vb.org Archive - Help forming an SQL Query

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Help forming an SQL Query (https://vborg.vbsupport.ru/showthread.php?t=236218)

kronnos

02-18-2010 01:44 PM

Help forming an SQL Query

I had a few hundred subscribed members in primary usergroup but now want to change them all to secondary usergroup.

Basically, Im trying to form an sql query that would

Select all users with primary usergroup "A"
Then change that "A" to a "B" in the primary usergroup
Then add "A" to that users secondary group(some users have more then one secondary membership group)
And set the display group of all these users to "A"

A huge thanks in advance!

All times are GMT. The time now is 01:21 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01011 seconds Memory Usage 1,701KB 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 (1)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
Messages: