[RELEASE v2.0] Report post to moderator -> PM or e-mail

[JohnM]

This hack allows you to select the method of delivery for the report to moderator message.

Rename the attached script to JohnMinstall.php and run it. It will make the necessary database modification and give you further instructions. Delete the script when you're done.

I hope this helps some people

[DEMOLiTiON]

But I get this when installing.

Parse error: parse error in /usr/local/etc/httpd/sites/demolition/htdocs/vb/admin/johnminstall.php on line 10

[JohnM]

not in admin, just your normal directory

works for me :-(

[JohnM]

If you're using PHP3 use the attached script instead and do the following:

Database update complete.

You must now find the following code in <b>report.php</b>:

//check usergroup of user to see if they can use PMs
if ($bbuserinfo[userid]==0) {
  show_nopermission();
}

After it add:

//if reporting is disabled, show an error
if ($reporttomoderator == 0) {
  eval("standarderror(\"".gettemplate("error_noreportpost")."\");");
}

Find:

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

Replace with:

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

Find:

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

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

Find:

    eval("$message = \"".gettemplate("email_reportbadpost",1,0)."\";");
    eval("$subject = \"".gettemplate("emailsubject_reportbadpost",1,0)."\";");
    
    mail ($moderator[email],$subject,$message,"From: \"$bbtitle Mailer\" <$webmasteremail>");

Replace with:

    if ($reporttomoderator == 1 || $reporttomoderator == 3) {
      eval("\$message = \"".gettemplate("email_reportbadpost",1,0)."\";");
      eval("\$subject = \"".gettemplate("emailsubject_reportbadpost",1,0)."\";");
      mail ($moderator[email],$subject,$message,"From: \"$bbtitle Mailer\" <$webmasteremail>");
    }
    if ($reporttomoderator == 2 || $reporttomoderator == 3) {
      eval("\$message = \"".gettemplate("pm_reportbadpost",1,0)."\";");
      eval("\$subject = \"".gettemplate("pmsubject_reportbadpost",1,0)."\";");
      $DB_site->query("INSERT INTO privatemessage (privatemessageid,userid,touserid,fromuserid,title,message,dateline,showsignature,iconid,messageread,folderid) VALUES (NULL,$moderator[userid],$moderator[userid],$bbuserinfo[userid],'$subject','$message',".time().",0,0,0,0)");
    }

Now, add a new template called 'error_noreportpost':
Sorry, this feature is disabled.

And templates 'pm_reportbadpost' and 'pmsubject_reportbadpost', based on the email_reportbadpost and emailsubject_reportbadpost templates.

Finally, upload the files and go into your control panel and select an option :)

[JohnM]

Err, forgot to attach it :O

[DEMOLiTiON]

ok the installing is working now
but when reporting a post I get this in my e-mail:

Database error in vBulletin: Invalid SQL: SELECT DISTINCT userid, user.email FROM moderator,user WHERE user.userid=moderator.userid AND moderator.forumid IN (4,3,-1)
mysql error: Column: 'userid' in field list is ambiguous
mysql error number: 1052
Date: Monday 28th of May 2001 07:09:27 PM
Script: /vb/report.php

[Psycho]

ive installed everything just like you laid it out. but when i test it, i get a parse error on the last line on the report.php

the last line is the ?>

any suggestions?

[JohnM]

demolition:

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

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

Psycho: make sure you didn't overwrite the } for the while() loop

[Psycho]

I changed that section of code, but still receive the same error code. the } is still there for the while loop, made sure there were 3 open and closing.

I attached the file for you to look at if you so wish, Maybe I set something wrong in it. Reason I tried to set this hack up is because the report didnt work on its own as an email, now it still isnt working.

<file removed>

[DEMOLiTiON]

ok I got this working now
but the reports are only send to one moderator.. is there a way to send it to all moderators and admins?
thnx

[JohnM]

First of all, it's against the license to post files. Please remove it.

for your question, your tags were a bit messed up

your while() loop part should be:

  while ($moderator=$DB_site->fetch_array($moderators)) {
    if ($reporttomoderator == 1 || $reporttomoderator == 3) {
	      eval("\$message = \"".gettemplate("email_reportbadpost",1,0)."\";");
	      eval("\$subject = \"".gettemplate("emailsubject_reportbadpost",1,0)."\";");
	      mail ($moderator[email],$subject,$message,"From: \"$bbtitle Mailer\" <$webmasteremail>");
	    }
	    if ($reporttomoderator == 2 || $reporttomoderator == 3) {
	      eval("\$message = \"".gettemplate("pm_reportbadpost",1,0)."\";");
	      eval("\$subject = \"".gettemplate("pmsubject_reportbadpost",1,0)."\";");
	      $DB_site->query("INSERT INTO privatemessage  (privatemessageid,userid,touserid,fromuserid,title,message,dateline,showsignature,iconid,messageread,folderid) VALUES (NULL,$moderator[userid],$moderator[userid],$bbuserinfo[userid],'$subject','$message',".time().",0,0,0,0)");
	    }
  }

[JohnM]

Originally posted by DEMOLiTiON
ok I got this working now
but the reports are only send to one moderator.. is there a way to send it to all moderators and admins?
thnx

it should send it to all of them... I don't see why it wouldn't... PM me your while loop part of report.php

[Psycho]

I wasnt thinking on the file, but I appreciate your help. It works great now. Thank you very much

[Psycho]

I know your probably getting sick of me. Ive put that code into my file which seemed to have fixed it. However, when I look at the private message it give me this

("INSERT INTO privatemessage (privatemessageid,userid,touserid,fromuserid,title
,message,dateline,showsignature,iconid,messageread
,folderid) VALUES (NULL,1,1,1,',',".time().",0,0,0,0)");

[DEMOLiTiON]

JohnM, I emailed you my report.php, please look at it