<?php
# $Id: ad-box,v 3.50 2014/01/20 Hiyama Exp $
# SQL統一型対応

#---------------------------------------------#
#                            初期設定
#---------------------------------------------#

//コンテンツ名
$QSS='kyoutube';
list($temp,$contTIT,$temp)=csv_set($QSS);

//設定
$SET_sc=$SC_set[CTPLUG][$QSS];
if(!$SET_sc) $SET_sc=$SC_set['adbox'][$QSS];

$UPDIR=log_dir.$QSS."/";// アップdir
$HMDIR=log_full.$QSS."/";// 表示dir

// ロックファイル
$lockfile=$UPDIR.lock_file;


//ソート配列
if(!$gOR) $gOR=array("新着順","人気順");
if(!$sOR) $sOR=array(" no_log desc"," week desc");

//絞り込み
if(!$gTAG) $gTAG=array("全て","女の子投稿","お店投稿");
if(!$sTAG) $sTAG=array(""," and temp2_log='1' and gid_log<>''"," and (temp2_log<>'1' or gid_log='')");
if(!$lTAG) $lTAG=array("","","");

//デフォルトタイトル
$TITLE="みるっ娘";


#---------------------------------------------#
#                            SQL設定
#---------------------------------------------#

$CONT_QUERY_CELL=$SQL_QUERY_CELL;
$CONT_TABLE=$SQL_TABLE;
$CONT_QUERY_WHERE=$SQL_QUERY_WHERE;
$CONT_QUERY_KEY=" order by no_log desc";

//logSQL
$CONT_QUERY_CELL.=",gid_m,name_m,age_m,comT_m,comB_m,comC_m,comW_m,comH_m,sys_MO_m,sys_PC_m,sys_SP_m,schedule_m,schweek_m,schsys_m,other_m";
$CONT_QUERY_CELL.=",no_log,gid_log,id_log,ct_log,sys_log,com_log,uptime_log,time_log,data_log,other_log,temp1_log,temp2_log,temp3_log";
$CONT_TABLE.=" join ".sql_kyoutubetable." on (id_log=id_p and sys_log=1 and com_log NOT LIKE '%title=>削除済み,%')";
$CONT_TABLE.=" left join ".sql_memtable." on (gid_log=gid_m and id_log=id_m";
$CONT_TABLE.=" and (sys_MO_m=1 or sys_SP_m=1 or sys_PC_m=1)";
//if(CTPLUG) $CONT_TABLE.=" and (sys_MO_m=1 or sys_SP_m=1 or sys_PC_m=1)";
//	else $CONT_TABLE.=" and sys_".Terminal."_m=1";
$CONT_TABLE.=")";
if(GID!='') $CONT_QUERY_WHERE.=" and gid_m='".GID."'";


//カウンター
$t=6;
$pagecell=",(";
for($i=0;$i<7;++$i){
	$sqlday=FutureDay(TODAY,-$i);
	$pagecell.=" IF(lastdate_cou<".$sqlday.",0,d_".($t-$i).") +";
}
$pagecell=rtrim($pagecell," +");
$pagecell.=" ) as week";

$CONT_QUERY_CELL.=$pagecell;
$CONT_QUERY_CELL.=",total,lastdate_cou as L_ACCESS";
$CONT_TABLE.=" left join ".sql_kyoutubecotable." on (no_cou=no_log)";

$o=$Q{'OR'};if(!$o) $o=0;
$CONT_QUERY_KEY_ORDER=" order by".$sOR[$o];
if($Q{'tag'}) $CONT_QUERY_WHERE_PLUS=$sTAG[$Q{'tag'}];

//契約内容
list($CONT_TABLE,$CONT_QUERY_WHERE)=ContSql($CONT_TABLE,$CONT_QUERY_WHERE,$QSS);

//追加SQL&AREA処理
require(ini_dir."plug-ordersql.php");


#---------------------------------------------#
#                         　メイン画面
#---------------------------------------------#

//SPLUG(デフォルトプラグ,指定プラグ)
$SPLUG=plug_carry($QSS,$PLUG[$QSS]);
if($SPLUG) if(file_exists($SPLUG)) require($SPLUG);

?>