} } // 获取最近文章列表 if ($page == 0) { $page = 1; } $query_sql = "SELECT a.id,a.cid,a.uid,a.ruid,a.title,a.addtime,a.edittime,a.comments,c.name as cname,u.avatar as uavatar,u.name as author,ru.name as rauthor\r\n FROM `yunbbs_articles` a \r\n LEFT JOIN `yunbbs_categories` c ON c.id=a.cid\r\n LEFT JOIN `yunbbs_users` u ON a.uid=u.id\r\n LEFT JOIN `yunbbs_users` ru ON a.ruid=ru.id\r\n ORDER BY `edittime` DESC LIMIT " . ($page - 1) * $options['list_shownum'] . "," . $options['list_shownum']; $query = $DBS->query($query_sql); $articledb = array(); while ($article = $DBS->fetch_array($query)) { // 格式化内容 $article['addtime'] = showtime($article['addtime']); $article['edittime'] = showtime($article['edittime']); $articledb[] = $article; } unset($article); $DBS->free_result($query); // 页面变量 $title = $options['name'] . ' - page ' . $page; $site_infos = get_site_infos(); $newest_nodes = get_newest_nodes(); if (count($newest_nodes) == $options['newest_node_num']) { $bot_nodes = get_bot_nodes(); } $show_sider_ad = "1"; $links = get_links(); if ($options['site_des']) { $meta_des = htmlspecialchars(mb_substr($options['site_des'], 0, 150, 'utf-8')) . ' - page ' . $page; } $pagefile = dirname(__FILE__) . '/templates/default/' . $tpl . 'indexpage.php'; include dirname(__FILE__) . '/templates/default/' . $tpl . 'layout.php';
// 格式化内容 if ($article['isred'] == '1' && $article['top'] == '1') { $article['title'] = "<span class=\"label label-warning\">置顶</span><span class=\"label label-success\">推荐</span>" . $article['title']; } elseif ($article['isred'] == '1') { $article['title'] = "<span class=\"label label-success\">推荐</span>" . $article['title']; } elseif ($article['top'] == '1') { $article['title'] = "<span class=\"label label-warning\">置顶</span>" . $article['title']; } //$article['addtime'] = showtime($article['addtime']); //$article['edittime'] = showtime($article['edittime']); $articledb[] = $article; } unset($article); $DBS->free_result($query); // set to cache $cache->set('home_articledb', $articledb); } // 页面变量 $title = $options['name']; $site_infos = get_site_infos($DBS); $newest_nodes = get_newest_nodes(); if (count($newest_nodes) == $options['newest_node_num']) { $bot_nodes = get_bot_nodes(); } $links = get_links(); $meta_kws = htmlspecialchars(mb_substr($options['name'], 0, 6, 'utf-8')); if ($options['site_des']) { $meta_des = htmlspecialchars(mb_substr($options['site_des'], 0, 150, 'utf-8')); } $pagefile = CURRENT_DIR . '/templates/default/' . $tpl . 'home.php'; include CURRENT_DIR . '/templates/default/' . $tpl . 'layout.php';