Quote from: Jeff Lewis on April 22, 2002, 02:56:41 PMFrom post.php, post the few lines before 744.
$subject,$threadid,$txt,$cgi,$db_prefix,$realemail,$doLimitOne,$username;
$request = mysql_query("SELECT notifies FROM {$db_prefix}topics WHERE (ID_TOPIC=$threadid && notifies!='') LIMIT 1");
if (mysql_num_rows($request) != 0)
{
$row = mysql_fetch_row($request);
$members = mysql_query("SELECT emailAddress, notifyOnce, memberName FROM {$db_prefix}members WHERE ID_MEMBER IN ($row[0]) && emailAddress!='' && memberName!='$username'");
while ($rowmember = mysql_fetch_array($members)) {
$send_subject=$txt[127].": ".$subject;
if ($rowmember['notifyOnce'] == 1) {
$request = mysql_query("SELECT notificationSent FROM {$db_prefix}log_topics WHERE memberName='$rowmember[memberName]' && ID_TOPIC=$threadid $doLimitOne");
if (mysql_num_rows($request) == 0)
$notificationSent = 0;
else
list($notificationSent) =