Pushes end-of-map player stats to MySQL with one threaded multi-row INSERT for external ladder websites.
Daemon666
1.0.0 - Initial release.
| csb_stats_webexport.sma main | 7a68699 | 4.7 KB |
README.md
CSB Stats Web Export collects kills, deaths, headshots, damage and playtime per player and writes them to a MySQL table at map end. Everything goes out as a single multi-row INSERT ... ON DUPLICATE KEY UPDATE through a threaded SQLx query, so the game thread never blocks and the database sees one query per map. An external website can then render ladders straight from the table.
Features
- Threaded SQLx - zero main-thread blocking.
- One batched query per map, additive on conflict.
- Connection details set by cvar.
Installation
- Enable the
sqlxandhamsandwichmodules and configure the MySQL section inaddons/amxmodx/configs/sql.cfgor thecsb_sql_*cvars. - Create the
csb_webstatstable (schema in the source header). - Compile, install, add to
plugins.ini, change map.
Installation
1. Enable the sqlx and hamsandwich modules in addons/amxmodx/configs/modules.ini 2. Create the csb_webstats table (schema is documented in the source header) 3. Compile, install, add to plugins.ini, change map
Cvars
| CVAR | Default | Description |
|---|---|---|
csb_sql_host |
localhost |
MySQL host. |
csb_sql_user |
amxx |
MySQL user. |
csb_sql_pass |
|
MySQL password. |
csb_sql_db |
csb_stats |
MySQL database. |
Journal des modifications — v1.0.0
1.0.0 - Initial release.Versions →
Note
No ratings yet.
Download v1.0.0
Prérequis
| AMX Mod X | ≥ 1.9 |
| Engine | ReHLDS HLDS |
| ReGameDLL | Optionnel |
| ReAPI | Optionnel |
| Metamod | Metamod / Metamod-r |
| Modules | hamsandwich sqlx |
Contributeurs
