0) $Stitle .= " (下層カテゴリデータ表示中)";
} else {
$kt_sql = "&".$_GET[kt]."&";
}
if(!$_GET[sort]){
$order="mark DESC, id DESC"; #デフォルトの読み込み方法
} else {
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;
case "rating": $order = "rating DESC"; break;
case "vote": $order = "votes DESC"; break;
case "comment": $order = "comments DESC"; break;
default: $order="mark DESC, id DESC";
}
}
$Ssearch_kt=$_GET[kt]; #検索対象のカテゴリ番号
$log_lines=array(); #表示データリスト
$Clog=array(); #各カテゴリの登録数
$st_no=$EST[hyouji]*($_GET[page] -1);
$query = "SELECT category FROM $EST[sqltb]log WHERE category LIKE '%&$_GET[kt]%';";
//$query = "SELECT category FROM $EST[sqltb]log WHERE category LIKE '%&$Spre_kt_file%';";
$result = $xoopsDB->query($query) or die("Query failed");
while ($line = mysql_fetch_row($result)) {
$tmp = explode("&", $line[0]);
foreach($tmp as $tmp2) {
$Clog[$tmp2]++;
}
$Clog['_ALL_']++;
}
if ($EST['kt_child_show']) $Clog[$Ssearch_kt] = $Clog['_ALL_'];
$query = "SELECT * FROM $EST[sqltb]log WHERE category LIKE '%$kt_sql%' ORDER BY $order LIMIT $st_no, $EST[hyouji];";
$result = $xoopsDB->query($query) or die("Query failed");
while ($Slog = mysql_fetch_row($result)) {
if($CK_data[3] || $is_admin == 1) {
$query="SELECT COUNT(*) FROM $EST[sqltb]rank WHERE time BETWEEN $start AND $end AND id='$Slog[0]'";
$result2 = $xoopsDB->query($query) or die("Query failed kt40 $query");
$count=mysql_fetch_row($result2);
$Slog[count] = "${EST[rank_kikan]}日(${count[0]})";
$query="SELECT COUNT(*) FROM $EST[sqltb]rank WHERE id='$Slog[0]'";
$result2 = $xoopsDB->query($query) or die("Query failed kt44 $query");
$count=mysql_fetch_row($result2);
$Slog[count] .= "_"."総(${count[0]})";
$query="SELECT COUNT(*) FROM $EST[sqltb]rev WHERE time BETWEEN $start AND $end AND id='$Slog[0]'";
$result2 = $xoopsDB->query($query) or die("Query failed kt48 $query");
$count=mysql_fetch_row($result2);
$Slog[count] .= ":逆リンク "."${EST[rank_kikan]}日(${count[0]})";
$query="SELECT COUNT(*) FROM $EST[sqltb]rev WHERE id='$Slog[0]'";
$result2 = $xoopsDB->query($query) or die("Query failed kt52 $query");
$count=mysql_fetch_row($result2);
$Slog[count] .= "_"."総(${count[0]})";
}
array_push($log_lines,$Slog);
}
}
else{ #その他の特殊カテゴリ
$Stitle=$EST["name_$_GET[mode]"];
$log_lines=array(); #表示データリスト
$Ssearch_kt=$Spre_kt_file;
$st_no=$EST[hyouji]*($_GET[page] -1);
if($_GET[mode] == 'new') {
$ntime=time()-$EST[new_time]*24*3600;
//$query = " stamp > $ntime AND renew = 0 ORDER BY mark DESC, id DESC";
$query = " build_time > $ntime ORDER BY build_time DESC";
} elseif($_GET[mode] == 'renew') {
$ntime=time()-$EST[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 temp.php in 245"; exit;}
$query1="SELECT * FROM $EST[sqltb]log WHERE".$query." LIMIT $st_no, $EST[hyouji]";
$result = $xoopsDB->query($query1) or die("Query failed kt110 $query");
while($Slog = mysql_fetch_row($result)){
if($CK_data[3] || $is_admin == 1) {
$query2="SELECT COUNT(*) FROM $EST[sqltb]rank WHERE time BETWEEN $start AND $end AND id='$Slog[0]'";
$result2 = $xoopsDB->query($query2) or die("Query failed kt40 $query");
$count=mysql_fetch_row($result2);
$Slog[count] = "${EST[rank_kikan]}日(${count[0]})";
$query2="SELECT COUNT(*) FROM $EST[sqltb]rank WHERE id='$Slog[0]'";
$result2 = $xoopsDB->query($query2) or die("Query failed kt44 $query");
$count=mysql_fetch_row($result2);
$Slog[count] .= "_"."総(${count[0]})";
$query2="SELECT COUNT(*) FROM $EST[sqltb]rev WHERE time BETWEEN $start AND $end AND id='$Slog[0]'";
$result2 = $xoopsDB->query($query2) or die("Query failed kt48 $query");
$count=mysql_fetch_row($result2);
$Slog[count] .= ":逆リンク "."${EST[rank_kikan]}日(${count[0]})";
$query2="SELECT COUNT(*) FROM $EST[sqltb]rev WHERE id='$Slog[0]'";
$result2 = $xoopsDB->query($query2) or die("Query failed kt52 $query");
$count=mysql_fetch_row($result2);
$Slog[count] .= "_"."総(${count[0]})";
}
array_push($log_lines,$Slog);
}
$query3="SELECT COUNT(*) FROM $EST[sqltb]log WHERE".$query;
$result = $xoopsDB->query($query3) or die("Query failed kt115 $query");
$num = mysql_fetch_row($result);
$Clog[$Ssearch_kt]=$num[0];
}
#ナビゲーションバーを表示
$kt=explode("_",$_GET[kt]); array_pop($kt);
foreach ($kt as $tmp){
$temp_kt .= $tmp;
$navi .= "$ganes[$temp_kt] > ";
$temp_kt .="_";
}
if($_GET[mode] == "new"){
$query = "SELECT COUNT(*) FROM $EST[sqltb]log";
$result = $xoopsDB->query($query) or die("Query failed yomi43 $query");
$total_url = mysql_fetch_row($result);
$navi .= " - 現在の総登録数:$total_url[0]サイト";
}
##ページ説明を表示
gane_guide();
if($_GET[mode] == "kt"){$guide = $KTEX[$_GET[kt]];}
else{$guide = $KTEX[$Spre_kt_file];}
unset($KTEX);
?>
=YOMI_HOME_URL?> > =$navi?>
=$guide?>
人気ランキング ';}
if($EST[rank_fl] && $EST[rev_fl]){echo " - ";}
if($EST[rev_fl]){echo ' アクセスランキング ';}
}
if($_GET[mode] == "kt"){
?>
下層カテゴリはデータは表示しない。";
} else {
echo "下層カテゴリデータも表示する。";
}
}
}
?>