CONTENIDO Forum

Code: Alles auswählen

<?php
/***********************************************
* CONTENIDO MODUL - OUTPUT
*
* Modulname   :     w3concepts.ukatlist.v1
* Author      :     Andreas Kummer
* Copyright   :     mumprecht & kummer w3concepts
* Created     :     06-09-2004
* Modified    :     06-09-2004
************************************************/

// konfiguration
$categorie = "CMS_VALUE[0]";

$db = new DB_Contenido;
$db2 = new DB_Contenido;

// liest die unterkategorien aus der datenbank
$sql = "
	SELECT a.idcat, b.name FROM {$cfg['tab']['cat']} AS a
	LEFT JOIN {$cfg['tab']['cat_lang']} AS b ON a.idcat = b.idcat
	WHERE
		b.idlang = $lang
		AND a.parentid = $categorie
	ORDER BY b.name
	";

$db->query($sql);
    
while ($db->next_record()) {
	$categorie = $db->f("idcat");
	// liest die anzahl artikel aus der datenbank
	$sql2 = "
		SELECT count(*) AS anzahl
	                FROM {$cfg['tab']['cat']} AS a,
	                     {$cfg['tab']['cat']} AS b,
	                     {$cfg['tab']['cat']} AS c
	                LEFT JOIN {$cfg['tab']['cat_art']} AS d ON c.idcat = d.idcat
	                LEFT JOIN {$cfg['tab']['art_lang']} AS e ON d.idart = e.idart
	                WHERE
	                    (
	                        (
	                            c.parentid = b.idcat
	                            AND b.parentid = a.idcat
	                        )
	                        OR
	                        (
	                            c.idcat = b.idcat
	                            AND b.parentid = a.idcat
	                        )
	                        OR
        	                (
	                            c.idcat = b.idcat
                	            AND b.idcat = a.idcat
	                        )
	                    )
	                    AND a.idcat = $categorie
			    AND d.is_start = 0
	                    AND e.online = 1
	                    AND e.redirect = 0
	                    AND e.external_redirect = 0
	                    AND e.idlang = $lang
	         ";

	$db2->query($sql2);
	$db2->next_record();

	$unterkategorie[$db->f("name")] = array($db2->f("anzahl"),$sess->url("front_content.php?client=$client&lang=$lang&idcat=".$db->f("idcat")));
}

// ausgabe an den schirm
echo "<p>";
foreach ($unterkategorie as $bezeichner => $details) {
	echo "<a href=\"{$details[1]}\">{$bezeichner} ({$details[0]})</a><br/>";
}
echo "</p>";
?>