Raised This Month: $12 Target: $400
 3% 

SQL Matches


Post New Thread Reply   
 
Thread Tools Display Modes
WardPearce
Senior Member
Join Date: Apr 2017
Location: New Zealand
Old 01-02-2019 , 15:41   Re: SQL Matches
Reply With Quote #11

Send the log errors_20190101.
WardPearce is offline
DabberDoug
Member
Join Date: Feb 2016
Location: USA
Old 01-02-2019 , 21:54   Re: SQL Matches
Reply With Quote #12

The plugin works great, It has done wonders to my 10 man community.

Is it possible you can add a section for the demos, it is auto generated using splewis's pug
DabberDoug is offline
neploho
Member
Join Date: Jul 2010
Old 01-03-2019 , 01:49   Re: SQL Matches
Reply With Quote #13

Quote:
Originally Posted by WardPearce View Post
Send the log errors_20190101.
this is it

Quote:
L 01/01/2019 - 158:14: SourceMod error session started
L 01/01/2019 - 158:14: Info (map "de_dust2") (file "errors_20190101.log")
L 01/01/2019 - 158:14: [SM] Exception reported: Configuration "sql_matches" not found
L 01/01/2019 - 158:14: [SM] Blaming: sqlmatch.smx
L 01/01/2019 - 158:14: [SM] Call stack trace:
L 01/01/2019 - 158:14: [SM] [0] SetFailState
L 01/01/2019 - 158:14: [SM] [1] Line 10, sqlmatch.sp::OnPluginStart
L 01/01/2019 - 158:14: [SM] Unable to load plugin "sqlmatch.smx": Error detected in plugin startup (see error logs)
my base

Quote:
CREATE USER 'sql_matches'@'%' IDENTIFIED WITH mysql_native_password;GRANT USAGE ON *.* TO 'sql_matches'@'%' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;SET PASSWORD FOR 'sql_matches'@'%' = '***';CREATE DATABASE IF NOT EXISTS `sql_matches`;GRANT ALL PRIVILEGES ON `sql\_matches`.* TO 'sql_matches'@'%';
neploho is offline
WardPearce
Senior Member
Join Date: Apr 2017
Location: New Zealand
Old 01-04-2019 , 03:03   Re: SQL Matches
Reply With Quote #14

Is your game server on the same server as your web server?
Otherwise it's most likely a permission issue or something else beside the plugin.

Last edited by WardPearce; 01-04-2019 at 03:05.
WardPearce is offline
WardPearce
Senior Member
Join Date: Apr 2017
Location: New Zealand
Old 01-04-2019 , 03:08   Re: SQL Matches
Reply With Quote #15

Quote:
Originally Posted by DabberDoug View Post
The plugin works great, It has done wonders to my 10 man community.

Is it possible you can add a section for the demos, it is auto generated using splewis's pug
I'm planning to expand the plugin to include a user profile system and demos as well.
WardPearce is offline
neploho
Member
Join Date: Jul 2010
Old 01-04-2019 , 03:56   Re: SQL Matches
Reply With Quote #16

Quote:
Originally Posted by WardPearce View Post
Is your game server on the same server as your web server?
Otherwise it's most likely a permission issue or something else beside the plugin.
Game and web server on the same server. There are no errors on the web server, only in the plugin.

UPD: Found another error

Quote:
[Fri Jan 04 14:08:11.870853 2019] [:error] [pid 10765] [client 176.***.***.798809] Array\n(\n [Host] => 127.0.0.1\n [Db] => matches\\_%\n [User] => matches\n [Select_priv] => Y\n [Insert_priv] => Y\n [Update_priv] => Y\n [Delete_priv] => Y\n [Create_priv] => Y\n [Drop_priv] => Y\n [Grant_priv] => N\n [References_priv] => Y\n [Index_priv] => Y\n [Alter_priv] => Y\n [Create_tmp_table_priv] => Y\n [Lock_tables_priv] => Y\n [Create_view_priv] => Y\n [Show_view_priv] => Y\n [Create_routine_priv] => Y\n [Alter_routine_priv] => Y\n [Execute_priv] => Y\n [Event_priv] => Y\n [Trigger_priv] => Y\n [can_delete] => 1\n)\n
maybe I base and user incorrectly create?

Last edited by neploho; 01-04-2019 at 04:16.
neploho is offline
WardPearce
Senior Member
Join Date: Apr 2017
Location: New Zealand
Old 01-04-2019 , 15:48   Re: SQL Matches
Reply With Quote #17

Quote:
Originally Posted by neploho View Post
Game and web server on the same server. There are no errors on the web server, only in the plugin.

UPD: Found another error



maybe I base and user incorrectly create?
If the game server and web server are not on the same server then you need to user a IP to direct the the game server to your database, otherwise its a permission issue or something wrong with how you created the user.
WardPearce is offline
raj kaul
Senior Member
Join Date: Mar 2018
Location: www.lotgaming.xyz
Old 01-22-2019 , 15:40   Re: SQL Matches
Reply With Quote #18

nice plugin. waiting for auto demo upload update which support splewis's pug setup

EDIT-- can you fix this? .If any player left the game 1 round before so its not showing his name and score on scoreboard tab

ex - https://lotgaming.xyz/stats/pug/scoreboard.php?id=6
__________________

Last edited by raj kaul; 01-26-2019 at 14:16. Reason: for 1 question
raj kaul is offline
DabberDoug
Member
Join Date: Feb 2016
Location: USA
Old 02-02-2019 , 14:13   Re: SQL Matches
Reply With Quote #19

Quote:
Originally Posted by WardPearce View Post
I'm planning to expand the plugin to include a user profile system and demos as well.
Is there a beta version available? I run a community server who has ran a 10 man almost every day for two months we use your plugin extensively

I would love to also include the RWS system that is used on the profiles.

Last edited by DabberDoug; 02-02-2019 at 14:48.
DabberDoug is offline
TheBOSS
Member
Join Date: Nov 2018
Old 02-16-2019 , 06:52   Re: SQL Matches
Reply With Quote #20

Fine!
just add team name and fix the players name which include symbols like this "ะยƝƓЄƦ - ♛ - ✪" not appear correctly in website and database
TheBOSS 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 14:49.


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