"; } */ if($movie_id>0){ $parancs = "SELECT * FROM movies WHERE movie_id ='" . $movie_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)) { $title2= "

".$sor['title']; if($sor['season']>0){ if($lng=="hun"){ $title2.= " - ". $sor['season'].".".$txt['season'].""; }else{ $title2.= " - ".$txt['season']." ". $sor['season']; } } $title2.= "

"; if( $sor['hun_title']!= $sor['eng_title']){ $title2.= "

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

"; } $title2.= "

(".$sor['year']; $title2.= ")

"; } } if($book_id>0){ $parancs = "SELECT * FROM books WHERE book_id ='" . $book_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)) { $title2= "

".$sor['title']; /* if($sor['season']>0){ if($lng=="hun"){ $title2.= " - ". $sor['season'].".".$txt['season'].""; }else{ $title2.= " - ".$txt['season']." ". $sor['season']; } } */ $title2.= "

"; if( $sor['hun_title']!= $sor['eng_title']){ $title2.= "

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

"; } $title2.= "

(".$sor['year']; $title2.= ")

"; } } if($game_id>0){ $parancs = "SELECT * FROM games WHERE game_id ='" . $game_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)) { $title2= "

".$sor['title']; $title2.= "

"; if( $sor['hun_title']!= $sor['eng_title']){ $title2.= "

".$sor['hun_title']; $title2.= "

"; } $title2.= "

(".$sor['year']; $title2.= ")

"; } } ?> <?php echo $txt["connectors"];?>

".$title2."

"; } ?>


"2010-01-01") { return $diffindays." ".$GLOBALS['txt']['days_ago']; }else{ return "Ismeretlen"; } } if($movie_id!=""){ $customfilter=" and createdby='".$nick."'"; $nicklink="&movie_id=".$movie_id.""; $conncectorslist=array(); $parancs = "SELECT connector_id FROM connected_movies WHERE movie_id='".$movie_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)){ $conncectorslist[]=$sor['connector_id']; } } if($book_id!=""){ $customfilter=" and createdby='".$nick."'"; $nicklink="&book_id=".$book_id.""; $conncectorslist=array(); $parancs = "SELECT connector_id FROM connected_books WHERE book_id='".$book_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)){ $conncectorslist[]=$sor['connector_id']; } } if($game_id!=""){ $customfilter=" and createdby='".$nick."'"; $nicklink="&game_id=".$game_id.""; $conncectorslist=array(); $parancs = "SELECT connector_id FROM connected_games WHERE game_id='".$game_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)){ $conncectorslist[]=$sor['connector_id']; } } /* $parancs22 = "SELECT id, type, createdby, obj_type, obj_id, obj_text,add_type, add_title,add_id,add_id2, add_text FROM suggestions WHERE status='2' ".$customfilter." "; $eredmeny22 = mysql_query($parancs22, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $resultstat2=mysql_num_rows($eredmeny22); $parancs33 = "SELECT id, type, createdby, obj_type, obj_id, obj_text,add_type, add_title,add_id,add_id2, add_text FROM suggestions WHERE status='3' ".$customfilter." "; $eredmeny33 = mysql_query($parancs33, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $resultstat3=mysql_num_rows($eredmeny33); $parancs11 = "SELECT id, type, createdby, obj_type, obj_id, obj_text,add_type, add_title,add_id,add_id2, add_text FROM suggestions WHERE status='1' ".$customfilter." "; $eredmeny11 = mysql_query($parancs11, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $resultstat1=mysql_num_rows($eredmeny11); $counted="DISTINCT id"; if($_GET['ct']=="2"){ $pagerquery = "SELECT id FROM suggestions WHERE status='2' ".$customfilter." "; $pagerquery = "SELECT id FROM suggestions WHERE status='2' ".$customfilter." "; }else if($_GET['ct']=="3"){ $pagerquery = "SELECT id FROM suggestions WHERE status='3' ".$customfilter." "; }else{ $pagerquery = "SELECT id FROM suggestions WHERE status='1' ".$customfilter." "; } //$visible="true"; include 'pager-suggestions.php'; */ $ct1active=""; $ct2active=""; $ct3active=""; $ct8active=""; $ct9active=""; if($_GET['ct']=="2"){ //Folytatás $parancs99 = "SELECT * FROM connectors WHERE type='2' ORDER BY datetime DESC"; $conntext=2; $ct2active=" ctActive"; }else if($_GET['ct']=="3"){ $parancs99 = "SELECT * FROM connectors WHERE type='3' ORDER BY datetime DESC"; $ct3active=" ctActive"; }else if($_GET['ct']=="5"){ $parancs99 = "SELECT * FROM connectors WHERE type='5' ORDER BY datetime DESC"; $ct5active=" ctActive"; }else if($_GET['ct']=="8"){ $parancs99 = "SELECT * FROM connectors WHERE type='8' ORDER BY datetime DESC"; $ct8active=" ctActive"; }else if($_GET['ct']=="9"){ $parancs99 = "SELECT * FROM connectors WHERE type='9' ORDER BY datetime DESC"; $ct9active=" ctActive"; }else{ $parancs99 = "SELECT * FROM connectors WHERE type='1' ORDER BY datetime DESC"; $conntext=1; $ct1active=" ctActive"; } print "
"; echo "

"; echo "
"; if($_SESSION['role']=="admin" || strpos($_SESSION['rolelist'], ',3,') !== false){ echo "
"; echo " ".$txt["create_connector"].""; echo "
"; } $eredmeny99 = mysql_query($parancs99, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); echo "
"; echo "
"; if($conntext!=""){ $statuslink="&ct=".$conntext; }else{ $statuslink="&ct=1"; } if($_GET['ct']>"7"){ echo ""; echo ""; } else if($_GET['ct']=="5"){ echo ""; }else{ echo ""; echo ""; echo ""; } //echo "
"; /* echo "
TV Sorozat
"; echo "
Folytatás
"; echo "
Remake
"; */ echo "
"; //END currentSuggestionsHDR echo "
"; if(mysql_num_rows($eredmeny99)>0){ echo ""; while ( $sor = mysql_fetch_array($eredmeny99)){ echo ""; echo ""; if($sor['type']==1){ echo ""; } if($movie_id>0){ if(in_array($sor["id"],$conncectorslist)){ echo ""; }else{ echo ""; } } if($book_id>0){ if(in_array($sor["id"],$conncectorslist)){ echo ""; }else{ echo ""; } } if($game_id>0){ if(in_array($sor["id"],$conncectorslist)){ echo ""; }else{ echo ""; } } echo ""; } echo "
"; echo "".$sor["eng_sequel_name"]." // ".$sor["hun_sequel_name"]." (".$sor["start_year"].")"; echo ""; switch($sor["status"]){ case 1: echo "Folyamatban"; break; case 2: echo "Szünetel"; break; case 3: echo "Elkaszált"; break; case 4: echo "Befejezett"; break; default: echo "-"; } if($sor["tvdbid"]<1){ echo " "; }else{ echo " ~"; } echo "
"; echo "
"; } else{ echo ""; echo ""; echo "
".$txt["no_matches_found"]."
"; echo "
"; } ?>