[+ARUKARI-]

I was thinking that.
This plugin does not work on Non-Steam servers.
Non-Steam is not supported on this forum.

[Canti87]

Sorry, I did not know.
So removing the dproto would avoid the blank spaces in the listing? not really used.

[+ARUKARI-]

Build a clean server with SteamCMD.
If that causes problems, please post again.

[Kelivart]

Hi +ARUKARI-, first of all, congratulations for the amazing work and keeping this update for the community for so many years.

Due the COVID-19 pandemic, me and my friends restarted playing CS 1.6. We have a server.

I'm trying to install your tool but I'm not safe in PHP and all that stuff. Excuse me for "newbie" questions.

My first question is if I can install your plugin on my rental CS 1.6 server and run the MySQL database on my personal host? They are completely different.

My second question is about the PHP and viewer part of the stats. When the plugin connect with MySQL DB, it automatically generante php files with the info stats?

Thank you for your time.

Greetings from Brazil

Kelivart

[+ARUKARI-]

@Kelivart
1.Yes, edit amxmodx/configs/sqlx.cfg and open mysql server port.
2.No, you first have to provide your own PHP to display the stats.
Download this from my GitHub and upload the csx_stats folder to your web server.
And then install twig template system using composer.

[Kelivart]

Thanks for your last answer, I advanced a little.

I'm with problems in 2 fronts now.

At the game console. Every time I log as admin, i got this:

L 05/22/2020 - 17:48:50: [admin.amxx] Login: "MyNick<1><STEAM_X:X:XXXXXX><>" became an admin (account "STEAM_X:X:XXXXXX") (access "abcdefghijklmnopqrstuvwy") (address "MYIP") L 05/22/2020 - 17:48:55: [AMXX] Plugin ("psd_104.amxx") is setting itself as failed. L 05/22/2020 - 17:48:55: [AMXX] Plugin says: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'myuserDBorDBNAME.user_info.online_time' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by L 05/22/2020 - 17:48:55: [AMXX] Run time error 1 (plugin "psd_104.amxx") - forced exit

I change the DB but I still getting that info from a old DB.

And in the PHP, front end I think, I'm getting this:

Fatal error: Uncaught Error: Class 'PDO' not found in /home3/myuser/public_html/statscs/includes/db/_db_h.inc:4 Stack trace: #0 /home3/myuser/public_html/statscs/includes/page_main.inc(3): require_once() #1 /home3/myuser/public_html/statscs/index.php(2): require_once('/home3/myuser/...') #2 {main} thrown in /home3/myuser/public_html/statscs/includes/db/_db_h.inc on line 4

Sorry to bother you, but any idea of why this is happening?

Thank you!

[+ARUKARI-]

1.Have you changed amx_sql_db somewhere?
2.Install php7.2 or above and php-pdo module.

[alferd]

https://github.com/AoiKagase/AMXMODX...ster/csx_stats

There is no such page, Please add another link

[+ARUKARI-]

UPDATE: v1.07

• Fixed: reset command not working.
• Fixed: ERROR: client_putinserver.
• Fixed: amx_psd_reset/amx_psd_update: not updating user table. (user name)
• Fixed: ERROR: for sql_mode=only_full_group_by.

[MetalMessiah]

Good evening,

It's necessary to change

register_plugin(PLUGIN, VERSION, AUTHOR);

for successfull compilation, otherwise invalid number of arguments error occures.

The problem

( 60) Load fails: Plugin uses an unknown function (name "geoip_code2_ex") - check your modules.ini.

solution is posted at some Spanish forum, GeoIP dudes changed the file format and amxmodx\data\GeoIP.dat is no more used, the GeoLite2-Country.mmdb should be placed there.

Few more points are not obvious for me:

how to use this plugin on multiple servers, i.e. where does it take server_id from? Hardcoding DEFAULT_SERVER_ID changes is not the right solution. Could it autodetect server ID from database, or take it from .cfg?

What is an average database size increment per week or month? Im afraid using datetime instead of 4-byte uint UNIX_TIMESTAMP(), storing auth_id as varchar(64) (I expect 32 is enough; unsigned int is also possible), many bigint's etc will raise it to gigabytes per year. Database search on such huge amount of data of variable row size will slow down the server.


P.S.
I've got

[AMXX] Plugin says: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ko','','','0')' at line 1

After investigation I found that it happens due to no escaping nicknames obtained in public insert_batch(), they are passed directly to insert_user_info_batch() causing SQL injection. Unfortunately, adding mysql_escape_string(sName, charsmax(sName)); somewhere after get_stats(i, ...) hangs the server during map change. Any ideas how to fix it? Maybe it was not hang but very long process (csstats.dat about 1Mb)

P.S.2 it looks like multiple mysql connections are created by this single plugin and some of them are not closed properly. I had max_user_connections multiple times.

P.A.3. on the level change between Reason: Dropping fakeclient on level change (last bot kicked) and
[PSD] Closing connection... there is about 10 seconds freeze in the main thread (console is not responding). csstats.dat is only 120 Kb. Players will drop because of this.