<?php

// omitted database requires

if (date('w')<=3){
$minus_seconds= (date('w')+3)*86400;
$wideBeginDate= date('Y-m-d',(strtotime(date('Y-m-d'))-$minus_seconds));
$minus_seconds= (date('w')+1)*86400;
$wideEndDate= date('Y-m-d',(strtotime(date('Y-m-d'))-$minus_seconds));

$plus_seconds= (6-date('w'))*86400;
$soonEndDate= date('Y-m-d',(strtotime(date('Y-m-d'))+$plus_seconds));
$soonBeginDate= date('Y-m-d',strtotime($soonEndDate)-(2*86400));
}elseif (date('w')>=4){
$plus_seconds= (6-date('w'))*86400;
$wideEndDate= date('Y-m-d',(strtotime(date('Y-m-d'))+$plus_seconds));
$wideBeginDate= date('Y-m-d',strtotime($wideEndDate)-(2*86400));
$soonBeginDate= date('Y-m-d',strtotime($wideEndDate)+(5*86400));
$soonEndDate= date('Y-m-d',strtotime($soonBeginDate)+(2*86400));
}

$select= 'SELECT movies.id, movies.name, movies.rating, movies.runtime, movies.score, movies.summary, movies.serial_no, trailers.url AS trailer_url ' .
'FROM movies left join trailers on (trailers.movie_id = movies.id), movie_status,release_dates ' .
'WHERE (movies.id = movie_status.movie_id) AND (movies.lang_id=0) AND (release_dates.theater_id=1) AND (release_dates.movie_id=movies.id) AND release_date between "'.$wideBeginDate.'" and "'.$wideEndDate.'" ORDER BY movies.score DESC';
$selectRST= mysql_query($select,$t10);
$selectTBL= mysql_fetch_assoc($selectRST);

$rss= '<?xml version="1.0" encoding="utf-8"?>
<new_movies>
';

do{
$title= htmlspecialchars(utf8_encode($selectTBL['name']),ENT_QUOTES);
$title= trim(substr($title,0,strrpos($title,'(')));
$movie_id= $selectTBL['id'];
$descrip= htmlspecialchars(utf8_encode(trim_last_word($selectTBL['summary'])),ENT_QUOTES);

$reviews= "Select count(id) from reviews where movie_id=$movie_id";
$reviews_rst= mysql_query($reviews,$t10) or die(mysql_error());
$reviewsNum= mysql_result($reviews_rst,0);
$rank_img= get_movie_portal__score_image($selectTBL['score'], 1);

if (file_exists('../reviews/images/'.$selectTBL['serial_no'].'.jpg')){
$movie_img= 'reviews/images/'.$selectTBL['serial_no'].'.jpg';
}else{
$movie_img= 'images/image_not_available.gif';
}

$qry_stars ="SELECT movie_stars.movie_id, stars.name FROM movie_stars, stars WHERE (movie_stars.movie_id =$movie_id) AND (movie_stars.star_id = stars.id) AND (starring_order > 0) ORDER BY starring_order LIMIT 2";
$rstStars = mysql_query($qry_stars, $t10) or die(mysql_error());
$totalRows_rstStars = mysql_num_rows($rstStars);
$row_rstStars = mysql_fetch_assoc($rstStars);

$star_list = '';
do {
$star_list .= $row_rstStars['name'].", ";
} while ($row_rstStars = mysql_fetch_assoc($rstStars));
mysql_free_result($rstStars); // close our original query
$star_list = substr($star_list, 0, strlen($star_list) - 2);

$rss.= '
<movie>
<title>'.$title.'</title>
<movie_img>'.$movie_img.'</movie_img>
<link>reviews/mr'.$movie_id.'.htm</link>
<summary>'.$descrip.'</summary>
<stars>'.$star_list.'</stars>
<rating>'.get_short_mpaa_string($selectTBL['rating']).'</rating>
<runtime>'.$selectTBL['runtime'].'</runtime>
<ranking>'.$selectTBL['score'].'</ranking>
<ranking_img>'.$rank_img.'</ranking_img>
<review_num>'.$reviewsNum.'</review_num>
<trailer>'.$selectTBL['trailer_url'].'</trailer>
</movie>';

} while ($selectTBL= mysql_fetch_assoc($selectRST)) ;

$rss.='

</new_movies>';

#print $rss;

$handle = fopen("top10_new_in_theaters.xml", "w");
$export_file_write = fwrite($handle, $rss);
fclose($handle);

?>