عرض اخر عشر مواضيع
last10
v.4
$last_thread[title] (اخر
مشاركة : $last_thread[lastposter] - عددالردود : $last_thread[replycount] - عددالزوار : $last_thread[views] ) » ]]>
last10_threads_by_cresttal
global_start
query_read("
SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid
$delquery
FROM " . TABLE_PREFIX . "thread AS thread
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.username = thread.lastposter)
$deljoin
WHERE thread.forumid NOT IN ($excludedforums)
$delthreadlimit
ORDER BY thread.lastpost DESC LIMIT 0, $displayrecords");
while ($last_thread = $db->fetch_array($last_threads))
{
$last_thread[title] = unhtmlspecialchars($last_thread[title]);
if (strlen($last_thread[title]) > $threadchars)
{
$last_thread[titletrimmed] = substr($last_thread[title], 0, strrpos(substr($last_thread[title], 0, $threadchars), ' ')) . '...';
}
eval('$last10_threads .= "' . fetch_template('last10_thread') . '";');
}]]>