The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
help with a query
Well...I have many strong points...
mysql queries and coding are not one of them (yet) I need help making a query that I can run... What I'm trying to do is take all the users in my forum that have an email address whatever@specificdomain.com and move them to a certain usergroup can anyone help me out with this |
#2
|
|||
|
|||
Untested, so backup...
Code:
# replace vb3_ with your vB table prefix # replace X with the new usergroup id # replace @domain.com with the email UPDATE vb3_user SET displaygroupid = IF(displaygroupid = usergroupid, 0, displaygroupid), usergroupid = X WHERE email LIKE '%@domain.com'; |
#3
|
||||
|
||||
worked perfectly, thanks
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|