Quote:
Originally Posted by Absolution  why dont you have someone code up a client mod that isn't detected by vac that issues console commands via a gui menu  |
Well, we could just disable VAC and make our own anti-cheat, but that'll never fly.
The server should be stable now, the serverdoc application was killing it at map change if it took longer than 25 seconds to change the map.
I'm about to throw on some code for the player database. Originally I used to use a "players.db" file to store all information about a player, such as their steamid, how many times they connected, their first name, their last name, the last IP address they used, and in CSS, their bank balance.
No more.
I started to toy with the MySQL again, I used to use MySQL with NSAdmin to load admins & donators, but these queries were done during map change, querying the MySQL server normally would cause the server to "lag".
So I toyed with threads, I've always been afraid of them, and I still am, but what I have now seems to work. It's going to be put on the server tonight for testing. Everything seems to work ok.
Basically, what happens is, someone connects to the server, it gets their steamid, and checks it against the MySQL server. If there is no result, it enters a new row for that player, and then requeries the server to obtain their playerid.
One problem is, sometimes the SQL client (being the srcds server) might lose connection, or the MySQL server is down at that exact time, so what I had to do was cache up any queries that are supposed to be done until the connection to the SQL server is back. For some reason it likes to time out in about 60 seconds, even when I set the options to a 3600 second timeout, so for now I just ping the server every 30 seconds, and if the connection gets dropped it reconnects if it can.
In the event that the SQL server is down for an extended period of time (say, a few hours), I'm not quite sure what to do yet in that case, but this should be fairly rare. Most likely the worst that'll happen is your bank balance and other features that rely on the MySQL server won't work.
I'm gonna be making a page that will show the total money in the economy, the number of players, and the average amount of money a player has in their bank account.
And it'll be live
