[RichieBoy67]

Originally Posted by Dave

It's a matter of changing the email column to an empty string:

PHP Code:

UPDATE `user` SET `usergroupid`= x, `email` = '' WHERE `email` LIKE '%.xmail.com' 


When you create a new user in the ACP of vBulletin and don't enter an email, vBulletin will do the same and set it to an empty string.

yeah, I tried this early but it would not work for me though I could have had it wrong. Thanks much

--------------- Added 10 Dec 2014 at 14:12 ---------------

Originally Posted by ForceHSS

tested that myself as I had a feeling it would not work
after you have changed usergroupid try this
UPDATE `user` SET `email`='' WHERE `usergroupid`= x

That makes sense to do them separately.

Thanks guys!!