Player Ranks

Ok. I'll try it out myself and see what's going on.
Thanks.

 

The hotkey doesn't work, so my players are just typing /pr tops. Not a huge deal, just thought you should know

 

Hey,
Thanks. Yeah, Facepunch prevented plugins from binding keys a while back so all the hot-key plugins (this, LustyMap, kits, etc) all require that the users manually map the command.

Instructions are in the overview.

 

there is a problem about something... that I could not fix yet.

 

Noted. Thanks.
[DOUBLEPOST=1516408847][/DOUBLEPOST]

Any change, @Ryrzy ?

 

i have changed mysql to localserver, but i think i have seen onece ore two this error with mysql. But... its not a problem, stats are refreshing ok. thanks!

 

Looked into it. I can't replicate this error and have no record of it in my logs.
The only SQL exceptions I have are connection refused or connection timed out, dating back to attempts when credentials were wrong, or the SQL server was down.

I think I need to find a way to make sure a connection is currently opening before closing - I had a problem with this before.
There's no error handling for this in PlayerRanks right now.

If the sql table is populating and this error only occurs once in a while, ignore it for the time being.
If it's happening all the time and there is no data getting to your sql table, please let me know.

 

ummmmm, whats SDR please?

 

Suicides to Deaths ratio.

 

Hi i got this:

Code:

Exception while invoking event handler (NullReferenceException: Object reference not set to an instance of an object)
  at MySql.Data.MySqlClient.MySqlDataReader.Close () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.MySqlConnection.Close () [0x00000] in <filename unknown>:0
  at Oxide.Core.MySql.Libraries.MySql.OnRemovedFromManager (Oxide.Core.Plugins.Plugin sender, Oxide.Core.Plugins.PluginManager manager) [0x00000] in <filename unknown>:0
  at Oxide.Core.Event+Callback`2[Oxide.Core.Plugins.Plugin,Oxide.Core.Plugins.PluginManager].Call (Oxide.Core.Plugins.Plugin arg0, Oxide.Core.Plugins.PluginManager arg1) [0x00000] in <filename unknown>:0

Code:

MySql handle raised an exception (NullReferenceException: Object reference not set to an instance of an object)
  at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.MySqlCommand.AsyncExecuteWrapper (Int32 type, CommandBehavior behavior) [0x00000] in <filename unknown>:0

my fail?

 

Hi,
Do you get this every time the plugin tries to save? (do playerranks.save if you're not sure)
Is your SQL table being populated successfully?

 

Two questions about the plugin since I'm trying to configure it.

1) When I have the mysql stuff set up I get this error on a reload and I'm curious what could be causing it. I was unable to look at the SQL demo you have linked on the Overview, it just leads to a dead page.

Code:

MySql handle raised an exception (MySqlException: Invalid attempt to call NextResult when the reader is closed.)   at MySql.Data.MySqlClient.MySqlDataReader.Throw (System.Exception ex) [0x00000] in <filename unknown>:0   at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00000] in <filename unknown>:0   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0 

2) Whenever I reload I also get these notifications:

Code:

[PlayerRanks] PlayerRanks: PlayTime Tracker is not installed. Please install it and reload.
[PlayerRanks] PlayerRanks: Economics is not installed. Category will show 0 for all players.
[PlayerRanks] PlayerRanks: Rust:IO is not installed.

I don't have PlayTime Tracker or Economics installed and don't want to enable these options but don't see a place to disable them in the config.
I do have Rust:IO installed so I'm not sure why that is popping up.

Thank you for your work on this plugin, it's quite nice!

 

TimePlayed of a player will not reset when /pr wipe

Can anyone help me with this?

 

You can ignore the Playtime and Economics notices if you don't intend to use them.
Rust:IO report should be accurate, though, unless something has changed there recently.

Have you accessed your server map at Rust:IO site to confirm?

TimePlayed is pulled from PlaytimeTracker plugin so although it does wipe with all the other PlayerRanks data, the source isn't reset.
If you want to reset TimePlayed for all your players, you'd need to trash PlaytimeTracker data too.

PlayerRanks should automatically overwrite the data for each player the next time it saves, after you do the above.

 

ok so i have put all mysql information in but how do i display it on a webpage on my website? does anyone have a tutorial on what to do next? thanks

 

Setting up mysql to display player ranks information on a webpage on my website i inputted all the information into player ranks.json but from there i dont know what to do next to display the info on my website could anyone help ?

thanks

Player Ranks

 

Hey,
This kind chap put together a public template for displaying the data.
There's a bit to it but I know people who have used it - All you need is in there.

 

Anyone have a smal script for website to show top 10?

 

Code:

(15:31:12) | MySql handle raised an exception (MySqlException: Unable to connect to any of the specified MySQL hosts.)
  at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.Driver.Open () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x00000] in <filename unknown>:0
(15:31:13) | MySql handle raised an exception (MySqlException: Unable to connect to any of the specified MySQL hosts.)
  at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.Driver.Open () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x00000] in <filename unknown>:0

anyone know what is wrong?

 

Looks like either your SQL credentials are incorrect in PR config, or the SQL server isn't set up to accept connections from your Rust server.

You should have a remote-connection set up section with your SQL provider - Add your rust Server IP in there.
Depending on the Rust server host, you might need to ask them what the IP is.
I had to with gameservers; The client.connect rust IP was not the IP used for sql comms.