0"); $cattotal = db_single("SELECT COUNT(*) FROM ".TBL_PREFIX."navi"); } else { $item_res = db_query("SELECT n.ID, count(i.ID) as anzahl FROM ".TBL_PREFIX."navi AS n LEFT JOIN ".TBL_PREFIX."item AS i ON i.itemgrID=n.ID LEFT JOIN ".TBL_PREFIX."it_sh AS ish ON ish.shopID=".SHOP_ID." and ish.itemID=i.ID WHERE (i.visible>0 AND i.visible!=4) AND (i.shopID=".SHOP_ID." OR (ish.itemID=i.ID AND ish.shopID=".SHOP_ID.")) GROUP BY n.id",1); while ($item_row = db_fetch_row($item_res)) { $itemtotal += $item_row[1]; $cattotal++; } } echo "

"; if(LANG=="de") echo "Derzeit sind $itemtotal Artikel in $cattotal Kategorien online."; else echo "There $itemtotal items in $cattotal categories online."; echo "

"; ?>