need users move query...but how can I do that

[BadGuy]

Hi

I need to move all users have more than 300 posts from usergroupid 2 to usergroupid 12

Thanks

[Lats]

From the manual...

http://www.vbulletin.com/docs/html/usergroup_promotions

[BadGuy]

Hi

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 :

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')

But this by time not by how many posts .

any one can help ?