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…

[imagen] 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 categorie…

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

Comunidad Datos e informes

codinghorror (Jeff Atwood) 23 Octubre, 2017 03:19 3

It is a feature, ask @sam about it.

[PAID] Allow badges to be granted in restricted categories

Tema		Respuestas	Vistas
Badges for posting Data & reporting sql-triggered-badge	4	433	27 Agosto 2024
[PAID] Allow badges to be granted in restricted categories Marketplace	9	2059	26 Noviembre 2017
Some common badge queries Data & reporting sql-triggered-badge	0	8835	7 Agosto 2015
Badge for replies in a specific category Data & reporting sql-triggered-badge	3	217	28 Agosto 2015
Badges for specific category Feature	1	1275	13 Junio 2018

Need help with an SQL badge query

Temas relacionados