public function getSitesIndex() {

        if ($this->isValueNumeric('nb_server_id')) {
            $retval = CNabuSite::buildObjectListFromSQL('nb_site_id',
                    "SELECT distinct si.*
                       FROM nb_site si
                      INNER JOIN nb_cluster_group cg
                         ON si.nb_cluster_group_id=cg.nb_cluster_group_id
                      INNER JOIN nb_cluster_group_service cgs
                         ON cg.nb_cluster_group_id=cgs.nb_cluster_group_id
                      INNER JOIN nb_server_host sh
                         ON cgs.nb_cluster_group_service_id=sh.nb_cluster_group_service_id
                      INNER JOIN nb_server se
                         ON sh.nb_server_id=se.nb_server_id
                        AND se.nb_server_id=%server_id\$d
                      INNER JOIN nb_site_alias sa
                         ON si.nb_site_id=sa.nb_site_id
                      ORDER BY si.nb_site_mounting_order ASC",
                    array('server_id' => $this->getValue('nb_server_id'))
            );
        } else {
            $retval = new CNabuSiteList();
        }

        return $retval;
    }
public function getSitesIndex() {

        if ($this->isValueNumeric('nb_server_id')) {
            $retval = CNabuSite::buildObjectListFromSQL('nb_site_id',
                    "SELECT distinct si.*
                       FROM nb_site si
                      INNER JOIN nb_cluster_group cg
                         ON si.nb_cluster_group_id=cg.nb_cluster_group_id
                      INNER JOIN nb_cluster_group_service cgs
                         ON cg.nb_cluster_group_id=cgs.nb_cluster_group_id
                      INNER JOIN nb_server_host sh
                         ON cgs.nb_cluster_group_service_id=sh.nb_cluster_group_service_id
                      INNER JOIN nb_server se
                         ON sh.nb_server_id=se.nb_server_id
                        AND se.nb_server_id=%server_id\$d
                      INNER JOIN nb_site_alias sa
                         ON si.nb_site_id=sa.nb_site_id
                      ORDER BY si.nb_site_mounting_order ASC",
                    array('server_id' => $this->getValue('nb_server_id'))
            );
        } else {
            $retval = new CNabuSiteList();
        }

        return $retval;
    }
public function getSitesIndex ( ) { if ( $ this -> isValueNumeric ( 'nb_server_id' ) ) { $ retval = CNabuSite :: buildObjectListFromSQL ( 'nb_site_id' , "SELECT distinct si.*
                       FROM nb_site si
                      INNER JOIN nb_cluster_group cg
                         ON si.nb_cluster_group_id=cg.nb_cluster_group_id
                      INNER JOIN nb_cluster_group_service cgs
                         ON cg.nb_cluster_group_id=cgs.nb_cluster_group_id
                      INNER JOIN nb_server_host sh
                         ON cgs.nb_cluster_group_service_id=sh.nb_cluster_group_service_id
                      INNER JOIN nb_server se
                         ON sh.nb_server_id=se.nb_server_id
                        AND se.nb_server_id=%server_id\$d
                      INNER JOIN nb_site_alias sa
                         ON si.nb_site_id=sa.nb_site_id
                      ORDER BY si.nb_site_mounting_order ASC" , array ( 'server_id' => $ this -> getValue ( 'nb_server_id' ) ) ) ; } else { $ retval = new CNabuSiteList ( ) ; } return $ retval ; }
Get all available sites to be indexed in the Web Server
@return CNabuSiteList Returns a list of all available sites if someone exists.
Get all available sites to be indexed in the Web Server