Root Admin commands:
- sm_hx_sqlcreate - Creates database table in case automatic mode is failed (warning: all data will be erased !!!)
- sm_hx_logpoints - Prints to log the list of top players of the last week and the last month
- sm_hx_upgrade - Updates database table to the latest version
- sm_hx_backup - <opt. 0/1 overwrite> <opt.table_name> Backups database table (by default, to `l4d2_stats_backup` table). Warning: old backup will be erased !!!
- sm_hx_revert - Revert a database from a backup. Warning: current database table will be lost !!!
- sm_hx_showpoints <#userid|name|steamid> - show points of specified player (including offline, if steamid provided)
- sm_hx_movepoints <steamid of source> <steamid of destination> - move points to another account (useful, if steam id is changed)
- sm_hx_delplayer <steamid> - delete statistics of this player completely
- sm_hx_delold <days> - delete players who didn't join for more than <days> ago (it is recommnded to use with `sm_hx_backup` first)
- sm_hx_unhide - Unhides all admins statistics. Useful to populate data after changing l4d_hxstat_hide_flag ConVar since db is not update offline admins

User commands:
- sm_stat - HX Statistics main menu
- sm_rank - show my rank and all my stats
- sm_rang - same as sm_rank
- sm_top - show top players of all the time
- sm_top10 - same as sm_top
- sm_topweek - show top players of the week

l4d_hxstat_enable - def.: 1 - Enable counting points? (0 - No, 1 - Yes)
l4d_hxstat_modes - def.: "" - Turn on the plugin in these game modes, separate by commas (no spaces). (Empty = all).

l4d_hxstat_callvote_rank - def.: 0 - Minimum rank to allow using the vote
l4d_hxstat_idle_rank - def.: 0 - Minimum rank to allow using !idle
l4d_hxstat_rank_call_interval - def.: 30 - Minimum interval (in sec.) to allow calling !top again
l4d_hxstat_print_points - def.: 1 - Print points in chat when you kill infected? (0 - No, 1 - Yes)

l4d_hxstat_rank_onstart - def.: 1 - Show rank on round start? (0 - No, 1 - Yes)
l4d_hxstat_rank_delay - def.: 6.0 - Delay (in sec.) on round start to show player's rank
l4d_hxstat_rank_inchat - def.: 1 - Show rank in chat when player joined? (0 - No, 1 - Yes). See: 'Join_Rank_InChat' translation phrase.
l4d_hxstat_rank_inchat_to_all - def.: 0 - Show rank in chat to all when some player joined? (0 - No, 1 - Yes). See: 'Join_Rank_InChatAll' translation phrase.
l4d_hxstat_rank_incenter - def.: 0 - Show rank in the center screen when player joined? (0 - No, 1 - Yes). See: 'Join_Rank_InCenter' translation phrase
l4d_hxstat_rank_inpanel - def.: 1 - Show rank in the panel when player joined? (0 - No, 1 - Yes)
l4d_hxstat_rank_once - def.: 1 - Show rank (to himself) only once per player joined the server? (0 - No, 1 - Yes)

l4d_hxstat_hide_flag - def.: "" - Users with these flag(s) will be hidden in statistics

l4d_hxstat_points_boomer - def.: 1 - How many points to give for killing the boomer
l4d_hxstat_points_charger - def.: 1 - How many points to give for killing the charger
l4d_hxstat_points_hunter - def.: 1 - How many points to give for killing the hunter
l4d_hxstat_points_jockey - def.: 1 - How many points to give for killing the jockey
l4d_hxstat_points_smoker - def.: 1 - How many points to give for killing the smoker
l4d_hxstat_points_spitter - def.: 1 - How many points to give for killing the spitter
l4d_hxstat_points_tank - def.: 5 - How many points to give for final tank shoot
l4d_hxstat_points_tank_solo - def.: 10 - How many points to give for final tank shoot
l4d_hxstat_points_witch - def.: 2 - How many points to give for killing the witch
l4d_hxstat_points_headshot - def.: 1 - How many additional points to give for headshot

l4d_hxstat_points_penalty_death - def.: -20 - How many points penalty for beeing killed by infected
l4d_hxstat_points_penalty_incap - def.: -5 - How many points penalty for beeing incapacitated
l4d_hxstat_points_penalty_ff - def.: 1 - How many points penalty for shooting teammate decreasing 10 hp
l4d_hxstat_points_allow_negative - def.: 1 - When set to "0" prevents points below zero

l4d_hxstat_commons_kill - def.: 50 - How many common zombies to kill to give points (for each piece)? (0 - to disable)
l4d_hxstat_points_infected - def.: 1 - How many points to give for killing X common zombies

l4d_hxstat_time_play - def.: 30 - How much time to play (in minutes) to give points (for each time interval)? (0 - to disable)
l4d_hxstat_points_time - def.: 10 - How many points to give for X minutes spent in game

l4d_hxstat_factor_easy - def.: 0.5 - All points are multiply by this value when game difficulty is 'Easy'
l4d_hxstat_factor_normal - def.: 1.0 - All points are multiply by this value when game difficulty is 'Normal'
l4d_hxstat_factor_hard - def.: 2.0 - All points are multiply by this value when game difficulty is 'Hard'
l4d_hxstat_factor_expert - def.: 4.0 - All points are multiply by this value when game difficulty is 'Impossible'

l4d_hxstat_menu_name - def.: "My Server name" - Name of statistics menu in !stat command
l4d_hxstat_vip_group - def.: "Black VIP" - VIP Group name (see file: data/vip/cfg/groups.ini)
l4d_hxstat_base_menu - def.: "sm_menu" - Command of 3d-party plugin to execute when you press 'Back' button in menu (leave empty, if none need)

l4d_hxstat_limit_top_all - def.: 15 - How many players to show in global top
l4d_hxstat_limit_top_week - def.: 15 - How many players to show in top of week
l4d_hxstat_limit_top_month - def.: 15 - How many players to show in top of month
l4d_hxstat_limit_top_week_vip - def.: 10 - How many players to award in top of week (and to show in top of last week)
l4d_hxstat_limit_top_month_vip - def.: 3 - How many players to award in top of month (and to show in top of last month)
l4d_hxstat_award_top_week_vip - def.: 7 - How many days of VIP to award player with (in winning top of week) (0 - to disable)
l4d_hxstat_award_top_month_vip - def.: 31 - How many days of VIP to award player with (in winning top of month) (0 - to disable)
l4d_hxstat_firstday - def.: 1 - First day of the week (0 - Sunday, 1 - Monday)

l4d_hxstat_menu_best_week - def.: 1 - Enable 'Best of week' menu item? (1 - Yes, 0 - No)
l4d_hxstat_menu_best_lweek - def.: 1 - Enable 'Best of last week' menu item? (1 - Yes, 0 - No)
l4d_hxstat_menu_best_month - def.: 1 - Enable 'Best of month' menu item? (1 - Yes, 0 - No)
l4d_hxstat_menu_best_lmonth - def.: 1 - Enable 'Best of last month' menu item? (1 - Yes, 0 - No)

l4d_hxstat_week_backup - def.: 0 - Enable full database backup every week? (1 - Yes, 0 - No)
l4d_hxstat_week_backup_rewrite - def.: 0 - Should week backup be overwritten? (1 - Yes, 0 - No: each time create new table with YYYY-MM-DD in name)

l4d_hxstat_table - def.: "l4d2_stats" - Preferred table name in database. It should be different for other server if you don't want to share points
l4d_hxstat_table_backup - def.: "l4d2_stats_backup" - Preferred table name in database for your backups

Natives:

HX_AddPoints - Give points to client.
HX_GetPoints - Retrieve a number of client points.
HX_IsClientRegistered - Say whether client is registered and available for retrieving statistics points.

Forwards:
HX_OnClientRegistered - Called when client is registered and become available for retrieving statistics points.

see hx_stats.inc file for details.

Usage sample:

PHP Code:

---

#pragma semicolon 1
#pragma newdecls required

#include <sourcemod>
#undef REQUIRE_PLUGIN
#include <hx_stats>

public Plugin myinfo = 
{
    name = "[L4D] HxStats Natives Demo",
    author = "Dragokas",
    description = "",
    version = "1.1",
    url = "https://forums.alliedmods.net/showthread.php?t=320247"
}

bool g_bHxStatsAvail;

/*
    README:
     * following plugin demonstrates simple examples:
      - how to retrieve the number of total points of specified target using console command "sm_getpoints"
      - how to add points to player statistics using console command "sm_addpoints"
      - how to print in chat the total number of tanks killed by every player when they joined, using "HX_OnClientRegistered" Forward.
*/

public void OnPluginStart()
{
    RegAdminCmd("sm_getpoints", CmdGetPoints, ADMFLAG_ROOT, "<target> Get points of specified player (or your own if none specified)");
    RegAdminCmd("sm_addpoints", CmdAddPoints, ADMFLAG_ROOT,    "<target> <points> Add points to specified player");
}

public Action CmdGetPoints(int client, int args)
{
    int target;
    
    if( args == 0 )
    {
        target = client;
    }
    else {
        char sArg[4];
        GetCmdArg(1, sArg, sizeof sArg);
        target = StringToInt(sArg);
    }

    if( g_bHxStatsAvail )
    {
        if( HX_IsClientRegistered(target) )
        {
            int points_total = HX_GetPoints(target, HX_COUNTING_ACTUAL, HX_POINTS);
            int points_round = HX_GetPoints(target, HX_COUNTING_ACTUAL, HX_POINTS);
            
            ReplyToCommand(client, "[%N] Total points: %i (round points: %i)", target, points_total, points_round);
        }
        else {
            ReplyToCommand(client, "[%N] Client: %i is not yet initialized by database. Please, wait...", target, target);
        }
    }
    else {
        ReplyToCommand(client, "HxStats is not available at the moment!");
    }
    
    return Plugin_Handled;
}

public Action CmdAddPoints(int client, int args)
{
    int target, points;
    
    if( args < 2 )
    {
        ReplyToCommand(client, "using: sm_addpoints <target> <points>");
        return Plugin_Handled;
    }
    
    char sArg[16];
    GetCmdArg(1, sArg, sizeof sArg);
    target = StringToInt(sArg);
    
    GetCmdArg(2, sArg, sizeof sArg);
    points = StringToInt(sArg);
    
    if( g_bHxStatsAvail )
    {
        if( HX_IsClientRegistered(target) )
        {
            HX_AddPoints(target, points);
            
            ReplyToCommand(client, "[%N] Added round points: %i", target, points);
        }
        else {
            ReplyToCommand(client, "[%N] Client: %i is not yet initialized by database. Please, wait...", target, target);
        }
    }
    else {
        ReplyToCommand(client, "HxStats is not available at the moment!");
    }
    
    return Plugin_Handled;
}

public void HX_OnClientRegistered(int client)
{
    if( client && IsClientInGame(client) && GetClientTeam(client) )
    {
        if( HX_IsClientRegistered(client) )
        {
            int tanks = HX_GetPoints(client, HX_COUNTING_ACTUAL, HX_TANK);
            
            PrintToChatAll("Player %N is just joined with number of tanks killed: %i", client, tanks);
        }
    }
}

public void OnAllPluginsLoaded()
{
    g_bHxStatsAvail = (GetFeatureStatus(FeatureType_Native, "HX_GetPoints") == FeatureStatus_Available);
}

public void OnLibraryAdded(const char[] name)
{
    if( strcmp(name, "hx_stats") == 0 )
    {
        g_bHxStatsAvail = true;
    }
}

public void OnLibraryRemoved(const char[] name)
{
    if( strcmp(name, "hx_stats") == 0 )
    {
        g_bHxStatsAvail = false;
    }
} 


---

1. If you are using VIP Core, set appropriate vip group name in l4d_hxstat_vip_group ConVar (cfg/sourcemod/l4d_hx_stats.cfg).
Note: you can find group name in file - data/vip/cfg/groups.ini.

2. If you have some basic menu on your server, set its command name (e.g. sm_menu) as a value in "l4d_hxstat_base_menu" ConVar.
It is required for "Back" menu button.

3. Compile the plugin (l4d2_hx_stats.sp), then:
- place l4d2_hx_stats.smx to addons/sourcemod/plugins
- place hx_stats.phrases.txt to addons/sourcemod/translations

If you already had HxStats ver. 1.0 by maks (or previous ver. of my fork) on the server:
- execute sm_hx_upgrade in console and restart the map.
otherwise:

4. Edit addons/sourcemod/configs/databases.cfg
by adding:

Code:

---

"l4d2_stats"
{
    "driver"              "mysql"
    "host"                "your_host"
    "database"            "your_db"
    "user"                "your_user"
    "pass"                "your_pass"
}

---

replace fields with information about your external MySQL connection. Contact to your hoster tech support for details.

5. Restart the map twice.

Basic installation finished.

If you need to see statistics on your site:
- go to Web-Site/l4d_stats_web folder, find .../system/hx_config.php and populate:

Code:

---

$aDB['server'] =        '127.0.0.1';                        // usually, it's ip or web-address of your database
$aDB['username'] =        'your_user';
$aDB['passwd'] =        'your_password';
$aDB['dbname'] =        'your_database_name';

---

with your MySQL connection info.

Update:

Code:

---

$aConf=array();
$aConf['title'] = 'Stats players:';                                        // title of web-site page
$aConf['description'] = '[L4D] hx_stats (Co-op)';
$aConf['keywords'] = '[L4D] hx_stats (Co-op)';
$aConf['limit'] = '50';                                                                // maximum number of players displayed in top
$aConf['L4D2'] = '1';                                                                // 0 - for L4D1, 1 - for L4D2
$aConf['language'] = 'en';                                                        // valid values are: "en" or "ru"

---

Upload folder to your site, and open index.php in browser.

* "Tank solo killed". New ConVar "l4d_hxstat_points_tank_solo". Default: 10.
* "Headshots" stat points. New ConVar "l4d_hxstat_points_headshot". Default: 1.

* Number of players displayed in top of site (see "limit" parameter).
* Table name, in case you need separate statistics for your several servers (see "table" parameter). In such case, ensure you also changed new ConVars "l4d_hxstat_table", "l4d_hxstat_table_backup".
* Added comments for better explanation for each option.
- Added ConVars:
* "l4d_hxstat_table" - Preferred table name in database. It should be different for other server if you don't want to share points.
* "l4d_hxstat_table_backup" - Preferred table name in database for your backups.

* use "Cvar Configs Updater": https://forums.alliedmods.net/showthread.php?t=188756
* or manually add new convars there
* or remove config file, change map, setup preferred ConVars again.

* ConVar "l4d_hxstat_week_backup" - def.: 0 - Enable full database backup every week? (1 - Yes, 0 - No)
* ConVar "l4d_hxstat_week_backup_rewrite" - def.: 0 - Should week backup be overwritten? (1 - Yes, 0 - No: each time create new table with YYYY-MM-DD in name)