View Single Post
2inspyr
SourceMod Donor
Join Date: Dec 2004
Old 05-08-2010 , 23:37   Re: [BETA]sql not working????
Reply With Quote #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 is offline