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…

[画像] 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. I…

Need help with an SQL badge query

データとレポート

codinghorror (Jeff Atwood) 2017 年 10 月 23 日午前 3:19 3

It is a feature, ask @sam about it.

[PAID] Allow badges to be granted in restricted categories

トピック		返信	表示
Badges for posting Data & reporting sql-triggered-badge	4	370	2024 年 8 月 27 日
[PAID] Allow badges to be granted in restricted categories Marketplace	9	2002	2017 年 11 月 26 日
Some common badge queries Data & reporting sql-triggered-badge	0	8704	2015 年 8 月 7 日
Badge for replies in a specific category Data & reporting sql-triggered-badge	3	188	2015 年 8 月 28 日
Badges for specific category Feature	1	1229	2018 年 6 月 13 日

Need help with an SQL badge query

関連トピック