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:

What cool badge queries have you come up with?

NOTE: So there are lots of potential badges that we can come up with using SQL queries. I thought I’d start a topic for people to share some of the queries and badges they’ve created. I for one am looking forward to seeing some cool inspiration! This post is a wiki topic. If you have a good badge query to add, please reply to this topic with your query, and then edit this post (pencil icon in the upper right) and include a link to your reply here in the following index. Thanks! Badges fo…

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

What are Badges?

Badges in Discourse reinforce positive user behaviour and facilitates “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! Create a new custom badge Create a new custom badge from the Admin > Badges page by clicking on “New” button. [02%20PM] Fill out badge details In our example, I am naming the badge “Scholar” and setting the badge type to “Gold”. Note that the badge image can either be a font awesome icon or an image URL. In this example, I chose the font awesome icon “fa-graduation-cap”. …

[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

Badge SQL can no longer be edited by default

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 allows them raw access to the database, generally we are opting that raw access to the database from the web UI is a feature you opt-in for. Even though the queries only return user_ids, an admin attacker can discover any information in the database using badge queries. If column A of table Y has the le…

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!