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); }