[dodgy]

05-11-03 at 08:33 AM Crazy Pete said this in Post #62
Yep, I just tried it again. Replaced the whole email_notify template with just "TESTTESTTESTTESTTESTTEST" and its still sending me the default template when someone replies to a thread. ??

yep.. found the prob. 2.3 needs to query style as well. try this one:

  $fieldid = 5; // ID of the email password field in the user's profile
  $useremails=$DB_site->query("SELECT user.*, style.templatesetid, userfield.field$fieldid
                               FROM subscribethread,user,userfield,usergroup
                               LEFT JOIN style ON (IF(user.styleid=0, 1, user.styleid)=style.styleid)
                               WHERE subscribethread.threadid='$threadid'
                                 AND subscribethread.userid=user.userid
                                 AND userfield.userid=user.userid

subject line is missing tho