> ide mennek az üzik
?>
";
while ( $sor = mysql_fetch_array($eredmeny)){
$wane=$sor['COUNT(book_id)'];
}
?>
0){
print "
";
}
?>
0){ print " - ".$txt['season']." " . $season; } */ ?>
";
include 'bookaverageratevotes.php';
print "
";
//---KAPCSOK - FOLYTATASRESZEK
$langsequelname=$lng."_sequel_name";
$parancs = "SELECT kapcsok.id, $langsequelname,start_year FROM connected_books kapocsjatekok, connectors kapcsok WHERE (kapocsjatekok.book_id='".$book_id."' AND kapocsjatekok.connector_id=kapcsok.id AND type='5') 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.book_id, title, year FROM books jatekok, connected_books kapocsjatekok WHERE (jatekok.book_id = kapocsjatekok.book_id AND kapocsjatekok.connector_id=\"".$sequelid."\" ) ORDER BY year ASC , jatekok.book_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['book_id']!=$book_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['book_id']!=$book_id){
$sequelsout .= " >> ".str_replace(" ", " ", $sor['title']).$evad." (".$sor['year'].") ";
//HASONLOSAGHOZ
$sub_array[]=$sor['book_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 = "".$sequel." ".$sequelsout." |
ez egy másik film címe (1239) >> Megegy másik gilm
"; print "
| ";
print "";
if($userertekeles<1){
$hiderate0="hideRate";
}
echo " ";
/*
print "";
echo $txt["book_rate0"];
echo " ";
for($i=1;$i<=5;$i++){
$currclass="";
if($userertekeles>0){
//$modtitle=$txt["i_modify_to"].": ";
if($i==$userertekeles){
//$modtitle=$txt["you_think"].": ";
$currclass="currentRate";
}
}
echo "";
echo $txt["book_rate".$i];
echo " ";
}
echo "";
include 'ratingviewer.php';
print " ";
*/
} else {
print "";
print "".$txt["to_rate_and_have_other_options_you_have_to_be_signed_in"]."" ;
print " ";
}
print " |
| ";
print "
";
}
if($wordcount>0){
print "| "; $runtime=round($wordcount/$_SESSION["wpm"]); echo $runtime." ".$txt['minutes']; if($defaultruntime!=$runtime){ //$episodesdisplay="".$defaultruntime." ".$txt['minutes']; //echo " *"; }else{ $episodesdisplay=""; } //echo $totalepisodes; echo " |
| [ ".$sor[$langgenrename]." ] | "; } while ( $sor = mysql_fetch_array($eredmeny)); } if($_SESSION['role'] == 'admin'){ print " | ";
}
print "
| ";
if($_SESSION['belepett'] == true ) {
//Favorit film-e
$parancs = "SELECT book_id FROM favbooks WHERE book_id='" . $book_id."' AND nick='".$_SESSION['nick']."'" ;
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
if(mysql_num_rows($eredmeny)>0){
$isFavbook="favbookActive";
$favbookTitle=$txt["delete_from_favourites"];
}else{
$isFavbook="";
$favbookTitle=$txt["add_to_favourites"];
}
//Megnezendo-e
$parancs = "SELECT book_id FROM wannaread WHERE book_id='" . $book_id."' AND nick='".$_SESSION['nick']."'" ;
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
if(mysql_num_rows($eredmeny)>0){
$isWannaread="wannareadActive";
$wannareadTitle=$txt["delete_from_wannareads"];
}else{
$isWannaread="";
$wannareadTitle=$txt["add_to_wannareads"];
}
//Folyamatban-e
$parancs = "SELECT book_id FROM books_in_progress WHERE book_id='" . $book_id."' AND nick='".$_SESSION['nick']."'" ;
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
if(mysql_num_rows($eredmeny)>0){
$isInProgress="inProgressActive";
$inProgressTitle=$txt["cancel"];
}else{
$isInProgress="";
$inProgressTitle=$txt["in_progress"];
}
//Megwan-e
$parancs = "SELECT book_id, extra_info FROM book_megwan WHERE book_id='" . $book_id."' AND nick='".$_SESSION['nick']."'" ;
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
$extra_info;
if(mysql_num_rows($eredmeny)>0){
$isMegwan="megwanActive";
$megwanTitle=$txt["i_dont_have_this"];
while($row = mysql_fetch_array($eredmeny)){
$extra_info=$row['extra_info'];
}
}else{
$isMegwan="";
$megwanTitle=$txt["i_have_this"];
}
//Olvasott=e
$parancs6 = "SELECT book_id FROM lastbooks WHERE book_id='" . $book_id."' AND nick='".$_SESSION['nick']."'" ;
$eredmeny6= mysql_query($parancs6, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
if(mysql_num_rows($eredmeny6)>0){
$isLastbook="lastbookActive";
$lastbookTitle=$txt["i_read_this_last"];
}else{
$isLastbook="";
$lastbookTitle=$txt["i_read_this"];
}
}
if($_SESSION['belepett'] == true){
/*
print " ";
print " ";
print "";
print "";
print " ";
print "";
print ""; */ print " ";
if($is_released!="false"){
$parancs8 = "SELECT DISTINCT nick FROM book_megwan WHERE book_id='".$book_id."' AND userid IN (".$_SESSION['active_list_userids'].")";
$eredmeny8 = mysql_query($parancs8, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
$numberOfMegwans=mysql_num_rows($eredmeny8);
if($numberOfMegwans<1){
$numberOfMegwans="0";
}
print " ";
print "";
print "". $numberOfMegwans." ".$txt['members']."".$txt['have_this']."\" class='hastipButton'>".ucfirst(strtolower($txt['i_have_this']))." [".$numberOfMegwans."] ";
if(strlen($extra_info)>0){
print "> ".$extra_info."'> ";
}
print "". $numberOfFavbooks." ".$txt['members']." ".$txt['marked_as_favourite']."\" class='hastipButton'>".ucfirst(strtolower($txt['favourite']))." [".$numberOfFavbooks."] ";
print "". $numberOfWannareads." ".$txt['members']." ".$txt['marked_as_wannaread']."\" class='hastipButton'>".ucfirst(strtolower($txt['wannaread']))." [".$numberOfWannareads."] ";
print "". $numberOfInProgresss." ".$txt['members']." ".$txt['marked_as_inProgress']."\" class='hastipButton'>".ucfirst(strtolower($txt['in_progress']))." [".$numberOfInProgresss."] ";
print "";
print " ";
}
print "Kérések: . ";
print ""; if($is_released!="false"){ print " ";
//include 'favbooksajax.php';
print " ";
}
//megnézendõstipp
print "";
//include 'wannareadbookajax.php';
print " ";
print " | ";
print "";
?>
 ";
}
print " ";
?>
0){ $titleurlhez=substr($title,0,strripos($title, $kivag)); }else{ $titleurlhez=$title; } if (!(strripos($title, $extradisc)>0)){ print " "; print"  ";
//print"  ";
if (($season>0)==false){
print "  ";
print "  ";
}
if ($anime=="true"){
print"  ";
}
print ""; } else { print " - - - extra - - - "; } */ print ""; //HOZZÁADÁS A LEGUTÓBBIAKHOZ ?> |
0) {
$wane_hanyfele+=1;
$parancs = "SELECT name, szemelyek.person_id FROM persons szemelyek, author szerzo WHERE szerzo.person_id=szemelyek.person_id AND szerzo.book_id=".$book_id." ORDER BY 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 "
| ||
|
";
print "";
print " ".$sor['name']."
| ";
if($_SESSION['role'] == 'admin'){
print " | ";
}
print"|||
| ".$txt['more']." | "; if($_SESSION['role'] == 'admin'){ print ""; } 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 "||
|
";
print "";
print " ".$sor['name']."
| ";
if($_SESSION['role'] == 'admin'){
print " | ";
}
print"|||
| ".$txt['more']." | "; if($_SESSION['role'] == 'admin'){ print ""; } print " |
| ";
$actornumber=0;
while ( $sor = mysql_fetch_array($eredmeny)) {
$actornumber++;
if($actornumber>$actorDisplayLimit && $actorDisplayLimit+1 < $allActorNum){
$moreActor="moreActor";
}
$portray = "pix/cult_character/". $sor['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 "||
|
";
print "";
print " ".$sor[$lng.'_name']."
| ";
if($_SESSION['role'] == 'admin'){
print " | ";
}
print"|||
| ".$txt['more']." | "; if($_SESSION['role'] == 'admin'){ print ""; } print " | "; print " | "; print ""; } //ha a sorok száma kisebb mint: 5 $wane_osszes=$wane_author; $wane_sorok=$wane_osszes+$wane_hanyfele; if ($wane_sorok<8 && $wane_osszes>0) { print "||
".$txt["author"].":
".$txt["person_SMALL"].":
".$txt["cult_character"].":"; } */ $labelsor .= "|| ".$sor[$langtagname]." || "; if($labelnum%6==0){ $labelsor .= "
"; } $labelpic = "pix/tag/".$sor['tag_id'].".png" ; if (file_exists($labelpic)) { $labelpicout = "
0){ $locationsor="
".ucfirst($txt["location"]).": " ;
}
print "".$locationsor." |
 |
| || ".$sor['label']." || | "; } while ( $sor = mysql_fetch_array($eredmeny)); print "
".$timesor." |
";
print " 
";
print " 
";
print "
";
print " 
";
print " 
";
print " 
";
print " 
";
echo "
";
*/
}
//TORTENET
if($lng=="hun"){
if(strlen($plot_hun)>2){
echo "| "; echo $txt['plot']; echo " | "; echo "
| "; echo nl2br($plot_hun); echo " | "; echo "
"; } } //TORTENET VEGE //CIKKEK,KRITIKAK $langfilter=""; if($lng!="hun"){ $langfilter=" AND language!='hun'"; } $parancs = "SELECT review_link,review_title,rev_id FROM reviews WHERE review_type='book' AND review_id='".$book_id."' ".$langfilter." ORDER BY LOCATE('filmo',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 "0){ ?>
";
$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 "".$txt["are_you_sure_you_delete_from_your_owns"]."?
";
print "";
?>
">
";
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_text;
}
print "0000-00-00 00:00:00
";
print "".$txt["be_the_first_to_write_in_this_topic"]."
";
print "![](".$useravatar_src.")
"; //nl2br()---konvertalja a nemlathato sortoreseket
print "
";
}
if($post_rows==$post_num_limit){
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']))."
";
print "";
print "
";
}
?>
".$txt['more_posts']."
"; print ""; ?>