“First post” badge!

data & reporting
2

You mean the first public post that they ever make to your forum?

  1. /admin/badges
  2. + New
  3. Give your badge a name
  4. Pick an icon. The font-awesome names can be found here (fa-pencil-square for example) or use a hosted image. This will be used on the various badges pages dotted around your site.
  5. Pick an (optional) image. You can use the same as the previous step. This image will appear on user cards.
  6. Select a badge type. For this you’d probably want Bronze.
  7. Pick a group (or create a new group for it first.)
  8. Give your badge a description
  9. Enter the following sql
SELECT MIN(bp.id) post_id, bp.user_id, MIN(bp.created_at) granted_at
FROM badge_posts bp
WHERE (:backfill OR bp.id IN (:post_ids) )
GROUP BY bp.user_id
  1. You probably want the following options checked:
  2. Save your badge and refresh the page to get more options between the SQL and the options shown above and you probably want the following
15 Likes