set_include_path('/usr/share/ossim/include');
require_once 'av_init.php';
$conf = $GLOBALS["CONF"];
$mdays = $conf->get_conf("tickets_max_days");
$send_mail = strtolower($conf->get_conf("tickets_send_mail"));
if ($send_mail == "no") {
exit;
}
$db = new ossim_db();
$conn = $db->connect();
$user = '******';
// login the user
$session = new Session($user, '', '');
$session->login(TRUE);
$dbpass = $conn->GetOne('SELECT pass FROM users WHERE login = ?', array($user));
$client = new Alienvault_client($user);
$client->auth()->login($user, $dbpass);
if ($result = $conn->execute("SELECT * FROM incident_tmp_email")) {
while (!$result->EOF) {
$incident_id = $result->fields["incident_id"];
$ticket_id = $result->fields["ticket_id"];
Incident_ticket::mail_notification($conn, $incident_id, $ticket_id);
if (ossim_error()) {
echo ossim_error() . "\n";
}
ossim_set_error(FALSE);
$conn->Execute('DELETE FROM incident_tmp_email WHERE incident_id = ?', array($incident_id));
$result->MoveNext();
}
}
$db->close($conn);
