Translator Badge

Sorry, I’m not understanding exactly what you mean by that, but I have been doing some experimenting.

There may be an easier way to do some steps, and the query may need to be improved, but this “works” as best as it does work I guess.

  • I created a Custom Group, I called it Translators
  • I added a member to it and Saved
  • I went to the member’s Profile JSON and got the custom_group id
  • I created a Badge, I called it Translator and gave it a bronze book under other using this query
SELECT u.id user_id, current_timestamp granted_at 
FROM users u 
JOIN group_users gu on u.id = gu.user_id 
WHERE gu.group_id = 42 
AND (:backfill OR u.id IN (:user_ids))

I then added a few more members to the group, then ran sidekiq (on my localhost I need to exec it myself)

The results

.

It can still be granted through the Admin Users pages - but - that is one at a time and could get old fast.
Adding members to Admin Groups can be done “bulk” so is a bit easier.

Who you add to the Group would be up to you

1 Like