Yomi-Search(PHP)';
$db = new db($cfg['db_host'], $cfg['db_user'], $cfg['db_password'], $cfg['db_database']);
$query = "SELECT * FROM ".$cfg['sqltb']."cfg";
$rowset = $db->rowset_num($query);
foreach ($rowset as $tmp) {
$cfg[$tmp[0]] = $tmp[1];
}
$query = "SELECT * FROM ".$cfg['sqltb']."text";
$rowset = $db->rowset_num($query);
foreach ($rowset as $tmp) {
$text[$tmp[0]] = $tmp[1];
}
#データの読み込み＆下層カテゴリ表示
if (isset($_GET['mode']) and $_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__);
$row['title'] = mb_convert_kana($row['title'], "ak", "EUC-JP");
$title = mb_convert_encoding($row['title'], "SJIS", "EUC-JP");
$row['comment'] = mb_convert_kana($row['comment'], "ak", "EUC-JP");
$guide = mb_convert_encoding($row['comment'], "SJIS", "EUC-JP");
$log_lines = array(); #表示データリスト
if (empty($_GET['page'])) $_GET['page'] = 1;
$st_no = $cfg['hyouji'] * ($_GET['page'] - 1);
$query = "SELECT * FROM $cfg[sqltb]log WHERE category LIKE '%&$_GET[path]&%' ORDER BY id DESC";
$log_lines = $db->rowset_assoc_limit($query,$st_no,$cfg['hyouji']) or $db->error("Query failed $query".__FILE__.__LINE__);
$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__);
#ナビゲーションバーを作成
$navi = '';
$navi_id = explode("/", substr($_GET['path'], 0, -1));
array_pop($navi_id);
$path = "";
foreach ($navi_id as $tmp) {
$path .= "$tmp/";
$query = "SELECT title FROM $cfg[sqltb]category WHERE path='$path'";
$row = $db->single_assoc($query) or $db->error("Query failed $query".__FILE__.__LINE__);
$row['title'] = mb_convert_kana($row['title'], "ak", "EUC-JP");
$row['title'] = mb_convert_encoding($row['title'], "SJIS", "EUC-JP");
$navi .= "$row[title] > ";
}
#目次を作成
$url = "i.php";
$bf_page = $_GET['page'] - 1;
$af_page = $_GET['page'] + 1;
$bf_url = "$url?page=";
$af_url = "&mode=$_GET[mode]&path=$_GET[path]";
$end_no = $_GET['page'] * $cfg['hyouji'];
$st_no = $end_no - $cfg['hyouji'] +1;
if ($end_no >= $num[0]){
$end_no=$num[0];
}
$max_page = (int)($num[0] / $cfg['hyouji']);
if ($num[0] % $cfg['hyouji']){
$max_page++;
}
$mokuji =" $st_no - $end_no ( $num[0] 件中 ) ";
if ($num[0] > $cfg['hyouji']){ #目次作成
$mokuji .= "[ ";
if ($_GET['page'] > 1){
$mokuji .= "←前ページ ";
}
$mokuji .= "/ ";
#make <=
$max_page_f = (int)($max_page / 10);
if ($max_page % 10){
$max_page_a = 1;
} else {
$max_page_a = 0;
}
$pre_page_f = (int)($_GET['page'] / 10);
if ($_GET['page'] % 10){
$pre_page_a = 1;
} else {
$pre_page_a = 0;
}
if ($max_page > 10 and $_GET['page'] > 10 and $pre_page_f > 0){
$j = $pre_page_f * 10 - 19 + $pre_page_a * 10;
$mokuji .= "<= ";
}
if ($pre_page_a){
$hyouji_page_st = $pre_page_f * 10 + 1;
}
else {
$hyouji_page_st = $pre_page_f * 10 - 9;
}
$hyouji_page_end = $hyouji_page_st + 9;
for ($i=1; $i <= $max_page; $i++){
if ($hyouji_page_end < $i){
break;
}
if ($hyouji_page_st <= $i){
if ($i != $_GET['page']){
$j = $i;
$mokuji .= "$i ";
}
else {
$mokuji .= "$i ";
}
}
}
#make =>
if ($max_page_f - ($pre_page_f + $pre_page_a - 1) != 1 or $max_page_a){
if ($max_page > 10 and $max_page > $_GET['page'] and $max_page_f > ($pre_page_f + $pre_page_a - 1)){
$j = $pre_page_f * 10 + 1 + $pre_page_a * 10;
$mokuji .= "=> ";
}
}
$mokuji .= "/ ";
if ($_GET['page'] < $max_page){
$mokuji .= "次ページ→ ";
}
$mokuji .="]";
}
?>
<?=$title?>
ﾎｰﾑ >
single_num($query) or $db->error("Query failed $query".__FILE__.__LINE__);
$query = "SELECT title, path FROM $cfg[sqltb]category WHERE up_id='$id[0]' ORDER BY path";
$rowset = $db->rowset_assoc($query) or $db->error("Query failed $query".__FILE__.__LINE__);
foreach ($rowset as $row) {
$query = "SELECT COUNT(*) FROM $cfg[sqltb]log WHERE category LIKE '%&$row[path]%'";
$num = $db->single_num($query) or $db->error("Query failed $query".__FILE__.__LINE__);
$query = "SELECT id FROM $cfg[sqltb]category WHERE path LIKE '$row[path]_%'";
$sub = $db->single_num($query) or $db->error("Query failed $query".__FILE__.__LINE__);
$row['title'] = mb_convert_kana($row['title'], "ak", "EUC-JP");
$row['title'] = mb_convert_encoding($row['title'], "SJIS", "EUC-JP");
echo " ■$row[title]";
if($sub[0]) echo "*";
echo "";
if($count_flag) echo"($num[0])";
echo "
";
}
$query = "SELECT title, path FROM $cfg[sqltb]category WHERE reffer LIKE '%&$id[0]&%' ORDER BY path";
$rowset = $db->rowset_assoc($query) or $db->error("Query failed $query".__FILE__.__LINE__);
foreach ($rowset as $row) {
$id = substr($row['path'], 0, -1);
$query = "SELECT COUNT(*) FROM $cfg[sqltb]log WHERE category LIKE '%&$id%'";
$num = $db->single_num($query) or $db->error("Query failed $query".__FILE__.__LINE__);
$query = "SELECT id FROM $cfg[sqltb]category WHERE path LIKE '${id}_%'";
$sub = $db->single_num($query) or $db->error("Query failed $query".__FILE__.__LINE__);
$row['title'] = mb_convert_kana($row['title'], "ak", "EUC-JP");
$row['title'] = mb_convert_encoding($row['title'], "SJIS", "EUC-JP");
echo " ■$row[title]@";
if($count_flag) echo"($num[0])";
echo "
";
}
}
if($log_lines){
echo "
$mokuji";
foreach ($log_lines as $log_data){
$log_data['title'] = mb_convert_kana($log_data['title'], "ak", "EUC-JP");
$log_data['title'] = mb_convert_encoding($log_data['title'], "SJIS", "EUC-JP");
$log_data['message'] = mb_convert_kana($log_data['message'], "ak", "EUC-JP");
$log_data['message'] = mb_convert_encoding($log_data['message'], "SJIS", "EUC-JP");
$jump_url = $log_data['url'];
$jump_url = urlencode($jump_url);
if($cfg['rank_fl']){
$jump_url = "$cfg[rank]?mode=link&id=$log_data[id]&url=$jump_url";
}
?>
-
$mokuji";
}
echo "
$cr";
$db->close();
exit;
}
?>
<?=$cfg['search_name']?>
ﾎｰﾑ
rowset_assoc($query) or $db->error("Query failed $query".__FILE__.__LINE__);
foreach($top_category as $row){
$row['path'] = mb_convert_encoding($row['path'], "SJIS", "EUC-JP");
$row['title'] = mb_convert_kana($row['title'], "ak", "EUC-JP");
$row['title'] = mb_convert_encoding($row['title'], "SJIS", "EUC-JP");
?>
rowset_assoc($query) or $db->error("Query failed $query".__FILE__.__LINE__);
foreach ($sub_category as $row){
if($row['top_list']){
$sublist_flag = 1;
$row['path'] = mb_convert_encoding($row['path'], "SJIS", "EUC-JP");
$row['title'] = mb_convert_kana($row['title'], "ak", "EUC-JP");
$row['title'] = mb_convert_encoding($row['title'], "SJIS", "EUC-JP");
echo "$row[title],";
}
}
if($sublist_flag) {
echo "‥";
}
}
?>
close();
exit;
?>
