";
// ********************************
// ***** M A G A M R O L ******
// ********************************
if ($_SESSION['belepett']==true){
$thisisme;
if ($_SESSION['nick']==$nick){
$thisisme=true;
$first_td_colspan=7;
}else{
$thisisme=false;
$first_td_colspan=8;
}
//MUFAJOK
$pagerquery = "SELECT movie_id FROM rate_movies WHERE nick='".$nick."' ";
$eredmeny = mysql_query($pagerquery, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
$sub_array=array();
while ( $sor = mysql_fetch_array($eredmeny)) {
$sub_array[]=$sor['movie_id'];
}
$langgenrename=$lng."_genre_name";
$parancs = "SELECT ".$langgenrename.", filmmufajok.genre_id , mufajok.genre_id , COUNT(DISTINCT filmmufajok.genre_id, filmmufajok.movie_id) as mufajdarab FROM genres mufajok, movie_genres filmmufajok WHERE mufajok.genre_id=filmmufajok.genre_id AND filmmufajok.movie_id IN ('".implode("','", $sub_array)."') GROUP BY ".$langgenrename." ORDER BY mufajdarab DESC, ".$langgenrename." ASC" ;
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
$genresor="";
while ( $sor = mysql_fetch_array($eredmeny)) {
if(strlen($genresor)>0){
$genresor.= ", ";
}
$genresor.= "
".$sor[$langgenrename]."" ;
}
Print("
");
print " ".$txt["about_me"]."
| ";
if ($thisisme){
echo " | ";
}
echo "
";
echo "";
print "";
echo "| INFO: | ".$aboutme." |
";
if(strlen($genresor)>0){
echo "| ".$txt['genres'].": | ".$genresor." |
";
}
if($email_visible>0){
echo "| E-mail: | ".$useremail." |
";
}
print("
");
}
// ********************************
// ***** É R T É K E L T E K ******
// ********************************
Print("
");
print " ".$txt["last_time"]." ".$txt["rateds"]."
| ";
if ($raterows>8){
echo "".strtolower($txt["alls"])."";
}
echo " |
";
if ($raterows>0){
$parancs = "SELECT nick, ertekeltek.movie_id, movie_rate, movie_rate_id, title, hun_title, eng_title, year, season FROM rate_movies ertekeltek, movies filmek WHERE ertekeltek.movie_id=filmek.movie_id AND nick='".$nick."' ORDER BY movie_rate_id DESC LIMIT 8 ";
$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 "";
$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']."
";
$titlebe.= " >> ".sprintf('%.1f',$sor['movie_rate'])." ";
$titlebe.="";
echo "";
$poster = "pix/poster/".$sor['movie_id'].".jpg" ;
if (file_exists($poster)) {
print "![](".$poster." "\\"\".$titlebe.\"\\"") ";
} else {
print " ";
}
echo "";
print" | ";
}
if ($raterows<8){
echo " | ";
}
print "
";
echo "| ".$txt["total"].": | ".$raterows."".$txt["pcs"]." | ".$txt['average'].": ".number_format($avg_rate,1)." |
";
} else {
print "".$txt["there_s_no_rated_yet"]." ";
if ($thisisme){
echo "".$txt['flash']." ".$txt['rating']."";
}
print " |
";
}
print("
");
// LEGUTÓBB LÁTOTTAK
Print("
");
print " ".$txt["last_time"]." ".$txt["seen"]."
| ";
if ($lastmovierows>8){
echo "".strtolower($txt["alls"])."";
}
echo " |
";
if ($lastmovierows>0){
$parancs = "SELECT hun_title, filmek.movie_id, title, eng_title, season, year, nick, legutobb.datetime, language, episode FROM movies filmek, lastmovies legutobb WHERE (filmek.movie_id = legutobb.movie_id AND nick='".$nick."' ) ORDER BY datetime DESC LIMIT 8" ;
$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 "";
$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 08:
$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;
}
$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']."
";
$titlebe.= " >> ";
if ($lng=="hun"){
$titlebe.=$year.". ".$month." ".$day.".";
}else{
$titlebe.=$day." ".$month." ".$year;
}
if ($sor['season']>0){
$titlebe.= " # e".str_pad($sor['episode'], 3, '0', STR_PAD_LEFT)." ";
}
$titlebe.="";
echo "";
$poster = "pix/poster/".$sor['movie_id'].".jpg" ;
if (file_exists($poster)) {
print "";
} else {
print "";
}
echo "";
print" | ";
}
if ($lastmovierows<8){
echo " | ";
}
echo "
";
echo "| ".$txt["total"].": | ".$lastmovies." ".strtolower($txt["movie"])." (".convertMinuteToDaysHoursMins($moviefulltime).") ".$txt["and"]." ".$lastseriepisodes." ".$txt["serie_episode"]." (".convertMinuteToDaysHoursMins($seriefulltime).") >> " .convertMinuteToDaysHoursMins($overalltime)." |
";
} else {
print "".$txt["there_s_no_seen_yet"]." ";
if ($thisisme){
echo "".$txt['seen']."";
}
print " |
";
}
print("
");
//**********************************************
//********** F A V O R I T F I L M E K ********
//**********************************************
$counted="DISTINCT nick, filmek.movie_id";
$pagerquery = "SELECT COUNT(" . $counted . ") FROM movies filmek, favmovies favoritok WHERE filmek.movie_id = favoritok.movie_id AND nick='".$nick."' ;" ;
$pagerresult = mysql_query($pagerquery) or die(mysql_error());
while($row = mysql_fetch_array($pagerresult)){
$favrows=$row['COUNT('.$counted.')'];
}
Print("
");
print " ".$txt['favourite']." ".$txt['movies']." / ".$txt['series']."
| ";
if ($favrows>8){
echo "".strtolower($txt["alls"])."";
}
echo " |
";
if ($favrows>0){
//RANDOM SORRENDBEN
$parancs = "SELECT hun_title, filmek.movie_id, title, season, year, nick, favmovie_id FROM movies filmek, favmovies favoritok WHERE (filmek.movie_id = favoritok.movie_id AND favoritok.nick='".$nick."' ) ORDER BY RAND() LIMIT 8" ;
$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 "";
$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'];
echo "";
$poster = "pix/poster/".$sor['movie_id'].".jpg" ;
if (file_exists($poster)) {
print "";
} else {
print "";
}
echo "";
print" | ";
}
if ($favrows<8){
echo " | ";
}
print "
";
echo "| ".$txt["total"].": | ".$favrows."".$txt["pcs"]." |
";
} else {
print "".$txt["there_s_no_favourite_yet"]." ";
if ($thisisme){
echo "".ucfirst(strtolower($txt["most_frequent"]))." ".ucfirst(strtolower($txt["favourites"]))."";
}
print" |
";
}
print("
");
//************************************
// F A V O R I T S Z E M É L Y E K
//************************************
$counted="DISTINCT nick, szemelyek.person_id";
$pagerquery = "SELECT COUNT(" . $counted . ") FROM persons szemelyek, favpersons favoritok WHERE szemelyek.person_id = favoritok.person_id AND nick='".$nick."' ;" ;
$pagerresult = mysql_query($pagerquery) or die(mysql_error());
while($row = mysql_fetch_array($pagerresult)){
$favrows=$row['COUNT('.$counted.')'];
}
Print("
");
//KEDVENC CIMKEK
$langtagname=$lng."_tag_name";
$parancs = "SELECT ".$langtagname.", filmcimkek.tag_id , COUNT(DISTINCT filmcimkek.tag_id, filmcimkek.tag_id) FROM tags cimkek, favtags filmcimkek WHERE cimkek.tag_id=filmcimkek.tag_id AND filmcimkek.nick='".$nick."' GROUP BY ".$langtagname ;
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
$num_tags=mysql_num_rows($eredmeny);
$num_tags_limit=25;
Print("
");
print " ".$txt['favourite']." ".$txt['tags']."
| ";
if ($num_tags>$num_tags_limit){
echo "".strtolower($txt["alls"])."";
}
echo " |
";
if($num_tags>0){
$parancs = "SELECT ".$langtagname.", filmcimkek.tag_id , COUNT(DISTINCT filmcimkek.tag_id, filmcimkek.tag_id) FROM tags cimkek, favtags filmcimkek WHERE cimkek.tag_id=filmcimkek.tag_id AND filmcimkek.nick='".$nick."' GROUP BY ".$langtagname." ORDER BY RAND() LIMIT ".$num_tags_limit." " ;
$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 " ".$sor[$langtagname]." ";
}
echo " |
";
echo "| ".$txt["total"].": | ".$num_tags." ".$txt["pcs"]." |
";
}else{
print "". $txt["no_matches_found"]." ";
if ($thisisme){
echo "".ucfirst(strtolower($txt["most_frequent"]))." ".ucfirst(strtolower($txt["favourite"]))." ".ucfirst(strtolower($txt["tags"]))."";
}
print " |
";
}
print "
";
//**********************************************
//********** F A V O R I T K O N Y V E K ********
//**********************************************
$counted="DISTINCT nick, filmek.book_id";
$pagerquery = "SELECT COUNT(" . $counted . ") FROM books filmek, favbooks favoritok WHERE filmek.book_id = favoritok.book_id AND nick='".$nick."' ;" ;
$pagerresult = mysql_query($pagerquery) or die(mysql_error());
while($row = mysql_fetch_array($pagerresult)){
$favrows=$row['COUNT('.$counted.')'];
}
Print("
");
print " ".$txt['favourite']." ".$txt['books']."
| ";
if ($favrows>8){
echo "".strtolower($txt["alls"])."";
}
echo " |
";
if ($favrows>0){
//RANDOM SORRENDBEN
$parancs = "SELECT hun_title, filmek.book_id, title, year, nick, favbook_id FROM books filmek, favbooks favoritok WHERE (filmek.book_id = favoritok.book_id AND favoritok.nick='".$nick."' ) ORDER BY RAND() LIMIT 8" ;
$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 "";
$titlebe="".$sor['title'];
$titlebe.="
";
if(strlen($sor['eng_title'])>1){
$titlebe.="".$sor['eng_title'];
$titlebe.="
";
}
if ($lng=="hun"){
$titlebe.="".$sor['hun_title'];
$titlebe.="
";
}
$titlebe.=$sor['year'];
echo "";
$poster = "pix/cover/".$sor['book_id'].".jpg" ;
if (file_exists($poster)) {
print "";
} else {
print "";
}
echo "";
print" | ";
}
if ($favrows<8){
echo " | ";
}
print "
";
echo "| ".$txt["total"].": | ".$favrows."".$txt["pcs"]." |
";
} else {
print "".$txt["there_s_no_favourite_yet"]." ";
if ($thisisme){
echo "".ucfirst(strtolower($txt["books"]))."";
}
print " |
";
}
print("
");
// F A V O R I T K U L T F I G U R Á K
/*kell egy query ami megadja a sorok számát*/
$counted="DISTINCT cult_id";
$pagerquery = "SELECT COUNT(" . $counted . ") FROM favcults WHERE nick='".$nick."' " ;
$pagerresult = mysql_query($pagerquery) or die(mysql_error());
while($row = mysql_fetch_array($pagerresult)){
$favrows=$row['COUNT('.$counted.')'];
}
Print("
");
// M E G N É Z E N D Õ K
/*kell egy query ami megadja a sorok számát*/
$counted="DISTINCT nick, filmek.movie_id";
$pagerquery = "SELECT COUNT(" . $counted . ") FROM movies filmek, wannasee megnezendok WHERE filmek.movie_id = megnezendok.movie_id AND release_date<='".$datetime."' AND nick='".$nick."' ;" ;
$pagerresult = mysql_query($pagerquery) or die(mysql_error());
while($row = mysql_fetch_array($pagerresult)){
$wannaseerows=$row['COUNT('.$counted.')'];
}
Print("
");
print " ".$txt['wannasees']."
| ";
if ($wannaseerows>8){
echo "".strtolower($txt["alls"])."";
}
echo " |
";
if ($wannaseerows>0){
$parancs2 = "SELECT hun_title, filmek.movie_id, title, season, year, nick, wannasee_id, filmek.release_date FROM movies filmek, wannasee megnezendok WHERE (filmek.movie_id = megnezendok.movie_id AND megnezendok.nick='".$nick."' AND filmek.release_date<='".$datetime."' ) ORDER BY wannasee_priority ASC, wannasee_id DESC LIMIT 8" ;
$eredmeny2 = mysql_query($parancs2, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
$fut_wannaseerows = mysql_num_rows($eredmeny2);
if($fut_wannaseerows>0){
echo "";
while ( $sor = mysql_fetch_array($eredmeny2)){
print "";
$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'];
echo "";
$poster = "pix/poster/".$sor['movie_id'].".jpg" ;
if (file_exists($poster)) {
print "";
} else {
print "";
}
echo "";
print" | ";
}
if ($fut_wannaseerows<8){
echo " | ";
}
print "
";
echo "| ".$txt["total"].": | ".$wannaseerows."".$txt["pcs"]." |
";
$wannaseerows_p=$wannaseerows;
}
} else {
print "".$txt["there_s_no_wannasee_yet"]." ";
if ($thisisme){
echo "top ".ucfirst(strtolower($txt["wannasees"]))."";
}
print " |
";
}
print("
");
// H A M A R O S A N
/*kell egy query ami megadja a sorok számát*/
$counted="DISTINCT nick, filmek.movie_id";
$pagerquery = "SELECT COUNT(" . $counted . ") FROM movies filmek, wannasee megnezendok WHERE filmek.movie_id = megnezendok.movie_id AND release_date>'".$datetime."' AND nick='".$nick."' ;" ;
$pagerresult = mysql_query($pagerquery) or die(mysql_error());
while($row = mysql_fetch_array($pagerresult)){
$wannaseerows=$row['COUNT('.$counted.')'];
}
Print("
");
print " ".$txt['soon']." | ";
if ($wannaseerows>8){
echo "".strtolower($txt["alls"])."";
}
echo " |
";
if ($wannaseerows>0){
$parancs2 = "SELECT hun_title, filmek.movie_id, title, season, year, nick, wannasee_id, filmek.release_date FROM movies filmek, wannasee megnezendok WHERE (filmek.movie_id = megnezendok.movie_id AND megnezendok.nick='".$nick."' AND filmek.release_date>'".$datetime."' ) ORDER BY release_date ASC, wannasee_id DESC LIMIT 8" ;
$eredmeny2 = mysql_query($parancs2, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
$fut_wannaseerows = mysql_num_rows($eredmeny2);
if($fut_wannaseerows>0){
echo "";
$pieces = explode(" ", $datetime);
$date=$pieces[0];
while ( $sor = mysql_fetch_array($eredmeny2)){
$release_pieces = explode(" ", $sor['release_date']);
$release_date=$release_pieces[0];
$diff = abs(strtotime($release_date) - strtotime($date));
$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;
}
print "";
$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']."
";
if ($lng=="hun"){
$titlebe.= "Bemutató: ".$release_year.". ".$release_month." ".$release_day.".";
}else{
$titlebe.= "Release date: ".$release_day." ".$release_month." ".$release_year ;
}
$titlebe.="";
echo "";
$poster = "pix/poster/".$sor['movie_id'].".jpg" ;
if (file_exists($poster)) {
print "";
} else {
print "";
}
echo "
".$to_release." ".$txt['days'];
echo "";
print" | ";
}
if ($fut_wannaseerows<8){
echo " | ";
}
print "
";
echo "| ".$txt["total"].": | ".$wannaseerows."".$txt["pcs"]." |
";
}
} else {
print "". $txt["no_matches_found"]." ";
if ($thisisme){
echo "".ucfirst(strtolower($txt["unreleased"]))."";
}
print " |
";
}
print("
");
//KÉRÉSEK
$parancs = "SELECT user_request_id, nick, user_request FROM user_requests WHERE nick='".$nick."' ORDER BY user_request_id";
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
$num_requests=mysql_num_rows($eredmeny);
Print("
");
print " ".$txt['requests']."
|
";
if($num_requests>0){
print "| ";
while ( $sor = mysql_fetch_array($eredmeny)) {
print " ".$sor['user_request']." ";
}
echo " |
";
}else{
print "". $txt["no_matches_found"]." ";
if ($thisisme){
echo "".ucfirst(strtolower($txt["requests"]))."";
}
print " |
";
}
print "
";
//FORUMOS
$parancs = "SELECT nick, post, post_id, spoiler FROM forum_posts WHERE nick='".$nick."' ";
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
$post_rows=mysql_num_rows($eredmeny);
Print("
");
print " ".$txt['posts']."
|
";
if($post_rows>0){
$parancs = "SELECT nick, post, post_id, spoiler FROM forum_posts WHERE nick='".$nick."' AND topic_id LIKE '11%'";
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
$moviecomments=mysql_num_rows($eredmeny);
echo "";
echo "| ".$txt["total"].": | ".$post_rows." ".$txt["pcs"]." | ".$txt['movie']." ".$txt['comments'].": ".$moviecomments." ".$txt["pcs"]." |
";
}else{
print "". $txt["no_matches_found"]." ";
if ($thisisme){
echo "".ucfirst(strtolower($txt["forum"]))."";
}
print " |
";
}
print "
";
if($thisisme){
print "
".$txt['flash']." ".$txt['rating']."
".$txt['recommended']."
".$txt['unreleased']."
";
}
print "
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 25 ";
//}
}else{
$findwordlimit="";
}
$findwordlimit=" LIMIT 77";
}
//$parancs = "SELECT filmek.movie_id, title, hun_title,eng_title, season, episode, legutobb.datetime, connector_id FROM movies filmek, lastmovies legutobb, connected_movies kapcsoltfilmek WHERE (filmek.movie_id = legutobb.movie_id AND kapcsoltfilmek.movie_id = legutobb.movie_id) AND season>0 ".$nickquery." GROUP BY connector_id ORDER BY count(legutobb.datetime) DESC, legutobb.datetime DESC ".$findwordlimit;
$parancs = "SELECT eng_sequel_name as title, hun_sequel_name as hun_title, start_year, count(legutobb.nick) as episodenum, 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." GROUP BY connector_id ORDER BY count(legutobb.datetime) DESC, legutobb.datetime DESC ".$findwordlimit;
// NO LIMIT
//$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";
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
if(mysql_num_rows($eredmeny)>0){
Print("
");
echo "".$txt['series']." |
";
while ( $sor = mysql_fetch_array($eredmeny)){
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'].")";
$titlebe.="
".$sor['episodenum']." ".$txt['episodes'];
print "' target='_self' class='tablink hastipButton' title=\"".$titlebe."\">";
//$seriimage = "pix/seri/".rtrim(strtolower(str_replace("?", "_", str_replace("'", "_", str_replace("é", "e", str_replace("ô", "o", str_replace(":", "_", $sor['title']))))))).".jpg" ;
$seriimage="pix/connectorcover/".$sor['connector_id'].".jpg";
//print "![](".$seriimage.") ";
if (file_exists($seriimage)) {
print "";
}else{
print $sor['title'];
}
print " |
";
}
print "
";
}
?>
";
}
echo "";
print"
".$txt['favourite']." ".$txt['persons']."
".$txt['favourite']." ".$txt['cult_characters']."
