Badge collection examples

[alefattorini (Alessio Fattorini)]

I have read this fantastic topic

What cool badge queries have you come up with?

Enabling Badge SQL entails security and performance risks so it is not available by default. For more information, see: Enable Badge SQL There are lots of potential badges that we can come up with using SQL queries. I thought I’d start a topic for people to share some of the queries and badges they’ve created. I for one am looking forward to seeing some cool inspiration! This post is a wiki topic. If you have a good badge query to add, please reply to this …

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…

[riking (Kane York)]

Just for take a look and copy

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

[alefattorini (Alessio Fattorini)]

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

[Mittineague]

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

[PJH]

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?

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:

http://bbs.boingboing.net/badges

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:

[alefattorini (Alessio Fattorini)]

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…