[L4D1/2] HxStats Coop Remastered

[MYGO.pl]

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
* Many fixes

Dependency:

- (optional) VIP Core by R1KO

Compatibility:

- L4D1.
- L4D2 - untested. Should work ok.

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 - 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 - sm_hx_showpoints <#userid|name|steamid> - show points of specified player (including offline, if steamid provided)
- sm_hx_movepoints - sm_hx_movepoints <steamid of source> <steamid of destination> - move points to another account (useful, if steam id is changed)

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

Settings (ConVars):

Spoiler

l4d_hxstat_callvote_rank - Minimum rank to allow using the vote
l4d_hxstat_idle_rank - Minimum rank to allow using !idle
l4d_hxstat_use_colors - Change player's color according to his rank (0 - No, 1 - Yes)
l4d_hxstat_rank_call_interval - Minimum interval (in sec.) to allow calling !top again
l4d_hxstat_print_points - Print points in chat when you kill infected? (0 - No, 1 - Yes)
l4d_hxstat_rank_onstart - Show rank on round start? (0 - No, 1 - Yes)
l4d_hxstat_rank_delay - Delay (in sec.) on round start to show player's rank

l4d_hxstat_points_boomer - How many points to give for killing the boomer
l4d_hxstat_points_charger - How many points to give for killing the charger
l4d_hxstat_points_hunter - How many points to give for killing the hunter
l4d_hxstat_points_jockey - How many points to give for killing the jockey
l4d_hxstat_points_smoker - How many points to give for killing the smoker
l4d_hxstat_points_spitter - How many points to give for killing the spitter
l4d_hxstat_points_tank - How many points to give for final tank shoot
l4d_hxstat_points_witch - How many points to give for killing the witch

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

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

l4d_hxstat_menu_name - Name of statistics menu in !stat command

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

Natives:

Spoiler

HX_AddPoints - Give points to client.
HX_GetPoints - Retrieve a number of client points.

see hx_stats.inc file for details.

Using (Installation):

Spoiler

1. If you are using VIP Core, edit source code l4d2_hx_stats.sp:

Code:

---

#define VIP_GROUP "Black VIP"

---

Place here the name of your VIP group (note: you can find it in file - data/vip/cfg/groups.ini):

2. If you have some basic menu on your server, edit source code l4d2_hx_stats.sp:

Code:

---

#define BASE_MENU "sm_menu"

---

place here command to open that menu. It is required for "Back" 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/l4d1_stats_web (or l4d2_stats_web) folder depending on L4D1 or L4D2,
find .../system/hx_config.php and populate:

Code:

---

$aDB['server'] = 'localhost';
$aDB['username'] = 'your_user';
$aDB['passwd'] = 'your_pass';
$aDB['dbname'] = 'your_db';

---

with your MySQL connection info.

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

Credits:

* maks - original author

Related topics:

L4D2 HxStats

Languages:

- English
- Russian

ChangeLog

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.

Attached Files

hx_stats.zip (69.0 KB)

Wyświetl pełny artykuł