Solved Customize categories WHERE clause

function displayList($tpl = null) { $this->Itemid = $this->get ( 'Itemid' ); $this->category = $this->get ( 'Category' ); if ($this->category->id && ! $this->category->authorise('read')) { $this->setError($this->category->getError()); } $this->message_ordering = $this->me->getMessageOrdering(); $this->categories = $this->get ( 'Categories' ); $this->pending = $this->get ( 'UnapprovedCount' ); $this->moderators = $this->get ( 'Moderators' ); $this->sections = isset($this->categories[0]) ? $this->categories[0] : array(); if ($this->category->isSection()) { // TODO: turn this on: /* if ($this->me->isAdmin($this->category)) { $url = "index.php?option=com_kunena&view=category&layout=manage&catid={$this->category->id}"; $this->category_manage = $this->getButton($url, 'manage', 'category', 'moderation'); }*/ } if ($this->me->exists()) { $this->markAllReadURL = KunenaRoute::_(); } $errors = $this->getErrors(); if ($errors) { $this->displayNoAccess($errors); return; } /*******************************************************************************************/ // here i add some code to hack category list, i need to display current language categories only! // i manage categories by placing the lang-code [en, fr, ...] before the category name itself (like en-website-category, fr-website-category, ...) //retrieve lang code $jcsoft_language = &JFactory::getLanguage(); $jcsoft_lang_code_array = explode('-',$jcsoft_language->getTag()); $jcsoft_lang_code = $jcsoft_lang_code_array[0]; //check if there are categories in other languages and unset them foreach ($this->categories as $jc_idx => $jc_main_cat) { foreach($jc_main_cat as $jc_inner_idx => $jc_cat) { $jc_cat_explo = explode("-", $jc_cat->alias); $jc_cat_lang = $jc_cat_explo[0]; if($jcsoft_lang_code==$jc_cat_lang) { // this is what i need! -do nothing- } else { // don't want these categories, remove from array unset($this->categories[$jc_idx][$jc_inner_idx]); } } } // finally check if there are some empty main categories (the parents of the removed ones) and unset them foreach($this->categories as $jc_idx => $jc_main_cat) { if(empty($jc_main_cat)) { unset($this->categories[$jc_idx]); unset($this->sections[$jc_idx]); } } // that's it, now it can be displayed /*******************************************************************************************/ $this->_prepareDocument('list'); $this->display ($tpl); }