-NaN% posters and hamster smurfing!
-
i.e. should have started a couple of minutes ago...
-
I believe the choice of start time is mine?
-
My perceived loophole is apparently within the rules. Carry on. Nothing to see here.
-
Will also require a definitive list of excluded categories/topics ;)
-
-
Will also require a definitive list of excluded categories/topics
Anything with a key here:
PM's & flags.
And anything turning up in a search for the UUID:
-
Doable.
Hard, but doable.
-
Doable.
Hard, but doable.
PMs are also excluded.
and some bots have the anonymizer module enabled for sockpuppeting..... :-D
-
-
-
-
-
The Agreement is strong in this one.
-
-
-
I hope they notify the others so we start mention bombing
Everyone's being so mean to me
-
-
@shadowmod monthposts
-
MonthPosts Backup Date: 2015-03-17 03:56:21
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') ) ) ), 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, 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)) <= 25) SELECT row_number as rank, username, percent, count FROM QUERY</details> [<img src="https://plot.ly/~shadowmod/322.svg" height="500" width="700" /><br/>Click for interactive graph.](https://plot.ly/~shadowmod/322) <!-- Posted by SockBot 0.16 "Hazardous Hera" on Tue, 17 Mar 2015 10:06:30 GMT-->
-
-
Huh?
Why didn't my 5% badge get revoked yet?
-
badge query hasn't run yet?
-
Graph says 5.11% ?
I'm at 2.13%... carp...
-
I broke 700‽
-
PostDays abarker Backup Date: 2015-03-17 03:56:21
[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-DD') AS day 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) AND created_at >= (CURRENT_DATE - 30) AND created_at < CURRENT_DATE GROUP BY to_char(created_at,'YYYY-MM-DD') ORDER BY to_char(created_at,'YYYY-MM-DD') ```
Click for interactive graph.](https://plot.ly/~shadowmod/326)
-
That's a lot of 30+ days. Hmph.
-
you've been busy lately it seems.
-
you've been busy lately it seems.
Apparently. Though a certain unnamed someone is nearing three times my post rate.
-
yeah, she's shot past my high water mark too.
-
*can smell something burning*
*splashes ears with water*
*burning smell goes away*
*is wondering why she's posting in a topic that'll make the situation worse*
-
is wondering why she's posting in a topic that'll make the situation worse
you're addicted. addicted i say!
-
Joke's on you: I replied in a thread that doesn't count! Hahaha-
Ah, shit…
-
i love it when people make my point for me. :-P
-
…it seems I'm addicted to making bad jokes too…
-
And I'm back again. Sorry, @aliceif.
-
No need to feel sorry.
-
25% of 100 people = 25 people
25% of X people = 36 people.
Solve for XFiled Under: Though the amount of people is currently growing fast
That's a point there. This club is about to get a helluva lot larger, even after purging the 0-post people.
Filed under: Oh, helluva you understand, but spacetime is not a word?, TDEMSYS!
-
I want to point out that I did not think of that in the slightest when making the post.
Filed Under: I never think about my posts beforehand so I can be suprised later on!
-
And I was wrong anyway.
See other thread, don't feel like crosslinking again.
-
Isn't it all up to how well @ben_lubar made that import script? I also don't feel like cross linking but I don't trust Discourse to handle an import well, yet.
Filed Under: Not even specific to Discourse ... I think import from other systems is a problem most IT people fai
-
That's a point there. This club is about to get a helluva lot larger, even after purging the 0-post people.
Not really. % Poster badges only take into account people who have posted in the last month. AIUI, ben's import script sets the dates on the old posts according to when they were originally created.
-
Isn't it all up to how well @ben_lubar made that import script?
Current data would seem to suggest dates are preserved. At least registration times are. I think it's safe to assume that years worth of content won't be dumped on top of
/latest
either.Not really. % Poster badges only take into account people who have posted in the last month. AIUI, ben's import script sets the dates on the old posts according to when they were originally created.
Yes, @RaceProUK already corrected me. Should've crosslinked with you pendants around though.
-
Yes, @RaceProUK already corrected me. Should've crosslinked with you pendants around though.
That's Viscount Pedantic Dickweed to you!
-
I think it's safe to assume that years worth of content won't be dumped on top of /latest either.
What makes you so sure about that?
-
I'm sure of nothing.
-
I'm going to expect the whole forum to be crushed under seven year's worth of unread content when I arrive tomorrow morning. That way I've set myself up to be pleasantly surprised if it isn't...
-
Whose Badge did I steal this time?
@shadowmod monthposts
-
MonthPosts 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') ) ) ), 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, 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)) <= 25) SELECT row_number as rank, username, percent, count FROM QUERY ```
Click for interactive graph.](https://plot.ly/~shadowmod/346)
-
Uh, what?
-
Were you perhaps trying to do @shadowmod postmonths