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…

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?

@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

codinghorror (Jeff Atwood) 2017年十月23日 03: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	508	2024年八月27日
[PAID] Allow badges to be granted in restricted categories Marketplace	8	2132	2017年十月27日
Some common badge queries Data & reporting sql-triggered-badge	0	8944	2015年八月7日
Badge for replies in a specific category Data & reporting sql-triggered-badge	3	260	2015年八月28日
Badges for specific category Feature	1	1306	2018年六月13日

Need help with an SQL badge query

相關主題