早期参加者のみバッジを付与するには？

[anon62249317]

Hello,

I want to give a badge to the early birds users, is there a way to create a badge and just give it to the first 100 users or something like that?

[awesomerobot (Kris)]

まさにそれに対応するバッジクエリが、この投稿にあります。

@techAPJ

• フォーラムの最初の100ユーザーにバッジを付与する

SELECT id AS user_id, created_at AS granted_at, NULL AS post_id
FROM users WHERE id > 0
ORDER BY created_at ASC LIMIT 100

これには、管理 > バッジ > 新規 > バッジクエリ (SQL) の下で追加してください。

[cjk77 (Chris Klugewicz)]

For our forum, we awarded an “Early Adopter” badge to users who joined before a certain date (1 month from the day we publicly announced):

SELECT id AS user_id, created_at AS granted_at, NULL AS post_id
FROM users WHERE created_at < '20180213'