Raised This Month: $256 Target: $400
 64% 

[ANY] Player Analytics


Post New Thread Reply   
 
Thread Tools Display Modes
Stropy
Senior Member
Join Date: Feb 2016
Old 07-04-2017 , 02:41   Re: [ANY] Player Analytics
Reply With Quote #331

Quote:
Originally Posted by Jillchang View Post
If there is any way to show mysql data of city's or state's of this plugin into a map by city or state for this web portal, please do. I'm willing to pay if needed.
Use this
Stropy is offline
mlov420
Senior Member
Join Date: May 2013
Old 10-05-2017 , 09:19   Re: [ANY] Player Analytics
Reply With Quote #332

Hey guys, I was having the same AJAX error that everyone else was having when attempting to use the Players or Staff tabs (Error that sent you here: https://datatables.net/manual/tech-notes/7) and figured out a solution, so I wanted to share.

For starters, it appears the file /inc/server_processing.php was causing a 404 error, which in turn made DataTables put off an error. The datatables.net page that it links to does not really offer a solution, only ideas to point you in a direction. So I searched for why a php file that exists would put off a 404 error, which indicates a file does not exist. Apparently, the problem here is occurring because the server_processing.php file is creating a URL that is longer than stock web hosting setups allows (you can see this insanely long URL by looking at the developer tab in your browser).

Solution:

*Please note that I have only tested this in IIS on Windows 2012 R2.

Microsoft IIS Page for referencing Information: https://docs.microsoft.com/en-us/iis...requestLimits/

1. Go to IIS Manager, select your domain
2. Go into "Request Filtering"
3. On the right side, select "Edit Feature Settings"
4. At first, my defaults were shown as:

Code:
Allow Unlisted File name extensions: Checked
Allow Unlisted verbs: Checked
Allowed high-bit characters: Checked
Allow double escaping:: unchecked

Maximum allowed content length (bytes): 30000000
Maximum URL Length (bytes): 4096
Maximum String Length (bytes): 2048
I doubled the last two lines, changing them to the following:

Code:
Maximum URL Length (bytes): 8192
Maximum String Length (bytes): 4096
I am no longer receiving the AJAX error and all pages are functioning correctly. This is on AChaosCoder's version, but this fix should also work on Sinclair's version as well, since it's putting out the same error.

ALTERNATIVELY, you can do this same thing a bit more simply by going into your web.config file and adding the following:

Code:
<security>
            <requestFiltering>
                <requestLimits maxUrl="8192" maxQueryString="4096" />
            </requestFiltering>
        </security>
Hopefully this will help some people who are having the problem. Thank you to Dr.Mckay, Sinclair, ChaosCoder, and everyone else who has helped contribute to this awesome plugin.
mlov420 is offline
Jillchang
Senior Member
Join Date: Mar 2014
Old 10-29-2017 , 22:36   Re: [ANY] Player Analytics
Reply With Quote #333

Quote:
Originally Posted by Stropy View Post
Use this
Is that one different from the one I'm using? The one I use only shows by country not by state or city like I need.
Jillchang is offline
Ejziponken
AlliedModders Donor
Join Date: Apr 2008
Old 01-25-2018 , 20:29   Re: [ANY] Player Analytics
Reply With Quote #334

Anyone have a better or updated version of the webpanel? There is so much data, feels like they are lacking some in features.
__________________
Ejziponken is offline
lugui
Senior Member
Join Date: Feb 2016
Location: Brasil
Old 01-25-2018 , 21:27   Re: [ANY] Player Analytics
Reply With Quote #335

I just noticed that the plugin have some trouble dealing with local IP adresses.

I attached a picture showing a pice of a table that contain some of my servers. sometimes it register the external address, and others, it register the local adress. All the servers are on the same host, but running on different ports
Attached Thumbnails
Click image for larger version

Name:	Screenshot_1.png
Views:	130
Size:	10.2 KB
ID:	168145  

Last edited by lugui; 01-25-2018 at 21:28.
lugui is offline
Wolfseye
Senior Member
Join Date: Apr 2014
Location: Germany
Old 01-26-2018 , 20:48   Re: [ANY] Player Analytics
Reply With Quote #336

I tried to install the following Webpanel (which was linked in one of the recent posts here), and I got a couple issues, that prevent me from actually seeing the Data of the Server/s.

Here are the issues.

Anyone know what to do about those ?

Thanks.

Wolf

P.S: Seems that issue has been adressed here before, but I dont find any solution.

https://forums.alliedmods.net/showpo...&postcount=310
Attached Thumbnails
Click image for larger version

Name:	firefox_2018-01-27_02-42-07.png
Views:	106
Size:	10.6 KB
ID:	168160  
Attached Images
File Type: jpg InkedInkedchrome_2018-01-27_02-44-36_LI.jpg (81.6 KB, 73 views)

Last edited by Wolfseye; 01-27-2018 at 05:56.
Wolfseye is offline
Send a message via Skype™ to Wolfseye
Wolfseye
Senior Member
Join Date: Apr 2014
Location: Germany
Old 01-27-2018 , 11:06   Re: [ANY] Player Analytics
Reply With Quote #337

In case anyone else has / had the same issues with the webpanel, at least the one I used from "theChaosCoder", this is what helped me. I got that from a reply on his end on Github.

Code:
It's a configuration problem on your end. You need to allow write permission for the folder /cache/SQL.
Code:
There are many tuts out there for this.
But for a quick test you could try to change the cache location

From
FileSystemCache::$cacheDir = $dir.'/../cache';
To
FileSystemCache::$cacheDir = '/tmp/player_analytics';

in app.php
https://github.com/theChaosCoder/player_analytics/blob/master/inc/app.php#L34
He replied twice on my issues, you see both replies above. For me, the first solution did it. Just in case more having the same issue.
Wolfseye is offline
Send a message via Skype™ to Wolfseye
BraveFox
AlliedModders Donor
Join Date: May 2015
Location: Israel
Old 02-03-2018 , 16:45   Re: [ANY] Player Analytics
Reply With Quote #338

Hey,
I have a problem with the webpanel, when I press on the players list I get this error:
Quote:
DataTables warning: table id=players - An SQL error occurred: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'csgotimes.player_analytics.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Any solution?
__________________
My Site
My Public Plugins
Donate Me
Contact Me:
Steam: S4muRaY'
Taking Private Requests
Develop SourcePawn, HTML, PHP
BraveFox is offline
paulo_crash
AlliedModders Donor
Join Date: May 2016
Location: Brazil
Old 02-03-2018 , 20:39   Re: [ANY] Player Analytics
Reply With Quote #339

Would you like to know if this is the most up-to-date version of Plugin and Web Interface?

If not where can I get the most current and stable version?
__________________
ABOUT-ME
Owner ZK Servidores

paulo_crash is offline
Send a message via Skype™ to paulo_crash
Ejziponken
AlliedModders Donor
Join Date: Apr 2008
Old 02-04-2018 , 20:16   Re: [ANY] Player Analytics
Reply With Quote #340

Anyway to get webpanel show public IP not the UDP?
__________________
Ejziponken 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 01:51.


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