function listpending_reviewsreply($option)
{
global $mainframe;
$database =& JFactory::getDBO();
# Get Pathway
$pathWay = new mtPathWay();
# Get all pending owner's reply
$sql = "SELECT r.*, u.username AS username, owner.username AS owner_username, owner.id AS owner_user_id, owner.email AS owner_email, u.email AS email, l.link_name 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 #__users AS owner ON owner.id = l.user_id" . "\nWHERE r.ownersreply_approved = '0' AND r.ownersreply_text != ''" . "\nORDER BY r.ownersreply_date DESC";
$database->setQuery($sql);
if (!($result = $database->query())) {
echo $database->stderr();
return false;
}
$reviewreplies = $database->loadObjectList();
HTML_mtree::listpending_reviewsreply($reviewreplies, $pathWay, $option);
}
