announcements

Forum > Announcements > More end-of-month automation
Reply To Thread (login)
Ender [1]
Administrator
2014-01-31 10:29:47
[10 years, 300 days ago]

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. :)


 
The Apex Predator [261]
2014-01-31 10:34:26
[10 years, 300 days ago]

brill update, frees up some more time for you :)


 
Shoegazer [100]
Moderator
2014-01-31 10:37:49
[10 years, 300 days ago]

that's great ender ^_^


 
Mithrandon [171]
2014-01-31 11:03:45
[10 years, 300 days ago]

nice to see a feature that doesn't only benefit the players for once


 
Trio [343]
2014-01-31 23:10:57
[10 years, 299 days ago]

I thought I read the last part of the second paragraph as 'hint: self serve porn star movies.' Lol


 
Tryhard [230]
2014-02-01 05:05:36
[10 years, 299 days ago]

That's in bots 5 Trio ;)


 
reet [82]
2014-02-01 05:14:03
[10 years, 299 days ago]

probably somethig went wrong...i didnt get any trophy...i was in top10 clan ://


 
Lyrad [337]
2014-02-01 09:34:53
[10 years, 299 days ago]

^ if im right, only the top 20 members will get that trophy.


 
Nosferatu [229]
2014-02-02 01:47:35
[10 years, 298 days ago]

Yes, Only Top 20 clan members get clan trophies.


 
Ender [1]
Administrator
2014-02-02 02:37:08
[10 years, 298 days ago]

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 |
+------+--------------------+--------------+

 
Shoegazer [100]
Moderator
2014-02-02 10:21:16
[10 years, 298 days ago]
|   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?


 
shoyuken [175]
2014-02-02 10:24:23
[10 years, 298 days ago]

looks like either by bot id or level cause trio got it


 
Fishwick [133]
Moderator
2014-02-02 10:25:56
[10 years, 298 days ago]

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


 
Fishwick [133]
Moderator
2014-02-02 10:27:18
[10 years, 298 days ago]

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?


 
Nosferatu [229]
2014-02-02 11:47:53
[10 years, 298 days ago]

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.


 
Ender [1]
Administrator
2014-02-02 15:35:57
[10 years, 298 days ago]

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.


 
Shoegazer [100]
Moderator
2014-02-03 15:06:23
[10 years, 297 days ago]

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.


 
Crab Whistler [130]
2014-02-03 16:06:35
[10 years, 297 days ago]

I knew I had seen that number before somewhere. Your total energy that is.

http://bots4.net/forum/3/828


 
Esvrainzas [134]
2014-02-03 16:24:22
[10 years, 297 days ago]

Nice catch Benny!


 
Tryhard [243]
2014-02-03 20:54:45
[10 years, 296 days ago]

Shoe has hit max energy, game is over now :D


 
Ender [1]
Administrator
2014-02-03 23:47:45
[10 years, 296 days ago]

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.


 
Trio [343]
2014-02-04 08:56:22
[10 years, 296 days ago]

Shoe's limit break gauge is full, use Omni-slash!


 
Shoegazer [100]
Moderator
2014-02-04 09:04:33
[10 years, 296 days ago]

thanks for fixing it :)


 
shadow_rith [75]
2014-02-04 09:10:24
[10 years, 296 days ago]

gratz shoe!


 
Shoegazer [100]
Moderator
2014-02-05 12:27:54
[10 years, 295 days ago]

btw - at my current pace ill hit the next limit in 780 years


 
Esvrainzas [134]
2014-02-05 16:53:15
[10 years, 295 days ago]

Perfectly possible.

http://www.dailygalaxy.com/my_weblog/2009/03/can-humans-live.html


 
shoyuken [175]
2014-02-05 20:22:14
[10 years, 294 days ago]

lol that's like the time you said you takes years to hit lvl 100


 
Forum > Announcements > More end-of-month automation
Reply To Thread (login)