Is there a way to grant a badge to someone who created a topic which then got many replies? Say, 100 replies? I’d call it “Popular Topic” and it would encourage people to think of new topic ideas that will generate lots of discussion.

I think a simple version would be something like this: SELECT t.user_id, CURRENT_TIMESTAMP AS granted_at, p.id AS post_id FROM topics t JOIN posts p ON p.topic_id = t.id AND p.post_number = 1 WHERE t.posts_count >= 100 AND t.archetype = 'regular' AND t.deleted_at ISNULL AND t.u…

That is awesome Jam! Op could also change post counts to have 3 levels bronze(50) Silver(100) gold(200) Thanks for the how-to and thanks @Shauny for the idea.

Thanks I’ll try it out and get back to you!

I’ve set this up now, but I guess it should be set to update daily? I’ll see if it has worked tomorrow. Does ‘targets posts’ need to be checked?

شارة للموضوع الشائع

مجتمع البيانات والتقارير

Shauny (Shaun Robinson) 31 مايو 2024، 5:46م 5

لقد قمت بإعداد هذا الآن، ولكن أعتقد أنه يجب تعيينه للتحديث يوميًا؟ سأرى ما إذا كان قد نجح غدًا. هل يحتاج “استهداف المنشورات” إلى تحديد؟

الموضوع		الردود	مرات العرض
A badge granted when someone posts a reply in a single specified topic Data & reporting sql-triggered-badge	7	481	19 يونيو 2018
Some common badge queries Data & reporting sql-triggered-badge	0	8964	7 أغسطس 2015
Badge ideas for Topic Voting Feature badges , topic-voting , sql-triggered-badge	0	1897	24 يونيو 2016
Reply at least once on 50+ topics? Data & reporting sql-triggered-badge	0	191	23 ديسمبر 2019
What query to award a badge for liking or replying to a particular topic? Data & reporting sql-triggered-badge	1	676	23 مايو 2023

شارة للموضوع الشائع

الموضوعات ذات الصلة