Subversion-Projekte lars-tiefland.nagios-php

Revision

Revision 44 | Revision 47 | 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 
    {
42 lars 5 
        public $display_name;
6 
        public $host_id;
7 
        public $host_object_id;
8 
 
9 
        public function __construct($id)
10 
        {
11 
            $sql="SELECT
12 
                    host_id,
13 
                    display_name,
14 
                    host_object_id
15 
                FROM
16 
                    hosts
17 
                WHERE
18 
                    host_id = $id
19 
                AND
20 
                    instance_id = " . $GLOBALS["cfg"]["instance"] . "
21 
            ";
22 
            $res = $GLOBALS["db"]->query($sql);
44 lars 23 
            $row = $res->fetchRow();
24 
            //$this->host_id=$row["host_id"];
25 
            foreach($row as $feld => $wert)
26 
            {
45 lars 27 
                $this->$feld = $wert;
44 lars 28 
            }
42 lars 29 
        }
9 lars 30 
        public static function getStatusList()
31 
        {
32 
            $sql = "SELECT
1 lars 33 
					count(current_state) AS anz
34 
				FROM
35 
					hoststatus
36 
				WHERE
37 
					instance_id = " . $GLOBALS["cfg"]["instance"] . "
38 
				AND
39 
					current_state = 0
40 
			";
9 lars 41 
            $res = $GLOBALS["db"]->query( $sql );
42 
            $row = $res->fetchRow();
43 
            $rows["up"] = $row["anz"];
44 
            $sql = "SELECT
1 lars 45 
					count(current_state) AS anz
46 
				FROM
47 
					hoststatus
48 
				WHERE
49 
					instance_id = " . $GLOBALS["cfg"]["instance"] . "
50 
				AND
51 
					current_state = 1
52 
			";
9 lars 53 
            $res = $GLOBALS["db"]->query( $sql );
54 
            $row = $res->fetchRow();
55 
            $rows["down"] = $row["anz"];
56 
            $sql = "SELECT
1 lars 57 
					count(current_state) AS anz
58 
				FROM
59 
					hoststatus
60 
				WHERE
61 
					instance_id = " . $GLOBALS["cfg"]["instance"] . "
62 
				AND
63 
					current_state = 2
64 
			";
9 lars 65 
            $res = $GLOBALS["db"]->query( $sql );
66 
            $row = $res->fetchRow();
67 
            $rows["unreachable"] = $row["anz"];
68 
            $rows["total"] = array_sum( $rows );
69 
            return $rows;
70 
        }
71 
    }
72 
 
1 lars 73 
?>