if ($settings['thread_notify']) { $result = dbquery( "SELECT tn.*, tu.user_id,user_name,user_email FROM ".DB_THREAD_NOTIFY." tn LEFT JOIN ".DB_USERS." tu ON tn.notify_user=tu.user_id WHERE thread_id='".$thread_id."' AND notify_user!='".$userdata['user_id']."' AND notify_status='1' "); if (dbrows($result)) { require_once INCLUDES."sendmail_include.php"; $data2 = dbarray(dbquery("SELECT thread_subject FROM ".DB_THREADS." WHERE thread_id='".$thread_id."'")); $post = dbarray(dbquery("SELECT post_id FROM ".DB_POSTS." WHERE thread_id='".$thread_id."' AND post_author='".$userdata['user_id']."' ORDER BY post_datestamp DESC LIMIT 1")); $link = $settings['siteurl']."forum/viewthread.php?forum_id=".$forum_id."&thread_id=".$thread_id."&pid=".$post['post_id']."#post_".$post['post_id']; while ($data = dbarray($result)) { $message_el1 = array("{USERNAME}", "{THREAD_SUBJECT}", "{THREAD_URL}"); $message_el2 = array($data['user_name'], $data2['thread_subject'], $link); $message_subject = str_replace("{THREAD_SUBJECT}", $data2['thread_subject'], $locale['550']); $message_content = str_replace($message_el1, $message_el2, $locale['551']); echo $message_subject; sendemail($data['user_name'],$data['user_email'],123,$settings['siteemail'],$message_subject,$message_content); } $result = dbquery("UPDATE ".DB_THREAD_NOTIFY." SET notify_status='0' WHERE thread_id='".$thread_id."' AND notify_user!='".$userdata['user_id']."'"); } }