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.

[Jinovich]

Originally Posted by boozehound

I'm not sure if you mean 'for certain usergroups' or 'for certain forums'. Do you want reports forums like this 'VIP' forum to be 'email-only' and not go into modcp at all, or something else?

Well if it can be made so that certain forum reports wont be sent to the MODCP but instead be sent via email to the moderator of that forum that would work just as well.

[MThornback]

I'm getting this error in the AdminCP Installer...help :speechless:

Database error in vBulletin 3.0.7:

Invalid SQL:
CREATE TABLE vb3_postreport (reportid INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
postid INTEGER NOT NULL, userid INTEGER NOT NULL, reporttext MEDIUMTEXT, status INTEGER,
modid INTEGER, dateline INTEGER, updatetime INTEGER, modtext MEDIUMTEXT);

mysql error: Table 'vb3_postreport' already exists

mysql error number: 1050

[Marco van Herwaarden]

Looks like you tried to run the installer twice.

[MThornback]

So if I drop the table I should have no problems then?

Edit:

OK...I dropped the table...and have a new error:

Database error in vBulletin 3.0.7:

Invalid SQL:
INSERT INTO vb3_phrasetype (phrasetypeid, fieldname, title, editrows) VALUES (183, 'postreports', 'Post Reports', 3);

mysql error: Duplicate entry '183' for key 1

mysql error number: 1062

[boozehound]

Originally Posted by MThornback

So if I drop the table I should have no problems then?

Edit:

OK...I dropped the table...and have a new error:

Database error in vBulletin 3.0.7:

Invalid SQL:
INSERT INTO vb3_phrasetype (phrasetypeid, fieldname, title, editrows) VALUES (183, 'postreports', 'Post Reports', 3);

mysql error: Duplicate entry '183' for key 1

mysql error number: 1062

If you've already got the phrases and settings added, but have dropped the table, just recreate the table. The SQL for that is in your previous post.

[question?]

When can we see this for 3.5 as a plugin or extension??

[Bakie]

Here is a really noobish question (I am new to vB) but how do I install the templates?

It says here:
3) Add the templates found in the templates folder.

postreports.txt -> postreports
postreportbits.txt -> postreportbits

How do I do this? I think that I know where but I just dont know how, it it under Style Manager -> Edit templte -> Postbit Templates and after here I am lost...

can anyone help?

[boozehound]

Originally Posted by Bakie

Here is a really noobish question (I am new to vB) but how do I install the templates?

It says here:
3) Add the templates found in the templates folder.

postreports.txt -> postreports
postreportbits.txt -> postreportbits

How do I do this? I think that I know where but I just dont know how, it it under Style Manager -> Edit templte -> Postbit Templates and after here I am lost...

can anyone help?

In the main 'style manager' page, where each style is listed, there is a dropdown next to each style. In that dropdown is an option called 'add new template'. Use that.

[Ghanem]

Hi..

Not yet for 3.5

[Delphiprogrammi]

hi people,

i like this hack and i modified this hack so it would work with vbulletin 3.5x so far so good.The MySQL stuff is done the "look" from the hack is there and so far it's working just getting a few syntax error but i will try to sort it out

here's a little "preview"

ignore that empty empty fields it's just an INSERT query i did to testto see if it's working