Improved Post Report System

This hack will place post reports into modcp, and enable moderators to give feedback to users via a page that users can see which includes all of their own post reports.

Post reports have three possible statuses: open, pending or closed.

When a post report is made, the report is put into a page in modcp called 'outstanding reports', and has a status of 'open'. There is a new option in admincp which governs whether or not the post report emails are sent to moderators; so if this is switched on, the emails are still sent.

Moderators can then see who reported the post and the time at which it was reported, and the comment given by the user. There are also links to the post itself, the thread the post is on, the forum the thread is in, the user who posted the post and the user who reported the post.

The user page can be linked anywhere you choose; I have included instructions for linking it on the quicklinks menu.

This system can be switched on or off from admincp. When off, the behaviour of post reports is as normal.

I've also included an optional scheduled task which will remove post reports from the system than are older than an age specified in days in admincp.

Moderators can then update the status of the report, and add a comment. The user who reported the post can then see these changes reflected in their page - it will show the name of the moderator dealing with the report, the comment (if any) left by the moderator, and the time at which the report was last updated.

When a moderator sets the status of a report to 'closed', it is moved to another page in modcp called 'closed post reports'. Post reports that are in the pending state are still kept in the 'outstanding post reports' page.

This hack has been tested on 3.0.3, 3.0.4, 3.0.5 and 3.0.6, and can be seen in action on The Student Room where it has been up and running since 18th January 2005.

Screenshots:

1) What the user sees
2) A closed report in modcp
3) The admincp settings
4) An open report and the modcp menu items

Updated 26th Feb 2005: installer now calls build_language so there is no need to rebuild the phrase cache manually.

[Ghanem]

Originally Posted by Delphiprogrammi

hi people,

God bless you
I was waiting for it

[Delphiprogrammi]

hi,

Just cleared out some dirty MySQL errors.There is still a problem with the script in the modcp for some reason it says it can't find the phrases used but they are there.I'm guessing it's because the 3.xx script uses some old vb function not supported in 3.5.x anymore when i got the time i will check the api docs at members.vbulletin.com.

A thing new to this hack is an automated uninstaller.Just hit the unintall button and all database modifications used are deleted (you get no warnings so think twice before hitting delete)

the problem with script in the modcp is solved.No unsupported functions but for some reason jelsoft moved the control panel stop message phrases to the error messages phraseid group

two thing to test out the cron script and the report.php modification after that ..... done (well as a beta to testdrive)

update

report.php modification done seems to be ok (no error messages or MySQL errors) but some things aren't set as they should be like for example the timestamp... i'm checking this.Also finische the cron script no problems with that

[Delphiprogrammi]

hi,
Well i don't get it where the hell is my dateline ?????? it's in the database show ......

PHP Code:

$db->query_first("INSERT INTO " . TABLE_PREFIX . "postreport(postid,userid,reporttext,status,dateline)VALUES($postid,$userid,'" .addslashes(htmlspecialchars_uni($reason)) . "',0," . TIMENOW . ")"); 


ok need a break now :speechless:

problem with timestamps solved all is working except for the thing "user comment" for some reason i didn't found yet that is staying empty

PHP Code:

$db->query_first("INSERT INTO " . TABLE_PREFIX . "postreport(postid,userid,reporttext,status,dateline)VALUES($postid,$userid,'" .addslashes(htmlspecialchars_uni($reason)) . "',0," . TIMENOW . ")"); 


htmlspecialchars_uni is still supported according to http://members.vbulletin.com/api so why on earth is that staying empty ??

[Delphiprogrammi]

hi,

Problem solved the user comment filed is properly filled in now

PHP Code:

$reason =& $vbulletin->GPC['reason']; 


but while testing i found another problem.If you have that redirection messages enabled you're redirected to an empty white page after you've submitted a report.Again i'm looking into this stay tuned

[Ghanem]

Originally Posted by Delphiprogrammi

stay tuned

waiting

[Delphiprogrammi]

hi,

redirection trouble solved to.I'm gonna put it on my live site and let it run for a while if now new problems show up .... i can share it with others

[Ghanem]

congratulation
shouldn't you post it now in vb35x forum :cheeky:

[Delphiprogrammi]

Originally Posted by unicorn

congratulation
shouldn't you post it now in vb35x forum :cheeky:

Yeah release will be in vb3.5.x code modifications.But i'm doing some more tests.You don't want a thing that crashes your database or server do you ? i'm also playing with an idea to put the thread from the reported post(s) into the moderation que but that could cause a security issue.I don't know about you but let's say for example your forum is hit by spammers url don't you wanna take action as fast you possibly can ? putting such threads into the moderation que would make them invisible (except for moderators and admins offcource) and the spammers won't get hits from your forums but like i said that could cause abuse

[Ghanem]

Originally Posted by Delphiprogrammi

Yeah release will be in vb3.5.x code...

I meant discussing it there will bring the 3.5.x coders and users while here the interested will be only 3.0.x

[Delphiprogrammi]

hi,

Everything is ready for release but i need to wait for the original author permission before that i'm not allowed to release anything yeah the rules of the opensource playground