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

[RedeemedWarrior]

works fantastic

[kud0gfx]

Have a really nice look, you think you could implement in the future report signatures, avatars or nicks? thyou

[itsheinz]

Finally i made it..Thanks Pedro!

[maxicep]

Originally Posted by Pedro!

Well, it means that when a mod goes to open/closed reports in the CP it will only show the reported posts in the forums they can moderate. It also checks moderator permissions with pictures, picture comments and visitor messages.

We have a problem.
Category Moderators see all reported posts from all forums.

Category Moderators should only show the reported posts in the forums they can moderate.

How can fix that ?

Also,
When i enable the "Acknowledge moderator permissions when displaying reports?" option

if Moderators clicks the open or closed reports links then:

    Database error in vBulletin 3.8.1:
   
  Invalid SQL:
   
                          SELECT COUNT(*) AS count
                          FROM pprmReports AS reports
                          WHERE reports.status != 'closed' AND reports.type != gm AND reports.type != gp AND reports.type != pap AND reports.type != papc AND reports.type != gpc AND reports.type != vm ORDER BY reports.prID DESC;
   
  MySQL Error   : Unknown column 'gm' in 'where clause'
  Error Number  : 1054

I fixed that with edit the modcp/pprm.php file

if (pprm_ack_perms() == true) {

    //Do crazy ANDs for permissions
    
    $z = 0;
    
    $reporttype = array('post','gm','gp','pap','papc','gpc','pm','vm');

    while ($z < 8) {
    
        if (pprm_check_perms($reporttype[$z]) == false) {
        
            $where .= "AND reports.type != " . $reporttype[$z] . " ";
        
        } 
        
        $z++;
    
    }
    
}

to

if (pprm_ack_perms() == true) {

    //Do crazy ANDs for permissions
    
    $z = 0;
    
    $reporttype = array('post','gm','gp','pap','papc','gpc','pm','vm');

    while ($z < 8) {
    
        if (pprm_check_perms($reporttype[$z]) == false) {
        
            $where .= "AND reports.type != '" . $reporttype[$z] . "' ";
        
        } 
        
        $z++;
    
    }
    
}

What is wrong ?

[andyh2]

After I install this mod on 3.8.1, none of the reports show up. It looks like this. Can anyone help?

[joe1989]

Originally Posted by andyh2

After I install this mod on 3.8.1, none of the reports show up. It looks like this. Can anyone help?

I think the problem you're running into is it only adds reports to the system that were reported AFTER you installed the mod. Make sense? So if you installed the mod on Mar 20, a report from Mar 19 will not show up. This is not a bug; that's just how it works.

To verify this, do a "test report" (after the mod is installed) and make sure it shows up in the system.

Make sense?

[andyh2]

Originally Posted by joe1989

I think the problem you're running into is it only adds reports to the system that were reported AFTER you installed the mod. Make sense? So if you installed the mod on Mar 20, a report from Mar 19 will not show up. This is not a bug; that's just how it works.

To verify this, do a "test report" (after the mod is installed) and make sure it shows up in the system.

Make sense?

We've gotten many, many reports after I installed it, but none of them showed up.

[joe1989]

Are you getting any errors? Try uninstalling, and re-doing everything. I don't know why it wouldn't be working at all; it works fine for me. Let me know of any error messages you receive...

[Pedro!]

Originally Posted by andyh2

After I install this mod on 3.8.1, none of the reports show up. It looks like this. Can anyone help?

I'm not sure what's going on as everyone elses seems to be working okay... can you look in your database and see if anything exists in the pprmReports table? Are you running any other report hacks/mods? If so try and disable those and see if it makes a difference...

Oh, also sorry I haven't brought out any updates, I've been rather busy lately! Will be giving this hack some attention and hopefully be implementing some of the suggested features soon (including an ImpEx tool)

[Pedro!]

Originally Posted by maxicep

We have a problem.
Category Moderators see all reported posts from all forums.

Category Moderators should only show the reported posts in the forums they can moderate.

How can fix that ?

Ah, I think I forgot to make it check the forum ID so it just checking if they can moderate any forum. I'll fix this in the next release. I'll also fix the SQL error.