Starting tonight with the end of January, you'll notice two changes in the usual end-of-month happenings:
- All end-of-month trophies will be awarded automatically
- Clan and bot historical results will be instantly available
In the past, players have had to wait for me to do some manual work before they received certain trophies like the ones based on monthly energy. Clan and bot results also weren't available until this happened. Automating this process eliminates a tedious monthly maintenance task of mine and frees up more of my time for building interesting things like tournaments. Expect to see a few more of these maintenance-killing updates in the coming months (hint: self-serve perm star moves, self-serve logo uploads, and my end-of-month announcement post).
As with all changes, but especially a big one like this, be on the lookout for anything unusual. I've gone to great pains to ensure the end-of-month script will produce the correct output by running it many, many times and diffing it against the expected output, but things can and do go wrong. That being said, I have high hopes that nothing bad will happen. :)
|
brill update, frees up some more time for you :)
|
|
nice to see a feature that doesn't only benefit the players for once
|
I thought I read the last part of the second paragraph as 'hint: self serve porn star movies.' Lol
|
|
probably somethig went wrong...i didnt get any trophy...i was in top10 clan ://
|
^ if im right, only the top 20 members will get that trophy.
|
Yes, Only Top 20 clan members get clan trophies.
|
Things went off without a hitch. \o/
probably somethig went wrong...i didnt get any trophy...i was in top10 clan ://
Yes, just to confirm, this is by design. Only the ranking members (i.e. the top 20) of each clan earn trophies for clan rank. This is described in more detail in the NC removal update. You finished in 29th in your clan and thus were not eligible:
mysql> SELECT
-> @row := @row + 1 AS rank,
-> username,
-> energy_month
-> FROM history_bots
-> JOIN (SELECT @row := 0) foo
-> WHERE
-> year = 2014 AND
-> month = 1 AND
-> clan_id = 299
-> ORDER BY energy_month DESC;
+------+--------------------+--------------+
| rank | username | energy_month |
+------+--------------------+--------------+
| 1 | Shoegazer | 614082 |
| 2 | shadow_rith | 348716 |
| 3 | Titan | 142276 |
| 4 | chimpus | 123196 |
| 5 | Tomato | 123028 |
| 6 | Jules | 97757 |
| 7 | Samuli | 88876 |
| 8 | fif5 | 75261 |
| 9 | Mr 0range | 70714 |
| 10 | Poly | 70156 |
| 11 | hope10 | 69073 |
| 12 | Player One | 65388 |
| 13 | Riae | 48603 |
| 14 | Monk | 48344 |
| 15 | Phantasy | 47428 |
| 16 | Gpof2 | 46014 |
| 17 | Rivan | 45396 |
| 18 | Nosferatu | 45057 |
| 19 | drseuss | 44677 |
| 20 | Lantern | 44640 |
| 21 | Port Royal | 44640 |
| 22 | dcruzgsxr | 44640 |
| 23 | thingSLEVIN | 44640 |
| 24 | Trio | 44640 |
| 25 | Fight Again | 44639 |
| 26 | Omega Supreme | 44606 |
| 27 | van Shoe | 44569 |
| 28 | stef | 38550 |
| 29 | reet | 34609 | <--- you
| 30 | Malach HaMavet | 33790 |
| 31 | iluvgem2 | 28123 |
| 32 | spooky | 26734 |
| 33 | Zal | 19980 |
| 34 | RealSteel | 6486 |
| 35 | KnuckleBuster | 936 |
| 36 | little neps | 459 |
| 37 | thingTWO | 39 |
| 38 | BRaze | 31 |
| 39 | hayabassie | 30 |
| 40 | Draoi | 23 |
| 41 | Spazz | 20 |
| 42 | HeartattackAndVine | 10 |
| 43 | Blitz | 9 |
| 44 | Sacred | 9 |
| 45 | Afterburner | 0 |
| 46 | Li Po | 0 |
| 47 | Tempestuous God | 0 |
| 48 | George II | 0 |
| 49 | Nexus | 0 |
| 50 | thingEIGHT | 0 |
| 51 | GeordieGirlie | 0 |
| 52 | Smeagol Hurts | 0 |
| 53 | Dazzekiel | 0 |
+------+--------------------+--------------+
|
| 20 | Lantern | 44640 |
| 21 | Port Royal | 44640 |
| 22 | dcruzgsxr | 44640 |
| 23 | thingSLEVIN | 44640 |
| 24 | Trio | 44640 |
How is the 20th trophy selected, when this occurs?
|
looks like either by bot id or level cause trio got it
|
Looks like it is based on ID like most secondary sorts are, so Trio got it and Lantern didn't. As for the table he just posted, I'm assuming Ender forgot to add a backup sort and it defaulted to descending instead of ascending, hence why it looks like Lantern should get it
|
Also, are "Clan wins x month" announcements not going to exist anymore? Or is that just an oversight and you want to automate that too?
|
He did say he wanted to eventually automate it, but more than likely this month will have to be done manually and he just hasn't gotten around to it yet.
|
How is the 20th trophy selected, when this occurs?
Good question. In the actual script that awards trophies, ties are broken by bot id with the lower id winning. The table I posted above was just an ad hoc example that only sorted by monthly energy.
Also, are "Clan wins x month" announcements not going to exist anymore? Or is that just an oversight and you want to automate that too?
They will still exist - not an oversight in automation, just something to come later. This, along with a few other maintenance-killing tasks, are hinted at in my post above.
|
not sure if this has always been the case and i just never noticed, but total energy on my bot does not update to include the monthly energy i have collected.
|
I knew I had seen that number before somewhere. Your total energy that is.
http://bots4.net/forum/3/828
|
|
Shoe has hit max energy, game is over now :D
|
not sure if this has always been the case and i just never noticed, but total energy on my bot does not update to include the monthly energy i have collected.
Thanks for pointing that out. As others pointed out, you'd hit the max total energy as defined by the database data type being used of 2^24-1 = 16,777,215. This was unrelated to this update; you just happened to go over the limit last month.
Anyway, I've added another byte of precision to these fields, so the new limit of 2^32-1 = 4,294,967,295 is now in effect. Congrats on hitting the first limit and good luck on hitting the second. :)
I've manually repaired the historical and current value of your total energy, so let me know if anything still looks out of place.
|
Shoe's limit break gauge is full, use Omni-slash!
|
|
|
btw - at my current pace ill hit the next limit in 780 years
|
|
lol that's like the time you said you takes years to hit lvl 100
|