$ss_account_status = 'inactive';
$ss_rebill_status = 'inactive';
$ss_rebill_status_text = 'Rebill Subscription Canceled/Inactive';
if ($transInfo['td_enable_rebill']) {
$ss_rebill_status = 'active';
}
if ($transInfo['td_enable_rebill']) {
$ss_rebill_status_text = '';
}
if (!$transInfo['td_subscription_id']) {
$transInfo['td_subscription_id'] = genRefId("subscription", "S");
}
$expDate = explode("/", $transInfo['validupto']);
$expYear = substr($expDate[0], -2, 2);
$expMonth = $expDate[1];
$sql = "\r\n\tinsert into `cs_subscription` set \r\n\t `ss_subscription_ID`='" . $transInfo['td_subscription_id'] . "',\r\n\t `ss_billing_firstname`='" . $transInfo['name'] . "',\r\n\t `ss_billing_mi`='" . $transInfo[''] . "',\r\n\t `ss_billing_lastname`='" . $transInfo['surname'] . "',\r\n\t `ss_billing_address`='" . $transInfo['address'] . "',\r\n\t `ss_billing_address2`='" . $transInfo[''] . "',\r\n\t `ss_billing_city`='" . $transInfo['city'] . "',\r\n\t `ss_billing_state`='" . $transInfo['state'] . "',\r\n\t `ss_billing_country`='" . $transInfo['country'] . "',\r\n\t `ss_billing_zipcode`='" . $transInfo['zipcode'] . "',\r\n\t `ss_billing_last_ip`='" . $transInfo['ipaddress'] . "',\r\n\t `ss_billing_card`='" . transaction::etelEncSalted($transInfo['CCnumber'], $salt) . "',\r\n\t `ss_billing_card_type`='" . $ss_billing_card_type . "',\r\n\t `ss_billing_gkard`='" . transaction::etelEncSalted($transInfo['td_gcard'], $salt) . "',\r\n\t `ss_billing_type`='" . $ss_billing_type . "',\r\n\t `ss_billing_exp`='" . date("Y-m-d", mktime(0, 0, 0, $expMonth, 1, $expYear)) . "',\r\n\t `ss_billing_cvv2`='" . transaction::etelEncSalted($transInfo['cvv'], $salt) . "',\r\n\t `ss_billing_check_account`='" . transaction::etelEncSalted($transInfo['bankaccountnumber'], $salt) . "',\r\n\t `ss_billing_check_routing`='" . transaction::etelEncSalted($transInfo['bankroutingcode'], $salt) . "',\r\n\t `ss_salt`='" . $salt . "',\r\n\t `ss_cust_email`='" . $transInfo['email'] . "',\r\n\t `ss_cust_phone`='" . $transInfo['phonenumber'] . "',\r\n\t `ss_cust_username`='" . $transInfo['td_username'] . "',\r\n\t `ss_cust_password`='" . $transInfo['td_password'] . "',\r\n\t `ss_rebill_ID`='" . $transInfo['td_rebillingID'] . "',\r\n\t `ss_rebill_next_date`='" . $transInfo['td_recur_next_date'] . "',\r\n\t `ss_rebill_amount`='" . $transInfo['chargeAmount'] . "',\r\n\t `ss_rebill_status`='" . $ss_rebill_status . "',\r\n\t `ss_rebill_status_text`='" . $ss_rebill_status_text . "',\r\n\t `ss_rebill_attempts`='" . $transInfo['td_recur_attempts'] . "',\r\n\t `ss_rebill_count`='" . $transInfo['td_recur_num'] . "',\r\n\t `ss_account_status`='" . $ss_account_status . "',\r\n\t `ss_account_start_date`='" . $transInfo['transactionDate'] . "',\r\n\t `ss_account_expire_date`='" . $transInfo['td_recur_next_date'] . "',\r\n\t `ss_transaction_id`='" . $transInfo['transactionId'] . "',\r\n\t `ss_last_rebill`='" . $transInfo['transactionDate'] . "',\r\n\t `ss_productdescription`='" . $transInfo['productdescription'] . "',\r\n\t `ss_site_ID` ='" . $transInfo['td_site_ID'] . "',\r\n\t `ss_user_ID` ='" . $transInfo['userId'] . "'\r\n\t\r\n\t";
die($sql);
}
/*
set_time_limit(0);
$sql="SELECT CCnumber,transactionId
FROM cs_transactiondetails
";
$result = mysql_query($sql) or dieLog(mysql_errno().": ".mysql_error()."<BR>");
while($transInfo = mysql_fetch_assoc($result))
{
if( isset($unique[$transInfo['CCnumber']])) $unique[$transInfo['CCnumber']]++;
else $unique[$transInfo['CCnumber']]=0;
$sql = "Update cs_transactiondetails set td_non_unique='".$unique[$transInfo['CCnumber']]."' where transactionId = ".$transInfo['transactionId'];
//die($sql);
mysql_query($sql) or die(mysql_error());
