vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Bulk update only certain users (https://vborg.vbsupport.ru/showthread.php?t=293212)

Gregg Lengling 12-22-2012 08:03 PM

Bulk update only certain users
 
I have a forum with over 25k members but now have a dedicated section for those that are paying for support. At this time I need to update 2400 members for access to those limited forums. Is there way to run a script pulling the registration email address associated with their registration to add the flag to the additional User Group I created for them???

kh99 12-22-2012 08:39 PM

I'm not quite sure what you're asking: is it that you have a list of email addresses, and you want to move those users to a different group? Is it a new main user group or an additional group?

Gregg Lengling 12-22-2012 10:02 PM

Yes I have set up an additional group that has privs for the new area, and I have a spread sheet that I can pull either user names or email addresses from . I want to find a way to enable that additional group for all these users without having to do them 1 at a time.

kh99 12-23-2012 12:25 AM

Well, I don't know of any way to do it with vbulletin. But if you imported your data into a table in the same database as vbulletin, then I'm pretty sure it could be done with sql. The membergroupid field in the user table is a comma separated list of ids, so it would take a bit of work there (I guess you'd need to add a comma or not depending on whether the user already has any additional member groups). Also if adding the group would affect the user's display group or ranks, then there's other updating that needs to be done to have everything consistent (if not, then I think just setting the field should be OK).


All times are GMT. The time now is 09:49 AM.

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.00989 seconds
  • Memory Usage 1,708KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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