Trying to modify Report.php

[ludachris]

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:

$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

$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?

[sql]SELECT DISTINCT user.email
FROM " . TABLE_PREFIX . "user AS user
WHERE user.usergroupid == 10 OR user.usergroupid == 6[/sql]
... this is a OR, not a AND...

[ludachris]

I was wondering about that too, but thought that AND should work. Anyhow, thanks. I'll give it a try.

[Xenon]

well as Nexial already said, the AND is false, as it will always produce a false.
But the Administrators aren't recieving the emails because of that query, but because of the next code block which selects admin/super mod emails if no other emails could be found.

[Colin F]

Also, there is a forum setting that allows you to have admins and supermods recieve reported posts per email.