=current_date AND $sql = "SELECT * FROM shop,area WHERE (area.area_matome_id=7 OR area.area_matome_id2=7 OR area.area_matome_id3=7) AND shop.shop_area=area.area_id AND shop.shop_publish=1 AND shop.shop_course>9 ORDER BY shop.upper_update DESC"; $rst = mysqli_query($con,$sql); if(!$sql){ print("SQLの実行に失敗しました。 "); exit; } $size = mysqli_num_rows($rst); //////////　まとめエリア読み込み　////////// $matome_sql = "SELECT * FROM matome WHERE matome_id =7"; $matome_result = mysqli_query($con,$matome_sql); if(!$matome_sql){ print("SQLの実行に失敗しました。 "); exit; } while($matome_data = mysqli_fetch_array($matome_result)){ $matome_id = $matome_data["matome_id"]; $matome_pref = $matome_data["matome_pref"]; $matome_pref_jp = pref_jp($matome_pref); $matome_pref_en = pref_en($matome_pref); $matome_name_en = $matome_data["matome_name_en"]; $matome_name_jp = $matome_data["matome_name_jp"]; } //////////　スマホページへリダイレクト　////////// $redirect = <<< TAGSET TAGSET; $title = "{$matome_name_jp} ｜ 【セクシーズ】 大阪セクキャバ・ツーショットキャバクラ情報"; $keywords = ""; $description = ""; include("../temp.php"); echo ${'head_'.$matome_pref_en}; echo ${'header_'.$matome_pref_en}; ?>
のお店情報　　件ヒットしました！
10 AND shop.shop_publish = 1 AND girl.waiting= 1 AND girl.girl_sort > 0 AND (girl.sun ='".$date."' OR girl.sun_check = 1) AND girl.sun_start<'".$nowtime."' AND girl.sun_end>'".$nowtime."' ORDER BY girl.sun_start, girl.sun_end LIMIT 5"; $girl_result = mysqli_query($con,$girl_sql); if(!$girl_sql){ print("SQLの実行に失敗しました。 "); exit; } $waiting_girls_rst = mysqli_num_rows($girl_result ); break; case 1: //-------//テーブル読み込み//-------// $girl_sql = "SELECT * FROM girl, shop WHERE shop.shop_id=girl.girl_shop_id AND shop.shop_area = AND shop.shop_pref= AND shop.shop_course>10 AND shop.shop_publish = 1 AND girl.waiting= 1 AND girl.girl_sort > 0 AND (girl.mon ='".$date."' OR girl.mon_check = 1) AND girl.mon_start<'".$nowtime."' AND girl.mon_end>'".$nowtime."' ORDER BY girl.mon_start, girl.mon_end LIMIT 5"; $girl_result = mysqli_query($con,$girl_sql); if(!$girl_sql){ print("SQLの実行に失敗しました。 "); exit; } $waiting_girls_rst = mysqli_num_rows($girl_result ); break; case 2: //-------//テーブル読み込み//-------// $girl_sql = "SELECT * FROM girl, shop WHERE shop.shop_id=girl.girl_shop_id AND shop.shop_area = AND shop.shop_pref= AND shop.shop_course>10 AND shop.shop_publish = 1 AND girl.waiting= 1 AND girl.girl_sort > 0 AND (girl.tue ='".$date."' OR girl.tue_check = 1) AND girl.tue_start<'".$nowtime."' AND girl.tue_end>'".$nowtime."' ORDER BY girl.tue_start, girl.tue_end LIMIT 5"; $girl_result = mysqli_query($con,$girl_sql); if(!$girl_sql){ print("SQLの実行に失敗しました。 "); exit; } $waiting_girls_rst = mysqli_num_rows($girl_result ); break; case 3: //-------//テーブル読み込み//-------// $girl_sql = "SELECT * FROM girl, shop WHERE shop.shop_id=girl.girl_shop_id AND shop.shop_area = AND shop.shop_pref= AND shop.shop_course>10 AND shop.shop_publish = 1 AND girl.waiting= 1 AND girl.girl_sort > 0 AND (girl.wed ='".$date."' OR girl.wed_check = 1) AND girl.wed_start<'".$nowtime."' AND girl.wed_end>'".$nowtime."' ORDER BY girl.wed_start, girl.wed_end LIMIT 5"; $girl_result = mysqli_query($con,$girl_sql); if(!$girl_sql){ print("SQLの実行に失敗しました。 "); exit; } $waiting_girls_rst = mysqli_num_rows($girl_result ); break; case 4: //-------//テーブル読み込み//-------// $girl_sql = "SELECT * FROM girl, shop WHERE shop.shop_id=girl.girl_shop_id AND shop.shop_area = AND shop.shop_pref= AND shop.shop_course>10 AND shop.shop_publish = 1 AND girl.waiting= 1 AND girl.girl_sort > 0 AND (girl.thu ='".$date."' OR girl.thu_check = 1) AND girl.thu_start<'".$nowtime."' AND girl.thu_end>'".$nowtime."' ORDER BY girl.thu_start, girl.thu_end LIMIT 5"; $girl_result = mysqli_query($con,$girl_sql); if(!$girl_sql){ print("SQLの実行に失敗しました。 "); exit; } $waiting_girls_rst = mysqli_num_rows($girl_result ); break; case 5: //-------//テーブル読み込み//-------// $girl_sql = "SELECT * FROM girl, shop WHERE shop.shop_id=girl.girl_shop_id AND shop.shop_area = AND shop.shop_pref= AND shop.shop_course>10 AND shop.shop_publish = 1 AND girl.waiting= 1 AND girl.girl_sort > 0 AND (girl.fri ='".$date."' OR girl.fri_check = 1) AND girl.fri_start<'".$nowtime."' AND girl.fri_end>'".$nowtime."' ORDER BY girl.fri_start, girl.fri_end LIMIT 5"; $girl_result = mysqli_query($con,$girl_sql); if(!$girl_sql){ print("SQLの実行に失敗しました。 "); exit; } $waiting_girls_rst = mysqli_num_rows($girl_result ); break; case 6: //-------//テーブル読み込み//-------// $girl_sql = "SELECT * FROM girl, shop WHERE shop.shop_id=girl.girl_shop_id AND shop.shop_area = AND shop.shop_pref= AND shop.shop_course>10 AND shop.shop_publish = 1 AND girl.waiting= 1 AND girl.girl_sort > 0 AND (girl.sat ='".$date."' OR girl.sat_check = 1) AND girl.sat_start<'".$nowtime."' AND girl.sat_end>'".$nowtime."' ORDER BY girl.sat_start, girl.sat_end LIMIT 5"; $girl_result = mysqli_query($con,$girl_sql); if(!$girl_sql){ print("SQLの実行に失敗しました。 "); exit; } $waiting_girls_rst = mysqli_num_rows($girl_result ); break; } } } if(!$waiting_girls_rst=="0") { echo <<< SET {$girl_name} （ {$age}歳 ）
SET; if ($sc_start == "未定") { echo "時間{$sc_start}
"; } elseif ($sc_start == "要TEL確認" or $sc_start == "休") { echo "{$sc_start}
"; } else { echo "{$sc_start}～{$sc_end24}
"; } echo <<< SET
{$area_name_jp}
SET; } echo <<< SET
▲今すぐ遊べる女の子--> SET; } $max_1p="10"; //ページング処理 $page = $_REQUEST['page']; if ($page == '') { $page = 1; } $page = max($page, 1); // 最終ページを取得する //----------//テーブル読み込み//--------// $maxPage = ceil($size / $max_1p); $page = min($page, $maxPage); $start = ($page - 1) * $max_1p; $recordSet = mysqli_query($con,"SELECT * FROM shop,area WHERE (area.area_matome_id=7 OR area.area_matome_id2=7 OR area.area_matome_id3=7) AND shop.shop_area=area.area_id AND shop.shop_publish=1 AND shop.shop_course>9 ORDER BY shop.shop_course DESC, shop.upper_update DESC LIMIT $start,$max_1p"); //------------------------------------// while($data = mysqli_fetch_array($recordSet)){ $shop_id = $data["shop_id"]; $shop_rank = $data["shop_rank"]; $shop_course = $data["shop_course"]; $shop_name = $data["shop_name"]; $shop_code = $data["shop_code"]; $shop_pref = $data["shop_pref"]; $shop_pref_jp = pref_jp($shop_pref); $shop_pref_en = pref_en($shop_pref); $shop_area = $data["shop_area"]; $shop_subarea_1 = $data["shop_subarea_1"]; $shop_subarea_2 = $data["shop_subarea_2"]; $shop_addr= $data["shop_addr"]; $shop_time = $data["shop_time"]; $shop_tel = $data["shop_tel"]; $shop_pr = $data["shop_pr"]; $shop_costume = $data["shop_costume"]; $shop_1pr = $data["shop_1pr"]; $shop_1pr_sp = $data["shop_1pr_sp"]; $shop_gyosyu = $data["shop_gyosyu"]; $shop_gyosyu_name = gyosyu_name($shop_gyosyu); $shop_access = $data["shop_access"]; $feature_set = $data["feature_set"]; $pr_plate = $data["pr_plate"]; $pr_plate_num = $data["pr_plate_num"]; $nyukin = $data["nyukin"]; $shop_update = $data["shop_update"]; $shop_main_img = $data["shop_main_img"]; $shop_main_img_sp = $data["shop_main_img_sp"]; $spri_url = $data["spri_url"]; $spri_url_sp = $data["spri_url_sp"]; //////////　エリア読み込み　////////// $area_sql = "SELECT * FROM area WHERE area_id ='".$shop_area."'"; $area_result = mysqli_query($con,$area_sql); if(!$area_sql){ print("SQLの実行に失敗しました。 "); exit; } while($area_data = mysqli_fetch_array($area_result)){ $area_id = $area_data["area_id"]; $area_name_en = $area_data["area_name_en"]; $area_name_jp = $area_data["area_name_jp"]; } //////////衣装名読み込み////////// $costume_sql = "SELECT * FROM costume WHERE costume_pref ='".$shop_pref."' AND costume_id ='".$shop_costume."'"; $costume_result = mysqli_query($con,$costume_sql); if(!$costume_sql){ print("SQLの実行に失敗しました。 "); exit; } //-----------------------------------// while($costume_data = mysqli_fetch_array($costume_result)){ $costume_id = $costume_data["costume_id"]; $costume_pref = $costume_data["costume_pref"]; $costume_pref_jp = pref_jp($costume_pref); $costume_name_en = $costume_data["costume_name_en"]; $costume_name_jp = $costume_data["costume_name_jp"]; } //////////　VIPコース　////////// if($shop_course=="30"){ if($spri_url ) { $spri_banner = <<< TAGSET TAGSET; } else { $spri_banner = ""; } $body.= <<< SET
{$shop_name}
{$spri_banner}
ジャンル : {$shop_gyosyu_name} / {$costume_name_jp}
店舗住所 : {$shop_addr}
地域区分 : {$area_name_jp}
営業時間 : {$shop_time}
電話番号 : {$shop_tel}
SET; //////////　女の子読み込み　////////// $girl_img_sql = "SELECT * FROM girl WHERE girl_shop_id ='".$shop_id."' AND girl_sort > 0 ORDER BY girl_sort LIMIT 3"; $girl_img_result = mysqli_query($con,$girl_img_sql); if(!$girl_img_sql){ print("SQLの実行に失敗しました。 "); exit; } while($girl_img_data = mysqli_fetch_array($girl_img_result)){ $girl_id = $girl_img_data["girl_id"]; $girl_name = $girl_img_data["girl_name"]; $size_b = $girl_img_data["size_b"]; $cup = $girl_img_data["cup"]; $size_w = $girl_img_data["size_w"]; $size_h = $girl_img_data["size_h"]; $size_t = $girl_img_data["size_t"]; $age = $girl_img_data["age"]; $blood = $girl_img_data["blood"]; $main_p = $girl_img_data["main_p"]; $newface = $gir_img_data["newface"]; $rank = $girl_img_data["rank"]; $in_year = $girl_img_data["in_year"]; $in_month = $girl_img_data["in_month"]; $in_day = $girl_img_data["in_day"]; $girl_sort = $girl_img_data["girl_sort"]; if (! $main_p == 0) { $body.= <<< SET
$shop_name｜$girl_name

{$girl_name}

SET; } else { $body.= <<< SET
$shop_name｜$girl_name

{$girl_name}

SET; } } $body.= <<< SET
{$shop_1pr}
SET; for ($w=0; $w<7; $w++){ if($date == $sc_day[$w]){ switch ($sc_week[$w]) { case 0: //////////　この店舗の今すぐ遊べる女の子読み込み・日曜日　////////// $girl_sql = "SELECT * FROM girl WHERE girl_shop_id =$shop_id AND waiting= 1 AND girl_sort > 0 AND (sun ='".$date."' OR sun_check = 1) AND girl.sun_start<'".$nowtime."' AND girl.sun_end>'".$nowtime."' ORDER BY sun_start, sun_end"; $girl_result = mysqli_query($con,$girl_sql); if(!$girl_sql){ print("SQLの実行に失敗しました。 "); exit; } $waiting_girls_rst = mysqli_num_rows($girl_result ); break; case 1: //////////　この店舗の今すぐ遊べる女の子読み込み・月曜日　////////// $girl_sql = "SELECT * FROM girl WHERE girl_shop_id =$shop_id AND waiting= 1 AND girl_sort > 0 AND (mon ='".$date."' OR mon_check = 1) AND girl.mon_start<'".$nowtime."' AND girl.mon_end>'".$nowtime."' ORDER BY mon_start, mon_end"; $girl_result = mysqli_query($con,$girl_sql); if(!$girl_sql){ print("SQLの実行に失敗しました。 "); exit; } $waiting_girls_rst = mysqli_num_rows($girl_result ); break; case 2: //////////　この店舗の今すぐ遊べる女の子読み込み・火曜日　////////// $girl_sql = "SELECT * FROM girl WHERE girl_shop_id =$shop_id AND waiting= 1 AND girl_sort > 0 AND (tue ='".$date."' OR tue_check = 1) AND girl.tue_start<'".$nowtime."' AND girl.tue_end>'".$nowtime."' ORDER BY tue_start, tue_end"; $girl_result = mysqli_query($con,$girl_sql); if(!$girl_sql){ print("SQLの実行に失敗しました。 "); exit; } $waiting_girls_rst = mysqli_num_rows($girl_result ); break; case 3: //////////　この店舗の今すぐ遊べる女の子読み込み・水曜日　////////// $girl_sql = "SELECT * FROM girl WHERE girl_shop_id =$shop_id AND waiting= 1 AND girl_sort > 0 AND (wed ='".$date."' OR wed_check = 1) AND girl.wed_start<'".$nowtime."' AND girl.wed_end>'".$nowtime."' ORDER BY wed_start, wed_end"; $girl_result = mysqli_query($con,$girl_sql); if(!$girl_sql){ print("SQLの実行に失敗しました。 "); exit; } $waiting_girls_rst = mysqli_num_rows($girl_result ); break; case 4: //////////　この店舗の今すぐ遊べる女の子読み込み・木曜日　////////// $girl_sql = "SELECT * FROM girl WHERE girl_shop_id =$shop_id AND waiting= 1 AND girl_sort > 0 AND (thu ='".$date."' OR thu_check = 1) AND girl.thu_start<'".$nowtime."' AND girl.thu_end>'".$nowtime."' ORDER BY thu_start, thu_end"; $girl_result = mysqli_query($con,$girl_sql); if(!$girl_sql){ print("SQLの実行に失敗しました。 "); exit; } $waiting_girls_rst = mysqli_num_rows($girl_result ); break; case 5: //////////　この店舗の今すぐ遊べる女の子読み込み・金曜日　////////// $girl_sql = "SELECT * FROM girl WHERE girl_shop_id =$shop_id AND waiting= 1 AND girl_sort > 0 AND (fri ='".$date."' OR fri_check = 1) AND girl.fri_start<'".$nowtime."' AND girl.fri_end>'".$nowtime."' ORDER BY fri_start, fri_end"; $girl_result = mysqli_query($con,$girl_sql); if(!$girl_sql){ print("SQLの実行に失敗しました。 "); exit; } $waiting_girls_rst = mysqli_num_rows($girl_result ); break; case 6: //////////　この店舗の今すぐ遊べる女の子読み込み・土曜日　////////// $girl_sql = "SELECT * FROM girl WHERE girl_shop_id =$shop_id AND waiting= 1 AND girl_sort > 0 AND (sat ='".$date."' OR sat_check = 1) AND girl.sat_start<'".$nowtime."' AND girl.sat_end>'".$nowtime."' ORDER BY sat_start, sat_end"; $girl_result = mysqli_query($con,$girl_sql); if(!$girl_sql){ print("SQLの実行に失敗しました。 "); exit; } $waiting_girls_rst = mysqli_num_rows($girl_result ); break; } } } if($waiting_girls_rst){ $body.= <<< SET
すぐに遊べる女の子：$waiting_girls_rst人
SET; } else { $body.= <<< SET
SET; } } //////////　標準掲載コース　////////// elseif($shop_course=="20"){ if($spri_url) { $spri_banner = <<< TAGSET TAGSET; } else { $spri_banner = ""; } $body.= <<< SET
{$shop_name}
SET; //////////　女の子読み込み　////////// $girl_img_sql = "SELECT * FROM girl WHERE girl_shop_id ='".$shop_id."' AND girl_sort > 0 ORDER BY girl_sort LIMIT 1"; $girl_img_result = mysqli_query($con,$girl_img_sql); if(!$girl_img_sql){ print("SQLの実行に失敗しました。 "); exit; } while($girl_img_data = mysqli_fetch_array($girl_img_result)){ $girl_id = $girl_img_data["girl_id"]; $girl_name = $girl_img_data["girl_name"]; $size_b = $girl_img_data["size_b"]; $cup = $girl_img_data["cup"]; $size_w = $girl_img_data["size_w"]; $size_h = $girl_img_data["size_h"]; $size_t = $girl_img_data["size_t"]; $age = $girl_img_data["age"]; $blood = $girl_img_data["blood"]; $main_p = $girl_img_data["main_p"]; $girl_sort = $girl_img_data["girl_sort"]; if (! $main_p == 0) { $body.= <<< SET
$shop_name｜$girl_name

{$girl_name}

SET; } else { $body.= <<< SET
$shop_name｜$girl_name

{$girl_name}

SET; } } $body.= <<< SET
ジャンル : {$shop_gyosyu_name}
衣装種別 : {$costume_name_jp}
営業時間 : {$shop_time}
電話番号 : {$shop_tel}
{$shop_addr}
このお店を見る
SET; for ($w=0; $w<7; $w++){ if($date == $sc_day[$w]){ switch ($sc_week[$w]) { case 0: //////////　この店舗の今すぐ遊べる女の子読み込み・日曜日　////////// $girl_sql = "SELECT * FROM girl WHERE girl_shop_id =$shop_id AND waiting= 1 AND girl_sort > 0 AND (sun ='".$date."' OR sun_check = 1) AND girl.sun_start<'".$nowtime."' AND girl.sun_end>'".$nowtime."' ORDER BY sun_start, sun_end"; $girl_result = mysqli_query($con,$girl_sql); if(!$girl_sql){ print("SQLの実行に失敗しました。 "); exit; } $waiting_girls_rst = mysqli_num_rows($girl_result ); break; case 1: //////////　この店舗の今すぐ遊べる女の子読み込み・月曜日　////////// $girl_sql = "SELECT * FROM girl WHERE girl_shop_id =$shop_id AND waiting= 1 AND girl_sort > 0 AND (mon ='".$date."' OR mon_check = 1) AND girl.mon_start<'".$nowtime."' AND girl.mon_end>'".$nowtime."' ORDER BY mon_start, mon_end"; $girl_result = mysqli_query($con,$girl_sql); if(!$girl_sql){ print("SQLの実行に失敗しました。 "); exit; } $waiting_girls_rst = mysqli_num_rows($girl_result ); break; case 2: //////////　この店舗の今すぐ遊べる女の子読み込み・火曜日　////////// $girl_sql = "SELECT * FROM girl WHERE girl_shop_id =$shop_id AND waiting= 1 AND girl_sort > 0 AND (tue ='".$date."' OR tue_check = 1) AND girl.tue_start<'".$nowtime."' AND girl.tue_end>'".$nowtime."' ORDER BY tue_start, tue_end"; $girl_result = mysqli_query($con,$girl_sql); if(!$girl_sql){ print("SQLの実行に失敗しました。 "); exit; } $waiting_girls_rst = mysqli_num_rows($girl_result ); break; case 3: //////////　この店舗の今すぐ遊べる女の子読み込み・水曜日　////////// $girl_sql = "SELECT * FROM girl WHERE girl_shop_id =$shop_id AND waiting= 1 AND girl_sort > 0 AND (wed ='".$date."' OR wed_check = 1) AND girl.wed_start<'".$nowtime."' AND girl.wed_end>'".$nowtime."' ORDER BY wed_start, wed_end"; $girl_result = mysqli_query($con,$girl_sql); if(!$girl_sql){ print("SQLの実行に失敗しました。 "); exit; } $waiting_girls_rst = mysqli_num_rows($girl_result ); break; case 4: //////////　この店舗の今すぐ遊べる女の子読み込み・木曜日　////////// $girl_sql = "SELECT * FROM girl WHERE girl_shop_id =$shop_id AND waiting= 1 AND girl_sort > 0 AND (thu ='".$date."' OR thu_check = 1) AND girl.thu_start<'".$nowtime."' AND girl.thu_end>'".$nowtime."' ORDER BY thu_start, thu_end"; $girl_result = mysqli_query($con,$girl_sql); if(!$girl_sql){ print("SQLの実行に失敗しました。 "); exit; } $waiting_girls_rst = mysqli_num_rows($girl_result ); break; case 5: //////////　この店舗の今すぐ遊べる女の子読み込み・金曜日　////////// $girl_sql = "SELECT * FROM girl WHERE girl_shop_id =$shop_id AND waiting= 1 AND girl_sort > 0 AND (fri ='".$date."' OR fri_check = 1) AND girl.fri_start<'".$nowtime."' AND girl.fri_end>'".$nowtime."' ORDER BY fri_start, fri_end"; $girl_result = mysqli_query($con,$girl_sql); if(!$girl_sql){ print("SQLの実行に失敗しました。 "); exit; } $waiting_girls_rst = mysqli_num_rows($girl_result ); break; case 6: //////////　この店舗の今すぐ遊べる女の子読み込み・土曜日　////////// $girl_sql = "SELECT * FROM girl WHERE girl_shop_id =$shop_id AND waiting= 1 AND girl_sort > 0 AND (sat ='".$date."' OR sat_check = 1) AND girl.sat_start<'".$nowtime."' AND girl.sat_end>'".$nowtime."' ORDER BY sat_start, sat_end"; $girl_result = mysqli_query($con,$girl_sql); if(!$girl_sql){ print("SQLの実行に失敗しました。 "); exit; } $waiting_girls_rst = mysqli_num_rows($girl_result ); break; } } } if($waiting_girls_rst){ $body.= <<< SET
すぐに遊べる女の子：$waiting_girls_rst人
SET; } else { $body.= <<< SET
SET; } } //////////　無料掲載コース　////////// elseif($shop_course=="10"){ $body.= <<< SET
{$shop_name}
お店の詳細を見る
店舗メッセージ
{$shop_pr}
SET; } } mysqli_free_result($recordSet); echo $body; echo <<< SET
SET; ?>