The specific query for each invitation badge is generated with two variables:
- How many people do they have to invite?
- What TL do those people have to reach?
The answers for the existing badges are:
| Badge | People | TL |
|---|---|---|
| Promoter | 1 | 0 |
| Campaigner | 3 | 1 |
| Champion | 5 | 2 |
So for your new badge, take the SQL in the invite_badge method at discourse/lib/badge_queries.rb at 43f63c435d0098ffb0bc66c5544e026099818310 · discourse/discourse · GitHub and replace #{count.to_i} with the number of people and #{trust_level.to_i} with the TL.