File manager - Edit - /home/autoph/public_html/connectv1/fix.php
Back
<?php //php 7.2.24 include('cfg/db.php'); ini_set('max_execution_time', '0'); set_time_limit(0); //same code above ini_set('memory_limit','-1'); $sql = "SELECT `customer_id` FROM `text_blast_birthday_record`"; $tbbr_list = $db->sql_query($sql); foreach($tbbr_list AS $row){ $customer_id = $row['customer_id']; $comp_deal_id = $db->select("SELECT `company_dealer_id` FROM `customer_dms` WHERE `customer_record_id` = '$customer_id' GROUP BY `customer_record_id`"); $query = "SELECT `company_id`, `dealer_id` FROM `source_company_dealer` WHERE `id` = '$comp_deal_id'"; $compdeal_query = $db->sql_query($query); foreach($compdeal_query AS $data){ $update = "UPDATE `text_blast_birthday_record` SET `company_id` = '" . $data['company_id'] . "', `dealer_id` = '" . $data['dealer_id'] . "' WHERE `customer_id` = '$customer_id'"; $db->sql_query($update); } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings