本文整理汇总了PHP中zen_db_perform函数的典型用法代码示例。如果您正苦于以下问题:PHP zen_db_perform函数的具体用法?PHP zen_db_perform怎么用?PHP zen_db_perform使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了zen_db_perform函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: zaikorobot_add_post_log
function zaikorobot_add_post_log($post, $server)
{
// ログ機能が有効な場合のみ
if (ZAIKOROBOT_LOG != "true") {
return;
}
$sql_data_array = array("from_zaikorobot" => print_r($post, true) . "\n" . print_r($server, true), "to_zaikorobot" => "", "date_added" => "now()");
zen_db_perform(FILENAME_ZAIKOROBOT_LOGS, $sql_data_array);
}
示例2: zen_visitors_update_visitors_data
function zen_visitors_update_visitors_data($customers_id, $customers_email_address)
{
global $db;
$customers_id = zen_db_prepare_input($customers_id);
$customers_email_address = zen_db_prepare_input($customers_email_address);
$check_email = $db->Execute("select customers_email_address\r\n from " . TABLE_CUSTOMERS . "\r\n where customers_email_address = '" . zen_db_input($customers_email_address) . "'\r\n and customers_id != '" . (int) $customers_id . "'");
if (!$check_email->RecordCount()) {
$sql_data_array = array('visitors_email_address' => $customers_email_address, 'visitors_info_date_account_last_modified' => 'now()');
zen_db_perform(TABLE_VISITORS, $sql_data_array, 'update', "visitors_id = '" . (int) $customers_id . "'");
}
}
示例3: _set_breadcrumb_block
function _set_breadcrumb_block($template, $css_selector)
{
global $db;
$sql = "SELECT * FROM " . TABLE_BLOCKS . "\n WHERE module = 'super_products_list'\n AND block = 'block_breadcrumb'\n AND template = '" . $template . "'";
$check = $db->Execute($sql);
if ($check->EOF) {
$mode = 'insert';
} else {
$mode = 'update';
$id = $check->fields['id'];
}
$sql_data_array = array('module' => 'super_products_list', 'block' => 'block_breadcrumb', 'template' => $template, 'location' => 'main', 'status' => 1, 'sort_order' => 0, 'visible' => 1, 'pages' => implode("\n", array('product_free_shipping_info', 'product_info', 'product_music_info', 'index_products', 'super_products_list#page_results')), 'css_selector' => $css_selector, 'insert_position' => 'replaceWith');
if ($mode == 'insert') {
zen_db_perform(TABLE_BLOCKS, $sql_data_array);
} else {
zen_db_perform(TABLE_BLOCKS, $sql_data_array, 'update', "id = '" . (int) $id . "'");
}
}
示例4: ec_step2_finish
//.........这里部分代码省略.........
// They're not logged in. Create an account if necessary, and then log them in.
// First, see if they're an existing customer, and log them in automatically
// If Paypal didn't supply us an email address, something went wrong
if (trim($paypal_ec_payer_info['payer_email']) == '') {
$this->terminateEC(MODULE_PAYMENT_PAYPALWPP_INVALID_RESPONSE, true);
}
// attempt to obtain the user information using the payer_email from the info returned from PayPal, via email address
$sql = "SELECT customers_id, customers_firstname, customers_lastname, customers_paypal_payerid, customers_paypal_ec\r\n FROM " . TABLE_CUSTOMERS . "\r\n WHERE customers_email_address = :emailAddress ";
$sql = $db->bindVars($sql, ':emailAddress', $paypal_ec_payer_info['payer_email'], 'string');
$check_customer = $db->Execute($sql);
// debug
$this->zcLog('ec_step2_finish - 4', 'Not logged in. Looking for account.' . "\n" . $sql . "\n" . print_r($check_customer, true));
if (!$check_customer->EOF) {
$acct_exists = true;
// see if this was only a temp account -- if so, remove it
if ($check_customer->fields['customers_paypal_ec'] == '1') {
// Delete the existing temporary account
$this->ec_delete_user($check_customer->fields['customers_id']);
$acct_exists = false;
// debug
$this->zcLog('ec_step2_finish - 5', 'Found temporary account - deleting it.');
}
}
// Create an account, if the account does not exist
if (!$acct_exists) {
// debug
$this->zcLog('ec_step2_finish - 6', 'No ZC account found for this customer. Creating new account.' . "\n" . '$this->new_acct_notify =' . $this->new_acct_notify);
// Generate a random 8-char password
$password = zen_create_random_value(8);
$sql_data_array = array();
// set the customer information in the array for the table insertion
$sql_data_array = array('customers_firstname' => $paypal_ec_payer_info['payer_firstname'], 'customers_lastname' => $paypal_ec_payer_info['payer_lastname'], 'customers_email_address' => $paypal_ec_payer_info['payer_email'], 'customers_telephone' => $paypal_ec_payer_info['ship_phone'], 'customers_fax' => '', 'customers_gender' => $paypal_ec_payer_info['payer_gender'], 'customers_newsletter' => '0', 'customers_password' => zen_encrypt_password($password), 'customers_paypal_payerid' => $_SESSION['paypal_ec_payer_id']);
// insert the data
$result = zen_db_perform(TABLE_CUSTOMERS, $sql_data_array);
// grab the customer_id (last insert id)
$customer_id = $db->Insert_ID();
// set the Guest customer ID -- for PWA purposes
$_SESSION['customer_guest_id'] = $customer_id;
// set the customer address information in the array for the table insertion
$sql_data_array = array('customers_id' => $customer_id, 'entry_gender' => $paypal_ec_payer_info['payer_gender'], 'entry_firstname' => $paypal_ec_payer_info['payer_firstname'], 'entry_lastname' => $paypal_ec_payer_info['payer_lastname'], 'entry_street_address' => $paypal_ec_payer_info['ship_street_1'], 'entry_suburb' => $paypal_ec_payer_info['ship_street_2'], 'entry_city' => $paypal_ec_payer_info['ship_city'], 'entry_zone_id' => $state_id, 'entry_postcode' => $paypal_ec_payer_info['ship_postal_code'], 'entry_country_id' => $country_id);
if ($state_id > 0) {
$sql_data_array['entry_zone_id'] = $state_id;
$sql_data_array['entry_state'] = '';
} else {
$sql_data_array['entry_zone_id'] = 0;
$sql_data_array['entry_state'] = $paypal_ec_payer_info['ship_state'];
}
// insert the data
zen_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array);
// grab the address_id (last insert id)
$address_id = $db->Insert_ID();
// set the address id lookup for the customer
$sql = "UPDATE " . TABLE_CUSTOMERS . "\r\n SET customers_default_address_id = :addrID\r\n WHERE customers_id = :custID";
$sql = $db->bindVars($sql, ':addrID', $address_id, 'integer');
$sql = $db->bindVars($sql, ':custID', $customer_id, 'integer');
$db->Execute($sql);
// insert the new customer_id into the customers info table for consistency
$sql = "INSERT INTO " . TABLE_CUSTOMERS_INFO . "\r\n (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created)\r\n VALUES (:custID, 0, now())";
$sql = $db->bindVars($sql, ':custID', $customer_id, 'integer');
$db->Execute($sql);
// send Welcome Email if appropriate
if ($this->new_acct_notify == 'Yes') {
// require the language file
global $language_page_directory, $template_dir;
if (!isset($language_page_directory)) {
$language_page_directory = DIR_WS_LANGUAGES . $_SESSION['language'] . '/';
示例5: after_process
function after_process()
{
global $insert_id, $db;
$comments = 'trade_no: ' . $_GET['trade_no'] . "\r\n" . 'out_trade_no: ' . $_GET['out_trade_no'] . "\r\n" . 'is_success: ' . $_GET['is_success'] . ' (T:success, F:failed)' . "\r\n" . 'trade_status: ' . $_GET['trade_status'] . "\r\n" . 'forex_total_fee: ' . $_GET['forex_total_fee'] . ' ' . $_GET['currency'] . "\r\n" . 'total_fee: ' . $_GET['total_fee'] . ' RMB' . "\r\n";
$sql_data_array = array('orders_id' => $insert_id, 'orders_status_id' => $this->order_status, 'date_added' => 'now()', 'customer_notified' => '0', 'comments' => $comments);
zen_db_perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array);
return true;
}
示例6: zen_get_languages
$languages = zen_get_languages();
for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
$language_id = $languages[$i]['id'];
$check = $db->Execute("select *\n from " . TABLE_METATAGS_CATEGORIES_DESCRIPTION . "\n where categories_id = '" . (int) $categories_id . "'\n and language_id = '" . (int) $language_id . "'");
if ($check->RecordCount() > 0) {
$action = 'update_category_meta_tags';
} else {
$action = 'insert_categories_meta_tags';
}
$sql_data_array = array('metatags_title' => zen_db_prepare_input($_POST['metatags_title'][$language_id]), 'metatags_keywords' => zen_db_prepare_input($_POST['metatags_keywords'][$language_id]), 'metatags_description' => zen_db_prepare_input($_POST['metatags_description'][$language_id]));
if ($action == 'insert_categories_meta_tags') {
$insert_sql_data = array('categories_id' => $categories_id, 'language_id' => $language_id);
$sql_data_array = array_merge($sql_data_array, $insert_sql_data);
zen_db_perform(TABLE_METATAGS_CATEGORIES_DESCRIPTION, $sql_data_array);
} elseif ($action == 'update_category_meta_tags') {
zen_db_perform(TABLE_METATAGS_CATEGORIES_DESCRIPTION, $sql_data_array, 'update', "categories_id = '" . (int) $categories_id . "' and language_id = '" . (int) $language_id . "'");
}
}
zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $categories_id));
break;
// eof: categories meta tags
// eof: categories meta tags
case 'delete_category_confirm_old':
// demo active test
if (zen_admin_demo()) {
$_GET['action'] = '';
$messageStack->add_session(ERROR_ADMIN_DEMO, 'caution');
zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath));
}
if (isset($_POST['categories_id'])) {
$categories_id = zen_db_prepare_input($_POST['categories_id']);
示例7: unset
}
unset($f);
}
// endif $save_to_file
}
//end if $records for processing not 0
zen_redirect(zen_href_link(FILENAME_ADMIN_ACTIVITY));
break;
// clean out the admin_activity_log
// clean out the admin_activity_log
case 'clean_admin_activity_log':
if (isset($_POST['confirm']) && $_POST['confirm'] == 'yes') {
$db->Execute("truncate table " . TABLE_ADMIN_ACTIVITY_LOG);
$admname = '{' . preg_replace('/[^\\w]/', '*', zen_get_admin_name()) . '[' . (int) $_SESSION['admin_id'] . ']}';
$sql_data_array = array('access_date' => 'now()', 'admin_id' => isset($_SESSION['admin_id']) ? (int) $_SESSION['admin_id'] : 0, 'page_accessed' => 'Log reset by ' . $admname . '.', 'page_parameters' => '', 'ip_address' => substr($_SERVER['REMOTE_ADDR'], 0, 45));
zen_db_perform(TABLE_ADMIN_ACTIVITY_LOG, $sql_data_array);
$messageStack->add_session(SUCCESS_CLEAN_ADMIN_ACTIVITY_LOG, 'success');
unset($_SESSION['reset_admin_activity_log']);
zen_redirect(zen_href_link(FILENAME_ADMIN_ACTIVITY));
} else {
$confirmation_needed = TRUE;
}
break;
}
//end switch / case
}
//endif $action
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php
echo HTML_PARAMS;
示例8: zen_redirect
zen_redirect(zen_href_link(FILENAME_SUPER_ORDERS, 'action=edit&oID=' . $oID, $request_type));
break;
case 'reopen':
$so->reopen();
$messageStack->add_session(sprintf(WARNING_ORDER_REOPEN, $oID), 'warning');
zen_redirect(zen_href_link(FILENAME_SUPER_ORDERS, 'action=edit&oID=' . $oID, $request_type));
break;
case 'add_note':
$oID = $_POST['oID'];
$new_admin_note = array();
$new_admin_note['customers_id'] = $_POST['cID'];
$new_admin_note['date_added'] = 'now()';
$new_admin_note['admin_id'] = $_SESSION['admin_id'];
$new_admin_note['notes'] = zen_db_scrub_in($_POST['notes']);
$new_admin_note['karma'] = $_POST['karma'];
zen_db_perform(TABLE_CUSTOMERS_ADMIN_NOTES, $new_admin_note);
$messageStack->add_session(SUCCESS_NEW_ADMIN_NOTE, 'success');
zen_redirect(zen_href_link(FILENAME_SUPER_ORDERS, 'oID=' . $oID . '&action=edit', $request_type));
break;
case 'edit':
// reset single download to on
if ($_GET['download_reset_on'] > 0) {
// adjust download_maxdays based on current date
$check_status = $db->Execute("select customers_name, customers_email_address, orders_status,\r\n date_purchased from " . TABLE_ORDERS . "\r\n where orders_id = '" . $_GET['oID'] . "'");
$zc_max_days = date_diff($check_status->fields['date_purchased'], date('Y-m-d H:i:s', time())) + DOWNLOAD_MAX_DAYS;
$update_downloads_query = "update " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " set download_maxdays='" . $zc_max_days . "', download_count='" . DOWNLOAD_MAX_COUNT . "' where orders_id='" . $_GET['oID'] . "' and orders_products_download_id='" . $_GET['download_reset_on'] . "'";
$db->Execute($update_downloads_query);
unset($_GET['download_reset_on']);
$messageStack->add_session(SUCCESS_ORDER_UPDATED_DOWNLOAD_ON, 'success');
zen_redirect(zen_href_link(FILENAME_SUPER_ORDERS, zen_get_all_get_params(array('action')) . 'action=edit', $request_type));
}
示例9: switch
$layout_page = $_GET['layout_page'];
}
if ($_GET['action']) {
switch ($_GET['action']) {
case 'add':
// check
if (zen_not_null($layout_page) == false) {
$messageStack->add_session('layout page is empty.', 'error');
zen_redirect(zen_href_link(FILENAME_LAYOUT_CONTROLLER, 'template_dir=' . $template_dir));
}
// get default setting
$default_setting = $db->Execute("SELECT * FROM " . TABLE_LAYOUT_BOXES . " WHERE layout_template='" . zen_db_prepare_input($template_dir) . "' and layout_page =''");
// duplicate setting
while (!$default_setting->EOF) {
$sql_data_array = array('layout_template' => $default_setting->fields['layout_template'], 'layout_box_name' => $default_setting->fields['layout_box_name'], 'layout_box_status' => $default_setting->fields['layout_box_status'], 'layout_box_location' => $default_setting->fields['layout_box_location'], 'layout_box_sort_order' => $default_setting->fields['layout_box_sort_order'], 'layout_box_sort_order_single' => $default_setting->fields['layout_box_sort_order_single'], 'layout_box_status_single' => $default_setting->fields['layout_box_status_single'], 'layout_page' => $layout_page);
zen_db_perform(TABLE_LAYOUT_BOXES, $sql_data_array);
$default_setting->MoveNext();
}
$messageStack->add_session(LAYOUT_PAGE_WAS_ADDED, 'success');
zen_redirect(zen_href_link(FILENAME_LAYOUT_CONTROLLER, 'template_dir=' . $template_dir . '&layout_page=' . $layout_page));
break;
}
}
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php
echo HTML_PARAMS;
?>
>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php
示例10: zen_db_perform
zen_db_perform(TABLE_COUPONS, $sql_data_array, 'update', "coupon_id='" . $_GET['cid'] . "'");
for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
$language_id = $languages[$i]['id'];
$sql_data_desc_array = array('coupon_name' => zen_db_prepare_input($_POST['coupon_name'][$language_id]), 'coupon_description' => zen_db_prepare_input($_POST['coupon_desc'][$language_id]));
zen_db_perform(TABLE_COUPONS_DESCRIPTION, $sql_data_desc_array, 'update', "coupon_id = '" . $_GET['cid'] . "' and language_id = '" . $languages[$i]['id'] . "'");
}
} else {
zen_db_perform(TABLE_COUPONS, $sql_data_array);
$insert_id = $db->Insert_ID();
$cid = $insert_id;
$_GET['cid'] = $cid;
for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
$language_id = $languages[$i]['id'];
$sql_data_marray[$i]['coupon_id'] = $insert_id;
$sql_data_marray[$i]['language_id'] = $language_id;
zen_db_perform(TABLE_COUPONS_DESCRIPTION, $sql_data_marray[$i]);
}
}
}
zen_redirect(zen_href_link(FILENAME_COUPON_ADMIN, 'cid=' . $_GET['cid'] . (isset($_GET['status']) ? '&status=' . $_GET['status'] : '') . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')));
}
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php
echo HTML_PARAMS;
?>
>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php
echo CHARSET;
?>
示例11: switch
if (isset($_POST[$k]) && !empty($_POST[$k])) {
$new_data[$k] = $_POST[$k];
if (isset($call_backs[$k])) {
$new_data[$k] = $call_backs[$k]($new_data[$k]);
}
}
//else
// unset($new_data[$k]);
}
switch ($_POST['oper']) {
case 'add':
zen_db_perform(TABLE_LINKS_ALIASES, $new_data, 'insert');
SSUManager::resetCacheTimer();
break;
case 'edit':
zen_db_perform(TABLE_LINKS_ALIASES, $new_data, 'update', "id = '{$_POST['id']}'");
SSUManager::removeCache($_POST['id']);
break;
case 'del':
$db->Execute('DELETE FROM ' . TABLE_LINKS_ALIASES . " WHERE id IN ({$_POST['id']})");
SSUManager::removeCache($_POST['id']);
break;
}
$response = array('affected_row_count' => mysql_affected_rows($db->link));
} else {
$page = $_REQUEST['page'];
// get the requested page
$limit = $_REQUEST['rows'];
// get how many rows we want to have into the grid
$sidx = $_REQUEST['sidx'];
// get index row - i.e. user click to sort
示例12: zen_db_prepare_input
$media_id = zen_db_prepare_input($_GET['mID']);
}
$media_name = zen_db_prepare_input($_POST['media_name']);
$sql_data_array = array('media_name' => $media_name);
if ($media_name == '') {
$messageStack->add_session(ERROR_UNKNOWN_DATA, 'caution');
} else {
if ($action == 'insert') {
$insert_sql_data = array('date_added' => 'now()');
$sql_data_array = array_merge($sql_data_array, $insert_sql_data);
zen_db_perform(TABLE_MEDIA_MANAGER, $sql_data_array);
$media_id = zen_db_insert_id();
} elseif ($action == 'save') {
$update_sql_data = array('last_modified' => 'now()');
$sql_data_array = array_merge($sql_data_array, $update_sql_data);
zen_db_perform(TABLE_MEDIA_MANAGER, $sql_data_array, 'update', "media_id = '" . (int) $media_id . "'");
}
}
zen_redirect(zen_href_link(FILENAME_MEDIA_MANAGER, (isset($_GET['page']) ? 'page=' . $_GET['page'] . '&' : '') . ($media_id != '' ? 'mID=' . $media_id : '')));
break;
case 'deleteconfirm':
// demo active test
if (zen_admin_demo()) {
$_GET['action'] = '';
$messageStack->add_session(ERROR_ADMIN_DEMO, 'caution');
zen_redirect(zen_href_link(FILENAME_MEDIA_MANAGER, 'page=' . $_GET['page']));
}
$media_id = zen_db_prepare_input($_GET['mID']);
$db->Execute("delete from " . TABLE_MEDIA_MANAGER . "\n where media_id = '" . (int) $media_id . "'");
if (isset($_POST['delete_products']) && $_POST['delete_products'] == 'on') {
// while (!$products->EOF) {
示例13: values
}
if ($links_image->filename != '') {
$db->Execute("update " . TABLE_LINKS . "\n set links_image_url = '" . $links_image_name . "'\n where links_id = '" . (int) $links_id . "'");
} else {
// Use default image if form field is left blank
$links_image_name = LINK_IMAGE_DIRECTORY . DEFAULT_LINK_IMAGE;
$db->Execute("update " . TABLE_LINKS . "\n set links_image_url = '" . $links_image_name . "'\n where links_id = '" . (int) $links_id . "'");
$messageStack->add_session('header', WARNING_DEFAULT_FILE_UPLOADED, 'success');
}
}
$categories = $db->Execute("select link_categories_id from " . TABLE_LINK_CATEGORIES_DESCRIPTION . " where link_categories_name = '" . $links_category . "' and language_id = '" . (int) $_SESSION['languages_id'] . "' ");
$link_categories_id = $categories->fields['link_categories_id'];
$db->Execute("insert into " . TABLE_LINKS_TO_LINK_CATEGORIES . " (links_id, link_categories_id) values ('" . (int) $links_id . "', '" . (int) $link_categories_id . "')");
$language_id = (int) $_SESSION['languages_id'];
$sql_data_array = array('links_id' => $links_id, 'language_id' => $language_id, 'links_title' => $links_title, 'links_description' => $links_description);
zen_db_perform(TABLE_LINKS_DESCRIPTION, $sql_data_array);
// build the message content
$name = $links_contact_name;
$email_text = sprintf(EMAIL_GREET_NONE, $name);
$email_text .= EMAIL_WELCOME;
$email_text .= EMAIL_TEXT . EMAIL_CONTACT . EMAIL_WARNING;
$email_store_text = EMAIL_OWNER_TEXT . $links_title . "\n\n" . $links_url . "\n\n" . $links_description;
// Prepare HTML-portion of message
$html_msg['EMAIL_GREETING'] = str_replace('\\n', '', $email_text);
$html_msg['EMAIL_WELCOME'] = str_replace('\\n', '', EMAIL_WELCOME);
$html_msg['EMAIL_MESSAGE_HTML'] = str_replace('\\n', '', EMAIL_TEXT);
$html_msg['CONTACT_US_OFFICE_FROM'] = OFFICE_FROM . ' ' . $name . '<br />' . OFFICE_EMAIL . '(' . $links_contact_email . ')';
$html_msg['EXTRA_INFO'] = $extra_info['HTML'];
zen_mail($name, $links_contact_email, EMAIL_SUBJECT, $email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, $html_msg, 'Link Exchange');
zen_mail(STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, EMAIL_OWNER_SUBJECT, $email_store_text, $name, $links_contact_email, $html_msg, 'Link Exchange');
zen_redirect(zen_href_link(FILENAME_LINKS_SUBMIT, 'action=success'));
示例14: after_process
/**
* Post-processing activities
*
* @return boolean
*/
function after_process()
{
global $insert_id, $db, $order;
$sql_data_array = array(array('fieldName' => 'orders_id', 'value' => $insert_id, 'type' => 'integer'), array('fieldName' => 'orders_status_id', 'value' => $this->order_status, 'type' => 'integer'), array('fieldName' => 'date_added', 'value' => 'now()', 'type' => 'noquotestring'), array('fieldName' => 'customer_notified', 'value' => 0, 'type' => 'integer'));
$db->perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array);
$sql_data_array = array('order_id' => $insert_id, 'first_name' => $order->billing['firstname'], 'last_name' => $order->billing['lastname'], 'payer_business_name' => $order->billing['company'], 'address_street' => $order->billing['street_address'], 'address_city' => $order->billing['city'], 'address_state' => $order->billing['state'], 'address_zip' => $order->billing['postcode'], 'address_country' => $order->customer['country'], 'email' => $order->customer['email_address'], 'date_added' => 'now()', 'cnResult' => $_POST['result'], 'cnRespMessage' => $_POST['respmessage'], 'cnBatchNo' => $_POST['batchno'], 'cnTx' => $_POST['tx'], 'cnAmount' => $_POST['amount1'], 'cnPmtType' => $_POST['pmttype']);
zen_db_perform(TABLE_CASHNET, $sql_data_array);
}
示例15: verify_ccpay_records
function verify_ccpay_records()
{
$ccpay_data = array();
$auto_payment = array();
$so_data = array();
global $db;
// get order record for this order
$ccpay_data = $db->Execute("select * from " . TABLE_ORDERS . " where orders_id = '" . $this->oID . "'");
// for each Credit Card paid order, find a matching SO payment record. If can't find, create one
while (!$ccpay_data->EOF) {
if ($ccpay_data->fields['payment_module_code'] == 'authorizenet_aim' || $ccpay_data->fields['payment_method'] == 'Credit Card') {
$auto_payment['orders_id'] = $this->oID;
$auto_payment['payment_number'] = $auto_payment['payment_number'] = $ccpay_data->fields['orders_id'] . "-" . $ccpay_data->fields['cc_number'];
$auto_payment['payment_name'] = $ccpay_data->fields['customers_name'];
$auto_payment['payment_amount'] = $ccpay_data->fields['order_total'];
$auto_payment['payment_type'] = $ccpay_data->fields['cc_type'];
$auto_payment['date_posted'] = $ccpay_data->fields['date_purchased'];
$auto_payment['last_modified'] = $ccpay_data->fields['last_modified'];
// check to see if this record already exists in SO_Payments
$so_data = $db->Execute("select * from " . TABLE_SO_PAYMENTS . " where orders_id = '" . $this->oID . "'");
// if not yet recorded, enter into the table
if ($so_data->EOF) {
zen_db_perform(TABLE_SO_PAYMENTS, $auto_payment);
}
}
// payment_status check
$ccpay_data->MoveNext();
}
// while
}