Notifications - more target options?

[Cherry]

Hey,

On my forum, I run a minigame where my users can pick a card, and they can win certain things in our game servers. It's entirely custom produced, and I'd love to notify everyone when someone wins the Jackpot.

Basically, I need a way to have a notification send to everyone, perhaps using * as wildcard in the to_id field of arrowchat_notifications table. It'd also be great to be able to do things such as "!=1", where it'd send a notification to everyone other than to_id 1. I still want to use a singular author_id, but being able to have more customisation with the notification target would be nice.

I would manually do a query for every one of my users, but when I have 4k users, that isn't really feasible.

Thanks for reading.

[Jason]

You could certainly do this in one query by having a select within an insert.

BTW, running 4k queries shouldn't be a huge issue as long as it's not happening a lot.

[Staff Bot]

[b]This thread has been locked because the last post is greater than six months old. There is a good chance that the information in this thread is outdated. Please open a new topic if you wish to discuss this further.[/b]