Moderators Functions - Unapprove Reported Posts (Based on No. of Reports & Usergroups)

This modification has been based on the following Mod found here: https://vborg.vbsupport.ru/showthread.php?t=231622 - I have been given permission by that author to release this modified version of his original Mod.

This modification adds much needed features such as:

- Number of Reports required to send a post in Moderation Queue
- Usergroups which can bypass min. reports required.

Anyone who makes changes to this modification to better it in anyway, I only ask you share it with the rest of us in this thread!

Enjoy!

[0ptima]

Will check this out soon!

[Manoel J?nior]

Tagged

[inciarco]

Very Interesting Mod, Thank You For Sharing It. :up:

The Code Alters the "post" Table adding the Field "reports", You Should Add the "DB Changes" in the Mod's Specifications.

ALTER TABLE " . TABLE_PREFIX . "post ADD reports INT(10) UNSIGNED NOT NULL DEFAULT '0'

My Best Regards.

[BirdOPrey5]

Originally Posted by inciarco

Very Interesting Mod, Thank You For Sharing It. :up:

The Code Alters the "post" Table adding the Field "reports", You Should Add the "DB Changes" in the Mod's Specifications.

ALTER TABLE " . TABLE_PREFIX . "post ADD reports INT(10) UNSIGNED NOT NULL DEFAULT '0'

My Best Regards.

Good catch. I made the change.

[MoMan]

Very nice and elegant mod!

[Ramsesx]

Cool, that's what I need, thanks.

[MoMan]

Not that this really matters, but technically a redundant query is made once a post has enough reports and gets unapproved.

I've updated my plugin code to the following:

PHP Code:

if ($_POST['do'] == 'sendemail' AND !empty($_POST['reason']))
{
    $reports = $vbulletin->db->query_first("SELECT reports FROM " . TABLE_PREFIX . "post WHERE postid = " . $postinfo['postid']);
    if ($reports['reports'] + 1 >= $vbulletin->options['unapprove_reported_posts_num_reports'] OR is_member_of($vbulletin->userinfo, unserialize($vbulletin->options['unapprove_reported_posts_bypass_usergroups'])))
    {
        $modinfo = fetch_userinfo($postinfo['userid']);
        $uglist = $modinfo['usergroupid'] . iif(trim($modinfo['membergroupids']), ",$modinfo[membergroupids]");
        if (!can_moderate(0, '', $modinfo['userid'], $uglist) OR ($permissions['adminpermissions'] & $vbulletin->bf_ugp_adminpermissions['cancontrolpanel']))
        {
            require_once(DIR. '/includes/functions_databuild.php');
            unapprove_post($postinfo['postid'], ($foruminfo['countposts'] AND !$postinfo['skippostcount']), true, $postinfo, $threadinfo, false);
            $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "post SET reports = 0 WHERE postid = " . $postinfo['postid']);
        }
        else
        {
            $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "post SET reports = reports + 1 WHERE postid = " . $postinfo['postid']);
        }
    }
    else
    {
        $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "post SET reports = reports + 1 WHERE postid = " . $postinfo['postid']);
    }
} 


[paul1972]

who has this on their website? I'd like to see it in action....please list your website

[Wonksta]

Originally Posted by paul1972

who has this on their website? I'd like to see it in action....please list your website

You can't see it in action unless you're a Moderator/Admin on the board it is installed on.

This modification works extremely well with the "Quick Moderation" Module with vBAdanced.

Here's a screeny: