$sqlState = "SELECT BH.`mac`, BD.`id`, BD.`status`, DATE(BD.`datetime`) AS 'date', DATE_FORMAT(BD.`datetime`, '%H:%i') AS 'hour', DATABASE(), BH.`host`, BH.`codigosonda` AS 'code_host' FROM `bm_disponibilidad` BD JOIN `bm_host` BH ON BD.`id_host` = BH.`id_host` WHERE BD.`change_status` = 'true' AND BD.`sendtrap` = 'false' AND UNIX_TIMESTAMP(BD.`datetime`) <= UNIX_TIMESTAMP(NOW()) AND UNIX_TIMESTAMP(BD.`datetime`) >= UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 1 DAY))";
$resultState = mysql_query($sqlState, $id);
if ($snmpServer["valor"] != "" && $snmpCommunity["valor"] != "" && $snmpHeader["valor"] != "") {
echo "existen parametros\n";
while ($valueState = mysql_fetch_assoc($resultState)) {
$trapserver = $snmpServer["valor"];
$community = $snmpCommunity["valor"];
$header = $snmpHeader["valor"];
$status = "";
if ($valueState["status"] == "true") {
$status = "UP";
$header .= ".1";
} else {
$status = "DOWN";
$header .= ".2";
}
$valueState["host"] = str_replace(" ", "_", $valueState["host"]);
$valueState["code_host"] = str_replace(" ", "_", $valueState["code_host"]);
$sh = "snmptrap -v 2c -c {$community} {$trapserver} '' {$header} {$header} s \"DB=" . $valueState["DATABASE()"] . "*HST=" . $valueState["host"] . "*CDHST=" . $valueState["code_host"] . "*MC=" . $valueState["mac"] . "*DT=" . $valueState["date"] . "*HR=" . $valueState["hour"] . "*ST={$status}\"";
echo "{$sh}\n";
shell_exec($sh);
$sqlUpdateState = "UPDATE `bm_disponibilidad` SET `sendtrap` = 'true' WHERE `id` = " . $valueState["id"];
mysql_query($sqlUpdateState, $id);
}
mysql_free_result($resultState);
}
}
}
$disp = new Disponibilidad("localhost", "root", "bsw\$\$2009");
$disp->start();
