File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/cron/txt_blast_request_status.php
Back
<?php include_once("../../cfg/db.php"); //execute per hour // 1224485629880750 // SECURITY if(isset($argv[1])){ parse_str($argv[1], $params); if(isset($params['apiKey']) && $params['apiKey'] === '1224485629880750'){ $get_request_id = $db->sql_query("SELECT request_id FROM request_status"); foreach($get_request_id AS $data){ $request_id = $data['request_id']; $count_first = $db->select("SELECT COUNT(*) FROM `txtblast_sms_service_approved` WHERE `request_id` = $request_id"); //check if request is existing //echo $count; exit; if($count_first > 0){ $count = $db->select("SELECT COUNT(*) FROM `txtblast_sms_service_approved` WHERE `request_id` = $request_id AND `status` = -1"); //check if there is still pending if($count == 0){ $checks = $db->sql_query("SELECT status FROM request_status WHERE `request_id` = $request_id"); $status = ""; foreach($checks AS $check){ $status = $check['status']; } if($status != 2){ // 2 is denied, cannot be considered $db->sql_query("UPDATE request_status SET `status` = 3 WHERE `request_id` = '$request_id'"); //closed $db->sql_query("UPDATE request_status_summary SET status = 3 WHERE `request_id` = '$request_id'"); //closed } } } } return; //always execute this } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings