Subversion-Projekte lars-tiefland.nagios-php

    $GLOBALS["ui"]->assign( "cfg", $GLOBALS["cfg"] );

    $GLOBALS["ui"]->assign( "nagiosVersion", getNagiosVersion() );

    $GLOBALS["ui"]->assign( "programStatus", getProgramStatus() );

    $GLOBALS["ui"]->assign( "runtimeInfo", getRuntimeInfo() );

    function getNagiosVersion()

    {

        $sql = "SELECT

                program_version

            FROM

                processevents pe

            JOIN

                programstatus ps

            ON

                pe.event_time = ps.progrram_starttime

            WHERE

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

            AND

                pe.instance_id = ps.instance_id

            AND

                pe.pprocess_id = ps.process_id

        ";

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

        $row = $res->fetchRow();

        return $row["program_version"];

    }

    function getProgramStatus()

    {

        $sql = "SELECT

                *

            FROM

                programstatus ps

            WHERE

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

        ";

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

        $info = $res->fetchAll();

        return $info;

    }

    function getRuntimeInfo()

    {

        $sql = "SELECT

                varname,

                varvalue

            FROM

                runtimevariables

            WHERE

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

        ";

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

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

        {

            $ret[$row["varname"]] = $row["varvalue"];

        }

        return $ret;