<?php
require_once( '../system/libs/smarty.inc' );
require_once( '../system/libs/Class_DB.php' );

if( !isset( $_GET['id'] ) || !is_numeric( $_GET['id'] ) ){
	header("Location: ../");
	exit;
}

$id = $_GET['id'];

$db = new Class_DB;

if( isset($_SERVER['HTTP_REFERER']) && strstr( $_SERVER['HTTP_REFERER'], '/web-admin/' ) ){
	$sql = "SELECT * FROM D_RESULT WHERE id = $id AND category = 2";
}else{
	$sql = "SELECT * FROM D_RESULT WHERE id = $id AND category = 2 AND status = '1' AND (st_time IS NULL OR st_time < CURRENT_TIMESTAMP ) AND (ed_time IS NULL OR ed_time > CURRENT_TIMESTAMP)";
}
$db->query( $sql );
if( $db->num_rows() ){
	$data = $db->fetch();
}else{
	header("Location: ../");
	exit;
}


// 年リスト
$db->query( "SELECT DISTINCT year FROM D_RESULT WHERE status = '1' AND category = 2 AND 
(st_time IS NULL OR st_time < CURRENT_TIMESTAMP ) AND 
(ed_time IS NULL OR ed_time > CURRENT_TIMESTAMP) ORDER BY date1 DESC");
$yearlist = array();
while( $row = $db->fetch() ){
	$yearlist[] = $row['year'];
}

$smarty->assign('year', $year );
$smarty->assign('yearlist', $yearlist );
$smarty->assign('data', $data );
$smarty->display('floor_tournament/detail.html');
?>