<?php
require_once(__DIR__ . "/common/mobile_redirect.php");
mobile_redirect("/ipn" . $_SERVER["REQUEST_URI"]);

//(2011/01/18 -修正-)ini_set("memory_limit", "256M");
session_start();
require_once(__DIR__ . "/adcgi/mod_ad.php");

UpdateAdTop(12); // トップ広告更新

//スタイルシート
if(strlen($_SESSION['ksn_this_tiho']) > 0 and $_SESSION['ksn_this_tiho'] != "zenkoku"){
	$tcss = $_SESSION['ksn_this_tiho'];
	$chiki_name = getTihoString($_SESSION['ksn_this_tiho']);
	$tiho_str = "area";
	$chiki_name2 = "chiki_table.chiiki='".getTihoString($_SESSION['ksn_this_tiho'])."' and ";
}else{
	$tcss = "zenkoku";
	$chiki_name = "全国";
	$tiho_str = "tiho";
	$chiki_name2 = "";
}

//ブログ最新の10件取得
require_once(__DIR__ . "/admin/mod_db.php");
require_once(__DIR__ . "/admin/mod_codes.php");
// DBオープン
$cn = openDB();
// [ ﾃﾞｰﾀ取得SQL ] --------------------------------------------------
$page  = ( isset( $_REQUEST['p'] ) ) ? $_REQUEST['p'] : 1;
$sql   = "";
$bdata = array();
$sql = $sql . "CREATE TEMPORARY TABLE tbl_temp ";
$sql = $sql . "SELECT ksn_ads.name              , ";
$sql = $sql .        "ksn_ads.area              , ";
$sql = $sql .        "ksn_ads.rank              , ";
$sql = $sql .        "ksn_ads.cate              , ";
$sql = $sql .        "ksn_ads.tiho				, ";
//$sql = $sql .        "ksn_blog_pro.P_BLOG_TITLE , ";
$sql = $sql .        "ksn_blog.B_ID             , ";
$sql = $sql .        "ksn_blog.DataNum          , ";
$sql = $sql .        "ksn_blog.B_TITLE          , ";
$sql = $sql .        "ksn_blog.B_BODY           , ";
$sql = $sql .        "ksn_blog.B_IMG            , ";
$sql = $sql .        "ksn_blog.B_DATE             ";
//$sql = $sql . " FROM  ( ( ksn_blog INNER JOIN ksn_blog_pro ON ksn_blog.DataNum = ksn_blog_pro.DataNum ) ";
$sql = $sql . " FROM  ( ksn_blog  ";
$sql = $sql . "         INNER JOIN ksn_ads ON ksn_blog.DataNum = ksn_ads.DataNum ) ";
//$sql = $sql . "         INNER JOIN chiki_table ON chiki_table.ads_id = ksn_ads.DataNum ";

if ( ( strlen($_SESSION['ksn_this_tiho']) > 0 ) and ( $_SESSION['ksn_this_tiho'] != "zenkoku" ) ) {
   //$sql = $sql . "WHERE chiki_table.chiiki = '" . getTihoString( $_SESSION['ksn_this_tiho'] ) . "' ";
   $sql = $sql . "WHERE ksn_ads.tiho       = '" . getTihoString( $_SESSION['ksn_this_tiho'] ) . "' ";
   $sql = $sql . "  AND ksn_ads.Horyu      = 0 ";
   $sql = $sql . "  AND ksn_blog.B_DRAFT   = 0 ";
} else {
   $sql = $sql . "WHERE ksn_ads.Horyu      = 0 ";
   $sql = $sql . "  AND ksn_blog.B_DRAFT   = 0 ";
}

//$sql = $sql . "GROUP BY ksn_blog.DataNum , ksn_blog.B_ID ";
$sql = $sql . "ORDER BY B_DATE DESC ";
if ( $page == 1 ) {
   $sql = $sql . "LIMIT 0 , 10 ";
} else {
   $sql = $sql . "LIMIT " . ( ($page * 10) - 10 ) . " , " . ( $page * 10 ) . " ";
}

$res = mysql_query( $sql , $cn ) or die( "data select error (1)" );

$sql = 'SELECT tbl_temp.*, ksn_blog_pro.P_BLOG_TITLE FROM tbl_temp INNER JOIN ksn_blog_pro ON tbl_temp.DataNum = ksn_blog_pro.DataNum';
$res = mysql_query( $sql , $cn ) or die( "data select error (1)" );

while( $row = mysql_fetch_array( $res , MYSQL_ASSOC ) ) {
		$sql = "select * from chiki_table where ads_id=" .$row["DataNum"]." order by id asc";
		$res_c = mysql_query($sql);
		$row_c = mysql_fetch_array($res_c);
		$row["chiki"] = $row_c["shiku"];
		$bdata[] = $row;
}
// [ 件数取得SQL ] --------------------------------------------------
$sql   = "";
$count = 0;
$sql   = $sql . "SELECT COUNT( B_ID ) AS cnt FROM ksn_blog WHERE ksn_blog.B_DRAFT = 0 ";
$res   = mysql_query( $sql , $cn ) or die( "data select error (2)" );
$row   = mysql_fetch_row( $res );
$count = $row[0] ;
// ------------------------------------------------------------------
//(2011/01/18 -修正-)[前SQL部分]
//(2011/01/18 -修正-)$sql = "select ksn_ads.name,ksn_blog_pro.P_BLOG_TITLE,ksn_blog.*,ksn_ads.area,ksn_ads.cate,ksn_ads.".$tiho_str." from ((ksn_blog INNER JOIN ksn_blog_pro on ksn_blog.DataNum=ksn_blog_pro.DataNum)INNER JOIN ksn_ads on ksn_blog.DataNum=ksn_ads.DataNum)INNER JOIN chiki_table ON chiki_table.ads_id=ksn_ads.DataNum where ".$chiki_name2."ksn_blog.B_DRAFT=0 and ksn_ads.Horyu<>1 group by ksn_blog.DataNum,ksn_blog.B_ID order by B_DATE DESC";
//(2011/01/18 -修正-)$res = mysql_query($sql, $cn) or die("data select error");
//(2011/01/18 -修正-)$bdata = array();
//(2011/01/18 -修正-)$count = 0;
//(2011/01/18 -修正-)if($res){
//(2011/01/18 -修正-)	while($row = mysql_fetch_array($res, MYSQL_ASSOC)){
//(2011/01/18 -修正-)		$bdata[] = $row;
//(2011/01/18 -修正-)		$count++;
//(2011/01/18 -修正-)	}
//(2011/01/18 -修正-)}
// DBクローズ
mysql_close($cn);
$prev_page=$page-1;
$next_page=$page+1;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ja" lang="ja">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="robots" content="INDEX,FOLLOW" />
<title><?=$chiki_name ?>店舗ブログ一覧 - 風俗求人・稼げるバイト探しは【高収入ドットコム】 p.<?=$page?></title>
<meta name="description" content="<?=$chiki_name ?>の風俗店店舗ブログです。スタッフが新鮮な風俗求人・高収入バイト情報を日々更新。ここでしか読めない稼げる求人情報が満載です。 p.<?=$page?>" />
<meta name="keywords" content="風俗求人,高収入,バイト,店舗,ブログ,<?=$chiki_name ?>" />

<link rel="canonical" href="<?=HTTP_ROOT_URL?>blog_list.html" />
<link rel="alternate" media="only screen and (max-width: 640px)" href="<?=HTTP_ROOT_URL?>ipn/blog_list.html">
<link href="<?=HTTP_ROOT_URL?>css/master.css" rel="stylesheet" type="text/css" />
<link href="<?=HTTP_ROOT_URL?>css/common.css" rel="stylesheet" type="text/css" />
<link href="<?=HTTP_ROOT_URL?>css/<?=$tcss ?>.css" rel="stylesheet" type="text/css" />
<link href="<?=HTTP_ROOT_URL?>css/top.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="<?=HTTP_ROOT_URL?>js/wrapscroll.js"></script>
<script type="text/javascript" src="<?=HTTP_ROOT_URL?>js/xmlhttp.js"></script>
<script type="text/javascript" src="<?=HTTP_ROOT_URL?>js/aj.js"></script>

<!--****** ランク6用CSS ******-->
<link rel="stylesheet" type="text/css" href="<?=HTTP_ROOT_URL?>css/_r6.css?<?=time(); ?>" />
<!--****** ランク6用CSS ******-->

<!--****** ランク6用にjQuery変更 ******-->
<script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
<!--****** ランク6用にjQuery変更 ******-->

<!--****** ランク6用スライダー ******-->
<link href="<?=HTTP_ROOT_URL?>js/jquery.bxslider.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="<?=HTTP_ROOT_URL?>js/jquery.bxslider.min.js" ></script>
<script type="text/javascript">
jQuery(function(){
  jQuery('#osusume_slider').bxSlider({
    mode: 'vertical',
    auto: true,
    controls: false,
    pager: false,
    minSlides:7,
    maxSlides:7,
    moveSlides:1,
    slideWidth:166
  });
});
</script>
<!--****** ランク6用スライダー ******-->
<? if($prev_page>0){ ?>
<link rel='prev' href='<?=HTTP_ROOT_URL?>blog_list.html?p=<?=$prev_page; ?>' />
<? } ?>
<? if($next_page<=($count/10)){ ?>
<link rel='next' href='<?=HTTP_ROOT_URL?>blog_list.html?p=<?=$next_page; ?>' />
<? } ?>

<script
src="https://code.jquery.com/jquery-3.4.1.js"
integrity="sha256-WpOohJOqMqqyKL9FccASB9O0KwACQJpFTUBLTYOVvVU="
crossorigin="anonymous"></script>
<meta property="og:type" content="website" >
<meta property="og:site_name" content="高収入ドットコム" >
<meta property="og:title" content="title">
<meta property="og:description" content="description">
<meta property="og:url" content="url">
<meta property="og:image" content="<?=HTTP_ROOT_URL ?>img/logo_kosyunyu.png">
<meta name="twitter:card" content="summary_large_image">
<script>
	$(function(){
		var title = $("title").html();
		var content = $("meta[name='description']").attr('content');
		var path = $(location).attr('pathname');
		var dir = path.slice( 1 ) ;
		$("meta[property='og:title']").attr('content', title);
		$("meta[property='og:description']").attr('content', content);
		$("meta[property='og:url']").attr('content', '<?=HTTP_ROOT_URL ?>' + dir);
	});
</script>
</head>
<body onload="loadHTMLFile('<?=HTTP_ROOT_URL ?>adcgi/aj_cook.php')">
<?
require_once(__DIR__ . "/gtm.html");
?>
<div id="wrapper" class="clearfix">
    <div id="container">
        <!--//ヘッダー//-->
        <div id="header">
            <h1><?=$chiki_name ?>店舗ブログ一覧 - 風俗求人・稼げるバイト探しは【高収入ドットコム】</h1>
            <div class="btn">
                <p class="btn_sitemap"><a href="<?=HTTP_ROOT_URL?>etc/sitemap.html"><img src="<?=HTTP_ROOT_URL?>img/common/btn/btn_sitemap.gif" alt="サイトマップ" /></a></p>
                <p class="btn_guide"><a href="<?=HTTP_ROOT_URL?>navi/guide/"><img src="<?=HTTP_ROOT_URL?>img/common/btn/btn_guide.gif" alt="はじめての方へ" /></a></p>
            </div>
            <p class="logo"><a href="<?=HTTP_ROOT_URL?>"><img src="<?=HTTP_ROOT_URL?>img/common/logo.jpg" alt="トップ" /></a></p>
            <div class="bnr">
            <!--++++++++++++++++++++++++ 広告枠(ランク2～6 150x50)　2件 ++++++++++++++++++++++++-->
            <?= GetContentsBanner() ?>
            <!--++++++++++++++++++++++++ /広告枠(ランク2～6 150x50)　2件/ ++++++++++++++++++++++++-->
            </div>
            <?php require_once(__DIR__ . "/navi.html"); ?>
        </div>
        <!--//ヘッダー//-->
        <p class="lead"><a href="<?=HTTP_ROOT_URL?>index.html">トップページ</a>&nbsp;&gt;&nbsp;<?=$chiki_name ?>版：お店ブログ日記一覧</p>
        <div id="main_osusume" class="clearfix">
            <div id="content" class="clearfix">
              <h2 class="ttl_blog2"><a href="<?=HTTP_ROOT_URL?>">お店ブログ一覧</a></h2>
<?php
// ------------------------------------------------------------------
$page = (isset($_REQUEST['p'])) ? $_REQUEST['p'] : 1;
if ( $page == 1 ) { $p_val = 0;
} else            { $p_val = ($page - 1) * 10;
}
//(2011/01/18 -修正-)for ( $i=$p_val; $i < ($p_val + 10); $i++ ) {
for ( $i=0; $i < 10; $i++ ) {
    if ( strlen($bdata[$i]["B_ID"]) > 0 ) {
       $day = array("日", "月", "火", "水", "木", "金", "土");
       //内容をタグをはずして表示
       $a = "/<.*?>/";$IMG_STR="";
       $NAIYO = preg_replace($a,"",stripslashes($bdata[$i]["B_BODY"]));
       if ( strlen($bdata[$i]["B_IMG"]) > 0 ) {
          $IMG_STR = "<a href=\"".HTTP_ROOT_URL."diary_detail.html?d=".$bdata[$i]['DataNum']."&b=".$bdata[$i]['B_ID']."\"><img src=\"".HTTP_ROOT_URL."bnr_img/bimg/".$bdata[$i]['B_IMG']."\" class=\"diary_ph_s\" /></a>";
       }
       $date_str = date("Y-m-d",strtotime($bdata[$i]["B_DATE"]))."(".$day[date("w", strtotime($bdata[$i]["B_DATE"]))].")".date("H:i",strtotime($bdata[$i]["B_DATE"]));
?>
                <div class="blogflame clearfix">
<?
if ($bdata[$i]["rank"] > 1) {
?>
                  <?=$IMG_STR ?>
<?
}
?>
                  <h3><?=htmlspecialchars($bdata[$i]["name"]) ?>&nbsp;&nbsp;「<?=$bdata[$i]["P_BLOG_TITLE"] ?>」</h3>
<?
if ($bdata[$i]["chiki"] == "") {
?>
                    <p class="area">[<?=htmlspecialchars($bdata[$i]["cate"]) ?>／<?=htmlspecialchars($bdata[$i]["tiho"]) ?>]</p>
<?
} else {
?>
                    <p class="area">[<?=htmlspecialchars($bdata[$i]["cate"]) ?>／<?=htmlspecialchars($bdata[$i]["chiki"]) ?>]</p>
<?
}
?>
                    <h4><a href="<?=HTTP_ROOT_URL?>diary_detail.html?d=<?=htmlspecialchars($bdata[$i]['DataNum']) ?>&b=<?=$bdata[$i]['B_ID'] ?>"><?=htmlspecialchars($bdata[$i]["B_TITLE"]) ?></a></h4>
                    <p style="word-break:break-all;"><?=mb_strimwidth($NAIYO, 0, 162, "･･･", "UTF-8") ?>（<a href="<?=HTTP_ROOT_URL?>diary_detail.html?d=<?=$bdata[$i]['DataNum'] ?>&b=<?=$bdata[$i]['B_ID'] ?>">続きを読む</a>）</p>
                    <p><?=$date_str ?></p>
                </div>
<?php
    }
}
// ------------------------------------------------------------------
?>

            <div id="page_number">
<?php
// ------------------------------------------------------------------
		$page_count = ceil($count / 10);
		if ($page > 1) {
			print "<a href=\"".HTTP_ROOT_URL."blog_list.html?p=".strval($page - 1)."\">&lt;前へ</a>&nbsp;";
			for ($i = 4; $i >= 1; $i--) {
				if ($page - $i >= 1) {
					print "<a href=\"".HTTP_ROOT_URL."blog_list.html?p=".strval($page - $i)."\">".strval($page - $i)."</a>&nbsp;";
				}
			}
		}
		print strval($page)."&nbsp;";
		if ($page < $page_count) {
			if($page < 5){$pp=10-$page;}else{$pp=5;}
			for ($i = 1; $i <= $pp; $i++) {
				if ($page + $i <= $page_count) {
					print "<a href=\"".HTTP_ROOT_URL."blog_list.html?p=".strval($page + $i)."\">".strval($page + $i)."</a>&nbsp;";
				}
			}
			print "<a href=\"".HTTP_ROOT_URL."blog_list.html?p=".strval($page + 1)."\">次へ&gt;</a>";
		}
// ------------------------------------------------------------------
?>
            </div>
		</div>
        <!--//メニュー//-->
        <?php require_once(__DIR__ . "/menu.html"); ?>
        <!--//メニュー//-->
        </div>

        <!--広告枠-->
        <div id="sub2">
            <h2>PICKUP高収入バイト</h2>

<!--****** ランク6用スライダー ******-->
<?
require_once(__DIR__."/r6_osusume.html");
?>
<!--****** ランク6用スライダー ******-->

        </div>
        <!--広告枠-->


        <!--//サブメニュー//-->
		<?php if ($tcss == "zenkoku") { ?>
        <?php require_once(__DIR__ . "/subnavi.html"); ?>
		<? } else { ?>
        <?php require_once(__DIR__ . "/subnavi_area.html"); ?>
		<? } ?>
        <!--//サブメニュー//-->

    </div>

<!--検討中BOX-->
	<?php require(__DIR__."/rightcol.html"); ?>
<!--検討中BOX-->
</div>

        <!--//フッター//-->
        <?php require_once(__DIR__ . "/footer.html"); ?>
        <!--//フッター//-->

</body>
</html>