vb.org Archive
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Statistics Modifications - Total Member Count Excluding Banned Members (https://vborg.vbsupport.ru/showthread.php?t=172677)

Mosh 03-10-2008 10:00 PM
Total Member Count Excluding Banned Members
 
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.

Barakat 03-11-2008 02:21 AM
works good ... thanks.

Mosh 03-11-2008 02:57 AM
Quote:
Originally Posted by Barakat (Post 1461973)
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 :)

Barakat 03-11-2008 02:20 PM
done thanks again ....

Mosh 05-22-2008 03:21 AM
Update: v3.7.002
  • Version numbering changed
  • Extra AdminCP option added
  • SQL Query changed

mattswanson 05-22-2008 11:18 AM
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.

Mosh 05-22-2008 12:00 PM
Quote:
Originally Posted by mattswanson (Post 1527865)
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

Idawg 05-26-2008 06:32 PM
I keep getting a database error when I run it

Mosh 05-26-2008 09:47 PM
Quote:
Originally Posted by Idawg (Post 1532153)
I keep getting a database error when I run it
What database error?????? Please elaborate

MDK-Indy 05-27-2008 03:02 AM
Quote:
Originally Posted by Idawg (Post 1532153)
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 


All times are GMT. The time now is 07:12 PM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01727 seconds
  • Memory Usage 1,748KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete