I'm trying to duplicate the Report.php feature and make it work for a usergroup other than the moderators. I've changed the query from:
Quote:
$moderators = $DB_site->query("
SELECT DISTINCT user.email
FROM " . TABLE_PREFIX . "moderator AS moderator," . TABLE_PREFIX . "user AS user
WHERE user.userid = moderator.userid
AND moderator.forumid IN ($foruminfo[parentlist])
");
|
to
Quote:
$moderators = $DB_site->query("
SELECT DISTINCT user.email
FROM " . TABLE_PREFIX . "user AS user WHERE user.usergroupid == 10 AND user.usergroupid == 6
");
|
This was done to send it to the administrator usergroup and another usergroup. The admins are receiving the alerts, but the other usergroup isn't. Anyone have any input on how the query should be written in order for it to work?