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.

[Paul M]

What version of mysql are you using ?

[Greek76]

Where do I edit this?

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

[tryckj?vel]

Originally Posted by Paul M

What version of mysql are you using ?

Server Type Linux
Web Server Apache v1.3.37
PHP 5.2.1
PHP Max Post Size 8.00 MB
PHP Maximum Upload Size 2.00 MB
PHP Memory Limit 16.00 MB
MySQL Version 4.1.22-standard
MySQL Packet Size 16.00 MB

[Paul M]

Originally Posted by Greek76

Where do I edit this?

vBulletin Options > User Infractions & Post Reporting Options

Originally Posted by tryckj?vel

MySQL Version 4.1.22-standard

It appears that the query in its present form will only work on mysql 5.0.12 and above. Im afraid its highly unlikely I will change it, I dont have any installations of mysql4 any more, its very old now. I suggest you upgrade your mysql (or ask your host to, your apache version is ancient as well) .

Just to be safe, I think I will add a mysql dependancy to the XML file.

[RedHacker]

Thanks for update....

[eXoOutsider]

This is an awesome mod. I've used for awhile now. Very nice.