[paprikon]

I am also preparing a old school CS 1.6 tournament.

I decided to go the SQL route. Even though the web-side is abandoned to say the least, I've managed to update the PHP files to reflect changes from PHP5.6 to PHP7.4. There are no errors on the website, it can successfully show the contents of the MySQL database. However, there is one slight issue: the plugin itself doesn't work with MySQL properly it seems.

I currently have it connect to a database that I have on the same machine (Debian 11). Even though there are NO ERRORS, even with debug enabled in plugins.ini, the tables/database are not updated/created/etc. when the plugin is running. I've tested that with players in-game, also with bots, with match in progress, warm-up etc., no statistics are being pushed onto the MySQL server.

Any idea how can I further track this down? Has anyone successfully managed to run this plugin with MySQL? Please let me know, it's bugging me so much at this point.
Just to clarify, AMXX is able to access the database, as it successfully has created the admins table.

UPDATE:
I have rewritten some of the code in the plugin as well as changed quite some code in the PHP files. What was needed to fix the plugin:
- Alter PHP code to reflect changes from PHP5 to PHP7.4 and up.
- Alter MySQL related code to reflect changes from MySQL 4 to MySQL 8.
- Fix errors that arise after conversion in PHP, which would be issues with lines in code where Teams are concerned when querying SELECT * FROM `amx_match_statistics`. Instead, use SELECT DISTINCT and remove GROUP BY as it is not necessary.

After more or less these changes, the plugin works with PHP7.4 and MySQL 8.