function listpending_claims($option) { global $mainframe; $database =& JFactory::getDBO(); # Get Pathway $pathWay = new mtPathWay(); $database->setQuery("SELECT COUNT(*) FROM #__mt_claims"); $total = $database->loadResult(); # Get all pending claims $sql = "SELECT r.*, u.username AS username, u.name AS name, u.email AS email, l.link_name FROM #__mt_claims AS r" . "\nLEFT JOIN #__users AS u ON u.id = r.user_id" . "\nLEFT JOIN #__mt_links AS l ON l.link_id = r.link_id" . "\nORDER BY r.created DESC"; $database->setQuery($sql); if (!($result = $database->query())) { echo $database->stderr(); return false; } $claims = $database->loadObjectList(); HTML_mtree::listpending_claims($claims, $pathWay, $option); }