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:

[Figment]

Can anyone help on this please?

[heynurse]

04-11-03 at 06:02 AM yzztik said this in Post #53
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?

Nice Hack! Just installed.

I agree the feature that I would like to see would be to let the reporting users give comments as to why they think the post is bad. Has anyone added this option?

[heynurse]

02-07-03 at 06:33 PM Erwin said this in Post #35
I've integrated your hack into my forum now -

when a user reports a post, the report is sent via EMAIL, PM, and a new THREAD is opened in my admin forum at the same time. It's just editing the report.php file.

Erwin,

I tried using both of your codes so that the mods get an e-mail with the reported post, but neither of them are sending e-mails?

Is there a setting that will send it to all the supermods, mods and admins?

Any ideas? Thanks

[yzztik]

ok, I am thinking of using the original of this that simply posts the thread in the mod forum, but is there any way at all to allow the user to give a reason for reporting it? This feature is installed at another board I mod and some of the reported posts without a reason make no sense.

[mtha]

04-11-03 at 11:10 PM Erwin said this in Post #57
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.

somehow, the code has a bunch of extra "))"

couldnt get this to work in report.php.
if I remove those extra ), it give me

mysql error number: 1062
mysql error: Duplicate entry '68995' for key 1

where '68995' should be the new postid (which doesnt exist yet)

[SemperFidelis]

Cheers for the code Erwin
Works flawlessly on a severly hacked up vb 2.3.0

[Shepski]

Is there a way to make this send an email to ALL moderators? The new thread gets posted in my moderators room but it would be very handy if the email gets sent to everyone as opposed to just the moderators of the forum that the post has been reported from.

[cnczone]

How can I add a box for the user to place a reason for the alert?

[Holidazed]

It has obviously been requested before, but I would like to see the following:

A spot for a user to state the reason for the Report.

I can easily add the textarea required to the modalert template. How do I make it so the contents of the comment field are posted to the ALERT thread.

[Holidazed]

Hello? Anybody home?