[kloning1]

hello, meet me again

I want to question something
I have a storage system user ( y_ini )
I want to convert user to mysql

question, where do I start?
if I should first check the user in y_ini then convert to mysql or how?

BIG THANKYOU

[Sithis]

Quote:

Originally Posted by kloning1 if I should first check the user in y_ini then convert to mysql or how?

You should check which values are saved in the INI files (such as username, password, x, y, z, a, money, health, etc).

After you know what kind of data you are storing, you will need to create a database and tables with the same kind of structure in your mysql database (most likely you'll be using PHPMyAdmin).

If you have a lot of players/vehicles/whatever in your gamemode and as a result a lot of .ini files, I suggest writing a conversion script (loading the stuff from INI files and inserting them into mysql).

This is a complex operation and will most likely screw over your gamemode, but a move to mysql is worth it. Make sure to use the most recent version (R39+) and consider using ORM as well.

[Vince]

ORM is hardly ever useful in a properly normalized database because you will be joining two or more tables pretty much all the time.

[Sithis]

Quote:

Originally Posted by Vince ORM is hardly ever useful in a properly normalized database because you will be joining two or more tables pretty much all the time.

True. I do however use it a lot in my scripts based on C#. NHibernate is a real blessing.