[dartho]

The following may be useful to someone...

// TURN OFF ALL EMAIL OPTIONS 
$adminemail=$vbulletin->bf_misc_useroptions['adminemail'];
$showemail=$vbulletin->bf_misc_useroptions['showemail'];
$emailonpm=$vbulletin->bf_misc_useroptions['emailonpm'];
$receivefriendemailrequest=$vbulletin->bf_misc_useroptions['receivefriendemailrequest'];
$vbulletin->db->query_write("UPDATE `user` SET `options` = `options` - $adminemail WHERE `user`.`userid` = $userid AND `user`.`options` & $adminemail");
$vbulletin->db->query_write("UPDATE `user` SET `options` = `options` - $showemail WHERE `user`.`userid` = $userid AND `user`.`options` & $showemail");
$vbulletin->db->query_write("UPDATE `user` SET `options` = `options` - $emailonpm WHERE `user`.`userid` = $userid AND `user`.`options` & $emailonpm");
$vbulletin->db->query_write("UPDATE `user` SET `options` = `options` - $receivefriendemailrequest WHERE `user`.`userid` = $userid AND `user`.`options` & $receivefriendemailrequest");
//TURN OFF MAIL SUBSCRIPTIONS 
$vbulletin->db->query_write("UPDATE `subscribethread` SET `emailupdate` = '0' WHERE `subscribethread`.`userid` = $userid;");
$vbulletin->db->query_write("UPDATE `subscribegroup` SET `emailupdate` = '0' WHERE `subscribegroup`.`userid` = $userid;");
$vbulletin->db->query_write("UPDATE `subscribeforum` SET `emailupdate` = '0' WHERE `subscribeforum`.`userid` = $userid;");
$vbulletin->db->query_write("UPDATE `subscribediscussion` SET `emailupdate` = '0' WHERE `subscribediscussion`.`userid` = $userid;");

https://vborg.vbsupport.ru/showthread.php?t=297249