<?php
if (!isset($_GET['path'])) $_GET['path'] = '';
if (!isset($_GET['sort'])) $_GET['sort'] = $cfg['defo_hyouji'];
$query = "SELECT * FROM $cfg[sqltb]cfg_reg WHERE name='Mbana_w' OR name='Mbana_h'";
$rowset = $db->rowset_num($query);
foreach ($rowset as $tmp) {
	$cfg_reg[$tmp[0]] = $tmp[1];
}
$cookie_data = get_cookie();
#データの読み込み＆下層カテゴリ表示
##データの読み込み
$time = time();
$start = $time - $cfg['rank_kikan'] * 86400;
$end = $time;
$navi = '';
if ($_GET['mode'] == "dir") { #各カテゴリの場合
	$query = "SELECT title, regist, comment FROM $cfg[sqltb]category WHERE path='$_GET[path]' LIMIT 1";
	$row = $db->single_assoc($query) or $db->error("Query failed $query".__FILE__.__LINE__);
	$title = $row['title'];
	$guide = $row['comment'];
	$regist = $row['regist'];
	switch($_GET['sort']) {
		case "id_new"  : $order = "id DESC"; break;
		case "id_old"  : $order = "id"; break;
		case "time_new": $order = "stamp DESC"; break;
		case "time_old": $order = "stamp"; break;
		case "ac_new"  : $order = "title"; break;
		case "ac_old"  : $order = "title DESC"; break;
		default: $order = "mark DESC, id DESC";
	}
	$search_id = $_GET['path']; #検索対象のカテゴリ番号
	$log_lines = array(); #表示データリスト
	$log_count = array(); #各カテゴリの登録数
	$st_no = $cfg['hyouji'] * ($_GET['page'] - 1);

	$query = "SELECT * FROM $cfg[sqltb]log WHERE category LIKE '%&$_GET[path]&%' ORDER BY $order";
	$rowset = $db->rowset_assoc_limit($query,$st_no,$cfg['hyouji']) or $db->error("Query failed $query".__FILE__.__LINE__);
	foreach ($rowset as $log_data) {
		if ($cookie_data[3]) { #adminモード
			$query = "SELECT count(*) FROM $cfg[sqltb]rank WHERE time BETWEEN $start AND $end AND id='$log_data[id]'";
			$count = $db->single_num($query) or $db->error("Query failed $query".__FILE__.__LINE__);
			$log_data['count'] = $count[0];
			$query = "SELECT rank,rev FROM $cfg[sqltb]rank_counter WHERE id='$log_data[id]'";
			$r_count = $db->single_assoc($query) or $db->error("Query failed $query".__FILE__.__LINE__);
			$log_data['count'] .= "_".$r_count['rank'];
			$query = "SELECT count(*) FROM $cfg[sqltb]rev WHERE time BETWEEN $start AND $end AND id='$log_data[id]'";
			$count = $db->single_num($query) or $db->error("Query failed $query".__FILE__.__LINE__);
			$log_data['count'] .= "_".$count[0];
			$log_data['count'] .= "_".$r_count['rev'];
		}
		array_push($log_lines,$log_data);
	}
	unset($rowset);
	$query = "SELECT count(*) FROM $cfg[sqltb]log WHERE category LIKE '%&$_GET[path]&%'";
	$num = $db->single_num($query) or $db->error("Query failed $query".__FILE__.__LINE__);
	$log_count[$search_id] = $num[0];
#ナビゲーションバーを表示
	$navi = navi_bar($_GET['path']);
}
else { #その他の特殊カテゴリ
	$title = $cfg["name_$_GET[mode]"];
	$guide = $cfg["$_GET[mode]_ys"];
	$log_lines = array(); #表示データリスト
	$search_id = $_GET['mode'];
	$st_no = $cfg['hyouji']*($_GET['page'] -1);
	if ($_GET['mode'] == 'new') {
		$ntime=time()-$cfg['new_time']*24*3600;
		$query = " stamp > $ntime AND renew = 0 ORDER BY mark DESC, id DESC";
	}
	elseif ($_GET['mode'] == 'renew') {
		$ntime = time() - $cfg['new_time']*24*3600;
		$query = " stamp > $ntime AND renew = 1 ORDER BY stamp DESC";
	}
	elseif ($_GET['mode'] == 'm1') $query = " mark LIKE '1%'";
	elseif ($_GET['mode'] == 'm2') $query = " mark LIKE '%1'";
	else {echo "STOP in ".__FILE__." line ".__LINE__; exit;}
	$query1 = "SELECT * FROM $cfg[sqltb]log WHERE".$query;
	$rowset = $db->rowset_assoc_limit($query1,$st_no,$cfg['hyouji']) or $db->error("Query failed $query".__FILE__.__LINE__);
	foreach ($rowset as $log_data){
		if ($cookie_data[3]) { #adminモード
			$query2 = "SELECT count(*) FROM $cfg[sqltb]rank WHERE time BETWEEN $start AND $end AND id='$log_data[id]'";
			$count = $db->single_num($query2) or $db->error("Query failed $query2".__FILE__.__LINE__);
			$log_data['count'] = $count[0];
			$query2 = "SELECT rank,rev FROM $cfg[sqltb]rank_counter WHERE id='$log_data[id]'";
			$r_count = $db->single_assoc($query2) or $db->error("Query failed $query2".__FILE__.__LINE__);
			$log_data['count'] .= "_".$r_count['rank'];
			$query2 = "SELECT count(*) FROM $cfg[sqltb]rev WHERE time BETWEEN $start AND $end AND id='$log_data[id]'";
			$count = $db->single_num($query2) or $db->error("Query failed $query2".__FILE__.__LINE__);
			$log_data['count'] .= "_".$count[0];
			$log_data['count'] .= "_".$r_count['rev'];
		}
		array_push($log_lines,$log_data);
	}
	$query3 = "SELECT count(*) FROM $cfg[sqltb]log WHERE".$query;
	$num = $db->single_num($query3) or $db->error("Query failed $query3".__FILE__.__LINE__);
	$log_count[$search_id] = $num[0];
}
if($_GET['mode'] == "new"){
	$total_url = $db->log_count("$cfg[sqltb]log") or $db->error("Query failed $query".__FILE__.__LINE__);
	$navi .= " - 現在の総登録数:<b>$total_url</b>サイト";
}
$arg = array($_GET['page'],$log_count[$search_id],$cfg['hyouji'],"&mode=$_GET[mode]&path=$_GET[path]&sort=$_GET[sort]",$cfg['script']);
$mokuji = mokuji($arg);
require "$cfg[temp_path]category.html";
$db->close();
exit;
?>