_EOT_;
//1番指定
$_POST["pricedown-down"]="-1";
$_POST["sort"]="(pricedown )";
/***********************
商品情報はここへ
***********************/
$item_title = '万引き！！捕まる人妻たち';
$name = '';
$actress_name = modifAuter($name);
$img_pass = '/4/5/8/2/';
$maker_name ='中嶋興業';
$genre_name = '人妻';
$onsale_day = '2016/05/01';
$jan_code = '4582220724493';
$item_number = 'NND-027';
$item_desc = 'レーベル：中嶋興業／ジャンル：万引き・凌辱／収録時間：２４５分／内容：手癖の悪い専業主婦に生ハメ死刑！スリルを求めて万引きする主婦に極悪店員がヤリたい放題！強気一辺の妻、なぜかふてくされる性悪妻、清楚なルックスの小心妻、逆ギレ妻などが、鬼畜チ○ポに貫かれる！';
//キーワードでの部門分け
$bumon = 'DVD';
//-----------------------------
//ピックアップの抽出条件を作成
$SQL_GET_ACTRESS=<<<_EOT_
select i.*
from (yumdb_item as i left join yumdb_iteminfo as ii on i.`JAN` = ii.`JAN`)
where (0 < i.`在庫数`)
and (i.`新古区分` = 1)
and (i.`小分類名` != 'アニメ')
and (i.`小分類名` != 'イメージ')
and (i.`小分類名` != '邦画')
and (i.`小分類名` != '洋画')
and (i.`小分類名` != 'その他')
and (i.`作者名` like '%$actress_name%')
order by ii.`画像有無` desc, i.`発売日` desc
limit 0, 4;
_EOT_;
$SQL_GET_MAKER=<<<_EOT_
select i.*
from (yumdb_item as i left join yumdb_iteminfo as ii on i.`JAN` = ii.`JAN`)
where (0 < i.`在庫数`)
and (i.`新古区分` = 1)
and (i.`小分類名` != 'アニメ')
and (i.`小分類名` != 'イメージ')
and (i.`小分類名` != '邦画')
and (i.`小分類名` != '洋画')
and (i.`小分類名` != 'その他')
and (i.`製作会社名` = '$maker_name')
order by ii.`画像有無` desc, ii.`新入荷日時` desc
limit 0, 4;
_EOT_;
$SQL_GET_GENRE=<<<_EOT_
select i.*
from (yumdb_item as i left join yumdb_iteminfo as ii on i.`JAN` = ii.`JAN`)
where (0 < i.`在庫数`)
and (i.`新古区分` = 1)
and (i.`定価` != 0)
and (i.`小分類名` != 'アニメ')
and (i.`小分類名` != 'イメージ')
and (i.`小分類名` != '邦画')
and (i.`小分類名` != '洋画')
and (i.`小分類名` != 'その他')
and (i.`小分類名` = '$genre_name')
order by ii.`画像有無` desc, i.`発売日` desc, ii.`新入荷日時` desc
limit 0, 4;
_EOT_;
//採算度外視のみランダム抽出
$SQL_GET_SALE_ITEM=<<<_EOT_
select i.*
from (yumdb_item as i left join yumdb_iteminfo as ii on i.`JAN` = ii.`JAN`)
where (0 < i.`在庫数`)
and (i.`新古区分` = 1)
and (i.`売価` <= 500)
and (i.`新古区分` = 1)
and (i.`中分類名` = 'アダルト')
and (i.`小分類名` != 'アニメ')
and (i.`小分類名` != 'イメージ')
and (i.`小分類名` != '邦画')
and (i.`小分類名` != '洋画')
and (i.`小分類名` != 'その他')
order by RAND()
limit 0, 8;
_EOT_;
// order by ii.`画像有無` desc, ii.`新入荷日時` desc, i.`発売日` desc
//初期化
//yumdb_shareを参照
$cid = connect_db();
$buf_maker=makelist($SQL_GET_MAKER,$cid);
$buf_actress=makelist($SQL_GET_ACTRESS,$cid);
$buf_genre=makelist($SQL_GET_GENRE,$cid);
$buf_sale=makelist($SQL_GET_SALE_ITEM,$cid);
mysql_close($cid);
$maker_list=format_items_data( $buf_maker,$format_adult,40,18);
$actress_list=format_items_data( $buf_actress,$format_adult,40,18);
$genre_list=format_items_data( $buf_genre,$format_adult,40,18);
$sale_list=format_items_data( $buf_sale,$format_adult,40,18);
//関連商品表示、情報無しの場合は表示しない
if(!empty($actress_name)){
if(!empty($actress_list)){
$title_h3 = '
