Stats 2.0
Welcome to Stats 2.0!
Most of you know Stats, it's one of the oldest and most popular tools for logging player actions, statistics and analysis. The original plugin was developed by Nidefawl and i have to thank him for his great work! Thanks to sockenklaus, too, for some improvements.
Features
- Logs many actions that players do!
- Block Destroys(for each block), Block Placement, Item Uses, Item Dropped, Item Piuckup, Damage Dealt, Damage Taken, Deaths per type, Kills per type, Played-Time (with AFK flags!)...
- Keeps all stats within a MySQL Database or Flatfile
- Your plugin can support Stats!
- NEW Crafting activities
Requirements
- Spout (Crafting)
Installation
- New directory since 2.1.0
- Put the Stats.jar inside your plugin folder
- Start the server / Stop the server
- Edit the config file to fit your needs
- Start the server
- Enjoy!
Permissions
- Stats.show.stats - View your own stats
- Stats.show.played - View your own played-time
Changelog
ToDo
- log Furnace-Events
- optimize Stats-commands
@Patrick_Janson
No my mistake ... sry!
It's inside the stats.properties inside the Stats folder.
Let's see:
sql-db: jdbc:mysql: is fix
localhost:3306 you can change this to a remote host: my.example.com:4567
Remote isn't a good idea, this could really slowdown.
/minecraft that's the database
Well, that might be a problem :p I dont have that file :s
@Patrick_Janson
Look in your root-directory where craftbukkit.jar is stored. There should be y mysql.properties That's the config file of Stats. I know i know ... why there? I don't know, i just saved this plugin out of inactivity. There could a lot get optimized -_-
When ever I set it to use mysql and not sqlite, All I get is errors.. Any idea of why? You do need to change this for Webstatistics .. right? And how do you link this plugin to a remote database (is it posible?) I have tried to get this working together for 3-4 hours now.. Cant figure out what im doing wrong :s
@TerraNetworkOrg
Nice man! Is there maybe a reload command?
@Drumpie
No i don#t think i can handle this ingame. I planned this feature for my Webstatistics, that are based on Stats&Achievements.
@TerraNetworkOrg
Oke nice. It already works.
Can you answer my reqeust perhaps?
Thanks!
@Drumpie
Stats isn't written to handle PEX permissions or BukkitPerms or Permssions 3.x It uses Vault to handle every permission Plugin that's supported by Vault.
@subflame11
Yes i can change/add some aliases.
@bassbeast83
It's a problem with your database. Can you check it?
Nevermind I already installed it.
I have a request tho, is it possible to make like a Top 10 list or something like that? It would be nice if I can update my players every 2 weeks with a top 10 list of every category and how much they build/broke/walked/killed etcetera. Maybe also a export to .txt function or something.
Overall a very nice plugin.
Thanks!
@TerraNetworkOrg
But I have PermissionEX. What is Vault doing for the permissions?
Hello ive recently installed your plugin on my server and we also have MCMMO and when we do /stats it tells us your plugins stats instead of mcmmo ones. could you please change something with that command to maybe /stat instead of /stats? since mcmmo uses the same thing.
@Drumpie
It's required for the permissions, but i will do an upgrade soon working without permissions.
Why is Vault required? I have Spout but I don't need Vault because I don't use an iConomy plugin.
@earthiverse
Will readd this feature, but with Bukkit-names, so we don't have to modify it with new materials.
Would it be possible for someone to create a script that adds all the previous version's block names total to the corresponding block id numbers and then removes the old totals?
I dunno quite what this means but maybe you can help.
2011-12-19 17:57:07 [SEVERE] [Stats 2.0.1] SQL exception: Unknown column 'player' in 'where clause' 2011-12-19 17:57:07 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'player' in 'where clause' 2011-12-19 17:57:07 [SEVERE] at sun.reflect.GeneratedConstructorAccessor83.newInstance(Unknown Source) 2011-12-19 17:57:07 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) 2011-12-19 17:57:07 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source) 2011-12-19 17:57:07 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) 2011-12-19 17:57:07 [SEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:382) 2011-12-19 17:57:07 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) 2011-12-19 17:57:07 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593) 2011-12-19 17:57:07 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525) 2011-12-19 17:57:07 [SEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986) 2011-12-19 17:57:07 [SEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140) 2011-12-19 17:57:07 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) 2011-12-19 17:57:07 [SEVERE] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111) 2011-12-19 17:57:07 [SEVERE] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407) 2011-12-19 17:57:07 [SEVERE] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325) 2011-12-19 17:57:07 [SEVERE] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310) 2011-12-19 17:57:07 [SEVERE] at com.nidefawl.Stats.datasource.PlayerStatSQL.save(PlayerStatSQL.java:39) 2011-12-19 17:57:07 [SEVERE] at com.nidefawl.Stats.datasource.PlayerStatSQL.save(PlayerStatSQL.java:107) 2011-12-19 17:57:07 [SEVERE] at com.nidefawl.Stats.Stats.unload(Stats.java:669) 2011-12-19 17:57:07 [SEVERE] at com.nidefawl.Stats.StatsPlayerListener.onPlayerQuit(StatsPlayerListener.java:29) 2011-12-19 17:57:07 [SEVERE] at org.bukkit.plugin.java.JavaPluginLoader$2.execute(JavaPluginLoader.java:272) 2011-12-19 17:57:07 [SEVERE] at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58) 2011-12-19 17:57:07 [SEVERE] at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:339) 2011-12-19 17:57:07 [SEVERE] at net.minecraft.server.ServerConfigurationManager.disconnect(ServerConfigurationManager.java:161) 2011-12-19 17:57:07 [SEVERE] at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:651) 2011-12-19 17:57:07 [SEVERE] at net.minecraft.server.NetworkManager.b(NetworkManager.java:231) 2011-12-19 17:57:07 [SEVERE] at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:93) 2011-12-19 17:57:07 [SEVERE] at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:550) 2011-12-19 17:57:07 [SEVERE] at net.minecraft.server.NetworkListenThread.a(SourceFile:108) 2011-12-19 17:57:07 [SEVERE] at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:527) 2011-12-19 17:57:07 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:425) 2011-12-19 17:57:07 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:457)
At all with SQL errors. If it helps you for a short while, i can provide you with a version that disables stacktraces (hopefully). I never worked with Java and MySQL before, update and modify Stats was easy, but i have to look, try and learn how the SQL-stuff works and that will need some time (it's christmas and i won't have much time next 10 days ;) ) I can't promise anything, but i will try to rebuild the SQL part.
@ManiacTwister
Should be fixed with 2.0.1.
(Tested it at my server and it works there with 2.0.1)
Of course Achievements 2.0.1, not Stats 2.0.1 :-)
Hey,
Everytime i enter the End and go back to normal World i get this error (on every Move): http://dev.bukkit.org/paste/4433/
@TerraNetworkOrg
Seems quiet on the errors front, but then again it's just myself on the server.