SQL query to auto assign custom badges

Hi there,

I’m brand new to discourse, but am trying to create custom badges for members of our community based on their participation level online (similar to trust level, but we would decide the criteria ourselves and try to set it up in the code somehow). We essentially want to define our own “participation tiers”, and through a SQL query define that if a student does x,y,z we want them to get a certain badge.

Is there a way to use SQL to auto assign badges to students continuously?

I also want to know whether it’s possible to send push notification emails to students when they receive a new badge, automatically.

Thanks for helping a newbie out!

See Triggered custom badge queries.

They’ll get a notification on the web site when they earn a new badge, but I don’t think they get an email notification.