Can the 'X% Poster'-Badges just stay?


  • Winner of the 2016 Presidential Election

    As the title says! I find it kind of annoying to get into the 25% posters every day! (besides yesterday where I didn't post on purpose)
    And every time I get the badge, the Bubble gets a blue notification like somebody replied so I happily click it just to find out I got the same badge I got yesterday....
    Can't we just make the badges stay and not revevaluate? Once somebody was in the top 1% even if he was that active years ago the badge still has meaning.

    Filed Under: Just my 25percents


  • sockdevs

    wait.... you get less than 10 notifications a day?

    whaaaaaaaaaaaaaa?

    hmm.... @pjh, maybe we could figure out how to make a grace period so you can't lose the 25% badge for like a week after you get it to prevent popcorn notifications like this?

    i mean they did that for TL3 so presumably it can be done for other badges.....? ne?


  • Discourse touched me in a no-no place

    The notifications should only trigger on a chango of band, not every day while staying in the same one; I certainly don't recall getting daily 5% and 10% notifications, only while moving between them.

    I'll check the 25% query tomorrow, but @Kuro, are you sure you're not floating in and out the top 25%?

    TL3 is graced in code, not in SQL.


  • Discourse touched me in a no-no place

    @PJH said:

    The notifications should only trigger on a chango of band, not every day while staying in the same one; I certainly don't recall getting daily 5% and 10% notifications, only while moving between them.

    I certainly didn't: I got the initial "too much time" one, and then I got the 5% once. (Oh, and then I wound up with the "too much time" one again for a couple of days, and I got one notification for each band.)

    It sure sounds more like he's flipping in and out of the 25%, in which case he should just get in a couple more posts a day. It probably wouldn't be hard to write a bot for that. :smile:

    Or maybe there's, as you guessed, a bug specific to the 25%.


  • Winner of the 2016 Presidential Election

    @PJH said:

    I'll check the 25% query tomorrow, but @Kuro, are you sure you're not floating in and out the top 25%?

    @Kuro said:

    As the title says! I find it kind of annoying to get into the 25% posters every day!

    As it is custom in this forum, lets get pedantic: to get into the 25% posters means I am clearly floating in and out.
    Maybe I used an hyperbole on the whole every day thing. It sure feels like it.

    Like really...

    @accalia said:

    wait.... you get less than 10 notifications a day?

    Thats because I am only in the top 25%. Obviously!

    Filed Under: My Request still stands


  • Discourse touched me in a no-no place

    @Kuro said:

    As it is custom in this forum, lets get pedantic: to get into the 25% posters means I am clearly floating in and out.

    We didn't have enough information until then to be sure. Did you check on alternate days (or whatever) to verify you didn't have the badge?

    Edit: also I'm trying to help you boost your post count so you can stay in the 25%.


  • Discourse touched me in a no-no place

    @Kuro said:

    As it is custom in this forum, lets get pedantic: to get into the 25% posters means I am clearly floating in and out.

    So there isn't a bug then...

    Those badges were designed to reflect the current state, not as a record of past achievements.

    I rather hoped that the boundaries I chose were reasonable but at low posting volumes (we're down to 50 in the whole 25% cohort) there will be some movement of members between them and not quite sure how to introduce hysteresis into it.



  • The bug is that it shows you notifications about things that don't exist.


  • Winner of the 2016 Presidential Election

    Where the hell did you get "Bug" from?
    Did I post this in Bugs? No!
    Is it 5AM and I didn't got a wink of sleep this night? Yes? Should I post like this? Heck No/Yes!

    See, all I was asking was to maybe think about making them permanent so people like me wouldn't slip in and out every two days. (or daily, or maybe every 3 days.... let's make that Discodaily)
    It's fine if you don't change it, really. There is worse out there. I just have a notification every once in a while.

    Also:
    I usually post like 1 post per day.... how the hell do I slip in and out with that? Is it the whole Likes-Thread wearing of?

    @FrostCat said:

    We didn't have enough information until then to be sure.

    But I said "get into" in my original post! So there is that!

    @FrostCat said:

    Did you check on alternate days (or whatever) to verify you didn't have the badge?

    I honestly don't care enough for the badge to even ever look at it. I just see the notification, think of something witty to answer, find out there is nothing to answer to and feel sad or something!

    @FrostCat said:

    Edit: also I'm trying to help you boost your post count so you can stay in the 25%.

    Welp, thanks, I guess? Now I will (maybe) be safe for another Discoday.
    I mean, yeah, I could just post a whole lot and hope to stay in the 25% forever. But that would just push the "burden" off to the next guy.... So there is that!

    @ben_lubar said:

    The bug is that it shows you notifications about things that don't exist.

    Well, the badge exists at the time I get the notification. The "bug" - if you want to call it that - is that I get the badge so often that it annoyed me :smiley:

    Filed Under: Final post before I go to sleep!


  • Discourse touched me in a no-no place

    @Kuro said:

    Where the hell did you get "Bug" from?

    Most commentary on here about features of Discourse tend to be about bugs therein - I just buttumed...



  • @Kuro said:

    I just have a notification every once in a while.

    We could make it so you get lots of notifications all the time. You'll never notice the 25% notifiers.


  • Winner of the 2016 Presidential Election

    You have an interesting way of thinking.

    Client: "Hey, my product keeps blowing up. Thats kinda annoying and stuff!"
    You: "We can blow your hourse up so you won't notice the product blowing up anymore!"

    Okay, so let's try this another way:
    Why are the % posters badges not permanent? Would being in the 1% at some point not be good enough for a constant badge?
    Also: Is the badge depending on the last 100 days or all time?

    Filed Under: If I wanted notifications all the time I would either post interesting posts or just spam the t/1000/



  • @Kuro said:

    You have an interesting way of thinking.

    I'm a parent.


  • BINNED

    When I was a kid, if I hurt a finger my Dad would offer to hurt the same finger on the other hand so it evened out


  • sockdevs

    @Kuro said:

    Why are the % posters badges not permanent?

    because they are meant to reflect the current status of the site, not just that you were once a x% poster

    @Kuro said:

    Also: Is the badge depending on the last 100 days or all time?

    neither. the period is one month. so an average of about 30.3 days


  • Discourse touched me in a no-no place

    @Kuro said:

    Why are the % posters badges not permanent? Would being in the 1% at some point not be good enough for a constant badge?

    I've already answered that.

    If you're after "ee when i were a lad, I posted lots of stuff" badges, we have the 2^n series for that.


  • Winner of the 2016 Presidential Election

    Oh, you actually did. I blame overreading it on being so tired :smiley:

    Oh well...I give up. I'll just either post more or less so I stop dropping in and out, I guess.

    @accalia said:

    neither. the period is one month. so an average of about 30.3 days

    Oh... welp then you guys need to post more so people like me don't get into 25% that easily ;P

    Filed Under: I am really not after badges if thats what you tried to say there. I am just happily reading along :D


  • sockdevs

    @Kuro said:

    Oh... welp then you guys need to post more so people like me don't get into 25% that easily

    as the current holder of the wooden spoon of "I have too much time on my hands" i'm doing my best! maybe people like @frostcat need to step up and post more? :-P



  • @Kuro said:

    Oh... welp then you guys need to post more so people like me don't get into 25% that easily

    Yeah, this is one you can't blame on people like us.


  • Discourse touched me in a no-no place

    FWIW - current standings (as of 0400UTC this morning):

    [postgres@sofa ~]$ LIMIT=75 sql_tdwtf month_posts            
    # post counts over last month
    debug1: client_input_channel_req: channel 0 rtype keepalive@openssh.com reply 1
    WITH exclusions AS ( /* Which categories to exclude from counters */
            SELECT user_id, id, topic_id, post_number
            FROM posts
            WHERE raw LIKE '%[UUID removed to prevent this thread accidentally being marked as excluded]%' 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, user_id, 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)) < 30
    LIMIT 75)
    SELECT row_number as rank, username, percent, count
    FROM QUERY
    
     rank |       username       | percent | count 
    ------+----------------------+---------+-------
        1 | accalia              |    0.50 |  1512
        2 | FrostCat             |    1.00 |  1128
        3 | boomzilla            |    1.49 |   788
        4 | chubertdev           |    1.99 |   649
        5 | abarker              |    2.49 |   523
        6 | loopback0            |    2.99 |   512
        7 | blakeyrat            |    3.48 |   496
        8 | Intercourse          |    3.98 |   415
        9 | ben_lubar            |    4.48 |   414
       10 | PJH                  |    4.98 |   384
       11 | dkf                  |    5.47 |   382
       12 | RaceProUK            |    5.97 |   379
       13 | mott555              |    6.47 |   303
       14 | Luhmann              |    6.97 |   249
       15 | tar                  |    7.46 |   239
       16 | HardwareGeek         |    7.96 |   225
       17 | Jaloopa              |    8.46 |   211
       18 | flabdablet           |    8.96 |   210
       19 | aliceif              |    9.45 |   196
       20 | tarunik              |    9.95 |   179
       21 | hungrier             |   10.45 |   173
       22 | Eldelshell           |   10.95 |   149
       23 | Yamikuronue          |   11.44 |   142
       24 | Maciejasjmj          |   11.94 |   132
       25 | PleegWat             |   12.44 |   128
       26 | Magus                |   12.94 |   127
       27 | anonymous234         |   13.43 |   124
       28 | antiquarian          |   13.93 |   120
       29 | Buddy                |   14.43 |   116
       30 | JazzyJosh            |   14.93 |   112
       31 | Gaska                |   15.42 |   111
       32 | Zecc                 |   15.92 |   100
       33 | Jaime                |   16.42 |    93
       34 | Weng                 |   16.92 |    88
       35 | ijij                 |   17.41 |    87
       36 | cartman82            |   17.91 |    86
       37 | codinghorror         |   18.41 |    80
       38 | another_sam          |   18.91 |    80
       39 | lucas                |   19.40 |    78
       40 | locallunatic         |   19.90 |    70
       41 | created_just_to_disl |   20.40 |    65
       42 | lolwhat              |   20.90 |    64
       43 | redwizard            |   21.39 |    63
       44 | smallshellscript     |   21.89 |    61
       45 | sam                  |   22.39 |    59
       46 | Groaner              |   22.89 |    54
       47 | powerlord            |   23.38 |    53
       48 | Bulb                 |   23.88 |    53
       49 | VinDuv               |   24.38 |    51
       50 | Kuro                 |   24.88 |    49
       51 | izzion               |   25.37 |    45
       52 | OffByOne             |   25.87 |    45
       53 | EvanED               |   26.37 |    44
       54 | xaade                |   26.87 |    44
       55 | Keith                |   27.36 |    44
       56 | TwelveBaud           |   27.86 |    43
       57 | KillaCoder           |   28.36 |    43
       58 | JBert                |   28.86 |    42
       59 | Monarch              |   29.35 |    41
       60 | Nprz                 |   29.85 |    39
    (60 rows)
    
    Elapsed: 64.687s
    Backup taken:  2015-01-06 04:01:13.091911
    
    

    Which also confirms my almost certain knowledge that I'm the one of the ones balanced between 5% & 10%...

    But since I'm back at work, that'll probably change.


  • BINNED

    @PJH said:

    17 | Jaloopa | 8.46 | 211

    Ooh, I'm firmly in the middle of 10%. That explains why I haven't been flitting between 10 and 25 recently



  • Except for the first two, output has been down with holidays and vacation for most of us.


  • sockdevs

    because i could.

    also i really need to get statsbot finished and sent to @pjh so we can get these graphs automagically.


  • Discourse touched me in a no-no place

    I'm not too sure about the validity of only printing every other value on that particular X axis...


  • sockdevs

    sorry, the SVG render does that. you can click through to the full interactive chart.

    that has all the usernames



  • Christ - I'm now in the top 3%?!
    I didn't think I was posting that much more.

    Also - 2^9 posts exactly.


  • sockdevs

    @loopback0 said:

    Also - 2^9 posts exactly.

    well..... not anymore. :-P


  • Discourse touched me in a no-no place

    @boomzilla said:

    Except for the first two, output has been down with holidays

    No, the last couple of times the numbers were posted I was within a few tens of @accalia at 1500+.


  • sockdevs

    @FrostCat said:

    No, the last couple of times the numbers were posted I was within a few tens of @accalia at 1500+.

    true enough. you even took the spoon back from me, briefly, once.


  • Winner of the 2016 Presidential Election

    So how do you feel about the fact that @Arantor is not here right now? I would be expecting a close race if you guys battled for the position of the biggest spammerposter

    Filed Under: Where is @Arantor anyway? Did we scare him away?


  • sockdevs

    @Kuro said:

    So how do you feel about the fact that @Arantor is not here right now?

    i miss the guy and hope he comes back soon.

    @Kuro said:

    I would be expecting a close race if you guys battled for the position of the biggest spammerposter

    nah, no contest. even when he was here i posted way more than he did.

    could be fun though, to see how high i can push that number without getting flagged spam.....


  • Winner of the 2016 Presidential Election

    @accalia said:

    could be fun though, to see how high i can push that number without getting flagged spam

    You were so close to getting a spam-flag for this! But that would mean more work for our mods and I really don't want to get on their bad side (more than I currently am)

    Filed Under: you can get flagged pretty easily with me around :D


  • sockdevs

    @Kuro said:

    I really don't want to get on their bad side (more than I currently am)

    i'm far more likely to be on their bad side. from sheer statistics.

    i mean i average more posts in a day than you do in a month (no offense intended, i promise) so statistically i'm far more likely to have problems with the mods than you are. :-P


  • Discourse touched me in a no-no place

    @PJH said:

    11 | dkf | 5.47 | 382

    So close!


  • mod

    @PJH said:

    I certainly don't recall getting daily 5% and 10% notifications, only while moving between them.

    I just did a check over the past few days. I'm not getting daily notifications of the 5% badge.


  • mod

    Damn. I'm climbing up the ranks. I used to be #8. Now I'm #5.


  • mod

    @Kuro said:

    Click "view older notifications" and screenshot that. It'll give us the dates so we can see when you got those notifications. That'll determine whether the notifications are because of border crossing.



  • @Kuro said:

    Did we scare him away?

    We didn't.


  • sockdevs

    @loopback0 said:

    We didn't.

    according to him (VIA Pm that i'm not sharing because personal) we did, indirectly. we did nothing to stop what drove him away, and it damn near drove me away too.


  • Winner of the 2016 Presidential Election

    @abarker said:

    That'll determine whether the notifications are because of border crossing.

    The smallest amount inbetween is two days, so bordercrossing is pretty much the problem.
    But as an enduser I actually don't care why it is the way it is. I just see that I get that badge a lot and it starts to annoy me. Hence I make this topic :smiley:

    @accalia said:

    we did nothing to stop what drove him away, and it damn near drove me away too.

    Maybe some of us did but nobody noticed!

    Filed Under: Does he still reply to PMs sometimes? Or is this old stuff?


  • sockdevs

    @Kuro said:

    Maybe some of us did but nobody noticed!

    Fair enough. your point is taken

    @Kuro said:

    Filed Under: Does he still reply to PMs sometimes? Or is this old stuff?

    occasionaly. it seems he logs in every couple of weeks to check on us and will sometimes answer PMs. send him one and see what happens!



  • @Kuro said:

    Hence I make this topic

    Which should prevent border crossings in the near future. Unless you get really uppity.



  • @Kuro said:

    accalia:
    wait.... you get less than 10 notifications a day?

    Thats because I am only in the top 25%. Obviously!

    You could post in the Likes thread, then you'd end up with more notifications per day. Those are most of the notifications I usually get, and I've been posting less (where it counts), so I fell out of the 25% club.


  • I survived the hour long Uno hand

    wat.

    I post too much.



  • @PJH said:

    14 | Luhmann

    Where did I deserve that?



  • I've noticed that I've flipped into the top 25% twice in the past week as well.

    How often is this calculated? Daily?


  • Discourse touched me in a no-no place

    @Luhmann said:

    Where did I deserve that?

    You're probably better off concentrating on the third column, not the first...



  • @PJH said:

    concentrating on the third column, not the first

    If I was aiming for something ... I'm entering a busy period with an extra looking over my shoulder at work ...



  • @Jaloopa said:

    I'm firmly in the middle of 10%

    As am I, which is not surprising after being AFK so much during the holidays. It will take some work to get back into the 5%. It remains to be seen whether being busy at work, or finally having access from home, has the bigger influence my posting output.



  • @powerlord said:

    How often is this calculated? Daily?

    Indeed.


Log in to reply
 

Looks like your connection to What the Daily WTF? was lost, please wait while we try to reconnect.