Jump to the post that solved this thread.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 11 Years, 4 Months, 2 Weeks ago Need SQL help
#2
Solved: 11 Years, 4 Months, 2 Weeks ago
UPDATE `mybb_users` SET `usergroup` = 'B' WHERE `usergroup` = 'A' AND `postnum` >= '1' AND `regdate` > '1296906752';

This'll move people who registered in the last 24 hours. Change the A and B to the IDs of the relevant usergroups.

Also it'd probably be a lot easier to use the promotions system to change their usergroups, rather than doing it manually...
MyReactions - All Plugins

Can you still feel the butterflies?

Free never tasted like pudding.
Jump to the post that solved this thread.


Messages In This Thread
Need SQL help - by Disturbed - 2011-02-06, 11:00 AM
RE: Need SQL help - by Matt - 2011-02-06, 11:54 AM
RE: Need SQL help - by Disturbed - 2011-02-06, 02:12 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)