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