The same stats model as the nVault ranks, stored in MySQL with threaded SQLx queries, so several servers share one ladder the website can read.
Daemon666
1.0.0 - Initial release.
| csb_rank_mysql.sma main | f3673b4 | 9.3 KB |
| csb_ranks.sql | 76176d6 | 0.9 KB |
README.md
CSB MySQL Ranks uses the same statistics model as the nVault rank plugin but stores everything in MySQL with fully threaded SQLx queries, so the game thread is never blocked. Stats are loaded with an async SELECT on authorise, written back with an async UPSERT on disconnect and at map end, and the player's ladder position is resolved with a COUNT(*) query against a stored score column. Several servers can share one ladder and the website can read the same table.
A clean-room GPL re-implementation inspired by MySQL rank systems such as PsychoStats; it ships its own tiny schema.
Features
- Threaded SQLx (SQL_MakeDbTuple / SQL_ThreadQuery) - no game-thread stalls
- Async UPSERT on disconnect and at map end
- Exact ladder position via a stored
scorecolumn andCOUNT(*) - Shared ladder across servers and readable by the website
- Ships
csb_ranks.sql; the table is also created automatically
Installation
- Put
csb_rank_mysql.amxxinaddons/amxmodx/plugins/ - Add it to
plugins.ini - Set the
csb_rank_*database cvars in an amxx config - Optionally import
csb_ranks.sql
Installation
1. Put csb_rank_mysql.amxx in addons/amxmodx/plugins/ 2. Add it to plugins.ini 3. Make sure the sqlx and hamsandwich modules are enabled 4. Set csb_rank_host/user/pass/db (e.g. in amxx.cfg or a server cfg) 5. The table is created automatically, or import csb_ranks.sql 6. Uses client_print_color, so AMX Mod X 1.9+ is required
CVARs
| CVAR | Default | Description |
|---|---|---|
csb_rank_host |
127.0.0.1 |
MySQL host. |
csb_rank_user |
csb |
MySQL user. |
csb_rank_pass |
|
MySQL password. |
csb_rank_db |
csb |
MySQL database name. |
Commands
| Command | Access | Description |
|---|---|---|
say /rank |
|
Show your stats, score and exact ladder position. |
say /stats |
|
Alias of /rank. |
Changelog — v1.0.0
1.0.0 - Initial release.Versions →
Rating
No ratings yet.
Download v1.0.0
Requirements
| AMX Mod X | ≥ 1.9 |
| Engine | ReHLDS HLDS |
| ReGameDLL | Not required |
| ReAPI | Not required |
| Metamod | Metamod / Metamod-r |
| Required modules | hamsandwich sqlx |
| Known conflicts | Run only one CSB rank plugin (nVault or MySQL), not both. |
Contributors
