function smart_updateMarkup($values, $action) { global $companyInfo; $userid = $values['append']; $res_disc = $_POST['res_disc_' . $userid]; $res_trans = $_POST['res_trans_' . $userid]; $sql = "select merchant_contract_agree,cb_ID\n\t\t\tFROM \n\t\t\t\tcs_companydetails as cd\n\t\t\tLEFT JOIN \n\t\t\t\tcs_entities as ce ON (cd.userId = ce.en_type_ID AND ce.en_type = 'merchant')\n\t\t\tLEFT JOIN \n\t\t\t\tcs_entities_affiliates as ea ON (ea.ea_en_ID = ce.en_ID)\n\t\t\tLEFT JOIN \n\t\t\t\tcs_company_banks as cb ON (cb.userId = cd.userId AND cb.bank_id = 0)\n\t\t\tWHERE\n\t\t\t\tea.ea_affiliate_ID = '" . $companyInfo['en_ID'] . "' and cd.userId = '{$userid}'"; $result = sql_query_read($sql) or dieLog(mysql_error() . " ~ {$sql}"); if (!mysql_num_rows($result)) { return array("action" => "Merchant Not Found.", "status" => "fail"); } $markupInfo = mysql_fetch_assoc($result); if ($markupInfo['merchant_contract_agree']) { return array("action" => "Merchant Already Signed Contract. If you would like more information, please contact the Sales Department.", "status" => "fail"); } if (!$markupInfo['cb_ID']) { $sql = "insert into cs_company_banks set userId = '" . intval($userid) . "',bank_id=0;"; $result = sql_query_write($sql) or dieLog(mysql_error() . " ~ {$sql}"); $cb_ID = mysql_insert_id(); } else { $cb_ID = $markupInfo['cb_ID']; } $update = array('default' => array('Processor' => array('disct' => $res_disc, 'trans' => $res_trans))); if (etel_update_serialized_field('cs_company_banks', 'cb_config', " cb_ID = '{$cb_ID}'", $update)) { return array("action" => "Merchant Rates Updated Successfully.", "status" => "success"); } return array("action" => "Error, Please contact support.", "status" => "fail"); }
function add_entity($type, $user, $pass, $table_id) { $type = quote_smart($type); $user = quote_smart($user); $pass = quote_smart($pass); $table_id = quote_smart($table_id); if (!isset($this->entities[$type])) { return -1; } $sql = "\n\t\t\tINSERT INTO\n\t\t\t\tcs_entities\n\t\t\tSET\n\t\t\t\tet_type = '{$type}',\n\t\t\t\tet_username = '******',\n\t\t\t\tet_password = '******',\n\t\t\t\tet_table_ID = '{$table_id}'\n\t\t\t"; sql_query_write($sql); }
function smart_deleteRefund($values, $action) { global $adminInfo; $sql = "Select * FROM `cs_callnotes` WHERE note_id = '" . $values['append'] . "'"; $result = sql_query_read($sql) or dieLog(mysql_error() . " ~ {$sql}"); $callNoteInfo = mysql_fetch_assoc($result); if ($adminInfo['li_level'] == 'full') { $sql = "DELETE FROM `cs_callnotes` WHERE note_id = '" . $values['append'] . "'"; $result = sql_query_write($sql, $cnn_cs) or dieLog(mysql_errno() . ": " . mysql_error() . "<BR>Cannot execute query"); return array("action" => "Transaction ID " . $callNoteInfo['transaction_id'] . " no longer being refunded.", "status" => "success"); } return array("action" => "Transaction ID " . $callNoteInfo['transaction_id'] . " no longer being refunded.", "status" => "failed. insufficient privilages."); }
function smart_updateMarkup($values, $action, $updateall = false) { global $curUserInfo; $en_ID = $values['append']; if ($updateall) { $res_disc = $_POST['default_disc']; $res_trans = $_POST['default_trans']; } else { $res_disc = $_POST['res_disc_' . $userid]; $res_trans = $_POST['res_trans_' . $userid]; } $sql = "select cb_ID,cb_config\n\t\t\tFROM \n\t\t\t\tcs_entities as ce\n\t\t\tLEFT JOIN \n\t\t\t\tcs_entities_affiliates as ea ON (ea.ea_en_ID = ce.en_ID)\n\t\t\tLEFT JOIN \n\t\t\t\tcs_company_banks as cb ON (ce.en_ID = cb.cb_en_ID AND cb.bank_id = 0)\n\t\t\tWHERE\n\t\t\t\tea.ea_affiliate_ID = '" . $curUserInfo['en_ID'] . "'"; if ($en_ID || !$updateall) { $sql .= " and ce.en_ID = '{$en_ID}'"; } $markupResult = sql_query_read($sql) or dieLog(mysql_error() . " ~ {$sql}"); if (!mysql_num_rows($markupResult)) { return array("action" => "Affiliate(s) Not Found.", "status" => "fail"); } while ($markupInfo = mysql_fetch_assoc($markupResult)) { if (!$markupInfo['cb_ID']) { $sql = "insert into cs_company_banks set cb_en_ID = '" . intval($markupInfo['merchant_en_ID']) . "',bank_id=0;"; $result = sql_query_write($sql) or dieLog(mysql_error() . " ~ {$sql}"); $cb_ID = mysql_insert_id(); } else { $cb_ID = $markupInfo['cb_ID']; $markupInfo['cb_config'] = etel_unserialize($markupInfo['cb_config']); } $update = array('default' => array('Reseller' => array('disct' => $res_disc, 'trans' => $res_trans, 'en_ID' => $curUserInfo['en_ID']))); if ($updateall && $markupInfo['cb_config']['default']['Reseller']) { $update = NULL; } if ($update) { $updated = etel_update_serialized_field('cs_company_banks', 'cb_config', " cb_ID = '{$cb_ID}'", $update); if (!$updateall) { if ($updated) { return array("action" => "Merchant Rates Updated Successfully.", "status" => "success"); } return array("action" => "Error, Please contact support.", "status" => "fail"); } } } return array("action" => "Merchant(s) Rates Updated Successfully.", "status" => "success"); }
function transaction_update_user_pass($trans_id, $user, $pass) { $query = "\t\n\t\tUPDATE \n\t\t\t`cs_transactiondetails`\n\t\tSET \n\t\t\ttd_username = '******',\n\t\t\ttd_password = '******'\n\t\tWHERE \n\t\t\t`transactionId` = '{$trans_id}'\n\t"; sql_query_write($query) or dieLog(mysql_error() . "<pre>{$query}</pre>"); }
$contactmethod = quote_smart($_REQUEST['contactmethod']); if ($_SESSION['no_more_where'] != "true") { $where = $_SESSION['where'] . " AND sub.`ss_subscription_ID` = '{$ss_subscription_ID}'"; } else { $where = $_SESSION['where']; } ///////////////////////////////////bad // $results = $lookup->find_transaction_query($where); // $row=mysql_fetch_array($results); ///////////////////////////////////bad $results = $lookup->find_transaction_query($where); foreach ($results as $outer_key => $row) { $_SESSION['no_more_where'] = "true"; $transactionId = $row['transactionId']; $sql = "INSERT INTO `cs_callnotes` (`transaction_id` , `call_date_time` , `service_notes` , `cancel_status` , `customer_notes` , `solved` , `is_bill_date_changed` , `call_duration` , `customer_service_id` , `prev_bill_date` , `dnc`, `cn_type`, `cn_contactmethod` )\n\t\t\t\tVALUES ('{$transactionId}', NOW() , 'User Requests Refund', '', '{$customer_notes}', '' , '', '', '', '', '', 'refundrequest', '{$contactmethod}');"; sql_query_write("{$sql}"); $ss_subscription_ID = $row['ss_subscription_ID']; if ($row[ss_rebill_status] == "active") { subscription_cancel($ss_subscription_ID, NULL, $ss_account_notes, $ss_rebill_status_text); } echo "<big><big><big><center>Processing...</big></big></big></center>"; } } elseif ($_REQUEST[action] == "cancel") { $reference_number = quote_smart($_REQUEST['reference_number']); $ss_account_notes = quote_smart(trim($_REQUEST['ss_account_notes'])); $ss_rebill_status_text = quote_smart($_REQUEST['ss_rebill_status_text']); if ($_SESSION['no_more_where'] != "true") { $where = $_SESSION['where'] . " AND td.`reference_number` = '{$reference_number}'"; } else { $where = $_SESSION['where']; }
if ($_POST['Email_Contract_Notification'] && $access['Data']['send_mail']['Value'] == 1) { send_email_template('contract_notification_email', $data); } if ($_POST['Email_Active_Notification'] && $access['Data']['send_mail']['Value'] == 1) { send_email_template('active_notification_email', $data); } if ($_POST['cd_custom_contract'] && !$access['Data']['cd_custom_contract']['Value']) { $Rates = new rates_fees(); $contract = $Rates->get_Merchant_Contract($en_ID); $sql = "insert into cs_email_templates \n\t\t\tset et_name='merchant_contract', \n\t\t\tet_custom_id='" . $company_id . "', \n\t\t\tet_title='" . quote_smart($access['Data']['en_company']['Value']) . " Contract', \n\t\t\tet_access='admin', \n\t\t\tet_to_title='" . quote_smart($access['Data']['en_company']['Value']) . "', \n\t\t\tet_subject='Custom Merchant Contract for " . quote_smart($access['Data']['en_company']['Value']) . "', \n\t\t\tet_htmlformat='" . quote_smart($contract['et_htmlformat']) . "', \n\t\t\tet_catagory='Merchant'"; $result = sql_query_write($sql) or dieLog(mysql_error() . " ~ sql"); $_POST['cd_custom_contract'] = mysql_insert_id(); } else { if (!$_POST['cd_custom_contract'] && $access['Data']['cd_custom_contract']['Value']) { $sql = "delete from cs_email_templates where et_name='merchant_contract' and et_custom_id='" . $company_id . "'"; $result = sql_query_write($sql) or dieLog(mysql_error() . " ~ sql"); $access['Data']['cd_custom_contract']['AddHtml'] = NULL; } } } $res = check_merchant_conflict($_POST, $en_ID); if (!$res['status']) { $access['HeaderMessage'] .= nl2br($res['msg']); foreach ($res['res'] as $key => $val) { if ($val) { $_POST[$key] = $access['Data'][$key]['Value']; $access['Data'][$key]['Highlight'] = true; } } } // Submit
exit; } else { $qry_insert_user = "******"; $qry_insert_user .= " values('{$username}','{$password}','{$companyname}','{$email}','{$volumeNumber}',0,'{$transaction_type}','rsel','{$resellerName}',{$resellerLogin},'{$current_date_time}',{$send_ecommercemail},'{$url}','{$gateway_id}',{$block_virtual_terminal})"; // print $qry_insert_user; if (!($show_sql = mysql_query($qry_insert_user))) { print mysql_errno() . ": " . mysql_error() . "<BR>"; print "Cannot execute query <br>"; exit; } else { $is_success = 0; $user_id = mysql_insert_id(); $user_reference_num = func_User_Ref_No($user_id); $is_success = func_update_single_field('cs_companydetails', 'ReferenceNumber', $user_reference_num, NULL, 'userId', $user_id, $cnn_cs); $sql = "Insert into cs_entities\n\t\t\t\tset \n\t\t\t\t\ten_username = '******',\n\t\t\t\t\ten_password = MD5('" . ($username . $password) . "'),\n\t\t\t\t\ten_email = '" . quote_smart($email) . "',\n\t\t\t\t\ten_gateway_ID = '" . quote_smart($gateway_id) . "',\n\t\t\t\t\ten_type = 'merchant',\n\t\t\t\t\ten_signup = NOW(),\n\t\t\t\t\ten_type_id = '" . quote_smart($user_id) . "'\n\t\t\t\t"; sql_query_write($sql) or dieLog(mysql_error() . " ~ {$str_qry}"); $letterTempate = 'merchant_referral_letter'; $emailData["email"] = $email_to; $emailData["reselleremail"] = $resellerInfo['reseller_email']; $emailData["full_name"] = "Merchant"; $emailData["companyname"] = $companyname; $emailData["resellername"] = $resellerInfo['reseller_companyname']; $emailData["username"] = $username; $emailData["password"] = $password; $emailData["Reference_ID"] = $user_reference_num; send_email_template($letterTempate, $emailData); $emailInfo = get_email_template($letterTempate, $emailData); /*************************************************************************/ $msgtodisplay = "New merchant registered successfully. Confirmation Email sent to '" . $email . "'"; $outhtml = "Y"; message($msgtodisplay, $outhtml, $headerInclude);
} $update = "registered "; if (!$rd_recur_enabled) { $i_recur_day = 0; } if ($i_recur_day > 0 && $i_trial_days == 0) { $i_trial_days = 3; } if ($rd_ibill_landing_html && $chk_enable_landing) { $rd_ibill_landing_html = "'" . $rd_ibill_landing_html . "'"; } else { $rd_ibill_landing_html = 'NULL'; } $sql_fields = "\n\t\t\t`recur_day` = '{$i_recur_day}', \n\t\t\t`recur_charge` = '{$i_recur_charge}', \n\t\t\t`company_user_id` = '{$company_user_id}', \n\t\t\t`rd_en_ID` = '" . $companyInfo['en_ID'] . "', \n\t\t\t`rd_initial_amount` = '{$i_trial_amount}', \n\t\t\t`rd_trial_days` = '{$i_trial_days}', \n\t\t\t`rd_description` = '{$i_txt_description}',\n\t\t\t`rd_hide` = 0,\n\t\t\t`rd_recur_enabled` = '{$rd_recur_enabled}',\n\t\t\t`rd_ibill_landing_html` = {$rd_ibill_landing_html},\n\t\t\t`rd_subName` = '{$rd_subName}'"; $qry_insert_details = "\n\t\tINSERT INTO `cs_rebillingdetails` \n\t\tset {$sql_fields} on duplicate key update {$sql_fields}\n\t\t"; $rst_insert = sql_query_write($qry_insert_details, $cnn_cs) or die(mysql_error()); $subAccount = mysql_insert_id($cnn_cs); if ($rd_subaccount) { $subAccount = $rd_subaccount; } $subAccountName = $subAcc['rd_subName']; $msgtodisplay = "<br>Sub Account '{$rd_subName}' Updated successfully.<br>To use this subaccount, make sure to include the entire subaccount name '{$rd_subName}' in your integration form.<br> "; print "<table align='center' width='100%'><tr height='20'><td align='center'><font face='verdana' size='1'> {$msgtodisplay}</td></tr><tr>\n\t</tr></table>"; } endTable('Recurring Transaction', NULL, true, true); die; } $sql = "SELECT * FROM `cs_rebillingdetails` WHERE `rd_hide` = 0 AND `rd_en_ID` = '{$en_ID}' ORDER BY `rd_subaccount` DESC "; if (!($result = sql_query_read($sql, $cnn_cs))) { print mysql_errno() . ": " . mysql_error() . "<BR>"; print $qry_update . "<br>";
function createNewTicket($emailInfo, $tickets_users_username, $tickets_thread, $tickets_category = 1) { $ticket = array(); $ticket['tickets_reference'] = 'NULL'; if (!$tickets_thread['tickets_id']) { $ticket['tickets_reference'] = "'" . strtoupper(substr(md5(time() . rand(0, 10000000)), 0, 16)) . "'"; } $tickets_subject = str_replace("Re: ", "", $emailInfo['Subject']); $sql = "\r\n\t\tInsert ignore Into `tickets_tickets`\r\n\t\tset tickets_username = '******',\r\n\t\ttickets_child = '" . $tickets_thread['tickets_id'] . "',\r\n\t\ttickets_subject = '{$tickets_subject}',\r\n\t\ttickets_reference = " . $ticket['tickets_reference'] . ",\r\n\t\ttickets_name = '" . quote_smart($emailInfo['FromEmail']) . "',\r\n\t\ttickets_email = '" . quote_smart($emailInfo['FromEmail']) . "',\r\n\t\ttickets_question = '" . quote_smart($emailInfo['body']) . "',\r\n\t\ttickets_category = '" . quote_smart($tickets_category) . "',\r\n\t\ttickets_timestamp = '" . time() . "'"; $result = sql_query_write($sql) or dieLog(mysql_error()); $ticket['id'] = mysql_insert_id(); if ($tickets_thread['tickets_id'] > 0) { sql_query_write("update `tickets_tickets` set tickets_status='Open' where tickets_id = '" . $tickets_thread['tickets_id'] . "'") or dieLog(mysql_error()); } if ($tickets_thread['tickets_id']) { $ticket['tickets_reference'] = $tickets_thread['tickets_reference']; } return $ticket; }
function func_update_single_field($tablename, $fieldname, $fieldvalue, $cnn, $comparefield, $comparefieldvalue, $cnn_cs = false) { $sql = "update {$tablename} set {$fieldname}='{$fieldvalue}' where {$comparefield}={$comparefieldvalue}"; if (!sql_query_write($sql, 1)) { //echo $qryUpdate; dieLog(mysql_error() . " {$sql}"); } }
function update_account_status() { $ss_account_status = 'active'; if (strtotime($this->row['subscriptionTable']['ss_account_expire_date']) < time()) { $ss_account_status = 'inactive'; } $ss_account_notes = "\n\n" . date('Y-m-d G:i:s') . ": Account " . ucfirst($ss_account_status); $upd = "UPDATE\n\t\t\t\t\tcs_subscription\n\t\t\t\t\tSET\n\t\t\t\t\tss_account_status = '{$ss_account_status}',\n\t\t\t\t\tss_account_notes = CONCAT(`ss_account_notes`, '{$ss_account_notes}' )\n\t\t\t\t\tWHERE\n\t\t\t\t\tss_ID = {$this->row['subscriptionTable']['ss_ID']}"; sql_query_write($upd) or dieLog(mysql_error() . "<pre>{$upd}</pre>"); $this->row['subscriptionTable']['ss_account_status'] = $ss_account_status; $this->row['subscriptionTable']['ss_account_notes'] .= $ss_account_notes; if ($ss_account_status == 'inactive') { return Process_Transaction($this->row['subscriptionTable']['ss_transaction_id'], "expiration", $this->test, "transactionId"); } return Process_Transaction($this->row['subscriptionTable']['ss_transaction_id'], "approve", $this->test, "transactionId"); }
function process_transactions($params) { set_time_limit(0); if (!$params['Format']) { $params['Format'] = "TXT"; } if (!$params['Incremental']) { $params['Incremental'] = "True"; } $RF = new rates_fees(); $trans = $this->Status_Download($params); $return_affected_rows = 0; $approve_affected_rows = 0; $log = ""; foreach ($trans as $tran) { $update = false; $chargeback = false; $refund = false; $status = ""; switch (strtolower($tran['ResponseType'])) { case "processed": $update = false; break; case "b": $update = false; break; case "f": $update = true; $status = 'A'; break; case "r": $update = true; $status = 'D'; break; case "nsf": $update = true; $status = 'D'; break; case "chargeback": $update = true; $status = 'D'; $chargeback = true; break; case "invalid": $update = true; $status = 'D'; break; case "declined": $update = true; $status = 'D'; break; case "refund": $update = true; $status = 'D'; $refund = true; break; case "credit": $update = true; $status = 'D'; $refund = true; break; case "incomplete": $update = true; $status = 'D'; break; case "cancelled": $update = true; $status = 'D'; break; case "bo exception": $update = true; $status = 'D'; break; case "downloaded": $update = false; break; case "credit originated": $update = false; break; case "credit downloaded": $update = false; break; case "credit return": $update = true; $status = 'D'; $chargeback = true; break; case "credit funded": $update = true; $status = 'A'; break; } $refid = substr($tran['ExternalClientID'], 0, 50); if (!$refid) { continue; } $sql = "\n\t\t\t\tselect * from \n\t\t\t\t\tcs_transactiondetails left join \n\t\t\t\t\tcs_subscription on \n\t\t\t\t\ttd_ss_ID = ss_ID\n\t\t\t\tWHERE\n\t\t\t\t\treference_number = '{$refid}'\n\t\t\t\t\tAND checkorcard='C'\t\t\n\t\t\t\tLIMIT 1\n\t\t\t"; $tranResult = mysql_query($sql) or dieLog(mysql_error() . " ~ {$sql}"); $transInfo = mysql_fetch_assoc($tranResult); $transId = $transInfo['transactionId']; if ($transInfo['status'] != 'P' && $update == true) { $update = false; } if (!$transId) { $log .= " Transaction ID Not Found!! " . print_r($tran, true); toLog('erroralert', 'misc', "Transaction ID Not Found!! {$transId} {$sql}"); $update = false; } if ($update) { $log .= " Found Response Type (" . $tran['ResponseType'] . ") For ({$refid}):\n"; $notify = 'decline'; $bank_transid = $tran['TransID']; if ($tran['ResponseDate']) { $billingDate = date('Y-m-d', strtotime($tran['ResponseDate'])); } else { $billingDate = ""; } if ($chargeback) { //is_chargeback $sql = "\n\t\t\t\t\t\tUPDATE\n\t\t\t\t\t\t\tcs_transactiondetails left join \n\t\t\t\t\t\t\tcs_subscription on \n\t\t\t\t\t\t\ttd_ss_ID = ss_ID\n\t\t\t\t\t\tSET\n\t\t\t\t\t\t\tstatus='A',\n\t\t\t\t\t\t\ttd_is_chargeback = 1,\n\t\t\t\t\t\t\ttd_bank_transaction_id = '{$bank_transid}',\n\t\t\t\t\t\t\tbillingDate = '{$billingDate}',\n\t\t\t\t\t\t\ttd_merchant_deducted=0,\n\t\t\t\t\t\t\tss_rebill_status = 'inactive',\n\t\t\t\t\t\t\tss_rebill_status_text = 'Subscription Inactive due to Chargeback'\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\ttransactionId = '{$transId}'\n\t\t\t\t\t\t\tAND checkorcard='C'\t\t\n\t\t\t\t\t"; $log .= " This transaction is a chargeback.\n"; $notify = 'chargeback'; $r = $RF->update_transaction_profit($transId); } else { if ($refund) { // cancel_status = y, cancel subscription $sql = "\n\t\t\t\t\t\tUPDATE\n\t\t\t\t\t\t\tcs_transactiondetails left join \n\t\t\t\t\t\t\tcs_subscription on \n\t\t\t\t\t\t\ttd_ss_ID = ss_ID\n\t\t\t\t\t\tSET\n\t\t\t\t\t\t\tstatus='A',\n\t\t\t\t\t\t\tcancelstatus = 'Y',\n\t\t\t\t\t\t\ttd_bank_transaction_id = '{$bank_transid}',\n\t\t\t\t\t\t\tbillingDate = '{$billingDate}',\n\t\t\t\t\t\t\ttd_merchant_deducted=0,\n\t\t\t\t\t\t\tss_rebill_status = 'inactive',\n\t\t\t\t\t\t\tss_rebill_status_text = 'Subscription Inactive due to Refund'\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\ttransactionId = '{$transId}'\n\t\t\t\t\t\t\tAND checkorcard='C'\t\t\t\n\t\t\t\t\t"; $log .= " This transaction is a refund.\n"; $notify = 'refund'; $r = $RF->update_transaction_profit($transId); } else { $ss_rebill_status_sql = $status == 'D' ? "ss_rebill_status = 'inactive', " : ''; $ss_rebill_status_text = $status == 'D' ? 'Subscription Inactive due to decline (' . $this->ach_status[$tran['ResponseType']] . ')' : 'Subscription Active'; $sql = "\n\t\t\t\t\t\tUPDATE\n\t\t\t\t\t\t\tcs_transactiondetails left join \n\t\t\t\t\t\t\tcs_subscription on \n\t\t\t\t\t\t\ttd_ss_ID = ss_ID\n\t\t\t\t\t\tSET\n\t\t\t\t\t\t\ttd_bank_transaction_id = '{$bank_transid}',\n\t\t\t\t\t\t\tstatus = '{$status}',\n\t\t\t\t\t\t\tbillingDate = '{$billingDate}',\n\t\t\t\t\t\t\ttd_merchant_deducted=0,\n\t\t\t\t\t\t\ttd_merchant_paid=0,\n\t\t\t\t\t\t\t{$ss_rebill_status_sql}\n\t\t\t\t\t\t\tss_rebill_status_text = '{$ss_rebill_status_text}'\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\ttransactionId = '{$transId}'\n\t\t\t\t\t\t\tAND checkorcard='C'\tAND status='P'\t\n\t\t\t\t\t"; $log .= " This transaction's status is (" . $this->ach_status[$tran['ResponseType']] . ").\n"; $r = $RF->update_transaction_profit($transId); } } sql_query_write($sql) or dieLog(mysql_error() . "<pre>{$sql}</pre>"); $affected = mysql_affected_rows(); if ($status != 'A') { $return_affected_rows += $affected; } else { $approve_affected_rows += $affected; } if ($status == 'A') { if ($transInfo['td_is_a_rebill']) { $notify = 'rebill'; } else { $notify = 'approve'; } } if ($affected) { Process_Transaction($transId, $notify, 0, 'transactionId'); } } else { $log .= " Ignoring Transaction.\n"; } } $log .= "CheckGateway Result: ({$return_affected_rows}) Returns, ({$approve_affected_rows}) Approves.\n"; return $log; }
if (!$index) { $index = $config_default_index; } session_destroy(); header("location:" . $index . "?login_redir=" . base64_encode($_SERVER['REQUEST_URI'])); exit; } if ($companyInfo['en_gateway_ID'] && $companyInfo['en_gateway_ID'] != $_SESSION["gw_id"]) { $_SESSION["gw_switch"] = $companyInfo['en_gateway_ID']; } if (!$_SESSION["gw_switch"]) { $_SESSION["gw_switch"] = $gateway_db_select; } if ($_SESSION["gw_user_en_debug"] && !isset($etel_debug_mode)) { if (ip2long($etel_current_ip) != $gwInfo['gw_debug_ip']) { sql_query_write("update etel_dbsmain.etel_gateways set gw_debug_ip = '" . ip2long($etel_current_ip) . "' where gw_id = '" . $gwInfo['gw_id'] . "'"); } $etel_debug_mode = 1; } if (ip2long($etel_current_ip) == $gwInfo['gw_debug_ip'] && $_COOKIE['etel_debug_enable'] == 2 && !isset($etel_debug_mode)) { $etel_debug_mode = 1; } // Debug Mode if ($etel_debug_mode == 1 && !$printable_version) { error_reporting(E_ALL ^ E_NOTICE); print "<span style='font-size: 10px;'>"; print_r($_REQUEST); print "<br>"; print_r($_SESSION); print "</span>"; } else {
//$etel_debug_mode = 1; $etel_disable_https = 1; include "includes/dbconnection.php"; $timelimit = 60; $time = time(); for ($i = 0; $i <= 20; $i++) { $found = 0; $sleep = 10; $result = sql_query_read('SHOW PROCESSLIST '); while ($list = mysql_fetch_assoc($result)) { preg_match('/\\/\\* TIMEOUT=([0-9]*) \\*\\//', $list['Info'], $matches); $limit = intval($matches[1]); if ($limit >= 5 || intval($list['Time']) >= 300 && strpos(strtolower($list['Info']), 'select') !== false) { if (intval($list['Time']) >= $limit) { $sql = "KILL " . $list['Id'] . "\n"; sql_query_write($sql); echo $sql; $found = 1; } $sleep = 1; } } if (!$found) { echo date('G:i:s') . ": No Processes to Kill<br>"; } flush(); if ($time + $timelimit < time()) { die; } sleep($sleep); }
function smart_removeRefund($values, $action) { global $curUserInfo; if (!$curUserInfo['en_access'][ACCESS_AUTH_TRANS_MOD]) { return array("action" => "Invalid Access.", "status" => "Fail"); } $transID = $values['append']; $qry_details = "UPDATE cs_transactiondetails SET `cancelstatus` = 'N',`td_bank_deducted`=1,`td_merchant_deducted`=1,`td_reseller_deducted`=1 WHERE `transactionId` = '{$transID}'"; $rst_details = sql_query_write($qry_details) or dieLog(mysql_errno() . ": " . mysql_error() . "<BR>Cannot execute query"); $qry_details = "DELETE FROM cs_callnotes WHERE `cn_type` = 'refundrequest' AND `transaction_id` = '{$transID}'"; $rst_details = sql_query_write($qry_details) or dieLog(mysql_errno() . ": " . mysql_error() . "<BR>Cannot execute query"); $RF = new rates_fees(); $r = $RF->update_transaction_profit($transID); return array("action" => "Transaction ID " . $values['append'] . " refund removed.", "status" => "success"); }
include "includes/header.php"; $sessionAdmin = isset($HTTP_SESSION_VARS["sessionAdmin"]) ? $HTTP_SESSION_VARS["sessionAdmin"] : ""; $ptype = isset($HTTP_GET_VARS['ptype']) ? quote_smart($HTTP_GET_VARS['ptype']) : ""; $headerInclude = "transactions"; //print_r($_REQUEST); require_once "../includes/projSetCalc.php"; $str_adminapproval = ""; $sessionlogin = isset($HTTP_SESSION_VARS["sessionlogin"]) ? $HTTP_SESSION_VARS["sessionlogin"] : ""; $mi_ID = quote_smart($_REQUEST['mi_ID']); $mi_status = quote_smart($_REQUEST['mi_status']); $mi_notes = quote_smart($_REQUEST['mi_notes']); $mi_notes = str_replace('\\r\\n', "\n", $mi_notes); if ($mi_status && $_REQUEST['action'] == 'Update Invoice' && $mi_ID) { $send_invoice_confirm = intval($_POST['send_invoice_confirm']); $invoice_sql = "update cs_merchant_invoice set mi_status = '{$mi_status}', mi_notes = '{$mi_notes}' where mi_ID ='{$mi_ID}'"; $result = sql_query_write($invoice_sql) or dieLog(mysql_error() . " ~ {$invoice_sql}"); $msg = "Invoice #{$mi_ID} Updated."; if ($send_invoice_confirm) { $invoice_sql = "select * from cs_merchant_invoice left join cs_companydetails on userId = mi_company_id where mi_ID ='{$mi_ID}'"; $result = sql_query_read($invoice_sql) or dieLog(mysql_error() . " ~ {$invoice_sql}"); $invoiceInfo = mysql_fetch_assoc($result); $emailData = array(); $emailData["companyname"] = $invoiceInfo['companyname']; $emailData["username"] = $invoiceInfo['username']; $emailData["password"] = $invoiceInfo['password']; $emailData["Reference_ID"] = $invoiceInfo['ReferenceNumber']; $emailData["email"] = $invoiceInfo['email']; $emailData["wiredate"] = $invoiceInfo['mi_paydate']; $emailData["mi_title"] = $invoiceInfo['mi_title']; $emailData["mi_deduction"] = $invoiceInfo['mi_deduction']; $emailData["mi_status"] = $mi_status;
function risk_report_install() { $report['Total Transactions']['desc'] = "The total number and value of all transactions"; $report['Total Transactions']['source'] = '$sales_amount'; $report['Total Transactions']['display'] = '$sales_count . " (\\$" . number_format($sales_amount,2) . ")"'; $report['Declined Transactions']['desc'] = "Alert when Declines are above Percentage"; $report['Declined Transactions']['source'] = '$sales_amount > 0 ? $decline_amount*100/$sales_amount : 0'; $report['Declined Transactions']['display'] = 'number_format($sales_amount > 0 ? $decline_amount*100/$sales_amount : 0,2) . "% (\\$" . number_format($decline_amount,2) . ")"'; $report['Unique Declined Transactions']['desc'] = "Alert when Unique Declines are above Percentage"; $report['Unique Declined Transactions']['source'] = '$sales_amount > 0 ? $uniquedecline_amount*100/$sales_amount : 0'; $report['Unique Declined Transactions']['display'] = 'number_format($sales_amount > 0 ? $uniquedecline_amount*100/$sales_amount : 0,2) . "% (\\$" . number_format($uniquedecline_amount,2) . ")"'; $report['Chargebacks - Total']['desc'] = "Alert when Transaction Chargebacks are over a limit"; $report['Chargebacks - Total']['source'] = '$sales_amount > 0 ? $chargebacks_amount*100/$sales_amount : 0'; $report['Chargebacks - Total']['display'] = 'number_format($sales_amount > 0 ? $chargebacks_amount*100/$sales_amount : 0,2)."% (\\$" . number_format($chargebacks_amount,2) . ")"'; $report['Chargebacks - Visa']['desc'] = "Alert when Visa Transaction Chargebacks are over a limit"; $report['Chargebacks - Visa']['source'] = '$sales_amount > 0 ? $chargebacksVisa_amount*100/$sales_amount : 0'; $report['Chargebacks - Visa']['display'] = 'number_format($sales_amount > 0 ? $chargebacksVisa_amount*100/$sales_amount : 0,2) . "% (\\$" . number_format(chargebacksVisa_amount,2) . ")"'; $report['Chargebacks - MC']['desc'] = "Alert when Mastercard Transaction Chargebacks are over a limit"; $report['Chargebacks - MC']['source'] = '$sales_amount > 0 ? $chargebacksMastercard_amount*100/$sales_amount : 0'; $report['Chargebacks - MC']['display'] = 'number_format($sales_amount > 0 ? $chargebacksMastercard_amount*100/$sales_amount : 0,2) . "% (\\$" . number_format($chargebacksMastercard_amount,2) . ")"'; $report['Refunds']['desc'] = "Alert when Refunds are over a limit"; $report['Refunds']['source'] = '$sales_amount > 0 ? $refund_amount*100/$sales_amount : 0'; $report['Refunds']['display'] = 'number_format($sales_amount > 0 ? $refund_amount*100/$sales_amount : 0,2) . "% (\\$" . number_format($refund_amount,2) . ")"'; $report['Non-Unique Transactions']['desc'] = "Alert when Non-Unique Transactions are over a limit"; $report['Non-Unique Transactions']['source'] = '$sales_amount > 0 ? $nonunique_amount*100/$sales_amount : 0'; $report['Non-Unique Transactions']['display'] = 'number_format($sales_amount > 0 ? $nonunique_amount*100/$sales_amount : 0,2) . "% (\\$" . number_format($nonunique_amount,2) . ")"'; // $report['Unique Transactions']['desc'] = "Alert when Unique Approved Transactions are over a limit"; // $report['Unique Transactions']['source'] = '$sales_amount > 0 ? $unique_amount*100/$sales_amount : 0'; // $report['Unique Transactions']['display'] = 'number_format($sales_amount > 0 ? $unique_amount*100/$sales_amount : 0,2) . "% (\$" . number_format($unique_amount,2) . ")"'; $report['CreditCard Transactions']['desc'] = "Report on CreditCard Sales"; $report['CreditCard Transactions']['source'] = '$sales_amount > 0 ? $creditcard_amount*100/$sales_amount : 0'; $report['CreditCard Transactions']['display'] = 'number_format($sales_amount > 0 ? $creditcard_amount*100/$sales_amount : 0,2) . "% (\\$" . number_format($creditcard_amount,2) . ")"'; $report['Check Transactions']['desc'] = "Report on Check Sales"; $report['Check Transactions']['source'] = '$sales_amount > 0 ? $check_amount*100/$sales_amount : 0'; $report['Check Transactions']['display'] = 'number_format($sales_amount > 0 ? $check_amount*100/$sales_amount : 0,2) . "% (\\$" . number_format($check_amount,2) . ")"'; $report['Web900 Transactions']['desc'] = "Report on Web900 Sales"; $report['Web900 Transactions']['source'] = '$sales_amount > 0 ? $web900_amount*100/$sales_amount : 0'; $report['Web900 Transactions']['display'] = 'number_format($sales_amount > 0 ? $web900_amount*100/$sales_amount : 0,2) . "% (\\$" . number_format($web900_amount,2) . ")"'; $report['Spider Score']['desc'] = "Alert when website has a high Spider Score"; $report['Spider Score']['source'] = 'number_format($spider,2)'; $report['Customer Support']['desc'] = "Report on Customer Service"; $report['Customer Support']['source'] = 'str_replace("\\n,","<br>",$customerservice)'; $report['Total Transactions']['label'] = array(array("limit" => 0, "text" => "Very Low", "color" => "FFFFFF", "score" => 0, "plaintext" => ""), array("limit" => 1000, "text" => "Low", "color" => "CCFFCC", "score" => 0, "plaintext" => ""), array("limit" => 5000, "text" => "Medium", "color" => "99FF99", "score" => 0, "plaintext" => ""), array("limit" => 10000, "text" => "High", "color" => "66FF66", "score" => 0, "plaintext" => ""), array("limit" => 100000, "text" => "Severe", "color" => "00FF00", "score" => 0, "plaintext" => "")); $report['Declined Transactions']['label'] = array(array("limit" => 0, "text" => "Very Low", "color" => "FFFFFF", "score" => 0, "plaintext" => ""), array("limit" => 15, "text" => "Low", "color" => "FFEEEE", "score" => 10, "plaintext" => "The number of declined transactions is currently at a low level."), array("limit" => 25, "text" => "Medium", "color" => "FFAAAA", "score" => 20, "plaintext" => "You should be aware of the number of declined transactions. This number should be lower."), array("limit" => 35, "text" => "High", "color" => "FF6666", "score" => 30, "plaintext" => "The number of declined transactions is approaching an unacceptible level. Please take steps to correct this."), array("limit" => 45, "text" => "Severe", "color" => "FF0000", "score" => 40, "plaintext" => "The number of declined transactions is above the acceptible level. You must correct this problem as soon as possible.")); $report['Unique Declined Transactions']['label'] = array(array("limit" => 0, "text" => "Very Low", "color" => "FFFFFF", "score" => 0, "plaintext" => ""), array("limit" => 17, "text" => "Low", "color" => "FFEEEE", "score" => 10, "plaintext" => "Some transactions are not being approved."), array("limit" => 18, "text" => "Medium", "color" => "FFAAAA", "score" => 20, "plaintext" => "The number of transactions not being approved is getting high. Please correct this."), array("limit" => 19, "text" => "High", "color" => "FF6666", "score" => 30, "plaintext" => "The number of transactions that have not be approved is reaching an unacceptible level. You should take steps to correct this."), array("limit" => 20, "text" => "Severe", "color" => "FF0000", "score" => 40, "plaintext" => "The number of transactions that failed to be approved is at an unacceptible level. You must correct this.")); $report['Chargebacks - Total']['label'] = array(array("limit" => 0, "text" => "Very Low", "color" => "FFFFFF", "score" => 0, "plaintext" => ""), array("limit" => 0.5, "text" => "Low", "color" => "FFEEEE", "score" => 10, "plaintext" => "You have a low number of chargebacks."), array("limit" => 1.0, "text" => "Medium", "color" => "FFAAAA", "score" => 20, "plaintext" => "The number of chargebacks is getting high. Be aware of this."), array("limit" => 1.5, "text" => "High", "color" => "FF6666", "score" => 30, "plaintext" => "The number of chargebacks is reaching an unacceptible level. You should take steps to correct this."), array("limit" => 2.0, "text" => "Severe", "color" => "FF0000", "score" => 40, "plaintext" => "The number of chargebacks is at an unacceptible level. You must correct this.")); $report['Chargebacks - Visa']['label'] = array(array("limit" => 0, "text" => "Very Low", "color" => "FFFFFF", "score" => 0, "plaintext" => ""), array("limit" => 0.5, "text" => "Low", "color" => "FFEEEE", "score" => 10, "plaintext" => "You have a very low occurance of chargebacks on Visa cards."), array("limit" => 1.0, "text" => "Medium", "color" => "FFAAAA", "score" => 20, "plaintext" => "The number of chargebacks on Visa cards is getting high. You need to watch this."), array("limit" => 1.5, "text" => "High", "color" => "FF6666", "score" => 30, "plaintext" => "The number of chargebacks on Visa cards is getting too high. You must correct this."), array("limit" => 2.0, "text" => "Severe", "color" => "FF0000", "score" => 40, "plaintext" => "The number of chargebacks on Visa cards is unacceptible. This must be corrected immediately.")); $report['Chargebacks - MC']['label'] = array(array("limit" => 0, "text" => "Very Low", "color" => "FFFFFF", "score" => 0, "plaintext" => ""), array("limit" => 0.25, "text" => "Low", "color" => "FFEEEE", "score" => 10, "plaintext" => "You have a very low occurance of chargebacks on Mastercard."), array("limit" => 0.5, "text" => "Medium", "color" => "FFAAAA", "score" => 20, "plaintext" => "The number of chargebacks on Mastercard is getting high. You need to watch this."), array("limit" => 0.75, "text" => "High", "color" => "FF6666", "score" => 30, "plaintext" => "The number of chargebacks on Mastercard is getting too high. You must correct this."), array("limit" => 1.0, "text" => "Severe", "color" => "FF0000", "score" => 40, "plaintext" => "The number of chargebacks on Mastercard is unacceptible. This must be corrected immediately.")); $report['Refunds']['label'] = array(array("limit" => 0, "text" => "Very Low", "color" => "FFFFFF", "score" => 0, "plaintext" => ""), array("limit" => 5, "text" => "Low", "color" => "FFEEEE", "score" => 10, "plaintext" => "The number of refunds is low but you should keep an eye on them."), array("limit" => 6, "text" => "Medium", "color" => "FFAAAA", "score" => 20, "plaintext" => "The number of refunds is getting higher. You should find ways to reduce refunds."), array("limit" => 7, "text" => "High", "color" => "FF6666", "score" => 30, "plaintext" => "The number of refunds is high. You need to fix this."), array("limit" => 8, "text" => "Severe", "color" => "FF0000", "score" => 40, "plaintext" => "The number of refunds is unacceptible. This must be fixed.")); $report['Non-Unique Transactions']['label'] = array(array("limit" => 0, "text" => "Very Low", "color" => "FFFFFF", "score" => 0, "plaintext" => ""), array("limit" => 15, "text" => "Low", "color" => "FFEEEE", "score" => 10, "plaintext" => ""), array("limit" => 20, "text" => "Medium", "color" => "FFAAAA", "score" => 20, "plaintext" => ""), array("limit" => 25, "text" => "High", "color" => "FF6666", "score" => 30, "plaintext" => ""), array("limit" => 30, "text" => "Severe", "color" => "FF0000", "score" => 40, "plaintext" => "")); /* $report['Unique Transactions']['label'] = array( array("limit"=>0,"text"=>"Very Low","color"=>"FFFFFF","score"=>0,"plaintext"=>""), array("limit"=>15,"text"=>"Low","color"=>"FFEEEE","score"=>10,"plaintext"=>""), array("limit"=>20,"text"=>"Medium","color"=>"FFAAAA","score"=>20,"plaintext"=>""), array("limit"=>25,"text"=>"High","color"=>"FF6666","score"=>30,"plaintext"=>""), array("limit"=>30,"text"=>"Severe","color"=>"FF0000","score"=>40,"plaintext"=>"") ); */ $report['CreditCard Transactions']['label'] = array(array("limit" => 0, "text" => "Very Low", "color" => "FFFFFF", "score" => 0, "plaintext" => ""), array("limit" => 15, "text" => "Low", "color" => "FFEEEE", "score" => 10, "plaintext" => ""), array("limit" => 20, "text" => "Medium", "color" => "FFAAAA", "score" => 20, "plaintext" => ""), array("limit" => 25, "text" => "High", "color" => "FF6666", "score" => 30, "plaintext" => ""), array("limit" => 30, "text" => "Severe", "color" => "FF0000", "score" => 40, "plaintext" => "")); $report['Check Transactions']['label'] = array(array("limit" => 0, "text" => "Very Low", "color" => "FFFFFF", "score" => 0, "plaintext" => ""), array("limit" => 15, "text" => "Low", "color" => "FFEEEE", "score" => 10, "plaintext" => ""), array("limit" => 20, "text" => "Medium", "color" => "FFAAAA", "score" => 20, "plaintext" => ""), array("limit" => 25, "text" => "High", "color" => "FF6666", "score" => 30, "plaintext" => ""), array("limit" => 30, "text" => "Severe", "color" => "FF0000", "score" => 40, "plaintext" => "")); $report['Web900 Transactions']['label'] = array(array("limit" => 0, "text" => "Very Low", "color" => "FFFFFF", "score" => 0, "plaintext" => ""), array("limit" => 15, "text" => "Low", "color" => "FFEEEE", "score" => 10, "plaintext" => ""), array("limit" => 20, "text" => "Medium", "color" => "FFAAAA", "score" => 20, "plaintext" => ""), array("limit" => 25, "text" => "High", "color" => "FF6666", "score" => 30, "plaintext" => ""), array("limit" => 30, "text" => "Severe", "color" => "FF0000", "score" => 40, "plaintext" => "")); $report['Spider Score']['label'] = array(array("limit" => 0, "text" => "Very Low", "color" => "FFFFFF", "score" => 0, "plaintext" => ""), array("limit" => 15, "text" => "Low", "color" => "FFEEEE", "score" => 10, "plaintext" => ""), array("limit" => 20, "text" => "Medium", "color" => "FFAAAA", "score" => 20, "plaintext" => ""), array("limit" => 25, "text" => "High", "color" => "FF6666", "score" => 30, "plaintext" => ""), array("limit" => 30, "text" => "Severe", "color" => "FF0000", "score" => 40, "plaintext" => "")); $report_dates[] = array("rrd_name" => "month", "rrd_title" => "This Month", "rrd_from_day" => '1', "rrd_from_month" => '$this_month', "rrd_from_year" => '$this_year', "rrd_to_day" => '0', "rrd_to_month" => '$this_month+1', "rrd_to_year" => '$this_year'); $report_dates[] = array("rrd_name" => "month", "rrd_title" => "Last Month", "rrd_from_day" => '1', "rrd_from_month" => '$this_month-1', "rrd_from_year" => '$this_year', "rrd_to_day" => '0', "rrd_to_month" => '$this_month', "rrd_to_year" => '$this_year'); $report_dates[] = array("rrd_name" => "day", "rrd_title" => "Today", "rrd_from_day" => '$this_day', "rrd_from_month" => '$this_month', "rrd_from_year" => '$this_year', "rrd_to_day" => '$this_day', "rrd_to_month" => '$this_month', "rrd_to_year" => '$this_year'); $report_dates[] = array("rrd_name" => "day", "rrd_title" => "Yesterday", "rrd_from_day" => '$this_day-1', "rrd_from_month" => '$this_month', "rrd_from_year" => '$this_year', "rrd_to_day" => '$this_day-1', "rrd_to_month" => '$this_month', "rrd_to_year" => '$this_year'); $report_dates[] = array("rrd_name" => "week", "rrd_title" => "Last Week", "rrd_from_day" => '$this_day-13', "rrd_from_month" => '$this_month', "rrd_from_year" => '$this_year', "rrd_to_day" => '$this_day-7', "rrd_to_month" => '$this_month', "rrd_to_year" => '$this_year'); $report_dates[] = array("rrd_name" => "week", "rrd_title" => "This Week", "rrd_from_day" => '$this_day-6', "rrd_from_month" => '$this_month', "rrd_from_year" => '$this_year', "rrd_to_day" => '$this_day', "rrd_to_month" => '$this_month', "rrd_to_year" => '$this_year'); $report_proj[] = array("rrp_name" => 'tomorrow', "rrp_title" => 'Tomorrow', "rrp_equation" => 'number_format($lastday != 0 ? $thisday+$thisday-$lastday : 0,2)'); $report_proj[] = array("rrp_name" => 'nextweek', "rrp_title" => 'Next Week', "rrp_equation" => 'number_format($lastweek != 0 ? $thisweek+$thisweek-$lastweek : 0,2)'); $report_proj[] = array("rrp_name" => 'nextmonth', "rrp_title" => 'Next Month', "rrp_equation" => 'number_format($lastmonth != 0 ? $thismonth+$thismonth-$lastmonth : 0,2)'); foreach ($report as $title => $info) { $values = "rrc_title=\"" . $title . "\""; $values .= ", rrc_desc=\"" . $info['desc'] . "\""; $values .= ", rrc_equation='" . $info['source'] . "'"; $values .= ", rrc_display='" . $info['display'] . "'"; $values .= ", rrc_label='" . quote_smart(serialize($info['label'])) . "'"; $sql = "INSERT INTO cs_risk_report_calc SET {$values} ON DUPLICATE KEY UPDATE {$values};"; $res = sql_query_write($sql) or dieLog(mysql_error()); } $sql = "DELETE FROM cs_risk_report_dates"; $res = sql_query_write($sql) or dieLog(mysql_error()); foreach ($report_dates as $index => $info) { $values = ""; foreach ($info as $name => $value) { $values .= ($values != "" ? ", " : "") . "{$name}=\"{$value}\""; } $sql = "INSERT INTO cs_risk_report_dates SET {$values};"; $res = sql_query_write($sql) or dieLog(mysql_error()); } foreach ($report_proj as $index => $info) { $values = ""; foreach ($info as $name => $value) { $values .= ($values != "" ? ", " : "") . "{$name}=\"{$value}\""; } $sql = "INSERT INTO cs_risk_report_projections SET {$values} ON DUPLICATE KEY UPDATE {$values};"; $res = sql_query_write($sql) or dieLog(mysql_error()); } }
function commit_transfer($data) { $sql = "\n\t\tInsert into \n\t\t\tcs_profit_action\n\t\tset\n\t\t\tpa_date = now(),\n\t\t\tpa_status = 'pending',\n\t\t\tpa_desc = '" . $data['description'] . "',\n\t\t\tpa_info = '" . quote_smart(serialize($data)) . "'\n\t\t"; $result = sql_query_write($sql) or dieLog(mysql_error() . " ~ {$sql}"); $pa_ID = mysql_insert_id(); if (!$result || !$pa_ID) { dieLog(mysql_error() . " ~ {$sql}"); } sql_query_write("Start Transaction") or dieLog(mysql_error() . " ~ {$sql}"); foreach ($data['transfers'] as $transfer) { $transfer['amount'] = floatval($transfer['amount']); if ($transfer['amount'] <= 0) { dieLog("Profit Transfer Error: Amount <=0 " . print_r($transfer, true)); } if ($transfer['from_entity'] < 1 || $transfer['to_entity'] < 1) { dieLog("Profit Transfer Error: Entity ID < 1 " . print_r($transfer, true)); } if (!$transfer['date_entered'] || !strtotime($transfer['date_entered'])) { $transfer['date_entered'] = date('Y-m-d G:i:s'); } if (!$transfer['date_effective'] || !strtotime($transfer['date_effective'])) { $transfer['date_effective'] = date('Y-m-d G:i:s'); } if (!$transfer['transfer_type']) { $transfer['transfer_type'] = 'General'; } $params = array(); $params['pt_action_ID'] = $pa_ID; $params['pt_type'] = $transfer['transfer_type']; $params['pt_bank_ID'] = $transfer['bank_ID']; $params['pt_trans_ID'] = $transfer['trans_ID']; $params['pt_date_entered'] = $transfer['date_entered']; $params['pt_date_effective'] = $transfer['date_effective']; // Transfer From $params['pt_amount'] = -$transfer['amount']; $params['pt_entity_ID'] = $transfer['from_entity']; $sql_set = ""; foreach ($params as $p_name => $p_value) { $sql_set .= ($sql_set == "" ? "" : ",\r\n") . $p_name . " = '" . quote_smart($p_value) . "'"; } $sql = "\n\t\t\tINSERT INTO\n\t\t\t\tcs_profit\n\t\t\tSET\n\t\t\t\t{$sql_set}\n\t\t\t"; $result = sql_query_write($sql); if (!$result) { sql_query_write("RollBack") or dieLog(mysql_error() . " ~ {$sql}"); dieLog(mysql_error() . " ~ {$sql}"); } // Transfer To $params['pt_amount'] = $transfer['amount']; $params['pt_entity_ID'] = $transfer['to_entity']; $sql_set = ""; foreach ($params as $p_name => $p_value) { $sql_set .= ($sql_set == "" ? "" : ",\r\n") . $p_name . " = '" . quote_smart($p_value) . "'"; } $sql = "\n\t\t\tINSERT INTO\n\t\t\t\tcs_profit\n\t\t\tSET\n\t\t\t\t{$sql_set}\n\t\t\t"; $result = sql_query_write($sql); if (!$result) { sql_query_write("RollBack") or dieLog(mysql_error() . " ~ {$sql}"); dieLog(mysql_error() . " ~ {$sql}"); } } sql_query_write("Commit") or dieLog(mysql_error() . " ~ {$sql}"); $sql = "\n\t\t\tUpdate \n\t\t\t\tcs_profit_action\n\t\t\tSet\n\t\t\t\tpa_status = 'success'\n\t\t\tWhere\n\t\t\t\tpa_ID = '{$pa_ID}'\n\t\t\t"; $result = sql_query_write($sql) or dieLog(mysql_error() . " ~ {$sql}"); }
function update_banlist($data, $bl_group = 0) { if ($bl_group) { $sql = "Delete from cs_banlist where bl_group = '{$bl_group}'"; sql_query_write($sql) or dieLog(mysql_error() . " ~ {$sql}"); } else { //$sql = "select bl1.bl_group+1 as nextAvailable from `cs_banlist` as bl1 left join `cs_banlist` as bl2 on bl1.bl_group = bl2.bl_group-1 where bl2.bl_group is null limit 1"; $sql = "select max(bl_group)+1 as nextAvailable from `cs_banlist`"; $result = sql_query_read($sql) or dieLog(mysql_error() . " ~ {$sql}"); if (mysql_num_rows($result)) { $bl_group = @mysql_result($result, 0, 0); } if ($bl_group < 1) { $bl_group = 1; } } $cnt = 0; foreach ($data as $bl_type => $bl_data) { if ($this->bl_types[$bl_type] && $bl_data) { $cnt++; } } if ($cnt == sizeof($data)) { foreach ($data as $bl_type => $bl_data) { $sql = "Insert into cs_banlist set bl_group = '{$bl_group}', bl_type = '{$bl_type}', bl_data = '{$bl_data}'"; if ($this->bl_types[$bl_type] && $bl_data) { sql_query_write($sql) or dieLog(mysql_error() . " ~ {$sql}"); } } } return array('bl_group' => $bl_group); }
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])) { $unique[$key] = $transInfo['transactionId']; } }
sql_query_read($qry_update) or dieLog(mysql_error() . " ~ " . $qry_update, "Failed to reenable URL for this company. Please contact support."); toLog('pendingwebsite', 'merchant', "Merchant {$siteid} reenables site {$cs_URL}", $deleted_cs_info['cs_ID']); } else { $msg = "Added Site Successfully."; $qry_update = "INSERT INTO `cs_company_sites` \n\t\t\t\t\t\tSET \n\t\t\t\t\t\t\tcs_created = NOW(),\n\t\t\t\t\t\t\tcs_en_ID = '" . $companyInfo['en_ID'] . "', \n\t\t\t\t\t\t\tcs_URL = '{$cs_URL}',\n\t\t\t\t\t\t\tcs_title = '{$cs_title}',\n\t\t\t\t\t\t\tcs_order_page = '{$cs_order_page}',\n\t\t\t\t\t\t\tcs_return_page = '{$cs_return_page}',\n\t\t\t\t\t\t\tcs_gatewayId = '" . $_SESSION["gw_id"] . "',\n\t\t\t\t\t\t\tcs_company_id = '{$siteid}',\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tcs_reference_ID = '" . strtoupper(md5($hashURL)) . "',\n\t\t\t\t\t\t\tcs_name = '{$hashURL}',\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tcs_ftp_user='******', \n\t\t\t\t\t\t\tcs_ftp_pass='******', \n\t\t\t\t\t\t\tcs_ftp='{$cs_ftp}', \n\t\t\t\t\t\t\tcs_support_email='{$cs_support_email}', \n\t\t\t\t\t\t\tcs_support_phone='{$cs_support_phone}', \n\t\t\t\t\t\t\tcs_reason = '',\n\t\t\t\t\t\t\tcs_2257_page = '{$cs_2257_page}',\n\t\t\t\t\t\t\tcs_member_url = '{$cs_member_url}',\n\t\t\t\t\t\t\tcs_member_username = '******',\n\t\t\t\t\t\t\tcs_member_password = '******',\n\t\t\t\t\t\t\tcs_enable_passmgmt = '{$cs_enable_passmgmt}',\n\t\t\t\t\t\t\tcs_allow_testmode = '{$cs_allow_testmode}',\n\n\t\t\t\t\t\t\tcs_member_secret = '{$cs_member_secret}',\n\t\t\t\t\t\t\tcs_member_data = '" . serialize($cs_member_data) . "',\n\t\t\t\t\t\t\tcs_member_updateurl = '{$cs_member_updateurl}',\n\n\t\t\t\t\t\t\tcs_notify_url = '{$cs_notify_url}',\n\t\t\t\t\t\t\tcs_notify_retry = '{$cs_notify_retry}',\n\t\t\t\t\t\t\tcs_notify_user = '******',\n\t\t\t\t\t\t\tcs_notify_pass = '******',\n\t\t\t\t\t\t\tcs_notify_type = '{$cs_notify_type}',\n\t\t\t\t\t\t\tcs_notify_key = '{$cs_notify_key}',\n\n\t\t\t\t\t\t\tcs_notify_event = '{$cs_notify_event}',\n\t\t\t\t\t\t\tcs_notify_eventurl = '{$cs_notify_eventurl}',\n\t\t\t\t\t\t\tcs_notify_eventuser = '******',\n\t\t\t\t\t\t\tcs_notify_eventpass = '******',\n\t\t\t\t\t\t\tcs_notify_eventdomain = '{$cs_notify_eventdomain}',\n\t\t\t\t\t\t\tcs_notify_eventlogintype = '{$cs_notify_eventlogintype}'\n\t\t\t\t\t\t"; sql_query_read($qry_update) or dieLog(mysql_error() . " ~ " . $qry_update, "Failed to add URL to this company. This URL may already exist for another company."); toLog('pendingwebsite', 'merchant', "Merchant {$siteid} adds site {$cs_URL}", mysql_insert_id()); } } else { if ($_POST['mode'] == 'edit') { $qry_update = "UPDATE `cs_company_sites` \n\t\t\t\t\t\tSET \n\t\t\t\t\t\t\tcs_order_page = '{$cs_order_page}',\n\t\t\t\t\t\t\tcs_title = '{$cs_title}',\n\t\t\t\t\t\t\tcs_return_page = '{$cs_return_page}',\n\t\t\t\t\t\t\tcs_ftp_user='******', \n\t\t\t\t\t\t\tcs_ftp_pass='******', \n\t\t\t\t\t\t\tcs_ftp='{$cs_ftp}', \n\t\t\t\t\t\t\tcs_support_email='{$cs_support_email}', \n\t\t\t\t\t\t\tcs_support_phone='{$cs_support_phone}', \n\t\t\t\t\t\t\tcs_reason = '',\n\t\t\t\t\t\t\tcs_2257_page = '{$cs_2257_page}',\n\t\t\t\t\t\t\tcs_member_url = '{$cs_member_url}',\n\t\t\t\t\t\t\tcs_member_username = '******',\n\t\t\t\t\t\t\tcs_member_password = '******',\n\t\t\t\t\t\t\tcs_enable_passmgmt = '{$cs_enable_passmgmt}',\n\n\t\t\t\t\t\t\tcs_member_secret = '{$cs_member_secret}',\n\t\t\t\t\t\t\tcs_member_data = '" . serialize($cs_member_data) . "',\n\t\t\t\t\t\t\tcs_member_updateurl = '{$cs_member_updateurl}',\n\n\t\t\t\t\t\t\tcs_notify_url = '{$cs_notify_url}',\n\t\t\t\t\t\t\tcs_notify_retry = '{$cs_notify_retry}',\n\t\t\t\t\t\t\tcs_notify_user = '******',\n\t\t\t\t\t\t\tcs_notify_pass = '******',\n\t\t\t\t\t\t\tcs_notify_type = '{$cs_notify_type}',\n\t\t\t\t\t\t\tcs_notify_key = '{$cs_notify_key}',\n\t\t\t\t\t\t\tcs_allow_testmode = '{$cs_allow_testmode}',\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tcs_notify_event = '{$cs_notify_event}',\n\t\t\t\t\t\t\tcs_notify_eventurl = '{$cs_notify_eventurl}',\n\t\t\t\t\t\t\tcs_notify_eventuser = '******',\n\t\t\t\t\t\t\tcs_notify_eventpass = '******',\n\t\t\t\t\t\t\tcs_notify_eventdomain = '{$cs_notify_eventdomain}',\n\t\t\t\t\t\t\tcs_notify_eventlogintype = '{$cs_notify_eventlogintype}'\n\t\t\t\t\t"; //if(strcasecmp("approved",$cs_verified) !=0 ) // $qry_update .=",cs_verified = 'pending'"; $qry_update .= "\t\t\t\t\t\t\t\n\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t{$identity} AND `cs_ID` = '{$cs_ID}'"; toLog('pendingwebsite', 'merchant', "Merchant {$siteid} updates site {$cs_URL}", $cs_ID); sql_query_write($qry_update) or dieLog(mysql_error() . " ~ " . $qry_update, "Failed to edit URL for this company. Please contact support."); } } } $sql = "SELECT * FROM `cs_company_sites` WHERE {$identity} AND cs_hide = '0' order by cs_verified DESC"; if (!($result = sql_query_read($sql, 1))) { dieLog(mysql_errno() . ": " . mysql_error() . "<BR>"); } else { ?> <script language="javascript"> function removeQuery(name) { return confirm("Are you sure you want to delete Site '"+name+"'?");
function etel_get_clicker_ID(&$data) { $sql_select = " select tk_ID,tk_ref from cs_tracking_clicker "; if ($data['Clicker_Ref']) { $sql .= "{$sql_select} where tk_ref = '" . quote_smart($data['Clicker_Ref']) . "' \n\t\tUNION\n\t\t"; } $sql .= "{$sql_select} where tk_host = '" . quote_smart($data['host_name']) . "'\n\t\tUNION\n\t\t{$sql_select} where tk_IP = INET_ATON( '" . $data['ip_address'] . "' ) "; $result = sql_query_read($sql) or dieLog(mysql_error() . " ~ {$sql}"); if (mysql_num_rows($result)) { $clicker = mysql_fetch_assoc($result); $data['tc_clicker_ID'] = $clicker['tk_ID']; $data['Clicker_Ref'] = $clicker['tk_ref']; return $clicker['tk_ID']; } $new_tk_ref = substr(md5(serialize($data)), 0, 32); $sql = "INSERT INTO cs_tracking_clicker set \n\t\ttk_IP = INET_ATON( '" . $data['ip_address'] . "' ),\n\t\ttk_host = '" . quote_smart($data['host_name']) . "', \n\t\ttk_ref = '{$new_tk_ref}' \n\t"; $result = sql_query_write($sql) or dieLog(mysql_error() . " ~ {$sql}"); $data['tc_clicker_ID'] = mysql_insert_id(); $data['Clicker_Ref'] = $new_tk_ref; return $data['tc_clicker_ID']; }
} if (isset($_FILES['file_article'])) { $file_status[] = func_upload_file($cnn_cs, $_FILES['file_article'], $company_id, "Articles"); } if (isset($_FILES['file_process_history'])) { $file_status[] = func_upload_file($cnn_cs, $_FILES['file_process_history'], $company_id, "History"); } if (isset($_FILES['file_merchant_contract'])) { $file_status[] = func_upload_file($cnn_cs, $_FILES['file_merchant_contract'], $company_id, "Contract"); } if (isset($_FILES['file_professional_reference'])) { $file_status[] = func_upload_file($cnn_cs, $_FILES['file_professional_reference'], $company_id, "Professional_Reference"); } $str_qry = "update cs_companydetails set cd_completion=6 where userId = '{$company_id}'"; if ($curUserInfo['cd_completion'] == 5) { sql_query_write($str_qry) or dieLog(mysql_errno() . ": " . mysql_error() . "<BR>{$str_qry}"); en_status_change_notify($curUserInfo['en_ID']); } beginTable(); print "<br><table align=center width='400' cellpadding='0' cellspacing='0'>"; print "<tr bgcolor='#CCCCCC'><td class='cl1'><font class='subhd'> File Name</span></td><td class='cl1'><span class='subhd'> Status</span></td></tr>"; for ($i = 0; $i < count($file_status); $i++) { if ($file_status[$i] != "") { $file_details = split("@#@", $file_status[$i]); print "<tr height='20'><td class='leftbottomright'><font face='verdana' size='1'> {$file_details['0']}</font></td><td class='cl1'><font face='verdana' size='1'> {$file_details['1']}</font></td></tr>"; } } print "</table>"; endTable("Upload Documents", "viewuploads.php", NULL, 0, 1); include "includes/footer.php"; function func_upload_file($cnn_cs, $file_object, $company_id, $file_type)
$use_calc[$name] = array(); } foreach ($use_calc as $name => $info) { $frm_append = "frm_" . strtolower(str_replace(array(" ", "-"), "_", $name)); foreach ($_POST as $post_name => $value) { if (stristr($post_name, $frm_append) !== FALSE) { $values = str_replace($frm_append . "_", "", $post_name); $values = explode("_", $values); $use_calc[$name]['labels'][$values[1]][$values[0]] = $value; } } } $custom_report = quote_smart(serialize(array("dates" => $use_date, "projections" => $use_proj, "calculations" => $use_calc))); $report_name = quote_smart($_POST['frm_report_name']); $sql = "INSERT INTO cs_risk_report SET rr_report_name = \"{$report_name}\", rr_report_settings=\"{$custom_report}\" ON DUPLICATE KEY UPDATE rr_report_settings=\"{$custom_report}\""; $res = sql_query_write($sql) or dieLog(mysql_error() . "error"); } } $report_cust = NULL; if (isset($_POST['frm_report_name'])) { $report_cust = $report->get_custom_report($_POST['frm_report_name']); } else { if (isset($_POST['frm_selected_report'])) { $report_cust = $report->get_custom_report($_POST['frm_selected_report']); } } $report_date = $report->report_date; $report_proj = $report->report_proj; $report_calc = $report->report_calc; /* $report->array_print($report_date);
function run_cron() { if ($this->sql_options == NULL) { return; } $sql_queries = $this->create_query(); foreach ($sql_queries as $company_id => $date_ranges) { $this->final_report[$company_id]['rc_results'] = array(); foreach ($date_ranges as $date_range => $sql_query) { $result = sql_query_read($sql_query); if (!$result) { echo "<p><b>" . mysql_error() . "</b><br>{$sql_query}</p>"; } else { if ($row = mysql_fetch_assoc($result)) { $this->final_report[$company_id]['rc_results'] += $row; } else { $this->final_report[$company_id]['rc_results'][$date_range] = 0; } } } $risk_calc = get_merchant_quick_status($company_id); $this->final_report[$company_id]['rc_risk_value'] = $risk_calc['percent']; $this->final_report[$company_id]['rc_date_time'] = time(); $this->final_report[$company_id]['rc_results'] = serialize($this->final_report[$company_id]['rc_results']); $this->goto_sleep(); } $sql = array(); foreach ($this->final_report as $company_id => $fields) { $values = "rc_company_id = {$company_id}"; foreach ($fields as $field => $value) { $values .= ($values != "" ? ", " : "") . "{$field} = \"" . quote_smart($value) . "\""; } $sql = "INSERT cs_risk_cron SET {$values} ON DUPLICATE KEY UPDATE {$values}"; $res = sql_query_write($sql) or dieLog("error" . mysql_error() . "<pre>{$sql}</pre>"); $this->goto_sleep(); } }
if (!isset($_POST['ticket_status']) || $_POST['ticket_status'] == '') { $_POST['ticket_status'] = 'Open'; } $_POST['account'] = Clean_It($_POST['account']); $_POST['name'] = Clean_It($_POST['name']); $_POST['email'] = Clean_It($_POST['email']); $_POST['ticketsubject'] = Clean_It($_POST['ticketsubject']); $_POST['category'] = Clean_It($_POST['category']); $_POST['urgency'] = Clean_It($_POST['urgency']); $_POST['ticket_status'] = Clean_It($_POST['ticket_status']); $_POST['message'] = Clean_It($_POST['message']); $urgency = explode('|', $_POST['urgency']); $category = explode('|', $_POST['category']); $tickets_reference = strtoupper(substr(md5(time() . rand(0, 1000)), 0, 16)); $query = "\tINSERT INTO tickets_tickets\n\t\t\t\t\t\t\tSET\n\t\t\t\t\t\t\ttickets_username = '******'account'] . "',\n\t\t\t\t\t\t\ttickets_subject\t = '" . $_POST['ticketsubject'] . "',\n\t\t\t\t\t\t\ttickets_timestamp = '" . mktime() . "',\n\t\t\t\t\t\t\ttickets_status = '" . $_POST['ticket_status'] . "',\n\t\t\t\t\t\t\ttickets_name\t = '" . $_POST['name'] . "',\n\t\t\t\t\t\t\ttickets_email\t = '" . $_POST['email'] . "',\n\t\t\t\t\t\t\ttickets_urgency\t = '" . $urgency['0'] . "',\n\t\t\t\t\t\t\ttickets_category = '" . $category['0'] . "',\n\t\t\t\t\t\t\ttickets_reference = '{$tickets_reference}',\n\t\t\t\t\t\t\ttickets_question = '" . addslashes($_POST['message']) . "'"; if ($result = sql_query_write($query)) { $lastinsertid = mysql_insert_id(); // CHECK THE FILE ATTACHMENT AND DISPLAY ANY ERRORS if ($allowattachments == 'TRUE' && !isset($_COOKIE['demomode']) || $demomode != 'ON') { FileUploadsVerification("{$_FILES}(userfile)", mysql_insert_id()); } // EMAIL ADMINISTRATOR THE TICKET NOTIFICATION $query = "\tSELECT *\n\t\tFROM tickets_categories WHERE tickets_categories_id = '{$category['0']}'\n\t\tORDER BY tickets_categories_name ASC"; $result = sql_query_read($query); $cat_info = mysql_fetch_assoc($result); $socketfrom = "Ticket-" . $tickets_reference . "@" . $socketdomain; //if($cat_info['tickets_categories_emailname']) $socketfromname = $cat_info['tickets_categories_emailname']; $message = "Ticket ID:\t {$tickets_reference}:" . $_GET['ticketid'] . "\n"; $message .= "Name:\t\t " . $_POST['name'] . "\n"; $message .= "Email:\t " . $_POST['email'] . "\n"; $message .= "Subject:\t " . $_POST['ticketsubject'] . "\n";
function func_upload_file($cnn_cs, $file_object, $company_id, $file_type) { $return_status = "Success"; $b_file_exists = false; $str_current_date_time = func_get_current_date_time(); extract($file_object, EXTR_PREFIX_ALL, 'uf2'); if ($uf2_name != "") { $svr = $_SERVER["PATH_TRANSLATED"]; $path_parts = pathinfo($svr); $str_current_path = $path_parts["dirname"]; $str_file_name = $uf2_name; $str_current_path = ""; $str_file_name = str_replace(" ", "", $str_file_name); $str_current_path .= "../gateway/" . $_SESSION['gw_folder'] . "UserDocuments/{$file_type}/" . $company_id . "_" . $str_file_name; //print ("path=$str_current_path"); if (filesize($uf2_tmp_name) != 0) { if (file_exists($str_current_path)) { $b_file_exists = true; } if (copy($uf2_tmp_name, $str_current_path)) { if (!$b_file_exists) { $str_query = "insert into cs_uploaded_documents(user_id, file_type, file_name, date_uploaded, status) values({$company_id}, '{$file_type}', '" . $company_id . "_" . $str_file_name . "', '{$str_current_date_time}', 'P')"; if (!sql_query_write($str_query, $cnn_cs)) { dieLog(mysql_errno() . ": " . mysql_error() . "<BR>{$str_query}"); } } } else { $return_status = "Upload failed, please try again"; } } else { $return_status = "Invalid file, please upload a valid file"; } } return $return_status; }
$qry_update_user .= "url1='{$url1}', cd_processing_reason='{$cd_processing_reason}',cd_previous_processor='{$cd_previous_processor}', preprocess = '{$prepro}', recurbilling = '{$rebill}', currprocessing = '{$currpro}', "; $qry_update_user .= "auto_cancel='{$strAutoCancel}',time_frame={$iTimeFrame},auto_approve='{$strAutoApprove}',transaction_type='{$transaction_type}',shipping_cancel='{$strShippingCancel}',shipping_timeframe={$iShippingTimeFrame},"; $qry_update_user .= "setupfees={$setupFees},"; $qry_update_user .= "legal_name = '{$legal_companyname}', incorporated_country = '{$inc_country}', incorporated_number = '{$inc_number}', fax_dba = '{$fax_dba}', physical_address = '{$physical_address}', "; $qry_update_user .= "cellular = '{$cellular}', technical_contact_details = '{$tech_contact_details}', admin_contact_details = '{$admin_contact_details}', max_ticket_amt = '{$max_ticket_amt}', min_ticket_amt = '{$min_ticket_amt}', "; $qry_update_user .= "goods_list = '{$goods_list}', volume_last_month = '{$volume_last_month}', volume_prev_30days = '{$volume_prev_30days}', volume_prev_60days = '{$volume_prev_60days}', totals = '{$totals}', "; $qry_update_user .= "forecast_volume_1month = '{$forecast_first_month}', forecast_volume_2month = '{$forecast_second_month}', forecast_volume_3month = '{$forecast_third_month}', "; $qry_update_user .= "current_anti_fraud_system = '{$current_anti_fraud_system}', customer_service_program = '{$customer_service_program}', refund_policy = '{$refund_policy}', "; $qry_update_user .= " email = '{$email}'"; $qry_update_user .= " where userId='{$userid}' {$bank_sql_limit}"; //print($qry_update_user); //if ($adminInfo['li_level'] == 'full' || $resellerInfo['isMasterMerchant']) sql_query_write($qry_update_user) or dieLog(mysql_errno() . ": " . mysql_error() . "<BR>{$qry_update_user}"); $cd_notes = isset($HTTP_POST_VARS['cd_notes']) ? "'" . quote_smart($HTTP_POST_VARS['cd_notes']) . "'" : "NULL"; if ($cd_notes) { sql_query_write("update cs_companydetails set cd_notes = {$cd_notes} where userId='{$userid}'") or dieLog(mysql_errno() . ": " . mysql_error()); } } } } $company_id = isset($HTTP_GET_VARS['company_id']) ? $HTTP_GET_VARS['company_id'] : ""; if ($company_id == "") { $company_id = isset($HTTP_POST_VARS['userid']) ? quote_smart($HTTP_POST_VARS['userid']) : ""; } if ($company_id == "") { $company_id = isset($_REQUEST['userIdList']) ? quote_smart($_REQUEST['userIdList']) : ""; } if ($company_id == "") { $company_id = isset($HTTP_GET_VARS['companyname']) ? quote_smart($HTTP_GET_VARS['companyname']) : ""; } $companyname = isset($HTTP_GET_VARS['companyname']) ? $HTTP_GET_VARS['companyname'] : "";
function etel_update_serialized_field($table, $field, $sql_conditions, $update) { if (!$table || !$sql_conditions || !$field) { return false; } if (!is_array($update)) { return false; } $sql = "select {$field} from {$table} where {$sql_conditions}"; $result = sql_query_read($sql) or dieLog(mysql_error() . " ~ {$sql}"); if (!mysql_num_rows($result)) { return false; } $info_ser = mysql_result($result, 0, 0); $info = @unserialize($info_ser); etel_add_array($info, $update); $new_ser = serialize($info); if ($info_ser == $new_ser) { return $info; } $sql = "update {$table} set {$field} = '" . quote_smart($new_ser) . "' where {$sql_conditions}"; if (is_array($info)) { sql_query_write($sql) or dieLog(mysql_error() . " ~ {$sql}"); } else { return false; } return $info; }