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!
-
View User Profile
-
Send Message
Posted Jan 14, 2013@jjacobson
Yes, there is a bug in the achievement generator.. please replace COW with its entity ID which can be found here: http://dev.bukkit.org/server-mods/saaplugin/pages/entity-ids-for-achievements-de-de/
So for COW it's 29:
INSERT INTO `achievements` (`name`, `description`, `type`, `block`, `data`, `value`, `command`) VALUES ('zombie 1', 'Kill 1', 'KILLS', '', 29, '1', '/say it works');
Also i just started playing minecraft again, expect some improvements soon, hopefully ;)
Edit: Colors are fixed in the next release.
-
View User Profile
-
Send Message
Posted Jan 13, 2013Colors are not working for me. And neither are mobs,
Using this
INSERT INTO `achievements` (`name`, `description`, `type`, `block`, `data`, `value`, `command`) VALUES ('zombie 1', 'Kill 1', 'KILLS', '', 'COW', '1', '/say it works');
get this
1 row(s) affected, 2 warning(s): 1366 Incorrect integer value: '' for column 'block' at row 1 1366 Incorrect integer value: 'ZOMBIE' for column 'data' at row 1
-
View User Profile
-
Send Message
Posted Jan 13, 2013Got this: http://pastebin.com/1KFcpTSv D: Also, How do I make it so you don't have to log out and in to refresh playtime?
-
View User Profile
-
Send Message
Posted Jan 12, 2013Yes, it should.
-
View User Profile
-
Send Message
Posted Jan 12, 2013This work in 1.4.6?
-
View User Profile
-
Send Message
Posted Jan 2, 2013@jjacobson
That is mysql query...
execute it at your mysql console or phpmyadmin..
-
View User Profile
-
Send Message
Posted Jan 2, 2013can someone share working mysql file of achievements?
-
View User Profile
-
Send Message
Posted Dec 30, 2012I can see in my database that the plugin logs about 45 stats. Out of that, play time, blocks placed, blocks destroyed, killed, died and logins. How can i choose witch one to be displayed? Is this a feature? Do i have to edit the plugin it self?
-
View User Profile
-
Send Message
Posted Dec 29, 2012Does it have a Reload command?
-
View User Profile
-
Send Message
Posted Dec 24, 2012http://dev.bukkit.org/server-mods/achievements
Is that plugins have same features like this plugins? I hope this plugins have same features like that plugins.
-
View User Profile
-
Send Message
Posted Dec 21, 2012Where exactly do I put this?
INSERT INTO `achievements` (`name`, `description`, `type`, `block`, `data`, `value`, `command`) VALUES ('Dirter', 'Break 50 Dirt Blocks', 'BLOCKDESTROY', '3', '0', '50', '/give 277 1'), ('Member', 'Login 50 times', 'LOGIN', '', '', '50', '/give 266 1'), ('Zombiekiller', 'Kill 10 Zombies', 'KILLS', '', 'ZOMBIE', '10', '/give 276 1');
-
View User Profile
-
Send Message
Posted Dec 21, 2012@exestino
I'll do it soon for my own server. I'll contribute it to the community if the project reaches the state of 'worksforme' ;-)
-
View User Profile
-
Send Message
Posted Dec 20, 2012Obviously I cannot read. Sorry about that, must have been really tired.
-
View User Profile
-
Send Message
Posted Dec 20, 2012Quote from Description: 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%
-
View User Profile
-
Send Message
Posted Dec 20, 2012Is there a variable for the player that achieved something like %PLAYER% or something similar? For commands like /eco give %PLAYER& 100?
-
View User Profile
-
Send Message
Posted Dec 18, 2012Maybe someone got web stats to share? Because this plugin without webstats in useles :(
-
View User Profile
-
Send Message
Posted Dec 11, 2012Maybe you should re-arrange the fields of your Achievements Generator top-down. With a smaller resolution or while my browser is not in full screen mode I cannot see all fields.
IF I scroll down, I can see and use the scrollbar. But the scrollbar isn't visible "at your fingertips" ;) - I think you should change that too.
-
View User Profile
-
Send Message
Posted Dec 9, 2012Here are some examples: (break 50dirt get 1 diamond shove, login 50times get 1 goldingot, kill 10 zombies get 1 diamond sword):
-
View User Profile
-
Send Message
Posted Dec 9, 2012This plugin is awesome .. But without example like for Login or Kill for see how to use it .. is very hard for noob like me :p I try different things with the nice generator http://plugins.maniacraft.de/SaAPlugin/achgen but nothing run .. have u got any example ? I use mysql and vault only.
-
View User Profile
-
Send Message
Posted Dec 8, 2012@shadoom23
maybe you're using an external mysql...