Are automatic badge triggers still available?

[jsonnull (Jason Nall)]

Hi, I’m trying to create a badge that is automatically granted, and I can’t find where to enter the SQL query while editing the badge. Is this somewhere else? Has the feature been removed?

Any help is appreciated, of course. Thanks!

[tobiaseigen]

yeah - you have to enable them from the command line first, though. see this topic.

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…

[jsonnull (Jason Nall)]

I see, thank you for sharing.

Is this still the best way to grant custom badges automatically?

Also, quick bit of feedback: I was searching for variations on “badge trigger” since a lot of the prior writing refers to triggers, but that post doesn’t have this so it didn’t show up in my searches. Maybe this will help somebody else.

[sam (Sam Saffron)]

Is this still the best way to grant custom badges automatically?

This remains the most efficient and timely way of automatically assigning badges based on a particular action on the forum.

If you are happy with a 24 hour delay you can just bypass thinking about triggers and just use a badge query.