Stats & Achievements
This Project is currently abandoned (and probably will forever be). See here for a alternative plugin
2-in-1 Stats and Achievements
This plugin logs various player activity as stats in a MySQL or SQLite database. With the integrated achievement system it is possible to award players when they reached a predefined target.
Features
- Logs block, mob, pvp and miscellaneous player statistics very detailled
- Logs also crafting statistics when spout is installed
- Integrated achievements system
- New database format which is more performant than older databases
- Integrated time delay to reduce server load and the number of SQL queries
- Planned web stats system
- Compatible with every Bukkit version since 1.1-R4
Tools
- You can convert older databases using our utility: http://89.144.25.51:8888/convert.php
- Achievements generator (will be extended soon): http://plugins.maniacraft.de/SaAPlugin/achgen
Requirements
- Vault (Permissions)
- Spout (if you want to get crafting stats)
Commands
- /stats help - General Help
- /stats [<player>] - Shows your stats or stats by <player>.
- /stats block [<player>] <block>[:<data>] - Shows stats for <block>.
- /stats pvp [<player>] [<player2>] - Shows PVP stats.
- /stats mob [<player>] [<mob>] - Shows mob damage stats.
- /achievements help - General Help
- /achievements [<player>] - Shows your obtained achievements or achievements obtained by <player>.
- /achievements list [<page>] - Lists all available achievements.
- /achievements admin add <name> <description> <category> <block> <data> <value> <command> - Adds a new achievement.
- /achievements admin remove <id> - Removes the achievement <id>.
- /achievements admin convert - Convert old achievements.
Achievement Commands
- /give <block>[:<data>] [<amount>] - gives the player the item <block> <data>
- All commands available on your server. Example (Essentials warp): /warp darkroom %player%
Permissions
Permission | Description |
---|---|
stats.show.blocks.own | Show own block stats |
stats.show.blocks.other | Show block stats by others |
stats.show.pvp.own | Show own pvp stats |
stats.show.pvp.other | Show pvp stats by others |
stats.show.mob.own | Show own mob stats |
stats.show.mob.other | Show mob stats by others |
stats.overview.own | Show your overview |
stats.overview.other | Show overview by others |
stats.receive | Log stats at all (for example not for Guests) |
achievements.receive | Gives achievements at all (for example not for Guests) |
achievements.admin.remove | Admin Command Remove |
achievements.admin.add | Admin Command Add |
achievements.admin.convert | Admin Command Convert achievements from old DB |
achievements.list | List all achievements |
achievements.show.own | Show obtained achievements |
achievements.show.other | Show achievements obtained by others |
Config
general: language: en # Language (Available: en/de, other languages can be added in plugins/StatsAndAchievements/lang/) update-delay: 30 # The time interval in seconds how often the stats will be updated in the database (Default and recommended: 30) achievements: true # Activating and deactivating Achievements text_color: '&6' # Color of command texts (1st color) data_color: '&7' # Color of data output (2nd color) debug: false # Debug output (Default and recommended: false) database: type: mysql # Database type, either mysql or sqlite table_prefix: '' # Table prefix to save stats of more than one server in a single database host: localhost # Only MySQL: Database server (Default: localhost) port: 3306 # Only MySQL: Database server port (MySQL default 3306) database: minecraft # Only MySQL: Database name user: root # Only MySQL: Database user password: stats123 # Only MySQL: Database password DisabledWorlds: # In this worlds the stats will be deactivated - disabledworld1 - creative listeners: blockStats: true # Block related stats brewingStats: true # Brewing related stats (maybe bugged) craftingStats: true # Crafting related stats (maybe bugged) enchantingStats: true # Enchanting related stats (maybe bugged) entityStats: true # Entity related stats playerStats: true # Player related stats (Your really should NOT disable this or you'll break everything!) playerMoveStats: true # Player move stats (if you experience lags you should set this to false) vehicleStats: true # Vehicle related stats
Language file formating
{br} - Line break &[0-f] - Color codes (http://img109.imageshack.us/img109/4334/mccolors.png) %[A-Z0-9]% - Internal variables, don't supposed to be translated!
@LordKainzo
Hm, just looked into the Heroes Javadocs, but i dont understand why it shouldn't work? Can you please explain this, i would really like to fix this if something doesnt work with Heroes :)
@Ferkswe
Thanks, bug fixed ;) I have sent you your converted database per PM
Hey, I still cannot convert my database. When I zip it it say's that it cannot find any sqldatabase. The file could not be uploaded. Internal error number 1 Please select the file to submit it again. This error happens sometimes when zipped, sometimes when nonzipped. The file is 25 mb, maybe that is the problem (Yeah, was wrong in my old post, it is indeed 25Mb :s) Any ideas? Thanks! FerkSwe
@ManiacTwister
The damage dealt system is not compatible with Heroes damage system - just a head's up to anyone using both.
I have updated the converter. The database should convert now much faster, but importing into the mysql server could take a while. Please run "/achievements admin convert" after you start your server the first time after the import. Otherwise your players will get all achievements they had one more time!
SQLite support isn't implemented until now, but we do our best...
Note. You need SaAPlugin-1.2 to convert your achievements. (file needs approval).
@cky2250
Our database format has changed massively. But our PHP API is going public soon, and webstats will follow, but feel free to rewrite your system for our new SaA database format.
Is this set up about the same as all the other stats plugins. Or am I going to need to re-write code for my project.HERE
@Ferkswe
The version you linked me to is still throwing the same error.
23 kb (Thank the lord, it's kb...) of stats on it's way. Waiting for dropbox to upload it. I'll pm you the link. Dont want anyone stealing our stats (wait whut? :S)
Sure
I PM'D you the link.
Just download and unzip.
@KoolSource Can you send me your Database export? (per 1-One-click hoster or something else) I have only a measly 15k big database, so its hard to figure out why it doesnt work with big databases :/
@ManiacTwister
413 Request Entity Too Large
Please note, were talking over a year of stats here lol
@ManiacTwister
Using firefox and trying to convert a mysql dump, but it keeps going to Connection Reset. Any ideas why?
Thanks! FerkSwe
If you need to convert your old database please use the new converter (Conversion can take up to 2 minutes for each 10.000 stat entrys): http://89.144.25.51:8888/convert.php
NOTE: SQLite convertion doesn't work at the moment. I'll try to fix this until tomorrow evening.
@KoolSource Mhh, strange..Can you please try this version: http://ci.s7t.de/job/StatsAndAchievements/58/artifact/target/StatsAndAchievements-1.2-SNAPSHOT.jar
@ManiacTwister
This error is spamming my console every couple of seconds:
22:02:02 [SEVERE] java.lang.NullPointerException
22:02:02 [SEVERE] at de.maniacraft.statsandachievements.Update.insertEntrys(Update.java:68)
22:02:02 [SEVERE] at de.maniacraft.statsandachievements.Update.run(Update.java:52)
22:02:02 [SEVERE] at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
22:02:02 [SEVERE] at java.lang.Thread.run(Unknown Source)
Also when i am in-game and type /stats everything is 0, permission nodes are set and i am Admin anyway, i get all nodes by default.
When i checked the database the only thing being recorded is player names, nothing with them such as play time. Everything is displaying as 0.
@KoolSource
I'll post an updated version of the converter soon (should be finished in the next 2 hours).
And 1.2.3 compatibility .. i have tested it with Craftbukkit-1.2.3-R0.2 and it worked fine for me..can you post the error please?
Just so you know, this plugin is not working with 1.2.3-R0.2.
Would be awesome if it did though.
Also the Database Conversion script does nothing. I click Download and i watch the file upload in the bottom left then once it hits 100% nothing happens, it just resets the page. I have left it for like 30 minutes after upload on several browsers and nothing happens.
Would really like to see this plugin working as i don't want to lose over a years worth of stats. Im currently having to use a different stats plugin which i will merge with my old database if i can get this plugin working.
@judam
Can you post the Errors and maybe the permissions.yml too please?
I get severe errors and stuck in boot loop when I add your nodes to PermissionsEx.
Very cool. I will be testing it out and tell you how it goes soon!