[PoetJA-1975]

Originally Posted by 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.

I'm not quite understanding those instructions...
the 2nd edit... How do you modify? And the last edit... What is the "profile field id number"?

Trying to get this to work for 3.6.4

Thanx

JAcquii.