wanted: report post goes to admin only

[redd]

We have been using a hack which will cause the "report this post" to notify the admins and not the moderators, found at http://www.vbulletin.com/forum/showthread.php?threadid=10141
The option we used was the very first one posted by The_Sisko.

Unfortunately, this stopped working a few versions ago. Could someone make one that works?

Thanks!!

[Xenon]

open report.php find this:

$moderators=$DB_site->query("SELECT DISTINCT user.email FROM moderator,user WHERE user.userid=moderator.userid AND moderator.forumid IN ($foruminfo[parentlist])");

$thread[title]=unhtmlspecialchars($thread[title]);

if ($DB_site->num_rows($moderators)==0) {
// get admins if no mods
$moderators=$DB_site->query("SELECT user.email FROM user,usergroup WHERE user.usergroupid=usergroup.usergroupid AND (usergroup.cancontrolpanel=1 OR usergroup.ismoderator=1)");
}


replace with this:
$thread[title]=unhtmlspecialchars($thread[title]);

$moderators=$DB_site->query("SELECT user.email FROM user,usergroup WHERE user.usergroupid=usergroup.usergroupid AND usergroup.ismoderator=1)");

[redd]

Thanks for the reply! I've finally upgraded my forum and used your hack, but it isn't working. I received the following error:

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT user.email FROM user,usergroup WHERE user.usergroupid=usergroup.usergroupid AND usergroup.ismoderator=1)
mysql error: You have an error in your SQL syntax near ')' at line 1

mysql error number: 1064


Do you know what could cause this?

[Logician]

Replace usergroup.ismoderator=1)"); part as usergroup.ismoderator=1");

[Xenon]

damn small typings ^^