";
print "
";
print "
";
print "
";
print "
";
print "
";
print " 
";
}
//rendezo-e
$counted="filmek.movie_id";
$pagerquery = "SELECT COUNT(" . $counted . "), title, hun_title, year, season FROM movies filmek, director rendezo WHERE filmek.movie_id=rendezo.movie_id AND rendezo.person_id=".$person_id." ORDER BY year DESC;" ;
$waneresult = mysql_query($pagerquery) or die(mysql_error());
while($row = mysql_fetch_array($waneresult)){
$wane_director=$row['COUNT('.$counted.')'];
}
//iro-e
$counted="filmek.movie_id";
$pagerquery = "SELECT COUNT(" . $counted . "), title, hun_title, year, season FROM movies filmek, writer iro WHERE filmek.movie_id=iro.movie_id AND iro.person_id=".$person_id." ORDER BY year DESC;" ;
$waneresult = mysql_query($pagerquery) or die(mysql_error());
while($row = mysql_fetch_array($waneresult)){
$wane_writer=$row['COUNT('.$counted.')'];
}
//szinesz-e
$counted="filmek.movie_id";
$pagerquery = "SELECT COUNT(" . $counted . "), title, hun_title, year, season, ".$lng."_role_name, voice_lang FROM movies filmek, actor szinesz WHERE filmek.movie_id=szinesz.movie_id AND szinesz.person_id=".$person_id." AND voice_lang!='hun' " ;
$waneresult = mysql_query($pagerquery) or die(mysql_error());
while($row = mysql_fetch_array($waneresult)){
$wane_actor=$row['COUNT('.$counted.')'];
}
//MAGYARszinkronos-e
$counted="filmek.movie_id";
$pagerquery = "SELECT COUNT(" . $counted . "), title, hun_title, year, season, ".$lng."_role_name, voice_lang FROM movies filmek, actor szinesz WHERE filmek.movie_id=szinesz.movie_id AND szinesz.person_id=".$person_id." AND voice_lang='hun' " ;
$waneresult = mysql_query($pagerquery) or die(mysql_error());
while($row = mysql_fetch_array($waneresult)){
$wane_szinkron=$row['COUNT('.$counted.')'];
}
//zeneszerzõ-e
$counted="filmek.movie_id";
$pagerquery = "SELECT COUNT(" . $counted . "), title, hun_title, year, season FROM movies filmek, composer zeneszerzo WHERE filmek.movie_id=zeneszerzo.movie_id AND zeneszerzo.person_id=".$person_id." ORDER BY year DESC;" ;
$waneresult = mysql_query($pagerquery) or die(mysql_error());
while($row = mysql_fetch_array($waneresult)){
$wane_composer=$row['COUNT('.$counted.')'];
}
//szerzõ-e
$counted="konyvek.book_id";
$pagerquery = "SELECT COUNT(" . $counted . "), title, hun_title, year FROM books konyvek, author szerzo WHERE konyvek.book_id=szerzo.book_id AND szerzo.person_id=".$person_id." ORDER BY year DESC;" ;
$waneresult = mysql_query($pagerquery) or die(mysql_error());
while($row = mysql_fetch_array($waneresult)){
$wane_author=$row['COUNT('.$counted.')'];
}
//konyvszereplo-e
$counted="konyvek.book_id";
$pagerquery = "SELECT COUNT(" . $counted . "), title, hun_title, year FROM books konyvek, bookperson konyvebeli WHERE konyvek.book_id=konyvebeli.book_id AND konyvebeli.person_id=".$person_id." ORDER BY year DESC;" ;
$waneresult = mysql_query($pagerquery) or die(mysql_error());
while($row = mysql_fetch_array($waneresult)){
$wane_bookperson=$row['COUNT('.$counted.')'];
}
print "
"; $function="( "; $mainfunction; $func; if ($wane_director>0){ $function.=strtolower($txt["director"]); $mainfunction="director"; $func="d"; } if ($wane_writer>0){ $func.="w"; if (strlen($function)>2){ $function.=", "; } if (($wane_writer>$wane_director)){ $mainfunction="writer"; } $function.=strtolower($txt["writer"]); } if ($wane_actor>0){ $func.="a"; if (strlen($function)>2){ $function.=", "; } if (($wane_actor>$wane_director) && ($wane_actor>$wane_writer)){ $mainfunction="actor"; } if($gender>1){ $function.=strtolower($txt["actress"]); }else{ $function.=strtolower($txt["actor"]); } } if ($wane_composer>0){ $func.="c"; if (strlen($function)>2){ $function.=", "; } if (($wane_composer>$wane_director) && ($wane_composer>$wane_actor) && ($wane_composer>$wane_writer)){ $mainfunction="composer"; } $function.=strtolower($txt["composer"]); } if ($wane_author>0){ $func.="t"; if (strlen($function)>2){ $function.=", "; } if (($wane_author>$wane_director) && ($wane_author>$wane_actor) && ($wane_author>$wane_writer) && ($wane_author>$wane_composer)){ $mainfunction="author"; } $function.=strtolower($txt["author"]); } $function.=" )"; print $function; ?>
| "; print " | "; if($_SESSION['belepett'] == true){ if($nickfav>0){ $isFavPerson="favPersonActive"; $favPersonTitle=$txt['delete_from_favourites']; }else{ $favPersonTitle=$txt['add_to_favourites']; } $favpersonajaxbutton="favPersonAjaxButton"; $numberOfFavPersonsId="numberOfFavPersons"; }else{ $favpersonajaxbutton="favPersonAjaxButtonNo"; $favPersonTitle=$txt['add_to_favourites']; $numberOfFavPersonsId="numberOfFavPersonsNo"; } $parancs = "SELECT DISTINCT nick FROM favpersons WHERE person_id='".$person_id."' AND userid IN (".$_SESSION['active_list_userids'].")"; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $numberOfFavPersons=mysql_num_rows($eredmeny); if($numberOfFavPersons<1){ $numberOfFavPersons="0"; } print " ";
print " ". $numberOfFavPersons." ".$txt['members']." ".$txt['marked_as_favourite']."\" class='hastipButton'>".ucfirst(strtolower($txt['favourite']))." [".$numberOfFavPersons."] ";
print " | ";
print " ";
}
print ""; print" ";
//print" ";
print" ";
print " ![]() "; print " | ";
?>
".$release_year.". ".$release_month." ".$release_day.".";
}else{
$release_date="".$release_day." ".$release_month." ".$release_year."";
}
}
return $release_date;
}
print "";
print " "; if($dob>0 || $birthplace>0 || strlen($birthname)){ echo " ".$txt['born'].": "; if(strlen($birthname)>0){ echo "".$birthname." "; } //echo "1988.12.23., Ausztria "; echo "".getProperDate($dob,true); if($birthplace>0){ $parancs = "SELECT ".$lng."_sta FROM loc_sta WHERE id =" . $birthplace ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor = mysql_fetch_array($eredmeny)) { $bp= $sor[$lng.'_sta']; } echo ", ".$bp.""; } echo " "; if($age>0){ echo "".getAge($age)." "; } } if($dod>0){ echo "".$txt['died'].": "; echo "".getProperDate($dod,false)." "; if($d_age>0){ echo "".getAge($d_age)." "; } } print ""; print " | ";
print ""; print " |