[Help Needed] Moving Certain Users to a new Usergroup

[Lats]

Try this query...

UPDATE
    user
SET
    usergroupid = X
WHERE
    posts < 10

Change X to your "less than 10" usergroupid.

Check the docs for usergroup promotions...

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