Raised This Month: $12 Target: $400
 3% 

[ANY] Player Analytics


Post New Thread Reply   
 
Thread Tools Display Modes
Pitbull3
AlliedModders Donor
Join Date: Aug 2009
Location: Degree-Gaming.com
Old 01-23-2014 , 09:46   Re: [ANY] Player Analytics
Reply With Quote #41

Quote:
Originally Posted by Dr. McKay View Post
Rewrite your query.
Could you give me a little bit more details about this...???
Pitbull3 is offline
DrFallen
AlliedModders Donor
Join Date: Jul 2013
Location: ./root
Old 01-24-2014 , 19:57   Re: [ANY] Player Analytics
Reply With Quote #42

Hey nice work Pickles on the modded web browser. I noticed it doesn't pick up the server name. Other than that everything works. No random errors.
DrFallen is offline
Pickles47
Member
Join Date: Jun 2013
Old 01-25-2014 , 11:20   Re: [ANY] Player Analytics
Reply With Quote #43

Quote:
Originally Posted by Fearts View Post
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.
You can replace the a few sections with this:
index.php
Spoiler

data/users.php
Spoiler


Quote:
Originally Posted by Pitbull3 View Post
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...
You can add/modify this to fit your needs, it will update connect_method from quickplay_* to quickplay on page load.

PHP Code:
UPDATE 'player_analytics' SET 'connect_method'='quickplay' WHERE `connect_methodLIKE '%quickplay%'" 
added this to my updated panel in sessions.php

Spoiler


Quote:
Originally Posted by DrFallen View Post
Hey nice work Pickles on the modded web browser. I noticed it doesn't pick up the server name. Other than that everything works. No random errors.
I've had this problem too where the table is not being filled with the correct ip at times, instead being filled with 0.0.0.0. Since the server name comes from the recorded ip in config.php, it will be Other.

Last edited by Pickles47; 01-25-2014 at 11:21.
Pickles47 is offline
Pitbull3
AlliedModders Donor
Join Date: Aug 2009
Location: Degree-Gaming.com
Old 01-25-2014 , 11:47   Re: [ANY] Player Analytics
Reply With Quote #44

#1064 - 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 ''player_analytics' SET 'connect_method'='quickplay' WHERE `connect_method` LIKE ' at line 1

This query doesn't seem to work.

Last edited by Pitbull3; 01-25-2014 at 11:47.
Pitbull3 is offline
Pickles47
Member
Join Date: Jun 2013
Old 01-25-2014 , 12:12   Re: [ANY] Player Analytics
Reply With Quote #45

Quote:
Originally Posted by Pitbull3 View Post
#1064 - 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 ''player_analytics' SET 'connect_method'='quickplay' WHERE `connect_method` LIKE ' at line 1

This query doesn't seem to work.
Try this: In sessions.php replace lines 1-44 with
Spoiler


you can also replace ConnMethod in config.php with the following to show Quickplay as a method in the webpanel.

Spoiler
Pickles47 is offline
Pitbull3
AlliedModders Donor
Join Date: Aug 2009
Location: Degree-Gaming.com
Old 01-25-2014 , 12:20   Re: [ANY] Player Analytics
Reply With Quote #46

So this will update whenever a new quickplay player joins? It will update every single quickplay_1-90, quickplay0,1,2... ect?


I was doing this manually....

Code:
update player_analytics set connect_method = replace(connect_method,'quickplay_1','quickplay')

Last edited by Pitbull3; 01-25-2014 at 12:21.
Pitbull3 is offline
Pickles47
Member
Join Date: Jun 2013
Old 01-25-2014 , 12:25   Re: [ANY] Player Analytics
Reply With Quote #47

Quote:
Originally Posted by Pitbull3 View Post
So this will update whenever a new quickplay player joins? It will update every single quickplay_1-90, quickplay0,1,2... ect?


I was doing this manually....

Code:
update player_analytics set connect_method = replace(connect_method,'quickplay_1','quickplay')
Yes, every time the sessions.php is loaded/refreshed all connect_method rows that contain "quickplay" will be changed to just quickplay. You will have to refresh twice to see the change in webpanel, once to update table, again to see results.

It will not do it automatically when a player joins, the code only works when the webpanel page sessions.php is loaded, all instances of quickplay* and quickplay_* will be changed at that time.

Last edited by Pickles47; 01-25-2014 at 12:27.
Pickles47 is offline
Pitbull3
AlliedModders Donor
Join Date: Aug 2009
Location: Degree-Gaming.com
Old 01-25-2014 , 12:26   Re: [ANY] Player Analytics
Reply With Quote #48

Awesome thank you so very much!
Pitbull3 is offline
DrFallen
AlliedModders Donor
Join Date: Jul 2013
Location: ./root
Old 01-25-2014 , 16:21   Re: [ANY] Player Analytics
Reply With Quote #49

Quote:
Originally Posted by Pickles47 View Post
I've had this problem too where the table is not being filled with the correct ip at times, instead being filled with 0.0.0.0. Since the server name comes from the recorded ip in config.php, it will be Other.
Thanks that worked. Any ideas on why Console connect is marked as other.
DrFallen is offline
Pickles47
Member
Join Date: Jun 2013
Old 01-25-2014 , 17:27   Re: [ANY] Player Analytics
Reply With Quote #50

Quote:
Originally Posted by DrFallen View Post
Thanks that worked. Any ideas on why Console connect is marked as other.
Yes, I made this for personal use before people started inquiring about a more complete panel from Dr. McKay. I only looked at the methods I was seeing in my database at the time, so some methods not listed in the config under ConnMethod will show as other. To my knowledge console is left null or empty. Link

Here is an update for config.php adding the 3 missing methods, quickplay, matchmaking and console as a replacement for other:
Spoiler

Last edited by Pickles47; 01-25-2014 at 17:29.
Pickles47 is offline
Reply


Thread Tools
Display Modes

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 12:18.


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