Raised This Month: $ Target: $400
 0% 

AMX Match Deluxe (Current Version: 8.11)


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
raven31
New Member
Join Date: May 2024
Old 05-06-2024 , 12:51   Re: AMX Match Deluxe (Current Version: 8.11)
Reply With Quote #1

Quote:
Originally Posted by paprikon View Post
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.
Hello,
I'm trying to get the stats functionality to work as best I can.
I have no errors, at the php level, or even at the database level, but when I run matches for tests, no data is displayed..
I welcome your updates
Thank you so much
raven31 is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 03:38.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode