Report link starts thread in Mod's forum.

[Joe]

Rather then have the report link send a thread to all moderators, how about make it start a thread in the Mod's forum? That would come in handy when talking about reported posts / problems. Moderators could also note of what was done.

[Xenon]

hmm, really a nice idea

open report.php
find

PHP Code:

  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)");
  }

  while ($moderator=$DB_site->fetch_array($moderators)) {
    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:

PHP Code:

    eval("\$message = \"".gettemplate("email_reportbadpost",1,0)."\";");
    eval("\$subject = \"".gettemplate("emailsubject_reportbadpost",1,0)."\";");

$DB_site->query("INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,postusername,postuserid,lastposter,dateline,iconid,visible,attach) VALUES (NULL,'".addslashes(htmlspecialchars($subject))."','".time()."','--Modforumid--','1','0','".addslashes($bbuserinfo[username])."','$bbuserinfo[userid]','".addslashes($bbuserinfo[username])."','".time()."','4','1','0')");
$threadid=$DB_site->insert_id();
$DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($subject))."','".addslashes($postusername)."','$bbuserinfo[userid]','".time()."','".addslashes($message)."',0,0,'$ipaddress',4,'1')"); 


think this should work, just insert the right id for --Modforumid-- ^^

[Joe]

That starts a thread in the mod's forum, but does not include a title, or text about the report

[Xenon]

sorry my fault, have corrected the mod above

[Joe]

BTW, thanks for taking this on, i think its a great idea

[Joe]

Yay, that worked, now off to edit some templates to make it look good

Thank you much, how about we move this to the completed hacks forum?

[Xenon]

you're welcome

well, i'll make the instructions a bit clearer and release it
it's just the fast version, could be made in a nicer way also

[Joe]

Good deal, Here is the change i made for the templates:

In email_reportbadpost

$bbuserinfo[username] has reported this post:

[url ]http://www.yourURL.com/showthread.php?postid=$postid#post$post[postid][ /url]

This is the reason that the user gave:

$reason

----
Please reply to this thread on how the above was dealt with.

And in emailsubject_reportbadpost

Reported post in $thread[title]

[Xenon]

thx

i think i'll release it tomorrow or friday...
have got som ideas which i have to test before releasing

[Erwin]

Hey, I wrote the same hack in the thread by Overgrow when he released his create new thread in mod forum hack (he's done it) but which does not incorporate the email or PM bits.

I just used a similar piece of code to yours Xenon that uses the email templates as well.