function createMonitorEvent($event_date, $event_type, $event_sub_type, $event_description, $event_client_name, $event_tags)
{
global $mysqlCon;
$event_client_name = findClientNameFromParams($event_date, $event_type, $event_sub_type, $event_description, $event_client_name, $event_tags);
$query = "INSERT INTO monitoring_event (event_date, event_type, event_sub_type, event_description, client_name, tags) VALUES (";
$query .= "'" . escapeString(date('Y-m-d H:i:s')) . "'";
$query .= ",'" . escapeString($event_type) . "'";
$query .= ",'" . escapeString($event_sub_type) . "'";
$query .= ",'" . escapeString($event_description) . "'";
$query .= ",'" . escapeString($event_client_name) . "'";
$query .= ",'" . escapeString($event_tags) . "'";
$query .= ' )';
mysqli_query($mysqlCon, $query);
$textMessage = $event_type . ": " . $event_description;
sendToSlack($textMessage, $event_type);
}
<?php
require_once dirname(__FILE__) . '/init.php';
$query = "SELECT * from monitoring_event ORDER BY event_date ASC";
$cnt = null;
$res = mysqli_query($mysqlCon, $query);
while ($t = mysqli_fetch_assoc($res)) {
//var_dump($t);
$event_id = $t['id'];
$event_date = $t['event_date'];
$event_type = $t['event_type'];
$event_sub_type = $t['event_sub_type'];
$event_description = $t['event_description'];
$client_name = $t['client_name'];
$event_tags = $t['tags'];
$new_client_name = findClientNameFromParams($event_date, $event_type, $event_sub_type, $event_description, $client_name, $event_tags);
if ($new_client_name != $client_name) {
$query = "UPDATE monitoring_event SET client_name=";
$query .= "'" . escapeString($new_client_name) . "'";
$query .= " WHERE id=" . $event_id;
echo "\n" . $query;
mysqli_query($mysqlCon, $query);
}
}
echo "\nOK\n";
