[Dragokas]

Since new update will out not soon, I suggest everybody manually update their database table type to InnoDB to make it more reliable and support transactions.

Example for phpMyAdmin interface:
https://www.dropbox.com/s/9jbk3beh9f...nnodb.png?dl=0

Alternative: example of query to database:

ALTER TABLE `l4d2_stats` ENGINE = InnoDB;

No more actions needed.

[zaviier]

Hi... this plugin is good, and work perfectly in my server.
but I want to ask about "Rank to other player" it's show nothing just my name...
or is that stats for player online in the same server?

[Dragokas]

Thanks.
That menu item is intended for currently online players only.

You can see offline player stats:

1) using web-site
2) using sm_hx_showpoints "steamid" command

[Dragokas]

Updated.

1.0.16 (10-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>

[ur5efj]

1.0.16

L 04/11/2020 - 11:21:42: SourceMod error session started
L 04/11/2020 - 11:21:42: Info (map "c1m1_hotel") (file "C:\SteamCMD\SteamApps\common\Left 4 Dead 2 Dedicated Server\left4dead2\addons\sourcemod\logs\errors_20200411.log")
L 04/11/2020 - 11:21:42: [SM] Exception reported: Client index 0 is invalid
L 04/11/2020 - 11:21:42: [SM] Blaming: l4d2_hx_stats.smx
L 04/11/2020 - 11:21:42: [SM] Call stack trace:
L 04/11/2020 - 11:21:42: [SM]   [0] GetClientUserId
L 04/11/2020 - 11:21:42: [SM]   [1] Line 1360, l4d2_hx_stats.sp::MakeBackup
L 04/11/2020 - 11:21:42: [SM]   [2] Line 763, l4d2_hx_stats.sp::SQL_OnUpdateTimeRequested
L 04/11/2020 - 11:21:42: [SM]   [3] Line 1437, l4d2_hx_stats.sp::SQL_Callback_RequestUpdateTime
L 04/11/2020 - 11:22:22: Error log file session closed.

L 04/11/2020 - 12:32:03: SourceMod error session started
L 04/11/2020 - 12:32:03: Info (map "l4d2_tank_arena") (file "C:\SteamCMD\SteamApps\common\Left 4 Dead 2 Dedicated Server\left4dead2\addons\sourcemod\logs\errors_20200411.log")
L 04/11/2020 - 12:32:03: [SM] Exception reported: Client index 0 is invalid
L 04/11/2020 - 12:32:03: [SM] Blaming: l4d2_hx_stats.smx
L 04/11/2020 - 12:32:03: [SM] Call stack trace:
L 04/11/2020 - 12:32:03: [SM]   [0] PrintToChat
L 04/11/2020 - 12:32:03: [SM]   [1] Line 2605, l4d2_hx_stats.sp::PrintPoints
L 04/11/2020 - 12:32:03: [SM]   [2] Line 1010, l4d2_hx_stats.sp::Event_TankKilled
L 04/11/2020 - 12:34:25: Error log file session closed.

[Dragokas]

Thanks.

Updated.

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.

[Dragokas]

Updated.

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.

[Dragokas]

Updated.

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.

Also, 1st post is supplied with "Natives usage sample", see "Natives" section.
E.g. you can use that to write your own module for this statistics, like custom award points and so.

[timonenluca]

this worked great! But there are a few problems.

the sm_hx_sqlcreate does not work! It does not create a table in my MYSQL Database.

It does however work if i download the old version off MAKS create a table using he's plugin and use the sm_hx_upgrade cvar afterwards.

last but not least

Could it be possible to not calculate into negative values under zero? so it stops at 0 as the lowest possible number. Right now my players go far into the negative range below 0 on expert and they can't recover from it.

[Dragokas]

Originally Posted by timonenluca this worked great! But there are a few problems. the sm_hx_sqlcreate does not work! It does not create a table in my MYSQL Database. It does however work if i download the old version off MAKS create a table using he's plugin and use the sm_hx_upgrade cvar afterwards.

Read installation instruction carefully. There are difference compairing to MAKS one.
You should not execute "sm_hx_sqlcreate". It is for emergency only. Table is created automatically.

It is strange that table does not created for you, maybe you didn't reload map after changing database connection info.

Originally Posted by timonenluca Could it be possible to not calculate into negative values under zero? so it stops at 0 as the lowest possible number. Right now my players go far into the negative range below 0 on expert and they can't recover from it.

Yes it is possible, but later.

Instead, maybe you just need decrease penalty points settings?
Also, "factor" ConVars decrease these values too.

Maybe it make sense to create different "factor" ConVars. One group for usual points and other group for penalty points...