root/tags/module-NagiosStatusMap-1.1/DB-Func.php

<?
/**
Oreon is developped with GPL Licence 2.0 :
http://www.gnu.org/licenses/gpl.txt
Developped by : Julien Mathis - Romain Le Merlus - Christophe Coraboeuf

The Software is provided to you AS IS and WITH ALL FAULTS.
OREON makes no representation and gives no warranty whatsoever,
whether express or implied, and without limitation, with regard to the quality,
safety, contents, performance, merchantability, non-infringement or suitability for
any particular or intended purpose of the Software found on the OREON web site.
In no event will OREON be liable for any direct, indirect, punitive, special,
incidental or consequential damages however they may arise and even if OREON has
been previously advised of the possibility of such damages.

For information : contact@oreon-project.org
*/

        function getStatusmapcgiOpt()   {
                global $pearDB;
                global $form;
                $statusmapcgi = array();
                
                $res =& $pearDB->query("SELECT * FROM statusmapcgi_opt WHERE sopt_id = '1' LIMIT 1");
                if (PEAR::isError($pearDB)) {
                        print "Mysql Error : ".$pearDB->getMessage();
                }
                # Set base value
                $statusmapcgi = array_map("myDecode", $res->fetchRow());
                
                return $statusmapcgi;
        }       



function getActiveCgiInfo()     {
                global $pearDB;
                global $form;
                $cgi = array();
                
                $res =& $pearDB->query("SELECT * FROM cfg_cgi WHERE cgi_activate = '1' LIMIT 1");
                if (PEAR::isError($pearDB)) {
                        print "Mysql Error : ".$pearDB->getMessage();
                }
                # Set base value
                $cgi = array_map("myDecode", $res->fetchRow());
                
                return $cgi;
        }       
        
        function getHostGroups() {
                global $pearDB;
                global $oreon;
                
                $lcaHost = getLcaHostByID($pearDB);
                $lcaHostGroupstr = getLcaHGStr($lcaHost["LcaHostGroup"]);
                
        # Host Groups comes from DB -> Store in $hgs Array
        $hgs = array();
        if ($oreon->user->admin || !HadUserLca($pearDB))                
                $res =& $pearDB->query("SELECT hg_id, hg_name FROM hostgroup ORDER BY hg_name");
        else
                $res =& $pearDB->query("SELECT hg_id, hg_name FROM hostgroup WHERE hg_id IN (".$lcaHostGroupstr.") ORDER BY hg_name");
        
                if (PEAR::isError($pearDB)) {
                        print "Mysql Error : ".$pearDB->getMessage();
                }
        
        while($res->fetchInto($hg))
                $hgs[$hg["hg_id"]] = $hg["hg_name"];
        $res->free();
                
        return  $hgs;
        }
        
        
        
        function updateStatusmapcgiOptInDB ($sopt_id = NULL)    {
                if (!$sopt_id) return;
                updateStatusmapcgiOpt($sopt_id);
        }

        function updateStatusmapcifConfigData($sopt_id = null)  {
                if (!$sopt_id) return;
                global $form, $pearDB, $oreon;
                $ret = array();
                $ret = $form->getSubmitValues();
                $rq = "UPDATE `statusmapcgi_opt` SET ";
                $rq .= "nagios_statusmapcgi_html_path = ";
                isset($ret["nagios_statusmapcgi_html_path"]) && $ret["nagios_statusmapcgi_html_path"] != NULL ? $rq .= "'".htmlentities($ret["nagios_statusmapcgi_html_path"], ENT_QUOTES)."', ": $rq .= "NULL, ";
                $rq .= "nagios_statusmap_user = ";
                isset($ret["nagios_statusmap_user"]) && $ret["nagios_statusmap_user"] != NULL ? $rq .= "'".htmlentities($ret["nagios_statusmap_user"], ENT_QUOTES)."', ": $rq .= "NULL, ";
                $rq .= "nagios_statusmap_password = ";
                isset($ret["nagios_statusmap_password"]) && $ret["nagios_statusmap_password"] != NULL ? $rq .= "'".htmlentities($ret["nagios_statusmap_password"], ENT_QUOTES)."', ": $rq .= "NULL, ";
                $rq .= "nagios_statusmap_use_lca = ";           
                isset($ret["nagios_statusmap_use_lca"]["nagios_statusmap_use_lca"]) && $ret["nagios_statusmap_use_lca"]["nagios_statusmap_use_lca"] != NULL ? $rq .= "'".$ret["nagios_statusmap_use_lca"]["nagios_statusmap_use_lca"]."' ": $rq .= "NULL ";
                
                $rq .= "WHERE sopt_id = '".$sopt_id."'";
                $DBRESULT =& $pearDB->query($rq);
                if (PEAR::isError($DBRESULT))
                        print $DBRESULT->getDebugInfo()."<br>";
                $oreon->optStatusmap = array();
                $DBRESULT =& $pearDB->query("SELECT * FROM `statusmapcgi_opt` LIMIT 1");
                if (PEAR::isError($DBRESULT))
                        print $DBRESULT->getDebugInfo()."<br>";
                $oreon->optStatusmap = $DBRESULT->fetchRow();
        }
        
        
        
        
        
        
        
        
        
        
?>