}
}
// 获取最近文章列表
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';
Example #2
0
        // 格式化内容
        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';