Raised This Month: $300 Target: $400
 75% 

Player Status in DB


Post New Thread Reply   
 
Thread Tools Display Modes
+ARUKARI-
AlliedModders Donor
Join Date: Jul 2004
Location: Japan
Old 05-18-2020 , 20:02   Re: Player Status in DB
Reply With Quote #121

I was thinking that.
This plugin does not work on Non-Steam servers.
Non-Steam is not supported on this forum.
__________________
+ARUKARI- is offline
Canti87
New Member
Join Date: May 2020
Old 05-18-2020 , 20:14   Re: Player Status in DB
Reply With Quote #122

Sorry, I did not know.
So removing the dproto would avoid the blank spaces in the listing? not really used.
Canti87 is offline
+ARUKARI-
AlliedModders Donor
Join Date: Jul 2004
Location: Japan
Old 05-18-2020 , 20:17   Re: Player Status in DB
Reply With Quote #123

Build a clean server with SteamCMD.
If that causes problems, please post again.
__________________
+ARUKARI- is offline
Kelivart
New Member
Join Date: May 2020
Old 05-20-2020 , 14:15   Re: Player Status in DB
Reply With Quote #124

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
Kelivart is offline
+ARUKARI-
AlliedModders Donor
Join Date: Jul 2004
Location: Japan
Old 05-20-2020 , 16:14   Re: Player Status in DB
Reply With Quote #125

@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.
__________________
+ARUKARI- is offline
Kelivart
New Member
Join Date: May 2020
Old 05-22-2020 , 16:59   Re: Player Status in DB
Reply With Quote #126

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:

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

Quote:
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!

Last edited by Kelivart; 05-22-2020 at 16:59.
Kelivart is offline
+ARUKARI-
AlliedModders Donor
Join Date: Jul 2004
Location: Japan
Old 05-22-2020 , 21:53   Re: Player Status in DB
Reply With Quote #127

1.Have you changed amx_sql_db somewhere?
2.Install php7.2 or above and php-pdo module.
__________________
+ARUKARI- is offline
Reply


Thread Tools
Display Modes

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 16:05.


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