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/showt...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:

PHP Code:

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

PHP Code:

  $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

PHP Code:

usergroup.ismoderator=1)"); 


part as

PHP Code:

usergroup.ismoderator=1"); 


[Xenon]

damn small typings ^^