#!/usr/bin/php
<?php

include("/usr/lib/nagios/plugins/mssql_connect.php");

$site_id = $argv[1];
$warn = $argv[2];
$crit = $argv[3];

if ( $argc < 4 )
{
        echo("Not enough args\n"); exit(3);
}

$row = false;
$retries = 2;
while ( (! $row ) && ($retries > 0) )
{
    $records = mssql_query('EXECUTE nagios_GetMinutesSinceLastReading ' . $site_id);
    $row = mssql_fetch_array($records);
    $rows = mssql_num_rows($records);
    $retries--;
    if ( ! $row )
    {
        usleep(100);
    }
}

if ( (! $row ) || (mssql_num_rows($records) < 1) || (! is_numeric($row[0])) )
{
        echo("*-*-* No data for site - " . $site_id ." *-*-*\n");
        exit(3);
}

$mins = $row[0];
$days = intval($mins / 1440);
$result = "";
if ($days == 1) $result = "1 day ";
if ($days > 1) $result = $days . " days ";
$mm = $mins - $days * 1440;
$result .= sprintf("%02d:%02d", $mm / 60, $mm % 60);

if ( $mins < $warn )
{
        echo("OK: " . $result . " - " . $site_id . "\n");
        exit(0);
}

elseif ( $mins < $crit )
{
        echo("WARN: " . $result . " - " . $site_id . "\n");
        exit(1);
}

else
{
        echo("CRITICAL: " . $result . " - " . $site_id . "\n");
        exit(2);
}

echo("end!");

?>