List Reported Posts

[Paul M]

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.

[lazydesis]

nice one this will help a lot for me .. tagged now .. will install later

[ssslippy]

Question, is it possible to have this only show to the user posts they have reported?

[Paul M]

No.

[Big-K]

Tagged. Can you make this also show the poster of the reported post?

[Paul M]

Sorry, no, I wont be altering the display.

[Big-K]

Sorry, no, I wont be altering the display.

Including the culprits name would have made this inch-perfect for my site. Next version perhaps?

[Paul M]

Sorry, but nope.

Like I said, I wont be altering it.

This is written for my site, and Im happy with the current display. I simply decided to share it (as is).

[SnowBot]

Very demanding these ppl hey paul..lol

Anyway i unistalled your old version ready for this one :) Cheers.

[Paul M]

Old version ?

Ive never released this before afaik.

[Big-K]

Don't mind the demanding Showboat,..sorry Snowbot :)

[maxicep]

i edited certain phrases and imported the product but i didnt see any link or change on report system. How can i use this now :)

p.s: Member groups are correct.

[Paul M]

Im amazed no one else has asked that :) I forgot this needs a manual link creating atm.

To view the page you need to create a link to misc.php?do=reported

I'll update it in the next few days to auto create a link in Quick Links or the Community Links.

[Big-K]

Hi,

I cant find the phrases
reportpost_newthread
reportprivatemessage_newthread

[Terrie]

This is a great mod thank you!

One thing tho... The links to the post and reporter
come up like this:
http://www.yoursitename.com/board/showthread.php?p=203344#post203344

My forums are in a directory called "forums" not "board"
is there a way to change this?

[Paul M]

Hmmm, I didnt realise /board/ was hard coded in there - thats because this was written purely for my forums originally, I've taken that out for 3.8.003

[Terrie]

Absolutely wonderful.... Thank you :)

[MentaL]

you sir are a gentleman

[Stifler]

this def needs to have a display for which forum the reported post is in and then it would be perfect for larger sites with lots of mods for different sections..

[Paul M]

Point noted, but its not high on my priority list.

[jscieza]

Hello Paul,

Just a quick question. Reported posts are now coming with this format (as required per your mod):


The following post has been reported.

Poster : username

Thread : thread title

Reason : report reason

Original Post (Link) :

message


When I click on the thread or message link, it loads on the same page. Is there any way to make this to open in a new page?

Why? Well, moderators are required to reply in the thread of the report commenting what they has done with the reported post and since the post link is being opened on the same page, they will need to look again for the thread of report in order to post what they has done.

Hope you can help me. Please excuse me for my bad english, that's not my language.

Thank you,
Jonathan

[Paul M]

Sorry, it uses the standard vb post bb code, which does not appear to open the link in a new page. On most browsers you can just hold down the SHIFT key and then click on the link.

[jscieza]

Hello Paul,

I see. No worries, thank you.

Another suggestion: it should have a column to contain a link to the report thread. This will be very useful for moderators when reviewing the list of reported post. I think that it could be another column or instead of that just add a link at the right of the thread title.

On a side note, all reports are created by a unique username defined in the vBulletin Options. Is there any way to bypass this config? I mean, any way to display the real username of the reporter instead of the username defined in the vBulletin Options?

Finally, I think that a feature to enable/disable reported post list access permisions base on usergroup should be very useful also.

Thank you,
Jonathan

[Paul M]

There is already a link to the reported post ;

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

As for the reporter - you must have set this up in your vb options, you dont have to have a specific user, just leave the "Post Reporting User" option blank.

[jscieza]

There is already a link to the reported post

Oh sorry, my mistake.

As for the reporter - you must have set this up in your vb options, you dont have to have a specific user, just leave the "Post Reporting User" option blank.

Yes I know but my suggestion is to add an option to bypass this config and display the username of the original reporter.

Finally, I think that a feature to enable/disable access to the misc.php?do=reported based on usergroups should be very useful also. Maybe someone want to make this information accesible only for staff.

Thank you,
Jonathan




Edited:

Quick question: when I click on the moderator name a new window is open with the reported post information. At the bottom line there is a 'Comment: No Reply Yet' text. What is the purpose of this text?

[Paul M]

Yes I know but my suggestion is to add an option to bypass this config and display the username of the original reporter.
I dont see the point, if you want the original reporter, turn off the fixed user in the existing vb options.

Finally, I think that a feature to enable/disable access to the misc.php?do=reported based on usergroups should be very useful also. Maybe someone want to make this information accesible only for staff.
This was designed to be accessible to everyone, so I dont think I'll be adding that anytime soon, if at all.

Quick question: when I click on the moderator name a new window is open with the reported post information. At the bottom line there is a 'Comment: No Reply Yet' text. What is the purpose of this text?
This is answered in the main post (staff comment).

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).

[Saint_ago]

Great Mod, but there is a problem.

My Moderators and Supermoderators are in primary group "Registered Users" and secondary "Moderators" and "Super". And the hack doesn't recognise they as staff members, even if configured in the hack options.

How can i fix this? I don't want to move them to other primary group than "Registered.."..

[Paul M]

Sorry, it only checks primary groups.

[Saint_ago]

Sorry, it only checks primary groups.

Is it possible to make it check secondary groups in a next version?

[Paul M]

Yes, I dont see why not.

Edit: Actually, there might be an issue with this, I need to look more closely.

[kidthanh86]

Dear Paul. i try to install this mod but i reported but i don't see thing in

http://xxxxx/misc.php?do=reported

please help me.

Thanks sir

[Paul M]

Help you how ?

[Pcwolfx?]

Hi Paul,
We want this addons for 3.7 Series.

[Paul M]

There is no specific 3.7 release - but if you edit the product xml to allow 3.7.0 instead of 3.8.0 it should all work ok.

[kidthanh86]

I make same in the guild and i reported some topic and don't have everting in http://azs.cc/misc.php?do=reported

[Pcwolfx?]

There is no specific 3.7 release - but if you edit the product xml to allow 3.7.0 instead of 3.8.0 it should all work ok.

thanks.

[Paul M]

thanks.
Actually, Im not so sure now, I seem to remember I had to make a few changes from 3.7 to 3.8, so it may not be compatible with 3.7

[Saint_ago]

Yes, I dont see why not.

Edit: Actually, there might be an issue with this, I need to look more closely.

Ok, thanks. Looking forward for this.

;)

[kidthanh86]

please help me, Paul Marsden
Thanks sir

[Paul M]

Help you how ?

[Paul M]

Ok, thanks. Looking forward for this.

;)

Updated - 3.8.004

[Pcwolfx?]

Updated - 3.8.004

Thanks Paul. :up:

[Saint_ago]

Updated - 3.8.004

Thanks, Paul! ;)

[Saint_ago]

Paul, another thing.. the reported Private Message isn't working, the thread is created but doesn't show on Message field:

[Paul M]

I dont know what you mean by "doesn't show on Message field"

Seems to be working fine for me.

[Saint_ago]

I dont know what you mean by "doesn't show on Message field"

Seems to be working fine for me.

Showing "0" instead of message #. I know that's a Private Message, but maybe if show anything else (like sender's id or member number) instead a 0, should be a little less confusing for all staff members..

[Paul M]

That field is the post number (and link to the post), both of which are irrelevant for reported PM's, therefore it is set to zero. That is not a fault, it is by design.

[Greek76]

Reported posts don't show up on the reported posts page for me either.

[Saint_ago]

That field is the post number (and link to the post), both of which are irrelevant for reported PM's, therefore it is set to zero. That is not a fault, it is by design.

I see.. thanks.

Is it possible to change in a new version? Put something else, another info like the sender's id or the link for sender's profile?

[Paul M]

Possible I guess, but then the column header would be incorrect. Still, I'll think about it.

[Big-K]

Hi Paul,

two questions

1. On my board, we try to make moderators anonymous. Is there a way to not show the moderators column, but still find a way to show the "reported post information" pop-up?

2. In the "reported post information" pop-up, I'm always seeing "No Reply Yet " in the comments field, even when there's been a response in the reported post thread.

Thanks!

[Paul M]

1. I suppose you could edit the template to output some fixed text instead of the mods name.

2. The response must be a quote (or whatever tag you have set) in the first staff response post.

[Big-K]

1. I suppose you could edit the template to output some fixed text instead of the mods name.

2. The response must be a quote (or whatever tag you have set) in the first staff response post.
Thanks Paul. Which of the templates control the output of the report list? The "Reported_Post_list" does not have a field for the specific row items.

[Paul M]

Hmm, having looked, its not that simple, you would have to edit the plugin code.

[Big-K]

Hmm, having looked, its not that simple, you would have to edit the plugin code.

I found the code in Reported Post List (2), created a phrase called "Details" to replace moderators username. Many thanks

[tafreeh]

can u please post a screenshot, of admin cp... so i can get the list of features

[itsheinz]

Im sorry if gona ask some questions coz i really dont know where to find these phrases:
reportpost_newthread
reportpost_newthread

[Paul M]

Look them up in the Phrase Manager

[itsheinz]

i dont see any in the "Email Subject text" and even in the "Email Body Text"
Where is it?i already installed the xml file,but i cant see those phrases.BTW,im using 3.8.1

[Paul M]

They are standard vb phrases, you search for them in the ACP (Languages & Phrases >> Search in Phrases) - I dont really see what else I can tell you.

[itsheinz]

im sorry about that dude,ok im done with it,thanks for this cool hack^^

[BoredOutOfMyMin]

Im amazed no one else has asked that :) I forgot this needs a manual link creating atm.

To view the page you need to create a link to misc.php?do=reported

I'll update it in the next few days to auto create a link in Quick Links or the Community Links.

I created a new Forum under Admin area which is closed by membergroup to only staff.

Great Tool Paul.

Thank you!

[SEW810]

Sounds cool.
Reserved

[RedHacker]

In Not Actioned Yet how to doing moderator for fix report post....?

[Paul M]

Um... Sorry, I dont understand you.

[RedHacker]

Forget it its work fine and it is useful

[RedHacker]

How to reported posts show only administrators and moderators?

[SEW810]

Not working, reported post log (thread) always empty.
Everyone can see reported post screen. (Setts says only Admins can )
I've translated everything just as txt says.

Using vb 3.8.1 :(

What's wrong?

[RedHacker]

The mod is working and i have 3.8.1 try then again..

Paul how can show only admin and mods in community\report post ....?

[Paul M]

There is no facility to only allow certain usergroups to view the list, it is designed for all (except guests).

[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]

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.

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

[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]

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]

Where do I edit this?

vBulletin Options > User Infractions & Post Reporting Options



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.