Raised This Month: $32 Target: $400
 8% 

[ANY] Player Analytics


Post New Thread Reply   
 
Thread Tools Display Modes
Chdata
Veteran Member
Join Date: Aug 2012
Location: Computer Chair, Illinois
Old 08-07-2016 , 16:19   Re: [ANY] Player Analytics
Reply With Quote #301

I remember someone showing me some version of the webpanel that lists their servers separately...

Does anyone know about that or have something like that?

Who are youuuuuu
__________________

Last edited by Chdata; 08-07-2016 at 16:19.
Chdata is offline
theChaosCoder
Junior Member
Join Date: Oct 2015
Old 08-08-2016 , 07:26   Re: [ANY] Player Analytics
Reply With Quote #302

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
theChaosCoder is offline
Chdata
Veteran Member
Join Date: Aug 2012
Location: Computer Chair, Illinois
Old 08-08-2016 , 08:46   Re: [ANY] Player Analytics
Reply With Quote #303

What is the difference between Quickplay and Quickpick?
__________________
Chdata is offline
pcmaster
AlliedModders Donor
Join Date: Sep 2009
Old 08-08-2016 , 08:58   Re: [ANY] Player Analytics
Reply With Quote #304

Quickplay = You click a button and get placed into a random server that has QP enabled
Quickpick = You get presented a list of servers that have QP enabled, where you have to click "connect" yourself.

Both are mostly non-existant in TF2 anymore (apart from MvM, which only has Quickplay).
__________________
Stopped hosting servers as of November 2018, no longer active around here.
pcmaster is offline
Dr. McKay
Sir Dr. SourceMod Plugin Approver Esq. Ltd. M.D. PhD
Join Date: Aug 2011
Location: Atlantis
Old 08-08-2016 , 14:41   Re: [ANY] Player Analytics
Reply With Quote #305

Quote:
Originally Posted by pcmaster View Post
Quickplay = You click a button and get placed into a random server that has QP enabled
Quickpick = You get presented a list of servers that have QP enabled, where you have to click "connect" yourself.

Both are mostly non-existant in TF2 anymore (apart from MvM, which only has Quickplay).
MvM uses "matchmaking".
__________________
Dr. McKay is offline
sneaK
SourceMod Moderator
Join Date: Feb 2015
Location: USA
Old 08-08-2016 , 15:00   Re: [ANY] Player Analytics
Reply With Quote #306

Is there a proper way of combining multiple player analytics databases? I like to track my servers stats separately by server type (ex. Surf separate from 1v1 Arenas, etc), but now with theChaosCoder's changes I'd like to combine and use one large database.
sneaK is offline
theChaosCoder
Junior Member
Join Date: Oct 2015
Old 08-08-2016 , 17:33   Re: [ANY] Player Analytics
Reply With Quote #307

I think the easiest way would be a SELECT INTO Statement.
http://www.w3schools.com/sql/sql_select_into.asp

Code:
INSERT INTO player_analytics_table1 (`server_ip`, `name`, `auth`, `connect_time`, `connect_date`, `connect_method`, `numplayers`, `map`, `duration`, `flags`, `ip`, `city`, `region`, `country`, `country_code`, `country_code3`, `premium`, `html_motd_disabled`, `os`)
SELECT `server_ip`, `name`, `auth`, `connect_time`, `connect_date`, `connect_method`, `numplayers`, `map`, `duration`, `flags`, `ip`, `city`, `region`, `country`, `country_code`, `country_code3`, `premium`, `html_motd_disabled`, `os`
FROM player_analytics_table2;
It's a select + insert with a new ID

Don't forget to backup first.
theChaosCoder is offline
Schpraaankiii
Veteran Member
Join Date: Dec 2009
Location: Sweden Norrköping
Old 08-10-2016 , 08:30   Re: [ANY] Player Analytics
Reply With Quote #308

Quote:
Originally Posted by theChaosCoder View Post
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
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)
__________________
CAOSK-ESPORTS.COM

Last edited by Schpraaankiii; 08-10-2016 at 08:38.
Schpraaankiii is offline
Send a message via Skype™ to Schpraaankiii
iGANGNAM
AlliedModders Donor
Join Date: Sep 2012
Location: Lithuania
Old 08-10-2016 , 11:19   Re: [ANY] Player Analytics
Reply With Quote #309

This plugin works perfectly with auto inviter
__________________

Last edited by iGANGNAM; 08-10-2016 at 11:19.
iGANGNAM is offline
mazdarx8
Veteran Member
Join Date: Aug 2014
Old 08-10-2016 , 12:00   Re: [ANY] Player Analytics
Reply With Quote #310

edited

Last edited by mazdarx8; 08-10-2016 at 12:01.
mazdarx8 is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 11:55.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode