convert accounts and characters to ini

tanelipe you can close it i have it in inis now

look to CoZero`s DataBase.cs, is already made, with some bugs, at inventory , skills, prof and equips i think.

If your using LOTF;
Convert accounts and characters to INI.

Why?Well, the famous loginfreeze is fixed then. Since MySQL drops connection from time to time with LOTF source, you change the character and account info to INI, and leave the rest stuffs in MySQL.

Wont the other stuffs, e.g Monster,NPC,Spawns etc be damaged if my server looses the connection with MySQL?No,it wont. Why? Beacuse Monster,Spawns , NPCS , Items and all that only have to be loaded ONCE, and that is at the server start. So it wont be damaged.



Emme

Quote:

Originally Posted by EmmeTheCoder If your using LOTF; Convert accounts and characters to INI. Emme

or simply make a timer that resets the connection to MySQL...?

Connection.Close();
Connection.Open();

Well yes, but why cover up the problem when you can fix it? Lol

Quote:

Originally Posted by EmmeTheCoder Connection.Close(); Connection.Open(); Well yes, but why cover up the problem when you can fix it? Lol

INIs is not fixing it. Keeping the connection alive / reseting it (to stay alive) is fixing it.

But, I am sorry, I had this topic go off-topic by debating over MySQL and INIs/cover ups.

Quote:

Originally Posted by EmmeTheCoder Connection.Close(); Connection.Open(); Well yes, but why cover up the problem when you can fix it? Lol

ini's is for people that dunno how to do sql it isn't a fix it is basically jerryriggin it because you dunno how to fix it properly.

Quote:

Originally Posted by LetterX INIs is not fixing it. Keeping the connection alive / reseting it (to stay alive) is fixing it. But, I am sorry, I had this topic go off-topic by debating over MySQL and INIs/cover ups.

Mine never drops sql enless my internet drops momentarily lol because i have sql and server running on 2 different boxes not local and the sql is on a remote dedi box.

There isn't even a need to reset the connection if sql is done correctly the 1 connection will stay alive entire time server is up.

Quote:

Originally Posted by Tw3ak ini's is for people that dunno how to do sql it isn't a fix it is basically jerryriggin it because you dunno how to fix it properly. I don't like (My)SQL, So I use INI's I don't use it because I can't use it properly, hell I have Ulti and all of his servers have been MySQL based. :P Mine never drops sql enless my internet drops momentarily lol because i have sql and server running on 2 different boxes not local and the sql is on a remote dedi box. There isn't even a need to reset the connection if sql is done correctly the 1 connection will stay alive entire time server is up.

Epic.

#Closed - As requested.