";
echo "![](/i/full/".$filename.")
";
echo "
";
echo "";
echo "".$copyright."";
echo "
";
echo "";
echo " ";
echo "
";
echo "";
echo " ";
echo "
";
echo "";
echo " ";
echo "
";
echo "";
//FORRÁS ÉS COPYRIGHT
$parancs = "SELECT filmek.movie_id, year FROM movies filmek, image_connections kapocs WHERE (filmek.movie_id = kapocs.conn_id and kapocs.img_id='".$id."' AND kapocs.conn_type='1') " ;
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
if(mysql_num_rows($eredmeny)>0){
while ( $sor = mysql_fetch_array($eredmeny)){
$movie_id=$sor['movie_id'];
$year=$sor['year'];
$langtagname=$lng."_tag_name";
$parancs = "SELECT ".$langtagname.", cimkek.tag_id FROM tags cimkek, movie_tags filmcimkek WHERE cimkek.tag_id=filmcimkek.tag_id AND cimkek.category='2' AND filmcimkek.movie_id =" . $movie_id ;
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
$studiolist=" ".$year." ";
if ( $sor2 = mysql_fetch_array($eredmeny)) {
do {
if(strlen($studiolist)>2){
$studiolist.=", ";
}
$studiolist .= "".$sor2[$langtagname]."";
} while ( $sor2 = mysql_fetch_array($eredmeny));
}
}
}
echo "";
if(strlen($source_name)>0){
echo "
";
if(strlen($description)>2){
echo "".$txt['source'].": ";
echo "".$source_name."";
echo "
";
}
if(strlen($author)>0){
echo "";
}
if(strlen($studiolist)>0 || strlen($copyright)>0){
echo "";
echo "©".$studiolist;
if(strlen($copyright)>0){
if(strlen($studiolist)>0){
echo " ||";
}
echo " ".$copyright;
}
echo "
";
}
echo "";
echo $description;
echo "
";
}
if($_SESSION['role'] == 'admin'){
echo "";
print "  ";
print "  ";
print "  ";
print "  ";
print "  ";
echo " |
";
echo "
"; echo "";
echo "
";
echo "
";
}
///KAPCSOLODO FILMEK
$parancs = "SELECT hun_title, filmek.movie_id, title, season, year FROM movies filmek, image_connections kapocs WHERE (filmek.movie_id = kapocs.conn_id and kapocs.img_id='".$id."' AND kapocs.conn_type='1') ORDER BY filmek.year DESC, filmek.movie_id DESC " ;
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
if(mysql_num_rows($eredmeny)>0){
?>
"; echo "
![](pix/person/".$person_id.".jpg) | ";
echo " ";
echo "";
echo " ";
echo "".$name." "; if($_SESSION['role']=="admin"){ echo " ";
}
echo "".$txt["more_pictures"]." ";
echo " | ";
if($count%3==2){
echo "
".$txt["more_pictures"]."
";
if($_SESSION['role']=="admin"){
print "";
echo "
"; echo "";
echo "
";
echo "
";
}
//END KAPCSOLODO CIMKEK
//KAPCSOLODO KULTFIGURAK
$parancs = "SELECT szemelyek.id, ".$lng."_name FROM cult_characters szemelyek, image_connections kapocs WHERE (szemelyek.id= kapocs.conn_id and kapocs.img_id='".$id."' AND kapocs.conn_type='4') ORDER BY ".$lng."_name ASC " ;
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
$numofrows=mysql_num_rows($eredmeny);
if($numofrows>0){
echo ""; echo "
| ";
$count=0;
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
while ( $sor = mysql_fetch_array($eredmeny)){
//echo " ".$i.": ".$keys[$i] ." >> ".$values[$i]."db"; $tag_id=$sor['tag_id']; $name=$sor[$lng_tag_name]; echo " ".$name." ";
/* echo "";
echo "";
echo $name." "; */
}
echo " |
";
echo "
"; echo "";
echo "
";
echo "
";
}
//KOLLEKCIOK
$parancs="SELECT kollekciok.id, name, kollekciok.nick, COUNT(kepek.img_id) AS kepekszama FROM image_collections kollekciok LEFT OUTER JOIN image_coll_items kepek ON kepek.coll_id=kollekciok.id WHERE kepek.img_id='".$id."' GROUP BY kollekciok.id ORDER BY kollekciok.datetime DESC";
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
if(mysql_num_rows($eredmeny)){
echo ""; echo "
![](pix/cult_character/".$person_id.".jpg) ";
echo " | ";
echo "";
echo " ".$txt["more_pictures"]." ";
echo " | ";
if($count%3==2){
echo "
";
echo "
"; echo "";
while ( $sor = mysql_fetch_array($eredmeny)){
echo "
";
}
if($_SESSION['belepett']==true){
//HOZZAADAS KOLLEKCIOKHOZ
$parancs="SELECT kollekciok.id, name, kollekciok.nick FROM image_collections kollekciok LEFT OUTER JOIN image_coll_items kepek ON kepek.coll_id=kollekciok.id WHERE kollekciok.id NOT IN (SELECT coll_id FROM image_coll_items WHERE img_id='".$id."') AND kollekciok.nick='".$_SESSION['nick']."' GROUP BY kollekciok.id ORDER BY kollekciok.datetime DESC";
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
echo "
"; echo "
";
echo "  ".$sor['name']."";
if($_SESSION['nick']==$sor['nick']){
echo " ";
}
echo " | ";
echo "".$sor['nick']." | "; print("
";
echo "
"; echo "";
while ( $sor = mysql_fetch_array($eredmeny)){
echo "
";
}
?>
"; echo "
| ";
echo " ".$sor['name']."";
if($_SESSION['nick']==$sor['nick']){
//echo " ";
}
echo " | ";
//echo "".$sor['nick']." | "; echo "  | ";
print("
| ".$newcollectiontext." | ||