function listpending_reviews($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_reviews WHERE rev_approved <> '1'"); $total = $database->loadResult(); # Get all pending reviews $sql = "SELECT r.*, u.username AS username, u.email AS email, l.link_name, log.value FROM #__mt_reviews 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" . "\nLEFT JOIN #__mt_log AS log ON log.link_id = r.link_id AND log.user_id = r.user_id AND log.log_type = 'vote' AND log.rev_id = r.rev_id" . "\nWHERE r.rev_approved <> '1'" . "\nORDER BY r.rev_date DESC"; $database->setQuery($sql); if (!($result = $database->query())) { echo $database->stderr(); return false; } $reviews = $database->loadObjectList(); HTML_mtree::listpending_reviews($reviews, $pathWay, $option); }