nomiscz / hlstatsx-community-edition Goto Github PK
View Code? Open in Web Editor NEWHLstatsX Community Edition - PHP 7 and GeoIP2 supported
License: GNU General Public License v2.0
HLstatsX Community Edition - PHP 7 and GeoIP2 supported
License: GNU General Public License v2.0
Is your feature request related to a problem? Please describe.
Add missing knives.
Describe the solution you'd like
https://www.counter-strike.net/shatteredweb
Do you upload smx files to your archive?
Is your feature request related to a problem? Please describe.
I would sugest creating a separate repository with the heatmaps for HLStatsX
Describe the solution you'd like
The heatmaps can be downloaded from here:
https://bitbucket.org/Maverick_of_UC/hlstatsx-community-edition/raw/0577b45e5f33df4e2a6122077fa44902073a8844/extras/HeatmapPack/heatmap-src_3.zip
They need also a fix for using mysqli. This is the error I get when I try to run php generate.php
PHP Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /home/games/cs-miez/tools/hlstatsx/hlxce/heatmaps/heatmap.class.php:582
Stack trace:
#0 /home/games/cs-miez/tools/hlstatsx/hlxce/heatmaps/heatmap.class.php(46): DB::connect()
#1 /home/games/cs-miez/tools/hlstatsx/hlxce/heatmaps/generate.php(10): Heatmap::init()
#2 {main}
thrown in /home/games/cs-miez/tools/hlstatsx/hlxce/heatmaps/heatmap.class.php on line 582
How can I see in-game these logs because now they get ignored everytime.
(IGNORED) OK Rcon from "192.168.1.137": "hlx_sm_psay "3" "HLstatsX:CE disabled! Need at least 2 active players (0/2)""
HLstatsX: CE Daemon Control
Sending Command to HLstatsX: CE Daemon at localhost:27500 — 50 bytes OK
Waiting for Backend Answer...recieving 0 bytes in 0 packets...OK
No packets received — check if backend dead or not listening on 127.0.0.1:27500
Closing connection to backend...OK
daemon control from admin panel does not work. does not show chat history. the number of instant players does not show on the homepage. and many features are not working with sourcemod update. retake autoplant add-on was corrupted. but then this plugin corrected the writer. with sourcemod update.
Describe the bug
A clear and concise description of what the bug is.
To Reproduce
Steps to reproduce the behavior:
Server Username: xxx_statshl
Error Diagnostic:
Bad query.
Server Error: (1055) Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'admin_hlstats.hlstats_Weapons.modifier' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Server Username: xxx_statshl
Error Diagnostic:
Bad query.
Server Error: (1055) Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'admin_hlstats.hlstats_Frags_as_res.killsTotal' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Environment
I have HLStatsX working and tracking players but the Clans page is empty:
https://miez.ro/cstrike/HLstatsX/hlstats.php?mode=clans&game=cstrike
Hi,
this is not a bug but I would appreciate any help in this regard. Klidně můžu pak psát česky? :-)
Hlstats work in the game using /rank
etc. but there is no data on the website: http://hlstats.csred.cz/hlstats.php
Log information keeps telling HLSTATSX: No data since 120 seconds. Everything is set up as stated in the official docs.
I would love to make this work even as a payment for a service.
Let me know.
HLstatsX Community Edition 1.6.19
Ubuntu 18.04
Apache + Nginx
PHP 7.2.24
Counter Strike 1.6 installed using Linux GSM https://linuxgsm.com/lgsm/csserver/.
I also tried reinstalling it for your version, did not help
Thank you!
Describe the bug
L 01/27/2020 - 16:01:43: SourceMod error session started
L 01/27/2020 - 16:01:43: Info (map "am_dust_challenge") (file "/root/csgo/csgo/addons/sourcemod/logs/errors_20200127.log")
L 01/27/2020 - 16:01:43: [SM] Exception reported: Entity -1 (-1) is invalid
L 01/27/2020 - 16:01:43: [SM] Blaming: superlogs-csgo.smx
L 01/27/2020 - 16:01:43: [SM] Call stack trace:
L 01/27/2020 - 16:01:43: [SM] [0] GetEntProp
L 01/27/2020 - 16:01:43: [SM] [1] Line 531, c:\Users\simon\OneDrive\SourceMod Pluginy\GIT\_hlstats_plugins\superlogs-csgo.sp::GetClientItemDefName
L 01/27/2020 - 16:01:43: [SM] [2] Line 226, c:\Users\simon\OneDrive\SourceMod Pluginy\GIT\_hlstats_plugins\superlogs-csgo.sp::Event_PlayerHurt
L 01/27/2020 - 16:01:43: [SM] Exception reported: Entity -1 (-1) is invalid
L 01/27/2020 - 16:01:43: [SM] Blaming: superlogs-csgo.smx
L 01/27/2020 - 16:01:43: [SM] Call stack trace:
L 01/27/2020 - 16:01:43: [SM] [0] GetEntProp
L 01/27/2020 - 16:01:43: [SM] [1] Line 531, c:\Users\simon\OneDrive\SourceMod Pluginy\GIT\_hlstats_plugins\superlogs-csgo.sp::GetClientItemDefName
L 01/27/2020 - 16:01:43: [SM] [2] Line 284, c:\Users\simon\OneDrive\SourceMod Pluginy\GIT\_hlstats_plugins\superlogs-csgo.sp::Event_PlayerDeath
L 01/27/2020 - 16:33:09: Error log file session closed.]
Environment
Additional context
To Reproduce
Steps to reproduce the behavior:
Tools
Optimize Database
Optimizing tables...
Fatal error: Uncaught Error: Call to undefined function mysql_num_rows() in C:\OSPanel\domains\css.setitagila.ru\hlxce\pages\admintasks\tools_optimize.php:93 Stack trace: #0 C:\OSPanel\domains\css.setitagila.ru\hlxce\pages\admin.php(1079): include() #1 C:\OSPanel\domains\css.setitagila.ru\hlxce\hlstats.php(224): include('C:\OSPanel\doma...') #2 {main} thrown in C:\OSPanel\domains\css.setitagila.ru\hlxce\pages\admintasks\tools_optimize.php on line 93
Environment
Hi there,
Could you please add support for Half-Life 1? I did try all the plugins and none of them works on it.
It would be very nice, HLDM still have a good amount of players, further than TFC or DoD (you can check links below).
So, it would be nice for HL servers owners to have such an opportunity to use this!
Thanks in advance, Cheker
Half-Life Steam charts
Day of defeat Steam charts
Team Fortress Classic Steam charts
Hello,
I am still using the Counter Strike 1.6 plugin hlstatsx_commands_cstrike.amxx on my server and it works. Could you add it back ?
Thank you
Describe the bug
When use "hlx_menu" in game and choose options that should open a stats page in ingame browser like "Server Status", "Statsme", "Weapon Usage", "Weapons Accuracy" etc. Ingame browser opens a non existing page (404 Not Found)
To Reproduce
Steps to reproduce the behavior:
Expected behavior
Ingame browser should open correct pages
Environment
Add litespeed server support? I want to set up a cyber panel. The cyber panel works as litespeed.
Can you add an MP5 weapon for CS:GO?
Awards and weapons should also be added to the pages. First you can add it without pictures. We do the tests.
Sample MP5 Picture: https://i.hizliresim.com/y6bd99.png
Describe the bug
mysql_num_rows should be replaced by mysqli_num_rows
To Reproduce
Steps to reproduce the behavior:
2020/01/30 13:50:45 [error] 9509#9509: *350 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught Error: Call to undefined function mysql_num_rows() in /pages/dailyawardinfo.php:145
Stack trace:
#0 /hlstats.php(224): include()
#1 {main}
thrown in /pages/dailyawardinfo.php on line 145" while reading upstream, client: 54.36.149.25, server: hlstats.example.com, request: "GET /hlstats.php?mode=dailyawardinfo&award=972&game=l4d2&page=15 HTTP/2.0", upstream: "fastcgi://unix:/run/php/php7.1-fpm.sock:", host: "hlstats.example.com"
Environment
Does not save statistics to the Awards page.
https://stats.not2easy.pro/hlstats.php?mode=awards&game=csgo#
There is no data as you can see from the link.
On the players page in the rank section, can you code players to show their real competitive ranks?
https://i.hizliresim.com/lqn0rX.png
Describe the bug
Whenever you click on an individual player's stats page, it is extremely slow at loading, taking 11-18 seconds (at worst being 20 or more seconds), with a database with over 50k people in it. It also makes my server's CPU go at 100% for that same amount of time. This was never like this, only when it started collecting stats for alot of people.
To Reproduce
Steps to reproduce the behavior:
Expected behavior
I expect it to load a little faster than 20 seconds and for it to not overload my CPU, I don't know if this is something that can be fixed but it's too much for my server's CPU and the wait time is ridiculously long.
Environment
Additional context
I would link my statistics page but I'm just not comfortable with it maxing out my CPU every time someone views a person's statistics page. This has been an ongoing issue since the original devs of HLStats and I don't know if they ever had a medium to large community before but this has happened to me twice so far in the time of me using this. It's especially bad because someone can easily DoS me just by loading the web page which is dangerous. Also, it's important to note that it was really fast at the start when it didn't have that many players logged, but as the database grew that's when it started really slowing down.
I added teamspeak3 server. Then the site is not entered.
https://stats.not2easy.pro/
Describe the bug
Starting December 30, 2019, we will be requiring users of our GeoLite2 databases to register for a MaxMind account and obtain a license key in order to download GeoLite2 databases.
GeoIP database is no longer available without API key, so install_binary
script is "broken".
To Reproduce
Run ~/_hlstatsx_daemon/GeoLiteCity/install_binary.sh
Expected behavior
Download update GeoIP2 data.
Environment
Linux
Additional context
https://blog.maxmind.com/2019/12/18/significant-changes-to-accessing-and-using-geolite2-databases/
2019-03-02 13:36:59: - MYSQL: Connecting to MySQL database 'hlstatsx' on 'localhost' as user 'root' ... connected ok
2019-03-02 13:36:59: - CONFIG: Reading database config...
2019-03-02 13:36:59: - CONFIG: I have found the following server configs in database:
2019-03-02 13:36:59: - S_CONFIG: xx.xxx.xxx.xxx:27016
2019-03-02 13:37:00: - HLSTATSX: HLstatsX:CE 1.6.19 starting...
2019-03-02 13:37:00: - UDP: Opening UDP listen socket on port 27500 ... ok
2019-03-02 13:37:00: - HLSTATSX: Tracking Trend of the stats are enabled
2019-03-02 13:37:00: - HLSTATSX: Maximum Skill Change on all servers are 25 points
2019-03-02 13:37:00: - HLSTATSX: Minimum Skill Change on all servers are 2 points
2019-03-02 13:37:00: - HLSTATSX: Minimum Players Kills on all servers are 50 kills
2019-03-02 13:37:00: - HLSTATSX: Players chat logging is enabled
2019-03-02 13:37:00: - HLSTATSX: Broadcasting public chat is disabled
2019-03-02 13:37:00: - HLSTATSX: Event queue size is set to 10
2019-03-02 13:37:00: - HLSTATSX: HLstatsX:CE is now running (Normal mode, debug level 1)
2019-03-02 13:37:32: xx.xxx.xxx.xxx:27016 - SERVER: Connecting to rcon on xx.xxx.xxx.xxx:27016 ... ok
2019-03-02 13:37:32: xx.xxx.xxx.xxx:27016 - TRCON: Trying to get rcon access (auth)
2019-03-02 13:37:32: xx.xxx.xxx.xxx:27016 - TRCON: Trying to get rcon access (auth)
2019-03-02 13:37:37: xx.xxx.xxx.xxx:27016 - SERVER: Server running map: /1224991873/$2000$
The IP address you provided (xx.xxx.xxx.xxx:27016) is not a valid IPv4 or IPv6 address at /usr/local/share/perl/5.18.2/MaxMind/DB/Reader/Role/Reader.pm line 39.
Describe the bug
Player accuracy (hits, shots) is not counted - superlogs-csgo bug.
Expected behavior
Headshots per Kill: X.XXXX (X.XXXX*)
Shots per Kill: XX
Weapon Accuracy: X.X% (X%)
Kills per Minute: X.XX
Kills per Death: X.XXXX (X.XX)
Environment
VS1 DE (Plesk Obsidian 18.0.21) - MySQL 5.7.28, Apache, Nginx (reverse proxy), PHP 7.3.x, Perl 5.22.1
crontab -e
*/5 * * * * cd /var/www/vhosts/not2easy.pro/hlstatsxyeniscripts/scripts/ && ./run_hlstats start >/dev/null 2>&1
15 00 * * * cd /var/www/vhosts/not2easy.pro/hlstatsxyeniscripts/scripts/ && ./hlstats-awards.pl >/dev/null 2>&1
I can't set this crontab. If I don't do this, will the plugin not work?
Daemon Control - after reload:
Can't use an undefined value as a symbol reference at ./hlstats.pl line 1611.
Thanks to EnterxSandman for reporting the bug.
Fatal error: Uncaught Error: Using $this when not in object context in C:\xampp\htdocs\hlx\pages\admintasks\tools_editdetails.php:66 Stack trace: #0 C:\xampp\htdocs\hlx\pages\admin.php(1079): include() #1 C:\xampp\htdocs\hlx\hlstats.php(222): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\hlx\pages\admintasks\tools_editdetails.php on line 66
When the rank is written, the menu does not appear completely. The top of the menu does not appear due to radar.
With sm_rank command, you can print simple statistics for chatting.
Rank score, playing time ...
Send some information to the chat message.
In the file pages/livestats.php the table should be edited so that the team name (Terrorist, Counter Terrorist) should be displayed before the players.
Currently it is displayed at the end
Zdravím,
tak mám další report.
L 12/23/2019 - 17:25:38: [SM] Blaming: superlogs-csgo.smx
L 12/23/2019 - 17:25:38: [SM] Call stack trace:
L 12/23/2019 - 17:25:38: [SM] [0] GetEntProp
L 12/23/2019 - 17:25:38: [SM] [1] Line 529, c:\Users\simon\OneDrive\SourceMod Pluginy\Work -N- KaizenPlay_hlstats_plugins\superlogs-csgo.sp::GetClientItemDefName
L 12/23/2019 - 17:25:38: [SM] [2] Line 286, c:\Users\simon\OneDrive\SourceMod Pluginy\Work -N- KaizenPlay_hlstats_plugins\superlogs-csgo.sp::Event_PlayerDeath
L 12/23/2019 - 17:28:46: [SM] Exception reported: Entity -1 (-1) is invalid
L 12/23/2019 - 17:28:46: [SM] Blaming: superlogs-csgo.smx
L 12/23/2019 - 17:28:46: [SM] Call stack trace:
L 12/23/2019 - 17:28:46: [SM] [0] GetEntProp
L 12/23/2019 - 17:28:46: [SM] [1] Line 529, c:\Users\simon\OneDrive\SourceMod Pluginy\Work -N- KaizenPlay_hlstats_plugins\superlogs-csgo.sp::GetClientItemDefName
L 12/23/2019 - 17:28:46: [SM] [2] Line 286, c:\Users\simon\OneDrive\SourceMod Pluginy\Work -N- KaizenPlay_hlstats_plugins\superlogs-csgo.sp::Event_PlayerDeath
L 12/23/2019 - 17:28:46: [SM] [4] ForcePlayerSuicide
L 12/23/2019 - 17:28:46: [SM] [5] Line 2365, /home/forums/content/files/3/2/0/9/1/170330.attach::MoveAFKClient
L 12/23/2019 - 17:28:46: [SM] [6] Line 2204, /home/forums/content/files/3/2/0/9/1/170330.attach::Timer_CheckPlayer
Díky za případný fix.
Compile error:
hlstatsx_commands_cstrike.sma(865) : error 032: array index out of bounds (variable "color3")
hlstatsx_commands_cstrike.sma(926) : error 032: array index out of bounds (variable "color3")
Hello,
I wantet to use HLstatsX for my Human vs Bot server but the bot are always added on the webpage and are ranked too. Is there a way to track kills but hide them from ranking and also hide the in game massages for bots if they kill a player.
"Clans with only 1 or more members from a total of 21 clans" writes the article. But the clan shows only 10 clans on the page.
Link: https://stats.not2easy.pro/hlstats.php?mode=clans&game=csgo&minmembers=1
Add API functions for others plugins.
Native/Callback Log/Rcon
Example Plugin <-----> HLStatsX Plugin <-----> Daemon
when i try to se Player Details on my webpage its just Loading... noting show up ?
Mysql 5.7.30-0ubuntu0.16.04.1 - (Ubuntu)
Apache2 Web server
Import successfully completed, completed 119 requests.
Notice in ./vendor/phpmyadmin/sql-parser/src/Components/OptionsArray.php#217
Trying to get property 'expr' of non-object
Backtrace
./vendor/phpmyadmin/sql-parser/src/Components/CreateDefinition.php#251: PhpMyAdmin\SqlParser\Components\OptionsArray::parse(
,
,
array,
)
./vendor/phpmyadmin/sql-parser/src/Statements/CreateStatement.php#432: PhpMyAdmin\SqlParser\Components\CreateDefinition::parse(
,
,
)
./vendor/phpmyadmin/sql-parser/src/Statement.php#90: PhpMyAdmin\SqlParser\Statements\CreateStatement->parse(
,
,
)
./vendor/phpmyadmin/sql-parser/src/Parser.php#500: PhpMyAdmin\SqlParser\Statement->__construct(
,
,
)
./vendor/phpmyadmin/sql-parser/src/Parser.php#376: PhpMyAdmin\SqlParser\Parser->parse()
./libraries/classes/Tracker.php#655: PhpMyAdmin\SqlParser\Parser->__construct(string '-- -- Table structure for table `hlstats_Players` -- CREATE TABLE IF NOT EXISTS `hlstats_Players` ( `playerId` int(10) unsigned NOT NULL auto_increment, `last_event` int(11) NOT NULL default \'0\', `connection_time` int(11) unsigned NOT NULL default \'0\', `lastName` varchar(64) NOT NULL default \'\', `lastAddress` varchar(32) NOT NULL default \'\', `city` varchar(64) NOT NULL default \'\', `state` varchar(64) NOT NULL default \'\', `country` varchar(64) NOT NULL default \'\', `flag` varchar(16) NOT NULL default \'\', `lat` FLOAT(7,4) NULL, `lng` FLOAT(7,4) NULL, `clan` int(10) unsigned NOT NULL default \'0\', `kills` int(11) unsigned NOT NULL default \'0\', `deaths` int(11) unsigned NOT NULL default \'0\', `suicides` int(11) unsigned NOT NULL default \'0\', `skill` int(11) unsigned NOT NULL default \'1000\', `shots` int(11) unsigned NOT NULL default \'0\', `hits` int(11) unsigned NOT NULL default \'0\', `teamkills` int(11) unsigned NOT NULL default \'0\', `fullName` varchar(128) default NULL, `email` varchar(64) default NULL, `homepage` varchar(64) default NULL, `icq` int(10) unsigned default NULL, `mmrank` tinyint(4) DEFAULT NULL, `game` varchar(32) NOT NULL, `hideranking` int(1) unsigned NOT NULL default \'0\', `headshots` int(10) unsigned NOT NULL default \'0\', `last_skill_change` int(11) NOT NULL default \'0\', `displayEvents` int(1) unsigned NOT NULL default \'1\', `kill_streak` int(6) NOT NULL default \'0\', `death_streak` int(6) NOT NULL default \'0\', `blockavatar` int(1) unsigned NOT NULL default \'0\', `activity` int(11) NOT NULL default \'100\', `createdate` int(11) NOT NULL default\'0\', PRIMARY KEY (`playerId`), KEY `playerclan` (`clan`,`playerId`), KEY `skill` (`skill`), KEY `game` (`game`), KEY `kills` (`kills`), KEY `hideranking` (`hideranking`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ')
./libraries/classes/Tracker.php#807: PhpMyAdmin\Tracker::parseQuery(string '-- -- Table structure for table `hlstats_Players` -- CREATE TABLE IF NOT EXISTS `hlstats_Players` ( `playerId` int(10) unsigned NOT NULL auto_increment, `last_event` int(11) NOT NULL default \'0\', `connection_time` int(11) unsigned NOT NULL default \'0\', `lastName` varchar(64) NOT NULL default \'\', `lastAddress` varchar(32) NOT NULL default \'\', `city` varchar(64) NOT NULL default \'\', `state` varchar(64) NOT NULL default \'\', `country` varchar(64) NOT NULL default \'\', `flag` varchar(16) NOT NULL default \'\', `lat` FLOAT(7,4) NULL, `lng` FLOAT(7,4) NULL, `clan` int(10) unsigned NOT NULL default \'0\', `kills` int(11) unsigned NOT NULL default \'0\', `deaths` int(11) unsigned NOT NULL default \'0\', `suicides` int(11) unsigned NOT NULL default \'0\', `skill` int(11) unsigned NOT NULL default \'1000\', `shots` int(11) unsigned NOT NULL default \'0\', `hits` int(11) unsigned NOT NULL default \'0\', `teamkills` int(11) unsigned NOT NULL default \'0\', `fullName` varchar(128) default NULL, `email` varchar(64) default NULL, `homepage` varchar(64) default NULL, `icq` int(10) unsigned default NULL, `mmrank` tinyint(4) DEFAULT NULL, `game` varchar(32) NOT NULL, `hideranking` int(1) unsigned NOT NULL default \'0\', `headshots` int(10) unsigned NOT NULL default \'0\', `last_skill_change` int(11) NOT NULL default \'0\', `displayEvents` int(1) unsigned NOT NULL default \'1\', `kill_streak` int(6) NOT NULL default \'0\', `death_streak` int(6) NOT NULL default \'0\', `blockavatar` int(1) unsigned NOT NULL default \'0\', `activity` int(11) NOT NULL default \'100\', `createdate` int(11) NOT NULL default\'0\', PRIMARY KEY (`playerId`), KEY `playerclan` (`clan`,`playerId`), KEY `skill` (`skill`), KEY `game` (`game`), KEY `kills` (`kills`), KEY `hideranking` (`hideranking`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ')
./libraries/classes/DatabaseInterface.php#350: PhpMyAdmin\Tracker::handleQuery(string '-- -- Table structure for table `hlstats_Players` -- CREATE TABLE IF NOT EXISTS `hlstats_Players` ( `playerId` int(10) unsigned NOT NULL auto_increment, `last_event` int(11) NOT NULL default \'0\', `connection_time` int(11) unsigned NOT NULL default \'0\', `lastName` varchar(64) NOT NULL default \'\', `lastAddress` varchar(32) NOT NULL default \'\', `city` varchar(64) NOT NULL default \'\', `state` varchar(64) NOT NULL default \'\', `country` varchar(64) NOT NULL default \'\', `flag` varchar(16) NOT NULL default \'\', `lat` FLOAT(7,4) NULL, `lng` FLOAT(7,4) NULL, `clan` int(10) unsigned NOT NULL default \'0\', `kills` int(11) unsigned NOT NULL default \'0\', `deaths` int(11) unsigned NOT NULL default \'0\', `suicides` int(11) unsigned NOT NULL default \'0\', `skill` int(11) unsigned NOT NULL default \'1000\', `shots` int(11) unsigned NOT NULL default \'0\', `hits` int(11) unsigned NOT NULL default \'0\', `teamkills` int(11) unsigned NOT NULL default \'0\', `fullName` varchar(128) default NULL, `email` varchar(64) default NULL, `homepage` varchar(64) default NULL, `icq` int(10) unsigned default NULL, `mmrank` tinyint(4) DEFAULT NULL, `game` varchar(32) NOT NULL, `hideranking` int(1) unsigned NOT NULL default \'0\', `headshots` int(10) unsigned NOT NULL default \'0\', `last_skill_change` int(11) NOT NULL default \'0\', `displayEvents` int(1) unsigned NOT NULL default \'1\', `kill_streak` int(6) NOT NULL default \'0\', `death_streak` int(6) NOT NULL default \'0\', `blockavatar` int(1) unsigned NOT NULL default \'0\', `activity` int(11) NOT NULL default \'100\', `createdate` int(11) NOT NULL default\'0\', PRIMARY KEY (`playerId`), KEY `playerclan` (`clan`,`playerId`), KEY `skill` (`skill`), KEY `game` (`game`), KEY `kills` (`kills`), KEY `hideranking` (`hideranking`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ')
./libraries/classes/Import.php#96: PhpMyAdmin\DatabaseInterface->tryQuery(string '-- -- Table structure for table `hlstats_Players` -- CREATE TABLE IF NOT EXISTS `hlstats_Players` ( `playerId` int(10) unsigned NOT NULL auto_increment, `last_event` int(11) NOT NULL default \'0\', `connection_time` int(11) unsigned NOT NULL default \'0\', `lastName` varchar(64) NOT NULL default \'\', `lastAddress` varchar(32) NOT NULL default \'\', `city` varchar(64) NOT NULL default \'\', `state` varchar(64) NOT NULL default \'\', `country` varchar(64) NOT NULL default \'\', `flag` varchar(16) NOT NULL default \'\', `lat` FLOAT(7,4) NULL, `lng` FLOAT(7,4) NULL, `clan` int(10) unsigned NOT NULL default \'0\', `kills` int(11) unsigned NOT NULL default \'0\', `deaths` int(11) unsigned NOT NULL default \'0\', `suicides` int(11) unsigned NOT NULL default \'0\', `skill` int(11) unsigned NOT NULL default \'1000\', `shots` int(11) unsigned NOT NULL default \'0\', `hits` int(11) unsigned NOT NULL default \'0\', `teamkills` int(11) unsigned NOT NULL default \'0\', `fullName` varchar(128) default NULL, `email` varchar(64) default NULL, `homepage` varchar(64) default NULL, `icq` int(10) unsigned default NULL, `mmrank` tinyint(4) DEFAULT NULL, `game` varchar(32) NOT NULL, `hideranking` int(1) unsigned NOT NULL default \'0\', `headshots` int(10) unsigned NOT NULL default \'0\', `last_skill_change` int(11) NOT NULL default \'0\', `displayEvents` int(1) unsigned NOT NULL default \'1\', `kill_streak` int(6) NOT NULL default \'0\', `death_streak` int(6) NOT NULL default \'0\', `blockavatar` int(1) unsigned NOT NULL default \'0\', `activity` int(11) NOT NULL default \'100\', `createdate` int(11) NOT NULL default\'0\', PRIMARY KEY (`playerId`), KEY `playerclan` (`clan`,`playerId`), KEY `skill` (`skill`), KEY `game` (`game`), KEY `kills` (`kills`), KEY `hideranking` (`hideranking`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8')
./libraries/classes/Import.php#256: PhpMyAdmin\Import::executeQuery(
string '-- -- Table structure for table `hlstats_Players` -- CREATE TABLE IF NOT EXISTS `hlstats_Players` ( `playerId` int(10) unsigned NOT NULL auto_increment, `last_event` int(11) NOT NULL default \'0\', `connection_time` int(11) unsigned NOT NULL default \'0\', `lastName` varchar(64) NOT NULL default \'\', `lastAddress` varchar(32) NOT NULL default \'\', `city` varchar(64) NOT NULL default \'\', `state` varchar(64) NOT NULL default \'\', `country` varchar(64) NOT NULL default \'\', `flag` varchar(16) NOT NULL default \'\', `lat` FLOAT(7,4) NULL, `lng` FLOAT(7,4) NULL, `clan` int(10) unsigned NOT NULL default \'0\', `kills` int(11) unsigned NOT NULL default \'0\', `deaths` int(11) unsigned NOT NULL default \'0\', `suicides` int(11) unsigned NOT NULL default \'0\', `skill` int(11) unsigned NOT NULL default \'1000\', `shots` int(11) unsigned NOT NULL default \'0\', `hits` int(11) unsigned NOT NULL default \'0\', `teamkills` int(11) unsigned NOT NULL default \'0\', `fullName` varchar(128) default NULL, `email` varchar(64) default NULL, `homepage` varchar(64) default NULL, `icq` int(10) unsigned default NULL, `mmrank` tinyint(4) DEFAULT NULL, `game` varchar(32) NOT NULL, `hideranking` int(1) unsigned NOT NULL default \'0\', `headshots` int(10) unsigned NOT NULL default \'0\', `last_skill_change` int(11) NOT NULL default \'0\', `displayEvents` int(1) unsigned NOT NULL default \'1\', `kill_streak` int(6) NOT NULL default \'0\', `death_streak` int(6) NOT NULL default \'0\', `blockavatar` int(1) unsigned NOT NULL default \'0\', `activity` int(11) NOT NULL default \'100\', `createdate` int(11) NOT NULL default\'0\', PRIMARY KEY (`playerId`), KEY `playerclan` (`clan`,`playerId`), KEY `skill` (`skill`), KEY `game` (`game`), KEY `kills` (`kills`), KEY `hideranking` (`hideranking`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8',
string '-- -- Table structure for table `hlstats_Players` -- CREATE TABLE IF NOT EXISTS `hlstats_Players` ( `playerId` int(10) unsigned NOT NULL auto_increment, `last_event` int(11) NOT NULL default \'0\', `connection_time` int(11) unsigned NOT NULL default \'0\', `lastName` varchar(64) NOT NULL default \'\', `lastAddress` varchar(32) NOT NULL default \'\', `city` varchar(64) NOT NULL default \'\', `state` varchar(64) NOT NULL default \'\', `country` varchar(64) NOT NULL default \'\', `flag` varchar(16) NOT NULL default \'\', `lat` FLOAT(7,4) NULL, `lng` FLOAT(7,4) NULL, `clan` int(10) unsigned NOT NULL default \'0\', `kills` int(11) unsigned NOT NULL default \'0\', `deaths` int(11) unsigned NOT NULL default \'0\', `suicides` int(11) unsigned NOT NULL default \'0\', `skill` int(11) unsigned NOT NULL default \'1000\', `shots` int(11) unsigned NOT NULL default \'0\', `hits` int(11) unsigned NOT NULL default \'0\', `teamkills` int(11) unsigned NOT NULL default \'0\', `fullName` varchar(128) default NULL, `email` varchar(64) default NULL, `homepage` varchar(64) default NULL, `icq` int(10) unsigned default NULL, `mmrank` tinyint(4) DEFAULT NULL, `game` varchar(32) NOT NULL, `hideranking` int(1) unsigned NOT NULL default \'0\', `headshots` int(10) unsigned NOT NULL default \'0\', `last_skill_change` int(11) NOT NULL default \'0\', `displayEvents` int(1) unsigned NOT NULL default \'1\', `kill_streak` int(6) NOT NULL default \'0\', `death_streak` int(6) NOT NULL default \'0\', `blockavatar` int(1) unsigned NOT NULL default \'0\', `activity` int(11) NOT NULL default \'100\', `createdate` int(11) NOT NULL default\'0\', PRIMARY KEY (`playerId`), KEY `playerclan` (`clan`,`playerId`), KEY `skill` (`skill`), KEY `game` (`game`), KEY `kills` (`kills`), KEY `hideranking` (`hideranking`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8',
array,
)
./libraries/classes/Plugins/Import/ImportSql.php#158: PhpMyAdmin\Import::runQuery(
string '-- -------------------------------------------------------- -- -- Table structure for table `hlstats_Players_Awards` -- CREATE TABLE IF NOT EXISTS `hlstats_Players_Awards` ( `awardTime` date NOT NULL, `awardId` int(11) unsigned NOT NULL default \'0\', `playerId` int(11) unsigned NOT NULL default \'0\', `count` int(11) unsigned NOT NULL default \'0\', `game` varchar(32) NOT NULL, PRIMARY KEY (`awardTime`,`awardId`,`playerId`,`game`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8',
string '-- -------------------------------------------------------- -- -- Table structure for table `hlstats_Players_Awards` -- CREATE TABLE IF NOT EXISTS `hlstats_Players_Awards` ( `awardTime` date NOT NULL, `awardId` int(11) unsigned NOT NULL default \'0\', `playerId` int(11) unsigned NOT NULL default \'0\', `count` int(11) unsigned NOT NULL default \'0\', `game` varchar(32) NOT NULL, PRIMARY KEY (`awardTime`,`awardId`,`playerId`,`game`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8',
array,
)
./import.php#554: PhpMyAdmin\Plugins\Import\ImportSql->doImport(array)
/var/www/vhosts/not2easy.pro/hlstatsxyeniscripts/scripts/hlstats-awards.pl
15 00 * * * cd /var/www/vhosts/not2easy.pro/hlstatsxyeniscripts/scripts/ && ./hlstats-awards.pl >/dev/null 2>&1
Can't locate .//ConfigReaderSimple.pm in @inc (@inc contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /var/www/vhosts/not2easy.pro/hlstatsxyeniscripts/scripts/hlstats-awards.pl line 61.
csgo-items plugin does not show rank in the score table. this add-on shows the rank in the score table with the gameme. Do you add rank in the score table using hlstatsx points?
https://github.com/hallucinogenic/MatchMaking-Ranks-By-Points
-09-30 09:50:01: - MYSQL: Connecting to MySQL database 'csgreekg_hlxce' on 'localhost' as user 'csgreekg_hlx' ... connected ok
2019-09-30 09:50:01: - CONFIG: Reading database config...
2019-09-30 09:50:01: - CONFIG: I have found the following server configs in database:
2019-09-30 09:50:01: - S_CONFIG: 176.57.188.35:27021
2019-09-30 09:50:01: - HLSTATSX: HLstatsX:CE 1.6.19 starting...
2019-09-30 09:50:01: - UDP: Opening UDP listen socket on web1.evovps.com:27500 ... ok
2019-09-30 09:50:01: - HLSTATSX: Tracking Trend of the stats are enabled
2019-09-30 09:50:01: - HLSTATSX: Maximum Skill Change on all servers are 15 points
2019-09-30 09:50:01: - HLSTATSX: Minimum Skill Change on all servers are 2 points
2019-09-30 09:50:01: - HLSTATSX: Minimum Players Kills on all servers are 20 kills
2019-09-30 09:50:01: - HLSTATSX: Broadcasting public chat is disabled
2019-09-30 09:50:01: - HLSTATSX: Event queue size is set to 10
2019-09-30 09:50:01: - HLSTATSX: HLstatsX:CE is now running (NameTrack mode, debug level 1)
2019-09-30 09:51:59: - HLSTATSX: No data since 120 seconds
2019-09-30 09:54:00: - HLSTATSX: No data since 120 seconds
2019-09-30 09:55:04: - HLSTATSX: Insert new server trend timestamp
2019-09-30 09:56:00: - HLSTATSX: No data since 120 seconds
2019-09-30 09:58:00: - HLSTATSX: No data since 120 seconds
2019-09-30 10:00:00: - HLSTATSX: No data since 120 seconds
2019-09-30 10:00:08: - HLSTATSX: Insert new server trend timestamp
2019-09-30 10:02:07: - HLSTATSX: No data since 120 seconds
2019-09-30 10:03:05: - PROXY, Reload request from 151.80.109.234:56119:
2019-09-30 10:03:07: - CONTROL: Command received: RELOAD
2019-09-30 10:03:07: 151.80.109.234:56119 - CONTROL: Sent 29 bytes to frontend at '151.80.109.234:56119'
2019-09-30 10:03:07: 151.80.109.234:56119 - CONTROL: Re-Reading Configuration by request from Frontend...
2019-09-30 10:03:07: 151.80.109.234:56119 - CONFIG: Reading database config...
2019-09-30 10:03:07: 151.80.109.234:56119 - CONFIG: I have found the following server configs in database:
2019-09-30 10:03:07: 151.80.109.234:56119 - S_CONFIG: 176.57.188.35:27021
Can't use an undefined value as a symbol reference at ./hlstats.pl line 1715.
Hello,
I have default ports on my TeamSpeak3 server. I can connect using this IP:
109.230.238.232:9987, but if I add it to hlstats I get an error. Thanks for help :-)
weapon_m4a1_silencer does not show statistics on awards page and weapons page.
Latency:
I've noticed that the avarage Ping of players does not get tracked. For CSGO it works fine. Superlogs for TF2 is also installed.
Buildings:
The Triggers for building and disassembling Buildings are wrong. Instead of "buildobject", the trigger is "player_buildobject" also for sapper (except minisentry is still "buildobject"). Trigger for disassembling is triggered as "detonated_object" and not "owner_killedobject". This also causes another bug. The engineer that disassembles their Building also triggeres "killedobject" and thus gains points even though he should loose them.
Server OS for TF2 Server: Debian 8 (VPS)
Server OS for Daemon: Debian 8 (VPS)
Webserver: Ngnix (VPS)
hlstatsx-community-edition/scripts/hlstats.pl
Line 1621 in b002a79
Geo::IP::PurePerl->GeoIP2::Database::Reader
Describe the bug
Some MySQL errors when running PHP 7.2 and MySQL 5.7
To Reproduce
Steps to reproduce the behavior:
Error Diagnostic:
Bad query.
Server Error: (1055) Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hlstats.hlstats_Weapons.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Last SQL Query:
SELECT
hlstats_Events_Frags.weapon,
hlstats_Weapons.name,
COUNT(hlstats_Events_Frags.weapon) AS kills,
SUM(hlstats_Events_Frags.headshot=1) as headshots
FROM
hlstats_Events_Frags
LEFT JOIN
hlstats_Weapons
ON
hlstats_Weapons.code = hlstats_Events_Frags.weapon
WHERE
hlstats_Events_Frags.killerId=1
GROUP BY
hlstats_Events_Frags.weapon
ORDER BY
kills desc, headshots desc
LIMIT
1
Expected behavior
There not to be a big ole errror
Screenshots
https://i.imgur.com/pEKTLy9.png
Environment
Additional context
Add any other context about the problem here.
Can you publish installation guide?
Most people are having problems about it. https://bitbucket.org/Maverick_of_UC/hlstatsx-community-edition/wiki/Install
I think this guide is not useful.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.