$stmt->execute(array(':client_tel' => $client_tel, ':client_login' => $client_login, ':unit_desc' => $unit_desc, ':client_adr' => $client_adr, ':client_mail' => $client_mail, ':client_posada' => $client_posada, ':client_id_param' => $client_id_param));
$stmt = $dbConnection->prepare("SELECT MAX(id) max_id FROM tickets");
$stmt->execute();
$max_id_ticket = $stmt->fetch(PDO::FETCH_NUM);
$max_id_res_ticket = $max_id_ticket[0] + 1;
$stmt = $dbConnection->prepare('INSERT INTO tickets
(id, user_init_id,user_to_id,date_create,subj,msg, client_id, unit_id, status, hash_name, prio, last_update) VALUES (:max_id_res_ticket, :user_init_id, :user_to_id, now(),:subj, :msg,:max_id,:unit_id, :status, :hashname, :prio, now())');
$stmt->execute(array(':max_id_res_ticket' => $max_id_res_ticket, ':user_init_id' => $user_init_id, ':user_to_id' => $user_to_id, ':subj' => $subj, ':msg' => $msg, ':max_id' => $client_id_param, ':unit_id' => $unit_id, ':status' => $status, ':hashname' => $hashname, ':prio' => $prio));
$unow = $_SESSION['helpdesk_user_id'];
$stmt = $dbConnection->prepare('INSERT INTO ticket_log (msg, date_op, init_user_id, ticket_id, to_user_id, to_unit_id) values (:create, now(), :unow, :max_id_res_ticket, :user_to_id, :unit_id)');
$stmt->execute(array(':create' => 'create', ':unow' => $unow, ':max_id_res_ticket' => $max_id_res_ticket, ':user_to_id' => $user_to_id, ':unit_id' => $unit_id));
//echo("dd");
if ($CONF_MAIL['active'] == "true") {
if ($user_to_id == "0") {
//echo("dd");
send_mail_to('new_all', $max_id_res_ticket);
} else {
if ($user_to_id != "0") {
//echo("dd");
send_mail_to('new_user', $max_id_res_ticket);
//echo("dd");
send_mail_to('new_coord', $max_id_res_ticket);
}
}
}
echo $hashname;
}
check_unlinked_file();
}
}
}
<?php
$table = 'campaignsN';
$hours = 3;
$recipient = '*****@*****.**';
$qry_em = "select group_concat(campaignID) as campaignd_without_automation from (select campaignId,max(ts) as last_update from campaignsNHistory where campaignId in (select\ncampaignID\nfrom campaignsN\nwhere parentid = 1601983051\nand status = 'active')\ngroup by 1\n) t\nwhere TIMESTAMPDIFF(HOUR,last_update,NOW()) > " . $hours;
$qry_res = mysqli_query($con, $qry_em);
$row = mysqli_fetch_array($qry_res, MYSQLI_ASSOC);
$campaignd_without_automation = $row['campaignd_without_automation'];
echo $campaignd_without_automation;
if (!isset($campaignd_without_automation)) {
// all is good
echo $campaignd_without_automation;
} else {
// We have a problem
$alert = "TURN AUTOMATION ALERT - We have campaigns that have not been updated in the last " . $hours . " hours : " . $campaignd_without_automation;
send_mail_to($recipient, $alert);
}
