How can I give a badge just to the early birds?


#1

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?


(Kris) #2

There’s a badge query for exactly that in this post

You’d add it under Admin > Badges > New > Badge Query (SQL)


(Chris Klugewicz) #3

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'