のお店情報 件ヒットしました!
10 ORDER BY shop_course DESC, upper_update DESC LIMIT $size) UNION (SELECT * FROM shop WHERE shop_subarea_1 =27 OR shop_subarea_2 =27 AND shop_publish=1 AND shop_course>10 ORDER BY upper_update DESC LIMIT $size) UNION (SELECT * FROM shop WHERE shop_area =27 AND shop_publish=1 AND shop_course=10 ORDER BY upper_update DESC LIMIT $size) 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);
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);
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" and $shop_subarea_1<>27 and $shop_subarea_2<>27){
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);
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
SET;
}
else {
$body.= <<< SET
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);
$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);
$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);
$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);
$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);
$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);
$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);
$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" and $shop_subarea_1<>27 and $shop_subarea_2<>27){
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);
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
SET;
}
else {
$body.= <<< SET
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);
$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);
$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);
$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);
$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);
$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);
$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);
$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_subarea_1==27 or $shop_subarea_2==27){
if($spri_url ) {
$spri_banner = <<< TAGSET