PDA

View Full Version : MySQL storage for credits



TF2274
Apr 30, 2011, 11:06 AM
It would be really nice if there could be the capability of storing the credits in a MySQL database instead of in the .cdb file. This is for a few reasons. One reason is so I can make a neat player lookup program for my website, and another is ever since the recent source update, it has been where the .cdb file never gets saved on server crash. Basically sourceOP is keeping track of the points, but not saving them to the database file. This is fine because players can rejoin and still have all of their credits... until the server crashes or is shut down.

A fix for this is really needed !

Drunken F00l
Apr 30, 2011, 06:10 PM
Credits will be saved on map change or proper server shutdown. The last Source update did not change this.

TF2274
May 01, 2011, 10:39 PM
Ok, here is the deal.

I use admin_map command to change the map...

My credits stick.

Then AFTER using the admin_map command I crash the server.

Now if what you are saying is correct then upon proper shutdown or map change the credits will be saved. Well I am now telling you that you are wrong because first theres the map change I perform which is supposed to save the credits, but then theres a crash which causes the credits to be reset. At the same time there's another server. I know the owner. Now when I play in that server its on the Co-Op maps, and Ive played on that server through full maps so the map finishes, and the server goes to the next map in the cycle. Supposedly my credits should be saved. Well... wrong because after playing a while I disconnect and take a break. Then later I might go on (by the time I go back onto the server it will most likely have had a crash that it recovered from) and there my credits are reset again.

Now I think it is very limited for us to need to use the .cdb file especially considering SourceOP now neglects to properly save user credit stats due to one of Valves shitty updates (the recent one of which has caused an unusual amount of damage to their source engine). My SQL is a lot more reliable anyways.

Drunken F00l
May 02, 2011, 12:07 AM
It should definitely save assuming you don't have two servers using the same credit database.

Maybe check to see if SourceOPErrors.log exists and has any more info.

TF2274
May 04, 2011, 09:29 PM
Well unless its the "Found no steamclient.dll inside of HL2 process" error that repeatedly shows up in the error log then IDK. This server is a standalone server which does not require Steam client anyways, and I dont think that should even be an issue. Also I am not the only person with this problem. I have a friend with his own coop server and he has the same issue.

Drunken F00l
May 05, 2011, 12:01 AM
Please turn on logging (console: log on) and check the log files for entries like:
[SOURCEOP] "Console<0><Console><Console>" due to load errors, credits are not saving

Or:
[SOURCEOP] "Console<0><Console><Console>" failed to save credits

If you see:
[SOURCEOP] "Console<0><Console><Console>" saved "##" credit entries

Then it has properly saved and I cannot explain what you are seeing.

DataStorm
May 05, 2011, 12:05 AM
Well unless its the "Found no steamclient.dll inside of HL2 process" error that repeatedly shows up in the error log then IDK. This server is a standalone server which does not require Steam client anyways, and I dont think that should even be an issue. Also I am not the only person with this problem. I have a friend with his own coop server and he has the same issue.

That error pops up if you have steam running while the server starts. Exit steam, start server and look again to lose that error. (at least my experience)

TF2274
May 13, 2011, 07:15 PM
This server Im using is the stand alone installation. Steam isn't even installed on the server computer that runs the SourceOP plugin.


Once again, I'm still having that issue with the credits.

Drunken F00l
May 13, 2011, 08:48 PM
Once again, I'm still having that issue with the credits.

Could you check the server logs like I mentioned earlier? I think that will solve all questions.