Hi, this is follow up my previous question from Locked query field for system badges - #5 by iidbae So, I want to give a badge to a member who has successful invited 25 people. Just like the existing badge, the Campaigner (3 people) or Champion (5 people). The reward is only a badge without raisi…

The specific query for each invitation badge is generated with two variables: How many people do they have to invite? What TL do those people have to reach? The answers for the existing badges are: Badge People TL Promoter 1 0 Campaigner 3 1 Champion 5 2 So for your new badge, tak…

Hi Andrew, thank you for your simple and easy explanation. I am really appreciate that. I just want to confirm if the below query is right: SELECT u.id user_id, current_timestamp granted_at FROM users u WHERE u.id IN ( SELECT invited_by_id FROM invites i …

[صورة] iidbae: So the query will automatically give a badge to a member who has successful invite 25 people when the TL is 2. Am I right? Yes.

ما هو استعلام شارة SQL للأشخاص المدعوين أكثر من 25 شخصًا؟

الدعم

schleifer (Andrew Schleifer) 22 مارس 2018، 6:58م 4

Yes.

الموضوع		الردود	مرات العرض
Locked query field for system badges Support badges	4	1890	21 مارس 2018
"Promoter" Badge broken? Bug	3	1533	13 أكتوبر 2015
Assigned a badge based on multiple badge assignment Data & reporting sql-triggered-badge	8	1150	18 مارس 2022
How to achieve the campaigner badge Support	11	3430	15 يونيو 2015
Two SQL queries for badges Marketplace	1	750	8 فبراير 2022

ما هو استعلام شارة SQL للأشخاص المدعوين أكثر من 25 شخصًا؟

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