function listpending_cats($option)
{
global $mainframe, $mtconf;
$database =& JFactory::getDBO();
# Get Pathway
$pathWay = new mtPathWay();
# Limits
$limit = $mainframe->getUserStateFromRequest("viewlistlimit", 'limit', $mtconf->getjconf('list_limit'));
$limitstart = $mainframe->getUserStateFromRequest("viewcli{$option}limitstart", 'limitstart', 0);
$database->setQuery("SELECT COUNT(*) FROM #__mt_cats WHERE cat_approved <> '1'");
$total = $database->loadResult();
# Page Navigation
jimport('joomla.html.pagination');
$pageNav = new JPagination($total, $limitstart, $limit);
# Get all pending cats
/*
$sql = "SELECT cat.*, cimg.filename AS cat_image FROM #__mt_cats AS cat"
. "\nLEFT JOIN #__mt_cats_images AS cimg ON cimg.cat_id = cat.cat_id"
*/
$sql = "SELECT cat.* FROM #__mt_cats AS cat" . "\nWHERE cat.cat_approved <> '1'" . "\nORDER BY cat.cat_created DESC" . "\nLIMIT {$pageNav->limitstart},{$pageNav->limit}";
$database->setQuery($sql);
if (!($result = $database->query())) {
echo $database->stderr();
return false;
}
$cats = $database->loadObjectList();
HTML_mtree::listpending_cats($cats, $pathWay, $pageNav, $option);
}
