".$txt["movies_with"]." ".$txt["with_this_tag"].": ". ucfirst($tag)." - FilmO"; print ""; print ""; if (file_exists($tagpic)) { echo ""; }else{ echo ""; } ?>
0) "; $parancs = "SELECT ROUND(AVG(movie_rate),1) AS real_avg FROM rate_movies ertekeltek, movie_tags filmcimkek WHERE (ertekeltek.movie_id = filmcimkek.movie_id AND filmcimkek.tag_id='".$tag_id."' AND ertekeltek.userid IN (".$_SESSION['active_list_userids'].")) "; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor = mysql_fetch_array($eredmeny)){ $averagemovierate=number_format((float)$sor['real_avg'], 1, '.', ''); } print "
"; echo "
"; //CAT holder /* if($cat!="com"){ echo "
"; } if($cat!="act"){ echo "
"; } if($cat!="wri"){ echo "
"; } if($cat!="dir"){ echo "
"; } */ echo "
"; $parancsimg = "SELECT cimkek.tag_id FROM tags cimkek, image_connections kapocs WHERE (cimkek.tag_id= kapocs.conn_id and kapocs.conn_id='".$tag_id."' AND kapocs.conn_type='3') " ; $eredmenyimg = mysql_query($parancsimg, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $numofpix=mysql_num_rows($eredmenyimg); $parancsvid = "SELECT cimkek.tag_id FROM tags cimkek, video_connections kapocs WHERE (cimkek.tag_id= kapocs.conn_id and kapocs.conn_id='".$tag_id."' AND kapocs.conn_type='3') " ; $eredmenyvid = mysql_query($parancsvid, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $numofvid=mysql_num_rows($eredmenyvid); if($numofvid>0){ echo "
"; } if($numofpix>0){ echo "
"; } echo "
"; echo "
"; echo "
".$txt['average'].": ".$averagemovierate.""; echo "
"; //end CAT holder echo "
"; print "

".$txt["movies_with"]." ".$txt["with_this_tag"].":

".ucfirst($tag)."

"; $tagpic = "pix/tag/".$tag_id.".png" ; ///FaVORIT tag panel if($_SESSION['belepett'] == 'true'){ $parancs = "SELECT DISTINCT nick FROM favtags WHERE tag_id='".$tag_id."' AND userid IN (".$_SESSION['active_list_userids'].")"; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $numberOffavTags=mysql_num_rows($eredmeny); if($numberOffavTags<1){ $numberOffavTags="0"; } $favTagTitle=$txt["add_to_favourite_tags"]; if ($numberOffavTags>0){ $parancs2 = "SELECT * FROM favtags WHERE userid='".$_SESSION['userid']."' AND tag_id='".$tag_id."' "; $eredmeny2 = mysql_query($parancs2, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); if (mysql_num_rows($eredmeny2)>0){ $isfavTag="favTagActive"; $favTagTitle=$txt["delete_from_favourite_tags"]; } } print "
"; print "
". $numberOffavTags." ".$txt['members']." ".$txt['marked_as_favourite']."\" class='hastipButton'>".$txt['favourite']." ".$txt['tag']." [".$numberOffavTags."]
"; print "
"; } if (file_exists($tagpic)) { print ""; print ""; } else{ print "

"; } ?>

0){ ?>
".$sor5[$lng.'_genre_name']."

"; } $allGenreList.="
".$txt['none']."
"; ?>
".$txt['so_far'].": ".$sor['COUNT(ertekeltek.movie_id)']." ".$txt['members']." */ print "

".$sor['title']; if($sor['season']>0){ print " - Season ".$sor['season']; } echo "

"; if($lng=="hun"){ print $sor['hun_title']; if($sor['season']>0){ print " -".$sor['season'].". Évad"; } }else if(strlen($sor['eng_title'])>0){ print $sor['eng_title']; if($sor['season']>0){ print " - Season ".$sor['season']; } } print " 

".$sor['year']."

"; /* print "
".$sor['COUNT(nick)']." ".$txt['members']." ".$txt['marked_as_wannasee']."\">".$txt['so_far']."

".$sor['COUNT(DISTINCT megnezendok.nick)']."

".$txt['members']."
"; */ 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 "
"; print "
".$txt['wannasee'].":
"; print ""; print "
"; //end userActList ?>
"; if($lng=="hun"){ print "Még nem tudunk semmit ajánlani. Jelölj meg néhány címkét favoritnak, hogy tudjuk milyen témákat szeretsz!


Néhány ötlet:"; }else{ print "We can't recommend anything yet. Please mark some tags as favourite, and we'll know the topics you like!


Some ideas:"; } print "

"; $langtagname=$lng."_tag_name"; //print "

".$txt["favourite"]." ". $txt['tags']."

"; //print "
"; print ""; $parancs = "SELECT ".$langtagname.", filmcimkek.tag_id , COUNT(filmcimkek.tag_id) FROM tags cimkek, favtags filmcimkek WHERE cimkek.tag_id=filmcimkek.tag_id GROUP BY ".$langtagname." ORDER BY ".$langtagname." ASC" ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); $labelsor=""; $labelpixsor=""; while ( $sor = mysql_fetch_array($eredmeny)) { $labelsor .= "0 && $sor['COUNT(DISTINCT filmcimkek.tag_id, filmcimkek.tag_id)']<2){ $labelsor .= ""; } if ($sor['COUNT(filmcimkek.tag_id)']>1 && $sor['COUNT(DISTINCT filmcimkek.tag_id, filmcimkek.tag_id)']<3){ $labelsor .= ""; } if ($sor['COUNT(filmcimkek.tag_id)']>2 && $sor['COUNT(DISTINCT filmcimkek.tag_id, filmcimkek.tag_id)']<4){ $labelsor .= ""; } if ($sor['COUNT(filmcimkek.tag_id)']>3 && $sor['COUNT(DISTINCT filmcimkek.tag_id, filmcimkek.tag_id)']<5){ $labelsor .= ""; } if ($sor['COUNT(filmcimkek.tag_id)']>4){ $labelsor .= ""; } $labelsor .= "|| ".$sor[$langtagname]." ||  "; $labelpic = "pix/tag/".$sor['tag_id'].".png" ; if (file_exists($labelpic)) { $labelpicout = ""; } else { $labelpicout = ""; } if (file_exists($labelpic)) { $labelpixsor .= " ".$labelpicout." "; } } if (strlen($labelsor)>0){ print ""; if (strlen($labelpixsor)>0){ print ""; } } print ""; } ?>
0){ ?>
". $sor['review_title'].""; if($_SESSION['role']=='admin'){ print "X"; } print ""; } print "
"; print "
"; } if($_SESSION['role']=="admin"){ print "  "; print "  "; } $topic_id="33".$tag_id; $parancs = "SELECT topic_name FROM forum_topics WHERE topic_id ='" . $topic_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)) { $topic_name= $sor['topic_name']; } if(strlen($topic_name)>2){ $ajaxPostAction="ins"; }else{ $ajaxPostAction="new"; } ?> 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_src="pix/useravatar/default.png"; } $spoiler=""; if($sor['spoiler']>0){ $spoiler="spoiler"; } 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 "
"; ?>