Thread
:
[BETA] SQL: Mysql Server has gone away. FIXED. ADDED: Psychostats Module 26/5/10
View Single Post
2inspyr
SourceMod Donor
Join Date: Dec 2004
05-08-2010 , 23:37 Re: [BETA]sql not working????
#
8
i have tried that with no luck, i made it open open the connection for every query, and mit lags the server out so bad that it couldnt even change maps. i guess i could go a step further and only connect if the connection is closed. Without a ping function i guess i would have to send a dummy query and check the returned result to see if the conneciton is alive. otherwise, i could write a set_task to send a dummy query every x seconds to keep the conneciton alive, and if its dead then reconnect, and i could easily write a cvar for the set_task time. i.e my webservers timeout is 20secs, your might be 60, i could make a cvar to add to the gungame.cfg so you can set it as needed.
__________________
hmmms........
2inspyr
View Public Profile
Send a private message to 2inspyr
Find More Posts by 2inspyr