MySql or .INI?

[jcsnider]

I am really thinking about trying again to add MySql into Eclipse. I want to see  Eclipse improve and I also want to take on the challenge.

So just a quick and general poll.
If MySql saving/loading was made for Eclipse would you use it?
Please post any thoughts and comments…

[Robin]

…what? You're using .ini to save data?

[jcsnider]

Last time I checked eclipse used .ini files and text files to store user data. I am thinking about removing all but the config inis and storing data to a mysql database…

[Adulese Games]

MySQL is by far one of the best ways to manage massive amounts of data that MMOs require. If you can get this to work with the engine and Sadscripting, it would make everything a bit easier to manage. However, Goddie's Main structure and ini set up is almost like an MySQL database in that everything is neat and organized. As long as it doesn't fuck anything up, I say go ahead and try.

- Adulese

[unknown]

I'm guessing this has probably been done before, but there's obviously no active project for it so yeah.. do it..

It'd be nice if you used some embeddable database library so the end user doesn't have to run some sql server somewhere. The best solution would be to have an option to run an embedded database (no setup required) or have it connect to a hosted database.

[jcsnider]

The only real type of database I have ever worked with has been MySql, so when you say a local database I think of like an Access Database…

I will work with the MySql first just because I am better with it, I do have extreme doubts on this but with the results from the poll so far I am going to give it my best shot.

[unknown]

Not an access database an **embedded** database

http://en.wikipedia.org/wiki/Embedded_database

[DFA]

mysql is useful for multiple servers

if everything is on 1 server, binary saving is win
buy some high-end memory for your server :)

[jcsnider]

Just a status report…

I have gotten an okay start on this today. I have almost finished with the saving and loading of the general account data such as
Login, Password, Email, and Verified....

Just a few more bugs I need to fix... Then I will move on to player data and then work on npcs, spells and such.

At this time my only concern is how much lag will this code generate... I will definately need to look into that but with a few more hours worth of work into this I think it may work quite well.

[Marsh]

Mysql is a great way to store data, though alot of the newcomers to Eclipse wouldnt be able to figure it out.

[Adulese Games]

And we can easily get our websites to work perfectly with the games, since PHP can use the said MySQL to retrieve info.

- Adulese

[Guest]

MYSQL all the way,
With is epic integration with PHP and smexy requirements i love it.

[Displaced]

MySQL
or
sqlite

[Robin]

Binary is faster, MySQL allows for queries and website integration.

[Tyr]

MySQL for sure, only I have no clue how to use it in vb6.0 … only in php :/

[Robin]

@Tyr:

> MySQL for sure, only I have no clue how to use it in vb6.0 … only in php :/

It's relatively simple. Can do a quick rip from Mirage 3.0.7 or vbGORE.

[jcsnider]

@Marsh:

> Mysql is a great way to store data, though alot of the newcomers to Eclipse wouldnt be able to figure it out.

I agree completely. I have added a option in Data.ini (Server Side) called INI, if 1 then use INIs and Dat files like normal, if 0 then use MySql which is default.
@Tyr:

> MySQL for sure, only I have no clue how to use it in vb6.0 … only in php :/

The hardest part for me that is, is just getting the correct DLLs and then getting the right connection string for that dll. After that it is really simple, just like php you make a query which I dim query as a string and then make query = your query, just like php
For example
```
query = "Insert into users (login,password,email) values ('" & (Trim$(Player(Index).Login)) & "','" & (Trim$(Player(Index).Password)) & "','" & (Trim$(Player(Index).Email)) & "')"
```
Then I just run the query by
cnmysql.execute (query)

Where cnmysql is my connection to the database.

The hard part is like I said is getting it set-up. After that everything is fine.

[demon xxx x]

I was thinking about MySQL for Eclipse.NET..

[jcsnider]

.Net with mysql is easier by a long shot then with vb6 you shouldn't have a problem with it, but if I get this vb6 version working correctly and you want me to give it a shot, i can in my free time.

Edit: I have gotten the whole general system working fine. This includes saving the Login, Password, and Email without problem.

[demon xxx x]

Congrats dude.  I'm working on the DirectX9 Module for Eclipse.NET atm xD I'll prob get on MySQL for it later tonight or tomorrow. (I'm alternating between working on different modules, so I don't get bored)

[jcsnider]

I understand completely but for me I have Call of Duty MW2 on my xbox so when i get tired I play a game of Search and Destroy then come back :p

BTW, I should be in school today but I am out due to weather so I will get ALOT done today at this rate so maybe an early beta tonight or early tomarrow (at this rate)

Edit:
I have everything I originally planned set-up and working…
This includes player-data, shops, spells, classes, npcs, and banks all working with a mysql database. (Banks is saved with player-data)

I am going to continue and add in elements, emotions and stuff like that...

However, the big thing now is testing... I would like to get 2 or 3 different people to test this for themselfs...

Anyone up to testing?

[DFA]

yeah when i tried vbgore and got to the mysql stuff, i was just like wow.
everything is so nicely organized and is easy to edit.

[Adulese Games]

MySQL is a great database system just cause I can run basically bulk commands and change a shit load of data at once. I love it simply for that. ;D

- Adulese

[jcsnider]

Auctually I have gotten everything I wanted out of this topic… I will go ahead and make a Eclipse Edit post or a project in development post somewhere.

[Alster]

Ima add a account viewer and widget generator (so you can get a nice box that says how many players your game has… etc) to the PHP Server Admin.