}
flush();
}
echo $cnt;
die;
$sql = " SELECT * FROM cs_subscription AS sub LEFT JOIN cs_rebillingdetails AS r ON r.rd_subaccount = sub.ss_rebill_id LEFT JOIN cs_transactiondetails AS t ON sub.ss_transaction_id =\r\nt.transactionid LEFT JOIN cs_companydetails AS cd on cd.userId = ss_user_ID LEFT JOIN etel_dbsmain.cs_company_sites AS cs on cs_ID = ss_site_ID WHERE 1 AND rd_enabled = 'Yes' AND activeuser = '******' AND cs_verified in\r\n('approved','non-compliant') AND sub.ss_user_id IN\r\n(130852,139955,137109,132248,132248,136418,137250,136324,114394,116850,137250,116137,126152,139544,137250,126402,136324,116275,130420,121493,130852,125190,136806,134900,137250,135499,137703,118966,137250,112653,136806,117533,137250,125458,137250,137250,137250,113298,139623,115007,117806,136806,118886,137109,130852,114786,116661,136806,136806,137250,119875,114836,133465,137250,137250,116337,137250,115120,137250,137250,112421,139920,114798,137494,110708,135682,137250,137109,136806,137109,125035,114706,137250,137250,137250,131596,114760,117215,119339,135682,135239,136806,137250,136039,119475,138625,135682,119724,116640,122634,117901,136806,137250,137250,136806,137250,137250,114901,123557,110745,132059,135041,137250,137250,137250,115842,119966,130852,136806,136806,137250,110758,121527,114073,117700,117176,126402,119074,134436,137250,137250,115044,115345,120309,132059,131304,136040,134815,111227,136806,137250,137250,118243,131596,126402,126402,113027,134606,136806,117700,130852,133988,115120,111019,120349,119155,130852,136806,133988,137250,116457,113697,113166,119538,111741,116335,117318,136806,136806,137250,117186,116850,137612,120469,136653,130084,121091,134606,137250,137250,137250,111409,132059,124530) AND\r\nsub.ss_rebill_frozen IN ('nocvv2') limit 30000 ";
$result = sql_query_read($sql) or dieLog(mysql_error());
while ($subInfo = mysql_fetch_assoc($result)) {
$ss_bank_id = 37;
if ($subInfo['ss_billing_type'] == 'MasterCard') {
$ss_bank_id = 38;
}
$add_data = array('billing_descriptor' => 'NovaPay');
$subs = new transaction_class(false);
$subs->pull_subscription($subInfo['ss_ID']);
$subs->send_email('customer_newbank_notification', $add_data);
$sql = "Update cs_subscription set ss_rebill_frozen = 'no', ss_bank_id = '{$ss_bank_id}' where ss_ID = '" . $subInfo['ss_ID'] . "'";
//echo $sql.'<br>';
sql_query_write($sql) or dieLog(mysql_error());
}
die;
$sql = "SELECT CCnumber, bankroutingcode, bankaccountnumber,transactionId\r\nFROM cs_transactiondetails\r\n";
$cnt = 0;
$result = mysql_query($sql) or dieLog(mysql_errno() . ": " . mysql_error() . "<BR>");
$unique = array();
while ($transInfo = mysql_fetch_assoc($result)) {
$key = $transInfo['CCnumber'] . $transInfo['bankroutingcode'] . $transInfo['bankaccountnumber'];
$sql = "Update cs_transactiondetails set td_non_unique='" . $unique[$key] . "' where transactionId = " . $transInfo['transactionId'];
mysql_query($sql) or die(mysql_error());
$cnt += mysql_affected_rows();
if (!isset($unique[$key])) {
