Hi again.
In functions.php, replace this huge thing:
Code:
// get last reply time
if ($postid) {
$dateline=$DB_site->query_first("SELECT dateline
FROM post
WHERE postid='$postid'");
$lastposttime=$DB_site->query_first("SELECT dateline
FROM post
WHERE threadid = '$threadid'
AND dateline < $dateline[dateline]
AND visible = 1
ORDER BY dateline DESC
LIMIT 1");
} else {
$lastposttime=$DB_site->query_first("SELECT dateline
FROM post
WHERE threadid='$threadid'
ORDER BY dateline DESC
LIMIT 1");
}
$useremails=$DB_site->query("SELECT user.*
FROM subscribethread,user
WHERE subscribethread.threadid='$threadid'
AND subscribethread.userid=user.userid
AND user.userid<>'$userid'
AND user.lastactivity>'$lastposttime[dateline]'");
with just this:
Code:
$useremails=$DB_site->query("SELECT user.*
FROM subscribethread,user
WHERE subscribethread.threadid='$threadid'
AND subscribethread.userid=user.userid
AND user.userid<>'$userid'");
that should be enough.