static function getAllCMSCategories($langId, $parentId = 0, $sp = '', $arr = null)
{
if ($arr == null) {
$arr = array();
}
$items = DB::getInstance()->executeS("Select c.id_cms_category, cl.name From " . _DB_PREFIX_ . "cms_category as c Inner Join " . _DB_PREFIX_ . "cms_category_lang as cl On c.id_cms_category = cl.id_cms_category Where c.id_parent = {$parentId} AND cl.id_lang = " . $langId);
if ($items) {
foreach ($items as $item) {
$arr[] = array('id_cms_category' => $item['id_cms_category'], 'name' => $item['name'], 'sp' => $sp);
$arr = VerticalMegaMenusLibraries::getAllCMSCategories($langId, $shopId, $item['id_cms_category'], $sp . '|- ', $arr);
}
}
return $arr;
}
