CSB MySQL Ranks

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.

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 score column and COUNT(*)
• Shared ladder across servers and readable by the website
• Ships csb_ranks.sql; the table is also created automatically

Installation

1. Put csb_rank_mysql.amxx in addons/amxmodx/plugins/
2. Add it to plugins.ini
3. Set the csb_rank_* database cvars in an amxx config
4. Optionally import csb_ranks.sql

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

1.0.0 - Initial release.