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(); }