Bitwish badges

[system]

Bitwish runs on Discourse, a platform that comes with many badges out of the box (learn more). On top of these, we are creating our own badges:

Bronze

• Wishlist Participant - Participated in one draft feature request discussion.
• First Feature Request - Proposed one feature request reviewed.
• First Preset - Published one preset on bitwiggers.com.
• Tutorials Participant - Participated in the Bitwig Video Guide.
• Music Participant - Participated in the collection of music made with Bitwig.

Silver

• Critical Mass - Joined Bitwish before it was cool.
• Wishlist Activist - Commented 25 times in draft feature request discussions.
• Feature Requester - Proposed 5 feature requests reviewed.
• Preset Provider - Published 10 presets on bitwiggers.com.

Gold

• Bitwish Pioneer - Joined when nobody knew or believed.
• Wishlist Champion - Commented 100 times in draft feature request discussions.
• Feature Perseverant - Proposed 15 feature requests reviewed.
• Preset Proliferator - Published 25 presets on bitwiggers.com.
• Bitwig Certified Trainer

Most of these badges are updated automatically on a daily basis. The three categories are hardcoded on Discourse.

If you have suggestions for other badges, share them in the comments.

[icaria36]

I believe these badges are accomplishing something, small but something, in the Wishlist and the Presets categories. For instance, they were used to create some statistics on Bitwish report - December 2021. I am thinking about creating badges for Music and Tutorials too.

Any ideas, any thoughts?

[icaria36]

Two new badges:

• Tutorials Participant - Participated in the Bitwig Video Guide.
• Music Participant - Participated in the collection of music made with Bitwig.

They will be granted automatically within the next 24 hours.

[icaria36]

I’m trying to create “silver” and “gold” badges for contributors of Tutorials and Music that post upvoted entries but my SQL is not good enough. I have asked upstream.

Also, right now the Tutorials Participant badge is buggy because is not taking into account the Bitwig User Guide subcategories. Here too my lack of SQL knowledge is the root of the problem and I have asked for help.

[icaria36]

It would be really nice to credit the right users, and I have set a bounty for whoever can provide the SQL queries: Two SQL queries for badges - marketplace - Discourse Meta

[icaria36]

One query is fixed: Tutorials Participant badge on Bitwish.

Today I learned that this syntax works in SQL:

WHERE t.category_id IN (13, 14, 15, 17, 18, 20, 21)

[icaria36]

Only 4 Critical Mass badges left.

[icaria36]

It’s official: we reached “critical mass” a couple of days ago! 410 users.

This might be even true, because we are having new users almost every day and I’d say most of them come from search results and the likes, and not because of specific outreach on KVR, Reddit or Discord as we did at the beginning. The pace in terms of conversations and posts is slow, but continuous. Maybe we have got a marathon pace?