File manager - Edit - /home/autoph/public_html/connectv1/app/cron/txt_blast_send_message.php
Back
<?php include_once("../../cfg/db.php"); include_once("../sms/sms_start.php"); ini_set('max_execution_time', '0'); set_time_limit(0); ini_set('memory_limit','-1'); //7933776506970416 if(isset($argv[1])){ parse_str($argv[1], $params); if(isset($params['apiKey']) && $params['apiKey'] === '7933776506970416'){ $count = $db->select("SELECT COUNT(*) FROM `txtblast_on_going_send` WHERE 1"); if($count > 0){ //if table is not empty $request_id = ""; $cust_id = ""; $mobile_number = ""; while($count > 0){ $rows = $db->sql_query("SELECT togs.cust_id, togs.first_name, togs.last_name, togs.suffix, togs.company_name, togs.request_id, togs.mobile_number, sd.name AS dealer_name, togs.customer_type FROM txtblast_on_going_send togs INNER JOIN source_dealer sd ON togs.dealer_id = sd.id WHERE 1 LIMIT 1"); $first_name = ""; $last_name = ""; $mobile_number = ""; $customer_type = ""; foreach($rows AS $row){ $request_id = $row['request_id']; $cust_id = $row['cust_id']; $first_name = $row['first_name']; $last_name = $row['last_name']; $corp_name = $row['company_name']; $mobile_number = $row['mobile_number']; $dealer_name = $row['dealer_name']; $customer_type = $row['customer_type']; } //get message content $message_content = ""; $messages = $db->sql_query("SELECT message_content FROM text_blast WHERE id = '$request_id'"); foreach($messages AS $message){ $message_content = $message['message_content']; } if($customer_type == 1){ //individual $replace = array( '[firstname]'=>ucwords(strtolower($first_name)), '[lastname]'=>ucwords(strtolower($last_name)), '[dealer]'=>ucwords(strtolower($dealer_name)) ); $message_content = strtr($message_content, $replace); } else { //corporate } $cleaned = str_replace("\r\n", "\n", $message_content); // echo strlen($cleaned); $isValid = substr($mobile_number, 0, 4); if($isValid == "+639" && strlen($mobile_number) == 13){ //valid number $send_sms = new SMS(); //send message $status = $send_sms->sendSMS($mobile_number, $cleaned, $variable); // SEND TEXT ITXTMO // $status = -2; //not activated (test live sent status) // echo $status; //set status $db->sql_query("UPDATE `txtblast_sms_service_approved` SET `status` = '$status' WHERE cust_id = '$cust_id' AND request_id = '$request_id'"); } else { // invalid number $db->sql_query("UPDATE `txtblast_sms_service_approved` SET `status` = 1 WHERE cust_id = '$cust_id' AND request_id = '$request_id'"); } //delete record $deleted = $db->sql_query_num_inserted("DELETE FROM `txtblast_on_going_send` WHERE cust_id = '$cust_id' AND request_id = '$request_id'"); sleep(2); // less count by 1 $count--; } } 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.01 |
proxy
|
phpinfo
|
Settings