-NaN% posters and hamster smurfing!
-
PostMonths abarker Backup Date: 2015-03-19 03:56:18
[Query
``` WITH exclusions AS ( /* Which categories to exclude from counters */ SELECT user_id, id, topic_id, post_number FROM posts WHERE raw LIKE '%[Magic Exclusion UUID]%' 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') ) ) ) SELECT count(*) AS posts, to_char(created_at,'YYYY-MM') AS month FROM badge_posts bp WHERE bp.topic_id NOT IN ( /* short topics */ SELECT topic_id FROM badge_posts GROUP BY topic_id HAVING count(topic_id) <10 ) AND bp.topic_id NOT IN ( /* Ineligible topics */ SELECT topic_id FROM exclusions ) AND bp.user_id in (SELECT id FROM users WHERE username ILIKE $1::varchar) GROUP BY to_char(created_at,'YYYY-MM') ORDER BY to_char(created_at,'YYYY-MM') ```
Click for interactive graph.](https://plot.ly/~shadowmod/351)
-
No ...
It's just that according to that graph, I shouldn't have the badge.
-
Maybe the badger query is rounding 5.04% to 5%?
-
Wow. That is a pretty big gap too, so the timing doesn't quite explain it.
Dunno. Maybe a few more recent posts from the CS forum changed the total count enough that you got bumped into the club.
-
Except those posts are too old to be included
-
Possibly between the backup being made and the badge being granted, a new person made the requisite 2 posts to be included in the monthposts calculation, slightly improving your % score?
-
Except those posts are too old to be included
You sure? I know that the CS forum was still functional for a while. When was it actually shut down? How recent are the most recent CS posts?
-
The most recent post on the old forums is from 11th Feb, so it'll fall outside the one-calendar-month window of the badger queries.
-
The most recent post on the old forums is from 11th Feb, so it'll fall outside the one-calendar-month window of the badger queries.
But just barely …
-
Actually I keep meaning to go browse the XSS thread on the old forums before it gets shut down. Probably won't look the same over here...
-
And I'm back to 10%.
-
Takes a while to discoupdate, huh?
-
Takes a while to discoupdate, huh?
Seems so. I changed my title awhile ago, even changed to a new tab, did a new post and saw my old title show up.
And still do:
And now when I click for my own user card, I get shuffled up topic.
-
A hard refresh will fix that ;)
-
Which is what I figured opening the site in a new tab and continuing from there would've done, yet...
EDIT: Apparently after editing my previous post, my new title is showing up fine without a hard refresh.
-
And now when I click for my own user card, I get shuffled up topic
Confirmed. Your usercard causes a random scroll. At least for the first click.
-
Hrm... I'm wondering now if a couple of bugs are related.
My user card shuffles you up topic and (apparently now) is one of the ones that breaks the user card description if you try to open someone else's user card after mine.
Hard refresh, still does, another refresh, @aliceif's does as well, as does a few other people's after more refreshes. Only the ones that break the display also do the scroll up, as far as I can see.
-
To get my usercard to display I have to:
- click my avatar (av@tar, geddit?)
- scroll back down the thread
- click someone else's avatar
- click my avatar again
Because it seems broken, but you can never tell with disc-o'-horses what's broken and what's actually working as designed shutup wontfix...
-
Because it seems broken, but you can never tell with disc-o'-horses what's broken and what's actually working as designed shutup wontfix...
Oh, it's definitely broken…
-
Oh, it's definitely broken…
Yeah, but I mean, that's what I've been saying about quoting...
-
-
And I'm out of the 5% again. I really should stay out for a while; I have things to do that are a lot more important than posting here, like looking for a job.
-
I have things to do that are a lot more important than posting here
sure ...
like looking for a job
Oh, that might be a priority ... but no need to exaggerate ... how many postings can one see in a day? 2? 5 if you really, really but your back into it.
-
I'm back in the 5% club!
-
Hurrah!
I'm now in the 2^12 posts club!
-
-
Will do!
-
I have returned
Probably for less than week ...
-
congratulations!
that is cupcake worthy!
-
I'll maybe celebrate once I'll've had it for a week or so.
-
"Cool!" the hedgehog calls down from her tower on high
-
Am I the only person who's had it continuously since last year?
-
"That tower used to be mine and will be again so keep it clean" shouts the fox from below
-
Am I the only person who's had it since last year?
If you fall out and go back in, it doesn't remember the earlier date.
-
Yeah - my post should have said "continuously". Fixed.
-
Please hurry--the sooner you do so the sooner I'll be properly marked as the first spoon holder emeritus.
-
-
...I what?
It's Xaade's fault!
-
congratulations!
-
Am I the only person who's had it continuously since last year?
technically i've been in the 5%+ club continuously since it was created.
but apparently that doesn't count.
-
technically i've been in the 5%+ club continuously since it was created.
There is no +.
-
technically i've been in the 5%+ club continuously since it was created.
Yeah but you've not had the 5% continuously, which is what I said.
-
@todo conspire to get @loopback0 the wooden spoon of shame
-
Todo a4ffff03, (accalia:uncategorized) conspire to get @loopback0 the wooden spoon of shame
-
technically i've been in the 5%+ club continuously since it was created.
Indeed.
Yeah but you've not had the 5% continuously, which is what I said.
I tried, but held the spoon for...like...a day.
-
@todo conspire to get @loopback0 the wooden spoon of shame
-
Todo c84d8ebb, (RaceProUK:uncategorized) conspire to get @loopback0 the wooden spoon of shame
-
I'm more likely to drop down than up. You'd have to shut Spiny up for starters, let alone anyone else
-
My spoon:
-
technically i've been in the 5%+ club continuously since it was created.
but apparently that doesn't count.
Yeah, because there's no 5%+ club. It's a disjoint set.