diese kleinen snippets finden die aktuelle anzahl artikel und kategorien einer sprache raus.
Code: Alles auswählen
// finde anzahl kategorien
$sql = "SELECT
count(c.idcat) as total
FROM
" . $cfg["tab"]["cat"] . " c
LEFT JOIN " . $cfg["tab"]["cat_lang"] . " cl ON c.idcat = cl.idcat
WHERE
c.idclient = " . (int)$client . " AND
cl.visible = 1 AND
cl.public = 1 AND
cl.idlang = " . (int)$lang;
$db->query($sql);
$db->next_record();
$arr_information["used_categories"] = $db->f("total");
// finde anzahl artikel
$sql = "SELECT
count(a.idart) as total
FROM
" . $cfg["tab"]["art"] . " a
LEFT JOIN " . $cfg["tab"]["art_lang"] . " al ON a.idart = al.idart
WHERE
a.idclient = " . (int)$client . " AND
al.online = 1 AND
al.redirect = 0 AND
al.idlang = " . (int)$lang;
$db->query($sql);
$db->next_record();
$arr_information["used_articles"] = $db->f("total");