Subversion-Projekte lars-tiefland.nagios-php

<?php
        class service
        {
                public static function getStatusList()
                {
                        $sql="SELECT
                                        count(current_state) AS anz
                                FROM
                                        servicestatus
                                WHERE
                                        instance_id = " . $GLOBALS["cfg"]["instance"] . "
                                AND
                                        current_state = 0
                        ";
                        $res = $GLOBALS["db"]->query($sql);
                        $row = $res->fetchRow();
                        $rows["ok"] = $row["anz"];
                        $sql="SELECT
                                        count(current_state) AS anz
                                FROM
                                        servicestatus
                                WHERE
                                        instance_id = " . $GLOBALS["cfg"]["instance"] . "
                                AND
                                        current_state = 1
                        ";
                        $res = $GLOBALS["db"]->query($sql);
                        $row = $res->fetchRow();
                        $rows["warning"] = $row["anz"];
                        $sql="SELECT
                                        count(current_state) AS anz
                                FROM
                                        servicestatus
                                WHERE
                                        instance_id = " . $GLOBALS["cfg"]["instance"] . "
                                AND
                                        current_state = 2
                        ";
                        $res = $GLOBALS["db"]->query($sql);
                        $row = $res->fetchRow();
                        $rows["critical"] = $row["anz"];
                        $sql="SELECT
                                        count(current_state) AS anz
                                FROM
                                        servicestatus
                                WHERE
                                        instance_id = " . $GLOBALS["cfg"]["instance"] . "
                                AND
                                        current_state = 3
                        ";
                        $res = $GLOBALS["db"]->query($sql);
                        $row = $res->fetchRow();
                        $rows["unknown"] = $row["anz"];
                        $rows["total"] = array_sum($rows);
                        return $rows;
                }
        }
?>