Copy-Paste Locked Badge Query (SQL) For More Than Champion or Invitation

[iidbae (Ridha)]

This is my first topic after become a member here since 222 days ago.

1. How to copy-paste this code?
   

   

2. I want to give a badge for 25 successful invitations. So, I only need change the valueHAVING COUNT (*) >= 5 into HAVING COUNT (*) >= 25, and give a Gold badge type too. Am I right?

I found similar topic "Promoter" Badge broken? but I just want to confirm, because I am not a really understand in coding.

Sorry for my stupid question.

[cpradio]

Here are the steps for enabling the SQL Badge Queries

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…

[iidbae (Ridha)]

Thank you Cpradio, yes I have enabled the SQL within 3 days, but its still locked.
I believe its for security purpose.
I tried to explore the Github too, but still does not know how to find the code line.

[Simon_Cossar]

You can find the badge query SQL here: discourse/badge_queries.rb at master · discourse/discourse · GitHub

[iidbae (Ridha)]

Thank you very much Simon.
I put wrong keyword in searching the code in the repository.
After I found the sql query, I still confuse.

I want to open another support topic, to make another question relating to this.
Thank you.