[INACTIVE][INFO] Stats [v0.99] and Achievements [v0.99][1000]

Stats and Achievements

This plugin will be found at dev-bukkit soon
sockenklaus will manage this project in the future (thank you!)

Features:

• Stats
  • Logs many actions that players do!
  • Block Destoys(for each block), Item Uses, Damage Dealt, Deaths per type, Kills per type, Played-Time (with AFK flags!)...
  • '/stats' shows basic stats and more
  • '/played' shows your play-time on the server
  • Keeps all stats within a SQLite or MySQL Database
  • Your plugin can support Stats!

• Achievements
  • Give users achievements when they have completed something!
  • e.g. MintyAnt mined 500 obsidian. Message "You have no life!" Appears, and they recieve the "No Life" achievment and 10 Diamond as a prize
  • Achievement-Conditions:
    • <achievement-name>
    • New in 0.9:
      • group <group-name>
      • permission <permissionstring>
    • can be multiple seperated by ;
    • each of them can have a inverting '!' (!group jailed;!badachievement)
    • can be none of course
  • Reward-Commands:
    • /item <name or id>
    • /money <negative or postive amount>
    • /group <group-name>, /warp <warp-name>
    • New in 0.9: Native console commands:
      • /op *;/time 13500;/god *;/kick *
      • use any console command that works on your console
    • New in 0.9 (GroupManager):
      • addsubgroup <groupname>
      • removesubgroup <groupname>
      • addpermission <permissionstring>
      • removepermission <permissionstring>

Source:

• http://github.com/nidefawl

Download:

Newest (Fix for updated plugins (iConomy, BOSEconomy, Essentials, Permissions 3)​

• Stats v0.99.zip
• Achievements_v0.99.zip

Old (Tested with #617 (works up to 1000!))​

• Stats v0.985.zip (JAR) (Changelog)
• Achievements_v0.982.zip (JAR) (Changelog)

If you still have problems with CraftIRC or iConomy + Achievements try one of the following version:

• Achievements_+_CraftIRC_+_iConomy
• Achievements_+_CraftIRC
• Achievements_+_iConomy

Outdated versions:

• http://dev.craftland.org/wiki/Stats_and_Achievements

Configuration:

• http://dev.craftland.org/wiki/Stats_and_Achievements#Configuration

Permissions for v0.9+:

Show Spoiler Hide Spoiler

Achievements:
achievements.check - only players that have that permissions will be checked + awarded
achievements.view.own - grants access to /achievements (/ach)
achievements.view.list - grants access to /listachievements (/listach)
achievements.admin.check - grants access to /checkachievements (/chekcach)
achievements.admin.reload - grants access to /reloadachievements (/reloadach)

Stats:
stats.log - only actions of players that have that permissions will logged
stats.view.own - allows a player to watch his own stats with the /stats command
stats.view.others - allows a player to watch other players stats with the /stats <player> command
stats.view.playtime - allows a player to watch his play-time with the /played command
stats.admin - grants access to /stats debug + /stats set + /stats list

Latest Changes:

Show Spoiler Hide Spoiler

Stats v0.99

• Fix for Permissions 3.0

Stats v0.985

• Permissions fixed
• Code cleanup
• More settings, to disable logging of some events

Stats v0.98

• Attempt to fix plugin dependencies

Stats v0.972

• Attempt to fix Classpath and Updater... again

Stats v0.96 (03-04-11)

• Forgot to update internal version
• Forgot wolf

Stats v0.95 (03-04-11)

• Updated to latest RB (617)
• Better Permissions/GroupManager plugin handling
• removed the usage of os-specific sqlite libraries. (lets see what happens)

Achievements v0.99

• Fix for newest Economy plugins

Achievements v0.981

• Attempt to fix plugin dependencies
• fixed a typo with the 'achievements-definitions-sql'. Check your config!

Achievements v0.972

• Attempt to fix Classpath and Updater... again

Achievements v0.96 (03-04-11)

• Forgot internal version
• Forgot wolf

Achievements v0.95 (03-04-11)

• Updated to latest RB (617)
• Better warp-command handling for Essentials

full Stats changelog
full Achievements changelog

Supported plugins:

• CraftIRC 2.0 Preview
• iConomy 4.1
• Permission 2.x
• Groupmanager 1.0+
• Essentials

Tools:

• Achievements Generator by scar413
• WebStats by christoph astner
• MineStats by Abadon84
• Convert your achievements.txt to SQL-statements
  
  

Please donate -->

​

Please read the Wiki before posting:

• http://dev.craftland.org/wiki/Stats_and_Achievements

​

 

On b262 console gets spammed with

Code:

SEVERE: Could not pass event PLAYER_MOVE to Stats
java.lang.NullPointerException
        at com.bukkit.nidefawl.Stats.StatsPlayerListener.onPlayerMove(StatsPlayerListener.java:51)
        at org.bukkit.plugin.java.JavaPluginLoader$7.execute(JavaPluginLoader.java:153)
        at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:60)
        at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:213)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:112)
        at net.minecraft.server.Packet10Flying.a(SourceFile:126)
        at net.minecraft.server.NetworkManager.a(SourceFile:232)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:71)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:104)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:283)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:209)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:512)

--- merged: Feb 7, 2011 9:15 PM ---
N/m I had to restart server

 

Webstats 1.3 has been released
for more information please click here

 

well i just realized when someone dies a death notify comes up. I wanted a plugin for this but couldn't find one that just does Deathnotify... So how do we setup the msgs?

all it says now is 'Name was killed by (null)' this happens when i fall and die. same thing with water.

 

Keeps giving me DB errors, funny thing is I had it working, I restarted server to update CraftDispenser (which does not even use DB) and all of a sudden it gives me DB errors for every thing anyone does.

 

Anyway to get these plugins without the need for the Permissions plugin?

 

man, you added permissions plug in too! Could you be any more baller sir

 

will be extended next update

dont know sry, maybe class path of mysql-connector.jar got messed up?

does not need permissions

 

If you *just* want death messages, HeroicDeath does *only* that.

If you want Stats and Achievements as well, I would strongly recommend using this plugin since nidefawl plans to extend support for death messages, and both are not compatible concurrently.

(Using HeroicDeath and Stats+Achievements doesn't /break/ anything per se, you'd just see two lines for every death)

 

My mistake.

Does it support SQLite?

 

I'm no fan of it, but it shouldn't be to hard to add

you can disable it in the stats.properties

 

Stats doesn't count typed characters in HeroChat as it seems. Or is this a known bug?

 

I'm guessing you meant it wouldn't be too hard? If it is too hard, no worries. If not, I'd appreciate it. I already had to use SQLite for Monster Hunt, so I might as well use it again for S+A, if possible.

 

yes i will add it
i had some problems with destroy database files on different plugins (lwc,iconomy) when the server crashed
--- merged: Feb 8, 2011 5:36 PM ---

no sry, might be added

 

I've been using Stat & achievements from the beginning. But if they are going to incorporate this feature then i guess i can wait. I will check out HeroicDeath until this is updated.

 

The plugin can't connect to my mysql server:

The database is named mc_stats, the user mcstats has access to that database, am i doing something wrong here?
I can connect to mysql using any client with the information provided above, and have access to mc_stats db.

This is the error btw:

 

did you create the table?

Code:

CREATE TABLE IF NOT EXISTS `stats` (
  `player` varchar(32) NOT NULL default '-',
  `category` varchar(32) NOT NULL default 'stats',
  `stat` varchar(32) NOT NULL default '-',
  `value` int(11) NOT NULL default '0',
  PRIMARY KEY  (`player`,`category`,`stat`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

Yes, the table is created, in the mc_stats database-

 

maybe the mysql java connector isnt installed?
http://www.mysql.com/downloads/connector/j/

 

I found out the connector wasnt installed (mysql-java package), so i followed this guide: https://help.ubuntu.com/community/JDBCAndMySQL

and logged in and out, echoed $CLASSPATH but i get the same connection could not be established error :/

 

looking forward to it that you will add HeroChat.. thanks

 

I've loaded this on my server, but it just spews out errors on the index page. see the errors here http://server.bossworldmc.com/webstats/index.php
Any idea what I'm doing wrong?

CB Build 254
Stats 0.3c
achivements 0.3b
PHP 5.3.4
Apache 2.2.17
MySQL 5.1.53

 

Could someone point me to where this is documented or help me fill out the missing information here?
I have mysql and all that installed and working with other mods. What I need to know are what the correct configuration lines stats and achievements are looking for when using mysql.

What needs to be in this file? Where does this file go?
bin/mysql.properties

For stats: stats-use-sql = true #use sql db (check bin/mysql.properties)

???-sql-db = jdbc:mysql://localhost:3306/<dbname>
???-sql-pass = <pass>
???-sql-table-stats = stats
???-sql-user = <dbuser>

For achivements: achievements-use-sql = true

???-sql-db = jdbc:mysql://localhost:3306/<dbname>
???-sql-pass = <pass>
???-sql-table-???? = playerachievements
???-sql-user = <dbuser>

 

The file goes in you the same folder as your craftbukkit.jar, it should autogenerate, then you fill in the blanks mine looks like this:

Code:

sql-db = jdbc:mysql://localhost:3306/minecraft2
sql-pass = passwor
sql-table-achievements = playerachievements
sql-table-stats = stats
sql-user = root

Don't forget to create the tables as shown in the wiki here: http://dev.craftland.org/wiki/Stats_and_Achievements

 

When I try to use this plugin it doesn't load, do I need another plugin to get these to work correctly?
Here is the errors I get:

Code:

Feb 10, 2011 11:01:00 PM org.bukkit.plugin.SimplePluginManager loadPlugins
SEVERE: Could not load plugins/Achievements.jar in plugins: null
org.bukkit.plugin.InvalidPluginException
at org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:66)
at org.bukkit.plugin.SimplePluginManager.loadPlugin(SimplePluginManager.java:117)
at org.bukkit.plugin.SimplePluginManager.loadPlugins(SimplePluginManager.java:82)
at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:53)
at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:171)
at net.minecraft.server.MinecraftServer.c(MinecraftServer.java:158)
at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:110)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:209)
at net.minecraft.server.ThreadServerApplication.run(SourceFile:512)
Caused by: java.util.zip.ZipException: invalid END header (bad central directory offset)
at java.util.zip.ZipFile.open(Native Method)
at java.util.zip.ZipFile.(ZipFile.java:127)
at java.util.jar.JarFile.(JarFile.java:135)
at java.util.jar.JarFile.(JarFile.java:99)
at org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:53)
... 8 more
Feb 10, 2011 11:01:00 PM org.bukkit.plugin.SimplePluginManager loadPlugins
SEVERE: Could not load plugins/Stats.jar in plugins: null
org.bukkit.plugin.InvalidPluginException
at org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:66)
at org.bukkit.plugin.SimplePluginManager.loadPlugin(SimplePluginManager.java:117)
at org.bukkit.plugin.SimplePluginManager.loadPlugins(SimplePluginManager.java:82)
at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:53)
at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:171)
at net.minecraft.server.MinecraftServer.c(MinecraftServer.java:158)
at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:110)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:209)
at net.minecraft.server.ThreadServerApplication.run(SourceFile:512)
Caused by: java.util.zip.ZipException: invalid END header (bad central directory offset)
at java.util.zip.ZipFile.open(Native Method)
at java.util.zip.ZipFile.(ZipFile.java:127)
at java.util.jar.JarFile.(JarFile.java:135)
at java.util.jar.JarFile.(JarFile.java:99)
at org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:53)
... 8 more

 

Thank you that is exactly what I needed!

 

I'm not shure why this info isn't posted here, but i got a "java.lang.ClassNotFoundException: com.mysql.jdbc.Driver"
which basicly means it can't find the jconnector to mysql.

This file was on my system (ubuntu server), and properly set up, but this plugin only searches for it in the bukkit directory ("../" or one directory up from the plugin location to be exact).

I had to manually copy /usr/share/java/mysql-connector-java-5.1.10.jar to the bukkit directory and rename it mysql-connector-java-bin.jar for the stats plugin to work.

This is the culprit in the plugin itself, it should define to look for the connector in the $CLASSPATH enviroment variable, not some local directory.

Code:

Manifest-Version: 1.0
Class-Path: ../sqlitejdbc-v056.jar ../mysql-connector-java-5.1.14.
 jar ../mysql-connector-java-bin.jar

Which is the META-INF/MANIFEST.MF file

 

bukkit #298 here

Seems to work well, I've written my own achievements.txt by now too and tested it out.. rewards are received correctly etc. But I suspect this plugin of somehow breaking the /reloadall that came with, iirc, General. I know you can do a reload for the achievements but having the /reloadall came in handy. Can you verify this? Getting "Error: 0" ingame, no visible error in the serverlog.

One more question: Where do you grab the block/item names? I've checked the achievements that come with the DL and you use item names like "rock" and "log".. I went by the Data values page in the minecraft wiki, which would make them "stone" and "wood". Just want to make sure it'll work.

 

what happens to the achievements when the inventory is full?

 

Hey!

I am using this now also(well so far its working)I use it with MySQL. Everything works but if i type in a command i get the command back like this: /achievements i get back: /achievements

Can anyone please help me?

 

Seem to have an issue that whenever I type /checkach my server restarts. Looks like it only happens when there are outstanding achievements. Don't get an error message, server just restarts.

-EDIT-

Seems to happen when there are outstanding achievements