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.

[Delphiprogrammi]

Originally Posted by wwesn1

did you read my posts?

Change The

		" . TABLE_PREFIX . "postreport.*,
		" . TABLE_PREFIX . "user.username modname,
		" . TABLE_PREFIX . "user2.username reporter,
		" . TABLE_PREFIX . "post.username postername,
		" . TABLE_PREFIX . "post.userid posterid,
		" . TABLE_PREFIX . "thread.title,
		" . TABLE_PREFIX . "thread.threadid,
		" . TABLE_PREFIX . "forum.title forumtitle,
		" . TABLE_PREFIX . "forum.forumid

TO

		postreport.*,
		user.username modname,
		user2.username reporter,
		post.username postername,
		post.userid posterid,
		thread.title,
		thread.threadid,
		forum.title forumtitle,
		forum.forumid

That will work untill he fixes it

yeah i did read your posts but i'm getting anothr error as you had php code that's causing the error ...

PHP Code:

$postreports = $DB_site->query("
    SELECT
    " . TABLE_PREFIX . "postreport.*,
    " . TABLE_PREFIX . "user.username modname,
    " . TABLE_PREFIX . "post.username postername,
    " . TABLE_PREFIX . "post.userid posterid,
    " . TABLE_PREFIX . "thread.title, thread.threadid
    FROM " . TABLE_PREFIX . "postreport AS postreport
    LEFT JOIN " . TABLE_PREFIX . "user AS user ON (postreport.modid = user.userid)
    LEFT JOIN " . TABLE_PREFIX . "post AS post ON (postreport.postid = post.postid)
    LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid)
    WHERE " . TABLE_PREFIX ."postreport.userid = $userid
    ORDER BY postreport.dateline DESC
    LIMIT $page_start, $reports_per_page
"); 


[wwesn1]

yes, for some reason those first four " . TABLE_PREFIX . " were messing things up. Unless he missed something somewhere that would make it work

[boozehound]

Ok, the problems with the TABLE_PREFIXes... I've updated the files in the zip to work correctly with table prefixes, and also switched the SQL queries for an installer. The installer should add the correct table prefix to the new table.

There is a possibility that if you just ran the queries as they were, on a system that uses table prefixes, you could still have a problem. But you should be able to fix that by removing " . TABLE_PREFIX . " from the FROM clause of the queries.

[trackpads]

Wow, this hack looks great! I am going to install it tonight! Great work!!!!

[Delphiprogrammi]

yeag that seems to be solved now thanks for fixing that

[boozehound]

Originally Posted by Delphiprogrammi

yeag that seems to be solved now thanks for fixing that

Sorry for any problems you had! Neither the forum it's been installed on for a while nor my test forum use table prefixes, so it was never tested in that way (til now). And there I was thinking gratuitous use of " . TABLE_PREFIX . " would make it ok

[Freezerator]

Wow, this is how post report should have been!
Installing!

[Freezerator]

Works like a charm.

One question or suggestion: Can there be that when a mod looks @ the postreport pages, that he sees al reports, and not the ones from himself? Or somewhere a counter so they can easy see there are open post reports waiting.

[boozehound]

Originally Posted by Freezerator

One question or suggestion: Can there be that when a mod looks @ the postreport pages, that he sees al reports, and not the ones from himself?

I suppose so but couldn't they just look in modcp for the same information?

Originally Posted by Freezerator

Or somewhere a counter so they can easy see there are open post reports waiting.

Hopefully in a future release

[Delphiprogrammi]

hi,

ok dumb question but i'm gonna ask anyhow i logged in with my normal user account i use for testing stuff like this and i reported a post.I receive an e-mail with stuff "post reported" but that table remains empty ? also in /modcp/ there's nothing there it says no posts have been reported :s what am i doing here