Remember the Score

[greenie]

Remember the Score by Nextra
( save frags save score save deaths remember the frags rememberthefrags rememberthescore rts )
.: Description
This plugin will keep track of players scores through a mysql (or optionally sqlite) database.
Everytime the user joins the server his score will be set to what is saved in the database (i.e. the score he has left the server with last time). It was made as per request.
.: Features
- Automatic saving on disconnect + configurable prevention saving to minimize loss of data after a crash
- Automatic pruning and per-map storing
- Uses threaded-querying
- Configuration of when and what to save
- API to allow for easy implementation into other plugins
.: Cvars
rts_host - DB Host
rts_user - DB User
rts_pass - DB Password
rts_db - DB
rts_table - DB Table
rts_type - DB Type (mysql or sqlite)
rts_auth - Track users by:
0 = steamid
1 = ip
2 = name
rts_max - Maximum of Score/Deaths to save (score saved in db will not go beyond this value)
rts_min - Score minimum to save (deaths minimum if rts_track = 2)
rts_prune - When to prune data (in days, 0 = disable)
rts_permap - Only save for one map. Table gets emptied completely on a new map. (Overrides rts_prune, rts_max and rts_min)
rts_track - What to track:
1 = track score
2 = track deaths
3 = track both
0 = plugin disabled
rts_save - The plugin saves on disconnect, additionally (prevents loss of data on crash) save on:
0 = never
1 = roundend
2 = every respawn (for deathmatch servers)
3 = every score update (may cause lots of traffic)
.: Required Modules
- CStrike
- FakeMeta
- Ham Sandwich
- MySQL / SQLite
.: Notes
#1 - I know that there is a plugin that essentially does the same but as I said this was a request, done due to the other one not working for the requester. I just wanted to share this in the hope it will be useful for others. For clearance why there are no credits: This was entirely done from scratch - no code was taken from any (esp. not rememberthefrags) plugins in the creation process.

#2 - I made the plugin rts_complement to showcase the API functions of RTS. It is made to be used as a reference and therefore only includes limited features, do not expect anything special from it.

#3 - This plugin did not go through much testing, unlike I usually prefer to do it with my stuff. This is because I currently do not need it myself. It is, however, working without errors for a few days on the requesters server (MySQL). SQLite has been only tested locally but everything should work fine. Please report any bugs you may encounter.
.: Changelog ( latest changes )
* 1.0.791
- Fixed not escaping strings for nickname saving.
* 1.0.800
- Fixed Auth problems.
- Added integrity checks and sync setting for SQLite, fixing problems that occured for some.
* 1.0.810
- Fixed typo.
- Changed errorlogging in startup routine to now use set_fail_and_fwd.

plugin
source