Exemplo n.º 1
0
function listpending_links($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_links WHERE link_approved < 1');
    $total = $database->loadResult();
    # Page Navigation
    jimport('joomla.html.pagination');
    $pageNav = new JPagination($total, $limitstart, $limit);
    # Get all pending links
    $sql = "SELECT * FROM #__mt_links" . "\nWHERE link_approved < '1'" . "\nORDER BY link_created ASC, link_modified DESC" . "\nLIMIT {$pageNav->limitstart},{$pageNav->limit}";
    $database->setQuery($sql);
    if (!($result = $database->query())) {
        echo $database->stderr();
        return false;
    }
    $links = $database->loadObjectList();
    HTML_mtree::listpending_links($links, $pathWay, $pageNav, $option);
}