//Set Defaults If nothing set
$show_covers = 0;
$cover_height = "50";
$show_extra = 1;
$show_ranking = 0;
$show_this_many = "10";
$sort_top_by = 0;
$show_published = 1;
}
//Check if only display published items
if ($show_published == 1) {
$sql_published = " b.published=1 ";
$where[] = $sql_published;
}
require_once JPATH_SITE . "/components/com_booklibrary/functions.php";
$s = getWhereUsergroupsString("c");
$where[] = "( " . $s . " )";
$where[] = " c.published='1'";
//Definition of Sorts
switch ($sort_top_by) {
case 0:
$sql_sort_top = "hits";
break;
case 1:
$sql_sort_top = "date";
break;
case 2:
$sql_sort_top = "rating";
break;
}
$rank_count = 0;
static function categoryArray()
{
global $database, $my;
$s = getWhereUsergroupsString("c");
$query = "select c.id,c.parent_id, COUNT(bc.bookid) AS books, c.title, c.image, '1' AS display, c.parent_id AS parent, c.name" . " 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})\n GROUP BY c.id \n\n ORDER BY parent_id DESC, c.ordering ";
$database->setQuery($query);
$items = $database->loadObjectList();
// establish the hierarchy of the menu
$children = array();
// first pass - collect children
foreach ($items as $v) {
$pt = $v->parent;
$list = @$children[$pt] ? $children[$pt] : array();
array_push($list, $v);
$children[$pt] = $list;
}
// second pass - get an indent list of the items
$array = PHP_booklibrary::bookLibraryTreeRecurse(0, '', array(), $children);
return $array;
}
