= 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 10;");
$songs_data = htmlspecialchars(json_encode(DB::selectAll("select * from songs;")), ENT_QUOTES, 'UTF-8');
// 服务器数据看板
$today_submit_num = DB::selectCount("select count(*) from submissions where date(submit_time) = date(now())");
$today_ac_num = DB::selectCount("select count(*) from submissions where date(submit_time) = date(now()) and score = 100");
$month_submit_num = DB::selectCount("select count(*) from submissions where year(submit_time) = year(now()) and month(submit_time) = month(now())");
$month_ac_num = DB::selectCount("select count(*) from submissions where year(submit_time) = year(now()) and month(submit_time) = month(now()) and score = 100");
$total_submit_num = DB::selectCount("select count(*) from submissions");
$total_ac_num = DB::selectCount("select count(*) from submissions where score = 100");
$total_problem_num = DB::selectCount("select count(*) from problems where is_hidden = 0");
$total_user_num = DB::selectCount("select count(*) from user_info");
// 最近比赛：未结束的按开始时间升序取，不足 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;
}
}
?>