protected static function subTree(&$categories, $category_id, &$n)
{
$left = $n++;
$db = JFactory::getDBO();
if (isset($categories[(int) $category_id]['subcategories'])) {
foreach ($categories[(int) $category_id]['subcategories'] as $subcategory_id) {
JeproshopCategoryModelCategory::subTree($categories, (int) $subcategory_id, $n);
}
}
$right = (int) $n++;
$query = "UPDATE " . $db->quoteName('#__jeproshop_category') . " SET n_left = " . (int) $left . ", n_right = " . (int) $right;
$query .= "\tWHERE category_id = " . (int) $category_id . " LIMIT 1";
$db->setQuery($query);
$db->query();
}
