File manager

File manager - Edit - /home/autoph/public_html/connectv1/app/auto_txt_blast/subscription.php

Back
<?php include_once("../../cfg/db.php"); //1364819332540584 $token = $db->escape($_POST['token']); $type = $db->escape($_POST['type']); // 1: bg, 2: insurance, 3: ty message $delivery_type = $db->escape($_POST['delivery_type']); // 2: sms if(isset($_REQUEST['apiKey'])){ if($_REQUEST['apiKey'] === '1364819332540584'){ $query = ""; if($type == 1){ // bg $check_token = $db->select("SELECT COUNT() FROM text_blast_birthday_record WHERE `token` = '$token'"); if($check_token > 0){ $status = $db->escape($_POST['status']); $query = "SELECT tbbr.customer_id, c.first_name, c.last_name, cc.mobile_phone_1, sc.id AS company_id, sd.id AS dealer_id FROM text_blast_birthday_record tbbr INNER JOIN customer c ON c.id = tbbr.customer_id INNER JOIN customer_contact cc ON cc.customer_id = tbbr.customer_id INNER JOIN customer_dms cdms ON cdms.customer_record_id = tbbr.customer_id INNER JOIN source_company_dealer scd ON scd.id = cdms.company_dealer_id INNER JOIN source_company sc ON sc.id = scd.company_id INNER JOIN source_dealer sd ON sd.id = scd.dealer_id WHERE tbbr.`token` = '$token'"; // echo $query; return; $cust_id = ""; $first_name = ""; $last_name = ""; $company_id = ""; $dealer_id = ""; $execute = $db->sql_query($query); foreach($execute AS $row){ $cust_id = $row['customer_id']; $first_name = $row['first_name']; $last_name = $row['last_name']; $company_id = $row['company_id']; $dealer_id = $row['dealer_id']; $mobile_number = $row['mobile_phone_1']; } if($status == "subscribed"){ $insert = $db->sql_query_num_inserted("INSERT INTO `txt_blast_subscription` (`customer_id`, `first_name`, `last_name`, `cited_contact`, `company_id`, `dealer_id`, `type`, `delivery_type`, `reason`) VALUES ('$cust_id', '$first_name', '$last_name', '$mobile_number', '$company_id', '$dealer_id', '$type', '$delivery_type', 2)"); if($insert > 0){ $arr['status'] = 1; //success } else { $arr['status'] = 0; //failed } echo json_encode($arr); } else { $query = "DELETE FROM txt_blast_subscription WHERE `customer_id` = '$cust_id' AND type = 1"; $execute = $db->sql_query_num_inserted($query); if($execute > 0){ $arr['status'] = 1; //success } else { $arr['status'] = 0; //failed } echo json_encode($arr); } } else { $arr['status'] = 0; // failed echo json_encode($arr); } } else if($type == 2){ // insurance } else if($type == 3){ // thank you message $check_token_ty = $db->select("SELECT COUNT() FROM text_blast_new_import_record WHERE `token` = '$token'"); if($check_token_ty > 0){ $status = $db->escape($_POST['status']); $query = "SELECT customer_id, first_name, last_name, mobile_number, company_id, dealer_id, token FROM text_blast_new_import_record WHERE `token` = '$token'"; // echo $query; exit; $cust_id = ""; $first_name = ""; $last_name = ""; $mobile_number = ""; $company_id = ""; $dealer_id = ""; $execute = $db->sql_query($query); foreach($execute AS $row){ $cust_id = $row['customer_id']; $first_name = $row['first_name']; $last_name = $row['last_name']; $mobile_number = $row['mobile_number']; $company_id = $row['company_id']; $dealer_id = $row['dealer_id']; } if($status == "subscribed"){ $reason_type = $db->escape($_POST['reason_type']); // echo "INSERT INTO `txt_blast_subscription` (`customer_id`, `first_name`, `last_name`, `company_id`, `dealer_id`, `cited_contact`, `type`, `delivery_type`, `reason`) // VALUES ('$cust_id', '$first_name', '$last_name', '$company_id', '$dealer_id', '$mobile_number', '$type', '$delivery_type', '$reason_type')"; exit; $insert = $db->sql_query_num_inserted("INSERT INTO `txt_blast_subscription` (`customer_id`, `first_name`, `last_name`, `company_id`, `dealer_id`, `cited_contact`, `type`, `delivery_type`, `reason`) VALUES ('$cust_id', '$first_name', '$last_name', '$company_id', '$dealer_id', '$mobile_number', '$type', '$delivery_type', '$reason_type')"); if($insert > 0){ $arr['status'] = 1; //success } else { $arr['status'] = 0; //failed } echo json_encode($arr); } else { $query = "DELETE FROM txt_blast_subscription WHERE `customer_id` = '$cust_id' AND type = 3"; $execute = $db->sql_query_num_inserted($query); if($execute > 0){ $arr['status'] = 1; //success } else { $arr['status'] = 0; //failed } echo json_encode($arr); } } else { $arr['status'] = 0; // failed echo json_encode($arr); } } } // else if($_REQUEST['apiKey'] === '6819364887295039'){ // } } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings