[Dragokas]

Description:

It's extended and improved version of HxStats: Coop statistics with MySQL database.

Basic differences & features:

* L4D1 support
* Integration with VIP Core by R1KO (optional).
* Multi-threaded database (not freeze server anymore)
* New stat points awards
* Stat of week / month / VIP of week / month
* Menu
* ConVars
* Useful commands
* Natives
* Translation
* Backup ability
* Many fixes

Dependency:

- (optional) VIP Core by R1KO

Compatibility:

- L4D1.
- L4D2.

- Coop only.
- Versus is planned - waiting for your comments here, what statistics points do you want to see...

Commands:

Spoiler

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

Settings (ConVars):

Spoiler

can be found in: cfg/sourcemod/l4d_hx_stats.cfg

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 & Usage sample:

Spoiler

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;
    }
} 


Using (Installation):

Spoiler

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:

"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:

$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:

$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.

Troubleshooting (mostly Linux)

Spoiler

Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
Solution: Try replacing server address "localhost" with "127.0.0.1"

Error: libz.so.1: cannot open shared object
Solution: install this package on server with root privileges: apt-get install lib32z1

Error: Access denied.
Solution: Give access to a database for user you specified in databases.cfg, e.g.:
GRANT ALL PRIVILEGES ON database_name.* TO 'user_name'@'%';
FLUSH PRIVILEGES;

Error: index.php displays raw code instead of table.
Solution: You'll have ot install PHP, e.g.: apt install php-common libapache2-mod-php php-cli

Error: index.php displays white page.
Solution: to diagnose error, you'll have to enable php loggin, e.g. edit your index.php by placing lines at the beginning of the script:

ini_set('display_errors', '1');
ini_set('display_startup_errors', '1');
error_reporting(E_ALL);

Error: index.php displays white page, and I'm receiving error: Class Class_mysqli not found
Solution: 1. You'll have to enable this extension in php.ini file by removing ; character:
extension=mysqli
2. You'll have to install this package: apt-get install php-mysqlnd
3. Reboot apach via: service restart apache2

Error: My server show index.html, how to force it to display index.php instead:
Solution: You may setup a redirection page, e.g. contents of index.html like so:

PHP Code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="refresh" content="0;url=./index.php">
    <title>Apache2 Debian Default Page: It works</title>
  </head>
</html> 


Credits:

* MAKS - original author

Related topics:

L4D2 HxStats

Languages:

- English
- Russian

ChangeLog

1.0.30 (15-Dec-2021)
- Added "l4d_hxstat_modes" ConVar - Turn on the plugin in these game modes, separate by commas (no spaces). (Empty = all).
- Some LogError() replaced by LogStackTrace() to be able track the rare case with incorrect SQL syntax error reported by Re:Creator.
- All common SQL callbacks are splitted to be able work with LogStackTrace(), since it is unfortunately 1-level deep only at the moment.
- All LogError() are screened with %s to be safe.
- Fixed some translation phrase names of error logger.
- New error logger system provides less performance, because of passing additional DataPack in SQL query. To disable it, set #define DEBUG_SQL to 0.
- Project is renamed into "DragoStats".
- Translation file is updated.

1.0.29 (05-Dec-2021)
- Fixed compilation warnings when compiled without vip_core.

1.0.28 (05-Dec-2021)
- Fixed compilation error.

1.0.27 (08-Jun-2021)
- Replaced favicon.ico
- Added reference to favicon in index.php file.

1.0.26 (25-Nov-2020)
- Removed unused debugging code.
- Some translation fixes.

1.0.25 (25-Nov-2020)
- Removed repeatable attempts to connect to MySQL database when initial connection failed, because this walkaround is useless (why it is useless and always fail?, - cannot fix connection during all 30 attempts every 3 sec., sm bug? I bet, my hoster doesn't switch off DB for whole 1,5 mins. There are no accidents in log file.)
- Added ability to display welcome (rank) message in chat / in center screen (by @weffer request):
* You can build very customized string on your own using constants from inc-file:
>> see hx_stats.phrases.txt file: phrases "Join_Rank_InChat" (for chat), "Join_Rank_InChatAll" (for all chat), "Join_Rank_InCenter" (for center screen).
>> see hx_stats.inc file: "AMOUNT_SOURCE_TYPE" enumeration.
* Added new ConVar "l4d_hxstat_rank_inchat" (default: 1) - Show rank in chat when player joined? (0 - No, 1 - Yes). See: 'Join_Rank_InChat' translation phrase.
* Added new ConVar "l4d_hxstat_rank_inchat_to_all" (default: 0) - Show rank in chat to all when some player joined? (0 - No, 1 - Yes). See: 'Join_Rank_InChatAll' translation phrase.
* Added new ConVar "l4d_hxstat_rank_incenter" (default: 0) - Show rank in the center screen when player joined? (0 - No, 1 - Yes). See: 'Join_Rank_InCenter' translation phrase
* Added new ConVar "l4d_hxstat_rank_inpanel" (default: 1) - Show rank in the panel when player joined? (0 - No, 1 - Yes)
* Added new ConVar "l4d_hxstat_rank_once" (default: 1) - Show rank (to himself) only once per player joined the server? (0 - No, 1 - Yes)
>> Note: to display any of above messages, ConVar "l4d_hxstat_rank_onstart" should be "1" !!!
- Added ConVar "l4d_hxstat_points_allow_negative". (default: 1). When set to "0" prevents points below zero (by @timonenluca request).
- Prevented calculation of penalty when player hurts himself (thanks to @Balloons for reporting).
- Player color functionality is removed from the core plugin (moved to a separate module/plugin).
- ConVar "l4d_hxstat_use_colors" is removed.
- inc file is updated:
* some arguments and enums are renamed to better clarify its purpose.
* new parameter value: "HX_COUNTING_ACTUAL". It is HX_COUNTING_START + HX_COUNTING_ROUND.
* added new Native for devs: "HX_IsClientRegistered" - Say whether client is registered and available for retrieving statistics points.
* added new Forward for devs: "HX_OnClientRegistered" - Called when the client is registered and become available for retrieving statistics points.
* added new source type: HX_PLACE_WEEK - to retrieve a player's place in the week statistics.
- l4d_native_usage_sample.sp (for devs) is updated.

1.0.24 (20-Nov-2020)
- Added compatibility with Versus (still, only survivor points are counted).
- Fixed false positive calculation of friendly-fire penalty points.

1.0.23 (19-Nov-2020)
- Added command !topweek
- Version history is moved from source code to a separate file "ChangeLog.txt".

1.0.22 (23-Sep-2020)
- Increased buffer size to prevent SQL syntax error during initial database creation.

1.0.21 (09-May-2020)
- Some safe checks added.

1.0.20 (20-Apr-2020)
- Added multiply factor for all points based on game difficulty. New ConVars:
* 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'
Note: penalty points are vice versa - they are devided by the values defined in above ConVars.

1.0.22 (23-Sep-2020)
- Increased buffer size to prevent SQL syntax error during initial database creation.

1.0.21 (09-May-2020)
- Some safe checks added.

1.0.20 (20-Apr-2020)
- Added multiply factor for all points based on game difficulty. New ConVars:
* 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'
Note: penalty points are vice versa - they are devided by the values defined in above ConVars.

1.0.19 (16-Apr-2020)
- VIP status is now not issued to players hidden by l4d_hxstat_hide_flag ConVar.
- Player rank is now displayed without counting hidden players.

1.0.18 (15-Apr-2020)
- Fixed table is created under incorrect name during first installation (bug in previous update).
- Prevented counting headshot points for common infected.

1.0.17 (12-Apr-2020)
- Added safe plugin unloading.
- Added ConVar "l4d_hxstat_enable" - Enable counting points? (0 - No, 1 - Yes).
- Fixed client index 0 errors.
- Code is optimized, events are now hooked if only they used according to ConVar settings. These also support dynamic hook / unhook.

1.0.16 (09-Apr-2020)
- Database engine is upgraded to InnoDB to support transactions (more safe queries).
- hx_stats.log is now contains only last week / last month top, so not to confuse you.
- Added "sm_hx_unhide" command - Unhides all admins statistics. Useful to populate data after changing l4d_hxstat_hide_flag ConVar since db is not update offline admins.
- Added new stat points (thanks to Re:Creator for request):

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

- Fixed chat messages are not coloring according to translation phrases color tags.
- Added "sm_rang" command, alias to "sm_rank".
- Some code simplification / optimization, "sm_hx_upgrade" is improved.

Web-site:
- Added ability to configure (in system/hx_config.php):

* 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.

- Web-site files for L4D1 and L4D2 are merged now. Defaulting to L4D2. For L4D1 you must setup "L4D2" parameter to 0 (in system/hx_config.php).
- Web-site is translated into Russian. Defaulted to English. To switch to Russian, setup "language" parameter to "ru" (in system/hx_config.php).

Upgrade details:
- DataBase Table version is now 2.4. Use "sm_hx_upgrade" to upgrade.
- Don't forget overwrite hx_stats.phrases.txt file!
- Don't forget overwrite web-site file "index.php" and also manually update "system/hx_config.php"!
- If you have L4D1, setup "L4D2" parameter to 0 (in system/hx_config.php).
- To update ConVar config file "cfg/sourcemod/l4d_hx_stats.cfg" you can:

* 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.

1.0.14
- fixed "l4d_hxstat_version" ConVar flag.
- added ability to create database backups automatically each week:

* 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)

- "sm_hx_backup" command is extended to hold 2 optional arguments: <0/1 - overwrite> <table_name>

1.0.13 (03-Feb-2020)
- most commands are now supported to be run from RCON.
- "sm_hx_logpoints" is automatically executed now before zeroing points for week / month.
- "sm_hx_backup", "sm_hx_revert", "sm_hx_movepoints", "sm_hx_delplayer", "sm_hx_delold" are returned now a message whether execution successfull.
- added translation of hints and return messages for all service commands.
- Database service user is now hidden upon installation (thanks to TheSolenOne for reporting).
- Added new ConVars group: l4d_hxstat_menu_best_* - to disable individual menu items "Best of week / month ..."

To update: don't forget overwrite hx_stats.phrases.txt file!

1.0.12 (02-Feb-2020)
- fixed "sm_hx_showpoints" and "sm_hx_movepoints" (was broken by v1.0.7 update).

1.0.11 (24-Jan-2020)
- inc file is corrected to prevent tag mismatch.
- enforced "utf-8" codepage for web-site (thanks to TheSolenOne for reporting).

To update: re-upload index.php file to your web-site.

1.0.10 (09-Jan-2020)
- Fixed error in log and disabled 'win' message for client with permanent VIP status (thanks to ur5efj for report).
- VIP_GROUP define is replaced by new "l4d_hxstat_vip_group" ConVar (for easy update).
- BASE_MENU define is replaced by new "l4d_hxstat_base_menu" ConVar (for easy update).

1.0.9 (03-Jan-2020)
- Potential fix: to prevent SQL query cache cause move week points twice (I hope).
- Disabled DB disconnection on round end.

1.0.8 (26-Dec-2019)
- Fixed chat messages are displayed even if points are disabled.

1.0.7 (24-Dec-2019)
- Fixed double-save points on player disconnect caused no points are saved at all (in L4D2).
- Fixed 'Witch' and 'Commons' points are not counted (in L4D2).
- 'Description of points' screen is splitted into 2 parts (for L4D2), because they doesn't fit in one.
- "Rank of other player" is now displayed in correct (requestor) language.
- Added command: "sm_hx_delplayer" <SteamId> - delete statistics of this player completely.
- Added command: "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)
- Added ability to disable some fields in statistics (you just need to set '0' points in ConVars where you want).
- Added ability to hide some players from statistics (requested by Re:Creator).
See "l4d_hxstat_hide_flag" ConVar. Offline players are not supported. They should join the server at least once to populate database.

* DataBase Table version is now 2.3. Use "sm_hx_upgrade" to upgrade.

* Web-site files (index.php) are updated!

1.0.6 (16-Dec-2019)
- Some SQL queries simplification
- Updated SQL queries to follow standard

1.0.5 (15-Dec-2019)
- Fixed hardcoded string not allowing to use "sm_hx_upgrade".

1.0.4 (14-Dec-2019)
- Added penalties:
* Survivor death
* Survivor Incap
* Friendly-fire

- Added ability to see "Rank of other player"

* DataBase Table version is now 2.2. Use "sm_hx_upgrade" to upgrade.

1.0.3 (01-Dec-2019)
- Added "sm_hx_showpoints" to view points of specific player by name / userid / steamid.
- Added "sm_hx_movepoints" to move points to another account (useful, if steam id is changed).
- "sm_topweek" renamed to "sm_hx_logpoints" and include top of last week and last month.
- Added auto-reconnect to database (max 20 attempts each 3 sec.) in case initial connection cannot be established for some reason.

1.0.2 (29-Nov-2019)
- Added integration with VIP Core by R1KO (added new ConVars).
- Finished functionality on shifting stats: week -> last week, month -> last month.
- Added ability to dump top of week to log, e.g. for your news site (sm_topweek).
- Added place of player.

- Added "HX_GetPoints" native.
- Added "sm_hx_upgrade" command to upgrade database table version.
- Added "sm_hx_backup" command to make a backup just in case.
- "sm_addsqlcreate" renamed to "sm_hx_sqlcreate" and now is not required while installation (leave just in case).

- All SQL queries are now Multi-threaded and no more spike the server.

- Statistics is now correctly re-loaded on plugin late load.
- Fixed: statistics is not saved when map is forcibly changed (by vote).
- User name escaping algorithm is replaced by SQL_EscapeString to be less false positive.
- Prevented counting game time points for !afk clients.
- Fixed "l4d_hxstat_points_time" ConVar is not worked.

* DataBase Table version is now 2.1. Use "sm_hx_upgrade" to upgrade.

1.0.1 (16-Nov-2019)
- Added L4D1 support

- added convars to choose min rank for blocking callvote and idle
- added convar to enable/disable coloring players by stat
- added convar to control min. interval allowed to call !top again
- Added convars for adjusting points of each type of killed infected, separately options for: 1. Killing 50 common, 2. Spent 30 minutes in game.
- Added convar for disabling printing the points in chat
- Added convars to choose whether you want to show player's rank on round start and delay

- Added !stat command to open main menu
- Added top of month / top of week (including previous month / week).
- Added menu with points description

- Added translation support
- Added translation into Russian

- Added library "hx_stats" registration
- Added native "HX_AddPoints" for developers

- client id replaced by UserId in timers
- Some code and SQL optimizations.
- Added protection and walkaround if Steam background is not responding
- !rank total score is now calculated more accurately
- Fixed empty name in database when new player connected
- Fixed bug when stats are not saved at all on player disconnect when none commons are killed

PHP update:
- Added L4d1 version of html/php scripts
- links are opened in the same window now

* DataBase Table version is now 2.0.

TODO:
- change column type from blob to name and find out why Russian letters recognized incorrectly in php using such type
- Read online admins from admins-simple.cfg / admins.cfg to populate "hide" option (for "sm_hx_unhide" command)

Donate

Donates are very appreciated and welcomed for further inspiration, make me happy, and make next updates came out more often:
- Patreon (Paypal)
- BitCoin
- Ю.Money

[Dragokas]

1.0.5 (15-Dec-2019) - Fixed hardcoded string not allowing to use "sm_hx_upgrade". 1.0.4 (14-Dec-2019) - Added penalties: * Survivor death * Survivor Incap * Friendly-fire - Added ability to see "Rank of other player" * DataBase Table version is now 2.2. Use "sm_hx_upgrade" to upgrade.

[tlch0324]

HI, I'm newbie how do I run it after setup a mysql server
Does it automatically create a database on the mysql server?

[ur5efj]

L 12/15/2019 - 19:49:52: SourceMod error session started
L 12/15/2019 - 19:49:52: Info (map "c2m3_coaster") (file "C:\SteamCMD\SteamApps\common\Left 4 Dead 2 Dedicated Server\left4dead2\addons\sourcemod\logs\errors_20191215.log")
L 12/15/2019 - 19:49:52: [l4d2_hx_stats.smx] Field 'Name' doesn't have a default value
L 12/15/2019 - 19:55:15: Error log file session closed.

[Dragokas]

Originally Posted by tlch0324 HI, I'm newbie how do I run it after setup a mysql server Does it automatically create a database on the mysql server?

You must have database name, user name and password.
Plugin automatically creates the table.

If, for some reason, it doesn't create one, use "sm_hx_sqlcreate" command.

[Dragokas]

ur5efj, does that error repeat for you?

[ur5efj]

This error on every map ( MySQL 5.7.28 )

L 12/15/2019 - 20:17:40: SourceMod error session started
L 12/15/2019 - 20:17:40: Info (map "c1m1_hotel") (file "C:\SteamCMD\SteamApps\common\Left 4 Dead 2 Dedicated Server\left4dead2\addons\sourcemod\logs\errors_20191215.log")
L 12/15/2019 - 20:17:40: [l4d2_hx_stats.smx] Field 'Name' doesn't have a default value
L 12/15/2019 - 20:20:48: Error log file session closed.
L 12/15/2019 - 20:20:56: SourceMod error session started
L 12/15/2019 - 20:20:56: Info (map "c1m2_streets") (file "C:\SteamCMD\SteamApps\common\Left 4 Dead 2 Dedicated Server\left4dead2\addons\sourcemod\logs\errors_20191215.log")
L 12/15/2019 - 20:20:56: [l4d2_hx_stats.smx] Field 'Name' doesn't have a default value
L 12/15/2019 - 20:28:35: Error log file session closed.
L 12/15/2019 - 20:28:43: SourceMod error session started
L 12/15/2019 - 20:28:43: Info (map "c1m3_mall") (file "C:\SteamCMD\SteamApps\common\Left 4 Dead 2 Dedicated Server\left4dead2\addons\sourcemod\logs\errors_20191215.log")
L 12/15/2019 - 20:28:43: [l4d2_hx_stats.smx] Field 'Name' doesn't have a default value
L 12/15/2019 - 20:32:55: Error log file session closed.
L 12/15/2019 - 20:33:03: SourceMod error session started
L 12/15/2019 - 20:33:03: Info (map "c1m4_atrium") (file "C:\SteamCMD\SteamApps\common\Left 4 Dead 2 Dedicated Server\left4dead2\addons\sourcemod\logs\errors_20191215.log")
L 12/15/2019 - 20:33:03: [l4d2_hx_stats.smx] Field 'Name' doesn't have a default value
L 12/15/2019 - 20:41:29: Error log file session closed.

[Dragokas]

Thank you.
Looks like, this happened because your MySQL strictly follow standards.
Try this one:

[tlch0324]

Originally Posted by Dragokas You must have database name, user name and password. Plugin automatically creates the table. If, for some reason, it doesn't create one, use "sm_hx_sqlcreate" command.

thanks, I input below in the database.cfg, is it correct?

"l4d2_stats"
{
"driver" "mysql"
"host" "127.0.0.1"
"database" "l4d2_stats"
"user" "root"
"pass" "mypass"
}

[Dragokas]

It is intended to work with external MySQL database only.
If 127.0.0.1 not work for you, try to set server's public IP there.
I'm not completely sure. Still learning sm database stuff. This is my first experience.

Also, are you sure "database" "l4d2_stats" schema is exist on your server?
If you don't know what is it, it's better to read some manuals. I don't think this topic is appropriate place for such discussion. It's better you open separate thread in General forum and leave here a link.