vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   Keeping banned members out of the membership total (https://vborg.vbsupport.ru/showthread.php?t=118772)

snowbird 06-16-2006 12:44 PM

Keeping banned members out of the membership total
 
The DB we are using has hundreds of banned members. We would like these banned accounts to NOT be included in the membership total. The CP can't do it..... anyone have a suggestion? Thanks!

Alan @ CIT 06-17-2006 11:44 PM

Hi,

I've knocked something together which should do what you want:

https://vborg.vbsupport.ru/showthread.php?t=118922

It adjusts the Member count on the forum homepage to take account of Banned users.

Thanks,
Alan.

snowbird 06-19-2006 11:59 AM

Thank you, but I use 3.5.4 and it did not install :cry:
Quote:

Database error in vBulletin 3.5.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'Exclude Banned Users', 'forumhome_complete', '// Count the number of banned users\r\n$banned_count_q = \"SELECT count(userid) AS banned_count FROM \" . TABLE_PREFIX . \"userban\";\r\n$banned_count_a = $vbulletin->db->query_first($banned_count_q);\r\n\r\n// Update the totals\r\n$numbermembers = vb_number_format($vbulletin->userstats[\'numbermembers\'] - $banned_count_a[\'banned_count\']);', 'cit_exclude_banned_users');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Monday, June 19th 2006 @ 07:54:38 AM
Script : http://www.MYDOMAINDELETEDFORPRIVACY...ncp/plugin.php
Referrer :
IP Address : 24.50.113.222
Username : MYUSERNAMEDELETEDFORPRIVACY
Classname : vb_database

Alan @ CIT 06-19-2006 12:01 PM

To get it to install on 3.5.4, edit the XML file in the zip, and find "executionorder="5" and delete it :)

Save the XML, then try installing it agian.

Thanks,
ALan.

snowbird 06-19-2006 12:31 PM

This time it installed but it does not function properly. The number of members dropped by 36, which, probablbly not coincidently, is the sum of members in two seperate other non-banned usergroups. The hundreds of banned members still remain included in the total.

Alan @ CIT 06-19-2006 02:32 PM

It just counts all the rows from the "userban" table. How have to banned your members?

Thanks,
Alan.

snowbird 06-20-2006 11:43 AM

If you are asking how we ban members, we view their profile in the cp, we select Ban User from the Quick User Links, and that's where you select which banned usergroup they go into, when the ban is lifted, and the Reason to show the user, then click Ban User.

Alan @ CIT 06-20-2006 11:46 AM

ok, leave it with me, I'll adjust the the way it works so that it's based on banned usergroups, rather than the userban table.

Thanks,
Alan.

snowbird 06-28-2006 11:47 PM

Any progress on the adjustment?

snowbird 07-09-2006 03:11 PM

Guess that's a no. :(


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

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.01707 seconds
  • Memory Usage 1,725KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete