File manager - Edit - /home/autoph/public_html/connectv1/app/cron/txt_blast_get_queue.php
Back
<?php include_once("../../cfg/db.php"); include_once("../sms/sms_start.php"); //3042667447062578 if(isset($argv[1])){ parse_str($argv[1], $params); if(isset($params['apiKey']) && $params['apiKey'] === '3042667447062578'){ if($db->select("SELECT COUNT(1) FROM `txtblast_on_going_send` WHERE 1") == 0){ //if table is empty // get 100 records to store in table $get_100 = $db->sql_query("SELECT tbss.cust_id, tbss.request_id, tbss.first_name, tbss.last_name, tbss.suffix, tbss.company_name, tbss.mobile_number, tb.dealer_id AS dealer, tbss.customer_type FROM `txtblast_sms_service_approved` tbss INNER JOIN text_blast tb ON tbss.request_id = tb.id WHERE tbss.status = -1 LIMIT 200"); foreach($get_100 AS $data){ $quer = "INSERT INTO `txtblast_on_going_send` (`cust_id`, `request_id`, `first_name`, `last_name`, `suffix`, `company_name`, `mobile_number`, `dealer_id`, `customer_type`) VALUES ('".$data['cust_id']."', '".$data['request_id']."', '".$data['first_name']."', '".$data['last_name']."', '".$data['suffix']."', '".$data['company_name']."', '".$data['mobile_number']."', '".$data['dealer']."', '".$data['customer_type']."')"; $db->sql_query($quer); } } return; //always execute this } } echo "What are you doing? "; //this will appear if there's an error on param or code ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings