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 [afbeelding] 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 le…

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

Ondersteuning

cpradio (cpradio) 20 maart 2018 om 16:50 2

Here are the steps for enabling the SQL Badge Queries

Topic		Antwoorden	Weergaven
Badge Query SQL edit box is disabled until page is refreshed Support sql-triggered-badge	2	1082	22 mei 2019
Enable Badge SQL Self-Hosting badges , how-to	0	21128	27 juli 2016
A Simple Way to Grant Badges en-masse? Support	1	1282	3 januari 2018
How do I make my own badge query? Data & reporting sql-triggered-badge	4	6201	1 oktober 2016
Where do I need to enter my Badge Query? Support sql-triggered-badge	1	1055	18 november 2019

Locked query field for system badges

Gerelateerde topics