-NaN% posters and hamster smurfing!
-
Give in to the dark side … in the thread specifically set aside for you two so you don't start another flame war, please.
-
-
Not to worry; I have enough willpower to hold back ;)
-
in the thread specifically set aside for you two
Even better, in PMs, because Discourse insists on bumping topics to the top of the latest list even if they're muted.
-
Not to worry; I have enough willpower to hold back
But I said to give in, not hold back!
-
11 posts‽ 11 belgium-ing posts‽
Well, I should have that wrapped up this morning.
Unless I miscounted, this post should give me that badge.
-
I count the same. But you'll have to wait until 12:00 GMT tomorrow, when the query is run.
-
I count the same. But you'll have to wait until 12:00 GMT tomorrow, when the query is run.
Yeah, I gotta wait about 20 discohours it looks like. :'(
-
I'm surprised that my lack of activity (it at least feels that way to me) this week hasn't caused me to lose my 10% badge.
-
I'm surprised mine hasn't lost me the 5% badge.
Maybe that's soon@shadowmod monthposts
-
MonthPosts 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 Backup Date: 2015-02-25 03:55:45
-
Oh, further from the edge than I thought.
-
!LikeBot set LikeBotPostMonths @shadowmod PostMonths
!LikeBot get LikeBotPostMonthsedit: oops lel
-
Remembered 'likebotpostmonths' as "@shadowmod PostMonths".
@shadowmod PostMonths
-
PostMonths riking 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') Backup Date: 2015-02-25 03:55:45
-
-
@shadowmod PostMonths
-
I think shadowmod ignores bots?
Already told him yesterday ;)Does it count as Hanzo if it's in a totally different thread?
-
Here we go again...
@shadowmod monthposts
-
MonthPosts 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 Backup Date: 2015-02-27 03:59:29
-
Give it a few days; at my current activity level, I'll be nabbing it some time next week ;)
-
Or getting banhammered.
edit: I even found a Manchester specific image for it.
-
Or getting banhammered.
If anyone does the hammering, it's me! I even have my own hammer:
@loopback0 said:I even found a Manchester specific image for it.
You're first
-
-
Here we go again...
hmm.... you are active in several of those
flamewarsvigorous discussions that i'm avoiding. that's gotta be helping your post count. ;-)
-
-
Discourse is disappoint ... I didn't get a notification although I'm clearly mentioned in your screenshot ...
-
-
I baaaaaaack! For some reason, the only version of my 5% Burns avatar I can find at the moment is a bit unseasonal, but at least it's a hat. Maybe someday Discourse will decide to use it.
-
I see it already ;)
-
I do, too, after a refresh.
-
my 5% Burns avatar I can find at the moment is a bit unseasonal, but at least it's a hat.
Just claim it's for St Paddy's day and you're RG color blind.
-
I could change the color easily enough, though I'm allowing any of the Mad Hatters that care to have a go at it to do so. If nobody does, I'll do it myself. ATM, off to hit the restroom before a meeting in a couple of minutes.
-
any of the Mad Hatters
There's only one Mad Hatter, and that's @abarker; the rest of us are just imitators ;)
-
There's only one Mad Hatter, and that's @abarker; the rest of us are just imitators
And I now sign my works. :)
-
BTW, somebody must be slacking off, because I haven't been posting enough that I should have gotten back into the club.
-
@shadowmod monthposts
-
MonthPosts Backup Date: 2015-03-11 03:59:42
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> Ooooo....new y-axis line! [<img src="https://plot.ly/~shadowmod/292.svg" height="500" width="700" /><br/>Click for interactive graph.](https://plot.ly/~shadowmod/292) <!-- Posted by SockBot 0.16 "Hazardous Hera" on Wed, 11 Mar 2015 19:01:44 GMT-->
-
THERE'S A LINE FOR 2,000 POSTS ON THAT GRAPH
Yes, I know it's my fault…
-
it's not the first time that line has appeared. before i fell to 3rd place (i seem to have passed @tar again) i was up to 1.5k/mo and that seems to be the limit where the 2k line appears for plot.ly
-
THERE'S A LINE FOR 2,000 POSTS ON THAT GRAPH
Yeah, and shadowmod even called it out!
-
BTW, somebody must be slacking off, because I haven't been posting enough that I should have gotten back into the club.
Actually, I think the number of active posters has increased. My ordinal rank (#9) has been relatively unchanged in weeks, but my percentage rank has gone from bouncing around 5% to under 4% in the last few days.
-
-
it's not the first time that line has appeared. before i fell to 3rd place (i seem to have passed @tar again) i was up to 1.5k/mo and that seems to be the limit where the 2k line appears for plot.ly
I was around 1.5k-1.6k and the line wasn't there; now I'm over 1.7k though…
@boomzilla said:Yeah, and shadowmod even called it out!
-
Actually, I think the number of active posters has increased. My ordinal rank (#9) has been relatively unchanged in weeks, but my percentage rank has gone from bouncing around 5% to under 4% in the last few days.
Could be, but it seems to me that I've moved to the left. I'm not sure without comparing it to one from a couple of weeks ago, and I'm too lazy to do that.
-
@shadowmod postsmonth
-
@shadowmod postmonths
-
PostMonths ben_lubar Backup Date: 2015-03-12 03:58:51
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')</details> [<img src="https://plot.ly/~shadowmod/294.svg" height="500" width="700" /><br/>Click for interactive graph.](https://plot.ly/~shadowmod/294) <!-- Posted by SockBot 0.16 "Hazardous Hera" on Thu, 12 Mar 2015 05:55:15 GMT-->
-
@shadowmod Portsmouth
-
@shadowmod daypostssinceIjoinednotjust30days