The Arcive of Official vBulletin Modifications Site.

Banned Members Log · **Released**: 10-30-2008

Please click Mark as Installed if you are using this hack.

What Does This Hack Do?[hr]hr[/hr]
It is a update of my v3.7.x hack available here, with the addition of file hooks, hack authors can now use hooks to expand this hack if needed, and a new column for the usergroup the banned user has been put in.

This hack displays a log of all temporary and permanently banned members on it's own page, it is paginated (with page count on the permanent bans section) if there are more results than you selected per page in the AdminCP, temporary bans are only displayed on page 1 (if you have more temporary banned members than one page, you must be doing something wrong), along with a count on how many temporary and permanent banned members there are. Any users displayed on the page(s) will have links to display their profile, if clicked on.

It can also show an altered total member count on your forum's homepage (if enabled) to either show the altered members count (exclude all banned members), show the altered members and unconfirmed (Users Awaiting Email Confirmation) members count, show the altered members, unconfirmed members and banned members count, or you can disabled it altogether (so it shows the unaltered members count). Enabled or disabled, it does not generate any extra queries.

You can optionally add a link on either the navbar proper or quick links.

This hack is controlled by usergroup permissions.

As an added bonus (if enabled), if a usergroup has permissions to view the banned members log, then the banned members count on the forumhome page will be clickable and will load the banned members log if clicked on (if no permission, then it will not be clickable).

This hack was created because I liked the idea of this hack by jredrum, and as it is not supported, not phrased at all, has no pagination, and has no usergroup permissions to speak of, I decided to use the idea of that hack and rewrite it from scratch based on the ModCP file banning.php, I have also integrated my Total Member Count Excluding Banned Members hack into this one and have now retired it.

There is only one file change (to config.php), but no template changes at all and is fully phrased. This generates no extra queries on the forum homepage at all, and generates 9-11 queries (depending on options selected and if logged out/logged in) on the ban_log.php page.

vBulletin Version Compatibility[hr]hr[/hr]
This hack can be used with vBulletin versions 3.6.0 - 3.8.8.

For the v4.0.x version of this hack - check here.

Hack Support/Feature Requests[hr]hr[/hr]
IMPORTANT: This hack is no longer supported.

Branding[hr]hr[/hr]
There is a small unobtrusive block of copyright branding text at the bottom of each page generated by this hack, which is there to promote my work and allow you to use this hack for free.

You are NOT allowed to remove my copyright branding from this hack.

Install/Uninstall Instructions[hr]hr[/hr]
The InstallInstructions.txt instructions file is included in attached .zip file.

Screenshots[hr]hr[/hr]
Shown in this order:

AdminCP Options
Banned Members Log (with temporary and permanent bans)
Banned user count shown in forum statistics on the forum homepage
Banned Members Log (with no temporary and permanent bans)
Message if there are no Banned Usergroups defined
Banned Members Log (with permanent bans and pagnation)

Version History[hr]hr[/hr]
v3.8.004 - Wednesday 24th June 2009
-- Fixed: banned_log template (column mismatch)

v3.8.003 - Wednesday 25th February 2009
-- Fixed: Banned Members Log (3) plugin - replaced 2 x ? with (c) to prevent parse errors (rare cases)
-- Changed: Files - ban_log.php (streamlined a couple of SQL queries)
-- Changed: banned_log template (column display order)
-- Changed: banned_perm_row template (column display order)
-- Changed: banned_temp_row template (column display order)
-- Updated: Files - ban_log_cron.php, hooks_ban_log.xml
-- Updated: Installation Instructions
-- Updated: Screenshots

v3.8.002 - Thursday 19th February 2009
-- Changed: Files - ban_log.php (updated SQL queries)
-- Changed: banned_log template
-- Changed: banned_none template
-- Changed: banned_perm_row template
-- Changed: banned_temp_row template
-- Updated: Banned Members Log (3) plugin
-- Updated: Files - ban_log_cron.php, hooks_ban_log.xml
-- Updated: Installation Instructions (now includes un-install instructions)
-- Updated: Screenshots
-- Added: New column - Usergroups
-- Added: bangroup phrase
-- Added: VersionHistory.txt

v3.8.001 - Friday 31st October 2008
-- Added: File Hooks
-- Initial vBulletin v3.8.x release

Show Your Appreciation [hr]hr[/hr]
Although not required, if you have enjoyed the benefits of this hack, and would like show your appreciation for my efforts, then please feel free to click on the Support Developer link and donate any amount you feel is appropriate.

Donations[hr]hr[/hr]
I would like to thank the following people for their kind donations:

Koidl

Mosh · #52 06-23-2009, 12:57 AM

Quote:

Originally Posted by Jon1422

Quick word of advice... when installed, the "ban time remaining" and "lift ban" column headers for temp bans are over the wrong columns

To correct, edit the .xml file prior to installing and locate the code lines:

<td class='thead' align='center'>$vbphrase[ban_time_remaining]</td>
<td class='thead' align='center'>$vbphrase[lift_ban]</td>

and swap these around so they read...

<td class='thead' align='center'>$vbphrase[lift_ban]</td>
<td class='thead' align='center'>$vbphrase[ban_time_remaining]</td>

Done

Thanks for pointing that out

I have been able to replicate this. I will release an updated version that fixes this in the next couple of days.

Mosh · #53 06-24-2009, 07:18 AM

Update: v3.8.004 - Wednesday 24th June 2009
-- Fixed: banned_log template (column mismatch)

ragarcia87 · #54 08-12-2009, 01:34 PM

After I upgraded to vBulletin 3.8.4 the number of banned users at the bottom shows 0 instead of 33 which it should be. Any help would be awesome

toonysnn · #55 08-12-2009, 04:33 PM

For anyone who has the issue that ragarcia87 has, I've made a temporary fix, adding a SQL query.

Replace plugin "Banned Members Log (2)" contents with:

PHP Code:


			
if ($vbulletin->options['bml_display_banned_membercount'] != 0)
{
    
    $qqqqqq = $vbulletin->db->query_read("SELECT COUNT(*) FROM `" . TABLE_PREFIX . "user` WHERE usergroupid='8'");
    $qqqqqq = $vbulletin->db->fetch_array($qqqqqq);
    
    // assign the member counts from the datastore to some variables
    $bannedmembercount = intval(($vbulletin->ms_datastore['bml_counter'] > 0 ? $vbulletin->ms_datastore['bml_counter'] : $qqqqqq['COUNT(*)']));
    $unconfirmedmembercount = intval($vbulletin->ms_datastore['bml_unconfirmed']);
    $propermembercount = $vbulletin->userstats['numbermembers'];

    // set all display flags to true
    $show['banned_count_url'] = true;
    $show['banned_count'] = true;
    $show['unconfirmed_count'] = true;

    // work out if the user is in a usergroup that has permissions to get the banned member link
    // if the user does not have permission, then set the display flag are set to false
    $banned_allowed_groups = explode(',',$vbulletin->options['bml_grps']); 
    if ($vbulletin->options['bml_all_grps'] == 1)
    {
        if(!is_member_of($vbulletin->userinfo,$banned_allowed_groups)) 
        {
            $show['banned_count_url'] = false;
        }
    }

    // change flags to false, depending on what counts we want to display
    // also calculate the altered member count, based on selection
    if ($vbulletin->options['bml_display_banned_membercount'] == 1)
    {
        $show['banned_count'] = false;
        $show['unconfirmed_count'] = false;
        $newmembercount = $propermembercount - $bannedmembercount;
    }
    if ($vbulletin->options['bml_display_banned_membercount'] == 2)
    {
        $show['banned_count'] = false;
        $newmembercount = $propermembercount - $unconfirmedmembercount - $bannedmembercount;
    }
    if ($vbulletin->options['bml_display_banned_membercount'] == 3)
    {
        $show['unconfirmed_count'] = false;
        $newmembercount = $propermembercount - $bannedmembercount;
    }
    if ($vbulletin->options['bml_display_banned_membercount'] == 4)
    {
        $newmembercount = $propermembercount - $unconfirmedmembercount - $bannedmembercount;
    }

    // here is the correct members count
    $numbermembers = vb_number_format($newmembercount);

    // spit out the resulting template
    eval('$numbermembers .= "' . fetch_template('banned_count') . '";');
}

ragarcia87: I've applied this to our board.

Mosh · #56 08-13-2009, 02:45 AM

Quote:

Originally Posted by ragarcia87

After I upgraded to vBulletin 3.8.4 the number of banned users at the bottom shows 0 instead of 33 which it should be. Any help would be awesome

I will look into it and get back to you.

Quote:

Originally Posted by toonysnn

For anyone who has the issue that ragarcia87 has, I've made a temporary fix, adding a SQL query.

Replace plugin "Banned Members Log (2)" contents with:

PHP Code:


			
if ($vbulletin->options['bml_display_banned_membercount'] != 0)
{
    
    $qqqqqq = $vbulletin->db->query_read("SELECT COUNT(*) FROM `" . TABLE_PREFIX . "user` WHERE usergroupid='8'");
    $qqqqqq = $vbulletin->db->fetch_array($qqqqqq);
    
    // assign the member counts from the datastore to some variables
    $bannedmembercount = intval(($vbulletin->ms_datastore['bml_counter'] > 0 ? $vbulletin->ms_datastore['bml_counter'] : $qqqqqq['COUNT(*)']));
    $unconfirmedmembercount = intval($vbulletin->ms_datastore['bml_unconfirmed']);
    $propermembercount = $vbulletin->userstats['numbermembers'];

    // set all display flags to true
    $show['banned_count_url'] = true;
    $show['banned_count'] = true;
    $show['unconfirmed_count'] = true;

    // work out if the user is in a usergroup that has permissions to get the banned member link
    // if the user does not have permission, then set the display flag are set to false
    $banned_allowed_groups = explode(',',$vbulletin->options['bml_grps']); 
    if ($vbulletin->options['bml_all_grps'] == 1)
    {
        if(!is_member_of($vbulletin->userinfo,$banned_allowed_groups)) 
        {
            $show['banned_count_url'] = false;
        }
    }

    // change flags to false, depending on what counts we want to display
    // also calculate the altered member count, based on selection
    if ($vbulletin->options['bml_display_banned_membercount'] == 1)
    {
        $show['banned_count'] = false;
        $show['unconfirmed_count'] = false;
        $newmembercount = $propermembercount - $bannedmembercount;
    }
    if ($vbulletin->options['bml_display_banned_membercount'] == 2)
    {
        $show['banned_count'] = false;
        $newmembercount = $propermembercount - $unconfirmedmembercount - $bannedmembercount;
    }
    if ($vbulletin->options['bml_display_banned_membercount'] == 3)
    {
        $show['unconfirmed_count'] = false;
        $newmembercount = $propermembercount - $bannedmembercount;
    }
    if ($vbulletin->options['bml_display_banned_membercount'] == 4)
    {
        $newmembercount = $propermembercount - $unconfirmedmembercount - $bannedmembercount;
    }

    // here is the correct members count
    $numbermembers = vb_number_format($newmembercount);

    // spit out the resulting template
    eval('$numbermembers .= "' . fetch_template('banned_count') . '";');
}

ragarcia87: I've applied this to our board.

Thanks for the temp fix

But it introduces two problems:

It adds an extra query per page
It does not take into account all ban groups, just usergroupid 8

As I said above for ragarcia87, I will look into it and get back to you asap (hopefully with a solution).

Mosh · #57 08-13-2009, 04:08 AM

Quote:

Originally Posted by ragarcia87

After I upgraded to vBulletin 3.8.4 the number of banned users at the bottom shows 0 instead of 33 which it should be. Any help would be awesome

I can not replicate your issue.

I just upgraded a forum to vBulletin v3.8.4 and the number of banned users still shows up fine and correct.

As the number of banned members shown on the homepage is stored in the datastore and as far as I know vBulletin v3.8.4 has not altered how the datastore works, upgrading your forum should not affect this hack at all.

OK, from the installation instructions, can you ensure that you have done step 4 (i.e. file edit has not been accidentally been removed), then follow it by step 6.

Let me know if this fixes your issue.

dothanhtrung · #58 08-16-2009, 07:08 AM

In Automatic Link Creation (ACP ===> Banned Members Log), can you add "Create Link in Community" ?

Thanks,

Mosh · #59 08-16-2009, 07:28 AM

Quote:

Originally Posted by dothanhtrung

In Automatic Link Creation (ACP ===> Banned Members Log), can you add "Create Link in Community" ?

Thanks,

I thought about that before I released v3.8.004 of this hack, but as the Community menu was not added until vBulletin v3.8, the option would not work with v3.7.x nor v3.6.x, I would definitely get unnecessary posts asking this was not working on 3.x.x and how to get it working with it.

So, to maintain full compatibility over all 3 versions of vBulletin this hack is supported on, I will not be adding your request to the hack, sorry

Mosh · #60 11-25-2009, 02:08 AM

The vBulletin v4.0.x version of this hack is available here.

Mosh · #61 01-02-2010, 01:36 AM

Hi all,

It is with regret that after over 4 years (and thousands of hours) spent providing free support for my free hacks released here, as of today I will no longer be able to provide support for free.

This is due to being unemployed for a while, being strapped for cash and unable to rely on the virtually non-existent donations from here to help to pay the bills or put food on the table for my family. I am now providing all support for my free hacks released here over at Wolfshead Solutions via an annual support subscription (for a small fee).

It does not mean I will be no longer release free hacks, I will, but I will just no longer be supporting them for free.

My free hacks have and always will remain free to download and use. And so will updates/bug fixes.

I will be releasing more free hacks, but if you require any support at all for those free hacks, you will need to purchase an annual support subscription over at Wolfshead Solutions to receive support.

I am really sorry I have to do this, but revenue generated by my programming gigs are now my only source of income, and I can no longer afford the luxury of providing free support here, when that time can be spent creating new commercial products, doing paid work requests or providing paid support to pay the bills.

Thank you for the understanding.

Regards,

Mosh.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04758 seconds Memory Usage 2,414KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_php (5)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (8)postbit_attachment (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!