I'm talking now about Badged, in a point of view about migration admin/mod/user :

Badged are diferent :

• https://ask.fedoraproject.org/en/badges/
• https://discussion.fedoraproject.org/badges (only admin can manage badged)

This is How discourse manage Badged ( it's easy configurable)

• https://meta.discourse.org/t/what-are-badges/32540
• https://meta.discourse.org/t/best-practice-for-discourse-badges/72841
• https://meta.discourse.org/t/sql-free-badge-editing/60933
• https://meta.discourse.org/t/custom-badge-rules/50229
• https://meta.discourse.org/t/what-cool-badge-queries-have-you-come-up-with/18978
• https://community.nethserver.org/badges (some cool badged here)

Regards. HTH

Note : #105, #101

a badged can awared in the following form :

             * Automatic (defined or programing)
             * Manual
             * by group

an example of a programing badged :

A badge for 10 accepted answers
SELECT id user_id, current_timestamp granted_at
FROM users
WHERE id  IN (
       SELECT p1.user_id 
       FROM post_custom_fields pc
       JOIN badge_posts p1 ON p1.id = pc.post_id
       JOIN topics t1 ON p1.topic_id = t1.id
       WHERE p1.user_id <> t1.user_id AND 
                    name = 'is_accepted_answer' AND 
                    value IS NOT NULL AND
            p1.user_id IN (
                   SELECT user_id 
                   FROM posts 
                   WHERE :backfill OR  p1.id IN (:post_ids)
            )
        GROUP BY p1.user_id
        HAVING COUNT(*) > 9
)

Note : Badge SQL can no longer be edited by default -> https://meta.discourse.org/t/badge-sql-can-no-longer-be-edited-by-default/47894

some-common-badge-queries-idea :

https://meta.discourse.org/t/some-common-badge-queries-idea/31859?source_topic_id=41079

Another Discousion :

https://meta.discourse.org/t/customizing-text-content-badges-to-points/60175?u=mikechristopher
https://meta.discourse.org/t/feature-proposal-improved-badge-granting-workflow/58631
https://meta.discourse.org/t/how-can-i-add-new-badges/68427
https://meta.discourse.org/t/creating-new-badge/58130
https://meta.discourse.org/t/what-cool-badge-queries-have-you-come-up-with/18978
https://meta.discourse.org/t/grant-a-badge-to-individual-users-manually/29426?source_topic_id=50946
https://meta.discourse.org/t/how-to-set-up-the-picture-of-badge-grant-a-badge-to-individual-users-manually/54293
https://meta.discourse.org/t/what-cool-badge-queries-have-you-come-up-with/18978?source_topic_id=50946
https://meta.discourse.org/t/how-do-i-make-my-own-badge-query/50946
https://meta.discourse.org/t/what-cool-badge-queries-have-you-come-up-with/18978/5
https://meta.discourse.org/t/discourse-new-user-guide/96331
https://meta.discourse.org/t/triggered-custom-badge-queries/19336
https://meta.discourse.org/t/grant-a-badge-to-individual-users-manually/29426
https://meta.discourse.org/t/automatically-grant-a-badge-for-all-members-of-a-group/18147
https://meta.discourse.org/badges
https://meta.discourse.org/t/what-cool-badge-queries-have-you-come-up-with/18978/4
https://meta.discourse.org/t/what-cool-badge-queries-have-you-come-up-with/18978/17
https://meta.discourse.org/t/badge-sql-can-no-longer-be-edited-by-default/47894
https://meta.discourse.org/t/what-cool-badge-queries-have-you-come-up-with/18978/35
https://meta.discourse.org/t/what-cool-badge-queries-have-you-come-up-with/18978/38

Another Discousion :

https://meta.discourse.org/t/what-are-badges/32540

This ticket has been migrated to the forgejo instance. Please find the new ticket here
https://forge.fedoraproject.org/join/Fedora-Join//issues/108