branch/main/README.md · CSB Stats Web Export

Daemon666 / csb-stats-webexport Public

Daemon666 4daeb72cc6 Initial release 1.0.0 12 months ago

1 lines 970 B Markdown Source Rendered Raw Permalink History

<p><strong>CSB Stats Web Export</strong> collects kills, deaths, headshots, damage and playtime per player and writes them to a MySQL table at map end. Everything goes out as a <strong>single multi-row INSERT ... ON DUPLICATE KEY UPDATE</strong> 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.</p><h2>Features</h2><ul><li>Threaded SQLx - zero main-thread blocking.</li><li>One batched query per map, additive on conflict.</li><li>Connection details set by cvar.</li></ul><h2>Installation</h2><ol><li>Enable the <code>sqlx</code> and <code>hamsandwich</code> modules and configure the MySQL section in <code>addons/amxmodx/configs/sql.cfg</code> or the <code>csb_sql_*</code> cvars.</li><li>Create the <code>csb_webstats</code> table (schema in the source header).</li><li>Compile, install, add to <code>plugins.ini</code>, change map.</li></ol>

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 sqlx and hamsandwich modules and configure the MySQL section in addons/amxmodx/configs/sql.cfg or the csb_sql_* cvars.
Create the csb_webstats table (schema in the source header).
Compile, install, add to plugins.ini, change map.