[calorie]

Do not use " ," to separate lines. Do like this:

$vbulletin->db->query_write("
	UPDATE " . TABLE_PREFIX . "user
	SET usergroupid = 105, displaygroupid = 105
	WHERE usergroupid = 2
	AND email NOT LIKE '%gmail%' AND email NOT LIKE '%hotmail%' AND email NOT LIKE '%rediffmail%'
	AND email NOT LIKE '%yahoo%' AND email NOT LIKE '%msn.com%' AND email NOT LIKE '%web.de%'
	AND email NOT LIKE '%rediffmail%' AND email NOT LIKE '%google%' AND email NOT LIKE '%@mail.com%'
	AND email NOT LIKE '%excite.com%' AND email NOT LIKE '%@mail.ru%' AND email NOT LIKE '%yandex%'
	AND email NOT LIKE '%free.fr%' AND email NOT LIKE '%t-online.de%' AND email NOT LIKE '%web2mail.com%'
	AND email NOT LIKE '%rocketmail.com%' AND email NOT LIKE '%pookmail.com%' AND email NOT LIKE '%@email.com%'
	AND email NOT LIKE '%webmail%' AND email NOT LIKE '%mindspring%' AND email NOT LIKE '%earthlink%'
	AND email NOT LIKE '%pandora.be%' AND email NOT LIKE '%mail.bg%' AND email NOT LIKE '%swing.be%'
	AND email NOT LIKE '%inbox%' AND email NOT LIKE '%ifrance.com%' AND email NOT LIKE '%free.hu%'
	AND email NOT LIKE '%@elvis.com%' AND email NOT LIKE '%eudora%' AND email NOT LIKE '%go2net%'
	AND email NOT LIKE '%flashmail%' AND email NOT LIKE '%@la.com%' AND email NOT LIKE '%lycos%'
	AND email NOT LIKE '%muslim%' AND email NOT LIKE '%netscape%'  AND email NOT LIKE '%@themail.com%'
	AND email NOT LIKE '%@usa.com%' AND email NOT LIKE '%india-11.com%' AND email NOT LIKE '%123india%'
	AND email NOT LIKE '%ifrance.com%' AND email NOT LIKE '%@india.com%' AND email NOT LIKE '%indiatimes.com%'
	AND email NOT LIKE '%mailnova%' AND email NOT LIKE '%chequemail.com%' AND email NOT LIKE '%mail2india%'
	AND email NOT LIKE '%netcrawler%' AND email NOT LIKE '%@paki.com%' AND email NOT LIKE '%pakistanmail%'
	AND email NOT LIKE '%helloasia%' AND email NOT LIKE '%virtualindia%' AND email NOT LIKE '%grabmail%'
	AND email NOT LIKE '%@mailru.com%' AND email NOT LIKE '%chat.ru%' AND email NOT LIKE '%@mail.md%'
	AND email NOT LIKE '%@tut.by%' AND email NOT LIKE '%@abv.bg%' AND email NOT LIKE '%@all.bg%'
	AND email NOT LIKE '%searcheurope%' AND email NOT LIKE '%email.co.yu%' AND email NOT LIKE '%newmail.net%'
	AND email NOT LIKE '%@mail.%' AND email NOT LIKE '%iobox.fi%' AND email NOT LIKE '%spray.no%'
	AND email NOT LIKE '%altavista%' AND email NOT LIKE '%a-topmail%' AND email NOT LIKE '%everymail%'
	AND email NOT LIKE '%belgique%' AND email NOT LIKE '%3xl.net%' AND email NOT LIKE '%francemail%'
	AND email NOT LIKE '%france-mail%' AND email NOT LIKE '%laposte.net%' AND email NOT LIKE '%lemonde.fr%'
	AND email NOT LIKE '%axis.org%' AND email NOT LIKE '%mymail%' AND email NOT LIKE '%163.com%'
	AND email NOT LIKE '%gmx.de%' AND email NOT LIKE '%freesurf%' AND email NOT LIKE '%casino%'
");

You might try something like this instead. Tweak as needed:

$vbulletin->db->query_write("
	UPDATE " . TABLE_PREFIX . "user
	SET usergroupid = 105, displaygroupid = 105
	WHERE usergroupid = 2
	AND SUBSTRING_INDEX(email, '@', -1) NOT IN
		(
			'163.com','3xl.net','abv.bg','all.bg','axis.org','chat.ru','chequemail.com','elvis.com',
			'email.co.yu','email.com','excite.com','free.fr','free.hu','gmx.de','ifrance.com','india.com',
			'india-11.com','indiatimes.com','iobox.fi','la.com','laposte.net','lemonde.fr','mail.bg',
			'mail.com','mail.md','mail.ru','mailru.com','msn.com','newmail.net','paki.com','pandora.be',
			'pookmail.com','rocketmail.com','spray.no','swing.be','t-online.de','themail.com','tut.by',
			'usa.com','web.de','web2mail.com'
		)
	AND SUBSTRING_INDEX(SUBSTRING_INDEX(email, '@', -1), '.', 1) NOT IN
		(
			'123india','a-topmail','altavista','belgique','casino','earthlink','eudora','everymail',
			'flashmail','france-mail','francemail','freesurf','gmail','go2net','google','grabmail',
			'helloasia','hotmail','inbox','lycos','mail','mail2india','mailnova','mindspring','muslim',
			'mymail','netcrawler','netscape','pakistanmail','rediffmail','searcheurope','virtualindia',
			'webmail','yahoo','yandex'
		)
");

Though you may wish to consider something like this:

$vbulletin->db->query_write("
	UPDATE " . TABLE_PREFIX . "user
	SET usergroupid = 105, displaygroupid = 105
	WHERE usergroupid = 2
	AND SUBSTRING_INDEX(email, '@', -1) NOT IN
		(
			SELECT banemail FROM banemails
		)
");

Where the table banemails contains foo.com entries.