3 Star 9 Fork 2

BLumia / BLumiaOJ

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
克隆/下载
index.php 1.10 KB
一键复制 编辑 Web IDE 原始数据 按行查看 历史
BLumia 提交于 2017-04-17 01:22 . easter?
<?php
session_start();
//Vars
require_once('./include/setting_oj.inc.php');
//Prepares
$sql=$pdo->prepare(
"SELECT COUNT(*) , COUNT(1) , DATE(in_date) submit_time , result
FROM solution
WHERE in_date > DATE_ADD(NOW() , INTERVAL -7 DAY)
GROUP BY submit_time, result
ORDER BY in_date"
);
$sql->execute();
$weekyResult=$sql->fetchAll(PDO::FETCH_ASSOC);
$tableResult = null;
foreach($weekyResult as $row) {
$submit_time = $row['submit_time'];
$tableResult[$submit_time]['date'] = $submit_time;
if(!isset($tableResult[$submit_time]['count'])) $tableResult[$submit_time]['count'] = 0;
if(!isset($tableResult[$submit_time]['4'])) $tableResult[$submit_time]['4'] = 0;
if(!isset($tableResult[$submit_time]['6'])) $tableResult[$submit_time]['6'] = 0;
else {
$tableResult[$submit_time]['count'] += $row['COUNT(*)'];
}
$tableResult[$submit_time][$row['result']] = $row['COUNT(*)'];
}
if (isset($_GET['night'])) {
$expireData = intval($_GET['night']) == 1 ? time()+4*7*24*3600 : time()-61;
setcookie("night","true",$expireData);
}
//Page Includes
require("./pages/index.php");
?>
PHP
1
https://gitee.com/blumia/BLumiaOJ.git
git@gitee.com:blumia/BLumiaOJ.git
blumia
BLumiaOJ
BLumiaOJ
master

搜索帮助

14c37bed 8189591 565d56ea 8189591