[sneaK]

Originally Posted by Stylee32 Is there a SQL query to remove players who have one connection and 0:00:00 time played?

I too would be interested in this, only for players with 00:00:00 time.

[Vastrix]

Bad Load:

L 06/29/2015 - 19:16:02: SourceMod error session started
L 06/29/2015 - 19:16:02: Info (map "mvm_coaltown") (file "errors_20150629.log")
L 06/29/2015 - 19:16:02: [SM] Failed to load plugin "player_analytics.smx": [2003]: Can't connect to MySQL server on 'localhost' (10061).

And in my database.cfg

	"player_analytics"
{
    "driver"            "mysql"
    "host"              "localhost"
    "database"        "player-analytics"
    "user"              "root"
    "pass"              "toor"	
  //"port"              "3306"
}

• Windows (yea yea i know..)
• SM Version: 1.7.3 dev5213

Any thoughts? :s

[PolyQuad]

Originally Posted by Vastrix Bad Load: L 06/29/2015 - 19:16:02: SourceMod error session started L 06/29/2015 - 19:16:02: Info (map "mvm_coaltown") (file "errors_20150629.log") L 06/29/2015 - 19:16:02: [SM] Failed to load plugin "player_analytics.smx": [2003]: Can't connect to MySQL server on 'localhost' (10061). And in my database.cfg "player_analytics" { "driver" "mysql" "host" "localhost" "database" "player-analytics" "user" "root" "pass" "toor" //"port" "3306" } Windows (yea yea i know..) SM Version: 1.7.3 dev5213 Any thoughts? :s

Have you connected to the localhost instance on the machine using something like MySQL workbench to verify that the connection works and that the database you are trying to access exists?

[Vastrix]

Originally Posted by PolyQuad Have you connected to the localhost instance on the machine using something like MySQL workbench to verify that the connection works and that the database you are trying to access exists?

Well, i know it doesn't exist, It's supposed to be created when ran for the first time, no?

[Phaiz]

Originally Posted by Vastrix Well, i know it doesn't exist, It's supposed to be created when ran for the first time, no?

The tables will be created on their own but not the database

edit-
Also, in case that is actually your password, I would delete it from the post

[Vastrix]

Originally Posted by Phaiz The tables will be created on their own but not the database edit- Also, in case that is actually your password, I would delete it from the post

Where do I place the mysql db then? :s
And is there a starter db that i missed somewhere?

dw, it's not ;)

[PolyQuad]

Just create a blank database named player-analytics, when the plugin is run it will create the tables.

[Vastrix]

Originally Posted by PolyQuad Just create a blank database named player-analytics, when the plugin is run it will create the tables.

And where should i place it? :s

data/mysql/player-analytics.sql ?

[PolyQuad]

Add PolyQuad on steam if you would like some help, you create the database with a tool like phpmyadmin or mysql workbench and connecting to the database, I don't think you can just create a db using a flat file, if so I have not done it that way before.

[Vastrix]

Originally Posted by PolyQuad Add PolyQuad on steam if you would like some help, you create the database with a tool like phpmyadmin or mysql workbench and connecting to the database, I don't think you can just create a db using a flat file, if so I have not done it that way before.

And under which path should i place the database?