convert accounts and characters to ini

[-Reflexis-]

tanelipe you can close it i have it in inis now

[alexbigfoot]

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

[_Emme_]

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

[LetterX]

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...?

[_Emme_]

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

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

[LetterX]

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.

[Tw3ak]

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.

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.

[InfamousNoone]

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.

[tanelipe]

#Closed - As requested.