"; exit; header("Location: fresh.php"); die(); } while ( $sor = mysql_fetch_array($eredmeny)) { $name= $sor['name']; $dob= $sor['dob']; $dod= $sor['dod']; $gender= $sor['gender']; $birthplace= $sor['birthplace']; $birthname= $sor['birthname']; $facebook= $sor['facebook']; $twitter= $sor['twitter']; } $thisweeknumber = date('Y_W'); $typeid=4; $parancsviewlog = "INSERT INTO view_log (item_type, item_id, userid, week_id) SELECT \"". $typeid ."\", \"". $movie_id ."\", \"". $_SESSION['userid'] ."\", \"". $thisweeknumber ."\" FROM DUAL WHERE NOT EXISTS (SELECT item_type, item_id, userid, week_id FROM view_log WHERE (item_type=\"". $typeid ."\" AND item_id=\"".$movie_id."\" AND userid=\"".$_SESSION['userid']."\" AND week_id=\"".$thisweeknumber."\" )) ;" ; $eredmenyviewlog = mysql_query($parancsviewlog, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); if($dob>0 && $dod=="0000-00-00"){ $diff = abs(strtotime($datetime) - strtotime($dob)); $age = floor($diff / (365*60*60*24)); } if($dob>0 && $dod>0){ $diff = abs(strtotime($dod) - strtotime($dob)); $d_age = floor($diff / (365*60*60*24)); } ?> " . $name . " - FilmO"; print ""; print ""; ?>

"; 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; ?>

0) { $nickcheckquery= "SELECT COUNT(person_id) FROM favpersons WHERE person_id='" . $person_id . "' AND nick='" . $_SESSION['nick'] . "' " ; $nickcheckresult = mysql_query($nickcheckquery) or die(mysql_error()); while($nickrow = mysql_fetch_array($nickcheckresult)){ $nickfav=$nickrow['COUNT(person_id)']; } } print ""; print ""; print ""; print ""; ?> ".$release_year.".".$release_month."".$release_day."."; }else{ $release_date="".$release_day."".$release_month."".$release_year.""; } } return $release_date; } print ""; print ""; print ""; $sorszam=0; print "
"; print "
"; if($wane_actor+$wane_director+$wane_composer+$wane_writer>0){ print "
"; echo "
"; //CAT holder /* if($cat!="com"){ echo "
"; } if($cat!="act"){ echo "
"; } if($cat!="wri"){ echo "
"; } if($cat!="dir"){ echo "
"; } */ echo "
"; echo "
"; $parancsimg = "SELECT szemelyek.person_id, name FROM persons szemelyek, image_connections kapocs WHERE (szemelyek.person_id= kapocs.conn_id and kapocs.conn_id='".$person_id."' AND kapocs.conn_type='2') ORDER BY name ASC " ; $eredmenyimg = mysql_query($parancsimg, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $numofpix=mysql_num_rows($eredmenyimg); $parancsvid = "SELECT szemelyek.person_id, name FROM persons szemelyek, video_connections kapocs WHERE (szemelyek.person_id= kapocs.conn_id and kapocs.conn_id='".$person_id."' AND kapocs.conn_type='2') ORDER BY name ASC " ; $eredmenyvid = mysql_query($parancsvid, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $numofvid=mysql_num_rows($eredmenyvid); if($numofvid>0){ echo "
"; } if($numofpix>0){ echo "
"; } echo "
"; echo "
"; echo "
"; //end CAT holder echo "
"; } print "
"; //ha wan rendezõként film if ($wane_director>0) { $parancs = "SELECT filmek.movie_id, title, hun_title, year, season, filmek.release_date, ROUND(AVG(movie_rate),1) AS avg_rate, COUNT(ertekeltek.movie_id) AS rate_num, ROUND(AVG(movie_rate),1) AS real_avg FROM director rendezo, movies filmek LEFT JOIN rate_movies ertekeltek ON filmek.movie_id= ertekeltek.movie_id AND ertekeltek.userid IN (".$_SESSION['active_list_userids'].") WHERE filmek.movie_id=rendezo.movie_id AND rendezo.person_id=".$person_id." GROUP BY filmek.movie_id ORDER BY year DESC;" ; print "

  ".$txt["as_director"]."

"; ?>
0){ $pieces = explode(" ", $datetime); $date=$pieces[0]; $currDate=$date; $time=$pieces[1]; $datepieces = explode("-", $date); $curryear=$datepieces[0]; $month=$datepieces[1]; $day=$datepieces[2]; while ( $sor = mysql_fetch_array($eredmeny)){ print "

".$sor['title']; if ($sor['season']>0){ echo " - ".$txt['season']." ".$sor['season']; } echo "

"; if($lng=="hun"){ print $sor['hun_title']; if ($sor['season']>0){ echo " - ".$sor['season'].".".$txt['season'].""; } }else{ print $sor['eng_title']; if ($sor['season']>0){ echo " - ".$txt['season']." ".$sor['season']; } } print " 

".$sor['year']."

"; print "
".$txt['average']."

".number_format($sor['real_avg'],1)."

".$sor['rate_num']." ".$txt['members']."
"; if($_SESSION['belepett']==true){ $notlogged1=""; $notlogged2=""; }else{ $notlogged1="no"; $notlogged2="No"; } print "
"; $thiswannasee=0; if($_SESSION['belepett']==true){ $parancs88 = "SELECT movie_id FROM wannasee WHERE movie_id='".$sor['movie_id']."' AND nick='".$_SESSION['nick']."' " ; $eredmeny88 = mysql_query($parancs88, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $thiswannasee=mysql_num_rows($eredmeny88); } $is_released=1; $to_release; if($sor['release_date']>$datetime){ $is_released=0; $to_release; $release_pieces = explode(" ", $sor['release_date']); $release_date=$release_pieces[0]; $diff = abs(strtotime($release_date) - strtotime($currDate)); $to_release = floor($diff / (60*60*24)); $release_datepieces = explode("-", $release_date); $release_year=$release_datepieces[0]; $release_nummonth=$release_datepieces[1]; $release_day=$release_datepieces[2]; switch ($release_nummonth) { case 01: $release_month=$txt["january"]; break; case 02: $release_month=$txt["february"]; break; case 03: $release_month=$txt["march"]; break; case 04: $release_month=$txt["april"]; break; case 05: $release_month=$txt["may"]; break; case 06: $release_month=$txt["june"]; break; case 07: $release_month=$txt["july"]; break; case 8: $release_month=$txt["august"]; break; case 9: $release_month=$txt["september"]; break; case 10: $release_month=$txt["october"]; break; case 11: $release_month=$txt["november"]; break; case 12: $release_month=$txt["december"]; break; } if ($lng=="hun"){ $release_date=$release_year.". ".$release_month." ".$release_day."."; }else{ $release_date=$release_day." ".$release_month." ".$release_year; } } if($_SESSION['belepett']==true){ $parancs99 = "SELECT movie_rate FROM rate_movies WHERE movie_id='".$sor['movie_id']."' AND nick='".$_SESSION['nick']."' " ; $eredmeny99 = mysql_query($parancs99, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $thismovierate=0; while ( $sor99 = mysql_fetch_array($eredmeny99)){ $thismovierate=$sor99['movie_rate']; } } if($is_released>0){ for($r=5;$r>=1;$r--){ print "
"; } } print "
"; if($is_released==0){ if ($lng=="hun"){ echo "
"; echo "".$txt['premiere'].": ".$to_release." nap
"; }else{ echo "
"; echo "".$txt['premiere'].": ".$to_release." days
"; } } print "
"; print "
"; $sorszam++; } } print "
"; } //ha wan íróként film if ($wane_writer>0) { $parancs = "SELECT filmek.movie_id, title, hun_title, year, season, filmek.release_date, AVG(movie_rate) AS avg_rate, COUNT(ertekeltek.movie_id) AS rate_num, ROUND(AVG(movie_rate),1) AS real_avg FROM writer iro, movies filmek LEFT JOIN rate_movies ertekeltek ON filmek.movie_id= ertekeltek.movie_id AND ertekeltek.userid IN (".$_SESSION['active_list_userids'].") WHERE filmek.movie_id=iro.movie_id AND iro.person_id=".$person_id." GROUP BY filmek.movie_id ORDER BY year DESC;" ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); print "

  ".$txt["as_writer"]."

"; ?>
0){ $pieces = explode(" ", $datetime); $date=$pieces[0]; $currDate=$date; $time=$pieces[1]; $datepieces = explode("-", $date); $curryear=$datepieces[0]; $month=$datepieces[1]; $day=$datepieces[2]; while ( $sor = mysql_fetch_array($eredmeny)){ print "

".$sor['title']; if ($sor['season']>0){ echo " - ".$txt['season']." ".$sor['season']; } echo "

"; if($lng=="hun"){ print $sor['hun_title']; if ($sor['season']>0){ echo " - ".$sor['season'].".".$txt['season'].""; } }else{ print $sor['eng_title']; if ($sor['season']>0){ echo " - ".$txt['season']." ".$sor['season']; } } print " 

".$sor['year']."

"; print "
".$txt['average']."

".number_format($sor['real_avg'],1)."

".$sor['rate_num']." ".$txt['members']."
"; if($_SESSION['belepett']==true){ $notlogged1=""; $notlogged2=""; }else{ $notlogged1="no"; $notlogged2="No"; } print "
"; $thiswannasee=0; if($_SESSION['belepett']==true){ $parancs88 = "SELECT movie_id FROM wannasee WHERE movie_id='".$sor['movie_id']."' AND nick='".$_SESSION['nick']."' " ; $eredmeny88 = mysql_query($parancs88, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $thiswannasee=mysql_num_rows($eredmeny88); } $is_released=1; $to_release; if($sor['release_date']>$datetime){ $is_released=0; $to_release; $release_pieces = explode(" ", $sor['release_date']); $release_date=$release_pieces[0]; $diff = abs(strtotime($release_date) - strtotime($currDate)); $to_release = floor($diff / (60*60*24)); $release_datepieces = explode("-", $release_date); $release_year=$release_datepieces[0]; $release_nummonth=$release_datepieces[1]; $release_day=$release_datepieces[2]; switch ($release_nummonth) { case 01: $release_month=$txt["january"]; break; case 02: $release_month=$txt["february"]; break; case 03: $release_month=$txt["march"]; break; case 04: $release_month=$txt["april"]; break; case 05: $release_month=$txt["may"]; break; case 06: $release_month=$txt["june"]; break; case 07: $release_month=$txt["july"]; break; case 8: $release_month=$txt["august"]; break; case 9: $release_month=$txt["september"]; break; case 10: $release_month=$txt["october"]; break; case 11: $release_month=$txt["november"]; break; case 12: $release_month=$txt["december"]; break; } if ($lng=="hun"){ $release_date=$release_year.". ".$release_month." ".$release_day."."; }else{ $release_date=$release_day." ".$release_month." ".$release_year; } } if($_SESSION['belepett']==true){ $parancs99 = "SELECT movie_rate FROM rate_movies WHERE movie_id='".$sor['movie_id']."' AND nick='".$_SESSION['nick']."' " ; $eredmeny99 = mysql_query($parancs99, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $thismovierate=0; while ( $sor99 = mysql_fetch_array($eredmeny99)){ $thismovierate=$sor99['movie_rate']; } } if($is_released>0){ for($r=5;$r>=1;$r--){ print "
"; } } print "
"; if($is_released==0){ if ($lng=="hun"){ echo "
"; echo "".$txt['premiere'].": ".$to_release." nap
"; }else{ echo "
"; echo "".$txt['premiere'].": ".$to_release." days
"; } } print "
"; print "
"; $sorszam++; } } print "
"; } //ha wan színészként film if ($wane_actor>0) { $parancs = "SELECT id, filmek.movie_id, title, hun_title, year, season, ".$lng."_role_name, cult_id, voice, voice_lang, filmek.release_date, AVG(movie_rate) AS avg_rate, COUNT(ertekeltek.movie_id) AS rate_num, ROUND(AVG(movie_rate),1) AS real_avg FROM actor szinesz, movies filmek LEFT JOIN rate_movies ertekeltek ON filmek.movie_id= ertekeltek.movie_id AND ertekeltek.userid IN (".$_SESSION['active_list_userids'].") WHERE filmek.movie_id=szinesz.movie_id AND szinesz.person_id=".$person_id." AND voice_lang!='hun' GROUP BY filmek.movie_id ORDER BY year DESC;" ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); print "

  ".$txt["as_actor"]."

"; ?>
0){ $pieces = explode(" ", $datetime); $date=$pieces[0]; $currDate=$date; $time=$pieces[1]; $datepieces = explode("-", $date); $curryear=$datepieces[0]; $month=$datepieces[1]; $day=$datepieces[2]; while ( $sor = mysql_fetch_array($eredmeny)){ print "

".$sor['title']; if ($sor['season']>0){ echo " - ".$txt['season']." ".$sor['season']; } echo "

"; if($lng=="hun"){ print $sor['hun_title']; if ($sor['season']>0){ echo " - ".$sor['season'].".".$txt['season'].""; } }else{ print $sor['eng_title']; if ($sor['season']>0){ echo " - ".$txt['season']." ".$sor['season']; } } print " 

".$sor['year']."

"; print "
".$txt['average']."

".number_format($sor['real_avg'],1)."

".$sor['rate_num']." ".$txt['members']."
"; if($_SESSION['belepett']==true){ $notlogged1=""; $notlogged2=""; }else{ $notlogged1="no"; $notlogged2="No"; } print "
"; $thiswannasee=0; if($_SESSION['belepett']==true){ $parancs88 = "SELECT movie_id FROM wannasee WHERE movie_id='".$sor['movie_id']."' AND nick='".$_SESSION['nick']."' " ; $eredmeny88 = mysql_query($parancs88, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $thiswannasee=mysql_num_rows($eredmeny88); } $is_released=1; $to_release; if($sor['release_date']>$datetime){ $is_released=0; $to_release; $release_pieces = explode(" ", $sor['release_date']); $release_date=$release_pieces[0]; $diff = abs(strtotime($release_date) - strtotime($currDate)); $to_release = floor($diff / (60*60*24)); $release_datepieces = explode("-", $release_date); $release_year=$release_datepieces[0]; $release_nummonth=$release_datepieces[1]; $release_day=$release_datepieces[2]; switch ($release_nummonth) { case 01: $release_month=$txt["january"]; break; case 02: $release_month=$txt["february"]; break; case 03: $release_month=$txt["march"]; break; case 04: $release_month=$txt["april"]; break; case 05: $release_month=$txt["may"]; break; case 06: $release_month=$txt["june"]; break; case 07: $release_month=$txt["july"]; break; case 8: $release_month=$txt["august"]; break; case 9: $release_month=$txt["september"]; break; case 10: $release_month=$txt["october"]; break; case 11: $release_month=$txt["november"]; break; case 12: $release_month=$txt["december"]; break; } if ($lng=="hun"){ $release_date=$release_year.". ".$release_month." ".$release_day."."; }else{ $release_date=$release_day." ".$release_month." ".$release_year; } } if($_SESSION['belepett']==true){ $parancs99 = "SELECT movie_rate FROM rate_movies WHERE movie_id='".$sor['movie_id']."' AND nick='".$_SESSION['nick']."' " ; $eredmeny99 = mysql_query($parancs99, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $thismovierate=0; while ( $sor99 = mysql_fetch_array($eredmeny99)){ $thismovierate=$sor99['movie_rate']; } } if($is_released>0){ for($r=5;$r>=1;$r--){ print "
"; } } print "
"; if($is_released==0){ if ($lng=="hun"){ echo "
"; echo "".$txt['premiere'].": ".$to_release." nap
"; }else{ echo "
"; echo "".$txt['premiere'].": ".$to_release." days
"; } } print "
"; //rolenameDiv echo "
"; if(strlen($sor[$lng."_role_name"])>25 || (strlen($sor[$lng."_role_name"])>20 && $sor['cult_id']>0)){ $longRoleName=" hastipButton' title=\"".$sor[$lng."_role_name"]."\""; }else{ $longRoleName="'"; } echo "0){ print " "; } print $sor[$lng."_role_name"]; if ($sor['voice']>0){ print " ["; if ($sor['voice_lang']=='hun'){ print "magyar "; } print $txt['voice']."]"; } if ($sor['cult_id']>0){ print ""; } //ha tobb karakter es az egyik kult if ($sor['cult_id']>0){ $parancs360 = "SELECT ".$lng."_role_name, leadrole, cult_id, voice, voice_lang FROM actor szinesz WHERE szinesz.person_id='".$person_id."' AND szinesz.movie_id=".$sor['movie_id']." AND id!='".$sor['id']."' ORDER BY voice_lang ASC, leadrole DESC, cult_id DESC;" ; $eredmeny360 = mysql_query($parancs360, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); if(mysql_num_rows($eredmeny360)>0){ echo " ..."; } /* while ( $sor360 = mysql_fetch_array($eredmeny360)) { echo "
"; if ($sor360['cult_id']>0){ print " "; } print $sor['role_name']; // ". eval('\$sor360['role_name'] = \'$sor360['role_name']\';'); if ($sor360['voice']>0){ print " ["; if ($sor360['voice_lang']=='hun'){ print "magyar "; } print $txt['voice']."]"; } } */ } echo "
"; echo "
"; //end of rolenemaDiv print "
"; $sorszam++; } } print "
"; } //ha wan MAGYARszinkronosként film if ($wane_szinkron>0 && $lng=='hun') { $parancs = "SELECT filmek.movie_id, title, hun_title, year, season, ".$lng."_role_name, cult_id, voice, voice_lang, filmek.release_date, AVG(movie_rate) AS avg_rate, COUNT(ertekeltek.movie_id) AS rate_num, ROUND(AVG(movie_rate),1) AS real_avg FROM actor szinesz, movies filmek LEFT JOIN rate_movies ertekeltek ON filmek.movie_id= ertekeltek.movie_id AND ertekeltek.userid IN (".$_SESSION['active_list_userids'].") WHERE filmek.movie_id=szinesz.movie_id AND szinesz.person_id=".$person_id." AND voice_lang='hun' GROUP BY filmek.movie_id ORDER BY year DESC;" ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); print "

  SZINKRON".$txt["as_actor"]."

"; ?>
0){ $pieces = explode(" ", $datetime); $date=$pieces[0]; $currDate=$date; $time=$pieces[1]; $datepieces = explode("-", $date); $curryear=$datepieces[0]; $month=$datepieces[1]; $day=$datepieces[2]; while ( $sor = mysql_fetch_array($eredmeny)){ print "

".$sor['title']; if ($sor['season']>0){ echo " - ".$txt['season']." ".$sor['season']; } echo "

"; if($lng=="hun"){ print $sor['hun_title']; if ($sor['season']>0){ echo " - ".$sor['season'].".".$txt['season'].""; } }else{ print $sor['eng_title']; if ($sor['season']>0){ echo " - ".$txt['season']." ".$sor['season']; } } print " 

".$sor['year']."

"; print "
".$txt['average']."

".number_format($sor['real_avg'],1)."

".$sor['rate_num']." ".$txt['members']."
"; if($_SESSION['belepett']==true){ $notlogged1=""; $notlogged2=""; }else{ $notlogged1="no"; $notlogged2="No"; } print "
"; $thiswannasee=0; if($_SESSION['belepett']==true){ $parancs88 = "SELECT movie_id FROM wannasee WHERE movie_id='".$sor['movie_id']."' AND nick='".$_SESSION['nick']."' " ; $eredmeny88 = mysql_query($parancs88, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $thiswannasee=mysql_num_rows($eredmeny88); } $is_released=1; $to_release; if($sor['release_date']>$datetime){ $is_released=0; $to_release; $release_pieces = explode(" ", $sor['release_date']); $release_date=$release_pieces[0]; $diff = abs(strtotime($release_date) - strtotime($currDate)); $to_release = floor($diff / (60*60*24)); $release_datepieces = explode("-", $release_date); $release_year=$release_datepieces[0]; $release_nummonth=$release_datepieces[1]; $release_day=$release_datepieces[2]; switch ($release_nummonth) { case 01: $release_month=$txt["january"]; break; case 02: $release_month=$txt["february"]; break; case 03: $release_month=$txt["march"]; break; case 04: $release_month=$txt["april"]; break; case 05: $release_month=$txt["may"]; break; case 06: $release_month=$txt["june"]; break; case 07: $release_month=$txt["july"]; break; case 8: $release_month=$txt["august"]; break; case 9: $release_month=$txt["september"]; break; case 10: $release_month=$txt["october"]; break; case 11: $release_month=$txt["november"]; break; case 12: $release_month=$txt["december"]; break; } if ($lng=="hun"){ $release_date=$release_year.". ".$release_month." ".$release_day."."; }else{ $release_date=$release_day." ".$release_month." ".$release_year; } } if($_SESSION['belepett']==true){ $parancs99 = "SELECT movie_rate FROM rate_movies WHERE movie_id='".$sor['movie_id']."' AND nick='".$_SESSION['nick']."' " ; $eredmeny99 = mysql_query($parancs99, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $thismovierate=0; while ( $sor99 = mysql_fetch_array($eredmeny99)){ $thismovierate=$sor99['movie_rate']; } } if($is_released>0){ for($r=5;$r>=1;$r--){ print "
"; } } print "
"; if($is_released==0){ if ($lng=="hun"){ echo "
"; echo "".$txt['premiere'].": ".$to_release." nap
"; }else{ echo "
"; echo "".$txt['premiere'].": ".$to_release." days
"; } } print "
"; //rolenameDiv echo "
"; if(strlen($sor[$lng."_role_name"])>25 || (strlen($sor[$lng."_role_name"])>20 && $sor['cult_id']>0)){ $longRoleName=" hastipButton' title=\"".$sor[$lng."_role_name"]."\""; }else{ $longRoleName="'"; } echo "0){ print " "; } print $sor[$lng."_role_name"]; if ($sor['voice']>0){ print " ["; if ($sor['voice_lang']=='hun'){ print "magyar "; } print $txt['voice']."]"; } if ($sor['cult_id']>0){ print ""; } echo ""; echo "
"; //end of rolenemaDiv print "
"; $sorszam++; } } print "
"; } //ha wan zeneszerzõként film if ($wane_composer>0) { $parancs = "SELECT filmek.movie_id, title, hun_title, year, season, filmek.release_date, AVG(movie_rate) AS avg_rate, COUNT(ertekeltek.movie_id) AS rate_num, ROUND(AVG(movie_rate),1) AS real_avg FROM composer zeneszerzo, movies filmek LEFT JOIN rate_movies ertekeltek ON filmek.movie_id= ertekeltek.movie_id AND ertekeltek.userid IN (".$_SESSION['active_list_userids'].") WHERE filmek.movie_id=zeneszerzo.movie_id AND zeneszerzo.person_id=".$person_id." GROUP BY filmek.movie_id ORDER BY year DESC;" ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); print "

  ".$txt["as_composer"]."

"; ?>
0){ $pieces = explode(" ", $datetime); $date=$pieces[0]; $currDate=$date; $time=$pieces[1]; $datepieces = explode("-", $date); $curryear=$datepieces[0]; $month=$datepieces[1]; $day=$datepieces[2]; while ( $sor = mysql_fetch_array($eredmeny)){ print "

".$sor['title']; if ($sor['season']>0){ echo " - ".$txt['season']." ".$sor['season']; } echo "

"; if($lng=="hun"){ print $sor['hun_title']; if ($sor['season']>0){ echo " - ".$sor['season'].".".$txt['season'].""; } }else{ print $sor['eng_title']; if ($sor['season']>0){ echo " - ".$txt['season']." ".$sor['season']; } } print " 

".$sor['year']."

"; print "
".$txt['average']."

".number_format($sor['real_avg'],1)."

".$sor['rate_num']." ".$txt['members']."
"; if($_SESSION['belepett']==true){ $notlogged1=""; $notlogged2=""; }else{ $notlogged1="no"; $notlogged2="No"; } print "
"; $thiswannasee=0; if($_SESSION['belepett']==true){ $parancs88 = "SELECT movie_id FROM wannasee WHERE movie_id='".$sor['movie_id']."' AND nick='".$_SESSION['nick']."' " ; $eredmeny88 = mysql_query($parancs88, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $thiswannasee=mysql_num_rows($eredmeny88); } $is_released=1; $to_release; if($sor['release_date']>$datetime){ $is_released=0; $to_release; $release_pieces = explode(" ", $sor['release_date']); $release_date=$release_pieces[0]; $diff = abs(strtotime($release_date) - strtotime($currDate)); $to_release = floor($diff / (60*60*24)); $release_datepieces = explode("-", $release_date); $release_year=$release_datepieces[0]; $release_nummonth=$release_datepieces[1]; $release_day=$release_datepieces[2]; switch ($release_nummonth) { case 01: $release_month=$txt["january"]; break; case 02: $release_month=$txt["february"]; break; case 03: $release_month=$txt["march"]; break; case 04: $release_month=$txt["april"]; break; case 05: $release_month=$txt["may"]; break; case 06: $release_month=$txt["june"]; break; case 07: $release_month=$txt["july"]; break; case 8: $release_month=$txt["august"]; break; case 9: $release_month=$txt["september"]; break; case 10: $release_month=$txt["october"]; break; case 11: $release_month=$txt["november"]; break; case 12: $release_month=$txt["december"]; break; } if ($lng=="hun"){ $release_date=$release_year.". ".$release_month." ".$release_day."."; }else{ $release_date=$release_day." ".$release_month." ".$release_year; } } if($_SESSION['belepett']==true){ $parancs99 = "SELECT movie_rate FROM rate_movies WHERE movie_id='".$sor['movie_id']."' AND nick='".$_SESSION['nick']."' " ; $eredmeny99 = mysql_query($parancs99, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $thismovierate=0; while ( $sor99 = mysql_fetch_array($eredmeny99)){ $thismovierate=$sor99['movie_rate']; } } if($is_released>0){ for($r=5;$r>=1;$r--){ print "
"; } } print "
"; if($is_released==0){ if ($lng=="hun"){ echo "
"; echo "".$txt['premiere'].": ".$to_release." nap
"; }else{ echo "
"; echo "".$txt['premiere'].": ".$to_release." days
"; } } print "
"; print "
"; $sorszam++; } } print "
"; } print "
"; print "
"; $sorszam=0; //ha wan szerzõként film if ($wane_author>0) { $parancs = "SELECT konyvek.book_id, title, hun_title, year, AVG(book_rate) AS avg_rate, COUNT(ertekeltek.book_id) AS rate_num, ROUND(AVG(book_rate),1) AS real_avg FROM author szerzo, books konyvek LEFT JOIN rate_books ertekeltek ON konyvek.book_id= ertekeltek.book_id AND ertekeltek.userid IN (".$_SESSION['active_list_userids'].") WHERE konyvek.book_id=szerzo.book_id AND szerzo.person_id=".$person_id." GROUP BY konyvek.book_id ORDER BY year DESC;" ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); print "

  ".$txt["as_author"]."

"; ?>
0){ $pieces = explode(" ", $datetime); $date=$pieces[0]; $currDate=$date; $time=$pieces[1]; $datepieces = explode("-", $date); $curryear=$datepieces[0]; $month=$datepieces[1]; $day=$datepieces[2]; while ( $sor = mysql_fetch_array($eredmeny)){ print "

".$sor['title']."

"; if($lng=="hun"){ print $sor['hun_title']; }else{ print $sor['eng_title']; } print " 

".$sor['year']."

"; print "
".$txt['average']."

".number_format($sor['real_avg'],1)."

".$sor['rate_num']." ".$txt['members']."
"; if($_SESSION['belepett']==true){ $notlogged1=""; $notlogged2=""; }else{ $notlogged1="no"; $notlogged2="No"; } print "
"; $thiswannasee=0; if($_SESSION['belepett']==true){ $parancs88 = "SELECT book_id FROM wannaread WHERE book_id='".$sor['book_id']."' AND nick='".$_SESSION['nick']."' " ; $eredmeny88 = mysql_query($parancs88, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $thiswannasee=mysql_num_rows($eredmeny88); } $is_released=1; $to_release; if($sor['release_date']>$datetime){ $is_released=0; $to_release; $release_pieces = explode(" ", $sor['release_date']); $release_date=$release_pieces[0]; $diff = abs(strtotime($release_date) - strtotime($currDate)); $to_release = floor($diff / (60*60*24)); $release_datepieces = explode("-", $release_date); $release_year=$release_datepieces[0]; $release_nummonth=$release_datepieces[1]; $release_day=$release_datepieces[2]; switch ($release_nummonth) { case 01: $release_month=$txt["january"]; break; case 02: $release_month=$txt["february"]; break; case 03: $release_month=$txt["march"]; break; case 04: $release_month=$txt["april"]; break; case 05: $release_month=$txt["may"]; break; case 06: $release_month=$txt["june"]; break; case 07: $release_month=$txt["july"]; break; case 8: $release_month=$txt["august"]; break; case 9: $release_month=$txt["september"]; break; case 10: $release_month=$txt["october"]; break; case 11: $release_month=$txt["november"]; break; case 12: $release_month=$txt["december"]; break; } if ($lng=="hun"){ $release_date=$release_year.". ".$release_month." ".$release_day."."; }else{ $release_date=$release_day." ".$release_month." ".$release_year; } } if($_SESSION['belepett']==true){ $parancs99 = "SELECT book_rate FROM rate_books WHERE book_id='".$sor['book_id']."' AND nick='".$_SESSION['nick']."' " ; $eredmeny99 = mysql_query($parancs99, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $thisbookrate=0; while ( $sor99 = mysql_fetch_array($eredmeny99)){ $thisbookrate=$sor99['book_rate']; } } for($r=5;$r>=1;$r--){ print "
"; } print "
"; if($is_released==0){ if ($lng=="hun"){ echo "
"; echo "".$txt['premiere'].": ".$to_release." nap
"; }else{ echo "
"; echo "".$txt['premiere'].": ".$to_release." days
"; } } print "
"; print "
"; $sorszam++; } } print "
"; } //ha wan kapcsolodo konyv if ($wane_bookperson>0) { $parancs = "SELECT konyvek.book_id, title, hun_title, year, AVG(book_rate) AS avg_rate, COUNT(ertekeltek.book_id) AS rate_num, ROUND(AVG(book_rate),1) AS real_avg FROM bookperson szerzo, books konyvek LEFT JOIN rate_books ertekeltek ON konyvek.book_id= ertekeltek.book_id AND ertekeltek.userid IN (".$_SESSION['active_list_userids'].") WHERE konyvek.book_id=szerzo.book_id AND szerzo.person_id=".$person_id." GROUP BY konyvek.book_id ORDER BY year DESC;" ; //$parancs = "SELECT konyvek.book_id, title, hun_title, year, real_avg, rate_num FROM books konyvek, bookperson konyvbeli WHERE konyvek.book_id=konyvbeli.book_id AND konyvbeli.person_id=".$person_id." ORDER BY year DESC;" ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); print "

  ".$txt["related_books"]."

"; ?>
0){ $pieces = explode(" ", $datetime); $date=$pieces[0]; $currDate=$date; $time=$pieces[1]; $datepieces = explode("-", $date); $curryear=$datepieces[0]; $month=$datepieces[1]; $day=$datepieces[2]; while ( $sor = mysql_fetch_array($eredmeny)){ print "

".$sor['title']."

"; if($lng=="hun"){ print $sor['hun_title']; }else{ print $sor['eng_title']; } print " 

".$sor['year']."

"; print "
".$txt['average']."

".number_format($sor['real_avg'],1)."

".$sor['rate_num']." ".$txt['members']."
"; if($_SESSION['belepett']==true){ $notlogged1=""; $notlogged2=""; }else{ $notlogged1="no"; $notlogged2="No"; } print "
"; $thiswannasee=0; if($_SESSION['belepett']==true){ $parancs88 = "SELECT book_id FROM wannaread WHERE book_id='".$sor['book_id']."' AND nick='".$_SESSION['nick']."' " ; $eredmeny88 = mysql_query($parancs88, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $thiswannasee=mysql_num_rows($eredmeny88); } $is_released=1; $to_release; if($sor['release_date']>$datetime){ $is_released=0; $to_release; $release_pieces = explode(" ", $sor['release_date']); $release_date=$release_pieces[0]; $diff = abs(strtotime($release_date) - strtotime($currDate)); $to_release = floor($diff / (60*60*24)); $release_datepieces = explode("-", $release_date); $release_year=$release_datepieces[0]; $release_nummonth=$release_datepieces[1]; $release_day=$release_datepieces[2]; switch ($release_nummonth) { case 01: $release_month=$txt["january"]; break; case 02: $release_month=$txt["february"]; break; case 03: $release_month=$txt["march"]; break; case 04: $release_month=$txt["april"]; break; case 05: $release_month=$txt["may"]; break; case 06: $release_month=$txt["june"]; break; case 07: $release_month=$txt["july"]; break; case 8: $release_month=$txt["august"]; break; case 9: $release_month=$txt["september"]; break; case 10: $release_month=$txt["october"]; break; case 11: $release_month=$txt["november"]; break; case 12: $release_month=$txt["december"]; break; } if ($lng=="hun"){ $release_date=$release_year.". ".$release_month." ".$release_day."."; }else{ $release_date=$release_day." ".$release_month." ".$release_year; } } if($_SESSION['belepett']==true){ $parancs99 = "SELECT book_rate FROM rate_books WHERE book_id='".$sor['book_id']."' AND nick='".$_SESSION['nick']."' " ; $eredmeny99 = mysql_query($parancs99, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $thisbookrate=0; while ( $sor99 = mysql_fetch_array($eredmeny99)){ $thisbookrate=$sor99['book_rate']; } } for($r=5;$r>=1;$r--){ print "
"; } print "
"; if($is_released==0){ if ($lng=="hun"){ echo "
"; echo "".$txt['premiere'].": ".$to_release." nap
"; }else{ echo "
"; echo "".$txt['premiere'].": ".$to_release." days
"; } } print "
"; print "
"; $sorszam++; } } print "
"; } print "
"; if ($wane_actor==0 && $wane_director==0 && $wane_composer==0 && $wane_writer==0 && $wane_author==0 && $wane_bookperson==0){ print "

Valamilyen fura véletlen folytán nincs még film hozzá..

"; } ?>
0){ ?>
". $sor['review_title'].""; if($_SESSION['role']=='admin'){ print "X"; } print ""; } print "
"; print "
"; } if($_SESSION['role']=="admin"){ print "  "; } ?>
0){ if($lng=="hun"){ $listsinwhichtext="Listák, amikben szerepel"; }else{ $listsinwhichtext="Lists, where it appears"; } ?> "; echo ""; echo ""; echo "".$listsinwhichtext." [".$listnumber."]"; echo ""; echo ""; while ( $sor = mysql_fetch_array($eredmeny111)){ echo ""; echo ""; echo " ". $sor['name']; echo ""; echo ""; echo $sor['nick']; echo ""; echo ""; } echo ""; echo "
"; } $parancs222="SELECT poll_id, question,question_eng, szavazasok.owner, valaszok.datetime AS utolsodatum FROM polls szavazasok, poll_answers valaszok WHERE szavazasok.type=2 AND confirmed=1 AND valaszok.object_id='".$person_id."' AND szavazasok.id=valaszok.poll_id GROUP BY poll_id ORDER BY utolsodatum DESC"; $eredmeny222 = mysql_query($parancs222, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $pollnumber=mysql_num_rows($eredmeny222); if($pollnumber>0){ if($lng=="hun"){ $pollsinwhichtext="Szavazások, amikben szerepel"; }else{ $pollsinwhichtext="Polls, where it appears"; } ?> "; echo ""; echo ""; echo "".$pollsinwhichtext." [".$pollnumber."]"; echo ""; echo ""; while ( $sor = mysql_fetch_array($eredmeny222)){ echo ""; echo ""; echo "
". $sor['question']; echo ""; echo ""; } echo ""; echo "
"; } ?> 0 || strlen($twitter)>0){ echo "
"; if(strlen($facebook)>0){ if(strlen($twitter)>0){ $fbwidth="620px"; }else{ $fbwidth="820px"; } echo "
"; } if(strlen($twitter)>0){ if(strlen($facebook)>0){ $twiwidth="200px"; }else{ $twiwidth="820px;"; echo ""; } echo "
"; } echo "
"; } $topic_id="22".$person_id; $parancs = "SELECT topic_name FROM forum_topics WHERE topic_id ='" . $topic_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)) { $topic_name= $sor['topic_name']; } if(strlen($topic_name)>2){ $ajaxPostAction="ins"; }else{ $ajaxPostAction="new"; } ?> 66){ $image_src="pix/style/comment-big.png"; } $parancs = "SELECT ".$lng."_category_name FROM forum_categories WHERE category_id='".$cat."'"; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor = mysql_fetch_array($eredmeny)) { $category_name=$sor[$lng."_category_name"]; } ?>
">
"; print "
0000-00-00 00:00:00
"; print "

".$txt["be_the_first_to_write_in_this_topic"]."
"; print "
"; } while ( $sor = mysql_fetch_array($eredmeny)) { $useravatar="pix/useravatar/".str_replace("/","_",strtolower($sor['nick'])).".png"; if (file_exists($useravatar)) { $useravatar_src=$useravatar; }else{ $useravatar_src="pix/useravatar/default.png"; } $spoiler=""; if($sor['spoiler']>0){ $spoiler="spoiler"; } print "
"; print "
".$sor['datetime']."
"; if($_SESSION['nick']==$sor['nick'] || $_SESSION['role']=="admin"){ print "
X
"; } if($sor['spoiler']>0){ print "
SPOILER
"; } print "
".$sor['nick']."
"; print "
".nl2br(preg_replace(" #((http|https|ftp)://(\S*?\.\S*?))(\s|\;|\)|\]|\[|\{|\}|,|\"|'|:|\<|$|\.\s)#ie", "'$3$4'", $sor['post']))."
"; //nl2br()---konvertalja a nemlathato sortoreseket print "
"; } if($post_rows==$post_num_limit){ print ""; } ?>
ImpO :: Ellenőrzés"; } ?> ".$txt["are_you_sure_you_delete"]."?
  "; print "
"; print "
"; print "
Megnezendo:
X
"; print ""; print "
"; print "
"; print "
Kérések:
X
"; print "
.
"; print "
"; ?>