I’m not well-versed in these queries but I have been using this (and others with different post requirements) query I got from the Discourse meta site to reward posting to a particular category. SELECT P.user_id, MIN(P.created_at) granted_at, MAX(P.id) post_id FROM badge_posts P JOIN topics T ON T.id = P.topic_id WHERE T.category_id IN (SELECT id FROM categories WHERE id = 56 OR parent_category_id = 6) AND P.user_id >= 0 GROUP BY P.user_id HAVING COUNT(*) >= 1 I was wondering how exactly I could change this to: A) Require new TOPICS, not just posts in the category and B) How I could include subcategories. So not just category 6, but also subcategories 7,8, and 9. Thanks so much.

[图片] Bernstein: I finally realized why this code wasn’t working. I can’t award badges to categories that are limited to certain trust levels. You can do this. The problem is that the query is using the badge_posts table. The badge_posts table doesn’t include posts from protected categories. If the query is changed to use the posts table instead of the badge_posts table, it should work.

I finally realized why this code wasn’t working. I can’t award badges to categories that are limited to certain trust levels. I have a category that is only accessible/visible to trust level 2+ Badges won’t work for that group. Is that a bug or feature? Is there any way around it?

It is a feature, ask @sam about it.

@sam, is there any way around this? The category is a corner of my forum designed to be earned by “leveling” up your trust level and contributing. I don’t mind if people who can’t access can see the badges earned from it. It’s meant to be something to work toward.

Need help with an SQL badge query

Community Building Data & reporting

simon 2019 年11 月 29 日 21:43 6

你可以实现这个功能。问题在于查询使用了 badge_posts 表，而该表不包含受保护分类中的帖子。如果将查询改为使用 posts 表而不是 badge_posts 表，应该就能正常工作。

话题		回复	浏览量
Badges for posting Data & reporting sql-triggered-badge	4	582	2024 年8 月 27 日
[PAID] Allow badges to be granted in restricted categories Marketplace	8	2197	2017 年10 月 27 日
Some common badge queries Data & reporting sql-triggered-badge	0	9139	2015 年8 月 7 日
Badge for replies in a specific category Data & reporting sql-triggered-badge	3	305	2015 年8 月 28 日
Badges for specific category Feature	1	1326	2018 年6 月 13 日

Need help with an SQL badge query

相关话题