Statistics

Table of Contents

This project is abandoned and its default file will likely not work with the most recent version of Minecraft. Whether this project is out of date or its author has marked it as abandoned, this project is no longer maintained.

Plugin is not in development any more. Sorry for any inconveniences...

[ Installation | Configuration | Wiki ]

Looking for a high-end plugin that tracks your players' data? Look no further!

There are a few similar plugins out there, and they track a decent amount of data, however, Statistics takes it a step further and completely overhauls the stats tracking, bringing the amount of information collected to a staggering amount. Name a data point, and we are probably tracking it. This plugin was made to be highly customizable; it will do only what you tell it to do.

Features:

Server Statistics:

Startup and shutdown times
Current server status
Uptime statistics
Total gameplay
Online players
.... and more!

World Statistics:

Distance Travelled
PVP, PVE, natural deaths
Blocks played and broken
Items picked up, dropped, used, eaten, etc.
.... and more!

Player Statistics:

Player inventory
Health, hunger, experience
Armour rating
Game mode
Words said, command sent
Login and logout times
Time spent on the server
Distance travelled
Detailed kills and deaths
... and more!

Plugin Statistics:

Vault (Money, Groups)
... more coming soon!

Others:

All Statistics are displayed on an homepage
Statistics can be displayed ingame on an scoreboard
Statistics can be displayed ingame in an Book

Requirements:

PHP 5.3.2 or greater
- GD2 library
- cURL library
- fsockopen

MySQL 5.5 or greater
- InnoDB support
- remote connections allowed

Comments

_ForgeUser7781625
- Join Date: 10/29/2011
- Posts: 455
- Member Details
#687 _ForgeUser7781625

View User Profile

Send Message

Posted Jun 4, 2014
@fafler

Yes It can be fixed ;). Can you please create an ticket with all the information's please.

I'll probably fix it this weekend, but i have to finish the bungee cord support, track multiple server in the same tables (equal prefix) so they appears as one big server on the portal, first.

Rollback Post to Revision RollBack

_ForgeUser9633014

Join Date: 9/16/2012
Posts: 23
Member Details

#686 Posted Jun 4, 2014

Hi. I'm trying to have several servers with Statistics connecting to the same database, with different prefixes, but it doesn't seem to work.

The first prefix I tried works alright with all servers (although the data itself is useless), but changing the prefix in config.yml while connecting to the same database gives me this:

[21:52:49 INFO]: [Statistics] Enabling Statistics v1.2.2
[21:52:49 INFO]: [Statistics] +------ [ Fetching Patches ] ------+
[21:52:49 INFO]: [Statistics] |  All patch files are up to date  |
[21:52:49 INFO]: [Statistics] +----------------------------------+
[21:52:49 INFO]: [Statistics] Current version: 0, latest version: 11
[21:52:49 INFO]: [Statistics] +-------] Database Patcher [-------+
[21:52:49 INFO]: [Statistics] |       Applying patch 1 / 11       |
[21:52:49 INFO]: [Statistics] |       Applying patch 2 / 11       |
[21:52:49 ERROR]: [Statistics] Cannot establish a database connection!
[21:52:49 ERROR]: [Statistics] Is the plugin set up correctly?
[21:52:49 WARN]: An error occured while executing database patch: 2.yaspx.sql
[21:52:49 WARN]: 	at com.wolvencraft.yasp.db.Database.executePatch(Database.java:201)
[21:52:49 WARN]: 	at com.wolvencraft.yasp.db.Database.patchDatabase(Database.java:129)
[21:52:49 WARN]: 	at com.wolvencraft.yasp.db.Database.<init>(Database.java:82)
[21:52:49 WARN]: 	at com.wolvencraft.yasp.Statistics.onEnable(Statistics.java:121)
[21:52:49 WARN]: 	at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:250)
[21:52:49 WARN]: 	at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:350)
[21:52:49 WARN]: 	at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:390)
[21:52:49 WARN]: 	at org.bukkit.craftbukkit.v1_7_R1.CraftServer.loadPlugin(CraftServer.java:460)
[21:52:49 WARN]: 	at org.bukkit.craftbukkit.v1_7_R1.CraftServer.enablePlugins(CraftServer.java:380)
[21:52:49 WARN]: 	at net.minecraft.server.v1_7_R1.MinecraftServer.m(MinecraftServer.java:348)
[21:52:49 WARN]: 	at net.minecraft.server.v1_7_R1.MinecraftServer.g(MinecraftServer.java:325)
[21:52:49 WARN]: 	at net.minecraft.server.v1_7_R1.MinecraftServer.a(MinecraftServer.java:281)
[21:52:49 WARN]: 	at net.minecraft.server.v1_7_R1.DedicatedServer.init(DedicatedServer.java:186)
[21:52:49 WARN]: 	at net.minecraft.server.v1_7_R1.MinecraftServer.run(MinecraftServer.java:437)
[21:52:49 WARN]: 	at net.minecraft.server.v1_7_R1.ThreadServerApplication.run(SourceFile:617)
[21:52:49 WARN]: Caused by: Error executing: CREATE  TABLE IF NOT EXISTS `stats`.`thisshouldwork_detailed_log_players` (
  `detailed_log_players_id` INT NOT NULL AUTO_INCREMENT ,
  `player_id` INT NOT NULL ,
  `time` INT(11) NOT NULL ,
  `world` VARCHAR(255) NULL DEFAULT NULL ,
  `x` INT NULL DEFAULT NULL ,
  `y` INT NULL DEFAULT NULL ,
  `z` INT NULL DEFAULT NULL ,
  `is_login` TINYINT(1) NULL DEFAULT 1 ,
  PRIMARY KEY (`detailed_log_players_id`) ,
  INDEX `fk_player_id4_idx` (`player_id` ASC) ,
  CONSTRAINT `fk_player_id4`
    FOREIGN KEY (`player_id` )
    REFERENCES `stats`.`thisshouldwork_players` (`player_id` )
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
.  Cause: java.sql.SQLException: Can't create table 'stats.thisshouldwork_detailed_log_players' (errno: 121)
[21:52:49 WARN]: 	at com.wolvencraft.yasp.db.ScriptRunner.runScript(ScriptRunner.java:120)
[21:52:49 WARN]: 	at com.wolvencraft.yasp.db.Database.executePatch(Database.java:200)
[21:52:49 WARN]: 	... 14 more
[21:52:49 WARN]: Caused by: java.sql.SQLException: Can't create table 'stats.thisshouldwork_detailed_log_players' (errno: 121)
[21:52:49 WARN]: 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
[21:52:49 WARN]: 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
[21:52:49 WARN]: 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
[21:52:49 WARN]: 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
[21:52:49 WARN]: 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
[21:52:49 WARN]: 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
[21:52:49 WARN]: 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
[21:52:49 WARN]: 	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
[21:52:49 WARN]: 	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
[21:52:49 WARN]: 	at com.wolvencraft.yasp.db.ScriptRunner.executeStatement(ScriptRunner.java:216)
[21:52:49 WARN]: 	at com.wolvencraft.yasp.db.ScriptRunner.handleLine(ScriptRunner.java:178)
[21:52:49 WARN]: 	at com.wolvencraft.yasp.db.ScriptRunner.runScript(ScriptRunner.java:111)
[21:52:49 WARN]: 	... 15 more

Some of the tables is created, but I only got a complete set for the first prefix:

mysql> use stats;
mysql> show full tables;
+------------------------------------+------------+
| Tables_in_stats                    | Table_type |
+------------------------------------+------------+
| blabla_players                     | BASE TABLE |
| blabla_settings                    | BASE TABLE |
| factions_detailed_death_players    | BASE TABLE |
| factions_detailed_destroyed_blocks | BASE TABLE |
| factions_detailed_dropped_items    | BASE TABLE |
| factions_detailed_log_players      | BASE TABLE |
| factions_detailed_pickedup_items   | BASE TABLE |
| factions_detailed_placed_blocks    | BASE TABLE |
| factions_detailed_pve_kills        | BASE TABLE |
| factions_detailed_pvp_kills        | BASE TABLE |
| factions_detailed_used_items       | BASE TABLE |
| factions_distances                 | BASE TABLE |
| factions_entities                  | BASE TABLE |
| factions_hook_factions             | BASE TABLE |
| factions_materials                 | BASE TABLE |
| factions_misc_info_players         | BASE TABLE |
| factions_modules                   | BASE TABLE |
| factions_player_inventories        | BASE TABLE |
| factions_player_locations          | BASE TABLE |
| factions_players                   | BASE TABLE |
| factions_server_statistics         | BASE TABLE |
| factions_settings                  | BASE TABLE |
| factions_total_blocks              | BASE TABLE |
| factions_total_deaths              | BASE TABLE |
| factions_total_items               | BASE TABLE |
| factions_total_pve_kills           | BASE TABLE |
| factions_total_pvp_kills           | BASE TABLE |
| superbusk_players                  | BASE TABLE |
| superbusk_settings                 | BASE TABLE |
| thisshouldwork_players             | BASE TABLE |
| thisshouldwork_settings            | BASE TABLE |
+------------------------------------+------------+
31 rows in set (0.00 sec)

Is there a fix to achieve this without creating a database for each server?

Also, in the configuration example on the wiki, the MySQL port is set to 3308, while the default port is 3306. That just cost me a half an hour of my life to figure out ;-)

_ForgeUser7781625
- Join Date: 10/29/2011
- Posts: 455
- Member Details
#685 _ForgeUser7781625

View User Profile

Send Message

Posted Jun 4, 2014
@Nefretum

All players have the permissions they need to get tracked on default so you don't need any permissions to enable tracking. But you can give negative permission nodes to disable tracking.

The permissions can be found here:

http://dev.bukkit.org/bukkit-plugins/statistics/pages/wiki/permissions/

Rollback Post to Revision RollBack
_ForgeUser15632762
- Join Date: 5/27/2014
- Posts: 3
- Member Details
#684 _ForgeUser15632762

View User Profile

Send Message

Posted May 31, 2014
so uh yeah stupid question. I have added all the perms I could find for the plugin, yet I still cannot use commands in-game...... what perms am I missing>

Rollback Post to Revision RollBack
_ForgeUser13878266
- Join Date: 3/21/2014
- Posts: 10
- Member Details
#681 _ForgeUser13878266

View User Profile

Send Message

Posted May 27, 2014
This awesome Plugin support PixelMon Servers with blocks?

Rollback Post to Revision RollBack
_ForgeUser13556140
- Join Date: 2/14/2014
- Posts: 59
- Member Details
#680 _ForgeUser13556140

View User Profile

Send Message

Posted May 26, 2014
Once I have added a server under the Multi Portal how can I remove it?

Rollback Post to Revision RollBack
_ForgeUser11269990
- Join Date: 5/19/2013
- Posts: 22
- Member Details
#679 _ForgeUser11269990

View User Profile

Send Message

Posted May 26, 2014
@Dazzel_

http://dev.bukkit.org/bukkit-plugins/statistics/tickets/290-error-occurred-how-can-i-fix-it/

Rollback Post to Revision RollBack
_ForgeUser7781625
- Join Date: 10/29/2011
- Posts: 455
- Member Details
#678 _ForgeUser7781625

View User Profile

Send Message

Posted May 25, 2014
@AstramG

At the moment i have lots of work with my server (new lobby, new mingames, ......). As soon all i have finished this things ill start working on statistics again.

Bungee support is already 50% finished ;)

Rollback Post to Revision RollBack
Forge_User_96951799
- Join Date: 3/31/2010
- Posts: 139
- Member Details
#677 Forge_User_96951799

View User Profile

Send Message

Posted May 25, 2014
@AstramG

Both of your ideas are in the works ;)

@QuollCraft

Please post an ticket with more detailed information about your error.

Rollback Post to Revision RollBack
_ForgeUser7673356
- Join Date: 10/8/2011
- Posts: 34
- Member Details
#676 _ForgeUser7673356

View User Profile

Send Message

Posted May 24, 2014
@bitWolfy I'd really like to use this plugin for my aspiring Minigame server. I'm a custom plugin developer myself, and I am suggesting two things for this plugin. Please integrate it with BungeeCord or multi-server support, due to people using this on server networks. Also, it'd be much appreciated to add in an API for developers to add their custom statistics to the plugin.

Rollback Post to Revision RollBack
_ForgeUser11269990
- Join Date: 5/19/2013
- Posts: 22
- Member Details
#675 _ForgeUser11269990

View User Profile

Send Message

Posted May 22, 2014
I get this error when I try to go to a players stats page Sorry. An unexpected error occurred. The table Stats_players is not in a *-to-one relationship with the table Stats_distances Type: fProgrammerException File: /home/quollcr1/public_html/stats/include/vendor/flourish/flourish/fORMSchema.php:181

{doc_root}/stats/index.php(29): Design->display('player.php') {doc_root}/stats/include/classes/Design.php(257): Design->loadModule('player.php') {doc_root}/stats/include/classes/Design.php(144): Module->construct('player.php', Array, Object(Design)) {doc_root}/stats/include/classes/Module.php(41): include('/home/quollcr1/...') {doc_root}/stats/contents/default/player.php(19): Player->createDistance() {doc_root}/stats/contents/default/player.php(19): fActiveRecord->call('createDistance', Array) {doc_root}/stats/include/vendor/flourish/flourish/fActiveRecord.php(1029): fORMRelated::createRecord('Player', Array, Array, 'Distance') {doc_root}/stats/include/vendor/flourish/flourish/fORMRelated.php(393): fORMSchema::getRoute(Object(fSchema), 'Stats_players', 'Stats_distances', NULL, '*-to-one') {doc_root}/stats/include/vendor/flourish/flourish/fORMSchema.php(101): fORMSchema::getRouteName(Object(fSchema), 'Stats_players', 'Stats_distances', NULL, '*-to-one') {doc_root}/stats/include/vendor/flourish/flourish/fORMSchema.php(181)

How do i fix this

Rollback Post to Revision RollBack
Forge_User_36521625
- Join Date: 7/17/2012
- Posts: 168
- Member Details
#674 Forge_User_36521625

View User Profile

Send Message

Posted May 20, 2014
Thanks! I'll check it all out ;].

Rollback Post to Revision RollBack
_ForgeUser7781625
- Join Date: 10/29/2011
- Posts: 455
- Member Details
#673 _ForgeUser7781625

View User Profile

Send Message

Posted May 20, 2014
@MikeGold

Make sure "Delay Time" is 0 to track all players immediately after join. You can find this in the Database section of the admin panel. On an small server < 30 players you can set the "Database Sync Time" to 60 and you can disable the Page caching. Skins and player search caching don't effect the delay between server and the portal so you should't change them to lower values.

Rollback Post to Revision RollBack
Forge_User_96951799
- Join Date: 3/31/2010
- Posts: 139
- Member Details
#672 Forge_User_96951799

View User Profile

Send Message

Posted May 20, 2014
@MikeGold

You can define the time an player should be logged.

The admin button disappears when the page is cached. Sorry for that ;) Missed that in the latest stable release...

Rollback Post to Revision RollBack
Forge_User_36521625
- Join Date: 7/17/2012
- Posts: 168
- Member Details
#671 Forge_User_36521625

View User Profile

Send Message

Posted May 19, 2014
To be honest I don't mind slow sync, but when someone log in for a short amount of time, build something and log out, it won't catch it. Plus I've noticed that admin login button sometimes is there on the bottom, sometimes it's missing. It's kind of random...

Rollback Post to Revision RollBack
_ForgeUser12575003
- Join Date: 11/8/2013
- Posts: 1
- Member Details
#670 _ForgeUser12575003

View User Profile

Send Message

Posted May 19, 2014
@MikeGold

I had the same issues, the login screen really hides!
Check out down the bottom on the right, next to the giant statistics logo, you should see an admin button.

Log into that, and you will find out how to help increase the speed it updates. Mine was super slow too, but now i've made it a little faster through that.

You'll want to edit portal --> Caching
Database --> Sync

Be careful with low values though like it says, it is a heavy process for it to undertake.

Last edited by _ForgeUser12575003: May 19, 2014

Rollback Post to Revision RollBack
Forge_User_36521625
- Join Date: 7/17/2012
- Posts: 168
- Member Details
#669 Forge_User_36521625

View User Profile

Send Message

Posted May 19, 2014
I've managed to set up everything. I have just one problem. Even though the web portal is tracking everything as it should, it is really slow on updating login information. Sometimes it shows player logged even though he is offline for a while, sometimes it's not showing player as online while he's playing. I managed to log in on my account, then log out and log in as my girlfriend and the portal shown that both of us are online. When I force database update with command, it's only updating things like my equip, but not the online status. Due to that issue, the online stats are suffering as well. I was supposedly online for 15 minutes, while actually I was only online for about 1 minute. I have set up refresh at every 30 sec. during installation, but it's not really working this way. Is it because I'm running server 1.7.9? If there is something that I'm missing, please let me know.

Last edited by Forge_User_36521625: May 19, 2014

Rollback Post to Revision RollBack
_ForgeUser7781625
- Join Date: 10/29/2011
- Posts: 455
- Member Details
#667 _ForgeUser7781625

View User Profile

Send Message

Posted May 19, 2014
@Max633

Can you please create an ticket.

When does this error appear (On every mob kill or only sometimes?)?

Rollback Post to Revision RollBack
_ForgeUser7781625
- Join Date: 10/29/2011
- Posts: 455
- Member Details
#666 _ForgeUser7781625

View User Profile

Send Message

Posted May 19, 2014
@MikeGold

If all required php extensions are enabled this guide should work:

http://dev.bukkit.org/bukkit-plugins/statistics/pages/wiki/installation/

Rollback Post to Revision RollBack
Forge_User_36521625
- Join Date: 7/17/2012
- Posts: 168
- Member Details
#665 Forge_User_36521625

View User Profile

Send Message

Posted May 19, 2014
Is there any chance, that at some point you could do a simple step by step installation guide for people like me, who own the server and don't know a thing about installation or usage of PHP or MySQL, but would like to use your plugin?

Rollback Post to Revision RollBack
To post a comment, please login or register a new account.

Project ID

54143
Created

Mar 18, 2013
Last Released File

Mar 15, 2015
Total Downloads

38,590
License

GNU General Public License ver...

Bukkit

Statistics

Bukkit Plugins

Statistics

Table of Contents

Plugin is not in development any more. Sorry for any inconveniences...

Features:

Server Statistics:

World Statistics:

Player Statistics:

Plugin Statistics:

Others:

Requirements:

Comments

About This Project

Categories

Members

Recent Files

Bukkit