= 3 order by rating desc, username asc limit 12;");
$hotusers = DB::selectAll("select username, rating, rating_rd, rating_vol, qq, motto from user_info order by rating_vol desc, username asc limit 12;");
$topblogs = DB::selectAll("select id from blogs order by zan desc limit 20;");
$songs_data = htmlspecialchars(json_encode(DB::selectAll("select * from songs;")), ENT_QUOTES, 'UTF-8');
// 最近比赛：未结束的按开始时间升序取，不足 5 场时补最近结束的
$recent_contests = array();
$result = DB::selectAll("select * from contests where status != 'finished' order by start_time asc, id asc limit 5");
foreach ($result as $contest) {
genMoreContestInfo($contest);
$recent_contests[] = $contest;
}
if (count($recent_contests) < 5) {
$need = 5 - count($recent_contests);
$result = DB::selectAll("select * from contests where status = 'finished' order by start_time desc, id desc limit $need");
foreach ($result as $contest) {
genMoreContestInfo($contest);
$recent_contests[] = $contest;
}
}
?>