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