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
Kurulum
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
Cvarlar
| 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. |
Komutlar
| Command | Access | Description |
|---|---|---|
say /rank |
|
Show your stats, score and exact ladder position. |
say /stats |
|
Alias of /rank. |
Değişiklik günlüğü — v1.0.0
1.0.0 - Initial release.Sürümler →
Puan
No ratings yet.
Download v1.0.0
Gereksinimler
| AMX Mod X | ≥ 1.9 |
| Engine | ReHLDS HLDS |
| ReGameDLL | İsteğe bağlı |
| ReAPI | İsteğe bağlı |
| Metamod | Metamod / Metamod-r |
| Modüller | hamsandwich sqlx |
| Bilinen çakışmalar | Run only one CSB rank plugin (nVault or MySQL), not both. |
Katkıda bulunanlar
