竹貓星球

代碼: 選擇全部

//
// Recent topic (only show normal topic)
//
$sql = 'SELECT topic_title, forum_id, topic_id
	FROM ' . TOPICS_TABLE . '
	WHERE topic_status <> ' . ITEM_MOVED . '
		AND topic_approved = 1 
		AND topic_type = ' . POST_NORMAL . '
		AND topic_moved_id = 0
		' . $sql_where . '
	ORDER BY topic_time DESC';

代碼: 選擇全部

//
// Recent topic (only show normal topic or sticky topic)
//
$sql = 'SELECT topic_title, forum_id, topic_id
	FROM ' . TOPICS_TABLE . '
	WHERE topic_status <> ' . ITEM_MOVED . '
		AND topic_approved = 1 
		AND ( topic_type = ' . POST_NORMAL . ' OR topic_type = ' . POST_STICKY . ' )
		AND topic_moved_id = 0
		' . $sql_where . '
	ORDER BY topic_time DESC';