"; exit; header("Location: fresh.php"); die(); } 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/gamecover/".$game_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://mygameapi.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 = "?"; ?> " . $pagetitle.""; ?> ";?>

 

X 

"; print ""; print ""; */ print ""; print ""; print ""; print ""; print ""; ?> 0){ ?>

"; /* while ( $sor = mysql_fetch_array($eredmeny)){ $wane=$sor['COUNT(game_id)']; } */ $wane=mysql_num_rows($eredmeny); ?> "; ?>

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 'gameaverageratevotes.php'; print "
"; //HASONLOSAGHOZ $sub_array=array(); //---KAPCSOK - REMAKE-ek $langsequelname=$lng."_sequel_name"; $parancs = "SELECT kapcsok.id, $langsequelname,start_year FROM connected_games kapocsjatekok, connectors kapcsok WHERE (kapocsjatekok.game_id='".$game_id."' AND kapocsjatekok.connector_id=kapcsok.id AND type='8') 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, jatekok.game_id, title, year FROM games jatekok, connected_games kapocsjatekok WHERE (jatekok.game_id = kapocsjatekok.game_id AND kapocsjatekok.connector_id=\"".$remakeid."\" ) ORDER BY year ASC , jatekok.game_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['game_id']!=$game_id){ $remakesout .= " >>  ".str_replace(" ", " ", $sor['hun_title']).$evad." (".$sor['year'].")  "; //HASONLOSAGHOZ $sub_array[]=$sor['game_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['game_id']!=$game_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_games kapocsjatekok, connectors kapcsok WHERE (kapocsjatekok.game_id='".$game_id."' AND kapocsjatekok.connector_id=kapcsok.id AND type='9') 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, jatekok.game_id, title, year FROM games jatekok, connected_games kapocsjatekok WHERE (jatekok.game_id = kapocsjatekok.game_id AND kapocsjatekok.connector_id=\"".$sequelid."\" ) ORDER BY year ASC , jatekok.game_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['game_id']!=$game_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['game_id']!=$game_id){ $sequelsout .= " >>  ".str_replace(" ", " ", $sor['title']).$evad." (".$sor['year'].")  "; //HASONLOSAGHOZ $sub_array[]=$sor['game_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 jatekokNEL EZEKET NEM ADJA A TALALATOKHOZ //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; } ?>
 %
$effvalue) { echo "".$effvalue['avgrate']."
"; } echo "// END TEST AVG"; */ // include 'effectarray.php'; //deklaracio fent while ( $effsor = mysql_fetch_array($eredmeny555)) { $motw= $effsor['game_id']; foreach($effectarray as $effkey=>$effvalue) { //echo $effkey."_".$effvalue['num']."
"; if ($effsor[$effkey]>0){ $effectarray[$effkey]['rate']=$effsor[$effkey]; }else{ $effectarray[$effkey]['rate']="0"; } } } ?> "; 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' || strpos($_SESSION['rolelist'], ',3,') !== false){ print ""; } print "
"; ?> \n"); print ""; //favoritolásos cuccok megjelenítése print ""; print "0) { $wane_hanyfele+=1; $parancs = "SELECT id,name, role_name, leadrole, szemelyek.person_id, cult_id, voice, voice_lang FROM persons szemelyek, actor_game szinesz WHERE szinesz.person_id=szemelyek.person_id AND szinesz.game_id=".$game_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_game zeneszerzo WHERE zeneszerzo.person_id=szemelyek.person_id AND zeneszerzo.game_id=".$game_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 ""; //} } ?>
"; print "
"; print "
".$sor['name']." 		"; if ($sor['cult_id']>0){ print ""; } print $sor['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 role_name, leadrole, cult_id, voice, voice_lang FROM actor_game szinesz WHERE szinesz.person_id='".$sor['person_id']."' AND szinesz.game_id=".$game_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['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']."
"; //print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; //print ""; print ""; print ""; print ""; print ""; print ""; echo "
                            
"; } //KÍSÉRLETI IDÕMEGJELÖLÉS $langtagname=$lng."_tag_name"; $parancs = "SELECT ".$langtagname.", cimkek.tag_id, category FROM tags cimkek, game_tags filmcimkek WHERE cimkek.tag_id=filmcimkek.tag_id AND filmcimkek.game_id =" . $game_id ." ORDER BY category ASC, ".$langtagname." ASC" ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $labelsor="  "; $platformsor="   Platform: " ; $labelpixsor=""; $labelnum=0; $platformnum=0; print ""; if ( $sor = mysql_fetch_array($eredmeny)) { do { /* $labelsor .= "|| ".$sor[$langtagname]." ||  "; */ if($sor['category']==16){ $platformsor .= "|| ".$sor[$langtagname]." ||  "; $platformnum++; }else{ $labelsor .= "|| ".$sor[$langtagname]." ||  "; $labelnum++; } if($labelnum%5==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 (($labelnum+$platformnum)>0){ if (strlen($labelpixsor)>0){ print ""; } if ($labelnum>0){ print ""; } if ($platformnum>0){ print ""; } } } print "
".$labelsor."
".$platformsor."
"; // //KÍSÉRLETI HELYMEGJELÖLÉS // $parancs = "SELECT loc_type, loc_id FROM game_loc WHERE game_id =" . $game_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]." <<  "; */ // $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]." <<  "; */ // $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[$lngsta]." <<  "; */ // $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]." <<  "; */ // $locationsor .= "  ".$sor4[$lngcon]." <<  "; // } // if (($_SESSION['role'] == 'editor') || ($_SESSION['role'] == 'admin')){ // $locationsor .= " "; // } // $locationsor .="
"; // //print ""; // } while ( $sor = mysql_fetch_array($eredmeny)); // //print ""; // } // //print ""; // print "
"; //ÚJ HELYMEGJELÖLÉS $parancs = "SELECT location_id,level, ".$lng."_name, parent FROM game_locations helyszinek, locations helyek WHERE helyek.id=helyszinek.location_id AND helyszinek.game_id =" . $game_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 ""; print "
"; //KÍSÉRLETI IDÕMEGJELÖLÉS ?>
 ".ucfirst($txt["time"]).": " ; if ( $sor = mysql_fetch_array($eredmeny)) { print "
"; do { $period; $thistime=$sor['time']; $parancs2 = "SELECT id FROM time_periods WHERE start<='".$thistime."' AND end>='".$thistime."' " ; $eredmeny2 = mysql_query($parancs2, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor2 = mysql_fetch_array($eredmeny2)) { $period=$sor2['id']; } //$timesor .= "["; $timesor .= "["; /* if ($sor['time']<0){ if ($lng=="hun"){ $timesor .= "i.e. "; } $timesor .= str_replace("-", "", $thistime); if ($lng=="eng"){ $timesor .= " BC"; } } else { $timesor .= $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 //KAPCSOLODO FILMEK $parancs = "SELECT hun_title, filmek.movie_id, title, season, year FROM movies filmek, gamerelmovie kapocs WHERE (filmek.movie_id = kapocs.movie_id and kapocs.game_id='".$game_id."' ) ORDER BY filmek.year DESC, 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){ ?>

".$sor['title']."

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

".$sor['year']."

"; $readonly=""; if($nick!=$_SESSION['nick']){ $readonly=" readonly=readonly' "; } if($_SESSION['role']=="admin"){ print "
X
"; } if($_SESSION['belepett']==true){ print "
"; $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); if($sor['release_date']<$datetime){ $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']; } for($r=5;$r>=1;$r--){ print "
"; } } print "
"; print "
"; } print "
"; $sorszam++; } print "
".$txt["are_you_sure_you_delete_from_your_owns"]."?
 
"; 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=4 AND confirmed=1 AND valaszok.object_id='".$game_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 = '3' AND obj_id = '".$game_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="newactortogame.php?gameid=".$game_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="newotherpersontogame.php?gameid=".$game_id."&personid=".$sor['add_id']."&fl=".$sor['add_id2'].""; echo "  "; } } if($sor['add_type']==4){ $actionlink1="taggame.php?game_id=".$game_id."&tag=".$sor['add_id'].""; echo "  "; } if($sor['add_type']==5){ $actionlink1="addgamelocations.php?game_id=".$game_id."&loc=".$sor['add_id'].""; echo "  "; } if($sor['add_type']==6){ $actionlink1="addgametime.php?game_id=".$game_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='game' AND review_id='".$game_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 ""; ?>
"; if($lng=="hun"){ $autotrailer="Automatikusan keresett trailer"; }else{ $autotrailer="Automatic searched trailer"; } echo $autotrailer; echo "

0){ if(count($exclude_array)>0){ $exclude_condition=" AND game_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 game_genres WHERE game_id='".$game_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 game_id,genre_id FROM game_genres WHERE game_id !='".$game_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 game_genres WHERE game_id='".$game_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 game_id,genre_id FROM game_genres WHERE game_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[$game_index]+=$genre_weight; } } } } } if(sizeOf($keys)>0){ //FOSZEREPLOK $subquery1="SELECT person_id FROM actor_game WHERE game_id='".$game_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 game_id,person_id FROM actor_game WHERE game_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[$game_index]+=$lead_actor_weight; } } } } } //KULTFIGURAK $subquery1="SELECT cult_id FROM actor_game WHERE game_id='".$game_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 game_id,person_id,cult_id FROM actor_game WHERE game_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[$game_index]+=$cultchar_weight; } } } } } //EVEK $subquery1="SELECT year FROM games WHERE game_id='".$game_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_game_year=$sor['year']; } $year_interval=8; $subquery1="SELECT game_id FROM games WHERE year<".($base_game_year+$year_interval)." AND year>".($base_game_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)) { $game_index=array_search($sor['game_id'], $keys); if(strlen($game_index)>0){ $values[$game_index]+=$year_weight; } } //IDOSZAK $subquery1="SELECT time FROM game_time WHERE game_id='".$game_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 game_id,time FROM game_time WHERE game_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]){ $game_index=array_search($sor['game_id'], $keys); if(strlen($game_index)>0){ $values[$game_index]+=$time_weight; } } } } //HELYSZINEK $subquery1="SELECT loc_id, loc_type FROM game_loc WHERE game_id='".$game_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 game_id,loc_id,loc_type FROM game_loc WHERE game_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[$game_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, game_id, title, year FROM games WHERE game_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/gamecover/" . $sor['game_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 "
"; ?>