I am working on badge SQL that grant’s users a badge when they have all of the badges in a specified list. (E.g. id’s 3, 4 and 5). I know this badge query works for one badge: SELECT user_id, count(id) , current_timestamp granted_at FROM user_badges WHERE badge_id=4 GROUP BY user_id But how wou…

I use something like this to create Alternative User Level for my members. You can replace ib.badge_id with the badge id your members should have achieved. SELECT user_id, CURRENT_TIMESTAMP granted_at, NULL post_id FROM user_badges pb WHERE badge_id = 1 AND EXISTS ( SELECT 1 FROM user_badges ib …

Thanks for your help, that works perfectly!

特定のバッジを持っているためのバッジ

コミュニティデータとレポート

Qursch 2020 年 12 月 17 日午後 12:27 3

お手伝いいただきありがとうございます。これで完璧に動作します！

トピック		返信	表示
Badges predicated on getting a series of other badges? Data & reporting sql-triggered-badge	4	2578	2014 年 11 月 24 日
Assigned a badge based on multiple badge assignment Data & reporting sql-triggered-badge	8	1159	2022 年 3 月 18 日
An extra badge based on already granted badges number? Data & reporting sql-triggered-badge	1	725	2023 年 5 月 23 日
Awarding badges multiple times with custom SQL Data & reporting sql-triggered-badge	2	1256	2017 年 10 月 25 日
Grant a badge based on number of bronze/silver/gold badges Data & reporting sql-triggered-badge	0	319	2024 年 1 月 17 日

特定のバッジを持っているためのバッジ

関連トピック