Moderators Functions - Pedro!'s Post Report Manager 0.93

This system offers an advanced management system for all types of reported content including:

• Posts
• Group Messages
• Group Pictures
• Profile Album Pictures
• Group Picture Comments
• Profile Album Picture Comments
• Private Messages
• Visitor Messages

Features of this hack (some of which are illustrated by the screenshots):

• Report tracking for the reporter
• Report management area accessible from the Mod CP and Admin CP
• Full integration with notifications menu
• Commenting/update system
• Ajax loading of the reported content from within the CP
• Quick links related to the report/report discussion
• Can set to only display reports that moderators have permissions to 'do something about'
• Fully phrased to allow easy translation

Installation Instructions:

1. Backup your forum database. You are installing this modification at your own risk - I will not be held responsible for any damages or losses to your computer/web server/site data/vBulletin installation that occur from trying to install/uninstall this hack.
2. Extract the files from the .zip archive
3. Open the upload directory
4. If you have changed the directory names of the Mod CP or the Admin CP from the defaults you will need to apply the same changes here.
5. Upload the contents of the 'upload' directory to the forum directory on your web server
6. When the uploads are complete go into the Admin CP and expand the 'Plugins and Products' menu on the left-hand side.
7. Click the 'Manage Products' link in the menu you just expanded.
8. Click the '[Add/Import Product]' link at the bottom of the page.
9. In the 'OR import the XML file from your server' text box change 'product.xml' to 'product-pprm.xml'
10. Click 'Import'
11. Click OK on the prompt
12. Make sure in the vBulletin Options menu under 'User Infractions & Post Reporting Options' that Post Reporting Email is not set to 'no e-mail'. Due to the core hook location of this hack it will not work if e-mailing is not enabled in the vBulletin options. However, this can be overridden on the PPRM configuration page.
13. and you're all done You may wish to change the configuration of PPRM, this can be done from the Post Reports menu in the Admin CP navigation.
14. Mark the mod as installed, this is so you can receive updates regarding the mod. I won't spam you or send you drunken e-mails lolol.

This hack is still in beta phase and I would really appreciate your feedback with any bugs/errors/design issues you encounter. Things to watch out for are compatibility issues with non-major browsers and the 'acknowledge permissions' setting not working as I've only done a very limited amount of testing on it.

The inspiration for this hack came from Distance's Advanced Post Report System for 3.6 which was an upgrade of a mod by some guy called pig, lol.

Change Log
__________________________________________________ ______________________

Version 0.91

• Fixed install issue, oops, lol.
• Removed unnecessary include from /pprm.php

Version 0.92

• Removed depreciated define('NO_REGISTER_GLOBALS', 1) in /pprm.php
• Fixed malformed information in e-mails.
• Fixed enable/disable e-mail option.

Version 0.93

• Fixed security hole.
• Fixed bad links in 'Closed Reports' pagination.

Known Issues
__________________________________________________ ______________________

• [S]0.90 - 'mismatched tag' error on install[/S]
  
• [S]0.91 - E-mail override doesn't work.[/S]
• [S]0.91 - E-mails don't link correctly.[/S]
• [S]0.92 - Pagination broken on Closed Reports page.[/S]
• [S]0.92 - Security Hole[/S]
• 0.92 - With 'Acknowledge moderator permissions...' enabled an SQL error may occur when a moderator tries to access open/closed reports.
• 0.92 - With 'Acknowledge moderator permissions...' enabled moderators can see reports for posts that are in forums they do not moderate.
• 0.92 - Date doesn't display correctly for those who are using a localized date setting

[DobieGillis?]

Originally Posted by Daithi

Thanks lol

I know. I remembered your post when I couldn't find it either, lol! That's how VBulletin does it, as well. BTW: Great Mod! Installed.

[Pedro!]

Hi guys, terribly sorry I haven't paid this mod any attention recently. I kinda totally forgot about it, eek. Big thanks to joe1989 who has been doing rather well in giving support in my absence.

Originally Posted by ToNetU

no am looking how can i find the post link as an admin?
i just find the content about the post (reported post) but there's no link for that post?

thanks

With regards to the link to the post, I'm not sure if this is erroneous or whether you're just not seeing it because it's quite subtle. You have to look at the top of the report where it says

"UserX has reported UserY's post/picture/etc."

The bit in bold is the link, up there are also links to each users profile. This screenshot might help explain what I'm talking about.



Thanks for all the positive feedback and bug reports everyone. I'll start working on a stable version soon and then hopefully we can go gold.

[SirHappy]

nice works! Tagged

[joe1989]

Originally Posted by Pedro

Big thanks to joe1989 who has been doing rather well in giving support in my absence.

No problem.

Originally Posted by Pedro

I'll start working on a stable version soon and then hopefully we can go gold.

Wasn't that what you said like a few months ago, before your extended leave of absence? Just kidding... It's a great mod, and you did a lot of work on it. I am glad to provide support where I can, but unfortunately, I'm very inexperienced when it comes to working with vB code. I have not gotten down into vB's default code enough to feel confident when it comes to coding add-ons for vB. Hence the reason why I have not made any of my own mods...

[Leo Brazil]

Hi Pedro, I've been using your mod for awhile, great job btw and only now I've noticed that date and time on reports discussions just gives me "d/m/Y @ G:i" for all updates and even when the report it self was sent just show me the same. I mean date and time are not parsing.
May be that's because my main language does not matches english standard and I have some different settings as locale for date and time.
I've read everything here but no one has reported this issue before. Any tips ?

Thx.

Edited: I've got it. Just for those with the same issue, I've edited both pprm.php file(one on root and other on modcp folder) and changed the format in two lines on those files for the same date and time format I have at locale. It worked great.

[DraculaVN]

I got this error while accessing "open reports" in ModCP

Database error in vBulletin 3.8.1:

Invalid SQL:

				SELECT COUNT(*) AS count
				FROM pprmReports AS reports
				WHERE reports.status != 'closed' AND reports.type != gp AND reports.type != pap ORDER BY reports.prID DESC;

MySQL Error   : Unknown column 'gp' in 'where clause'

[DraculaVN]

There is no column named 'gp' (also 'pap') in the XML file.

- <installcode>
- <![CDATA[ 
$vbulletin->db->hide_errors();

$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS `" . TABLE_PREFIX . "pprmComments` (
  `cID` int(11) NOT NULL auto_increment,
  `prID` int(11) NOT NULL,
  `uID` int(11) NOT NULL,
  `comment` longtext NOT NULL,
  `commenttime` int(11) NOT NULL,
  `commentstatus` mediumtext NOT NULL,
  PRIMARY KEY  (`cID`)
)");

$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS `" . TABLE_PREFIX . "pprmOptions` (
  `fieldname` char(20) NOT NULL,
  `value` tinyint(4) NOT NULL,
  PRIMARY KEY  (`fieldname`)
)");

$vbulletin->db->query_write("INSERT INTO `" . TABLE_PREFIX . "pprmOptions` (`fieldname`, `value`) VALUES
('usepermissions', 0),
('e-mail', 0)");

$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS `" . TABLE_PREFIX . "pprmReports` (
  `prID` int(11) NOT NULL auto_increment,
  `type` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `posterID` int(11) NOT NULL,
  `reporterID` int(11) NOT NULL,
  `post-picture` int(11) NOT NULL,
  `thread-album-profile` int(11) NOT NULL,
  `forum-group` varchar(255) NOT NULL,
  `reason` longtext NOT NULL,
  `url` longtext NOT NULL,
  `content` longtext NOT NULL,
  `discussionID` int(11) NOT NULL,
  `reporttime` int(11) NOT NULL,
  `closedtime` int(11) NOT NULL,
  PRIMARY KEY  (`prID`)
)");

  ]]> 
  </installcode>

[Spinball]

Have installed.
Some immediate feedback from some of my 50 moderators...

Moderators only want to be notified of the reported posts in the forums they moderate.
If no moderators are assigned to a forum then admin need to be notified.
Since our moderators moderate several forums, we need to see (in the reported post list) the forum containing each reported post.

Hope the feedback helps and I have explained it all ok!
Thanks.

[Spinball]

In fact, my moderators have asked that I roll back to Distance's 3.6 version (which still works) because they only want to see the reports which apply to them and need to see which forum the reported threads are in.
Sorry, but until these two issues are resolved, I have had to disable.
Looking forward to re-enabling your otherwise excellent mod some time soon.

[DraculaVN]

What about my problem from the post above? Still no comment yet