Bukkit

@wattzy

Fantastic! You rock dude.

I would love to know why my achievements aren't triggering, but that might be my problem to deal with. Is anyone else's LASTLOGOUT not updating? Or is that just me.

YOU GUYS ARE AWESOME! Love this plugin :)

@wattzy

nice :)

@wattzy

I love you? :)

Can't wait to see this. I was already looking for another plugin =/

@wattzy

yes, i am using the remotetoolkit to restart once a day in the morning at 05:30. Since SAA will "eat" my RAM, i restart more than once a day to prevent the memoryleak. Will be helpfull, but not fine.

sometimes get this (saa 1.7)

11:44:04 [SEVERE] java.util.ConcurrentModificationException
11:44:04 [SEVERE]       at java.util.HashMap$HashIterator.nextEntry(HashMap.java:810)
11:44:04 [SEVERE]       at java.util.HashMap$EntryIterator.next(HashMap.java:851)
11:44:04 [SEVERE]       at java.util.HashMap$EntryIterator.next(HashMap.java:849)
11:44:04 [SEVERE]       at java.util.HashMap.putAll(HashMap.java:540)
11:44:04 [SEVERE]       at de.maniacraft.statsandachievements.Update.run(Update.java:53)
11:44:04 [SEVERE]       at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
11:44:04 [SEVERE]       at java.lang.Thread.run(Thread.java:679)

@ThaMunsta

I'll see what I can do about it. But sincerely, I think it is beyond what I can do, as just from MySQL I cant do nothing about it. But, you can do some simple things if you want to use some PHP.

You can do like me and get online players using Minecraft Querys. Read the Readme file there and it'll explain almost everything you need to know.

Just get the Online Players from there and set your online list using that. For me, it's better and it's always accurate.

I'll look for other alternatives.

-

Just to clarify: here is some pseudo-code to tell what I do to get Online Players from my Sever:

$OnlinePlayers -> getOnlinePlayers();

foreach ( $OnlinePlayers as $Player ) {
  echo "$Player - Online";
}

/* select name from stats.players */

while ( $Query->Fetch() ) {
  if (!in_array($Query['name'] , $OnlinePlayers)( {
    echo "$Query['name'] - Offline";
  }
}

It is something like that. You can do that but instead of using Echo, you can add to an array and make some more controls. It's pretty easy.

You can mix that if you're running another server like me (I have my main survival server, a creative one that only me and moderators can Login and an Adventure Map that I open for some players. On the Status field, it'll say where the player are like: Online @ Test Server or Online @ Adventure_Map_Name.

@ThaMunsta

@ThaMunsta: I set the delay to 90s, but the memory eater is still alive :(

Could you post a little wiki how to use all achievements?

The normal Achievements as blockbreak, create and so on ... are no problem but the other Archievements as crafting and so on are a bit difficult, could you make a little wiki how to use them and what for commands as reward are possible with which Plugin (iConomy, Essentials ....) would be great if you could do that, so that I and others have it a bit easier! :)

@PainKNero

I had to crank my update delay up to 60 seconds to prevent this. Things have been running smooth now.

@Gidedin

Can you think of a way to trigger the LASTLOGOUT when the player logs out? All my values are 0 which sucks because my web interface assumes they are logged in if login > logout... so everyone is always logged in lol Seems to work when I'm OP but aside from that I can't get it to update in the DB

@wattzy

I use that too and recommend. Unfortunately I'm running my server on a x86 Windows XP computer and every 5 hours or so the server becomes very laggy and overloaded.

I've set my RTK to restart every 5 hours and takes roughly 22 seconds from stop to restart. Very simple and easy.

I'm still waiting for the Maniac answer about the Stats being recorded while on Creative =|

I can't get achievements on creative, but after I go out of it the achievement just popup as I've already reached what was necessarily (If the achievement are block destroy or anything like that).

If possible, don't record anything at all while on creative :-)

ok...sadly: i disable all plugins, who aren't necessary for security or server maintenance. Just Essentials, Worldguard, Multiverse and SAA will stay.

Last step, disabling SAA, waiting 24h, and we see: No lost memory, no lost TPS after server-runtime 10-12h... server runs normal. It seems to be that it is SAA which kill my server every 12h after restart.

Can you check, if the code is written safe ? It will reserve memory and won't give it free after use ?

Very sadly, because the achievements are cool !!! The old versions 0.99 (sockenklaus) don't have any errors, but won't work on 1.2x Servers :(

@Justins210

Are you using the last version available? It should be fixed there. If not, add this to your database:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;

-- Dumping structure for trigger stats.tr_players_bfup
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
DROP TRIGGER `tr_players_bfup` //
CREATE TRIGGER `tr_players_bfup` BEFORE UPDATE ON `players` FOR EACH ROW BEGIN

  IF NEW.PLAYTIME > 1000000000 THEN
  
    SET NEW.PLAYTIME = ( OLD.PLAYTIME + 1);
    
  END IF;
  
  IF NEW.LASTLOGIN = 0 THEN
  
    SET NEW.LASTLOGIN =  UNIX_TIMESTAMP(NOW());
    
  END IF;

END//
DELIMITER ;
SET SQL_MODE=@OLD_SQL_MODE;
/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

It should work very fine for two things:

• The PLAYTIME getting very high for an unknown reason; and
• The LASTLOGIN being zero. When the Database first update the player, it means it is already online. So, It'll make the the LASTLOGIN field always be filled with something.

After about 3 hours of play time, my players' play time gets set to some random number like 8134553. I don't have any idea how to fix this?

@Galzen

Hey there Galzen.

You can do half of what you want, for that, do the following steps:

1. Create the file '../plugins/StatsAndAchievements/lang/SaAPlugin_en.properties';
2. Add the line: achievements.notifyachwidget somewhere;
3. Change the line to something like this:

&6Congratulations! &9%player% &6just completed the achievement %achievement%&6! And for that, he was rewarded for &9%reward%&6!

In game, it should look like this:

Congratulations! Gidedin just completed the achievement Rocking Out! And for that, he was rewarded for 1x Diamond

I've placed some colors there to show the Player, the Achievement and the Reward in Blue, the message will be in gold. It looks nice.

The full archive would look like that:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35

== File: '../plugins/StatsAndAchievements/lang/SaAPlugin_en.properties' ==

pages = Showing page %site% of %sites%
help = The following commands are available:
show.achievements.all = Available achievements
show.achievements.own = Show your obtained achievements
show.achievements.other = Show achievements obtained by %player%
show.achievements.help = %basecommand% help - Shows this help.{br}%basecommand% [<player>] - Shows your obtained achievements or achievements obtained by <player>.{br}%basecommand% list [<page>] - Lists all available achievements.
show.achievements.admin.help = %basecommand% admin add <name> <description> <category> <block> <data> <value> <command> - Adds a new achievement.{br}%basecommand% admin remove <id> - Removes the achievement <id>.
show.stats.hr = &8---------------------------------
show.stats.playtime = Play time:
show.stats.blocksplaced = Blocks placed:
show.stats.blocksdestroyed = Blocks destroyed:
show.stats.kills = Killed:
show.stats.deaths = Died:
show.stats.joins = Logins:
show.stats.help = Use /stats help for detailled statistics
show.stats.overall.own = Your overview
show.stats.overall.other = Overview of %player%
show.stats.pvp = Shows PVP stats: %sourceplayer% -> %refplayer%
show.stats.pvp.overall = Show PVP stats
show.stats.killsdeaths = Killed/Killed by:
show.stats.dmgdealttaken = Damage dealt/Damage taken:
show.stats.mob = Show mob stats: %mob% -> %refplayer%
show.stats.block.own = Show your block stats for "%block%"
show.stats.block.other = Show block stats for "%block%" by %player%
show.stats.block.createdestroy = Placed/destroyed:
show.stats.help = %basecommand% help - Shows this help.{br}%basecommand% [<player>] - Shows your stats or stats by <player>.{br}%basecommand% block [<player>] <block>[:<data>] - Shows stats for <block>.{br}%basecommand% pvp [<player>] [<player2>] - Shows PVP stats.{br}%basecommand% mob [<player>] [<mob>] - Shows mob damage stats.
achievements.nofreeslot = An achievement reward item is waiting for you!{br}You should get some free space in your inventory!
achievements.notifytitle = Achievement get!
achievements.notifychat = &6%player%&3 has received a new achievement!
achievements.notifyreward = Reward: %reward%
achievements.notifyachwidget = &6Congratulations! &9%player% &6just completed the achievement %achievement%&6! And for that, he was rewarded for &9%reward%&6!
achievement.remove = Achievement %id% removed!
achievement.add = Achievement successfully added!

Thanks for the explanation with the bundle en , it's more clear now. This file should be auto-created, that would be easier for new users to translate the text.

Is it possible to show the achievement's name when it's completed ? like on the older achievements

I want a message like "Achievement (achievement name) completed - (description) ! Reward : (reward, I use /money give %player% x)

I tested things like %name% %description% but it doesn't work :)

If we can do this, could we have a list of things we can customize in this file ? Thanks

periodically get some errors:

2012-04-15 15:15:52 [SEVERE] java.util.ConcurrentModificationException
2012-04-15 15:15:52 [SEVERE] 	at java.util.HashMap$HashIterator.nextEntry(HashMap.java:810)
2012-04-15 15:15:52 [SEVERE] 	at java.util.HashMap$EntryIterator.next(HashMap.java:851)
2012-04-15 15:15:52 [SEVERE] 	at java.util.HashMap$EntryIterator.next(HashMap.java:849)
2012-04-15 15:15:52 [SEVERE] 	at java.util.HashMap.putAll(HashMap.java:540)
2012-04-15 15:15:52 [SEVERE] 	at de.maniacraft.statsandachievements.Update.run(Update.java:53)
2012-04-15 15:15:52 [SEVERE] 	at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
2012-04-15 15:15:52 [SEVERE] 	at java.lang.Thread.run(Thread.java:679)

And this one, sometimes, if achievement will be granted:

2012-04-15 17:22:35 [WARNING] [StatsAndAchievements] [MySQL]: Error in SQL query: Data truncation: Out of range value adjusted for column 'data' at row 1
2012-04-15 17:22:36 [INFO] PainKIxxam hat eine Auszeichnung 62 Bauer III erhalten!

Also, once a day, server will be come total laggy, from 20 TPS down to 2 TPS, Restart needed. Don't know, if SAA produced that error, i try to disable plugin after plugin. Will be a hard one, because the lag will accour only once a day, no specific hour. I rise the updatetime from SAA to 90, i will look at that...

(fortunately there aren't so much plugins recently update or new, so on one of the next day, i will disable SAA too for a day, to look at the behaviour after that)

Greetings,

Nero

@ManiacTwister

Thank Maniac, but there is a small thing yet: While on creative, I still get Stats even when the config is set to true.

The achievements is blocked and I didn't managed to get the test achievements I made, but I still was getting stats. It is supposed to be like that?

I wish I could block everything at all while on Creative ^_^"

Another thing (Sorry for asking all those things =/): Can you control when a player dies from falling, lava or some other way other then killed by monsters/players?