Player Database [Replaced]

Reneb submitted a new resource:

Player Database - Log all players in a datafile, only userids as default, other plugins can add more

Read more about this resource...

 

Reneb updated Player Database with a new update entry:

initial fix + added /findname STEAMID

 

Reneb updated Player Database with a new update entry:

fixed findallplayers (usefull for my next plugin)

 

Reneb updated Player Database with a new update entry:

optional use SteamAPI Key

 

Reneb updated Player Database (MySQL Support) with a new update entry:

added Mysql support

 

I'm having problems with MySQL


I have table, mysql connection data is correct. Table is empty (without any records as know as users)

 

Reload the plugin.

 

Even I restart server it's just same.

 

Reneb updated Player Database (MySQL Support) with a new update entry:

fix for mysql

[DOUBLEPOST=1429354068][/DOUBLEPOST]i know why ^^this should fix your problem

 

I don't quite understand. I use same connection data for localhost webpage (For webrequests), for remote webpage (everything works fine) and why is that? I inserted privileges once more and used FLUSH PRIVILEGES and still....
[DOUBLEPOST=1429355486]UPDATE[/DOUBLEPOST]

UPDATE​

Is this a bug? I tried (to test is this a problem) to use 127.0.01 and well it says 'rust'@'localhost' ... (Of course I restarted server after changing config)


By the way... My MYSQL port is 3307 not default one 3306 (maybe it have something to do with the problem)

 

just read the error message:
INSERT command denied to user 'rust'@'localhost' for table 'playerdatabase'
everything you need to know is in here ... you dont have the privilege on the database,
and don't ask me more i'm no pro to it lol ...

 

mmmm im getting teh same priviege error and not sure what the problem is either.

Code:

4:50 PM [Error] Failed to call hook 'OnPlayerConnected' on plugin 'PlayerDatabase' (MySqlException: INSERT command denied to user 'rusty'@'192.168.1.200' for table 'playerdatabase')
4:50 PM [Debug]   at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.NativeDriver.GetResult (System.Int32& affectedRow, System.Int64& insertedId) [0x00000] in <filename unknown>:0
4:54 PM [Error] Failed to call hook 'OnPlayerConnected' on plugin 'PlayerDatabase' (MySqlException: Access denied for user 'rusty'@'192.168.1.200' (using password: YES))
4:54 PM [Debug]   at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.NativeDriver.ReadPacket () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket () [0x00000] in <filename unknown>:0

[DOUBLEPOST=1429421507][/DOUBLEPOST]The users privileges are fine, just created a new database (rustlegacy) and tested the database connection

[DOUBLEPOST=1429440598,1429419881][/DOUBLEPOST]OK finally got it working.

So the issue isn't actually permissions of the user, it is that the plugin isn't using variables for the database name, so it isnt looking in the right database.
Was pretty clear when I saw this:

Code:

150419 21:15:34     3 Connect   [email protected] on rustlegacy
                    3 Query     SHOW VARIABLES
                    3 Query     select timediff( curtime(), utc_time() )
                    3 Query     SHOW COLLATION
                    3 Query     SET NAMES utf8
                    3 Query     SET character_set_results=NULL
                    3 Init DB   rustlegacy
                    3 Query     INSERT INTO `rust`.`playerdatabase` (`steamid`) VALUES('7656119796XXXXXXX')

Which can be seen on this line: query = string.Format("INSERT INTO `rust`.`{0}` (`steamid`) VALUES('{1}');", mysqlTable, userid);

After fixing it, it was just complaining about default values due to MySQL default being STRICT.
I quick fixed that by running SET GLOBAL sql_mode=''

 

Reneb updated Player Database (MySQL Support) with a new update entry:

fixed the database bug

[DOUBLEPOST=1429442081][/DOUBLEPOST]sorry didnt see that i've hard coded the `rust` dbname. removed it

 

Reneb updated Player Database (MySQL Support) with a new update entry:

resourceid & fixed some mysql bug

 

Code:

10:38 PM [Error] Failed to call hook 'OnPlayerConnected' on plugin 'PlayerDatabase' (MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '...;'' WHERE `playerdatabase`.`steamid` = 76561197994414379' at line 1)
10:38 PM [Debug]  at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.NativeDriver.GetResult (System.Int32& affectedRow, System.Int64& insertedId) [0x00000] in <filename unknown>:0

Code:

10:08 PM [Error] Failed to call hook 'OnPlayerConnected' on plugin 'PlayerDatabase' (SocketException: Error looking up error string)
10:08 PM [Debug]  at System.Net.Sockets.Socket.Receive (System.Byte[] buffer, Int32 offset, Int32 size, SocketFlags flags) [0x00000] in <filename unknown>:0
  at System.Net.Sockets.NetworkStream.Read (System.Byte[] buffer, Int32 offset, Int32 size) [0x00000] in <filename unknown>:0
10:08 PM [Warning] CallHook 'OnPlayerConnected' on plugin 'PlayerDatabase' took: 33054.69ms

 

i recommend not to use mysql it seems that the plugin had a hard time connecting to your mysql, there for blocking your server (as long as the request isnt made the server "stops" working)
mysql is only for servers that use local tables

 

how to delete a row from the database?

__________________________
I am Russian. Sorry for my English
[DOUBLEPOST=1432257834,1432249675][/DOUBLEPOST]already understood

 

For what plugins do I need this plugin?
It seems like the home location plugin only works with this player database plugin.
But I only have SQLlite..

 

It's a player database that allows other Plugin devs to use it as a framework for their plugs to have a unified database of data.
It stops each plugin from having to track the players their steam id, and any other details about the player they might want to use.

e.g If you make a bansystem that uses this Player database then you could have an attribute "banned" and "banned date" which the ban system creates.
You could then also have a website where you create a banlist, and pull those same deatils from the player database.

Perhaps you just want to make a webpage that pulls details from the database of players on your server, and when they were last seen.

As far as formats it supports SQLite and MySQL.

 

I am installing MySQL 5.6.25, it wants me to configure the SQL server, do I have to check or uncheck: "Name Pipe" or "Shared Memory"