";
}
//HA CIMKE
if($_GET['type']=="tag"){
if($_GET['id']>0){
$tag_id =$_GET['id'];
}else{
$tag_id =1;
}
$parancs = "SELECT ".$lng."_tag_name FROM tags WHERE tag_id =" . $tag_id ;
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
while ( $sor = mysql_fetch_array($eredmeny)) {
$title2= $sor[$lng."_tag_name"];
}
$parancs = "SELECT filmek.movie_id FROM movies filmek, movie_tags filmcimkek WHERE (filmek.movie_id = filmcimkek.movie_id AND filmcimkek.tag_id='".$tag_id."' ) GROUP BY filmek.movie_id ";
$waneresult = mysql_query($parancs) or die(mysql_error());
while($row = mysql_fetch_array($waneresult)){
$inmovies[]=$row['movie_id'];
}
if($lng=="hun"){
$backbuttontitle="Vissza a címkéhez";
}else{
$backbuttontitle="Back to the tag";
}
$backbutton="
";
}
//HA FILM
if($_GET['type']=="movie"){
if($_GET['id']>0){
$movie_id =$_GET['id'];
}else{
$movie_id =1;
}
$parancs = "SELECT * FROM movies WHERE movie_id ='" . $movie_id ."' ";
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
while ( $sor = mysql_fetch_array($eredmeny)) {
$title2= "".$sor['title']; if($sor['season']>0){ if($lng=="hun"){ $title2.= " - ". $sor['season'].".".$txt['season'].""; }else{ $title2.= " - ".$txt['season']." ". $sor['season']; } } $title2.= "
"; if( $sor['hun_title']!= $sor['eng_title']){ $title2.= "".$sor['hun_title']; if($sor['season']>0){ if($lng=="hun"){ $title2.= " - ". $sor['season'].".".$txt['season'].""; }else{ $title2.= " - ".$txt['season']." ". $sor['season']; } } $title2.= "
"; } $title2.= "(".$sor['year']; $title2.= ")
"; } $inmovies[]=$movie_id; if($lng=="hun"){ $backbuttontitle="Vissza a filmhez"; }else{ $backbuttontitle="Back to the movie"; } $backbutton="
";
}
//HA IDOSZAK
if($_GET['type']=="period"){
if($_GET['id']>0){
$period_id =$_GET['id'];
}else{
$period_id = 21;
}
$parancs = "SELECT id, eng_period, hun_period, start, end FROM time_periods WHERE id=" . $period_id. " ";
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
while ( $sor = mysql_fetch_array($eredmeny)) {
$title2= $sor[$lng."_period"];
$period_start=$sor['start'];
$period_end=$sor['end'];
}
$parancs2 = "SELECT filmek.movie_id FROM movies filmek, movie_time ido WHERE (filmek.movie_id=ido.movie_id AND time>".($period_start-1)." AND time<".($period_end+1)." ) " ;
$waneresult = mysql_query($parancs2) or die(mysql_error());
while($row = mysql_fetch_array($waneresult)){
$inmovies[]=$row['movie_id'];
}
if($lng=="hun"){
$backbuttontitle="Vissza az idöszakhoz";
}else{
$backbuttontitle="Back to the time period";
}
$backbutton="
";
}
$inmovies_u=array_unique($inmovies);
if(count($inmovies_u)>0){
$inmoviesfilter=" AND helyszinek.movie_id IN (" .implode(",",$inmovies_u).") ";
}else{
$inmoviesfilter="";
}
$langloctow=$lng."_tow";
$langlocsta=$lng."_sta";
$langlocsub=$lng."_sub";
$langloccon=$lng."_con";
$parancs_sta = "SELECT ".$langlocsta.", eng_sta, id, COUNT(DISTINCT helyszinek.movie_id) as thecounter FROM loc_sta allamok, movie_loc helyszinek WHERE (helyszinek.loc_type='sta' AND helyszinek.loc_id= allamok.id OR (helyszinek.loc_type='tow' AND helyszinek.loc_id= ANY (SELECT id FROM loc_tow WHERE sta_id=allamok.id))) ".$inmoviesfilter." GROUP BY ".$langlocsta." ORDER BY thecounter DESC" ;
$eredmeny_sta = mysql_query($parancs_sta, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
$locstasor="";
$stacount;
$parancs2 = "SELECT ".$langloccon.",eng_con, id, COUNT(DISTINCT helyszinek.movie_id) as thecounter FROM loc_con kontinensek, movie_loc helyszinek WHERE (helyszinek.loc_type='con' AND helyszinek.loc_id= kontinensek.id) ".$inmoviesfilter." GROUP BY ".$langloccon." ORDER BY thecounter DESC" ;
$eredmeny2 = mysql_query($parancs2, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
$parancs_sub = "SELECT ".$langlocsub.",eng_sub, id, COUNT(DISTINCT helyszinek.movie_id) as thecounter FROM loc_sub allamok, movie_loc helyszinek WHERE (helyszinek.loc_type='sub' AND helyszinek.loc_id= allamok.id) ".$inmoviesfilter." GROUP BY ".$langlocsub." ORDER BY thecounter DESC" ;
$eredmeny_sub = mysql_query($parancs_sub, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
?>
".ucfirst($txt["locations"])." - FilmO";
?>
Helyszínek - FilmO";
?>
10){
echo "".strtoupper($txt["locations"])."
"; if(strlen($title2)>1){ print "".$title2."
"; } print "