SQLStats [Unmaintained]

i would of agreed 5 years ago. but your ip is stored everywhere now. (Was then as well). Not the argument i want to do on the forums either .

I would never put it on say a top stats of the website but for the example im showing all the columns that are gathered in each table for the plugin.

 

I feel a little bit dump, did I have to create table by myself or the plugin should do it for me?

EDIT: nvm found it!

 

I'm probaly the only one that doesn't understand it. But do we need to fill in exactly?

{
"dbConnection": {
"Database": "databasename?",
"Host": "IP of the rustserver or hostserver?",
"Password": "PW of the rustserver or hostserver?",
"Port": wich port?,
"Username": "username of the rustserver or hostserver?"
}
}

 

Hey Marco,
you will need to creat a new database somewhere with a USER and a PASSWORD for that user.
Once your database is created dont forget to create your table.
{
"dbConnection": {
"Database": "databasename",
"Host": "ip of your database (My database is on my web site, so its my website IP ",
"Password": "database passwords",
"Port": 3306 its the default Mysql port,
"Username": "database username"
}

 

Code:

[Oxide] 2:17 AM [Debug] ExType: MySqlException
[Oxide] 2:17 AM [Error] MySql handle raised an exception in 'SQLStats v1.0.2' plugin (SocketException: No such host is known.
)
[Oxide] 2:17 AM [Debug]   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 

How can I fix that?

 

I'm getting some weird bug with the connection. I've tried 2 different server databases.

[03/10/2016 22:43:48] [Oxide] 10:43 PM [Debug] 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

*EDIT
Nevermind. Different SQL connection.

 

Anyone got a nice PHP script that can implement the stats on our website?
I've been trying to make my own but it doesn't like my SQL queries even though they are correct.

 

Help me to make my SQLStats to work and ill give you my script you will just need to edit the tables

 

Hello, i have a problem.

In player name, say the steamid player,

Can help me, please?
[DOUBLEPOST=1457959050,1457786670][/DOUBLEPOST]If i want put in the 3307 port? what is the solution please?

 

Hi! I have some trouble with your plugin. My console write next:
(01:57:26) | [Oxide] 1:48 AM [Error] SQLStats.cs(351,28): error CS0246: The type or namespace name `Planner' could not be found. Are you missing an assembly reference?
Maybe I dont setup it on my server?? Where I need to make a config file? And for each vertion of Rust this plugin, Legacy or Experemental?

 

I try to make this plugin work with Rust Legacy. I need to send SQLdata to my website from server....

 

Hello, I've just downloaded SQLStats and got it all working, but I've just noticed its now how I want it to be in the SQL.
I need SQLStats to be re-edited so it will list as a row with,
Kill_Death_Ratio [Name, Kills, Deaths]
And another row with
Player_Online_Time [Name, Days, Hours, Mins]
If any one think they can do this please start a conversation with me or comment in this, and we will talk about how much you would like for it
I don't know how to code but this cant be too hard to do or should take too long to do.

Here is the plugin SQLStats for Rust | Oxide

Here is an example:
Gyazo - a21298217af4ea393b0b6062c2f1a328.png

 

You don't need to edit SQLStats, you just need to select that information from the database as you want.

 

I am interested in donating to help keep this uptodate and provide and in game gui to show the stats. Please contact me.

 

Can it getting updated for the last Oxide release ? It should be great ! :d

 

I did take a look at the plugin and made an update to it to work with Oxide Version 2.0.1873
GitHub - Limmek/SQLStats-for-Rust: upload
or

 

SQLYog can connect from the dedicated to the MySQL DB, the script says it's connected but I get this spamming the console:-
ect to any of the specified MySQL hosts.)
(21:58:33) | [Oxide] 9:58 PM [Error] MySql handle raised an exception (MySqlException: Unable to connect to any of the specified MySQL hosts.)
(21:58:34) | [Oxide] 9:58 PM [Error] MySql handle raised an exception (MySqlException: Unable to connect to any of the specified MySQL hosts.)
(21:58:35) | [Oxide] 9:58 PM [Error] MySql handle raised an exception (MySqlException: Unable to connect to any of the specified MySQL hosts.)
(21:58:36) | [Oxide] 9:58 PM [Error] MySql handle raised an exception (MySqlException: Unable to connect to any of the specified MySQL hosts.)
(21:58:37) | [Oxide] 9:58 PM [Error] MySql handle raised an exc

Thats using that latest .cs above.

 

Check your config i'm using it and it working just fine on last update April 21st, 2016 (protocol 1367, build 862.87).

{
"dbConnection": {
"Database": "database_name",
"Host": "127.0.0.1",
"Password": "pass",
"Port": 3306,
"Username": "name"
}
}