Public Leaderboard |
Private Leaderboard | 資料新增
上傳頁
=COMPETITION201803_OPEN_DATETIME);
# https://stackoverflow.com/questions/7745609/sql-select-only-rows-with-max-value-on-a-column
$a = $wpdb->get_results('SELECT * FROM '.TBL_COMPETITION_UPLOAD.' ORDER BY '.$DISPLAY_SCORE.' ASC', ARRAY_A);
$ary_tr = array();
$ary_team_id_VS_score = array();
$ary_team_id_VS_uploadtimes = array();
$ary_team_id_VS_datetime = array();
foreach($a as$v){
if(!isset($ary_team_id_VS_score[$v['team_id']])){
$ary_team_id_VS_score[$v['team_id']] = true;
$ary_team_id_VS_uploadtimes[$v['team_id']] = 1;
$ary_team_id_VS_datetime[$v['team_id']] = array($v['create_datetime']);
$ary_tr[$v['team_id']] = $v;
}else{
$ary_team_id_VS_uploadtimes[$v['team_id']] += 1;
$ary_team_id_VS_datetime[$v['team_id']][] = $v['create_datetime'];
}
}
echo'
'.($IS_SHOW_TOP6 ? '| 名次 | ' : '').'隊伍名稱 |
提交次數 |
最佳分數(越低越佳) |
最近上傳時間 | '.($IS_SHOW_TOP6 ? '入圍複賽 | ' : '').($IS_SHOW_CSV_DOWNLOAD ? '下載csv | ' : '').'';
$i=1;
foreach($ary_tr as$team_id=>$tr){
?>
|
|
|
|
|
|
|
';
} ?>