/** * This function is used to show a list of all books */ static function listCategories($catid) { PHP_booklibrary::addTitleAndMetaTags(); global $mainframe, $database, $my, $acl; global $mosConfig_shownoauth, $mosConfig_live_site, $mosConfig_absolute_path; global $cur_template, $Itemid, $booklibrary_configuration; //PHP_booklibrary::addTitleAndMetaTags(); $s = getWhereUsergroupsString("c"); //----------------------- $lang = JFactory::getLanguage(); $lang1 = $lang->getName(); //----------------------- //echo "<br /><pre>" . print_r($lang1, true) . "</pre>" ; exit ; $query = "SELECT c.id,c.parent_id, c.language, COUNT(bc.bookid) AS books, c.title, c.image, '1' AS display" . " FROM #__booklibrary_main_categories as c\n LEFT JOIN #__booklibrary_categories AS bc ON c.id=bc.catid \n\n LEFT JOIN #__booklibrary AS b ON b.id=bc.bookid AND b.published=1 AND b.approved=1\n WHERE c.section='com_booklibrary'\n AND c.published = 1 AND ({$s}) AND (c.langshow LIKE'" . $lang1 . "' OR c.language='' OR c.language IS NULL OR c.language='*')\n GROUP BY c.id \n\n ORDER BY parent_id DESC, c.ordering "; $database->setQuery($query); $cat_all = $database->loadObjectList(); foreach ($cat_all as $k1 => $cat_item1) { $cat_all[$k1]->display = PHP_booklibrary::is_exist_curr_and_subcategory_books($cat_all[$k1]->id); } $currentcat = NULL; // Parameters // $menu = new mosMenu( $database ); // //$menu = new JTableMenu( $database ); // for 1.6 // // $menu->load( $Itemid ); // $params = new mosParameters( $menu->params ); if (version_compare(JVERSION, '3.0', 'lt')) { $menu = new JTableMenu($database); // for 1.6 $menu->load($Itemid); $params = new mosParameters($menu->params); } else { $menu = new JTableMenu($database); $menu->load($Itemid); $params = new JRegistry(); $params->loadString($menu->params); } $params->def('pageclass_sfx', ''); $params->def('show_search', '1'); $params->def('back_button', $mainframe->getCfg('back_button')); //print_r($params);exit; //print_r($params->def('back_button', $mainframe->getCfg('back_button')));exit; // page header $currentcat = new stdClass(); $currentcat->header = ''; if (@$currentcat->name != '') { $currentcat->header = $currentcat->name; } else { $currentcat->header = $params->get('header'); } //***** begin add for Manager Suggestion: button 'Suggest a book' //********* end add for Manager Suggestion: button 'Suggest a book' ** //add for show in category picture if ($GLOBALS['cat_pic_show']) { $params->def('show_cat_pic', 1); } // page description $currentcat->descrip = _BOOKLIBRARY_DESC; // used to show table rows in alternating colours $tabclass = array('sectiontableentry1', 'sectiontableentry2'); if (checkAccessBL($booklibrary_configuration['search_field']['registrationlevel'], 'RECURSE', userGID_BL($my->id), $acl) && $booklibrary_configuration['search_field']['show']) { $params->def('search_fieldshow', 1); } $params->def('allcategories01', "{loadposition com_booklibrary_all_categories_01}"); $params->def('allcategories02', "{loadposition com_booklibrary_all_categories_02}"); $params->def('allcategories03', "{loadposition com_booklibrary_all_categories_03}"); $params->def('allcategories04', "{loadposition com_booklibrary_all_categories_04}"); $params->def('allcategories05', "{loadposition com_booklibrary_all_categories_05}"); $params->def('allcategories06', "{loadposition com_booklibrary_all_categories_06}"); $params->def('allcategories07', "{loadposition com_booklibrary_all_categories_07}"); $params->def('allcategories08', "{loadposition com_booklibrary_all_categories_08}"); $params->def('allcategories09', "{loadposition com_booklibrary_all_categories_09}"); $params->def('allcategories10', "{loadposition com_booklibrary_all_categories_010}"); //print_r($cat_all);exit; HTML_booklibrary::showCategories($params, $cat_all, $catid, $tabclass, $currentcat); }