[theChaosCoder]

Originally Posted by Schpraaankiii Nice, I'll try this out! Btw, if you're still developing this. Could you maybe add map statistics for the maps played. Like most played maps (maybe a similar chart of the countries), for each server and for the dashboard(all servers). UPDATE: Getting this (screenshot) error when trying to fetch information about players. Btw, is there anything that could be done about the time duration it takes to load up the results? (I have 1220513 lines in the db table and it's growing by the minute)

Could be a php timeout. Try the newest version. load time should be a bit faster now (But not the search!)

[Archange]

Originally Posted by Schpraaankiii UPDATE: Getting this (screenshot) error when trying to fetch information about players.

+1

[Archange]

Originally Posted by theChaosCoder Could be a php timeout. Try the newest version. load time should be a bit faster now (But not the search!)

Google Chrome console >>>
AJAX Error message
404 - Not Found.

The most common errors are: 404 - Not Found. The URL requested was not found on the server. Check for typos in the file name in the ajax parameter and in your file on the server.

Résolution Source:
https://datatables.net/manual/tech-notes/7

Plz Update the plugin

[theChaosCoder]

What happens if you open http://yourdomain/player_analytics/inc/getplayers.php in your browser? (change domain and path)
Based on your information: You have a permission issue or did not upload all files.

@blackhawk74 I think I will add a DB switcher. that means you can add multiple DBs. So maybe you don't need to merge (But no global stats then )

[Chdata]

Originally Posted by theChaosCoder Maybe it was the dev branch from Sinclair47's player_analytics... I made a fork and merged both branches + made some fixes. Feel free to test it and report back. https://github.com/theChaosCoder/player_analytics changes: Added list of servers -> show stats per server (from dev branch) Fixed donut Charts: Show only the Top 10 countries (instead of 100+) Merged all Quickplay/Quickpick items in chart

Thanks a bunch for this, it's quite nice.

[theChaosCoder]

I made some bigger updates again to the webpanel. Added mutli server select, date selection is now globally available. And nearly every sql query uses a connect_date range now, so the performance should be better now on very large tables. Tested with a table of 6 mil records and a selection of 90 days on my small vps.

You also should add an index to connect_date to improve performance (if you're using phpmyadmin, just klick in the "index" link in the structure view of your table. If you receive a 502 timeout, don't worry, mysql is adding the index in the backgroud)

You can futher optimize your large table by adding partitons. use google

Next update will be charts stats charts

p.s. You can now use multiple databases (table name still fixed to "player_analytics". Will change what also later)
download here: https://github.com/theChaosCoder/player_analytics

Edit2: even better, use in addition a combined index: ALTER TABLE player_analytics ADD INDEX (server_ip, connect_date);

[mazdarx8]

I updated the version, but if I click on Maps i get message "Nothing to see here." How to enable it?

2. I dont see the link "Servers" not anylonger.

[theChaosCoder]

Update to latest version. The "Servers selection" is now at the top. (the image shows an older version on github). Also try a "forced reload" (STRG+F5) if something looks weird.

[theChaosCoder]

@Dr. McKay
Is it possible to add the duration to the error log too, so I have a chance to update it myself?

L 08/22/2016 - 09:36:16: [player_analytics.smx] Unable to update row 706364. Can't connect to MySQL server

[AeroAcrobat]

L 10/15/2016 - 13:19:18: [player_analytics.smx] Unable to insert row for client ∃ ∧ ∠ ∨ ∩ ⊂ ⊃ ∪<190><[U:1:317444635]><>. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

L 10/15/2016 - 16:50:04: [player_analytics.smx] Unable to insert row for client фредди фазбеар<685><[U:1:238670530]><>. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''Windo' at line 1