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 warning 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 …

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.

Champ de requête verrouillé pour les badges système

Soutien

cpradio (cpradio) Mars 20, 2018, 4:50 2

Here are the steps for enabling the SQL Badge Queries

Sujet		Réponses	Vues
Badge Query SQL edit box is disabled until page is refreshed Support sql-triggered-badge	3	1078	Juin 21, 2019
Enable Badge SQL Self-Hosting badges , how-to	0	21074	Juillet 27, 2016
A Simple Way to Grant Badges en-masse? Support	2	1280	Janvier 5, 2018
How do I make my own badge query? Data & reporting sql-triggered-badge	5	6185	Octobre 10, 2016
Where do I need to enter my Badge Query? Support sql-triggered-badge	2	1051	Novembre 18, 2019

Champ de requête verrouillé pour les badges système

Sujets connexes