Exemplos de HTML_mtree::listpending_claims em PHP

Exemplo n.º 1

Arquivo: admin.mtree.php Projeto: rsemedo/Apply-Within

function listpending_claims($option)
{
    global $mainframe;
    $database =& JFactory::getDBO();
    # Get Pathway
    $pathWay = new mtPathWay();
    $database->setQuery("SELECT COUNT(*) FROM #__mt_claims");
    $total = $database->loadResult();
    # Get all pending claims
    $sql = "SELECT r.*, u.username AS username, u.name AS name, u.email AS email, l.link_name FROM #__mt_claims 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" . "\nORDER BY r.created DESC";
    $database->setQuery($sql);
    if (!($result = $database->query())) {
        echo $database->stderr();
        return false;
    }
    $claims = $database->loadObjectList();
    HTML_mtree::listpending_claims($claims, $pathWay, $option);
}