[CS:GO / ?] Simple Stats MySQL

nhnkl159 · **Author**

SimpleStats

Web Leaderboard added (09-03-2017) :

Set max players to show at index.php line -> 4;

Edit your database info at -> 'core/db-config.php';

The leaderboard is ordered by kills (most kills = 1st).

Plugin :

This plugin tracks players info, play time and show everything in a menu.

Database :

SteamID (SteamID64)
Name
IP
Kills
Deaths
Shots
Hits
Headshots
Assists
SecondsOnServer
LastConn

This plugin support's only MySQL, so don't try to use it with SQLite.

Install :

If you want to use this plugin you must use MySQL add a database entry in addons/sourcemod/configs/databases.cfg, call it "simplestats".

Code:

"Databases"
{
	"simplestats"
	{
		"driver"         "mysql"
		"host"           "localhost"
		"database"       "simplestats"
		"user"           "root"
		"pass"           ""
	}
}

Copy the .smx file to your plugins (addons/sourcemod/plugins) folder
Restart your server.

Cvars :

Code:

// Sets whether or not to record stats
// -
// Default: "1"
sm_ss_enabled "1"

// Minimum players to start record stats
// -
// Default: "4"
sm_ss_minplayers "4"

// Record stats while we are in warmup ?
// -
// Default: "1"
sm_ss_warmup "1"

// Record knife as shot when client slash ?
// -
// Default: "1"
sm_ss_countknife "1"

// Enable the menu with top players?
// -
// Default: "1"
sm_ss_topenabled"1"

// Amount of people to display on sm_top
// -
// Default: "10"
sm_ss_toplimit "10"

Commands :

sm_ssreset <target> - Command for flag z to reset player stats.
sm_stats - Command for client to open menu with his stats.
sm_top - Command for client to open menu with top kills x players.

API For Developers :

Code:

/**
 * Retrieve the amount of kills.
 *
 * @param client					Client index.
 * @return                          Amount of kills.
 */
native int SS_GetKillsAmount(int client);

/**
 * Retrieve the amount of deaths.
 *
 * @param client					Client index.
 * @return                          Amount of deaths.
 */
native int SS_GetDeathsAmount(int client);

/**
 * Retrieve the amount of shots.
 *
 * @param client					Client index.
 * @return                          Amount of shots.
 */
native int SS_GetShotsAmount(int client);

/**
 * Retrieve the amount of hits.
 *
 * @param client					Client index.
 * @return                          Amount of hits.
 */
native int SS_GetHitsAmount(int client);

/**
 * Retrieve the amount of headshots.
 *
 * @param client					Client index.
 * @return                          Amount of headshots.
 */
native int SS_GetHeadshotsAmount(int client);

/**
 * Retrieve the amount of assists.
 *
 * @param client					Client index.
 * @return                          Amount of assists.
 */
native int SS_GetAssistsAmount(int client);

/**
 * Retrieve the total amount of seconds played on the server.
 *
 * @param client					Client index.
 * @return                          Amount of seconds played.
 */
native int SS_GetPlayTimeAmount(int client);

Credits :

Me - Creating the plugin.
shavitush - few functions

Download :