Subversion-Projekte lars-tiefland.nagios-php

<?php

    class hostGroup

    {

        public $alias;

        public $hostgroup_id;

        public $members;

        public function __construct( $id )

        {

            $sql = "SELECT

                    alias,

                    hostgroup_id

                FROM

                    hostgroups

                WHERE

                    instance_id = " . $GLOBALS["cfg"]["instance"] . "

                AND

                    hostgroup_id = $id

            ";

            $res = $GLOBALS["db"]->query( $sql );

            $row = $res->fetchRow();

            foreach ( $row as $feld => $wert )

            {

                $this->$feld = $wert;

            }

            $this->members = $this->getMemberList( $id );

        }

        public static function getList()

        {

            $sql="SELECT

                    hostgroup_id

                FROM

                    hostgroups

                WHERE

                    instance_id = " . $GLOBALS["cfg"]["instance"] . "

            ";

            $res = $GLOBALS["db"]->query( $sql );

            while ( $row = $res->fetchRow() )

            {

                $ret[] = new hostGroup( $row["hostgroup_id"] );

            }

            return $ret;

        }

        public function getMemberList( $hg_id )

        {

            $sql = "SELECT

                    host_object_id

                FROM

                    hostgroup_members

                WHERE

                    instance_id = " . $GLOBALS["cfg"]["instance"] . "

                AND

                    hostgroup_id = $hg_id

            ";

            $res = $GLOBALS["db"]->query( $sql );

            while ( $row = $res->fetchRow() )

            {

                $ret[] = new host( $row["host_object_id"] );

            }

            return $ret;

        }

    }

?>