Miscellaneous Hacks - List Reported Posts

As of 24 Nov 2017 this modification has been withdrawn.

This is something I have been using for the last few years on Cable Forum, it displays a list of reported posts for both staff and members to see.

The list shows ;

Reported Date/Time
Reporter (Staff Only)
Thread Title
Post Number
Actioned Date/Time
Moderator Who Actioned.

For this system to work you must have vbulletin set-up to create a new thread for each report.

On the reported posts page members can click on the Actioned Moderator name to see any comment left by the moderator.

A report is considered as actioned by the first staff member to reply in the report thread. The comments are read from that first post (by default it reads anything inside quote tags).

Staff can click on the reporter to be taken directly to the report thread.

Staff Usergroups are defined in the mods settings - also the number of days to show reports for is defined in the settings.

Note: For this to function, certain phrases must be edited as per the instructions, if you fail to do this, it will not display correctly.

If enabled, this will also attempt to add a link to your Quick Links or Community Links. There is also an option to prefix the link path if you use something like CMPS.


History:

v3.8.001 : First Release for vB 3.8.
v3.8.002 - Added auto links with choice of Quick Links or Community Links.
v3.8.003 - Fix hard coded path in thread links.
v3.8.004 - Updated to allow staff usergroups to be secondary groups.
v3.8.005 - Internal update, not released.
v3.8.006 - Fix deleted post and lowercase bugs.

[amjadz4]

well how does an admin or a mod take action on the list? all i see is no action yet on the reported page.

[Wseries]

Working wells so far. Don't like the colon that's put into the thread title in my reported posts forum. I'd it to read "Reported Post in {Thread Title} without having to edit it manually every time. Is there a phrase or template I can edit to fix it?

[Paul M]

Originally Posted by amjadz4

well how does an admin or a mod take action on the list? all i see is no action yet on the reported page.

Please read the main post.

Originally Posted by Wseries

Working wells so far. Don't like the colon that's put into the thread title in my reported posts forum. I'd it to read "Reported Post in {Thread Title} without having to edit it manually every time. Is there a phrase or template I can edit to fix it?

Please see the instructions, step 1.

[amjadz4]

aah I see. Thank you!

[Wseries]

D'oh? How did I miss that? Thanks Paul.

[faraz_9000]

thnx for the mod

all instruction followed
but cant see reported post in misc.php?do=reported
pls help

wat shud i do with this

For this system to work you must have vbulletin set-up to create a new thread for each report.

[faraz_9000]

thnx
prblm solved installed

[RedHacker]

I had 3.8.004 and put 3.8.006 with overwrite... Must edit nothing....?

[Paul M]

Correct, nothing to do other than import it.

[tryckj?vel]

I'm sure its something stupid... but i'm getting a database error about missing column information? this is when i go to the .../misc.php?do=reported link.

Database error in vBulletin 3.8.4:

Invalid SQL:

		SELECT post.postid, post.threadid, post.username, post.dateline, post.title,
		post.visible, pagetext, firstpostid,  post.userid, usergroupid, membergroupids
		FROM post AS post
		LEFT JOIN user AS user USING (userid)
		LEFT JOIN thread AS thread USING (threadid)
		WHERE thread.forumid = 31 AND post.dateline > 1250400287 AND post.visible = 1
		ORDER BY post.threadid, post.dateline;

MySQL Error   : Unknown column 'sql_prefix.user.threadid' in 'on clause'
Error Number  : 1054