Raised This Month: $344 Target: $400
 86%   Almost there!

[ANY] Player Analytics


Post New Thread Reply   
 
Thread Tools Display Modes
September
Senior Member
Join Date: Jul 2015
Location: Russian Federation
Old 10-19-2016 , 22:57   Re: [ANY] Player Analytics
Reply With Quote #321

Help to make time to spectator was not considered
September is offline
Send a message via Skype™ to September
Fearts
ferts of daeth
Join Date: Oct 2008
Old 10-21-2016 , 01:18   Re: [ANY] Player Analytics
Reply With Quote #322

Quote:
Originally Posted by theChaosCoder View Post
I made some bigger updates again to the webpanel. Added mutli server select, date selection is now globally available. And nearly every sql query uses a connect_date range now, so the performance should be better now on very large tables. Tested with a table of 6 mil records and a selection of 90 days on my small vps.

You also should add an index to connect_date to improve performance (if you're using phpmyadmin, just klick in the "index" link in the structure view of your table. If you receive a 502 timeout, don't worry, mysql is adding the index in the backgroud)

You can futher optimize your large table by adding partitons. use google

Next update will be charts stats charts

p.s. You can now use multiple databases (table name still fixed to "player_analytics". Will change what also later)
download here: https://github.com/theChaosCoder/player_analytics

Edit2: even better, use in addition a combined index: ALTER TABLE player_analytics ADD INDEX (server_ip, connect_date);
Very nice. Would be cool if you added a log in feature to this. Maybe something with Steam's OpenID or something. Basically something to restrict access to only people I want to be able to use this page.
__________________
Fearts is offline
lugui
Senior Member
Join Date: Feb 2016
Location: GetClientAbsOrigin();
Old 11-10-2016 , 13:06   Re: [ANY] Player Analytics
Reply With Quote #323

The duration of the session is set in minutes or seconds?
lugui is offline
Dr. McKay
Sir Dr. SourceMod Plugin Approver Esq. Ltd. M.D. PhD
Join Date: Aug 2011
Location: Atlantis
Old 11-11-2016 , 21:12   Re: [ANY] Player Analytics
Reply With Quote #324

Seconds.
__________________
Dr. McKay is offline
Thorlax
Junior Member
Join Date: May 2008
Location: Sweden
Old 03-28-2017 , 09:29   Re: [ANY] Player Analytics
Reply With Quote #325

Hi all,

I'm getting this error on server launch with this plugin, I feel like I'm missing a simple step with the mysql setup. I have the database created on my mysql server and have verified connection to the dbase with mysql workbench. Here's the log from my server on startup,

[SM] Unable to load extension "dbi.mysql.ext": libz.so.1: cannot open shared object file: No such file or directory
L 03/28/2017 - 08:49:41: [SM] Failed to load plugin "player_analytics.smx": Driver "mysql" not found.

Here's my database.cfg from my SM folder,

Quote:
"Databases"
{
"driver_default" "mysql"

// When specifying "host", you may use an IP address, a hostname, or a socket file path

"player_analytics"
{
"driver" "mysql"
"host" "r**0.*****.net"
"database" "******_plyanalytics1"
"user" "********_wizstats1"
"pass" "***"
"timeout" "0"
"port" "3306"
}

"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}

"clientprefs"
{
"driver" "sqlite"
"host" "localhost"
"database" "clientprefs-sqlite"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}
}

The dbi.mysql.ext is located in the correct SM folder. The server is Debian Jessie running newest security updates. Thanks in advance for your time!
__________________


Thorlax is offline
Send a message via Skype™ to Thorlax
asherkin
SourceMod Developer
Join Date: Aug 2009
Location: OnGameFrame()
Old 03-28-2017 , 09:49   Re: [ANY] Player Analytics
Reply With Quote #326

Quote:
Originally Posted by Thorlax View Post
[SM] Unable to load extension "dbi.mysql.ext": libz.so.1: cannot open shared object file: No such file or directory
https://www.google.co.uk/search?q=[S...alliedmods.net
__________________

Last edited by asherkin; 03-28-2017 at 09:49.
asherkin is offline
Thorlax
Junior Member
Join Date: May 2008
Location: Sweden
Old 03-28-2017 , 17:29   Re: [ANY] Player Analytics
Reply With Quote #327

Got it, forgot to install 32bit req. libraries. Whelp!
__________________


Thorlax is offline
Send a message via Skype™ to Thorlax
Jillchang
Senior Member
Join Date: Mar 2014
Old 06-15-2017 , 14:27   Re: [ANY] Player Analytics
Reply With Quote #328

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.

Last edited by Jillchang; 06-15-2017 at 14:27.
Jillchang is offline
Stropy
Senior Member
Join Date: Feb 2016
Old 07-04-2017 , 02:41   Re: [ANY] Player Analytics
Reply With Quote #329

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 #330

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
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 02:02.


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