Can the 'X% Poster'-Badges just stay?
-
How often is this calculated? Daily?
Once a day. When during the day appears to be largely a function of when the job was last manually run ± some DiscoTime.
-
Most roller shutters that lower automatically actually do so at a daily +- random time approach to make potential thieves think somebody is at home, lowering them manually.
Maybe Discourse wants you to think that somebody activates these badges manually, so you don't hack into the system!Filed Under: Best practices and stuff!
-
Maybe Discourse wants you to think that somebody activates these badges manually, so you don't hack into the system!
No. They're using SideKiq instead of something crontab-like.
-
@shadowmod MonthPosts
:-D
-
@shadowmod? hello?
-
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: Wed, 07 Jan 2015 04:01:55 GMT
-
oh. there you are!
you had me worried!
-
What categories is this bot restricted to?
Filed Under: Inb4 abuse
-
same as any other..... none, but it won't reply to posts from, or topics opened by anyone on the bots ignore list.
right now the default list is just paulabean (so they mostly stay out of articles) and blakeyrat (because they annoy him)
i don't think @pjh changed the ignore list for shadowmod...?
-
i don't think @pjh changed the ignore list for shadowmod...?
You've seen 99% of the config - the only thing I've done is munged any passwords before you got it.
-
You've seen 99% of the config - the only thing I've done is munged any passwords before you got it.
ah. then no, you're still running the default ignore list.
so the bot will ignore:
- Muted topics (currently has to be done manually)
- other bots (unless they are staff (mod/admin/bot owner))
- TL0 users
- TL1 users that have interacted with the bot in the past 10 minutes
- Users that have been ignored
- Topics that were started by users that have been ignored
and, yes all sockbots consider me their default owner. @pjh has overridden that so he is the owner of shadowmod
-
12 | RaceProUK | 5.97 | 379
Ah, that explains why I flit between 10% and 5% occasionally...Not far off the top 10 either
-
you dropped a bit percentage yesterday....
yesterday was a good day for me....
-
*looks at own count*
*looks at @accalia's count*
*dies from shock*
-
dies from shock
#CLEAR!
/me zaps @RaceProUK with a defibrillator
yeah.... i've been busy this past month...
-
Yeah busy not shutting the fuck up.
-
/me zaps @RaceProUK with a defibrillator
You do know those aren't actually used to restart a heart, right? They're not jump leads
-
Aren't they basically like the lightning bolt Frankenstein used?
-
They're not jump leads
..... but then why do they always use one when someone flatlines on ER? and why did my first responder training include the use of an AED?
-
..... but then why do they always use one when someone flatlines on ER? and why did my first responder training include the use of an AED?
Defibrillation != kick-starting ;)
-
IIRC, a heart attack is basically a breakdown in the regulation of the electrical impulses that make the heart pump, causing chaotic behaviour. A defibrillator gives a big jolt in the hopes that it will override the chaotic fluctuations and let the normal rhythm take over again. It's not a particularly sophisticated tool
-
but then why do they always use one when someone flatlines on ER?
BecauseERTV LIES!
@accalia said:and why did my first responder training include the use of an AED?
So you can treat fibrillation; that's why it's called a defibrillator
-
huh.... well then.
/me "borrows" one of Zeus' thunderbolts.
you still need that kickstart?
-
/me "borrows" one of Zeus' thunderbolts.
Surely Mötley Crüe is easier to procure?
https://www.youtube.com/watch?v=uZ5BUEJR0zU
@accalia said:you still need that kickstart?
Clearly not, as I'm posting stillUnless I turned into a zombie and hadn't noticed...
-
when someone flatlines
http://tvtropes.org/pmwiki/pmwiki.php/Main/Flatline (usual timesink warning. And hey- it beats citing PikiWeedia)
Rule of Perception says that a flatline on film is always... well, a flat line. However, in Real Life a recently asystolic patient would still show occasional waves on the screen, a condition also known as Pulseless Electrical Activity - the electrical signal to beat is being generated, but the heart muscle isn't responding anymore.
but then why do they always use one when someone flatlines on
ERTV?http://tvtropes.org/pmwiki/pmwiki.php/Main/MagicalDefibrillator
While early defibrillation is instrumental in improving survival ratios for witnessed and unwitnessed cardiac arrests, there is a specific time window in which shock must be applied. In general, if defibrillation isn't applied within four minutes after the onset of arrest, the odds of successful conversion drop drastically.
A defibrillator does not restart the heart. It stops a dysfunctional rhythm (e.g. pulseless tachycardia: beating too fast without effective pumping, or fibrillation: irregular beating without pumping) in the hope that the heart's intrinsic mechanisms will restore an effective rhythm.
-
stuff
The flatline does tell you something though: it tells you someone tripped over a cable and pulled it out of the machine
-
The flatline does tell you something though: it tells you someone tripped over a cable and pulled it out of the machine
Well quite - from my flatline link:
If the scene is being played for comedy, the "flatline" may be the result of the patient playing with the monitor leads, getting up for a bathroom trip, a guest accidentally tripping over the monitor, or other such mundane causes.
-
Unless I turned into a zombie and hadn't noticed...
Stay away from me and my brains ...
-
Stay away from me and my brains ...
i'd say what brains, but then i wouldn't be able to say: "What he said!"
-
-
And this is bad, how?
because this thread:
http://what.thedailywtf.com/t/can-we-please-nuke-the-fucking-bots/3213
that was not a good day for me. and i don't want it to happen again.
-
Fair enough.
People annoying @blakeyrat: good. Bots annoying @blakeyrat: bad.
-
exactly.
well at least on your seccond assetion. i'm going to plead the fifth on the first.
-
i'm going to plead the fifth on the first.
Riiiiiiiiight!
[spoiler]Would that be a fifth of fermented potato water?[/spoiler]
-
Fair enough but I don't see how the bots ignoring him fixes them annoying him. He's not going to be triggering them anyway.
-
Would that be a fifth of fermented potato water?
depends on the brand. if i'mma gonna have a whole fifth it had better be top shelf and then some.
-
because ignoring him has the side effect of banning them from topics where he's OP.
reduces his contact with them dramatically.
-
Fair enough but I don't see how the bots ignoring him fixes them annoying him. He's not going to be triggering them anyway.
Part of the ignoring is that they stay out of threads he starts.
-
Aha - hadn't thought of that.
-
-
@abarker - Last Day Without A Discourse Bug: null
-
@abarker Is Doing It Wrong™
-
what are we doing here? ;-)
-
what are we doing here? ;-)
Brain malfunction. I blame having to handle my work and having to fix everything my former cow-orker belgium-ed.