Player Ranks

I wanted to lower the font size of messages in chat.

 

Oh, for chat?

Yeah, I can do that.

 

Steenamoroo you have a issue for fix SQL error ?

 

What's the error?

 

Code:

(14:56:59) | ExType: MySqlException
(14:56:59) | MySql handle raised an exception in 'PlayerRanks v1.3.5' plugin (SocketException: No such host is known.
)
  at System.Net.Dns.GetHostByName (System.String hostName) [0x00000] in <filename unknown>:0
  at System.Net.Dns.GetHostEntry (System.String hostNameOrAddress) [0x00000] in <filename unknown>:0
  at MySql.Data.Common.MyNetworkStream.GetHostEntry (System.String hostname) [0x00000] in <filename unknown>:0
  at MySql.Data.Common.MyNetworkStream.CreateStream (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings, Boolean unix) [0x00000] in <filename unknown>:0
  at MySql.Data.Common.StreamCreator.GetTcpStream (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x00000] in <filename unknown>:0
  at MySql.Data.Common.StreamCreator.GetStream (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000] in <filename unknown>:0

 

"SocketException: No such host is known"

Sounds like your credentials aren't correct. Double check the IP you are using to connect, and make sure you're using your SQL hosts 'remote connection IP', if it's an external DB and one is offered.

 

Where i check this ?

I just put the logging' info of my databe external in config file PlayerRanks.json :

Code:

 "MySQL - Database Name": "dfbdfbdbdf",
  "MySQL - Host": "dfbfdbdfb",
  "MySQL - Password": "bfdfbfdb",
  "MySQL - Port": 3306,
  "MySQL - Table Name": "playerranksdb",

 

The error message suggests that the IP (host) address you used is incorrect.

You need to get the correct IP(host), password, and database name, from your SQL provider.

 

And the error message appears at each save of data for each players

 

That's a separate issue that's been rectified in un-released 1.3.6.
Thank you, though.

 

Ok ! For exemple actually, my host is : (Database Name).mysql.db
So I do replace by Ip ?

 

It should look like this

Code:

 "MySQL - Database Name": "RanksDatabase",
  "MySQL - Host": "1.2.3.456",
  "MySQL - Password": "5uper5secretp4ass",
  "MySQL - Port": 3306,
  "MySQL - Table Name": "playerranksdb",
  "MySQL - Username": "SqlAccountUserName",

but with your details instead of made up ones.

Note - Username was missing from your paste.

Host, User, Pass, and Port come from the SQL provider.
Table Name you can make up.

 

It work ! Thank you !

 

Glad to help.

 

Anyone else getting this in console since the new update?

Code:

Failed to call hook 'OnPlayerDisconnected' on plugin 'PlayerRanks v1.3.5' (NullReferenceException: Object reference not set to an instance of an object)
  at Oxide.Plugins.PlayerRanks.OnPlayerDisconnected (.BasePlayer player, System.String reason) [0x00000] in :0
  at Oxide.Plugins.PlayerRanks.DirectCallHook (System.String name, System.Object& ret, System.Object[] args) [0x00000] in :0
  at Oxide.Plugins.CSharpPlugin.InvokeMethod (Oxide.Core.Plugins.HookMethod method, System.Object[] args) [0x00000] in :0
  at Oxide.Core.Plugins.CSPlugin.OnCallHook (System.String name, System.Object[] args) [0x00000] in :0
  at Oxide.Core.Plugins.Plugin.CallHook (System.String hook, System.Object[] args) [0x00000] in :0 

 

I updated oxide at the same time as the server update. There was another one afterwards?

 

Preparing next version.
Quite a few changes; Could use some testers if anyone's interested. PM me.

SQL users preferred.

 

Hey @Steenamaroo, what are your thoughts on adding the OnPlayerBanned hook so when someone gets banned, their stats (if any) are automatically wiped?