ss_temperature_room.php

<?php
require_once("/home/cacti/www_secure/db.php");

/* do NOT run this script through a web browser */
if (!isset($_SERVER["argv"][0]) || isset($_SERVER['REQUEST_METHOD'])  || isset($_SERVER['REMOTE_ADDR'])) {
    die("<br><strong>This script is only meant to run at the command line.</strong>");
}

$no_http_headers = true;

/* display ALL errors */
error_reporting(0);

if (!isset($called_by_script_server)) {
    include_once(dirname(__FILE__) . "/../include/global.php");
    
    array_shift($_SERVER['argv']);

    print call_user_func_array("ss_temperature", $_SERVER['argv']);
}

function ss_temperature($room) {
    $idb = db_link();
    $query = "SELECT t.name as name, t.temperature as temperature FROM temperature t WHERE name IS NOT NULL and timestampdiff(minute, t.time, UTC_TIMESTAMP()) < 20";

    $result = $idb->query($query);
    $output = "";

    while ($row = $result->fetch_object()) {
        if ($row->name == $room) {
            return 'Temperature:'.$row->temperature;
        }
    }

    return "";
}

?>