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 [画像] 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 was…

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.

システムバッジのロック済みクエリフィールド

サポート

cpradio (cpradio) 2018 年 3 月 20 日午後 4:50 2

Here are the steps for enabling the SQL Badge Queries

トピック		返信	表示
Badge Query SQL edit box is disabled until page is refreshed Support sql-triggered-badge	3	1076	2019 年 6 月 21 日
Enable Badge SQL Self-Hosting badges , how-to	0	21049	2016 年 7 月 27 日
A Simple Way to Grant Badges en-masse? Support	2	1274	2018 年 1 月 5 日
How do I make my own badge query? Data & reporting sql-triggered-badge	5	6183	2016 年 10 月 10 日
Where do I need to enter my Badge Query? Support sql-triggered-badge	2	1049	2019 年 11 月 18 日

システムバッジのロック済みクエリフィールド

関連トピック