PHP HTML_mtree::list_reviews示例

function list_reviews($link_id, $option)
{
    global $mainframe, $mtconf;
    $database =& JFactory::getDBO();
    # Get Link's info
    $link = new mtLinks($database);
    $link->load($link_id);
    # Get Pathway
    $pathWay = new mtPathWay($link->cat_id);
    # 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 && link_id = ' . $database->quote($link_id));
    $total = $database->loadResult();
    # Page Navigation
    jimport('joomla.html.pagination');
    $pageNav = new JPagination($total, $limitstart, $limit);
    # Get All the reviews
    $sql = "SELECT *, u.name AS username FROM #__mt_reviews AS r" . "\nLEFT JOIN #__users AS u ON u.id = r.user_id" . "\nWHERE r.rev_approved=1 && r.link_id = '" . $link_id . "'" . "\nLIMIT {$pageNav->limitstart},{$pageNav->limit}";
    $database->setQuery($sql);
    if (!($result = $database->query())) {
        echo $database->stderr();
        return false;
    }
    $reviews = $database->loadObjectList();
    HTML_mtree::list_reviews($reviews, $link, $pathWay, $pageNav, $option);
}