decryption($GLOBALS['dbuser']); $GLOBALS['dbpass']=$action->decryption($GLOBALS['dbpass']); $action = new mysql_ct(); $db = $action->connect($GLOBALS['dbserver'], $GLOBALS['dbuser'], $GLOBALS['dbpass']); $action->select_db($GLOBALS['vdbname']); //--------------- //review //--------------- $review = array(); $i = 0; $new = 3; list($ty,$tm,$td) = explode("-",date('Y-m-d', mktime (0, 0, 0, date("m"), date("d"), date("y")) - (86400 * $new))); $tempdate = ($ty*10000)+($tm*100)+$td; $icon = ''; //query $query = "select SQL_CALC_FOUND_ROWS a.*,b.vtitle,b.vlistthumb,c.mnick from (".$GLOBALS['revtable']." as a left join ".$GLOBALS['vtable']." as b on a.vid=b.vid) left join ".$GLOBALS['mmdbname'].".".$GLOBALS['mmtable']." as c on a.mid=c.mid where a.revstat=1 order by a.editdate desc,a.revid desc limit 0,6"; $result = $action->query($query); while($line=$action->fetch_array($result)){ list($ty,$tm,$td) = explode("-",$line['editdate']); $line['editdate']=str_replace("-","/",$line['editdate']); $tdate = ($ty*10000)+($tm*100)+$td; $line['icon']=$tdate>=$tempdate?$icon:""; $review[$i] = $line; $i++; } //件数取得 $query = "SELECT FOUND_ROWS()"; $result = $action->query($query); $line=$action->fetch_array($result); $reviewall = $line['FOUND_ROWS()']; //--------------- //movie //--------------- $bkmov = array(); $i = 0; //新着、非公開分をカウント $inv = array(); $query = "select vid,count(revid) as num from ".$GLOBALS['revtable']." where revstat<>1 group by vid order by null"; $result = $action->query($query); while($line=$action->fetch_array($result)){ $inv[] = $line; } //全体を取得しレビューをカウント(上記カウントを引く) $query = "select SQL_CALC_FOUND_ROWS a.*,count(b.revid) as num,max(b.editdate) as recentdate from ".$GLOBALS['vtable']." as a left join ".$GLOBALS['revtable']." as b on a.vid=b.vid where a.adddate<=now() group by vid order by a.adddate desc limit 0,5"; $result = $action->query($query); while($line=$action->fetch_array($result)){ list($year,$month,$day)=explode("-",$line['adddate']); $line['adddate']=($year*1)."年".($month*1)."月".($day*1)."日"; $line['vol']=sprintf("%03d",$line['vol']); $tdate = ($year*10000)+($month*100)+$day; $line['icon']=$tdate>=$tempdate?$icon:""; //新着、非公開引く foreach($inv as $invline){ if($invline["vid"]==$line["vid"]){ $line["num"]-=$invline["num"]; break; } } if($i==0){ $lastnum = $line['vid']; } $bkmov[$i] = $line; $i++; } //件数取得 $query = "SELECT FOUND_ROWS()"; $result = $action->query($query); $line=$action->fetch_array($result); $all = $line['FOUND_ROWS()']; //メモリ開放 $action->free($result); // 接続を閉じる $action->close($db); function getYoubi($date){ $sday = strtotime($date); $res = date("w", $sday); $day = array("日", "月", "火", "水", "木", "金", "土"); return $day[$res]; } function convPath($path,$n){ $ar = explode("www.anemo.co.jp",$path); $ar2 = explode("/",$ar[1]); array_pop($ar2); return implode("/",$ar2)."/".$n.".jpg"; } ?> 映画、試写会、プレゼント|anemo movie > トップ > 映画',8); ?>
映画 anemo movie 話題の新作映画のご紹介と、試写会プレゼントのコーナー。
「ユーザーレビュー」では皆さまからのご投稿をお待ちしています。
映画トップ > >
映画トップ邦画も洋画もアジア映画も新着ぞくぞく!みなさまからのレビューをお待ちしております!
新着ユーザーレビュー
作品: 投稿者: 0){ ?> ★ ☆ 1){ ?> ★ ☆ 2){ ?> ★ ☆ 3){ ?> ★ ☆ 4){ ?> ★ ☆
新着映画
レビュー( )>> 特集
ページのトップへ