<?

	require_once('include/header_set.php');
	require_once('include/func.php');
	
	$sql = "SELECT name, data FROM config WHERE page = 'admin_top.php'";
	$rs = mysql_query($sql,$con);
	while ($row = mysql_fetch_row($rs)) {
		$name = $row[0];
		$data = $row[1];
		$Smarty->assign($name, $data);
	}
	

	//ニュースの最新3件を検索して表示（top_flg = 0は除く）
	$sql = "SELECT * FROM news WHERE act_flg = 1 AND top_flg = 1 ORDER BY update_time DESC";
	$rs = mysql_query($sql,$con);
	$data = array();
	while ($row = mysql_fetch_row($rs)) {
		$data[] = $row;
	}
	$Smarty->assign("top_news_list",$data);
	
	
	//最新のゲームの節を検索して表示
	$sql = "SELECT * FROM seg WHERE finish_flg = 1 ORDER BY date DESC LIMIT 0,1";
	$rs = mysql_query($sql,$con);
	$row = mysql_fetch_row($rs);
	$seg_id = $row[0];
	$year = $row[2];
	$seg_name = $row[4];
	$Smarty->assign("top_scoreboard_subtitle",$seg_name);
	$game_list = array();
	$game_list = game_list('', $seg_id);
	$Smarty->assign("top_scoreboard_gamelist",$game_list);
	
	
	//ゲームIDからスコアを検索して表示
	$score_list = score_list($seg_id);
	$Smarty->assign("top_scoreboard_scorelist",$score_list);
	
	
	//順位表の出力
	$arr = array();
	$arr = season_ranking($year);
	$Smarty->assign("t_stats",$arr[0]);
	
	
	//近々のスケジュール
	//現在の日付以降のスケジュールを検索
	$today = date('Y-m-d');
	$sql = "
		SELECT id, ivent_date AS date, ivent_title, '' AS place, news_text, '' AS text, 'news' AS type FROM news WHERE act_flg = 1 AND cate_id = 8 AND ivent_date >= '$today'
		UNION
		SELECT id, date, CONCAT('メトロリーグ公式戦 ',name,'（',text,'）') AS ivent_title, stadium AS place, '' AS news_text, text, 'seg' AS type FROM seg WHERE date >= '$today'
		ORDER BY date
	";
	$rs = mysql_query($sql,$con);
	$data = array();
	$i = 0;
	while ($row = mysql_fetch_array($rs)) {
		$data[$i] = $row;
		if ($row['type'] == 'news') {
			$data[$i]['place'] = kiridashi($row['news_text'], '【場所：', '】');
			$data[$i]['time'] = kiridashi($row['news_text'], '【時間：', '】');
			$data[$i]['text'] = kiridashi($row['news_text'], '【備考：', '】');
		}
		$i++;
	}
	$Smarty->assign("top_schedule",$data);

 	//Smarty出力
	$title = "トップページ";
	$page = "index.html";
	$Smarty->assign("page_title",$title);
	$Smarty->assign("page",$page);
	
	$Smarty->display("parts/basic.html");


?>