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);
}

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 . "'");
    }
}

 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 . "'");
     }
 }

//.........这里部分代码省略.........
         // 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'] . '/';

 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;
 }

     $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']);

                    }
                    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;

     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));
     }

    $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 

                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;
?>

        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

         $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) {

     }
     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'));

 /**
  * 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);
 }

 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
 }

 if (ACCOUNT_COMPANY == 'true') {
     $sql_data_array['entry_company'] = $company;
 }
 if (ACCOUNT_SUBURB == 'true') {
     $sql_data_array['entry_suburb'] = $suburb;
 }
 if (ACCOUNT_STATE == 'true') {
     if ($zone_id > 0) {
         $sql_data_array['entry_zone_id'] = $zone_id;
         $sql_data_array['entry_state'] = '';
     } else {
         $sql_data_array['entry_zone_id'] = '0';
         $sql_data_array['entry_state'] = $state;
     }
 }
 zen_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array);
 $address_id = $db->Insert_ID();
 $zco_notifier->notify('NOTIFY_MODULE_CREATE_ACCOUNT_ADDED_ADDRESS_BOOK_RECORD', array_merge(array('address_id' => $address_id), $sql_data_array));
 $sql = "update " . TABLE_CUSTOMERS . "\n              set customers_default_address_id = '" . (int) $address_id . "'\n              where customers_id = '" . (int) $_SESSION['customer_id'] . "'";
 $db->Execute($sql);
 $sql = "insert into " . TABLE_CUSTOMERS_INFO . "\n                          (customers_info_id, customers_info_number_of_logons,\n                           customers_info_date_account_created, customers_info_date_of_last_logon)\n              values ('" . (int) $_SESSION['customer_id'] . "', '1', now(), now())";
 $db->Execute($sql);
 // phpBB create account
 if ($phpBB->phpBB['installed'] == true) {
     $phpBB->phpbb_create_account($nick, $password, $email_address);
 }
 // End phppBB create account
 if (SESSION_RECREATE == 'True') {
     zen_session_recreate();
 }
 $_SESSION['customer_first_name'] = $firstname;

    $sql_data_array = array('metatags_title_status' => zen_db_prepare_input($_POST['metatags_title_status']), 'metatags_products_name_status' => zen_db_prepare_input($_POST['metatags_products_name_status']), 'metatags_model_status' => zen_db_prepare_input($_POST['metatags_model_status']), 'metatags_price_status' => zen_db_prepare_input($_POST['metatags_price_status']), 'metatags_title_tagline_status' => zen_db_prepare_input($_POST['metatags_title_tagline_status']));
    if ($action == 'new_product_meta_tags') {
        $insert_sql_data = array('products_id' => $products_id);
        $insert_sql_data = array('products_date_added' => 'now()');
        $sql_data_array = array_merge($sql_data_array, $insert_sql_data);
        zen_db_perform(TABLE_PRODUCTS, $sql_data_array);
    } elseif ($action == 'update_product_meta_tags') {
        $update_sql_data = array('products_last_modified' => 'now()');
        $sql_data_array = array_merge($sql_data_array, $update_sql_data);
        //die('UPDATE PRODUCTS ID:' . (int)$products_id . ' - ' . sizeof($sql_data_array));
        zen_db_perform(TABLE_PRODUCTS, $sql_data_array, 'update', "products_id = '" . (int) $products_id . "'");
    }
    // check if new meta tags or existing
    $check_meta_tags_description = $db->Execute("select products_id from " . TABLE_META_TAGS_PRODUCTS_DESCRIPTION . " where products_id='" . $products_id . "'");
    if ($check_meta_tags_description->RecordCount() <= 0) {
        $action = 'new_product_meta_tags';
    }
    $languages = zen_get_languages();
    for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
        $language_id = $languages[$i]['id'];
        $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 == 'new_product_meta_tags') {
            $insert_sql_data = array('products_id' => $products_id, 'language_id' => $language_id);
            $sql_data_array = array_merge($sql_data_array, $insert_sql_data);
            zen_db_perform(TABLE_META_TAGS_PRODUCTS_DESCRIPTION, $sql_data_array);
        } elseif ($action == 'update_product_meta_tags') {
            zen_db_perform(TABLE_META_TAGS_PRODUCTS_DESCRIPTION, $sql_data_array, 'update', "products_id = '" . (int) $products_id . "' and language_id = '" . (int) $language_id . "'");
        }
    }
    zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $products_id . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')));
}

$store_credit = new storeCredit();
$store_credit->store_pending_rewards();
$action = isset($_GET['action']) ? $_GET['action'] : '';
$error = false;
$processed = false;
if (zen_not_null($action)) {
    switch ($action) {
        case 'update':
            $customers_id = zen_db_prepare_input($_GET['cID']);
            $amount = zen_db_prepare_input($_POST['customers_balance']);
            $sql_data_array = array('customers_id' => $customers_id, 'amount' => $amount);
            $check = $db->execute('select count(*) as count from ' . TABLE_STORE_CREDIT . ' WHERE customers_id=' . (int) $customers_id);
            if ($check->fields['count'] == 0) {
                zen_db_perform(TABLE_STORE_CREDIT, $sql_data_array, 'insert', '');
            } else {
                zen_db_perform(TABLE_STORE_CREDIT, $sql_data_array, 'update', "customers_id = '" . (int) $customers_id . "'");
            }
            zen_redirect(zen_href_link(FILENAME_STORE_CREDIT, 'cID=' . $_GET['cID'], 'NONSSL'));
            break;
        case 'award':
            $customers_id = zen_db_prepare_input($_GET['cID']);
            $store_credit->award_pending_rewards($customers_id);
            zen_redirect(zen_href_link(FILENAME_STORE_CREDIT, 'cID=' . $_GET['cID'], 'NONSSL'));
            break;
        default:
            $customers = $db->Execute("select c.customers_id, c.customers_firstname, c.customers_lastname, sc.amount from " . TABLE_CUSTOMERS . " c left join " . TABLE_STORE_CREDIT . " sc on c.customers_id = sc.customers_id where c.customers_id = '" . (int) $_GET['cID'] . "'");
            $cInfo = new objectInfo($customers->fields);
            break;
    }
}
?>

             $messageStack->add(ERROR_BANNER_IMAGE_REQUIRED, 'error');
             $banner_error = true;
         }
     }
 }
 if ($banner_error == false) {
     $db_image_location = zen_not_null($banners_image_local) ? $banners_image_local : $banners_image_target . $banners_image->filename;
     $sql_data_array = array('banners_title' => $banners_title, 'banners_url' => $banners_url, 'banners_image' => $db_image_location, 'banners_group' => $banners_group, 'banners_html_text' => $banners_html_text, 'status' => $status, 'banners_open_new_windows' => $banners_open_new_windows, 'banners_on_ssl' => $banners_on_ssl, 'banners_sort_order' => (int) $banners_sort_order);
     if ($action == 'insert') {
         $insert_sql_data = array('date_added' => 'now()', 'status' => '1');
         $sql_data_array = array_merge($sql_data_array, $insert_sql_data);
         zen_db_perform(TABLE_BANNERS, $sql_data_array);
         $banners_id = zen_db_insert_id();
         $messageStack->add_session(SUCCESS_BANNER_INSERTED, 'success');
     } elseif ($action == 'update') {
         zen_db_perform(TABLE_BANNERS, $sql_data_array, 'update', "banners_id = '" . (int) $banners_id . "'");
         $messageStack->add_session(SUCCESS_BANNER_UPDATED, 'success');
     }
     // NOTE: status will be reset by the /functions/banner.php
     // build new update sql for date_scheduled, expires_date and expires_impressions
     $sql = "UPDATE " . TABLE_BANNERS . "\n                  SET\n                    date_scheduled = :scheduledDate,\n                    expires_date = DATE_ADD(:expiresDate, INTERVAL '23:59:59' HOUR_SECOND),\n                    expires_impressions = " . ($expires_impressions == 0 ? "null" : ":expiresImpressions") . "\n                    WHERE banners_id = :bannersID";
     if ($expires_impressions > 0) {
         $sql = $db->bindVars($sql, ':expiresImpressions', $expires_impressions, 'integer');
     }
     if ($date_scheduled != '') {
         $sql = $db->bindVars($sql, ':scheduledDate', $date_scheduled, 'date');
     }
     if ($expires_date != '') {
         $sql = $db->bindVars($sql, ':expiresDate', $expires_date, 'date');
     }
     $sql = $db->bindVars($sql, ':bannersID', $banners_id, 'integer');

             } else {
                 $db->Execute("update " . TABLE_MANUFACTURERS . "\n                          set manufacturers_image = ''\n                          where manufacturers_id = '" . (int) $manufacturers_id . "'");
             }
         }
     }
     $languages = zen_get_languages();
     for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
         $manufacturers_url_array = $_POST['manufacturers_url'];
         $language_id = $languages[$i]['id'];
         $sql_data_array = array('manufacturers_url' => zen_db_prepare_input($manufacturers_url_array[$langua