[CyberRanger]

Originally Posted by Black Tiger

Nice hack. Coul'd there be a feature made so admin can decide who get's a pm? For example if you just want die admin to get a pm and not other people which can manage the moderation queu?

There are two plugins that control sending the PM's: "Alert Mods to Edited File in Moderation" and "Alert Mods to New File in Moderation" In both, the sql that selects the users to send the PM to is:

PHP Code:

$result = $db->query_read("SELECT title, usergroup.usergroupid, username, userid
               FROM " . TABLE_PREFIX . "usergroup, " . TABLE_PREFIX . "user
                           WHERE ecdownloadpermissions & 1024 AND  usergroup.usergroupid = user.usergroupid
            "); 


You could easily change the WHERE clause to get a different set of users. For example, to have the PM sent to the admin group, change the query to:

PHP Code:

$result = $db->query_read("SELECT title, usergroup.usergroupid, username, userid
               FROM " . TABLE_PREFIX . "usergroup, " . TABLE_PREFIX . "user
                           WHERE usergroup.usergroupid = 6
            ");