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); ?>

>

> [More] [New Window]
 
[他のカテゴリ] [サイトマップ] [ヘルプ] [修正・削除] [このカテゴリに新規登録]

人気ランキング ';} if($EST[rank_fl] && $EST[rev_fl]){echo " - ";} if($EST[rev_fl]){echo ' アクセスランキング ';} } if($_GET[mode] == "kt"){ ?>
[現在の表示: "; if(!$_GET[sort]){ switch ($EST[defo_hyouji]) { case "time_new": echo "更新日の新しい順"; break; case "id_new": echo "登録日の新しい順"; break; case "ac_new": echo "アイウエオ順(昇順)"; break; case "ac_old": echo "アイウエオ順(降順)"; break; case "id_old": echo "登録日の古い順"; break; case "time_old": echo "更新日の古い順"; break; case "comment": echo "コメントの多い順"; break; case "rating": echo "評価の高い順"; break; case "vote": echo "投票の多い順"; break; default: echo "マーク順"; } } else { switch ($_GET[sort]) { case "time_new": echo "更新日の新しい順"; break; case "id_new": echo "登録日の新しい順"; break; case "ac_new": echo "アイウエオ順(昇順)"; break; case "ac_old": echo "アイウエオ順(降順)"; break; case "id_old": echo "登録日の古い順"; break; case "time_old": echo "更新日の古い順"; break; case "comment": echo "コメントの多い順"; break; case "rating": echo "評価の高い順"; break; case "vote": echo "投票の多い順"; break; default: echo "マーク順"; } } ?> ] 下層カテゴリデータは表示しない。"; } else { echo "下層カテゴリデータも表示する。"; } } ?>
です。 この色の文は管理人のコメントです。
※リンク先が無くなっている等の問題がある場合にはタイトル横の [管理者に通知] リンクを押してください

下層カテゴリはデータは表示しない。"; } else { echo "下層カテゴリデータも表示する。"; } } } ?>