[PolyQuad]

I login to phpmyadmin and click create database name it and click ok. Or i login with mysql workbench, create and name database, there is no need to know where the local database file path needs to be placed.

https://www.siteground.com/tutorials...e_database.htm

or if you have a webhost on the box with php you can create a simple php script to run one time to create a database, then delete the php file after it is run.

http://www.w3schools.com/php/php_mysql_create.asp

[Pala4]

What error?

[player_analytics.smx] Unable to insert row for client Арчи Хартстрингс<263><[U:1:183928510]><>. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

[Phaiz]

Originally Posted by Vastrix And under which path should i place the database?

Do you have a vps or a shared hosting server? If you have a vps then you should have (or be able to) install phpmyadmin. I've never used any other program but that one is -very- straight forward and easy to use

[Vastrix]

Ok, thanks guys!

[mazdarx8]

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

Push.,...

[PolyQuad]

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

I am sure it isnt hard to do, I looked in my database and I dont see any instance in thousands of connections of anyone that has 1 connection and 0 time. Are you saying when you look in your database you have entries with duration = 0?

EDIT:
Ok after looking again I see single entries where players have a NULL duration, which probably occurs when the server crashes. This query should show you those entries in your table

SELECT auth, count(auth), sum(duration) from player_analytics
group by auth
having count(auth) = 1 and sum(duration) is null


You probably just want to delete all null duration entries from your analytics table. I would do this when your server was empty so you dont delete data of a newly joined player that has yet to leave the server.

Back up your table by copying it first before testing
CREATE TABLE player_analytics_backup select * from player_analytics;

Then just try
DELETE FROM player_analytics where duration is null;

[Caaine]

my site is to slow

[Phaiz]

Would it be possible to add tracking of private or public player Steam profiles?

[Dr. McKay]

Originally Posted by Phaiz Would it be possible to add tracking of private or public player Steam profiles?

That could be possible, although I'm not sure how much I want to add API requests to the plugin.

[Phaiz]

Originally Posted by Dr. McKay That could be possible, although I'm not sure how much I want to add API requests to the plugin.

The only reason I ask is it could help server owners determine if it would be worth while to run a plugin that kicks players with private Steam profiles