$rank. $moviename
"; } } function premiere_image_uw($today, $startlimit=0) { $sql="SELECT t1.movieID FROM movtblMovies as t1, movtblProduct as t2 WHERE t1.deleted=0 AND t1.movieID=t2.movieID AND t2.producttypeID=367492 AND YEARWEEK(t2.release_sale, 3) = YEARWEEK($today, 3) order by t2.release_sale, t2.updated desc limit $startlimit,1"; $result = mysql_query($sql); while ($myrow = mysql_fetch_row($result)) { $topmovieID=$myrow[0]; $imglink=getMoviestill($topmovieID, 300, "ultrawide"); } if(!$imglink&&$startlimit<10) { $startlimit++; $imglink=premiere_image_uw($today, $startlimit); } else { return $imglink; } } function premiere_image($today, $startlimit=0) { $sql="SELECT t1.movieID FROM movtblMovies as t1, movtblProduct as t2 WHERE t1.deleted=0 AND t1.movieID=t2.movieID AND t2.producttypeID=367492 AND YEARWEEK(t2.release_sale, 3) = YEARWEEK($today, 3) order by t2.release_sale, t2.updated desc limit $startlimit,1"; $result = mysql_query($sql); while ($myrow = mysql_fetch_row($result)) { $topmovieID=$myrow[0]; $imglink=getMoviestill($topmovieID, 450); } if(!$imglink&&$startlimit<10) { $startlimit++; $imglink=premiere_image_uw($today, $startlimit); } else { return $imglink; } } function coming_premiere_image($today, $startlimit=0) { $sql="SELECT t1.movieID FROM movtblMovies as t1, movtblProduct as t2 WHERE t1.deleted=0 AND t1.movieID=t2.movieID AND t2.producttypeID=367492 AND YEARWEEK(t2.release_sale, 3) > YEARWEEK($today, 3) order by t2.release_sale, t2.updated desc limit $startlimit,1"; $result = mysql_query($sql); while ($myrow = mysql_fetch_row($result)) { $topmovieID=$myrow[0]; $imglink=getMoviestill($topmovieID, 450); } if(!$imglink&&$startlimit<10) { $startlimit++; $imglink=premiere_image_uw($today, $startlimit); } else { return $imglink; } } function print_waitingfor($from_siteID, $from_maintype, $from_genericID) { $sql="select to_siteID, to_maintype, to_genericID, relationID from tblRelations where from_siteID=$from_siteID AND from_maintype=$from_maintype AND from_genericID=$from_genericID limit 10"; $result=mysql_query($sql); $treff=mysql_num_rows($result); while($row=mysql_fetch_row($result)) { $to_siteID=$row[0]; $to_maintype=$row[1]; $to_genericID=$row[2]; $relationID=$row[3]; if($to_maintype==9) // product { $title=getproducttitle($to_genericID, 0); $movieID=getmovieID($to_genericID); //$imagelink=getcoverimage($to_genericID, 1); $linkURL="/html/product/".$to_genericID.".html"; $releasedate=getreleasedate($to_genericID); $producttype=getproducttypename($to_genericID); } print "\n$title"; print " ($producttype - $releasedate)"; print "
"; } } include "$DESIGN_INCLUDES/head.php"; ?>
Kommende kinofilmer"; $sql="select t1.movieID, t1.title_no, t1.prodyear_start, date_format(t2.release_sale, '%d.%m'), WEEK(t2.release_sale, 3) from movtblMovies as t1, movtblProduct as t2 where t1.deleted=0 AND t1.movieID=t2.movieID AND t2.producttypeID=367492 AND YEARWEEK(t2.release_sale, 3) > YEARWEEK($today,3) AND YEARWEEK(t2.release_sale, 3) < YEARWEEK($plussixty,3) order by t2.release_sale "; $result=mysql_query($sql); while($myrow=mysql_fetch_row($result)) { $mID=$myrow[0]; $moviename=stripslashes($myrow[1]); $prodyear_start=$myrow[2]; $dato=$myrow[3]; $ukenr=$myrow[4]; if($ukenr<>$storedweek) { print "
Uke $ukenr
"; } print "$dato: $moviename
"; $storedweek=$ukenr; } //print "

>> Flere kommende kinofilmer"; ?>

'; print "$imglink \n"; print ""; print "Kinotoppen uke $listweek, Norge og USA

"; print ''; print ''; print ''; print ''; print ''; print '
'; // Norgeslisten print "Norge
"; printweeklist($listweek,$listyear,2); print '
'; //USA-listen print "USA
"; printweeklist($listweek,$listyear,1); print '
'; print '
'; // så kommer KOMMENDE FILMER // først forsøker vi å finne et passende ultrawide-bilde. // funksjonen går gjennom listen fra denne uken og framover inntil bilde finnes (max 10). $imglink=premiere_image_uw($today); print '
'; print "$imglink \n"; print ""; print "Premierer denne uken

"; $sql="select t1.movieID, t1.title_no, t1.prodyear_start, date_format(t2.release_sale, '%d.%m') from movtblMovies as t1, movtblProduct as t2 where t1.deleted=0 AND t1.movieID=t2.movieID AND t2.producttypeID=367492 AND YEARWEEK(t2.release_sale, 3) = YEARWEEK($today,3) order by t2.release_sale limit 10"; $result=mysql_query($sql); while($myrow=mysql_fetch_row($result)) { $mID=$myrow[0]; $moviename=stripslashes($myrow[1]); $prodyear_start=$myrow[2]; $dato=$myrow[3]; $dato2=$myrow[4]; print "$dato: $moviename
"; } print "

>> Kommende ukers premierefilmer"; print '

'; ?>
$minusthirty AND t1.dato<=$today AND t1.ok=1 order by t1.dato desc, t1.updated desc limit 2"; $result = mysql_query($sql); $teller=1; while ($myrow = mysql_fetch_row($result)) { $overskrift=stripslashes($myrow[0]); $teaser=$myrow[1]; $shortbread=stripslashes($myrow[2]); $articleID=$myrow[3]; $dato=$myrow[4]; $displaywidth=300; $imagearray=get_intro_image($articleID, $displaywidth); print '
'; print ""; if($imagearray[0]<>'') { print $imagearray[0]; } print "
$overskrift
"; print "

$teaser

"; print '
'; } */ ?>