[taravasya]

Stratis its in module: "Showing notifications" of FractalizeR product.
At this time:
//reply - post
its begin of first if statement after comment:
//#################### Acquiring ####################

and....

//visitormessage, groupmessage, picturecomment
its begin of second if statement after comment:
//#################### Acquiring ####################

And all together looks like this:

PHP Code:

    //#################### Acquiring ####################  
    //reply - post  
    if(in_array('reply', $fr_itemsToTrack)) {  
        $query = "SELECT COUNT(*) AS num  
                  FROM " . TABLE_PREFIX . "moderation AS moderation  
                  INNER JOIN " . TABLE_PREFIX . "post AS post ON (moderation.primaryid = post.postid)  
                  INNER JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid)  
                  WHERE type = 'reply' ". $m_forums;  
        $fr_result = $vbulletin->db->query_first($query);  
        $fr_modItems['reply'] ['total'] = $fr_result['num'];  
    } 

    //visitormessage, groupmessage, picturecomment  
    if(count(array_intersect($fr_itemsToTrack, array('visitormessage', 'groupmessage', 'picturecomment')))>0) {  
        $query = "SELECT COUNT(type) AS total, type  
                  FROM ". TABLE_PREFIX ."moderation  
                  GROUP BY type";  
        $fr_result = $vbulletin->db->query_read($query);  
        while($fr_entry = $vbulletin->db->fetch_array($fr_result)) {  
            $fr_modItems[$fr_entry['type']] ['total'] = $fr_entry['total'];  
        }  
    } 


For correct processing of rights of moderation with this product you need to rearrange this two if statement upward. Like this:

PHP Code:

    //#################### Acquiring ####################  
    //visitormessage, groupmessage, picturecomment  
    if(count(array_intersect($fr_itemsToTrack, array('visitormessage', 'groupmessage', 'picturecomment')))>0) {  
        $query = "SELECT COUNT(type) AS total, type  
                  FROM ". TABLE_PREFIX ."moderation  
                  GROUP BY type";  
        $fr_result = $vbulletin->db->query_read($query);  
        while($fr_entry = $vbulletin->db->fetch_array($fr_result)) {  
            $fr_modItems[$fr_entry['type']] ['total'] = $fr_entry['total'];  
        }  
    }    

    //reply - post  
    if(in_array('reply', $fr_itemsToTrack)) {  
        $query = "SELECT COUNT(*) AS num  
                  FROM " . TABLE_PREFIX . "moderation AS moderation  
                  INNER JOIN " . TABLE_PREFIX . "post AS post ON (moderation.primaryid = post.postid)  
                  INNER JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid)  
                  WHERE type = 'reply' ". $m_forums;  
        $fr_result = $vbulletin->db->query_first($query);  
        $fr_modItems['reply'] ['total'] = $fr_result['num'];  
    } 


Sorry for my english.... :erm: