Page 1 of 1

Notifications - more target options?

PostPosted: 31 Jul 2012, 17:05
by 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.

PostPosted: 31 Jul 2012, 18:57
by 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.

Topic Closed

PostPosted: 16 Dec 2014, 00:26
by 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]