# Badge collection examples

**URL:** https://meta.discourse.org/t/badge-collection-examples/26451
**Category:** Community Building
**Tags:** sql-triggered-badge
**Created:** [March 17, 2015, 9:16pm UTC](https://meta.discourse.org/t/badge-collection-examples/26451 "2015-03-17T21:16:39Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![alefattorini](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/alefattorini/32/119928_2.png) [@alefattorini](https://meta.discourse.org/u/alefattorini)
#### Post date: [March 17, 2015, 9:16pm UTC](https://meta.discourse.org/t/badge-collection-examples/26451/1 "2015-03-17T21:16:39Z")

</div>

I have read this fantastic topic

> [@\[Superseded\] What cool badge queries have you come up with?](https://meta.discourse.org/t/what-cool-badge-queries-have-you-come-up-with/18978):
>
> warning Enabling Badge SQL entails security and performance risks so it is not available by default. For more information, see: [Enable Badge SQL](https://meta.discourse.org/t/badge-sql-can-no-longer-be-edited-by-default/47894) This topic became too long to be easily searched and has been broken down into separate topics. If you have any questions about how to write a badge query, or have one to share, please start a new topic in the #data & reporting category and tag it with the #sql-triggered-badge tag. +1 More ideas: [Some common badge queries](https://meta.discourse.org/t/some-common-badge-queries-idea/31859)

Could anyone suggest me some discourse installations with a lot of this custom badges already implemented? Just for take a look and copy 😉 Something with multiple badges and so on..

---

<div class="post-metadata">

### Author: ![riking](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/riking/32/170938_2.png) [@riking](https://meta.discourse.org/u/riking)
#### Post date: [March 17, 2015, 10:36pm UTC](https://meta.discourse.org/t/badge-collection-examples/26451/2 "2015-03-17T22:36:42Z")

</div>

> [@alefattorini](#):
>
> Just for take a look and copy

You can’t view the badge queries normally, you have to ask for them.

---

<div class="post-metadata">

### Author: ![alefattorini](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/alefattorini/32/119928_2.png) [@alefattorini](https://meta.discourse.org/u/alefattorini)
#### Post date: [March 18, 2015, 4:08am UTC](https://meta.discourse.org/t/badge-collection-examples/26451/3 "2015-03-18T04:08:19Z")

</div>

Sure, see the description could be enough for me 😉 after I can ask more info to the admin.

---

<div class="post-metadata">

### Author: ![Mittineague](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/mittineague/32/114259_2.png) [@Mittineague](https://meta.discourse.org/u/Mittineague)
#### Post date: [March 18, 2015, 4:44am UTC](https://meta.discourse.org/t/badge-collection-examples/26451/4 "2015-03-18T04:44:00Z")

</div>

Seems you would need more than “description” and want the query syntax / table structure. .  
Or am I missing something and completely off-topic here?

---

<div class="post-metadata">

### Author: ![PJH](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pjh/32/39071_2.png) [@PJH](https://meta.discourse.org/u/PJH)
#### Post date: [March 18, 2015, 8:41am UTC](https://meta.discourse.org/t/badge-collection-examples/26451/5 "2015-03-18T08:41:54Z")

</div>

> [@alefattorini](#):
>
> Could anyone suggest me some discourse installations with a lot of this custom badges already implemented?

Apart from where the one you quoted is [implemented](http://what.thedailywtf.com/badges)? 😃

I’m not too aware of other DC implementations - apart from the meta ones, BoingBoing is the only one I can name off the top of my head, and they just seem to use the stock badges:

> **[Boing Boing BBS](https://bbs.boingboing.net/badges)**
>
> Boing Boing BBS, the forums of boingboing.net

> [@Mittineague](#):
>
> Seems you would need more than “description” and want the query syntax / table structure. .

All that would be needed is

- The SQL, if applicable (well -necessary- if you want them automatically implementing)
- Any peculiarities about which triggers/checkboxes are required for example,
  - it may need to be triggered daily because it’s a long running SQL badge.
  - a policy of not checking ‘revocation’ because the situation that causes the badge may disappear, but you still want the badge to remain afterwards (the emeritus badges in the linked thread e.g.)

- Suggestions to badge level, icons etc.
- notes about any peculiarities in the query itself (e.g. site specific stuff like mine do.)

Basically most of the important stuff on the badge configuration page:

 ![](https://global.discourse-cdn.com/meta/original/3X/3/5/35785cc9db4b8db01604567a849d1678ad984daa.png)

---

<div class="post-metadata">

### Author: ![alefattorini](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/alefattorini/32/119928_2.png) [@alefattorini](https://meta.discourse.org/u/alefattorini)
#### Post date: [March 18, 2015, 10:25am UTC](https://meta.discourse.org/t/badge-collection-examples/26451/6 "2015-03-18T10:25:40Z")

</div>

> [@PJH](#):
>
> Apart from where the one you quoted is implemented?

That’s cool man! A lot of examples there. This is what I’m looking for.. 😃