'".$lastvisited."'
GROUP BY tp.post_id"
);
$rows = dbrows($result);
if ($rows) {
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
$result = dbquery(
"SELECT tp.forum_id, tp.thread_id, tp.post_id, tp.post_author, tp.post_datestamp,
tf.forum_name, tf.forum_access, tt.thread_subject, tu.user_id, tu.user_name
FROM ".DB_POSTS." tp
INNER JOIN ".DB_FORUMS." tf ON tp.forum_id = tf.forum_id
INNER JOIN ".DB_THREADS." tt ON tp.thread_id = tt.thread_id
LEFT JOIN ".DB_USERS." tu ON tp.post_author = tu.user_id
WHERE ".groupaccess('tf.forum_access')." AND tp.post_datestamp > '".$lastvisited."'
ORDER BY tp.post_datestamp DESC LIMIT ".$_GET['rowstart'].",20"
);
$i = 0;
echo "\n\n";
echo "| ".$locale['global_048']." | \n";
echo "".$locale['global_044']." | \n";
echo "".$locale['global_050']." | \n";
echo "
\n";
while ($data = dbarray($result)) {
if ($i % 2 == 0) { $row_color = "tbl1"; } else { $row_color = "tbl2"; }
echo "\n";
echo "| ".$data['forum_name']." | \n";
echo "".$data['thread_subject']." | \n";
echo "".$data['user_name']."
\n".showdate("forumdate",$data['post_datestamp'])." | \n";
echo "
\n";
$i++;
}
echo "\n| ".sprintf($locale['global_055'], $rows)." | \n
\n
\n";
} else {
echo "
".sprintf($locale['global_055'], $rows)."
\n";
}
closetable();
if ($rows > 20) { echo "\n".makepagenav($_GET['rowstart'], 20, $rows, 3)."\n
\n"; }
require_once THEMES."templates/footer.php";
?>