CONTENIDO Forum

Code: Alles auswählen

<?php
/***********************************************
* CONTENIDO MODUL - OUTPUT
*
* Modulname  	:     	Hauptnavigation 2.1
* Author(s)   	:     	Jan Lengowski, Andreas Lindner, 4fb
* Author(V2) 	: 		Christian Bachmann
* Copyright   	:     	Contenido - four for business, Andreas Lindner
* Created     	:     	12.08.2005
* V2			:		04.10.2006
************************************************/

#System properties in use:
#Type: navigation, Name: idcat_homepage
#Contains idcat of tree to be displayed in main navigation

#Includes


#Includes
cInclude("frontend", "includes/functions.navigation.php");


/* Include Template Class */
include_once($cfg["path"]["contenido"] . 'classes/class.template.php');

#If no tree is selected, use client setting
$start_cat = "CMS_VALUE[0]";

/* Template Instance */
$tpl = new Template;

/* Start Output buffer */
ob_start();




	
global $cfg, $client, $lang;
// second db class instance
$db = new DB_Contenido;
$db2 = new DB_Contenido;
$db3 = new DB_Contenido;
$db4 = new DB_Contenido;
$db5 = new DB_Contenido;
$db6 = new DB_Contenido;

//Navigation 1
$sql = "SELECT
			A.idcat,
			C.name,
			C.public,
			C.idcatlang
		FROM
			".$cfg["tab"]["cat_tree"]." AS A,
			".$cfg["tab"]["cat"]." AS B,
			".$cfg["tab"]["cat_lang"]." AS C
		WHERE
			A.idcat     = B.idcat   AND
			B.idcat     = C.idcat   AND
			B.idclient  = '$client' AND
			C.idlang    = '$lang'   AND
			C.visible   = '1'       AND
			B.parentid  = '".$start_cat."'
		ORDER
			BY A.idtree";

$db->query($sql);	
while ($db->next_record()) {	
	/* Check for external redirects... */
	$sql = "SELECT
				a.external_redirect AS ext,
				a.idartlang AS idartlang
			FROM
				".$cfg["tab"]["art_lang"]." AS a,
				".$cfg["tab"]["cat_art"]." AS b,
				".$cfg["tab"]["cat"]." AS c
			WHERE
				b.idcat     = '".$db->f("idcat")."' AND
				c.idclient  = '".$client."' AND
				c.idcat     = b.idcat AND
				a.idart     = b.idart AND
				a.idlang    = '".$lang."'";
	
	$db2->query($sql);
	$flag = false;
	while ($db2->next_record()&&!$flag) {
		if (isStartArticle($db2->f("idartlang"), $db->f("idcat"), $lang))
		{
			$flag = true;
			$target = ( $db2->f("ext") == 0 ) ? '_self' : '_blank';
			/* 1. Navigations Ebene */
			$tpl->reset();
			$tpl->set('d', 'NAME', $db->f("name"));
			$tpl->set('d', 'TARGET', $target);
			$tpl->set('d', 'HREF',  $sess->url('front_content.php?idcat='.$db->f("idcat")));
			$tpl->next();
			$tpl->generate('templates/navfirst_on.html');
		}
	}
	
	//Navigation 2
	$sql = "SELECT
				A.idcat,
				C.name,
				C.public,
				C.idcatlang
			FROM
				".$cfg["tab"]["cat_tree"]." AS A,
				".$cfg["tab"]["cat"]." AS B,
				".$cfg["tab"]["cat_lang"]." AS C
			WHERE
				A.idcat     = B.idcat   AND
				B.idcat     = C.idcat   AND
				B.idclient  = '$client' AND
				C.idlang    = '$lang'   AND
				C.visible   = '1'       AND
				B.parentid  = '".$db->f("idcat")."'
			ORDER
				BY A.idtree";
	
		  $db3->query($sql);
	
	  while ($db3->next_record()) {	
		/* Check for external redirects... */
		$sql = "SELECT
					a.external_redirect AS ext,
					a.idartlang AS idartlang
				FROM
					".$cfg["tab"]["art_lang"]." AS a,
					".$cfg["tab"]["cat_art"]." AS b,
					".$cfg["tab"]["cat"]." AS c
				WHERE
					b.idcat     = '".$db3->f("idcat")."' AND
					c.idclient  = '".$client."' AND
					c.idcat     = b.idcat AND
					a.idart     = b.idart AND
					a.idlang    = '".$lang."'";

		$db4->query($sql);
		$flag = false;
		while ($db4->next_record()&&!$flag) {
			if (isStartArticle($db4->f("idartlang"), $db3->f("idcat"), $lang))
			{
				$flag = true;
				$target = ( $db4->f("ext") == 0 ) ? '_self' : '_blank';
			
				$tpl->reset();
				$tpl->set('d', 'NAME', $db3->f("name"));
				$tpl->set('d', 'TARGET', $target);
				$tpl->set('d', 'HREF',  $sess->url('front_content.php?idcat='.$db3->f("idcat")));
				$tpl->next();
				$tpl->generate('templates/navsecond_on.html');

			}
		}	
		
		//Navigation 3
		$sql = "SELECT
					A.idcat,
					C.name,
					C.public,
					C.idcatlang
				FROM
					".$cfg["tab"]["cat_tree"]." AS A,
					".$cfg["tab"]["cat"]." AS B,
					".$cfg["tab"]["cat_lang"]." AS C
				WHERE
					A.idcat     = B.idcat   AND
					B.idcat     = C.idcat   AND
					B.idclient  = '$client' AND
					C.idlang    = '$lang'   AND
					C.visible   = '1'       AND
					B.parentid  = '".$db3->f("idcat")."'
				ORDER
					BY A.idtree";
		
			  $db5->query($sql);
		
		  while ($db5->next_record()) {	
			/* Check for external redirects... */
			$sql = "SELECT
						a.external_redirect AS ext,
						a.idartlang AS idartlang
					FROM
						".$cfg["tab"]["art_lang"]." AS a,
						".$cfg["tab"]["cat_art"]." AS b,
						".$cfg["tab"]["cat"]." AS c
					WHERE
						b.idcat     = '".$db5->f("idcat")."' AND
						c.idclient  = '".$client."' AND
						c.idcat     = b.idcat AND
						a.idart     = b.idart AND
						a.idlang    = '".$lang."'";
	
			$db6->query($sql);
			$flag = false;
			while ($db6->next_record()&&!$flag) {
				if (isStartArticle($db6->f("idartlang"), $db5->f("idcat"), $lang))
				{
					$flag = true;
					$target = ( $db6->f("ext") == 0 ) ? '_self' : '_blank';
	
					
					/* 3. Navigations Ebene */
					$tpl->reset();
					$tpl->set('d', 'NAME',  $db5->f("name"));
					$tpl->set('d', 'TARGET', $target);
					$tpl->set('d', 'HREF',  $sess->url('front_content.php?idcat='.$db5->f("idcat")));
					$tpl->next();
					$tpl->generate('templates/navthird_on.html');
					
				}
			}
		}					
	}
}


/* Read out buffer */
$html = ob_get_contents();

/* Clean buffer */
ob_end_clean();

/* Output buffer-contents */
echo $html;     

?>