![]() |
mySQL question
In my user table I have an added field called "donator". When the value equals 1 they are a donator (installed the basic donation hack). I now want to put these people in there own user group witch will be user group 12.
What would the mySQL quire be to alter the user group to 12 for all users that have a 1 in the donator field? I know it would start with something like: ALTER TABLE user WHERE donator=1 ......or somthing :) Thank you in advance for your help. |
[sql]UPDATE user SET usergroupid=12 WHERE donator=1 and usergroupid=2[/sql]
that will move all donating users from registred into 12 |
Thank you very much Xenon! :)
|
you're welcome
|
All times are GMT. The time now is 12:32 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 | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|