Subversion-Projekte lars-tiefland.nagios-php

Revision

Revision 1 | Revision 42 | Zur aktuellen Revision | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<?php
9 lars 2 
 
3 
    class service
4 
    {
5 
        public static function getStatusList()
6 
        {
7 
            $sql = "SELECT
1 lars 8 
					count(current_state) AS anz
9 
				FROM
10 
					servicestatus
11 
				WHERE
12 
					instance_id = " . $GLOBALS["cfg"]["instance"] . "
13 
				AND
14 
					current_state = 0
15 
			";
9 lars 16 
            $res = $GLOBALS["db"]->query( $sql );
17 
            $row = $res->fetchRow();
18 
            $rows["ok"] = $row["anz"];
19 
            $sql = "SELECT
1 lars 20 
					count(current_state) AS anz
21 
				FROM
22 
					servicestatus
23 
				WHERE
24 
					instance_id = " . $GLOBALS["cfg"]["instance"] . "
25 
				AND
26 
					current_state = 1
27 
			";
9 lars 28 
            $res = $GLOBALS["db"]->query( $sql );
29 
            $row = $res->fetchRow();
30 
            $rows["warning"] = $row["anz"];
31 
            $sql = "SELECT
1 lars 32 
					count(current_state) AS anz
33 
				FROM
34 
					servicestatus
35 
				WHERE
36 
					instance_id = " . $GLOBALS["cfg"]["instance"] . "
37 
				AND
38 
					current_state = 2
39 
			";
9 lars 40 
            $res = $GLOBALS["db"]->query( $sql );
41 
            $row = $res->fetchRow();
42 
            $rows["critical"] = $row["anz"];
43 
            $sql = "SELECT
1 lars 44 
					count(current_state) AS anz
45 
				FROM
46 
					servicestatus
47 
				WHERE
48 
					instance_id = " . $GLOBALS["cfg"]["instance"] . "
49 
				AND
50 
					current_state = 3
51 
			";
9 lars 52 
            $res = $GLOBALS["db"]->query( $sql );
53 
            $row = $res->fetchRow();
54 
            $rows["unknown"] = $row["anz"];
55 
            $rows["total"] = array_sum( $rows );
56 
            return $rows;
57 
        }
58 
    }
59 
 
1 lars 60 
?>