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 host
4 
    {
5 
        public static function getStatusList()
6 
        {
7 
            $sql = "SELECT
1 lars 8 
					count(current_state) AS anz
9 
				FROM
10 
					hoststatus
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["up"] = $row["anz"];
19 
            $sql = "SELECT
1 lars 20 
					count(current_state) AS anz
21 
				FROM
22 
					hoststatus
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["down"] = $row["anz"];
31 
            $sql = "SELECT
1 lars 32 
					count(current_state) AS anz
33 
				FROM
34 
					hoststatus
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["unreachable"] = $row["anz"];
43 
            $rows["total"] = array_sum( $rows );
44 
            return $rows;
45 
        }
46 
    }
47 
 
1 lars 48 
?>