CONTENIDO Forum

Code: Alles auswählen

<?php

include_once($cfg["path"]["contenido"].$cfg["path"]["includes"]."functions.con.php");

$catStart = "CMS_VALUE[0]";

if ($catStart != "") {
  $catIds = conDeeperCategoriesArray($catStart);

  $sqlabfrage = "SELECT COUNT(*) FROM con_cat WHERE parentid = 1";
  $db->query($sqlabfrage);
  $db->next_record();  
  $maxmenuitem = $db->f("COUNT(*)"); 

  if ( is_array($catIds) ) {

    foreach($catIds as $key=>$val) {
      // Ersten Eintrag ueberspringen, weil das der Menupunkt selbst ist
      // und nicht angezeigt werden soll.
      if ($key != 0) {

        $sql = "SELECT CAT.idcat AS idcat, name FROM ".
               $cfg["tab"]["cat"]." AS CAT, ".
               $cfg["tab"]["cat_lang"]." AS CATLANG 
               WHERE CAT.idcat = ".$val."
               AND CAT.idcat = CATLANG.idcat
               AND CATLANG.idlang = '$lang'
               AND CATLANG.visible = '1'
               AND CAT.parentid = '1'";
        
        $db->query($sql);
        
        $db2 = new DB_Contenido;

        while ( $db->next_record() ) {
        
           $target = "_self";
          
          /* Check for redirect and new window flag */
          $sql = "SELECT idart FROM ".$cfg["tab"]["cat_art"]." WHERE idcat='". $db->f("idcat")."' AND is_start = '1'";
          $db2->query($sql);
          if ($db2->next_record())
          {
                $cidart = $db2->f("idart");
                $sql = "SELECT external_redirect FROM ".$cfg["tab"]["art_lang"]." WHERE idart = '$cidart' AND idlang='$lang'";
                $db2->query($sql);
                if ($db2->next_record())
                {
                    $target = ( $db2->f("external_redirect") == 0 ) ? '_self' : '_blank';
                }
          }

          $sql3 = "SELECT * FROM con_properties WHERE name = 'medianame' AND value = 'Hauptmenu_".$db->f("name")."'";
          $db2->query($sql3);
          $db2->next_record();
          $db2->f("itemid");  //dateiname bild normal
          $teilstring = substr($db2->f("itemid"), 0, -4);
          $high = $teilstring."_high.gif";  
         
          echo '<a target="'.$target.'" href="front_content.php?idcat='.$db->f("idcat").'"><img src=upload/'.$db2->f("itemid").' border=0 onMouseOut="this.src=\'upload/'.$db2->f("itemid").'\';" onMouseOver="this.src=\'upload/'.$high.'\';"></a>';

          $maxmenuitem--;
          if($maxmenuitem > 0)
          {
            echo '<img src="images/kopf/nav_strich.gif">';
          }   
          
        } // end while
      } // if
    }  // end foreach
  } // end if (is_array)
echo '<img src="images/kopf/nav_strich_ende.gif" width="2" height="24">';
}
?>

Code: Alles auswählen

  $sqlabfrage = "SELECT COUNT(*) FROM con_cat WHERE parentid = 1";

Code: Alles auswählen

  $sqlabfrage = "SELECT COUNT(*) FROM con_cat WHERE parentid = '$catStart'";

Code: Alles auswählen

        $sql = "SELECT CAT.idcat AS idcat, name FROM ". 
               $cfg["tab"]["cat"]." AS CAT, ". 
               $cfg["tab"]["cat_lang"]." AS CATLANG 
               WHERE CAT.idcat = ".$val." 
               AND CAT.idcat = CATLANG.idcat 
               AND CATLANG.idlang = '$lang' 
               AND CATLANG.visible = '1' 
               AND CAT.parentid = '1'";

Code: Alles auswählen

        $sql = "SELECT CAT.idcat AS idcat, name FROM ". 
               $cfg["tab"]["cat"]." AS CAT, ". 
               $cfg["tab"]["cat_lang"]." AS CATLANG 
               WHERE CAT.idcat = ".$val." 
               AND CAT.idcat = CATLANG.idcat 
               AND CATLANG.idlang = '$lang' 
               AND CATLANG.visible = '1' 
               AND CAT.parentid = '$catStart'";

Code: Alles auswählen

<?php
/***********************************************
* Bottom Navigation Output
*
* Author      :     Willi Man
* Copyright   :     four for business AG
* Version	  : 	1.0
* Created     :     17-03-2005
* Modified    :     05-08-2005, Andreas Lindner
************************************************/

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


#Includes
cInclude("frontend", "includes/functions.navigation.php");
cInclude('classes', 'class.template.php');

#Get settings	
$cApiClient = new cApiClient($client);
$catStart = $cApiClient->getProperty('navigation', 'Fußnotennavigation');

if (!is_object($oClient)) {
	$oClient = new cApiClient($client);
}

#Get sub categories
$navigation = array ();
$navigation = createNavigationArray($catStart, $db);

#Output sub categories
$output = '';
if (count($navigation) > 0) {
	foreach ($navigation as $key => $data) {
		$output .= '<a href="'.$sess->url("front_content.php?idcat=".$data['idcat']).'" class="bottomnavi" title="'.$data['name'].'">'.$data['name'].'</a> | ';
	}
}
if (strlen($output) > 0) {
	$output = substr($output, 0, strlen($output) - 3);
}

echo $output;
?>