Raised This Month: $150 Target: $400
 37% 

[ANY] Player Analytics


Post New Thread Reply   
 
Thread Tools Display Modes
theChaosCoder
Junior Member
Join Date: Oct 2015
Old 08-25-2016 , 04:29   Re: [ANY] Player Analytics
Reply With Quote #321

@Dr. McKay
Is it possible to add the duration to the error log too, so I have a chance to update it myself?

Code:
L 08/22/2016 - 09:36:16: [player_analytics.smx] Unable to update row 706364. Can't connect to MySQL server
theChaosCoder is offline
AeroAcrobat
AlliedModders Donor
Join Date: Apr 2011
Location: lives in a circus
Old 10-18-2016 , 17:30   Re: [ANY] Player Analytics
Reply With Quote #322

Code:
L 10/15/2016 - 13:19:18: [player_analytics.smx] Unable to insert row for client ∃ ∧ ∠ ∨ ∩ ⊂ ⊃ ∪<190><[U:1:317444635]><>. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
Code:
L 10/15/2016 - 16:50:04: [player_analytics.smx] Unable to insert row for client фредди фазбеар<685><[U:1:238670530]><>. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''Windo' at line 1
__________________

Last edited by AeroAcrobat; 10-18-2016 at 17:36.
AeroAcrobat is offline
September
Member
Join Date: Jul 2015
Location: Russian Federation
Old 10-19-2016 , 22:57   Re: [ANY] Player Analytics
Reply With Quote #323

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

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
Old 11-10-2016 , 13:06   Re: [ANY] Player Analytics
Reply With Quote #325

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

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

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

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

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

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
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 21:52.


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