Player Ranks

Like this?

The php is pretty straight forward. PM if you want a hand.

 

Would it be possible to request that Economics be shown on the top ranks list?

 

Hi,
Yes, I could add that as an option. I'll make a note for next V.

 

thank you very much =)

 

Steenamaroo updated Player Ranks with a new update entry:

1.1.7

 

Hey there just loaded the update for this and got this error
(12:44:38) | Loaded plugin PlayerRanks v1.1.7 by Steenamaroo
(12:44:40) | Error while compiling: Friends.cs(400,34): error CS1061: Type `Oxide.Core.Libraries.Covalence.IPlayerManager' does not contain a definition for `FindPlayerByObj' and no extension method `FindPlayerByObj' of type `Oxide.Core.Libraries.Covalence.IPlayerManager' could be found. Are you missing an assembly reference?

Not sure what its about?

 

Hi,
Please check the update notes at Friends API | Oxide

 

Should it add the SQL table itself or do I need one from you?

Code:

9:44 PM [Error] MySql handle raised an exception (SocketException: A blocking operation was interrupted by a call to WSACancelBlockingCall.
)
9:44 PM [Stacktrace]   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
21:44 [Info] Loaded plugin PlayerRanks v1.1.7 by Steenamaroo
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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
9:44 PM [Error] MySql handle raised an exception (MySqlException: Table 'playerranks.playerranksdb' doesn't exist)
9:44 PM [Stacktrace]   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 

I've done a server save and seems it doesn't create the tables
[DOUBLEPOST=1494273718][/DOUBLEPOST]Players can't close the menu even when the plugin is loaded and while unloading the server freezes for 20 seconds due to the SQL tables can't be created.

 

[Feature Request] Hi!
Is it possible to connect third-party plugins for storage?
For example, save information about the hours spent on the server from the plugin Playtime Tracker | Oxide

 

Hi,
The plugin creates the table automatically.
Is your MySQL server set up to allow connections from your game server IP?
[DOUBLEPOST=1494274977][/DOUBLEPOST]

Hi,
Yes..I was thinking about maybe adding an offline/online status, and playtime.
I'll look into it.
Thanks.

 

Yes, we have couple other plugins with the same information that works fine.

 

oh? Ok.
Would you do me a favour and try the previous version, in case I've made a mistake somewhere?
Thank you.

 

That one worked

 

ok. Thank you.
And if you update to most recent, that works now?
[DOUBLEPOST=1494275792][/DOUBLEPOST]Not sure why that happened.

I just removed the plug, deleted data, dropped SQL table, and installed the most recent version from here.
Table was created without issue on first save.
[DOUBLEPOST=1494275942][/DOUBLEPOST]

This may be a separate thing. Someone else had this issue and tracked it down to a conflict with another plugin, but he didn't track it down to which plugin.
I have a list of his plugins here and intend to find out.

In the meantime I've put in a timer which should destroy the GUI if it's open for more than 10 seconds but since I can't replicate the fault, I can't test the temporary fix.

 

Could it be InfoPanel?

 

I don't think so.
I run info panel on my server.

Could you send me a full list of your plugins via private message?
just type plugins in RCON and they'll all list there.

If a few people do that it'll make it much easier!

 

Could you make the ingame commands a console command aswell?

 

Line 23 in the config have a typo.

Code:

"Categories - Stuctures Demolished": true,

Stuctures should be Structures.

 

Plugin seems to omit some players when updating database (it should only be omitting unicode chars ?) :

Code:

(23:15:51) | [Oxide] 23:15 [Info] [PlayerRanks] Player Ranks Local Database Was Saved.
(23:15:52) | [Oxide] 23:15 [Info] [PlayerRanks] Player Ranks MySQL Database Was Saved.
(23:15:52) | [Oxide] 23:15 [Error] MySql handle raised an exception in 'PlayerRanks v1.1.7' plugin (MySqlException: Incorrect string value: '\xE2\x9C\xAA Wy...' for column 'Name' at row 1)
(23:15:52) | [Oxide] 23:15 [Stacktrace]   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

 

^^ That's the error we got when someone had odd chars in their name.

They're meant to be filtered out now but obviously something got through.

Can you tell (or PM) me the specific player name, please?