-NaN% posters and hamster smurfing!
-
-sigh-
half hearted SJW rallying cry.... FAILED
-
i never hear it said "That's what he said!"?
If he said it, it would need a different emoji:
(Assuming he is a heteronormative male.)
-
-
(Assuming he is a heteronormative male.)
But what if he's a passable transvestite?
-
half hearted SJW rallying cry.... FAILED
Because SJW cries work so well here normally? ;)
-
BTW (No, I won't consider replying to several posts at once), apropos of the current title of this topic, what do you guys use for stuffing hamsters? This looks really good. It's supposed to go with pork; would it work well with hamster, too?
-
But what if he's a passable transvestite?
It depends on the anatomy of the partner, not what the speaker is wearing.
-
is @frostcat any closer to taking his spoon back?
[postgres@sofa ~]$ LIMIT=75 sql_tdwtf month_posts # post counts over last month WITH exclusions AS ( /* Which categories to exclude from counters */ SELECT user_id, id, topic_id, post_number FROM posts WHERE raw LIKE '%[UUID removed to prevent this thread accidentally being marked as excluded]%' AND user_id IN ( SELECT gu.user_id FROM group_users gu WHERE group_id IN( SELECT g.id FROM groups g WHERE g.name IN ('admins') ) ) ), LastMonth AS ( /* Count eligible posts from last month */ 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 AND bp.user_id NOT IN ( /* ignore bots */ SELECT gu.user_id FROM group_users gu WHERE group_id IN( SELECT g.id FROM groups g WHERE g.name IN ('bots') ) ) WHERE topic_id NOT IN ( /* short topics */ SELECT topic_id FROM badge_posts GROUP BY topic_id HAVING count(topic_id) <10 ) AND topic_id NOT IN ( /* Ineligible topics */ SELECT topic_id FROM exclusions ) 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 ), QUERY AS ( SELECT username, user_id, row_number, cast(row_number*100.0/TotalUsers.max AS numeric(36,2)) as percent, count, CURRENT_DATE granted_at FROM LastMonth, TotalUsers WHERE cast(row_number*100.0/TotalUsers.max AS numeric(36,2)) < 30 LIMIT 75) SELECT row_number as rank, username, percent, count FROM QUERY rank | username | percent | count ------+-------------------+---------+------- 1 | accalia | 0.43 | 1588 2 | FrostCat | 0.85 | 1545 3 | boomzilla | 1.28 | 1121 4 | chubertdev | 1.71 | 1051 5 | blakeyrat | 2.14 | 888 6 | Intercourse | 2.56 | 563 7 | abarker | 2.99 | 451 8 | mott555 | 3.42 | 449 9 | ben_lubar | 3.85 | 358 10 | PJH | 4.27 | 348 11 | HardwareGeek | 4.70 | 343 12 | flabdablet | 5.13 | 332 13 | Magus | 5.56 | 327 14 | dkf | 5.98 | 318 15 | loopback0 | 6.41 | 317 16 | RaceProUK | 6.84 | 288 17 | Yamikuronue | 7.26 | 280 18 | Arantor | 7.69 | 252 19 | Eldelshell | 8.12 | 234 20 | Maciejasjmj | 8.55 | 225 21 | Jaloopa | 8.97 | 221 22 | tarunik | 9.40 | 199 23 | Luhmann | 9.83 | 197 24 | aliceif | 10.26 | 196 25 | hungrier | 10.68 | 176 26 | Onyx | 11.11 | 164 27 | Keith | 11.54 | 156 28 | JazzyJosh | 11.97 | 153 29 | Zecc | 12.39 | 146 30 | Gaska | 12.82 | 146 31 | xaade | 13.25 | 141 32 | antiquarian | 13.68 | 127 33 | Buddy | 14.10 | 125 34 | Monarch | 14.53 | 123 35 | another_sam | 14.96 | 119 36 | Jaime | 15.38 | 118 37 | Weng | 15.81 | 117 38 | cartman82 | 16.24 | 113 39 | PleegWat | 16.67 | 105 40 | Groaner | 17.09 | 98 41 | anonymous234 | 17.52 | 96 42 | OffByOne | 17.95 | 94 43 | lucas | 18.38 | 92 44 | EvanED | 18.80 | 84 45 | locallunatic | 19.23 | 79 46 | redwizard | 19.66 | 77 47 | KillaCoder | 20.09 | 72 48 | delfinom | 20.51 | 72 49 | VinDuv | 20.94 | 71 50 | Bulb | 21.37 | 69 51 | lolwhat | 21.79 | 64 52 | ijij | 22.22 | 64 53 | izzion | 22.65 | 61 54 | CarrieVS | 23.08 | 60 55 | RTapeLoadingError | 23.50 | 51 56 | Cursorkeys | 23.93 | 51 57 | Steve_The_Cynic | 24.36 | 49 58 | monkeyArms | 24.79 | 49 59 | powerlord | 25.21 | 47 60 | codinghorror | 25.64 | 47 61 | riking | 26.07 | 45 62 | asdf | 26.50 | 45 63 | DoctorJones | 26.92 | 42 64 | Kuro | 27.35 | 41 65 | VaelynPhi | 27.78 | 40 66 | kupfernigk | 28.21 | 40 67 | sam | 28.63 | 37 68 | evandentremont | 29.06 | 37 69 | Spencer | 29.49 | 36 70 | trithne | 29.91 | 33 (70 rows) Elapsed: 3.03s Backup taken: 2014-12-12 16:15:13.618894 [postgres@sofa ~]$
In fact, that I've got an addon on here now and gone most of the way up the learning curve for git and part of the way for an addon, I may start seriously looking into getting some publicly viewable stats pages based on live data.
Probably not to dissimilar to the admin screen, but with more useful stats..
what do you guys use for stuffing hamsters?
Empty toilet roll tubes - I thought - were de rigueur...
-
Down again despite more posts
-
1 | accalia | 0.43 | 1588
2 | FrostCat | 0.85 | 1545a difference of < 40 posts makes up ~.4% of the posts? huh...
anyway: keep it up frostcat! you're gaining! (until i get my grooveon and do 3k posts/30 days (that's only 100 posts/day. totally doable!)
-
a difference of < 40 posts makes up ~.4% of the posts? huh...
No. The %age is of users, not of posts made by those users...
...cast(row_number*100.0/TotalUsers.max AS numeric(36,2)) as percent...
You'll note that there's roughly the same difference between every pair of users in that table.
-
anyway: keep it up frostcat! you're gaining!
This has been a tough week, for that, heh. Troubled customers. "Hey, why don't you upgrade your software instead of me, so the users don't think we are able to help them with problems." :jawdrop:
I've spent hours in the last couple of days with this guy in the Caribbean who's a nice guy but hard to understand due to his accent--I'm sure he thinks the same about me. But it means everything takes forever. Plus the call keeps disconnecting. I'm sure there's a pair of tin cans and string involved somewhere.
-
after 3.5 hours, we have the server updated, and 1/5 PCs. The second one I'm giving up on for now as it's coming up with a bizarre error. After lunch we'll tackle the rest.
-
I'm up to 16.6%?
wow.
-
I'm up to 16.6%?
wow.
No. You're up to 16.67%. If you reduce that to 3 sig figs you should be rounding it, which gives you 16.7%. What kind of plebeian are you? Are you sure you deserve that 16.67%?
-
Lol, good one
-
I'm in the 5% club - for now.
-
Welcome! Welcome!
-
I'll not get to comfortable, can't see me being here long!
-
Nonsense. If you want to stay you can! You just need to post!
-
aaaan....... i'm baaaaaack!
for now. i'm sure i'll steal the spoon from @frostcat again one of these days.
-
And I'm gone again. And likely to stay that way for a while; RL is a barrier to TDWTF.
-
Gone again too!
-
I wonder who made it in. You can see who's got it now, but without knowing who had it previously it's hard to see the deltas.
No, wait, you can probably see by acquisition date. Looks like @dkf and @flabdablet. Congrats, I guess.
-
No, wait, you can probably see by acquisition date.
yes, although that doesn't give you whether they moved into the group through promotion or demotion (i'm very recently 5% but i was previously wooden spoon.
-
Actually, since you were the spoon, everyone else moved into 5% via promotion. Obviously that's not going to work for the 10% and 25% badges.
-
As it's 5% then the only demotion would be from Wooden Spoon. And neither of those 2 were wooden spoon.
EDIT - Hanzoed.
-
Obviously that's not going to work for the 10% and 25% badges.
which was my point... i just used the only example i knew of for certain. ;-)
-
which was my point... i just used the only example i knew of for certain.
Since two people admitted to dropping out of top 5%, we can assume two people moved up. Of course more could that we don't know about. However, it seems unlikely there's a badge history, so anyone with a recent date probably are the ones.
-
It's interesting that the 5% club is so stable. 4 of the people there are charter members.
-
five people are if you count me, who only lost it by moving into the wooden spoon badge for a while
-
No, wait, you can probably see by acquisition date. Looks like @dkf and @flabdablet. Congrats, I guess.
I'm prouder of my Pedantry badge. :p
-
It's interesting that the 5% club is so stable. 4 of the people there are charter members.
I'm a little surprised that it's only 4.
-
five people are if you count me, who only lost it by moving into the wooden spoon badge for a while
I don't, because you've been out of the group.
I'm a little surprised that it's only 4.
Not from looking at the numbers. It really flattens out towards the bottom of the group, so a bit of churn makes sense there. Add in the two trading the spoon back and forth, plus an original member who's disappeared...
-
-
don't look at me. i hand out pedantry flags on a semi-regular basis.
the really exceptional pedantry i even advertize my flagging.
-
I'm prouder of my Pedantry badge.
I'm prouder of my spellar badge, as those appear to be even more exclusive.
-
now that flag i've stopped handing out when directed at me.
otherwise it would be like shooting fish in a barrel.
-
i hand out pedantry flags on a semi-regular basis.
I think I hand out more than my share of flags. The badges should come because you're naturally a pedantic dickweed (or actively trolling, at least). If they get handed out all willy nilly, they're nothing special.
-
-
The badges should come because you're naturally a pedantic dickweed (or actively trolling, at least).
Same with you as Accalia. I know you've both flagged me at the same time more than once but I have not yet gotten that third flag on a single post.
I feel like that soap opera actress who gets nominated for an Emmy or whatever every single year but never gets the actual trophy.
-
-
I'll probably be falling out of a lot of these groups soon...
-
-
I'm prouder of my spellar badge, as those appear to be even more exclusive.
I really doubt I'll ever get one of those. My own variation on CDO won't let it happen. I think that it is more likely that I'll pick my house up with my bare hands and throw it into the next county…
-
-
Compulsive Disorder; Obsessive.
it's like OCD, except the letters are in alphabetical order, AS THEY FRACKING WELL SHOULD BE!
-
Compulsive Disorder; Obsessive.
it's like OCD, except the letters are in alphabetical order, AS THEY FRACKING WELL SHOULD BE!
whoosh, but no
fragflag
-
-
who said woosh? i'll cut them with a semicolon!