nomiscz / hlstatsx-community-edition Goto Github PK

View Code? Open in Web Editor NEW

80.0 20.0 41.0 56.71 MB

HLstatsX Community Edition - PHP 7 and GeoIP2 supported

License: GNU General Public License v2.0

SourcePawn 15.12% PHP 59.48% Perl 12.07% Shell 1.56% Python 0.28% CSS 2.74% JavaScript 2.97% HTML 0.12% Pawn 5.66%

hlstatsx-community-edition's People

Stargazers

Watchers

hlstatsx-community-edition's Issues

[TF2] No Latency Tracked, Wrong Action code for Buildings and Sappers

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)

hlstats-awards.pl Crontab

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

[Requisite] CS:GO MP5 Weapon Stats

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

Player Details Loding

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

Heatmaps - rewrite DB class to MySQLi (PHP >= 7.x)

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

CS:GO Player accuracy (hits, shots) not counted

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)

Screenshots

Environment
VS1 DE (Plesk Obsidian 18.0.21) - MySQL 5.7.28, Apache, Nginx (reverse proxy), PHP 7.3.x, Perl 5.22.1

Additional context

Error importing install.sql in database

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)

CS:GO superlogs entity -1 is invalid

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

CS:GO, 1v1 server

Additional context

Current active players number is higher than maxplayers

Hello,

I have a little problem on 3 CS Go Servers, the current active players number is higher than actual maxplayers !

As you can see :

Why is this happening ?

CS:GO Add missing knives - Operation Shattered Web

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

Describe alternatives you've considered

Additional context

Rank command radar problem

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.

Some of the old plugins still work

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

[REQUEST] smx files

Do you upload smx files to your archive?

Optimize Database

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

Webserver: apache 2.4+nginx 1.17
Hosting environment: VDS
PHP version: 7.3 x64
Browser: chrome 67 81.0.4044.92 x64

not working.

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.

Setup Doc.

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.

Exception reported: Entity -1 (-1) is invalid

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.

Adding teamspeak3 server problem

I added teamspeak3 server. Then the site is not entered.
https://stats.not2easy.pro/

Wrong error message (old)

hlstatsx-community-edition/scripts/hlstats.pl

Line 1621 in b002a79

 &printEvent("ERROR", "GeoIP method set to binary file lookup but Geo::IP::PurePerl module NOT FOUND", 1); 

Geo::IP::PurePerl->GeoIP2::Database::Reader

CS:GO plugin - missing clantag trigger (clans)

Add this: https://forums.alliedmods.net/showpost.php?p=2573907&postcount=6

[Requisite] weapon_m4a1_silencer Stats for CS:GO

weapon_m4a1_silencer does not show statistics on awards page and weapons page.

[Requisite] Awards Page

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.

[Setup] crontab

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?

MySQL Errors

Describe the bug
Some MySQL errors when running PHP 7.2 and MySQL 5.7

To Reproduce
Steps to reproduce the behavior:

Go to the stats page for a user and look at the error :P

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

Webserver: Apache w/ NGINX reverse proxy
Hosting environment: dedicated web box
PHP version: 7.2
Browser: latest chrome

Additional context
Add any other context about the problem here.

Team name before players in livestats

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

Large databases are slow at loading individual player stats

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:

Go to stats page.
Click on any player to view their stats.
Wait...
Wait...
Wait...
Finally.

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

Webserver: Apache/2.4.29 (Ubuntu)
Hosting environment: VPS
PHP version: PHP 5.6.40-8+ubuntu18.04.1+deb.sury.org+1 (cli)
Browser: Chrome Version 75.0.3770.142

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.

[Request] ScoreTable Rank

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

CS:GO Rewrite superlogs plugin

Remove csgo-items dependency
Add missing weapons
Rewrite/clean code
Rewrite Events

Ingame browser shows "Error 404" when using hlx_menu

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:

Type "hlx_menu" into chat
Select menu 5

Expected behavior
Ingame browser should open correct pages

Screenshots

Environment

Webserver: nginx
Hosting environment: dedicated server
PHP version: 7.2.17
Browser: ingame

Add API to Daemon / SM Plugins

Add API functions for others plugins.

            Native/Callback           Log/Rcon
Example Plugin <-----> HLStatsX Plugin <-----> Daemon

Missing "Last Connect" - CS:GO

GeoLite2 MaxMind database (GDPR and CCPA)

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/

HLSTATSX:CE SIMPLE ERROR

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

[TeamSpeak] Connection error

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

HLSTATSX: No data since 120 seconds

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!

Edit Player or Clan Details Error

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

AMXX - Fix color3 array index out of bounds

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

Fix: https://forums.alliedmods.net/showthread.php?t=313263

Question about logging

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

Clans page not working for CS 1.6 / TF2 / X (except for CS:GO)

I have HLStatsX working and tracking players but the Clans page is empty:
https://miez.ro/cstrike/HLstatsX/hlstats.php?mode=clans&game=cstrike

mysql_num_rows should be replaced by mysqli_num_rows

Describe the bug
mysql_num_rows should be replaced by mysqli_num_rows

To Reproduce
Steps to reproduce the behavior:

Go to search in this repo put mysql_num_rows and see files have mysql_num_rows
i was have errors in error.log of hlstats

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

Webserver: nginx 1.17
Hosting environment: vds
PHP version: 7.1

GeoIP2 - invalid IP

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.

LiteSpeed Support

Add litespeed server support? I want to set up a cyber panel. The cyber panel works as litespeed.

Clan Page Bug

"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

Hide Bots from Ranking but track bot kills

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.

Duplikující se text v chatu

Zdravím,

mám problém s duplikací textu. Používám plugin simple-chatprocessor.smx (custom-chatcolors-csgo.smx), který nejspíš může mít dopad na chat. Nicméně tato chyba se zobrazuje pouze u HLStatsX: CE. Jeden text se zobrazí bez barvy a druhý s barvou.

Díky za případný fix.

Database Error - incompatible with sql_mode=only_full_group_by

Describe the bug
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:

Go to 'hlstats.php?mode=playerinfo&player'
Click on 'weapons , Team & Action'
Scroll down to '....'
See error

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

Webserver: apache, nginx
Hosting environment: vps
PHP version: 7.0
Browser: Firefox

[Request] Ranks on Players Page

On the players page in the rank section, can you code players to show their real competitive ranks?

https://i.hizliresim.com/lqn0rX.png

Half-Life 1 (HLDM) support

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

Drop Geo::IP::PurePerl support

Rewrite hlstats-awards.pl to new GeoIP2
Remove old dependencies

Daemon reload GeoIP2 problem

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.

nomiscz / hlstatsx-community-edition Goto Github PK

hlstatsx-community-edition's People

Stargazers

Watchers

Forkers

hlstatsx-community-edition's Issues

Additional context

Describe alternatives you've considered

Additional context

Recommend Projects

Recommend Topics

Recommend Org