Convert "Custom User Group" after import

[djbaxter]

vBulletin v 3.60
Clean import from SMF 1.1 RC2

Issue 1
The importer created a "custom user group" which I would like to convert to the standard "Registered User".

What would be the MySQL syntax for doing this via a database query?

Issue 2
I would like to set "Show signature" for all of the old imported posts. Can I also do that via and SQL query?

[djbaxter]

Excellent! Thank you!!

I must say that as a new vBulletin owner I am finding the support from this forum to be superb - not to mention FAST!! :D

[Jerry]

SQL is not the preferred method for moving the users from the default import group, don't do it.

As per the manual, delete the import created usergroup :

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

[djbaxter]

The previously posted (and now deleted) SQL method worked perfectly for me.

[Lats]

OMG! My first deleted post :(

[Jerry]

OMG! My first deleted post :(

Well what you posted was technically correct, though deleting the usergroup allows vBulletin to take care of any cleanup from mass moving users from an unwanted usergroup, also just keeping the consistency for advise to users.