Login freezin bug in LOTF

08/30/2008 07:38 ~Yuki~#1
The bug ISNT in the source!
The bug IS in the MySQL system!
How to fix it ?
Get MySQL Gui toolz and Optimize the BUFFER Space and the Query Cache!
TA DAA!
FIXED
How the get the right Values to fix it ?
TRY IT!
Can i use my Current source WITHOUT ANY EDIT IN THE SOURCE?
YEEE!

Btw LOTF works nice with Accs / Chars /Guilds in MySQL and Rest in INI files^^
08/30/2008 17:29 plasma-hand#2
u sure this even works before i take the time to try it
08/30/2008 18:17 elragal_30#3
Quote:
Originally Posted by lolmaster123 View Post
The bug ISNT in the source!
The bug IS in the MySQL system!
How to fix it ?
Get MySQL Gui toolz and Optimize the BUFFER Space and the Query Cache!
TA DAA!
FIXED
How the get the right Values to fix it ?
TRY IT!
Can i use my Current source WITHOUT ANY EDIT IN THE SOURCE?
YEEE!

Btw LOTF works nice with Accs / Chars /Guilds in MySQL and Rest in INI files^^
is this can solve my problem
see it here :

[Only registered and activated users can see links. Click Here To Register...]

and i have to edit this on Php.ini file for my appserv ??
can u tell me what Variables i need to change ??
ty
08/31/2008 02:49 pegaeu#4
@lolmaster123
how i get it?

@elragal_30
wrong client
LOTF is CONQUER CLIENT patch 5017...
08/31/2008 08:14 ~Yuki~#5
google it or use this link :)
[Only registered and activated users can see links. Click Here To Register...]
09/01/2008 18:14 Tw3ak#6
Quote:
Originally Posted by lolmaster123 View Post
The bug ISNT in the source!
The bug IS in the MySQL system!
How to fix it ?
Get MySQL Gui toolz and Optimize the BUFFER Space and the Query Cache!
TA DAA!
FIXED
How the get the right Values to fix it ?
TRY IT!
Can i use my Current source WITHOUT ANY EDIT IN THE SOURCE?
YEEE!

Btw LOTF works nice with Accs / Chars /Guilds in MySQL and Rest in INI files^^

This may work i dunno but it's a ghettofabulous way to say it's fixed it is only a temp solution at best when the problem is in the db class itself,It is written horribly and incorrrectly to handle the loads of saves at high volumes of players.

I don't care if ya set the buffer and query cache to 9999999999 lol outcome at high volume of players will still result in same problems and dropped sql connections without rewriting the database class the right way to handle it,And even if ya do that server will still freeze up for other reasons that have nothing to do with sql at all.And what you didn't tell people is that messing with the buffer and cache and raising them too high will eat up all the resources on your box if your not careful.

There is no need to write anything to ini's or mess with the cache and buffer if sql is written right.
09/09/2008 00:27 Bottingpunk#7
hmm i downloaded the program its like mysql admin what should i do next XD i dont under stand that program taht much
09/09/2008 13:27 ~LightRuler~#8
appserver does have the problem to
09/09/2008 13:35 ~Yuki~#9
Quote:
Originally Posted by ~LightRuler~ View Post
appserver does have the problem to
And we see again how dumb u are-.-

Appserv = php5 + apache +MYSQL!
09/09/2008 15:15 glupkotrup#10
@lolmaster123 Lol you can't imagine how dumb he is :D
09/09/2008 16:13 ~Yuki~#11
He is a scammer ( he asked the MODs here how to add mobs to "HIS" source (Headsets one ))
09/09/2008 18:39 glupkotrup#12
Awwww... If I was him I would hire someone to kill me lol :D
09/09/2008 19:15 ~Yuki~#13
Wahahaha rofl^^
09/09/2008 21:34 glupkotrup#14
What's so funny? :confused: We are talking about death! :D
09/09/2008 21:37 ~Yuki~#15
i could help u .....BANG!
Np buddy^^