phpBB.de

Code: Alles auswählen

if($mode == "viewseason"){
	
	$serie 		= $_REQUEST["id"];	

	$sql = "SELECT c.*, p.*
		FROM ". EPG_SERIE_TABLE ." AS c 
		LEFT JOIN ". EPG_FOLGEN_TABLE ." AS p ON c.serie_id = p.serie_id
		WHERE c.serie_id = ".$serie."
		GROUP BY p.serie_id";
		
	if( !($result = $db->sql_query($sql)) )
	{
	message_die(GENERAL_ERROR, 'Could not query Serien information', '', __LINE__, __FILE__, $sql);
	}
				
	while( $row = $db->sql_fetchrow($result) )
	{
		$folgen_id = $row['folge_id'];
		$folgen_title = $row['folge_title'];
		$folgen_desc = $row['folge_desc'];
		$folgen_img = $row['folge_img'];
		
		$season_id = $row['season_id'];
		
		$serie_id = $row['serie_id'];
		$serie_title = $row['serie_title'];
				
		$template->assign_block_vars('season', array(		
		'SERIE_TITLE' => $serie_title,
		'SEASON_ID' => $season_id,		
		'FOLGEN_ID' => $folgen_id,
		'FOLGEN_TITLE' => $folgen_title,
		));
				
	}
	
	$template->assign_block_vars('menue', array(
																			
		// Navigation Lexikon
			'L_EPG_LEXIKON' => $lang['EPG_LEXIKON'],
			'U_EPG_LEXIKON' => $link['EPG_LEXIKON'],
	
		// Navigation Lexikon
			'L_EPG_TV' => $lang['EPG_TV'],
			'U_EPG_TV' => $link['EPG_TV'],
	
		// Navigation Authoren
			'L_EPG_AUTHOREN' => $lang['EPG_AUTHOREN'],
			'U_EPG_AUTHOREN' => $link['EPG_AUTHOREN'],
	
		// Navigation Bio
			'L_EPG_BIOGRAFIE' => $lang['EPG_BIOGRAFIE'],
			'U_EPG_BIOGRAFIE' => $link['EPG_BIOGRAFIE'],
				
		// Navigation Bio
			'L_EPG_CHARACKTERE' => $lang['EPG_CHARACKTERE'],
			'U_EPG_CHARACKTERE' => $link['EPG_CHARACKTERE'],
				
	));	
								
}