Improved Moderator Alert System

IMPROVED MODERATOR ALERT v.1.1

Goal: Improve the way staff handles junk posts. Speed up processing time of moderator alerts from users. Make the forum meta-moddable.

Usefuleness: The default moderator alerts are useless. Why rely on email to a few people when you have a perfectly good forum system? This hack will have you create a thread in your private Moderators forum. Then as users click "Moderator Alert" under any post, the system will add a new post to your thread in the private room-- allowing all staff to see and discuss the problem immediately instead of relying on the old style email functions.


Requirements:

-Existing private moderator/admin forum
-Annoying users that violate your TOS
-Useful users that will report them


Installation:

-Create and upload one file to your forum directory
-Make one addition in functions.php
-Upload one gif
-Make one addition to the postbit template
-Add two templates


Difficulty: Somewhat Easy

Speed: Not too bad

Release: 1.1-- Feb 07, 2003

Added option to put all alerts in one post or in mutiple threads

Fixed bugs and tested both versions


Michael Knight:

[yzztik]

02-07-03 at 09:09 PM Erwin said this in Post #37
To integrate this into your usual reporting methods, you do NOT have to make a new file or make new templates up, or add any extra queries to search the message - everything is in report.php already.

To achieve the same result, while being able to email mods (and if you have the PM mod hack, PM mods as well), just do this (no need to do anything else):

Open report.php.

Find:

PHP Code:

  $url = str_replace("\"", "", $url); 


ABOVE this, ADD:

PHP Code:

$modforum="100"; 
    $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()."','$modforum','1','0','".addslashes($bbuserinfo[username])."','$bbuserinfo[userid]','".addslashes($bbuserinfo[username])."','".time()."','$iconid','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','Post Alert - $postinfo[username]','$bbuserinfo[username]','$bbuserinfo[userid]','".time()."','".addslashes(parseurl($message))."','$allowsmilie','$signature','$ipaddress','$iconid','1')");
    $DB_site->query("UPDATE forum SET replycount=replycount+1,lastpost='".time()."',lastposter='$bbuserinfo[username]' WHERE forumid='$modforum'"); 


Change:

$modforum="100";

To the forumid of your admin forum.

Done!

P.S. I hope Overgrow doesn't mind me posting this here - I could post this in a separate hack, but after all, it's his idea, and he should get the credit.

When I try this, I get a parse error:

PHP Code:

Parse error: parse error, unexpected ')' in /home/friend/public_html/forum/report.php on line 64 


Any ideas? :-s

[Figment]

Exactly the same error I get if I adopt Erwins suggestion.

I'd like to get this sorted one way or other - either by finding the fix for Erwins method or getting help on making the email to mods work in Overgrows original set up.

TIA

[yzztik]

With Erwins suggestion, the post that gets made, does it include the post they are reporting and their reason too? Also, does it only do the new thread thing, or can it post to an existing thread?

[Figment]

As it uses the existing report.php file, I would presume it works in the same way as the original vB reports, with the addition of a post into the admin/mods forum. I am not sure whether it allows you to choose between new thread per reported post or all reports into one thread, and I have yet to find out whether it includes a copy of the original post, as I cannot test it because of the parse error.

[yzztik]

Yeah same here ... I cannot for the life of me figure out the parse error, I mean it seems there is an extra ) somewhere, but I tried removing some and still got the error, so I am not certain of what it is. It seems to be in the first line of code.

[Figment]

Hmm, just tried replying by email but it hasn't appeared. So apologies if this posts twice

Yes, I've tried that too. Not too hot on PHP, but I tried removing/replacing them one by one, adding an extra '(' here and there all without success. Seem to recall with some combinations the actual error message changed, but I could not get it to work no matter what I tried.

[Erwin]

Try this code:

Find:

PHP Code:

  $url = str_replace("\"", "", $url); 


Above, add:

PHP Code:

$modforum="xx";
    $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()."','$modforum','1','0','".addslashes($bbuserinfo[username])."','$bbuserinfo[userid]','".addslashes($bbuserinfo[username])."','".time()."','$iconid','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))."','$bbuserinfo[username]','$bbuserinfo[userid]','".time()."','".addslashes(parseurl($message))."','$allowsmilie','$signature','$ipaddress','$iconid','1')");
    $DB_site->query("UPDATE forum SET replycount=replycount+1,lastpost='".time()."',lastposter='".addslashes($bbuserinfo[username])."' WHERE forumid='$modforum'"); 


Replace xx with your mod forum.

This is the code I am using.

If you have the LAST TITLE ON FORUM HOME hack, use this code instead (which updates the forum title too).

PHP Code:

$modforum="xx";
    $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()."','$modforum','1','0','".addslashes($bbuserinfo[username])."','$bbuserinfo[userid]','".addslashes($bbuserinfo[username])."','".time()."','$iconid','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))."','$bbuserinfo[username]','$bbuserinfo[userid]','".time()."','".addslashes(parseurl($message))."','$allowsmilie','$signature','$ipaddress','$iconid','1')");
    $DB_site->query("UPDATE forum SET replycount=replycount+1,lastpost='".time()."',lastposter='".addslashes($bbuserinfo[username])."',lasttitle='".addslashes(htmlspecialchars($subject))."' WHERE forumid='$modforum'"); 


Again, replace xx with your mod forum.

[Erwin]

Sorry to Overgrow for hijacking his thread, but I don't want to release a hack that does the same thing... unless you want me to do so.

[yzztik]

I can't find this string:

$url = "\"", "", $url);

All I have is this:

$url = str_replace("\"", "", $url);


When I add it above that, still get a parse error

I am using 2.2.9

[Figment]

Ditto here, using 2.2.8