This section is an archive with no posting allowed. The software represented in this forum is no longer supported or updated. If you need help upgrading to a newer version of vBulletin please open a support ticket. You can also post in the section supporting the upgrade version you're planning to use.
We are sorry for any inconvenience this may cause.
Welcome to the vBulletin support forums! In our community forums you can receive professional support and assistance with any issues you might have with your vBulletin Products.
That way didn't help , my forum have 230,000 users and I have more than 12,000 users have more than 300 and by that way its moving 1 user by 1 and for long time and till now I just moved 250 users .
I need command to do it from mysql .
I found this one :
Code:
UPDATE user
SET usergroupid = 2
WHERE usergroupid = 3
AND joindate > UNIX_TIMESTAMP('2006-10-20 00:00:00')
AND joindate < UNIX_TIMESTAMP('2006-10-22 00:00:00')
Comment