[SpankMe]

Remove the following line from the newpost_complete Quote Notification plugin as it's not needed.

PHP Code:

        $quotegetfieldquery = $vbulletin->db->query_first("SELECT profilefieldid FROM " . TABLE_PREFIX . "profilefield WHERE title='Quote Notification'"); 


and modify the following line...

PHP Code:

        $quoteuserquery = $vbulletin->db->query_first("SELECT user_table.userid AS userid, user_table.email AS email, profile_fields.field" . $quotegetfieldquery['profilefieldid'] . " AS wantquotenotify FROM " . TABLE_PREFIX . "user AS user_table LEFT JOIN " . TABLE_PREFIX . "userfield AS profile_fields ON (user_table.userid=profile_fields.userid) WHERE user_table.username='" . $vbulletin->db->escape_string($kr_load[$kr]) . "' GROUP BY user_table.userid"); 


replacing

PHP Code:

" . $quotegetfieldquery['profilefieldid'] . " 


with the Quote Notification profile field id number.