Raised This Month: $153 Target: $400
 38% 

[ANY] Player Analytics


Post New Thread Reply   
 
Thread Tools Display Modes
Stropy
Member
Join Date: Feb 2016
Old 07-04-2017 , 03: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 , 10: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 , 23: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
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 05:36.


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