Alright guys, get your carpal tunnel prevention cream ready! It's Super Turkey time! [Edit] I really like this color. I should use it more. It's not as glaring as white. c:
1129 heads out there how much candy though? Who is selling? how much you want for an SC xD Since we all have to pat ourselves on the back for where we got, 380, 298 and 229. man I put in a lot of work xD which all added together is 100... how does that work? lol. I'm sure if everyone else added their alts in too I would be lower(higher? now I'm getting confused) than 100 lol. Also, mind you, I did all three of those in about 10 hours... yes I was on EMC for over 10 hours... actually it was like 18 O.O From what I heard the first two days you could have gotten that 346 points in like... an hour. Kinda sad I missed it. will just have to pull candy out of the throats of these jack-o-lanterns to make myself feel better. *chomps on candy bones*
Code: SELECT @curRank := @curRank + 1 AS rank, name, score FROM ( SELECT m.value as score, u.name as name FROM user u JOIN user_meta m ON m.user_id = u.user_id WHERE m.meta_key = 'htown.score' ORDER BY CAST(value as UNSIGNED) DESC ) p, (SELECT @curRank := 0) r
And for you techies, here is the code for the event https://gist.github.com/aikar/903589f3843e82c2444cddd690d18b96
I can confirm this would be impossible lol Not counting the Sunday launch, I was on most of the day Monday and got that much the whole day and I was pretty close to the top most of the day. EDIT: Impossible is the wrong word lol If that many were on, it could be done. Just didn't seem like ever that many one at once.
I like to think they got 28th right there with me. So I guess it was a 4-way tie, is what you're saying. Yeah, I'd agree to that.
They can't both happen or also you wouldn't want both to process. So the else causes the program to skip any checks on the second if statement. (Less computing time and ensures that both statements never both run)
Wow, that is mighty generous of you Aikar, thanks a bunch for sharing that! Seriously.. Of course we can't "just" take this and stick it into our own server and then expect things to work (then again...) but even so: this is one heck of an example, one which we all know works because we've seen it work ourselves. And one should never underestimate what you can learn from other people's work! So yeah, thanks a bunch, I seriously appreciate this.
Final score prizes have been delivered. If you were in the Top 10 GLOBAL, you received 5,000 tokens and 25,000 rupees. If you were the 1st place winner of an SMP, you received 1,000 tokens and 10,000 rupees. Thank you to all that participated. This was the most fun I've had throwing candy at people in a long time
