". $txt["user_has_seen"]." ".strtoupper($nick)." ". $txt["has_seen_these"]."

"; }else{ print "

". $txt["weve_seen_these"]."

"; } /*

Mitkeressen:

*/ if (strlen($findwordbase)>0){ print "".$txt["searched_word"].": ".$findwordbase."
"; } else { print "
"; } ?>

".$txt["no_matches_found_for_this_word"]."

"; }else{ /* $parancs = "SELECT DISTINCT hun_title, filmek.movie_id, title, year, season, disc_id, dvd FROM movies filmek, disc diszk WHERE filmek.movie_id = diszk.movie_id AND ( title LIKE '%" . $findword . "%' OR hun_title LIKE '%" . $findword . "%' ) ORDER BY disc_id DESC limit " . $kezd ." , " . $megjelenitett ; */ $parancs = "SELECT hun_title, filmek.movie_id, title, season, year, nick, language, legutobb.datetime, episode FROM movies filmek, lastmovies legutobb WHERE (filmek.movie_id = legutobb.movie_id ) AND userid IN (".$_SESSION['active_list_userids'].") AND ( title LIKE '%" . $findword . "%' OR hun_title LIKE '%" . $findword . "%' ) ".$nickquery." ORDER BY datetime DESC LIMIT " . $kezd ." , " . $megjelenitett ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); print "

"; Print("\n"); //print""; while ( $sor = mysql_fetch_array($eredmeny)) { print ""; print ""; print ""; print ""; if($_SESSION['belepett'] == true ) { print ""; } print ""; } print("

"; if ($_SESSION['nick']==$sor["nick"]){ print " "; }else{ print " "; } print "".$sor['nick'].""; if ($_SESSION['nick']==$sor["nick"]){ print " "; } print "	"; $poster = "pix/poster/".$sor['movie_id'].".jpg" ; if (file_exists($poster)) { print "  "; } else { print "  "; } print "	"; $pieces = explode(" ", $sor['datetime']); $date=$pieces[0]; $datepieces = explode("-", $date); $year=$datepieces[0]; $nummonth=$datepieces[1]; $day=$datepieces[2]; switch ($nummonth) { case 01: $month=$txt["january"]; break; case 02: $month=$txt["february"]; break; case 03: $month=$txt["march"]; break; case 04: $month=$txt["april"]; break; case 05: $month=$txt["may"]; break; case 06: $month=$txt["june"]; break; case 07: $month=$txt["july"]; break; case 8: $month=$txt["august"]; break; case 9: $month=$txt["september"]; break; case 10: $month=$txt["october"]; break; case 11: $month=$txt["november"]; break; case 12: $month=$txt["december"]; break; } if ($lng=="hun"){ print " ".$year.". ".$month." ".$day.". " ; }else{ print " ".$day." ".$month." ".$year." " ; } if ( substr( $sor["language"] , 0 , 3) == "HUN"){ print " ".$sor['hun_title']; if ($sor['season'] > 0){ print " - " .$sor['season'] . ".".$txt['season'].""; print " - e"; if ($sor['episode']<10){ print "0"; } print $sor['episode'] ; } print " [" .$sor['title'] ; if ($sor['season'] > 0){ print " - ".$txt['season']." " .$sor['season'] ; print " - e"; if ($sor['episode']<10){ print "0"; } print $sor['episode'] ; } print "]   "; } else { print " ".$sor['title']; if ($sor['season'] > 0){ print " - ".$txt['season']." " .$sor['season'] ; print " - e"; if ($sor['episode']<10){ print "0"; } print $sor['episode'] ; } print " (" .$sor['hun_title']; if ($sor['season'] > 0){ print " - " .$sor['season'] . ".".$txt['season'].""; print " - e"; if ($sor['episode']<10){ print "0"; } print $sor['episode'] ; } print ")   "; } print " "; print " ".$sor["year"]." "; print"	"; print "   "; print "

"); /* print (""); print "".$sor['title'] ; if ($sor["season"]>0) { print " - ".$txt['season']." ". $sor["season"]; } print ""; print "".$sor["hun_title"]; if ($sor["season"]>0) { print " - ". $sor["season"].".".$txt['season'].""; } print ""; print "".$sor["year"].""; */ /* "; if ($sor["season"]>0) { print "Sorozatokban"; } else { print "Filmekben" ;} print ""; */ /* print(""); } print("\n"); */ ?>

0){ $nicklink="?user=".$nick; }else{ $nicklink=""; } print ""; ?>

" ?>

"; echo ""; ?>









6){ $limit=$rows*4; $findwordlimit=" LIMIT ".$limit." "; } if($rows>30){ if ($pagenum>=$osszes_lap){ if ($utolsorow%$megjelenitett>6){ $limit=($utolsorow%$megjelenitett)*4; $findwordlimit=" LIMIT ".$limit." "; }else{ $findwordlimit=" LIMIT 23 "; } }else{ $findwordlimit="LIMIT 33"; } } //$findwordlimit="LIMIT 23"; if (strlen($nick)>0){ $nickquery=" AND legutobb.nick='".$nick."' "; //$parancs = "SELECT DISTINCT title,filmek.movie_id, season, datetime FROM movies filmek, lastmovies legutobb WHERE (filmek.movie_id = legutobb.movie_id ) AND season>0 ".$nickquery." ORDER BY datetime DESC ".$findwordlimit; $parancs = "SELECT eng_sequel_name as title, hun_sequel_name as hun_title, start_year, legutobb.datetime, connector_id FROM connectors kapcsok, lastmovies legutobb, connected_movies kapcsoltfilmek WHERE (kapcsoltfilmek.movie_id = legutobb.movie_id AND kapcsok.id = kapcsoltfilmek.connector_id ) AND type=1 ".$nickquery." ORDER BY legutobb.datetime DESC ".$findwordlimit; //$parancs = "SELECT title, hun_title, movie_id, season FROM movies WHERE movie_id IN (SELECT movie_id FROM lastmovies WHERE nick='".$nick."' ORDER BY datetime DESC) as titleorder AND season>0 GROUP BY title ORDER BY titleorder ".$findwordlimit; /*$parancs = "SELECT filmek.movie_id, filmek.title, filmek.hun_title, filmek.season FROM movies filmek WHERE season>0 INNER JOIN (SELECT legutobb.movie_id, legutobb.datetime as timestamp FROM lastmovies legutobb )c ON (c.movie_id = filmek.movie_id) ORDER BY c.datetime ".$findwordlimit; */ }else{ //$parancs = "SELECT filmek.movie_id, title, hun_title, season, episode, datetime FROM movies filmek, lastmovies legutobb WHERE (filmek.movie_id = legutobb.movie_id ) AND season>0 ".$nickquery." GROUP BY title ORDER BY count(datetime) DESC, datetime DESC ".$findwordlimit; $parancs = "SELECT eng_sequel_name as title, hun_sequel_name as hun_title, start_year, count(legutobb.id) as episode_num, legutobb.datetime, connector_id FROM connectors kapcsok, lastmovies legutobb, connected_movies kapcsoltfilmek WHERE (kapcsoltfilmek.movie_id = legutobb.movie_id AND kapcsoltfilmek.connector_id = kapcsok.id ) AND legutobb.userid IN (".$_SESSION['active_list_userids'].") AND type=1 AND connector_id!=44 GROUP BY connector_id ORDER BY episode_num DESC, legutobb.datetime DESC ".$findwordlimit; } $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); print ""; Print("\n"); //print""; while ( $sor = mysql_fetch_array($eredmeny)){ print ""; } print "

".$sor['title'].""; if ($lng=="hun" && $sor['title']!=$sor['hun_title']){ $titlebe.=" ".$sor['hun_title'].""; } if ($lng=="eng" && strlen($sor['eng_title'])>2){ $titlebe.=" ".$sor['eng_title'].""; } $titlebe.=" (".$sor['start_year'].")"; if(strlen($nick)==0){ $titlebe.=" ".$sor['episode_num']." ".$txt['episodes']; } print "' target='_self' class='tablink hastipButton' title=\"".$titlebe."\">"; //$seriimage = "pix/seri/".rtrim(strtolower(str_replace("á", "a", (str_replace("ö", "o", (str_replace("ü", "u", (str_replace("?", "_", str_replace("'", "_", str_replace("é", "e", str_replace("ô", "o", str_replace(":", "_", $sor['title']))))))))))))).".jpg" ; $seriimage="pix/connectorcover/".$sor['connector_id'].".jpg"; if (file_exists($seriimage)) { print ""; }else{ print $sor['title']; } print "

"; ?>