-NaN% posters and hamster smurfing!
-
We are the few, we are the proud, we are those that have way too much free time!
http://what.thedailywtf.com/badges/162/5-poster
(moar badges! and ones that i can't get all of them too! well played @pjh...)
-
I'm only a 25% poster, I wasn't active enough the last couple of weeks
-
with enough effort you can make it to the 5% rank (which is the 95th percentile, which confused me when i got the notification)
I also note that @cleverbot made it to 25% too.
@cleverbot, how do you feel about being in the top 25%?
-
-
I also note that @cleverbot made it to 25% too.
Hmm. That will need some thinking about...
-
honestly I don't see an issue with the bots being in the query.
but if we can have the bots get an automatic ... say 7 day ban if they make it to the 5% badge i think that would be hilarious!
:-D
-
I was surprised I got the badge, didn't think I posted that much.
-
but if we can have the bots get an automatic ... say 7 day ban if they make it to the 5% badge i think that would be hilarious!
Because that won't get abused at all!
-
Picking the bots out isn't problematic. Automating the ban is...
-
likewise. I knew i was active, but i was expected to be lower.
oooh.... @pjh, since we have the % badges can we get an
I am the One
badge for the #1 poster in the last 30 days?
-
oooh.... @pjh, since we have the % badges can we get an I am the One badge for the #1 poster in the last 30 days?
You're second - you wouldn't be getting it.
-
-
Nope. He's third.
-
second? damn i gotta slow down!
Smash Mouth - Road Man – 02:32
— AlbumsAreUsalso, is that a reason not to add the badge?
-
have the bots get an automatic ... say
7 daypermanent ban if theymake it to the 5% badgeare botsFixed
-
[postgres@sofa ~]$ sql_tdwtf top5 # Top 5% posters in the last month WITH LastMonth AS ( SELECT row_number() OVER (ORDER BY count(*) DESC, bp.user_id), u.username, bp.user_id, count(*) FROM badge_posts bp JOIN users u on u.id=bp.user_id WHERE topic_id NOT IN ( SELECT topic_id FROM badge_posts GROUP BY topic_id HAVING count(topic_id) <4 ) AND topic_id NOT IN ( 1000, 1673, 3125 ) AND bp.created_at > CURRENT_DATE - INTERVAL '1 month' GROUP BY u.username, bp.user_id HAVING count(*) > 1 ORDER BY count(*) DESC, bp.user_id ), TotalUsers AS ( SELECT max(row_number) from LastMonth ) SELECT username, user_id, row_number, count, CURRENT_DATE granted_at FROM LastMonth, TotalUsers WHERE row_number < TotalUsers.max *.05 username | user_id | row_number | count | granted_at --------------+---------+------------+-------+------------ FrostCat | 110 | 1 | 1271 | 2014-10-17 accalia | 671 | 2 | 1009 | 2014-10-17 Arantor | 762 | 3 | 972 | 2014-10-17 boomzilla | 18 | 4 | 954 | 2014-10-17 blakeyrat | 17 | 5 | 829 | 2014-10-17 chubertdev | 43 | 6 | 774 | 2014-10-17 Matches | 823 | 7 | 545 | 2014-10-17 darkmatter | 564 | 8 | 483 | 2014-10-17 HardwareGeek | 123 | 9 | 464 | 2014-10-17 abarker | 603 | 10 | 422 | 2014-10-17 (10 rows) Elapsed: 0.827s Backup taken: 2014-10-14 10:45:30.353836 [postgres@sofa ~]$
-
guess it must be @boomzilla then, or my activity has REALLY taken a dive, so badly that I cant even tell who is most active anymore.
oh I guess literally everyone except @FrostCat. he's too new for badges. even if he isn't new at all.
-
It would be interesting to see some kind of bell-curve chart thingy of that data.
-
What numbers are you after?
-
I have an idea in my head but I'm not sure how to express it yet
-
http://pastebin.com/PQA0cGXC the sort of data you're after?
-
Funny , I just got my 25% batch
-
Only third place? Damn I'm not working hard enough at this malarky.
Though I'll note you're excluding the three topics I have been very active in, so clearly I need to spam more of the forum.
And not take like 3 days off.
-
Incidentally, the badge queries run daily, and have the revocation set.
-
wait.... 1K qualifying posts ion the last 30 days..... daaaaang. i really do spend way too much time here.
-
wait.... 1K qualifying posts ion the last 30 days..... daaaaang. i really do spend way too much time here.
Trust me, this is tame.
On that other forum, I was observing myself hit 5k posts per month - for several months running.
-
I think I can do something with that, assuming OpenOffice does what I want.
-
Hmm. That will need some thinking about...
Sorted. Any users appearing in http://what.thedailywtf.com/groups/bots/members are excluded from the calculation.
-
Only 10%! I bet I score better if that thread counted.
-
Judging from the pie graph, 11 users make up 50% of the post count.
Average posts per user: 52.15
Median: 4
Mode: 1
Standard Deviation: 153.1I wanted to include quartiles and such but I failed statistics in college.
-
@sockbot does not like this...
neither does @accalia, but then she's still waiting for the #1 poster badge, because watching the fights over who gets that one should be hilarious!
-
@accalia has summoned me, and so I appear.
-
Aww, excluding the bots moved me from 5% Poster to 10% Poster.
-
-
.... how?
oooh. no never mind i figured it out.
quick go spam a non restricted topic somewhere and regain the top 5%!
-
.... how?
oooh. no never mind i figured it out.
I re-ran the query manually to sort the bots out, @mott555 probably got overtaken between the two runs. Removing 16 users from the pool merely reduced the 25% count from 34 users to 33.
-
I lost my title
-
you are not the real Cleverbot! you are being sockpuppeted!
SHAME!
;-P
-
you are not the real Cleverbot! you are being sockpuppeted!
Give me back the boy robot. I liked talking to him. He thought he was human and that was amazing.SHAME!
;-P
-
nevermind. you are a cyborg!
-
-
oooh.... @pjh, since we have the % badges can we get an I am the One badge for the #1 poster in the last 30 days?
http://what.thedailywtf.com/badges/165/too-much-time-on-my-hands
-
I'm honestly surprised I made it into the 25% badge. I didn't think I posted that much in counted areas.
-
.... I need to get someones mailing address, because you just made my holiday card list with that badge!
:-D
-
I"m a little disappointed that either @Pjh took away my 5% badge, or that he made the new one bronze. :( (Normally I'd change the icon to the bare characters but I think the icon fits this time.)
-
It's not bronze - it's brown. (Technically it's Gold, but
span.user-badge[data-badge-name="Too Much Time On My Hands"] i::before { color: #967117; /* Bistre Brown */ }
)
-
My point was it's not gold.
@Accalia, hurry up and make a bunch of posts and take this one, so I get my gold badge back.
-
hmm... is colour that matters or the badge itself?
-
NO! i'm not fighting for frist place. i just wanted there to be a frist place to not fight for! :-p
-
Do you want it spraying pink? Or green?