Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.7 > vBulletin 3.7 Add-ons
Reload this Page Statistics Modifications - Total Member Count Excluding Banned Members
FAQ Community Calendar Today's Posts Search

Reply
Page 1 of 2 1 2
 
Thread Tools
Total Member Count Excluding Banned Members Details »»
Total Member Count Excluding Banned Members
MOD Information
The Developer
Mosh's Avatar
 
Version: 3.7.004, by Mosh Mosh is offline
Developer Last Online: Nov 2023 Show Printable Version Email this Page
Category: Statistics Modifications - Version: 3.7.x Rating:
Released: 03-10-2008 Last Update: 05-29-2008 Installs: 21
Uses Plugins Auto-Templates
Re-useable Code Translations  
No support by the author.

Hack Support

This hack is obsolete and has now been discontinued, as it has now been integrated into my Banned Members Log hack - this means that while it will remain available for download and use, there will be no further updates, nor will support be provided as the thread is no longer monitored.

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


vBulletin Version Compatibility

This hack can be used with v3.6.10 and v3.7.x. This has not been tested with earlier versions of v3.6.x, but should work.


What Does This Hack Do?

This simple hack will alter the total member count on your forum's homepage to exclude all banned members, you can optionally show the banned member count.

This hack was created because I liked the idea of this hack by Alan @ CIT, and as it was in the Modification Graveyard I had rewrite it from scratch, and I have added the option to display the banned member count (as this hack calculates it, so thought I would display that as well).

There are no file or template changes at all and is fully phrased. This generates 1 extra query on the forum homepage only.


Installation Instructions
  1. Import ms_membercount_ex_banned.xml into vB using the AdminCP Product Manager. If upgrading then set Allow Overwrite to Yes.
  2. In vBulletin Options > Total Member Count Excluding Banned Members. You can select if you want to display the banned member count (this is disabled by default). You can also turn this hack on or off.
Note: If you want to change the word Banned to a different word or language, you will need to edit the banned phrase.

Uninstall Instructions
  1. Uninstall the product in vB using the AdminCP Product Manager.


Screenshots
Shown in this order:
  • Without the hack installed
  • With the hack installed and active
  • With the hack installed and active along with banned member count display being enabled
  • AdminCP options


Version History

v3.7.004 - Saturday 31st May 2008
-- Final Release
-- Changed: Partial code rewrite
-- Fixed: SQL query yet again

v3.7.003 - Thursday 29th May 2008
-- Fixed: SQL query again

v3.7.002 - Thursday 22nd May 2008
-- Changed: Version numbering
-- Fixed: SQL query
-- Added: AdminCP option

v1.0.0 - Tuesday 11th March 2008
-- Initial Release


Show Your Appreciation

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.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 03-11-2008, 02:21 AM
Barakat's Avatar
Barakat Barakat is offline
 
Join Date: Nov 2004
Location: Jerusalem
Posts: 571
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
works good ... thanks.
Reply With Quote
  #3  
Old 03-11-2008, 02:57 AM
Mosh's Avatar
Mosh Mosh is offline
 
Join Date: Aug 2004
Location: Melbourne, Australia
Posts: 1,968
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Barakat View Post
works good ... thanks.
Hi Barakat,

I noticed your forum is in Arabic, all you need to do is edit the banned phrase and change it to Arabic instead
Reply With Quote
  #4  
Old 03-11-2008, 02:20 PM
Barakat's Avatar
Barakat Barakat is offline
 
Join Date: Nov 2004
Location: Jerusalem
Posts: 571
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
done thanks again ....
Reply With Quote
  #5  
Old 05-22-2008, 04:21 AM
Mosh's Avatar
Mosh Mosh is offline
 
Join Date: Aug 2004
Location: Melbourne, Australia
Posts: 1,968
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Update: v3.7.002
  • Version numbering changed
  • Extra AdminCP option added
  • SQL Query changed
Reply With Quote
  #6  
Old 05-22-2008, 12:18 PM
mattswanson mattswanson is offline
 
Join Date: Oct 2006
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I'm getting a negative number for total members (-132). At last count I had 138 banned users and 6690 members. Any ideas on why the math is coming out wrong?

www.kpcnews.net/fence_post - I've turned it off right now while I try to figure out what is going on.
Reply With Quote
  #7  
Old 05-22-2008, 01:00 PM
Mosh's Avatar
Mosh Mosh is offline
 
Join Date: Aug 2004
Location: Melbourne, Australia
Posts: 1,968
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by mattswanson View Post
I'm getting a negative number for total members (-132). At last count I had 138 banned users and 6690 members. Any ideas on why the math is coming out wrong?

www.kpcnews.net/fence_post - I've turned it off right now while I try to figure out what is going on.
Try this this one instead, when importing set Allow Overwrite to Yes.

Let me know if this works.

EDIT: Removed attachment
Reply With Quote
  #8  
Old 05-26-2008, 07:32 PM
Idawg's Avatar
Idawg Idawg is offline
 
Join Date: Nov 2006
Location: Phx, Az
Posts: 65
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I keep getting a database error when I run it
Reply With Quote
  #9  
Old 05-26-2008, 10:47 PM
Mosh's Avatar
Mosh Mosh is offline
 
Join Date: Aug 2004
Location: Melbourne, Australia
Posts: 1,968
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Idawg View Post
I keep getting a database error when I run it
What database error?????? Please elaborate
Reply With Quote
  #10  
Old 05-27-2008, 04:02 AM
MDK-Indy MDK-Indy is offline
 
Join Date: Mar 2007
Location: Germany
Posts: 91
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Idawg View Post
I keep getting a database error when I run it
Me to...

PHP Code:
Datenbankfehler in vBulletin 3.7.0:

Invalid SQL:

        SELECT COUNT(userban.userid) AS count
        FROM vbuserban;

MySQL-Fehler  : Unknown column 'userban.userid' in 'field list'
Fehler-Nr.    : 1054
Fehler-Zeit   : Tuesday, 27.05.2008 @ 07:01:00
Datum         : Tuesday, 27.05.2008 @ 07:01:00
Skript        : http://xxx/index.php
Referrer      : http://xxx/member.php?u=1
IP-Adresse    : xxx.xxx.xxx.xxx
Benutzername  : Indy
Klassenname   : vB_Database
MySQL-Version : 5.0.32-Debian_7etch5 
Reply With Quote
Reply
Page 1 of 2 1 2

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 02:12 PM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07966 seconds
  • Memory Usage 2,307KB
  • Queries Executed 23 (?)
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
  • (1)bbcode_php
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (9)postbit
  • (10)postbit_onlinestatus
  • (10)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_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete