[ANY] Player Analytics
 

[ANY] Player Analytics

Description:
This plugin logs detailed statistics of all connecting players to a MySQL table. Stats that are logged include:

• Server IP
• Player name
• Steam ID
• Time of connection (as Unix timestamp)
• Date of connection
• Connection method (on games that support cl_connectmethod)
• Number of players in-game at time of connection
• Current map at time of connection
• Duration of play session
• User admin flags
• User IP
• Player's city, region, 2-letter country code, and 3-letter country code (requires GeoIPCity)
• Player's country
• Player's F2P/Premium status (TF2 only, requires SteamTools)
• Player's HTML MOTD preference (enabled/disabled)
• Player's operating system

There will be a web interface later with which you can view the stats. In the meantime, you'll have to use something like phpMyAdmin to see the raw logs.

Cvars:

• player_analytics_version - plugin version
• player_analytics_auto_update - enables automatic updating (has no effect if Updater is not installed)

Developers:
Player Analytics has an API with which you can get player connection IDs. See the include file.

Requirements:
Both of these extensions are optional dependencies. That is, they are not required for the plugin to operate.

• GeoIPCity - Required to look up players' cities, regions, and country codes
• SteamTools - Required to detect the server's public IP behind a NAT and to look up Premium/F2P status on TF2

Installation:
This plugin requires a MySQL database. It will first look for a configuration named "player_analytics", and will fall back to "default" if one is not found. Example:

This should go in databases.cfg.

Install any optional extension dependencies that you want, and then put player_analytics.smx into /addons/sourcemod/plugins and os_detect.games.txt into /addons/sourcemod/gamedata and reboot your server or type "sm plugins load player_analytics" into your console or rcon.

Auto Update:
Install Updater. The plugin will be auto-updated according to your Updater settings. It'll work without Updater.

Changelog:

• v1.3.0 (4/3/15)
  • Plugin now uses utf8 queries
• v1.2.0 (3/31/15)
  • Added plugin API
• v1.1.0 (12/7/13)
  • Updated OS detection
• v1.0.0 (12/2/13)
  • Initial release

Download Plugin (player_analytics.zip)

.zip file includes plugin, gamedata, source, and include file

Requires updater.inc and mckayupdater.sp to compile.
______________________________

I have attached a development preview of the web panel. It's still in development so there are a lot of broken links and placeholder items. Simply set your variables in config_example.php and rename it to config.php

Web panel is by rannmann.

Re: [ANY] Player Analytics
 

The development web panel is very limited, and a community member has taken it on themselves to build on it. You may want to use it:

https://forums.alliedmods.net/showpo...8&postcount=69

Re: [ANY] Player Analytics
 

Awesome! Thanks for releasing this!

Re: [ANY] Player Analytics
 

I've attached a development preview of the web panel to the main post.

Re: [ANY] Player Analytics
 

hi,
does or will it store multiple player names?

Re: [ANY] Player Analytics
 

Very useful! Thanks Dr. McKay!

Re: [ANY] Player Analytics
 

Is there a reason why you connect non-threaded to the database?
In some countries it's not permitted (or atleast it's a grey area) to store dynamic ip's, you might want to add an option to anonymize it.
Some of the columns are a little bit too big (auth and ip for example), sure it makes no big difference, but it sums up for long-term data like this.

Re: [ANY] Player Analytics
 

This looks awesome.

Will be giving it a try tonight :D

Re: [ANY] Player Analytics
 

SQL_TQuery doesn't support the persistent parameter, and I like to conserve connections. Since it only connects on plugin startup, it won't block the server since realistically plugin startup will only be on server startup.

I find it somewhat questionable that it wouldn't be legal to store the IP address associated with a connection. If that were the case, then SRCDS itself would be in question due to its logs, which are stored indefinitely. If you can provide me a source, I might be able to add an option to not log IPs.

Re: [ANY] Player Analytics
 

An threaded connection handle stays valid until you close it, persistant connections are kinda default for it.

Re: [ANY] Player Analytics
 

The persistent parameter tells SourceMod to try to re-use an already-open connection if one exists, eliminating unnecessarily duplicate database connections. When you have many servers, this starts to become an issue.

Re: [ANY] Player Analytics
 

Neat plugin - Thanks Dr. McKay :)

Looking forward for the front end to be all done.

Re: [ANY] Player Analytics
 

Updated to 1.0.2. Fixed a problem that prevented SteamTools from being properly marked as optional (thanks nomy) and removed some debug spew.

Re: [ANY] Player Analytics
 

Here's a screenshot of the dev web panel if anyone is interested

Re: [ANY] Player Analytics
 

Hey great work guys, I've got the panel working but whenever I try to any of the top 4 tabs (users,sessions,connection or audience) it doesnt do anything. If I open in new tab it goes back to the dashboard. Is it supposed to happen for now or is there something I need fix?

Re: [ANY] Player Analytics
 

Looks nice!

Re: [ANY] Player Analytics
 

None of the links work yet.

Re: [ANY] Player Analytics
 

Ok thanks for confirming :)

Re: [ANY] Player Analytics
 

Awesome! Exactly what i was looking for, the web preview that I've installed so good so far! Can't wait to see the finalized version.

Re: [ANY] Player Analytics
 

+1

Re: [ANY] Player Analytics
 

FYI I got some errors from the dev. web panel.

For starts, i'm running PH 5.3.10

The config.php had to be edited to include quotes or i received errors
<?php
define('PA_DATABASE_SERVER', 'localhost');
define('PA_DATABASE_USER', 'user');
define('PA_DATABASE_PASSWORD', 'password');
define('PA_DATABASE_NAME', 'player_analytics');
?>

And on the main page i'm getting:


EDIT: I had to add at line 25:
That fixed the error above.

Re: [ANY] Player Analytics
 

Updated to v1.1.0. The method by which it detects players' operating systems has been updated. It now requires a gamedata file, which is in the .zip file.

Re: [ANY] Player Analytics
 

If a player connects twice, does it write 2 logs or overwrite the first?.


edit: it just keeps making logs. Mabye you can provide a cvar for that in the future?

Edi2:actually that's probably not the best idea

Re: [ANY] Player Analytics
 

Added support for this in Donations Control

https://github.com/nineteeneleven/Donations-Control/

Re: [ANY] Player Analytics
 

this plugin is very useful ^^, the plugin creates a table with charset utf8, however the charset of querys was not set to utf8

[IMG]http://s29.************/536ght8sn/non_utf8.png[/IMG]

Re: [ANY] Player Analytics
 

Isn't the connect_date not needed since the connect_time has it already?

1386450476 translates to:
Sat, 07 Dec 2013 21:07:56 GMT

Unless it's there to help with front end displaying of data?

Re: [ANY] Player Analytics
 

That's what it's there for.

Re: [ANY] Player Analytics
 

Same result as connect_date, let the database do the work.

Re: [ANY] Player Analytics
 

Great plugin, thanks!

Seeing this on our CSGO servers:

Re: [ANY] Player Analytics
 

Seeing some errors in my database, sometimes the server IP is not added correctly, filling a server_ip as 0.0.0.0:27015.

Also seeing problems with flags, a few times flags are not added properly. For example, my flags are 'azop' on a few occasions the flags are only 'az'. There are no errors in my sourcemod log file when these occur.

Re: [ANY] Player Analytics
 

Is there a rough time of when the panel will be fully available?

Re: [ANY] Player Analytics
 

Currently, no.

Re: [ANY] Player Analytics
 

?

Re: [ANY] Player Analytics
 

Great job, working on css :3
P.S.

Re: [ANY] Player Analytics
 

Re: [ANY] Player Analytics
 

Thanks for the work you did on the interface. One thing I would really like is just to be able to filter each column so I can see who has played the longest and who has the most visits ect. Also a way to get a % for each type of thing. Like the % of people who connect via favorites and such.

Re: [ANY] Player Analytics
 

A very simple edit, set query to use utf8
with that player names with special characters are entered correctly in the table :wink:

Re: [ANY] Player Analytics
 

I am having these issues, any way to fix?

Line 238:


EDIT::: Weird, idk...but after about 10 minutes it fixed it's self... lol

Re: [ANY] Player Analytics
 

hey I am seeing like.... 50 versions of quickplay_1, 2 ect..... is there a way to combine all of them permanently? I don't want to have to run an sql query each time I want to merge them together...

Re: Re: [ANY] Player Analytics
 

Rewrite your query.