#!/usr/bin/php
<?php

include "/usr/local/opmon/etc/config.php";

set_logged_user("opmonadmin");
$mod = "EXTERNAL";


$query = "SELECT host_id, host_name, service_description from opmon4.service_status;";
$ret = do_query($query, DBOPMON, OPDB_FETCH_OBJ);
while(!$ret->EOF) {
	if (isset($ret->fields->host_id)) {
		print "Fixing current_state for ".$ret->fields->host_name." - ".$ret->fields->service_description."...\t\t";
		$table = "service_state_change_".$ret->fields->host_id;
		$upSql = "update ".$table." set current_state = 1 where display_status = 4;";
		do_query($upSql, DBOPMON);
		$upSql = "update ".$table." set current_state = 2 where display_status = 6;";
		do_query($upSql, DBOPMON);

		$table = "host_state_change_".$ret->fields->host_id;
		$upSql = "update ".$table." set current_state = 1 where display_status = 8;";
		do_query($upSql, DBOPMON);
		$upSql = "update ".$table." set current_state = 2 where display_status = 7;";
		do_query($upSql, DBOPMON);
		print "Done.\n";
	}
	$ret->MoveNext();
}
exit(0);

?>