Hi there I’m trying to earn badges! I’m currently looking at how to get the “Read 100 posts” badge and I’m wondering if there is ANY topic with that many posts? I’ve looked up a few other topics, but noone reached 100posts Any tips? Thanks in advance!
Okay so now I have read a hundred topics under Javascript/Create your own adventure and I don’t have the badge, might it be bugged?
@sralse I think Discourse hands out badges to everybody who’s earned one once every twenty four hours or so. If you wait until tomorrow afternoon, you should’ve gotten your badge by then
Okidoki Thank you very much!
Still no badge :’( …
I don’t think we are looking at the right #. We need to find a “a topic with more than 100 posts”. I’m not sure we have one of those here yet.
Yeah we have, go to JavaScript/Code your own adventure
Count the amount of topics starting by “inspect Elementing” the frst topic and the last, the ID’s are over a 100 diffrence… hus more as 100 topics… I’ve read all of them now…
I think that isn’t what this badge is counting. We need one topic that has 100+ posts.
That’s what I ment, take a look, and count the amount of posts.
JavaScript/Code your own adventure is a category.
Each thread in that category is a topic. This badge isn’t counting topics.
We want a topic with 100+ posts.
This is my opinion, I haven’t see the SQL command that is pulling the data for that badge.
Hmm I thought a post was in a topic, and a topic is in a category
If you go to the list of all topics: http://discuss.codecademy.com/latest
And sort it by Replies, I think that might be the number it is looking at.
But those are replies, not posts right?
They are replies, but I think that is another word for posts.
Categories have a “c” in their URL: http://discuss.codecademy.com/c/Meta
Topics have a “t” in their URL: http://discuss.codecademy.com/t/badges-howto/7283
Replies are Posts, they add an incremental integer to the end of the “t” URL that they live in: http://discuss.codecademy.com/t/badges-howto/7283/9
From [the Badges page][1]: “Read every post in a topic with more than 100 posts”.
To get the Reader badge we need to have a topic with 100+ posts in it. Our forums are new, and we don’t have a topic that meets that criteria yet.
Last night I went to another Discourse site, one that did have some topics with 100+ posts and read one of them … it took a while I don’t know if it can distinguish one just scrolling through them all quickly or does it look at the time it takes you, but I went slow just in case. When I went back to check today, I found that I had the Reader badge.
[1]: http://discuss.codecademy.com/badges
Question. Do you know if the “Help Desk” badge is available? I’m not sure that I have 10 or more solutions, but I am sure at least one person does by now.
We have a topic with 100+ posts in it now … give it a read and then we’ll see if the badge kicks in.
We have 14 people with the Reader badge, http://discuss.codecademy.com/badges/17/reader, so we know that one is working.
This one doesn’t seem to be kicking in.
@alexcommunitymgr, are you able to see why this badge is not being awarded?
Go to the Introducing thingy
It seems to be correct SQL?
SELECT id user_id, current_timestamp granted_at
FROM users
WHERE id IN (
SELECT p1.user_id
FROM post_custom_fields pc
JOIN badge_posts p1 ON p1.id = pc.post_id
JOIN topics t1 ON p1.topic_id = t1.id
WHERE p1.user_id <> t1.user_id AND
name = 'is_accepted_answer' AND
p1.user_id IN (
SELECT user_id
FROM posts
WHERE :backfill OR p1.id IN (:post_ids)
)
GROUP BY p1.user_id
HAVING COUNT(*) > 9
)