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']); //movie info $bkmov = 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 = ''; //新着、非公開分をカウント $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 ".$start.",".$per; $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"; } $pnavi = create_PAGENAVI($_SERVER['SCRIPT_NAME'],"",$page,$all,$per); ?> 映画一覧|anemo movie > トップ > 映画',8); ?>
映画 anemo movie 話題の新作映画のご紹介と、試写会プレゼントのコーナー。
「ユーザーレビュー」では皆さまからのご投稿をお待ちしています。
映画トップ > 映画一覧
映画一覧
▼新着順
.html">" width="70" border="0">
.html"> .html#review">レビュー( )>>
特集':''); ?>
  ページのトップへ