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!

[paul1972]

so if a post get a certain number of complaints then it will be forwarded to a moderators section?

or how does this work?

is there a button to click on to report the violation to the moderators?

[Wonksta]

Originally Posted by paul1972

so if a post get a certain number of complaints then it will be forwarded to a moderators section?

or how does this work?

is there a button to click on to report the violation to the moderators?

Click on a post and select 'Disapprove' that's all it does to a post/thread.

[MoMan]

FYI with this mod you get a database error if you try to report a PM/VM/picture comment.

In order to fix this, change the plugin code to the following:

PHP Code:

if ($_POST['do'] == 'sendemail' AND isset($postinfo['postid']) 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']);
    }
} 


Essentially you are adding isset($postinfo['postid']) to the main conditional.

[SnakeV]

Good catch.

One question, did you use this mod directly with it's default install code?

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

Because i have also have more than 1.5M of posts like your forum and i think that it could take some time to execute that query.

Originally Posted by MoMan

FYI with this mod you get a database error if you try to report a PM/VM/picture comment.

In order to fix this, change the plugin code to the following:

PHP Code:

if ($_POST['do'] == 'sendemail' AND isset($postinfo['postid']) 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']);
    }
} 


Essentially you are adding isset($postinfo['postid']) to the main conditional.

[home9000]

MoMan or anymone

we need this hack updated anyone can help

[MoMan]

Originally Posted by SnakeV

Good catch.

One question, did you use this mod directly with it's default install code?

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

Because i have also have more than 1.5M of posts like your forum and i think that it could take some time to execute that query.

Yes, it will take several seconds - ideally you should close your board, but I decided not to and got no crashes.

[JesterP]

I can even imagine why this isn't already in vBulletin. Fantastic addition and thank you to the others for the improvements.

Nominated.

[hpidriver]

^^ What version of vb are you running?

marked as tagged

[JesterP]

I have multiple sites running this, 3.8.x and a couple 4.1.7 forums.

[lm3a.net]

It's good but after installing it the sending via email for the reported post is not working also after uninstalling the product