I have a badge that my members can earn multiple times, it is a “Book Club” badge - they are awarded it for discussing the book of the month. Each month, a new topic is created about the next book, and everyone replying should get the badge - this is currently done manually and is a real pain. I w…

I think something like this could do it: WITH book_club_first_posts AS ( SELECT p.topic_id, p.user_id, MIN(p.id) AS post_id FROM posts p JOIN topics t ON t.id = p.topic_id WHERE t.category_id = 5 -- replace with the category_id of your book club AND p.deleted_at ISNULL AND …

Can anyone help with this? Or is there a guide anywhere about how to craft Badge SQL?

Did you read through Topics tagged sql-triggered-badge ?

Yes I’ve read all of those. It’s a bit daunting to just try something out as a badly formed SQL query on a live site could go very wrong. Is there a test mode or anything?

[이미지] Shaun Robinson: Is there a test mode or anything? I use a staging server for experiments.

Did you get any further with this? How are the book club topics defined? Are they in a separate category, or grouped by a tag?

No further. I’m stumped by the multiple granting factor. All the topics are in the same category. That category is locked down so only staff can create posts there, so it’s safe to auto grant to any replies in the category. But I want it to: Grant a badge for the first reply by each person in ea…

카테고리에서 새 주제에 게시할 때마다 배지를 받을 수 있나요?

커뮤니티 구축 데이터 및 보고

thoka (Thomas Kalka) 4월 4, 2024, 5:20오후 5

실험을 위해 스테이징 서버를 사용합니다.

글		댓글	조회수
A badge granted when someone posts a reply in a single specified topic Data & reporting sql-triggered-badge	7	504	6월 19, 2018
Badge for replies in a specific category Data & reporting sql-triggered-badge	3	288	8월 28, 2015
Badges for posting Data & reporting sql-triggered-badge	4	544	8월 27, 2024
Some common badge queries Data & reporting sql-triggered-badge	0	9050	8월 7, 2015
Awarding badges multiple times with custom SQL Data & reporting sql-triggered-badge	2	1256	10월 25, 2017

카테고리에서 새 주제에 게시할 때마다 배지를 받을 수 있나요?

Related topics