[squidsk]

Originally Posted by John Lester

Thanks for replying squid I changed the ON clause and still have a parse error

    // If you selected to change existing thread subscriptions this code will be executed
    if ($vbulletin->options['advanced_unsubscribe_link_existing_thread_sub'])
       {
         // Sets existing thread subscriptions to through control panel only
         $db->query{"
                   UPDATE " .TABLE_PREFIX. "subscribethread
                   LEFT JOIN " .TABLE_PREFIX. "user AS user ON (subscribethread.userid = user.email)
                   SET emailupdate = 0
                   WHERE emailupdate IN (1,2,3)
                   AND userid = $id
                   AND email= '" . $db->escape_string($email) . "'");
       }

Tried using this as well and get a parse error.

(user.email = subscribethread.userid)

If I comment out the block of code the mod works fine.

Shouldn't the ON block be:

ON user.userid = subscribethread.userid

You can't compare an email to a userid.