" . $titlename . " - FilmO"; print ""; print ""; ?>

"; $lng_period=$lng."_period"; if($period_id>0){ $parancs2 = "SELECT id, eng_period, hun_period, start, end FROM time_periods WHERE id=" . $period_id. " "; }else{ $parancs2 = "SELECT id, eng_period, hun_period, start, end FROM time_periods WHERE start<=" . $time. " AND end >=". $time ." ORDER BY id ASC"; } $eredmeny2 = mysql_query($parancs2, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor = mysql_fetch_array($eredmeny2)) { $period= $sor[$lng_period]; $period_id=$sor['id']; $period_start=$sor['start']; $period_end=$sor['end']; ?>

"?>

" ); $parancs = "SELECT filmek.movie_id, title, hun_title, year, season, time, time_cat FROM movies filmek, movie_time ido WHERE (filmek.movie_id=ido.movie_id AND time>".($period_start-1)." AND time<".($period_end+1)." )ORDER BY time ASC, year ASC;" ; //$parancs = "SELECT id, eng_name, hun_name FROM cult_characters WHERE id!='".$cult_id."' ORDER BY RAND() DESC LIMIT 33 " ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $timevar; $colorone="#1f1f1f"; $colortwo="#050505"; $tdcolor=$colortwo; while ( $sor = mysql_fetch_array($eredmeny)) { if ($timevar!=$sor['time']){ if ($tdcolor==$colorone){ $tdcolor=$colortwo; } else if ($tdcolor==$colortwo){ $tdcolor=$colorone; } } $tdcolor_save=$tdcolor; if ($sor['year']<$sor['time'] || $sor['time_cat']>1 ){ $tdcolor="#550500"; } print ""; if ($timevar!=$sor['time']){ print "
"; if ($sor['time']<0){ if ($lng=="hun"){ print "i.e. "; } print str_replace( "000000", "M", str_replace("-", "", $sor['time'])); if ($lng=="eng"){ print " BC"; } } else { print $sor['time']; } print " >> "; $timevar=$sor['time']; } print ""; if ($sor['year']<$sor['time'] || $sor['time_cat']>1 ){ $tdcolor=$tdcolor_save; } } print ""; ?>

"; $parancs3 = "SELECT id, eng_period, hun_period, start, end FROM time_periods ORDER BY start DESC"; $eredmeny3 = mysql_query($parancs3, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); print "
"; $szamlal; while ( $sor = mysql_fetch_array($eredmeny3)) { print " ".$sor[$lng_period]."     " ; if ($szamlal%5==0){ print "
"; } $szamlal++; } print "
"; print ""; ?>