[INACTIVE][INFO] Statistician V1.3 - Extremely Detailed Player/Server Stats Tracking [953]

Yes my webserver can connect to my db now, try it out https://pimpen.no-ip.org/statistik
be patient it loads really slow and the language is swedish =P

I had to change this in php.ini to btw, the changes i made are in red.
for some reason the webportal did not seem to use statisticians config.php

Oh and for your information, im a noob when it comes to webservers and MySQL so im changing one setting, restart and try to connect, then just repeat the steps =P Im hitting in the dark if i can say it like that =P

One thing i know is that it is a bad idea to set the passwords here but this way was the only way i could get it to work for me =(

Code:

[MySQL]
; Allow accessing, from PHP's perspective, local files with LOAD DATA statements
; http://php.net/mysql.allow_local_infile
mysql.allow_local_infile = On

; Allow or prevent persistent links.
; http://php.net/mysql.allow-persistent
mysql.allow_persistent = On

; If mysqlnd is used: Number of cache slots for the internal result set cache
; http://php.net/mysql.cache_size
mysql.cache_size = 2000

; Maximum number of persistent links.  -1 means no limit.
; http://php.net/mysql.max-persistent
mysql.max_persistent = -1

; Maximum number of links (persistent + non-persistent).  -1 means no limit.
; http://php.net/mysql.max-links
mysql.max_links = -1

; Default port number for mysql_connect().  If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
; at MYSQL_PORT.
; http://php.net/mysql.default-port
mysql.default_port = 3306

; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
; http://php.net/mysql.default-socket
mysql.default_socket = "MySQL"

; Default host for mysql_connect() (doesn't apply in safe mode).
; http://php.net/mysql.default-host
mysql.default_host = [COLOR=rgb(255, 0, 0)]my internal ip-adress here (since im behind a router)[/COLOR]

; Default user for mysql_connect() (doesn't apply in safe mode).
; http://php.net/mysql.default-user
mysql.default_user = [COLOR=rgb(255, 0, 0)]my user here [/COLOR]

; Default password for mysql_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
; and reveal this password!  And of course, any users with read access to this
; file will be able to reveal the password as well.
; http://php.net/mysql.default-password
mysql.default_password = [COLOR=rgb(255, 0, 0)]my pass here[/COLOR]

; Maximum time (in seconds) for connect timeout. -1 means no limit
; http://php.net/mysql.connect-timeout
mysql.connect_timeout = 30

; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
; SQL-Errors will be displayed.
; http://php.net/mysql.trace-mode
mysql.trace_mode = On

Here is the translated locale file btw!

 

Unfortunately I don't have a php.ini file, I am using a database hosted on freemysql.net, so not sure how I would configure that.

EDIT: Nevermind, I do have a php.ini file, I was a bit confused as to where it was.

 

Can this be used if your minecraft server is physically separate from your web/db server?

 

Yes it can, i have one server for MySQL and web, and one server for minecraft =)

 

Man, still gives me the "could not acquire connection" error after editing the php.ini file. This thing just does not want to work for me

 

This plugin rocks! My server members like it, and I absolutely love it! I love to see how many countless hours I have made go to waste in the form of other players playing my server. We are well past a years worth and I only just started using the plugin. Well done!

 

hey if you refer to Pimpen104's post up a bit that fixed the could not acquire connection, the default location for those files just isn't readable for some reason. Simply create a sub folder and drop those 4 in it then adjust statistician.php accordingly.

 

That's what I tried before, it didn't work either. I have "_playerObj.php", "_serverObj.php", "config.php", and "query_utils.php" in a new folder called "test", and I edited "statistician.php" to point to the new folder, and it still doesn't work. Now I tried putting my database information directly into the "php.ini" file and that also didn't work.

What I hate most of all is the fact that it doesn't tell you what exactly went wrong. All it says is it could not acquire connection to the database. So, could it not find the host, is the username/password wrong, is something blocking it from accessing it, is a file missing or wrongly formatted? It tells you absolutely nothing which makes this near impossible to troubleshoot.

 

I just thought of something!
Is it possible for you to install your webserver on a different partition?
Pengh up there are saying that the files could not be read.
on C:/ the security somehow are a bit higher than other partitions, maybe if you install your webserver on D:/ or something else, just not C:/.
I don't want to whine about this plugins since it's an awesome plugin, but! it seems to have problems that other plugins that use DB's don't =(

 

That's actually a good idea, I would be able to try that if I had more than 1 partition. I do have an external hard drive though, I wonder if I could install it on that and try it. Either way I'm in school right now, I'll definitely try it when I get home.

Tried it installed on my external hard-drive, same error. Of course, why am I not surprised.

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Seems slow to me. About 5 seconds to load a page.

 

Ok heres my problem cause i now have spent a days worth of time trying to get this to work... I have done mysql update and its now 5.5.15. i have bukkit ver 1000 here is my config :

Code:

database_name: mc_statistician
database_address: localhost
database_username: root
database_password: blarg
database_port: 3306
database_update_time: 120

i get this error on start up:

Code:

13:48:53 [INFO] [Statistician] Critical Error, could not connect to mySQL. Is th
e database Available? Check config file and try again.
13:48:53 [SEVERE] Error occurred while disabling Statistician v1.3 (Is it up to
date?): null
java.lang.NullPointerException
        at com.ChaseHQ.Statistician.StatisticianPlugin.onDisable(StatisticianPlu
gin.java:43)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:128)
        at org.bukkit.plugin.java.JavaPluginLoader.disablePlugin(JavaPluginLoade
r.java:899)
        at com.ChaseHQ.Statistician.StatisticianPlugin.onEnable(StatisticianPlug
in.java:72)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
.java:878)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
r.java:272)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:162)
        at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:146
)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:284)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:271)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:148)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:335)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)

Don't tell me to increase my thread_stack cause its already at 512k.. Also I'm using ROOT. mcMMO is having no problem with MySQL cause its working just fine as is. This all happened after i did a clean wipe of the Statistician database cause it wasn't even creating any data other than config. I have gone over everything Multiple times and root does have full access to the privileges.

EDIT: Just a thought but do i need to downgrade MySQL to 5.1.x? Its starting to seem more like an incompatibility.

UPDATE: I downgraded to MySQL 5.1.53 and everything is working fine. There is some sort of Incompatibility with 5.5.x.. Hope this fixes alot of peoples problems cause it did for me. Please let people know in the first post that it will not work with that version.

 

I know you are working on the API documentation, but if I could have a little snippet of php code to get total kills and total deaths of a player, that would be great. I am a php noob so this would be much appreciated

 

Is that total deaths altogether? Or separated by PVP and PVE?

Check out https://github.com/ChaseHQ/Statistician_Web/blob/master/statistician/_playerObj.php#L394

That'll list player deaths by another player but the SQL is easily changed to total detaths.

SELECT * FROM kills WHERE killed_uuid = '{playerUUID}'

The number of rows returned will be total deaths.

 

This plugin is awesome, and has been working very well for me so far! Would it be possible to enable the monitoring of things like memory used and such? I would like to be able to track my memory usage with respect to number of players online. I figure since this is already gathering me so much other data, it may be a good fit.... Maybe?

Thank You!

 

I would like the total kills (PVP or PVE) of a player as well as total deaths from all sources.

 

Code:

15:30:41 [INFO] [Statistician] Version 1.3 By ChaseHQ Starting Up...
15:30:41 [SEVERE] Error occurred while enabling Statistician v1.3 (Is it up to d
ate?): java.lang.Integer cannot be cast to java.lang.String
java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.Stri
ng
        at com.ChaseHQ.Statistician.Config.Config.<init>(Config.java:76)
        at com.ChaseHQ.Statistician.Config.Config.getConfig(Config.java:33)
        at com.ChaseHQ.Statistician.StatisticianPlugin.onEnable(StatisticianPlug
in.java:65)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
.java:878)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
r.java:272)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:162)
        at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:146
)
        at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:380)
        at org.bukkit.command.SimpleCommandMap$ReloadCommand.execute(SimpleComma
ndMap.java:281)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:12
9)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:3
20)
        at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.
java:713)
        at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:677)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:670)
        at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
        at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:85)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:451)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)

 

Darn I really hope Chase didn't give this up this is one of the most amazing plugins I've ever seen.

 

I really do love this plugin. It's amazing. Why is it [INACTIVE]?

 

because the topic was not updated for already two RBs 1000 and 1060. even if it works, nobody can expect forum staff to test every plugin

 

Yeah he hasn't been on in 17-18 days? I'd say its pretty close to inactive! ,
I'd love to take up the reins on this one though!

 

Pffft. This is broken for big servers. And the dev hasnt been heard from for weeks. Had potential.

 

Well I did a fork, I'm going to try to keep it alive. I have avery large serve 150+ players, and yes it is broken -.-. I want to leverage the potential here anyway, so expect an update in the next few days. I've already redone the API and made it modular, take a look on how I integrated it on my website: http://www.mmominecraft.com/beta/ Specifically go to members and click on their profiles. (In-Game Stats). I've also got a tag cloud swf player list. It's great.

Anyway, hope I can fix this!

 

When you say 150+ you mean total players? I put 8000 unique players on this plugin in 20 days. 1 1/2 years of total play time. It was taking the php script like 3-4 minutes to query the DB.

I misspoke it was 6894 I put the page back up without the plugin running http://punchtrees.monstercraft.org/Stats/?view=main

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Oh registered players, yeah he does not know php very well it seems. That's the new sight, but we have 20k+ registered players. With my new API no problem. I want to make the plugin log seperate stats instead of using the API to render global stats, I hate the idea of grabbing all of the players to get a specific stat, really redundant.

Look how rediclious that is! 134217728 bytes???
For example: Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 32 bytes) in /var/www/html/Stats/statistician/query_utils.php on line 9

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Yea, I took it back down because it takes the MySQL process to like 450%

When I asked about registered players I was refering to "on the stats page"
It is horribly inefficient after about 1000 registered players as you can see.

I have recently switched to Hawkeye for rollbacks, He has a web page for queries....
Holds most of the same info and is like 400000 times faster.

 

Well Ill see what I can do on this pluigin! Like I said thank's for letting me know about your trifes!

 

Thanks for trying to keep this alive!! Hope all goes well, if you need help testing, please let me know!

 

Anything new yet on this plugin? im watching this thread and i hope you can do anything with it =D

 

Ya I hope this gets picked up by someone... I love it! Unfortunately... I have enough going on with server administration.. I would never have time to do it justice in keeping it going...