"; exit; header("Location: fresh.php"); die(); } $thisweeknumber = date('Y_W'); $typeid=1; $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 ($movie_id==$max_movie_id){ $next_movie_id=1; }else{ $next_movie_id=$movie_id+1; } if ($movie_id==1){ $prev_movie_id=$max_movie_id; } else { $prev_movie_id=$movie_id-1; } //LNG a hianyzo elemek szekciohoz if ($lng=="hun"){ $lngtext_reporterror="Hiba jelzése"; $lngtext_missingitem="Hiányzó elem javaslat"; $lngtext_typeerrorhere="ÍRD IDE AZ ÉSZREVETT HIBÁT"; $lngtext_reason="INDOKLÁS"; $lngtext_starttypingperson="Kezdd el beírni a személy nevét"; $lngtext_starttypingtag="Kezdd el beírni a címkét"; $lngtext_taginstruction="FONTOS: csak olyan címkét javasolj, ami teljesen jellemzi a filmet (nem csak elhanyagolható mellékmotívumként jelenik meg)"; $lngtext_starttypinglocation="Kezdd el beírni a helyszínt"; $lngtext_locationinstruction="FONTOS: a lehetséges legpontosabb helyszínt add meg (pl. ha lehet tudni a várost is, akkor ne az országot. az automatikusan hozzaadódik a városhoz)"; $lngtext_typingtime="Írd ide, hogy mikor játszódik"; $lngtext_selectfunctions="Milyen funkciója van"; }else{ $lngtext_reporterror="Report Error"; $lngtext_missingitem="Missing Item"; $lngtext_typeerrorhere="TYPE HERE THE ERROR YOU SPOTTED"; $lngtext_reason="REASON"; $lngtext_starttypingperson="Start typing the name of the person"; $lngtext_starttypingtag="Start typing the tag"; $lngtext_taginstruction="IMPORTANT: please recommend only those tags, which are describing the movie/tv show mainly (and are not unimportant motifs)"; $lngtext_starttypinglocation="Start typing the location"; $lngtext_locationinstruction="IMPORTANT: please add the most precise location (eg. if you know the city, don't add the country (that will be autoatically added though the city)"; $lngtext_typingtime="Type here, when it is set"; $lngtext_selectfunctions="Select the roles"; } while ( $sor = mysql_fetch_array($eredmeny)) { $title= $sor['title']; $hun_title= $sor['hun_title']; $eng_title= $sor['eng_title']; $year= $sor['year']; $season= $sor['season']; $episodes= $sor['episodes']; $runtime= $sor['runtime']; $trailer= $sor['trailer']; $release= $sor['release_date']; $plot_eng=$sor['plot_eng']; $plot_hun=$sor['plot_hun']; } $poster = "pix/poster/".$movie_id.".jpg" ; $pagetitle=$title; if (strlen($hun_title)>0 && $hun_title!=$title){ $pagetitle.=" // ".$hun_title; } if (strlen($eng_title)>0 && $eng_title!=$title && $eng_title!=$hun_title){ $pagetitle.=" // ".$eng_title; } if ($season>0){ $pagetitle.=" - S" . $season; } $pagetitle.=" (".$year.") - FilmO"; /// datum es film mmegjelenes date_default_timezone_set('Europe/Budapest'); $datetime = date("Y-m-d G:i:s"); $pieces = explode(" ", $datetime); $date=$pieces[0]; $currDate=$date; $time=$pieces[1]; $datepieces = explode("-", $date); $curryear=$datepieces[0]; $month=$datepieces[1]; $day=$datepieces[2]; $is_released; $to_release; if($release>$datetime){ $is_released="false"; $release_pieces = explode(" ", $release); $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; } //TEST IMDB $url = "http://mymovieapi.com/?title=".urlencode($title)."&year=".$year."&type=json&plot=simple&episode=1&limit=1&yg=0&mt=none&lang=en-US&offset=&aka=simple&release=simple&business=0&tech=0"; //$contents = file_get_contents($url); //$imdbjson = json_decode($contents, true); //$imdbrating = $imdbjson[0]['rating']; $imdbrating = "?"; include 'effectarray.php'; $parancs555 = "SELECT * FROM effectmeter WHERE (movie_id='".$movie_id."') AND userid IN (".$_SESSION['active_list_userids'].") GROUP BY nick" ; $eredmeny555 = mysql_query($parancs555, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $effectfullnumuse=mysql_num_rows($eredmeny555); $effectfullnum=0; //echo $effectnum; $effnicksor=""; while ( $sor = mysql_fetch_array($eredmeny555)) { if(strlen($effnicksor)>0){ $effnicksor.=", "; } $effnicksor.=$sor["nick"]; foreach($effectarray as $effkey=>$effvalue) { //echo $effkey."_".$effvalue['num']."
"; if ($sor[$effkey]>0 ){ $effectarray[$effkey]['avgrate']=(($sor[$effkey]-1)*25)."%"; $effectfullnum++; }else if($sor[$effkey]==0){ $effectarray[$effkey]['avgrate']="0"; }else { $effectarray[$effkey]['avgrate']="---"; } } } ?> " . $pagetitle.""; ?> ";?>

".$txt["movie_of_the_week_p1"]."
".$txt["movie_of_the_week_p2"]."

"; } ?>
> ide mennek az üzik ?>

 

X 

"; print ""; print ""; */ print ""; print ""; print ""; print ""; print ""; if ($season>0){ $parancs6 = "SELECT episode FROM lastmovies WHERE movie_id =" . $movie_id ." AND nick='".$_SESSION['nick']."' ORDER BY datetime ASC"; $eredmeny6 = mysql_query($parancs6, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor = mysql_fetch_array($eredmeny6)) { $episode= $sor['episode']; } if($episode>0){ $parancs66 = "SELECT COUNT(DISTINCT episode) AS totalepisodes FROM lastmovies WHERE movie_id =" . $movie_id ." AND nick='".$_SESSION['nick']."' "; $eredmeny66 = mysql_query($parancs66, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor = mysql_fetch_array($eredmeny66)) { $totalepisodes= $sor['totalepisodes']; } } print ""; } ?> 0){ ?>

"; /* while ( $sor = mysql_fetch_array($eredmeny)){ $wane=$sor['COUNT(movie_id)']; } */ $wane=mysql_num_rows($eredmeny); ?> "; if ($effectfullnum>0){ print "

".$effectfullnumuse."
"; } if ($wane>0){ print "
".$wane."
"; } if ($rewatchnum>0){ if($lng=="hun"){ $rewatch_text="Újranézné"; }else{ $rewatch_text="Re-watch listed"; } print "
".$rewatchnum."
"; } ?>

0){ if ($lng=="hun" && $hun_title==$title){ print " - " . $season . ".".$txt['season']." "; }else{ print " - Season " . $season; } } ?>

"; if($lng=="hun"){ if (strlen($hun_title)>0 && $hun_title!=$title){ print $hun_title ; } } if($lng=="eng"){ if (strlen($eng_title)>0 && $eng_title!=$title){ print $eng_title ; } } if ($season>0 && $lng=="hun" && $hun_title!=$title){ print " - " . $season . ".".$txt['season']." "; } if($lng=="hun" && strlen($eng_title)>0 && $eng_title!=$title){ print " * " ; } print "

" ; ?> (". $year .")

" ; //átlagértékelés print "
"; include 'movieaverageratevotes.php'; print "
"; //HASONLOSAGHOZ $sub_array=array(); //---KAPCSOK - REMAKE-ek $langsequelname=$lng."_sequel_name"; $parancs = "SELECT kapcsok.id, $langsequelname,start_year FROM connected_movies kapocsfilmek, connectors kapcsok WHERE (kapocsfilmek.movie_id='".$movie_id."' AND kapocsfilmek.connector_id=kapcsok.id AND type='3') GROUP BY kapcsok.id"; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $remakedarab=0; $remakesor=array(); $remakenamesor=array(); $remakestartsor=array(); while ( $sor = mysql_fetch_array($eredmeny)) { $remakedarab++; $remakesor[$remakedarab]=$sor['id']; $remakestartsor[$remakedarab]=$sor['start_year']; $remakenamesor[$remakedarab]=$sor[$langsequelname]; } if ($remakedarab>0){ for ($i = 1; $i <= $remakedarab; $i++){ $remakeid=$remakesor[$i]; $remakename=$remakenamesor[$i]; if($remakestartsor[$i]>0){ //$remakename.=" (".$remakestartsor[$i].")"; }else{ $remakestart=""; } $parancs = "SELECT hun_title, filmek.movie_id, title, season, year FROM movies filmek, connected_movies kapocsfilmek WHERE (filmek.movie_id = kapocsfilmek.movie_id AND kapocsfilmek.connector_id=\"".$remakeid."\" ) ORDER BY year ASC , filmek.movie_id ASC"; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $remakesout=""; while ( $sor = mysql_fetch_array($eredmeny)) { $evad=""; if ($lng=="hun"){ if ($sor['season']>0){ //$evad=" - ".$sor['season'].".".$txt['season'].""; $evad=" [".strtolower($txt['serie'])."]"; } if ($sor['movie_id']!=$movie_id){ $remakesout .= " >>  ".str_replace(" ", " ", $sor['hun_title']).$evad." (".$sor['year'].")  "; //HASONLOSAGHOZ $sub_array[]=$sor['movie_id']; }else { $remakesout .= " >> ".str_replace(" ", " ", $sor['hun_title']).$evad." (".$sor['year'].")  "; } }else{ if ($sor['season']>0){ //$evad=" -  Season".$sor['season'].""; $evad=" [".strtolower($txt['serie'])."]"; } if ($sor['movie_id']!=$movie_id){ $remakesout .= " >>  ".str_replace(" ", " ", $sor['title']).$evad." (".$sor['year'].")  "; }else { $remakesout .= " >> ".str_replace(" ", " ", $sor['title']).$evad." (".$sor['year'].")  "; } } } $aktuallabel=str_ireplace("á", "a" , strtolower($remakeid)); $aktuallabel=str_ireplace("é", "e" , $aktuallabel); $aktuallabel=str_ireplace("í", "i" , $aktuallabel); $aktuallabel=str_ireplace("ó", "o" , $aktuallabel); $aktuallabel=str_ireplace("ú", "u" , $aktuallabel); $aktuallabel=str_ireplace("ü", "u" , $aktuallabel); $aktuallabel=str_ireplace("û", "u" , $aktuallabel); $aktuallabel=str_ireplace("ö", "o" , $aktuallabel); $aktuallabel=str_ireplace("õ", "o" , $aktuallabel); $labelpic = "pix/style/remake.png" ; if (file_exists($labelpic)) { $pictitle=$remakename; $remake = ""; } else{ $remake = $remakename; } print ""; print "
"; } } //---KAPCSOK - FOLYTATASRESZEK $langsequelname=$lng."_sequel_name"; $parancs = "SELECT kapcsok.id, $langsequelname,start_year FROM connected_movies kapocsfilmek, connectors kapcsok WHERE (kapocsfilmek.movie_id='".$movie_id."' AND kapocsfilmek.connector_id=kapcsok.id AND type='2') GROUP BY kapcsok.id"; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $sequeldarab=0; $sequelsor=array(); $sequelnamesor=array(); $sequelstartsor=array(); while ( $sor = mysql_fetch_array($eredmeny)) { $sequeldarab++; $sequelsor[$sequeldarab]=$sor['id']; $sequelstartsor[$sequeldarab]=$sor['start_year']; $sequelnamesor[$sequeldarab]=$sor[$langsequelname]; } if ($sequeldarab>0){ for ($i = 1; $i <= $sequeldarab; $i++){ $sequelid=$sequelsor[$i]; $sequelname=$sequelnamesor[$i]; if($sequelstartsor[$i]>0){ //$sequelname.=" (".$sequelstartsor[$i].")"; }else{ $sequelstart=""; } $parancs = "SELECT hun_title, filmek.movie_id, title, season, year FROM movies filmek, connected_movies kapocsfilmek WHERE (filmek.movie_id = kapocsfilmek.movie_id AND kapocsfilmek.connector_id=\"".$sequelid."\" ) ORDER BY year ASC , filmek.movie_id ASC"; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $sequelsout=""; while ( $sor = mysql_fetch_array($eredmeny)) { $evad=""; if ($lng=="hun"){ if ($sor['season']>0){ //$evad=" - ".$sor['season'].".".$txt['season'].""; $evad=" [".strtolower($txt['serie'])."]"; } if ($sor['movie_id']!=$movie_id){ $sequelsout .= " >>  ".str_replace(" ", " ", $sor['hun_title']).$evad." (".$sor['year'].")  "; }else { $sequelsout .= " >> ".str_replace(" ", " ", $sor['hun_title']).$evad." (".$sor['year'].")  "; } }else{ if ($sor['season']>0){ //$evad=" -  Season".$sor['season'].""; $evad=" [".strtolower($txt['serie'])."]"; } if ($sor['movie_id']!=$movie_id){ $sequelsout .= " >>  ".str_replace(" ", " ", $sor['title']).$evad." (".$sor['year'].")  "; //HASONLOSAGHOZ $sub_array[]=$sor['movie_id']; }else { $sequelsout .= " >> ".str_replace(" ", " ", $sor['title']).$evad." (".$sor['year'].")  "; } } } $aktuallabel=str_ireplace("á", "a" , strtolower($sequelid)); $aktuallabel=str_ireplace("é", "e" , $aktuallabel); $aktuallabel=str_ireplace("í", "i" , $aktuallabel); $aktuallabel=str_ireplace("ó", "o" , $aktuallabel); $aktuallabel=str_ireplace("ú", "u" , $aktuallabel); $aktuallabel=str_ireplace("ü", "u" , $aktuallabel); $aktuallabel=str_ireplace("û", "u" , $aktuallabel); $aktuallabel=str_ireplace("ö", "o" , $aktuallabel); $aktuallabel=str_ireplace("õ", "o" , $aktuallabel); $labelpic = "pix/connectoricon/".$aktuallabel.".png" ; if (file_exists($labelpic)) { $pictitle=$sequelname; $sequel = ""; } else{ $sequel = $sequelname; } print ""; print "
"; } } //tovabbi evadok $exclude_array=array(); //HASONLO FILMEKNEL EZEKET NEM ADJA A TALALATOKHOZ if ($season>0){ $status; //KAPOCS LEKERDEZES $parancs99 = "SELECT kapcsok.id, tvdbid, status FROM connected_movies kapocsfilmek, connectors kapcsok WHERE (kapocsfilmek.movie_id='".$movie_id."' AND kapocsfilmek.connector_id=kapcsok.id AND type='1') GROUP BY kapcsok.id"; $eredmeny99 = mysql_query($parancs99, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor99 = mysql_fetch_array($eredmeny99)){ $status=$sor99['status']; $tvdbid=$sor99['tvdbid']; $connectorid=$sor99['id']; } if($tvdbid>0){ $episodelist=" "; } //$seasonparancs = "SELECT movie_id, title, season FROM movies WHERE season>0 AND season!=" . $season ." AND title=\"".$title."\" ORDER BY season ASC "; $seasonparancs = "SELECT hun_title, filmek.movie_id, title, season, year FROM movies filmek, connected_movies kapocsfilmek WHERE (filmek.movie_id = kapocsfilmek.movie_id AND kapocsfilmek.connector_id=\"".$connectorid."\" AND season>0 AND season!=" . $season .") ORDER BY year ASC , filmek.movie_id ASC"; $seasoneredmeny = mysql_query($seasonparancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); if ( $sor = mysql_fetch_array($seasoneredmeny)) { if($connectorid<1){ print "

".$txt['more_seasons_of_this_serie'].": "; }else{ print "

".$episodelist."".$txt['more_seasons_of_this_serie'].": "; } do { print "  " .$sor['season'] . ".   "; $exclude_array[]=$sor['movie_id']; } while ( $sor = mysql_fetch_array($seasoneredmeny)); print " "; if($connectorid<1){ if($_SESSION['role']=="admin"){ echo " KAPOCSHOZ ADÁS "; } }else{ if($lng=="hun"){ $txt_inprogress="Folyamatban"; $txt_onbreak="Szünetel"; $txt_cancelled="Elkaszált"; $txt_finished="Befejezett"; }else{ $txt_inprogress="In progress"; $txt_onbreak="On break"; $txt_cancelled="Cancelled"; $txt_finished="Finished"; } if($status=="1"){ echo " "; }else if($status=="2"){ echo " "; }else if($status=="3"){ echo " "; }else{ echo " "; } } echo "


"; } if(mysql_num_rows($seasoneredmeny)==0){ echo $episodelist; if($connectorid<1){ if($_SESSION['role']=="admin"){ echo " KAPOCSHOZ ADÁS "; } }else{ if($status=="1"){ echo " "; }else if($status=="2"){ echo " "; }else if($status=="3"){ echo " "; }else{ echo " "; } } } } //print "

ez egy másik film címe (1239) >> Megegy másik gilm

"; print ""; print ""; print ""; print "
"; if($_SESSION['belepett']==true && $totalepisodes>0 AND $episodes>0){ $episode_percentage=round($totalepisodes/($episodes/100)); if($episode_percentage<100 && $episode_percentage>0){ $percentage_id=1; if($episode_percentage>=0 && $episode_percentage<20){ $percentage_id=1; } if($episode_percentage>=20 && $episode_percentage<40){ $percentage_id=2; } if($episode_percentage>=40 && $episode_percentage<60){ $percentage_id=3; } if($episode_percentage>=60 && $episode_percentage<80){ $percentage_id=4; } if($episode_percentage>=80 && $episode_percentage<=100){ $percentage_id=5; } ?>
 %
0){ $effecttoactive=" active"; } if($_SESSION['belepett']==true){ echo "
 ".$txt['effectometer']."
"; } ?> $effvalue) { echo "".$effvalue['avgrate']."
"; } echo "// END TEST AVG"; */ // include 'effectarray.php'; //deklaracio fent while ( $effsor = mysql_fetch_array($eredmeny555)) { $motw= $effsor['movie_id']; foreach($effectarray as $effkey=>$effvalue) { //echo $effkey."_".$effvalue['num']."
"; if ($effsor[$effkey]>0){ $effectarray[$effkey]['rate']=$effsor[$effkey]; }else{ $effectarray[$effkey]['rate']="0"; } } } //foreach($effectarray as $effkey=>$effvalue) { //echo $effkey.": ".$effvalue['num']." || ".$effvalue['name']." :: ".$effvalue['rate']."
"; /* foreach($effvalue as $subeffkey=>$subeffvalue) { echo $subeffkey."_".$subeffvalue."
"; } */ //} echo "
"; echo "
"; echo " ".$txt["effectometer"]; if($effectnum==0 && $lng=="hun"){ echo "  Légyszi nyomj minden hatásra, ami bármennyire igaz a filmre (az átlagoknál számít)"; } echo "
"; echo " "; echo "
"; echo "
"; echo "
"; foreach($effectarray as $effkey=>$effvalue) { echo "
"; if(strlen($effvalue['description'])>0){ $efftitle=" title='".$effvalue['description']."'"; $hastipclass=" hastipButton"; }else{ $efftitle=""; $hastipclass=""; } if($effvalue['rate']>0){ $deleffactive="active"; $effnameclass="effect".$effvalue['rate']; }else{ $deleffactive=""; $effnameclass=""; } echo "
"; echo "".$effvalue['name'].""; echo "
"; echo "
"; for($j=5;$j>=1;$j--){ if($j==$effvalue['rate']){ $effactive="active"; }else{ $effactive=""; } echo "
"; for($s=1;$s<=$j;$s++){ echo "*"; } echo "
"; } echo "
"; echo "
"; echo " "; echo "
"; echo "
"; } echo "
"; echo "
"; // END HATASMETER ?> "; if($_SESSION['belepett']==true){ ?> =100){ echo ""; } if($runtime>0){ echo ""; } if ( $sor = mysql_fetch_array($eredmeny)) { do { if ($sor['genre_id']=="3"){ $anime="true"; } if ($sor['genre_id']=="2"){ $animacios="true"; } print ""; } while ( $sor = mysql_fetch_array($eredmeny)); } if($_SESSION['role'] == 'admin'){ print ""; } print "
"; ?> \n"); print ""; //favoritolásos cuccok megjelenítése print ""; print "0) { $wane_hanyfele+=1; $parancs = "SELECT name, szemelyek.person_id FROM persons szemelyek, director rendezo WHERE rendezo.person_id=szemelyek.person_id AND rendezo.movie_id=".$movie_id." ORDER BY name ASC;" ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); print ""; while ( $sor = mysql_fetch_array($eredmeny)) { print " "; if($_SESSION['role'] == 'admin'){ print ""; } print""; } } //ha wannak irok if ($wane_writer>0) { $wane_hanyfele+=1; $parancs = "SELECT name, szemelyek.person_id FROM persons szemelyek, writer iro WHERE iro.person_id=szemelyek.person_id AND iro.movie_id=".$movie_id." ORDER BY name ASC;" ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); print ""; while ( $sor = mysql_fetch_array($eredmeny)) { print " "; if($_SESSION['role'] == 'admin'){ print ""; } print""; } } //ha wannak szineszek if ($wane_actor>0) { $wane_hanyfele+=1; $parancs = "SELECT id,name, ".$lng."_role_name, leadrole, szemelyek.person_id, cult_id, voice, voice_lang FROM persons szemelyek, actor szinesz WHERE szinesz.person_id=szemelyek.person_id AND szinesz.movie_id=".$movie_id." GROUP BY szinesz.person_id ORDER BY voice_lang ASC, leadrole DESC, cult_id DESC, name ASC;" ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $actorDisplayLimit=3; $allActorNum=mysql_num_rows($eredmeny); print ""; $actornumber=0; while ( $sor = mysql_fetch_array($eredmeny)) { $actornumber++; if($actornumber>$actorDisplayLimit && $actorDisplayLimit+1 < $allActorNum){ $moreActor="moreActor"; } $portray = "pix/person/". $sor['person_id'].".jpg" ; if (!file_exists($portray)) { $portray = "pix/person/person0.jpg" ; } $hastipPortrait="hastipPortrait"; if (($sor['voice_lang']=='hun' && $lng=='hun')|| $sor['voice_lang']!='hun' ){ print ""; if($_SESSION['role'] == 'admin'){ print ""; } print""; } } if ($actornumber>$actorDisplayLimit && $actorDisplayLimit+1 < $allActorNum){ print ""; if($_SESSION['role'] == 'admin'){ print ""; } print ""; } } //ha wannak zeneszerzok if ($wane_composer>0) { $wane_hanyfele+=1; $parancs = "SELECT name, szemelyek.person_id FROM persons szemelyek, composer zeneszerzo WHERE zeneszerzo.person_id=szemelyek.person_id AND zeneszerzo.movie_id=".$movie_id." ORDER BY name ASC;" ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); print ""; while ( $sor = mysql_fetch_array($eredmeny)) { print " "; if($_SESSION['role'] == 'admin'){ print ""; } print""; } } //ha nincs egyik sem if ($wane_director==0 && $wane_writer==0 && $wane_actor==0 && $wane_composer==0) { $hianyzo_sorok=15; print ""; print ""; } //ha a sorok száma kisebb mint: 5 $wane_osszes=$wane_director+$wane_writer+$wane_actor+$wane_composer; $wane_sorok=$wane_osszes+$wane_hanyfele; if ($wane_sorok<8 && $wane_osszes>0) { //$hianyzo_sorok=8-$wane_sorok; //for ($i = 1; $i <= $hianyzo_sorok; $i++) { print ""; //} } ?>
".$sor['name']."

".$txt["writer"].":

".$sor['name']."

".$txt["cast"].":

"; print "
"; print "
".$sor['name']." 		"; if ($sor['cult_id']>0){ print ""; } print $sor[$lng."_role_name"]; if ($sor['cult_id']>0){ print " "; } // ". eval('\$sor['role_name'] = \'$sor['role_name']\';'); if ($sor['voice']>0){ print " ["; if ($sor['voice_lang']=='hun'){ print "magyar "; } print $txt['voice']."]"; } //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='".$sor['person_id']."' AND szinesz.movie_id=".$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()); while ( $sor360 = mysql_fetch_array($eredmeny360)) { echo " / "; if ($sor360['cult_id']>0){ print ""; } print $sor360[$lng."_role_name"]; if ($sor360['cult_id']>0){ print " "; } // ". eval('\$sor360['role_name'] = \'$sor360['role_name']\';'); if ($sor360['voice']>0){ print " ["; if ($sor360['voice_lang']=='hun'){ print "magyar "; } print $txt['voice']."]"; } } } print "
".$txt['more']."

".$txt["composer"].":

".$sor['name']."
"; } if($_SESSION['role'] == 'admin'){ print ""; print ""; print ""; print ""; print ""; print ""; print ""; if($season>0){ print ""; } print ""; print ""; print ""; print ""; print ""; print ""; } if(($_SESSION['role'] == 'admin' || $_SESSION['role'] == 'editor') ){ print ""; print ""; } if($_SESSION['role'] == 'admin' || $_SESSION['role'] == 'editor'){ echo "
                            
"; } //KÍSÉRLETI IDÕMEGJELÖLÉS $langtagname=$lng."_tag_name"; $parancs = "SELECT ".$langtagname.", cimkek.tag_id FROM tags cimkek, movie_tags filmcimkek WHERE cimkek.tag_id=filmcimkek.tag_id AND filmcimkek.movie_id =" . $movie_id ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $labelsor="  "; $labelpixsor=""; $labelnum=0; print ""; if ( $sor = mysql_fetch_array($eredmeny)) { do { $labelnum++; /* $labelsor .= "|| ".$sor[$langtagname]." ||  "; */ $labelsor .= "|| ".$sor[$langtagname]." ||  "; if($labelnum%6==0){ $labelsor .= "
"; } $labelpic = "pix/tag/".$sor['tag_id'].".png" ; if (file_exists($labelpic)) { $labelpicout = ""; } else { $labelpicout = ""; } if (file_exists($labelpic)) { /* $labelpixsor .= "".$labelpicout."  "; */ $labelpixsor .= "".$labelpicout."  "; } //print ""; } while ( $sor = mysql_fetch_array($eredmeny)); if (strlen($labelsor)>8){ if (strlen($labelpixsor)>0){ print ""; } print ""; } } print "
".$labelsor."
"; /* //KÍSÉRLETI HELYMEGJELÖLÉS $parancs = "SELECT loc_type, loc_id FROM movie_loc WHERE movie_id =" . $movie_id ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $locationsor="   ".ucfirst($txt["location"]).": " ; print "
"; if ( $sor = mysql_fetch_array($eredmeny)) { do { $lngtow=$lng."_tow"; $lngsta=$lng."_sta"; $lngsub=$lng."_sub"; $lngcon=$lng."_con"; $loc_type=$sor[loc_type]; $loc_id=$sor[loc_id]; if ($loc_type=="sta"){ $sta_id = $sor[loc_id]; $con_id; } else if ($loc_type=="con"){ $con_id= $sor[loc_id]; } else if ($loc_type=="sub"){ $sub_id= $sor[loc_id]; } else if ($loc_type=="tow"){ $tow_id= $sor[loc_id]; $sta_id; $sub_id; $con_id; $parancs2 = "SELECT id, ".$lngtow.", sta_id FROM loc_tow WHERE id =" . $tow_id; $eredmeny2 = mysql_query($parancs2, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor2 = mysql_fetch_array($eredmeny2)) { $locationsor .= "  ".$sor2[$lngtow]." <<  "; $sta_id = $sor2['sta_id']; } } if ($loc_type=="sta" || $loc_type=="tow"){ $parancs3 = "SELECT id, ".$lngsta.", sub_id FROM loc_sta WHERE id ='" .$sta_id."' "; $eredmeny3 = mysql_query($parancs3, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor3 = mysql_fetch_array($eredmeny3)) { $locationsor .= "  ".$sor3[$lngsta]." <<  "; $sub_id = $sor3['sub_id']; } } if ($loc_type=="sub" || $loc_type=="sta" || $loc_type=="tow"){ $parancs3 = "SELECT id, ".$lngsub.", con_id FROM loc_sub WHERE id ='" .$sub_id."' "; $eredmeny3 = mysql_query($parancs3, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor3 = mysql_fetch_array($eredmeny3)) { $locationsor .= "  ".$sor3[$lngsub]." <<  "; $con_id = $sor3['con_id']; } } $parancs4 = "SELECT id, ".$lngcon." FROM loc_con WHERE id ='" .$con_id."' "; $eredmeny4 = mysql_query($parancs4, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor4 = mysql_fetch_array($eredmeny4)) { $locationsor .= "  ".$sor4[$lngcon]." <<  "; } if (($_SESSION['role'] == 'editor') || ($_SESSION['role'] == 'admin')){ $locationsor .= " "; } $locationsor .="
"; } while ( $sor = mysql_fetch_array($eredmeny)); print ""; } print "
"; */ //ÚJ HELYMEGJELÖLÉS $parancs = "SELECT location_id,level, ".$lng."_name, parent FROM movie_locations helyszinek, locations helyek WHERE helyek.id=helyszinek.location_id AND helyszinek.movie_id =" . $movie_id ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); if(mysql_num_rows($eredmeny)>0){ $locationsor="   ".ucfirst($txt["location"]).": " ; } print "
"; while ( $sor = mysql_fetch_array($eredmeny)) { $location_id=$sor["location_id"]; $location_name=$sor[$lng."_name"]; $location_parent=$sor["parent"]; $location_level=$sor["level"]; $locationsor .= "  ".$location_name." <<  "; if($location_level>1){ $current_parent=$location_parent; for($l=($location_level-1);$l>=1;$l--){ $parancs2 = "SELECT id, parent, ".$lng."_name FROM locations helyek WHERE helyek.id =" . $current_parent ; $eredmeny2 = mysql_query($parancs2, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor2 = mysql_fetch_array($eredmeny2)) { $current_parent=$sor2["parent"]; $plocation_id=$sor2["id"]; $location_name=$sor2[$lng."_name"]; $locationsor .= "  ".$location_name." <<  "; } } } if (($_SESSION['role'] == 'editor') || ($_SESSION['role'] == 'admin')){ $locationsor .= " "; } $locationsor .="
"; } print ""; print "
"; //KÍSÉRLETI IDÕMEGJELÖLÉS ?>
 ".ucfirst($txt["time"]).": " ; if ( $sor = mysql_fetch_array($eredmeny)) { print "
"; do { //$timesor .= "["; $timesor .= "["; /*if ($sor['time']<0){ if ($lng=="hun"){ $timesor .= "i.e. "; } $timesor .= str_replace("-", "", round($sor['time'])); if ($lng=="eng"){ $timesor .= " BC"; } } else { $timesor .= round($sor['time']); } */ $timesor .= $sor['formatted_time']; $timesor .= "]"; if ( ($_SESSION['role'] == 'admin')){ $timesor .= " "; $timesor .= "  "; } //print ""; } while ( $sor = mysql_fetch_array($eredmeny)); print ""; } //TORTENET if($lng=="hun"){ if(strlen($plot_hun)>2){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; echo $txt['plot']; echo "
"; echo nl2br($plot_hun); echo "
"; echo "
"; } }else if($lng=="eng"){ if(strlen($plot_eng)>2){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; echo $txt['plot']; echo "
"; echo nl2br($plot_eng); echo "
"; echo "
"; } } //TORTENET VEGE $parancs111="SELECT listak.id, name, listak.nick, COUNT(listaelemek.object_id) AS listaelemekszama, listaelemek.datetime AS listaelemdatum FROM customlists listak, customlist_items listaelemek WHERE (listaelemek.list_id=listak.id AND listak.type=1 AND listak.id IN (SELECT list_id FROM customlist_items WHERE object_id='".$movie_id."' GROUP BY list_id)) GROUP BY listak.id ORDER BY listaelemdatum DESC"; $eredmeny111 = mysql_query($parancs111, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $listnumber=mysql_num_rows($eredmeny111); if($listnumber>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=1 AND confirmed=1 AND valaszok.object_id='".$movie_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 "
"; } ?>
"; echo "
"; echo "
".$lngtext_reporterror."
"; echo "
".$lngtext_missingitem."
"; echo "
"; echo "
"; echo "
".$txt["person"]."
"; echo "
".$txt["tag"]."
"; echo "
".$txt["location"]."
"; echo "
".$txt["time"]."
"; echo ""; echo "
"; //END addAnswersHDR echo "
"; //END addAnswersHDR echo "
"; echo "
"; ///INNENTOL COMMENTELNI echo "
"; //echo "ADD"; echo "
"; echo "
"; //END answerOptions echo "
"; echo "
"; //echo "a"; echo "
"; //END importantInfo */ echo "
"; echo $lngtext_selectfunctions.":"; echo "
".$txt['actor']."
"; echo "
".$txt['director']."
"; echo "
".$txt['writer']."
"; echo "
".$txt['composer']."
"; echo "
"; //END importantInfo */ echo "
"; //END additionalOptions echo "
"; // END suggestOptionsBoxNEW echo "
"; // END SuggestNEW echo "
"; //echo "
"; echo ""; //var_dump($_SESSION); if($_SESSION["merated"]>=500 ){ echo "
".$txt['send']."
"; }else{ echo "
".$txt['send']."
"; } //echo "
"; //END answerOptions echo "
"; //END reportError $parancs99 = "SELECT id, type, createdby, obj_type, obj_id, add_type, add_title,add_id,add_id2, add_text FROM suggestions WHERE obj_type = '1' AND obj_id = '".$movie_id."' AND status <2 ORDER BY datetime DESC "; $eredmeny99 = mysql_query($parancs99, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); if(mysql_num_rows($eredmeny99)>0){ echo "
"; echo "
"; echo "Jelenlegi aktív jelzések:"; echo "
"; //END currentSuggestionsHDR echo "
"; echo ""; while ( $sor = mysql_fetch_array($eredmeny99)){ echo ""; echo ""; echo ""; echo ""; if($_SESSION["role"]=="admin"){ echo ""; } echo ""; if($_SESSION["role"]=="admin"){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } echo "
"; if($sor['type']==1){ echo ""; }else{ echo ""; } echo ""; if($sor['type']==2){ echo "".$sor['add_title'].""; if(strlen($sor['add_id2'])>1){ echo " :".str_replace(",1",":".$txt['actor'],str_replace(",2",":".$txt['director'],str_replace(",3",":".$txt['writer'],str_replace(",4",":".$txt['composer'],$sor['add_id2'])))); } if(strlen($sor['add_text'])>0){echo "
";} } echo $sor['add_text']; echo "		"; echo $sor['createdby']; echo ""; echo "
 
"; echo "
 
"; echo "
"; if($sor['type']!=1){ //echo $sor['add_type']; //echo $sor['add_id2']; if($sor['add_type']==2){ if(strpos( $sor['add_id2'],'1')== true){ $actionlink1="newactortomovie.php?movieid=".$movie_id."&personid=".$sor['add_id'].""; echo "  "; } if(strpos( $sor['add_id2'],'2')== true || strpos( $sor['add_id2'],'3')== true || strpos( $sor['add_id2'],'4')== true){ $actionlink1="newotherpersontomovie.php?movieid=".$movie_id."&personid=".$sor['add_id']."&fl=".$sor['add_id2'].""; echo "  "; } } if($sor['add_type']==4){ $actionlink1="tagmovie.php?movie_id=".$movie_id."&tag=".$sor['add_id'].""; echo "  "; } if($sor['add_type']==5){ $actionlink1="addlocations.php?movie_id=".$movie_id."&loc=".$sor['add_id'].""; echo "  "; } if($sor['add_type']==6){ $actionlink1="addtime.php?movie_id=".$movie_id."&time=".$sor['add_title'].""; echo "  "; } } echo ""; echo ""; echo "
"; echo ""; echo ""; echo "
"; echo "
"; //END currentSuggestionsContent echo "
"; //END currentSuggestions } echo "
"; //END addAnswers //} ?>
0){ ?>

".$sor['title']."

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

".$sor['year']."

"; $readonly=""; if($nick!=$_SESSION['nick']){ $readonly=" readonly=readonly' "; } print "
"; $sorszam++; } print "
".$txt["are_you_sure_you_delete_from_your_owns"]."?
 
"; print "
"; ?>
Biztosan el szeretnéd küldeni?
  "; print "
"; print "
Biztosan el szeretnéd küldeni?
"; print "
"; //CIKKEK,KRITIKAK $langfilter=""; if($lng!="hun"){ $langfilter=" AND language!='hun'"; } $langfilter=""; //150104 NYELVI FILTER KILOVE $parancs = "SELECT review_link,review_title,rev_id FROM reviews WHERE review_type='movie' AND review_id='".$movie_id."' ".$langfilter." ORDER BY LOCATE('filmegwan',review_link) 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){ ?>
". $sor['review_title'].""; if($_SESSION['role']=='admin'){ print "X"; } print ""; } print "
"; print "
"; } ////TRAILER if (strlen($trailer)>1 || strlen($trailer)==0) { Print("
\n"); if (strlen($trailer)==0) { echo ""; } print ""; ?> ImpO :: Ellenőrzés"; } ?>
0){ if(count($exclude_array)>0){ $exclude_condition=" AND movie_id NOT IN (".implode(',',$exclude_array).") "; } for($t=0;$t"; //echo "keys BEFORE: ".count($keys)."
"; $keys2=array_values($keys); $values2=array_values($values); //HITCOUNTER $hitcount=array_count_values($values);//Counts the values in the array, returns associatve array asort($hitcount);//Sort it from highest to lowest $hitkeys=array_keys($hitcount);//Split the array so we can find the most occuring key $hitvalues=array_values($hitcount);//Split the array so we can find the most occuring key $hitlimiter; $limitreached; $hitkey_array=array(); for($i=0;$i=$hitlimit && $limitreached<1){ $limitreached=$hitkeys[$i]; } } //echo "Reached ".$hitlimiter." @".$limitreached."
"; for($i=0;$i"; //echo "keys AFTER: ".count($keys2)."
"; //HA NINCS ELEG a HITLIMITHEZ KEPEST $genre_used=false; if(count($values2)<$hitlimit){ $newhitlimit=$hitlimit-count($values2); $genre_used=true; $subquery1="SELECT genre_id FROM movie_genres WHERE movie_id='".$movie_id."'"; $eredmeny1 = mysql_query($subquery1, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $genre_array=array(); while ( $sor = mysql_fetch_array($eredmeny1)) { $genre_array[]=$sor['genre_id']; } //var_dump($genre_array); $subquery1="SELECT movie_id,genre_id FROM movie_genres WHERE movie_id !='".$movie_id."' ".$exclude_condition." "; $eredmeny1 = mysql_query($subquery1, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $genre_based_sub_array=array(); while ( $sor = mysql_fetch_array($eredmeny1)) { for($j=0;$j"; //echo "keys BEFORE: ".count($keys_genre_based)."
"; $keys3=array_values($keys_genre_based); $values3=array_values($values_genre_based); //HITCOUNTER $hitcount_genre_based=array_count_values($values_genre_based);//Counts the values in the array, returns associatve array asort($hitcount_genre_based);//Sort it from highest to lowest $hitkeys_genre_based=array_keys($hitcount_genre_based);//Split the array so we can find the most occuring key $hitvalues_genre_based=array_values($hitcount_genre_based);//Split the array so we can find the most occuring key $hitlimiter; $limitreached; $hitkey_array=array(); for($i=0;$i=$newhitlimit && $limitreached<1){ $limitreached=$hitkeys_genre_based[$i]; } } //echo "II: Reached ".$hitlimiter." @".$limitreached."
"; for($i=0;$i"; //echo "keys AFTER II: ".count($keys3)."
"; $keys2=$keys3+$keys2; $values2=$values3+$values2; //echo "values AFTER II MERGE: ".count($values2)."
"; //echo "keys AFTER II MERGE: ".count($keys2)."
"; } //$keys=array_slice($keys2, 0, 33); //$values=array_slice($values2, 0, 33); $keys=$keys2; $values=$values2; if($genre_used==false){ //MUFAJOK $subquery1="SELECT genre_id FROM movie_genres WHERE movie_id='".$movie_id."'"; $eredmeny1 = mysql_query($subquery1, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $genre_array=array(); while ( $sor = mysql_fetch_array($eredmeny1)) { $genre_array[]=$sor['genre_id']; } //var_dump($genre_array); $subquery1="SELECT movie_id,genre_id FROM movie_genres WHERE movie_id IN (". implode(',',$keys).")"; $eredmeny1 = mysql_query($subquery1, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor = mysql_fetch_array($eredmeny1)) { for($j=0;$j0){ $values[$movie_index]+=$genre_weight; } } } } } if(sizeOf($keys)>0){ //FOSZEREPLOK $subquery1="SELECT person_id FROM actor WHERE movie_id='".$movie_id."' AND leadrole=1"; $eredmeny1 = mysql_query($subquery1, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $actor_array=array(); while ( $sor = mysql_fetch_array($eredmeny1)) { $actor_array[]=$sor['person_id']; } //var_dump($actor_array); if(sizeOf($actor_array)>0){ $subquery1="SELECT movie_id,person_id FROM actor WHERE movie_id IN (". implode(',',$keys).") AND leadrole=1"; $eredmeny1 = mysql_query($subquery1, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor = mysql_fetch_array($eredmeny1)) { for($j=0;$j0){ $values[$movie_index]+=$lead_actor_weight; } } } } } //KULTFIGURAK $subquery1="SELECT cult_id FROM actor WHERE movie_id='".$movie_id."' and cult_id>0"; $eredmeny1 = mysql_query($subquery1, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $cult_array=array(); while ( $sor = mysql_fetch_array($eredmeny1)) { $cult_array[]=$sor['cult_id']; } //var_dump($cult_array); if(sizeOf($cult_array)>0){ $subquery1="SELECT movie_id,person_id,cult_id FROM actor WHERE movie_id IN (". implode(',',$keys).")"; $eredmeny1 = mysql_query($subquery1, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor = mysql_fetch_array($eredmeny1)) { for($j=0;$j0){ $values[$movie_index]+=$cultchar_weight; } } } } } //RENDEZO(K) $subquery1="SELECT person_id FROM director WHERE movie_id='".$movie_id."'"; $eredmeny1 = mysql_query($subquery1, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $director_array=array(); while ( $sor = mysql_fetch_array($eredmeny1)) { $director_array[]=$sor['person_id']; } //var_dump($director_array); if(sizeOf($director_array)>0){ $subquery1="SELECT movie_id,person_id FROM actor WHERE movie_id IN (". implode(',',$keys).")"; $eredmeny1 = mysql_query($subquery1, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor = mysql_fetch_array($eredmeny1)) { for($j=0;$j0){ $values[$movie_index]+=$director_weight; } } } } } //IRO(K) $subquery1="SELECT person_id FROM writer WHERE movie_id='".$movie_id."'"; $eredmeny1 = mysql_query($subquery1, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $writer_array=array(); while ( $sor = mysql_fetch_array($eredmeny1)) { $writer_array[]=$sor['person_id']; } //var_dump($director_array); if(sizeOf($writer_array)>0){ $subquery1="SELECT movie_id,person_id FROM writer WHERE movie_id IN (". implode(',',$keys).")"; $eredmeny1 = mysql_query($subquery1, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor = mysql_fetch_array($eredmeny1)) { for($j=0;$j0){ $values[$movie_index]+=$writer_weight; } } } } } //EVEK $subquery1="SELECT year FROM movies WHERE movie_id='".$movie_id."'"; $eredmeny1 = mysql_query($subquery1, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor = mysql_fetch_array($eredmeny1)) { $base_movie_year=$sor['year']; } $year_interval=8; $subquery1="SELECT movie_id FROM movies WHERE year<".($base_movie_year+$year_interval)." AND year>".($base_movie_year-$year_interval)." "; $eredmeny1 = mysql_query($subquery1, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor = mysql_fetch_array($eredmeny1)) { $movie_index=array_search($sor['movie_id'], $keys); if(strlen($movie_index)>0){ $values[$movie_index]+=$year_weight; } } //IDOSZAK $subquery1="SELECT time FROM movie_time WHERE movie_id='".$movie_id."'"; $eredmeny1 = mysql_query($subquery1, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $time_array=array(); while ( $sor = mysql_fetch_array($eredmeny1)) { $time_array[]=$sor['time']; } //var_dump($actor_array); $time_start_end=array(); for($z=0;$z'".$time_array[$z]."' "; $eredmeny1 = mysql_query($subquery1, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor2 = mysql_fetch_array($eredmeny1)) { $time_start_end[][0]=$sor2['start']; $time_start_end[][1]=$sor2['end']; } } //var_dump($time_start_end); $subquery1="SELECT movie_id,time FROM movie_time WHERE movie_id IN (". implode(',',$keys).")"; $eredmeny1 = mysql_query($subquery1, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor = mysql_fetch_array($eredmeny1)) { for($j=0;$j=$time_start_end[$j][0]){ $movie_index=array_search($sor['movie_id'], $keys); if(strlen($movie_index)>0){ $values[$movie_index]+=$time_weight; } } } } //HELYSZINEK $subquery1="SELECT loc_id, loc_type FROM movie_loc WHERE movie_id='".$movie_id."'"; $eredmeny1 = mysql_query($subquery1, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $loc_id_array=array(); $loc_type_array=array(); while ( $sor = mysql_fetch_array($eredmeny1)) { $loc_type_array[]=$sor['loc_type']; $loc_id_array[]=$sor['loc_id']; } //var_dump($loc_id_array); $subquery1="SELECT movie_id,loc_id,loc_type FROM movie_loc WHERE movie_id IN (". implode(',',$keys).")"; $eredmeny1 = mysql_query($subquery1, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor = mysql_fetch_array($eredmeny1)) { for($j=0;$j0){ $values[$movie_index]+=$loc_weight; } } } } $combined=array_combine($keys, $values); arsort($combined);//Sort it from highest to lowest $keys=array_keys($combined);//Split the array so we can find the most occuring key $values=array_values($combined);//Split the array so we can find the most occuring key if(count($keys)>0){ echo "
"; echo ""; echo ""; echo ""; echo ""; for($i=0;$i<$displaylimit;$i++){ $parancs = "SELECT hun_title, eng_title, movie_id, title, season, year FROM movies WHERE movie_id ='".$keys[$i]."' " ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor = mysql_fetch_array($eredmeny)){ $titlebe="".$sor['title']; if ($sor['season']>0){ $titlebe.= " [s".$sor['season']."]"; } $titlebe.="
"; if(strlen($sor['eng_title'])>1){ $titlebe.="".$sor['eng_title']; if ($sor['season']>0){ $titlebe.= " [s".$sor['season']."]"; } $titlebe.="
"; } if ($lng=="hun"){ $titlebe.="".$sor['hun_title']; if ($sor['season']>0){ $titlebe.= " [s".$sor['season']."]"; } $titlebe.="
"; } $titlebe.=$sor['year']; $poster="pix/poster/" . $sor['movie_id'] . ".jpg"; if (!file_exists($poster)){ $poster="pix/poster/0.jpg"; } echo ""; } } echo ""; echo "
"; echo $txt['similar']; //echo "Hasonlóak"; echo "
"; } } */ ?> 2){ $ajaxPostAction="ins"; }else{ $ajaxPostAction="new"; } if ($userertekeles>0){ $spoiler_text=""; }else{ $spoiler_text="spoiler"; } ?> 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="pix/useravatar/".str_replace("ó","o",str_replace("/","_",preg_replace('/[^A-Za-z0-9\-]/', 'e',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_text; } 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 ""; } ?>
".$txt["are_you_sure_you_delete"]."?
  "; print "
"; ?>