function listpending_reviewsreports($option)
{
global $mainframe;
$database =& JFactory::getDBO();
# Get Pathway
$pathWay = new mtPathWay();
$database->setQuery("SELECT COUNT(*) FROM #__mt_reports WHERE rev_id > 0 && link_id > 0");
$total = $database->loadResult();
# Get all pending reports
$sql = "SELECT r.*, rev.rev_title, rev.rev_text, u2.username AS review_username, u2.id AS review_user_id, rev.rev_date, u.username AS username, u.email AS email, l.link_name FROM #__mt_reports AS r" . "\nLEFT JOIN #__mt_reviews AS rev ON rev.rev_id = r.rev_id" . "\nLEFT JOIN #__users AS u ON u.id = r.user_id" . "\nLEFT JOIN #__users AS u2 ON u2.id = rev.user_id" . "\nLEFT JOIN #__mt_links AS l ON l.link_id = r.link_id" . "\nWHERE r.rev_id > 0 && r.link_id > 0" . "\nORDER BY r.created DESC";
$database->setQuery($sql);
if (!($result = $database->query())) {
echo $database->stderr();
return false;
}
$reports = $database->loadObjectList();
HTML_mtree::listpending_reviewsreports($reports, $pathWay, $option);
}
