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