-NaN% posters and hamster smurfing!
-
well, yes. but that is more a sipplimentary attribute.
also mobile typing without swype sucks!
-
-
sipplimentary
I'm normally willing to cut you some slack on typos, especially on mobile (except when it can be exploited for lulz), but I am failing to parse this. The obvious translation is "supplementary," but that doesn't seem to fit the context.
-
it's more beneficial to abuse it for 5% and 2^n
Fair point. I'd assumed you were in the 5% club already. Now I know you're not, you're competition! :O
-
supplimentary was the word i was going for.
indicating that spamming and bad spellaring are two different continum scales that both operate on posts.
-
I tend to near the 5%/10% boundary. Between work and the holidays, I've slipped to about the middle of the 10% range. If I were currently in the 5%, I'd be using my Burns avatar, most likely.
-
-
we do like that one don't we?
Um, are you referring to the community, or are you using the royal we?
-
the community. @accalia tends to speak in the third person to refer to herself for comic effect
she also does it if you interrupt her RPG sessions and she's still in character.
BRB. need to finish casting this greater fireball spell.
-
Well,
-
I got caught up in this topic
-
quicker than I thought I would...
-
I'm a little surprised that I'm a 5% Poster at the moment. I'd expect someone to take that from me now I'm back at work...
-
-
I need to be chattier if I'm going to take that badge back.
-
@shadowmod monthposts if you're online?
-
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: Sun, 11 Jan 2015 03:33:17 GMT
-
That's a significant drop between @tarunik and me.
Good thing I'm still barely inside the 10%-tier.
-
Hm, I seem to be slowly rising toward 10% (currently at 12-ish). Guess I'm posting more...
-
-
I'm a little surprised that <i>I'm</i> a 5% Poster at the moment. I'd expect someone to take that from me now I'm back at work...
The holidays interrupted a lot of normal posting patterns.
-
-
@StatsBot attendance tar
-
maybe shadowmod? @pjh decided not tu use the @statsbot account i set up for some strange reason. :-P
-
@shadowmod attendance tar
-
Attendance tar 25 WITH StartingPoints AS ( SELECT user_id, visited_at, ROW_NUMBER() OVER(ORDER BY user_id, visited_at) AS rownum FROM user_visits AS A WHERE NOT EXISTS ( SELECT * FROM user_visits AS B WHERE B.visited_at = A.visited_at - 1 AND B.user_id = A.user_id ) ), EndingPoints AS ( SELECT user_id, visited_at, ROW_NUMBER() OVER(ORDER BY user_id, visited_at) AS rownum FROM user_visits AS A WHERE NOT EXISTS ( SELECT * FROM user_visits AS B WHERE B.visited_at = A.visited_at + 1 AND B.user_id = A.user_id ) ) SELECT u.username, S.visited_at AS start_range, E.visited_at AS end_range, (E.visited_at - S.visited_at +1) AS Days FROM StartingPoints AS S JOIN EndingPoints AS E ON E.rownum = S.rownum JOIN users u ON u.id=S.user_id AND u.username ILIKE $1::varchar ORDER BY S.visited_at DESC LIMIT $2::int username | start_range | end_range | days tar | 2014-12-13 | 2015-01-11 | 30 Backup Date: Sun, 11 Jan 2015 03:33:17 GMT
-
D'oh! That's what I get for copy pasting my queries before.
-
Next Friday then. Make sense, I joined up on a Friday...
-
uhh..... no i think you'd get 31% tomorrow actually, since you're at 30 today. :-P
-
Next Friday then.
Does Friday come after Sunday in your world?
username | start_range | end_range | days
tar | 2014-12-13 | 2015-01-11 | 30Backup Date: Sun, 11 Jan 2015 03:33:17 GMT
Looks like you're set to be eligible in a few discohours.
EDIT: Hanzo'd, because I put in more detail.
-
Friday could be a few Discohours away from Sunday considering that a Discohour is both an unknown and inconsistent quantity.
-
And @tar should have his 31% badge next Friday, since he's already been here today. Just that he should have it before then.
-
Attendance tar 25
I only read the frist line! I thought it was telling me my attendance was 25 days...
-
indeed. assuming he wasn't online here before 03:33 UTC today. otherwise he still has a day to go.
-
nope. that's mostly a debugging aide. it tells you the name of the query being run and what parameters it's being run with. that way you cna fill in yourself what $1::varchar and $2::int are and see the query as it is queried.
in this case the 25 is the maximum number of rows we're allowing in the result set. people who have breaks in their attendance can accumulate quite a few rows and that puts a maximum limit on them.
-
I expect I'll get it tomorrow evening local time (PST) then...
-
Oh, right...got the UTC direction backwards. A few hours yet...
-
keep this up and i am sure it will be excluded..
I was in two minds about it...
Consistent abuse in a topic will get it excluded.
Occasional abuse in a topic will probably be ignored.
Knowing you lot )having been provided with these criteria(, consistent occasional abuse will result in them being excluded.
Parens typo left in for amusement value...
-
Knowing you lot )having been provided with these criteria(, consistent occasional abuse will result in them being excluded.
i find the fact that we need this clause far more ammusing than i really should.
:-D
-
i find the fact that we need this clause far more ammusing than i really should.
I find your consistent occasional typos far more ammusing (sic) than I really should. :)
-
Hmm, let's see:
@shadowmod attendance frostcat
-
Attendance FrostCat 25 WITH StartingPoints AS ( SELECT user_id, visited_at, ROW_NUMBER() OVER(ORDER BY user_id, visited_at) AS rownum FROM user_visits AS A WHERE NOT EXISTS ( SELECT * FROM user_visits AS B WHERE B.visited_at = A.visited_at - 1 AND B.user_id = A.user_id ) ), EndingPoints AS ( SELECT user_id, visited_at, ROW_NUMBER() OVER(ORDER BY user_id, visited_at) AS rownum FROM user_visits AS A WHERE NOT EXISTS ( SELECT * FROM user_visits AS B WHERE B.visited_at = A.visited_at + 1 AND B.user_id = A.user_id ) ) SELECT u.username, S.visited_at AS start_range, E.visited_at AS end_range, (E.visited_at - S.visited_at +1) AS Days FROM StartingPoints AS S JOIN EndingPoints AS E ON E.rownum = S.rownum JOIN users u ON u.id=S.user_id AND u.username ILIKE $1::varchar ORDER BY S.visited_at DESC LIMIT $2::int username | start_range | end_range | days FrostCat | 2014-09-14 | 2015-01-11 | 119 FrostCat | 2014-08-20 | 2014-09-12 | 24 FrostCat | 2014-08-17 | 2014-08-17 | 1 FrostCat | 2014-08-08 | 2014-08-14 | 7 FrostCat | 2014-08-06 | 2014-08-06 | 1 FrostCat | 2014-08-04 | 2014-08-04 | 1 FrostCat | 2014-08-01 | 2014-08-02 | 2 FrostCat | 2014-07-27 | 2014-07-27 | 1 FrostCat | 2014-07-23 | 2014-07-23 | 1 FrostCat | 2014-07-20 | 2014-07-21 | 2 FrostCat | 2014-07-18 | 2014-07-18 | 1 FrostCat | 2014-07-16 | 2014-07-16 | 1 FrostCat | 2014-07-12 | 2014-07-13 | 2 FrostCat | 2014-07-08 | 2014-07-10 | 3 Backup Date: Sun, 11 Jan 2015 03:33:17 GMT
-
I find your consistent occasional typos far more ammusing (sic) than I really should.
and the fact that my bad spelling is consistently inconsistent (i don't have favorite words (other than spelling that i play with on purpose) to misspell)
-
@shadowmod attendance antiquarian
-
shadow mod seems less than stable.... i'm not sure why.
@pjh..... is it giving any output that might tell me why its going AWOL like this?
-
my bad spelling is consistently inconsistent
It's very appropriate here; it's Discoursistent™.
-
And I lost it ...
-
@shadowmod monthposts
-
I think he's dead. Or sleeping.
-
That box seems to be down for some reason - I can't ssh onto it...
OSSEC appears to indicate it died 0120UTC this morning :/ - won't be able to do much until I get home this evening...