This is my first topic after become a member here since 222 days ago. How to copy-paste this code? [how-to-copy-paste-lock-code-sql] I want to give a badge for 25 successful invitations. So, I only need change the value HAVING COUNT (*) >= 5 into HAVING COUNT (*) >= 25, and give a Gold badge…

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

Here are the steps for enabling the SQL Badge Queries [image] Enable Badge SQL Self-Hosting bookmark This guide explains how to enable Badge SQL in Discourse and discusses the associated security and performance risks. person_raising_hand Required user level: …

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.

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.

Locked query field for system badges

Support

cpradio (cpradio) March 20, 2018, 4:50pm 2

Here are the steps for enabling the SQL Badge Queries

Topic		Replies	Views
Badge Query SQL edit box is disabled until page is refreshed Support sql-triggered-badge	2	1086	May 22, 2019
Enable Badge SQL Self-Hosting badges , how-to	0	21134	July 27, 2016
A Simple Way to Grant Badges en-masse? Support	1	1284	January 3, 2018
How do I make my own badge query? Data & reporting sql-triggered-badge	4	6207	October 1, 2016
Where do I need to enter my Badge Query? Support sql-triggered-badge	1	1057	November 18, 2019

Locked query field for system badges

Related topics