Code: Alles auswählen
$query = "SELECT
E . idcat ,
E . idart , startidartlang ,
D . pagetitle ,
C . name ,
UNIX_TIMESTAMP( D . lastmodified ) AS lastmodified
FROM
".$cfg["tab"]["cat_tree"]." AS A ,
".$cfg["tab"]["cat_lang"]." AS C ,
".$cfg["tab"]["cat"]." AS B ,
".$cfg["tab"]["cat_art"]." AS E
INNER JOIN ".$cfg["tab"]["art_lang"]." AS D ON ( E . idart = D . idart )
WHERE
A . idcat = B . idcat
AND B . idcat = C . idcat
AND C . idcat = E . idcat
AND B . idclient = '".$client."'
AND C . idlang = '".$lang."'
AND D . idlang = '".$lang."'
AND C . visible = '1'
AND E . idcatart IS NOT NULL
AND D . online = '1'
".$weiterleitungen."
".$dontshow."
ORDER BY
A . idtree, E . idart";
if ($db->f("idart") == $db->f("startidartlang")) {
// Wenn Startartikel gebe nur Kategorie aus
$link = ModRewrite::build_new_url("?idcat=$linkcat");
} else {
// Wenn kein Startartikel gebe nur Artikel aus
$link = ModRewrite::build_new_url("?idart=$linkid");
}