How do I make my own badge query?

[keith1 (Keith Guerrette)]

I’m feeling quite silly for having to ask, but I’m finding tons of great resources for making my own badges, but I can’t figure out where exactly to put all of these badge queries. Can someone just point me in the right direction?

Thanks!
Keith

[Pad_Pors]

there is a topic describing other badges:

[Superseded] What cool badge queries have you come up with?

Enabling Badge SQL entails security and performance risks so it is not available by default. For more information, see: Enable Badge SQL This topic became too long to be easily searched and has been broken down into separate topics. If you have any questions about how to write a badge query, or have one to share, please start a new topic in the data & reporting category and tag it with the sql-triggered-badge tag. More ideas: Some common badge queries

the faq topic for badge (which may not be what you want):

What are Badges?

Badges in Discourse reinforce positive user behaviour and facilitate “learning by doing”. It is a central part of Discourse’s gamification features. [image] Receiving Badges There are two ways to receive a badge: Manually granted by an administrative user Automatically granted by the system Furthermore, all badges have some optional properties. Allow badge to be used as a title Can be granted multiple times Show badge on the public badges page Show post granting badge on badge page C…

creating badge:

Grant a badge to individual users manually

In this guide we’ll be creating a new “Scholar” badge that we will grant to individual users manually. Let’s get started! This guide is only applicable for custom badges. To manually grant one of Discourse’s built in badges, you will need to follow: Bulk Award a badge to a set of users Create a new custom badge Create a new custom badge from the Admin > Badges page by clicking on “New” button. [new_badge] Fill out badge details In our example, I am naming the badge “Scholar”…

[keith1 (Keith Guerrette)]

Yes, like I said, I’ve found loads of great resources on here for customizing my own badges, etc (I guess I should have linked them to prevent this answer), but on a very basic level, I can’t find any information of where to put the queries. Let me be more specific:

SELECT user_id, 0 post_id, current_timestamp granted_at 
FROM badge_posts  
WHERE (:backfill OR user_id IN (:user_ids) OR 0 NOT IN (:post_ids) )
GROUP BY user_id 
HAVING count(*) > 1000

Where does this code belong? Is there an admin section for badge query modifications that I’m not finding, or is this offline/external file editing, in which case, can you just point me to where in the discourse directories these live? None of the topics on here about badge creation actually mention this bit, so I’m assuming it’s something entirely obvious that I’m missing.

[dax (Daniela)]

Are you on latest?

If you are, read this before

Enable Badge SQL

Enabling Badge SQL entails security and performance risks. Starting from Discourse 1.6 badge SQL can no longer be edited by admins unless explicitly enabled. This change was made for a couple of reasons: Security: Allowing admins to enter SQL directly grants them raw access to the database. Generally, we opt that raw access to the database from the web UI as a feature you opt-in for. Even though the queries only return user_ids, an admin attacker can discover any information in …

After you enabled it, you will find a new SQL field on /admin/badges/new

[keith1 (Keith Guerrette)]

Aha! That was the part I was missing. Thank you for connecting those dots!