function updateBill($login, $password, $txn, $status) { //обработка возможных ошибок авторизации if ($login != MODULE_PAYMENT_QIWI_ID) { return 150; } if (!empty($password) && $password != strtoupper(md5($txn . strtoupper(md5(MODULE_PAYMENT_QIWI_SECRET_KEY))))) { return 150; } // получаем номер заказа $transaction = intval($txn); // проверяем, есть ли такой заказ в базе $order_query = vam_db_query("select count(*) as total from " . TABLE_ORDERS . " where orders_id = '" . (int) $transaction . "'"); $order_exists = vam_db_fetch_array($order_query); if ($order_exists['total'] <= 0) { return 210; } // меняем статус заказа при условии оплаты счёта if ($status == 60) { $sql_data_array = array('orders_status' => MODULE_PAYMENT_QIWI_ORDER_STATUS_ID); vam_db_perform('orders', $sql_data_array, 'update', "orders_id='" . $transaction . "'"); $sql_data_arrax = array('orders_id' => $transaction, 'orders_status_id' => MODULE_PAYMENT_QIWI_ORDER_STATUS_ID, 'date_added' => 'now()', 'customer_notified' => '0', 'comments' => 'QIWI accepted this order payment'); vam_db_perform('orders_status_history', $sql_data_arrax); // Отправляем письмо клиенту и админу о смене статуса заказа require_once DIR_WS_CLASSES . 'order.php'; $order = new order($transaction); $vamTemplate = new vamTemplate(); // assign language to template for caching $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->caching = false; $vamTemplate->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/'); $vamTemplate->assign('logo_path', HTTP_SERVER . DIR_WS_CATALOG . 'templates/' . CURRENT_TEMPLATE . '/img/'); $vamTemplate->assign('NAME', $order->customer['firstname'] . ' ' . $order->customer['lastname']); $vamTemplate->assign('ORDER_NR', $transaction); $vamTemplate->assign('ORDER_LINK', vam_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $transaction, 'SSL')); $vamTemplate->assign('ORDER_DATE', vam_date_long($order->info['date_purchased'])); $lang_query = vam_db_query("select languages_id from " . TABLE_LANGUAGES . " where directory = '" . $_SESSION['language'] . "'"); $lang = vam_db_fetch_array($lang_query); $lang = $lang['languages_id']; if (!isset($lang)) { $lang = $_SESSION['languages_id']; } $orders_status_array = array(); $orders_status_query = vam_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . $lang . "'"); while ($orders_status = vam_db_fetch_array($orders_status_query)) { $orders_statuses[] = array('id' => $orders_status['orders_status_id'], 'text' => $orders_status['orders_status_name']); $orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name']; } $vamTemplate->assign('ORDER_STATUS', $orders_status_array[MODULE_PAYMENT_QIWI_ORDER_STATUS_ID]); $html_mail = $vamTemplate->fetch(CURRENT_TEMPLATE . '/admin/mail/' . $_SESSION['language'] . '/change_order_mail.html'); $txt_mail = $vamTemplate->fetch(CURRENT_TEMPLATE . '/admin/mail/' . $_SESSION['language'] . '/change_order_mail.txt'); include_once DIR_WS_LANGUAGES . $_SESSION['language'] . '/modules/payment/qiwi.php'; // create subject $order_subject = str_replace('{$nr}', $transaction, MODULE_PAYMENT_QIWI_EMAIL_SUBJECT); // send mail to admin vam_php_mail(EMAIL_BILLING_ADDRESS, EMAIL_BILLING_NAME, EMAIL_BILLING_ADDRESS, STORE_NAME, EMAIL_BILLING_FORWARDING_STRING, $order->customer['email_address'], $order->customer['firstname'], '', '', $order_subject, $html_mail, $txt_mail); // send mail to customer vam_php_mail(EMAIL_BILLING_ADDRESS, EMAIL_BILLING_NAME, $order->customer['email_address'], $order->customer['firstname'] . ' ' . $order->customer['lastname'], '', EMAIL_BILLING_REPLY_ADDRESS, EMAIL_BILLING_REPLY_ADDRESS_NAME, '', '', $order_subject, $html_mail, $txt_mail); } }
<?php // create conteiner for tops boxes , wich loaded by ajax $box = new vamTemplate(); $box_content = ''; $flag = ''; $box->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/'); //$box_content = ; if ($flag == true) { define('SEARCH_ENGINE_FRIENDLY_URLS', true); } $box->assign('BOX_CONTENT', $box_content); $box->caching = 0; $box->assign('language', $_SESSION['language']); $box_admin = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_tops.html'); $vamTemplate->assign('box_TOPS', $box_admin);
$vamTemplate->assign('LINK_sort_name_desc', vam_href_link(basename($PHP_SELF), vam_get_all_get_params(array('page', 'sort', 'direction', 'info', 'x', 'y')) . 'sort=name&direction=desc')); $vamTemplate->assign('LINK_sort_price_asc', vam_href_link(basename($PHP_SELF), vam_get_all_get_params(array('page', 'sort', 'direction', 'info', 'x', 'y')) . 'sort=price&direction=asc')); $vamTemplate->assign('LINK_sort_price_desc', vam_href_link(basename($PHP_SELF), vam_get_all_get_params(array('page', 'sort', 'direction', 'info', 'x', 'y')) . 'sort=price&direction=desc')); /* /sort, on page */ $vamTemplate->assign('section', 'featured'); $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->assign('module_content', $module_content); $vamTemplate->caching = 0; //switch display mode $listing_template = 'product_tops_list.html'; if (isset($_SESSION['listing_tops_template'])) { $listing_template = $_SESSION['listing_tops_template']; } if ($listing_template == 'product_tops_list.html') { $vamTemplate->assign('LISTING_TEMPLATE', 'product_tops_columns.html'); $vamTemplate->assign('LISTING_TEMPLATE_TEXT', 'плиткой'); } else { $vamTemplate->assign('LISTING_TEMPLATE', 'product_tops_list.html'); $vamTemplate->assign('LISTING_TEMPLATE_TEXT', 'списком'); } $main_content = $vamTemplate->fetch(CURRENT_TEMPLATE . '/module/product_listing/' . $listing_template); $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->assign('main_content', $main_content); $vamTemplate->caching = 0; if (!defined(RM)) { $vamTemplate->load_filter('output', 'note'); } $template = file_exists('templates/' . CURRENT_TEMPLATE . '/' . FILENAME_FEATURED . '.html') ? CURRENT_TEMPLATE . '/' . FILENAME_FEATURED . '.html' : CURRENT_TEMPLATE . '/index.html'; $vamTemplate->assign('category_depth', true); $vamTemplate->display($template); include 'includes/application_bottom.php';
osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 - 2003 osCommerce Released under the GNU General Public License ---------------------------------------------------------------------------*/ $box = new vamTemplate(); $box_content = ''; $box->assign('tpl_path', DIR_WS_CATALOG . 'templates/' . CURRENT_TEMPLATE . '/'); if (isset($_SESSION['affiliate_id'])) { $box_content .= '<li><a href="' . vam_href_link(FILENAME_AFFILIATE_SUMMARY, '', 'SSL') . '">' . BOX_AFFILIATE_SUMMARY . '</a></li>'; $box_content .= '<li><a href="' . vam_href_link(FILENAME_AFFILIATE_ACCOUNT, '', 'SSL') . '">' . BOX_AFFILIATE_ACCOUNT . '</a></li>'; $box_content .= '<li><a href="' . vam_href_link(FILENAME_AFFILIATE_PAYMENT, '', 'SSL') . '">' . BOX_AFFILIATE_PAYMENT . '</a></li>'; $box_content .= '<li><a href="' . vam_href_link(FILENAME_AFFILIATE_CLICKS, '', 'SSL') . '">' . BOX_AFFILIATE_CLICKRATE . '</a></li>'; $box_content .= '<li><a href="' . vam_href_link(FILENAME_AFFILIATE_SALES, '', 'SSL') . '">' . BOX_AFFILIATE_SALES . '</a></li>'; $box_content .= '<li><a href="' . vam_href_link(FILENAME_AFFILIATE_BANNERS) . '">' . BOX_AFFILIATE_BANNERS . '</a></li>'; $box_content .= '<li><a href="' . vam_href_link(FILENAME_AFFILIATE_CONTACT) . '">' . BOX_AFFILIATE_CONTACT . '</a></li>'; $box_content .= '<li><a href="' . vam_href_link(FILENAME_CONTENT, 'coID=11') . '">' . BOX_AFFILIATE_FAQ . '</a></li>'; $box_content .= '<li><a href="' . vam_href_link(FILENAME_AFFILIATE_LOGOUT) . '">' . BOX_AFFILIATE_LOGOUT . '</a></li>'; } else { $box_content .= '<li><a href="' . vam_href_link(FILENAME_CONTENT, 'coID=10') . '">' . BOX_AFFILIATE_INFO . '</a></li>'; $box_content .= '<li><a href="' . vam_href_link(FILENAME_AFFILIATE, '', 'SSL') . '">' . BOX_AFFILIATE_LOGIN . '</a></li>'; } //$box->assign('BOX_TITLE', BOX_HEADING_ADD_PRODUCT_ID); $box->assign('BOX_CONTENT', $box_content); $box->assign('language', $_SESSION['language']); // set cache ID $box->caching = 0; $box_affiliate = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_affiliate.html'); $vamTemplate->assign('box_AFFILIATE', $box_affiliate);
if (isset($_GET['action']) && $_GET['action'] == 'first_opt_in') { $check_customer_query = vam_db_query("select customers_email_address, customers_id from " . TABLE_CUSTOMERS . " where customers_email_address = '" . vam_db_input($_POST['email']) . "'"); $check_customer = vam_db_fetch_array($check_customer_query); $vlcode = vam_random_charcode(32); $link = vam_href_link(FILENAME_PASSWORD_DOUBLE_OPT, 'action=verified&customers_id=' . $check_customer['customers_id'] . '&key=' . $vlcode, 'NONSSL'); // assign language to template for caching $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/'); $vamTemplate->assign('logo_path', HTTP_SERVER . DIR_WS_CATALOG . 'templates/' . CURRENT_TEMPLATE . '/img/'); // assign vars $vamTemplate->assign('EMAIL', $check_customer['customers_email_address']); $vamTemplate->assign('LINK', $link); // dont allow cache $vamTemplate->caching = false; // create mails $html_mail = $vamTemplate->fetch(CURRENT_TEMPLATE . '/mail/' . $_SESSION['language'] . '/password_verification_mail.html'); $txt_mail = $vamTemplate->fetch(CURRENT_TEMPLATE . '/mail/' . $_SESSION['language'] . '/password_verification_mail.txt'); if ($_POST['captcha'] == $_SESSION['vvcode']) { if (!vam_db_num_rows($check_customer_query)) { $case = wrong_mail; $info_message = TEXT_EMAIL_ERROR; } else { $case = first_opt_in; vam_db_query("update " . TABLE_CUSTOMERS . " set password_request_key = '" . $vlcode . "' where customers_id = '" . $check_customer['customers_id'] . "'"); vam_php_mail(EMAIL_SUPPORT_ADDRESS, EMAIL_SUPPORT_NAME, $check_customer['customers_email_address'], '', '', EMAIL_SUPPORT_REPLY_ADDRESS, EMAIL_SUPPORT_REPLY_ADDRESS_NAME, '', '', TEXT_EMAIL_PASSWORD_FORGOTTEN, $html_mail, $txt_mail); } } else { $case = code_error; $info_message = TEXT_CODE_ERROR; } }
Contribution based on: osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 - 2003 osCommerce Released under the GNU General Public License ---------------------------------------------------------------------------*/ require 'includes/application_top.php'; // include needed functions require_once DIR_FS_INC . 'vam_image_button.inc.php'; // create smarty elements $vamTemplate = new vamTemplate(); // include boxes require DIR_FS_CATALOG . 'templates/' . CURRENT_TEMPLATE . '/source/boxes.php'; $breadcrumb->add(NAVBAR_TITLE, vam_href_link(FILENAME_AFFILIATE, '', 'SSL')); $breadcrumb->add(NAVBAR_TITLE_SIGNUP_OK); require DIR_WS_INCLUDES . 'header.php'; $vamTemplate->assign('LINK_SUMMARY', '<a class="button" href="' . vam_href_link(FILENAME_AFFILIATE_SUMMARY, '', 'SSL') . '">' . vam_image_button('submit.png', IMAGE_BUTTON_CONTINUE) . '</a>'); $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->caching = 0; $main_content = $vamTemplate->fetch(CURRENT_TEMPLATE . '/module/affiliate_signup_ok.html'); $vamTemplate->assign('main_content', $main_content); $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->caching = 0; if (!defined(RM)) { $vamTemplate->load_filter('output', 'note'); } $vamTemplate->display(CURRENT_TEMPLATE . '/index.html');
if ($_SESSION['customers_status']['customers_status_max_order'] != 0) { if ($total > $_SESSION['customers_status']['customers_status_max_order']) { $_SESSION['allow_checkout'] = 'false'; $less_to_buy = $total - $_SESSION['customers_status']['customers_status_max_order']; $max_order = $vamPrice->Format($_SESSION['customers_status']['customers_status_max_order'], true); $order_amount = $vamPrice->Format($less_to_buy, true); $vamTemplate->assign('info_message_1', MAXIMUM_ORDER_VALUE_REACHED_1); $vamTemplate->assign('info_message_2', MAXIMUM_ORDER_VALUE_REACHED_2); $vamTemplate->assign('order_amount', $order_amount); $vamTemplate->assign('min_order', $max_order); } } } if ($_GET['info_message']) { $vamTemplate->assign('info_message', str_replace('+', ' ', htmlspecialchars($_GET['info_message']))); } $vamTemplate->assign('BUTTON_RELOAD', vam_image_submit('update.png', IMAGE_BUTTON_UPDATE_CART)); $vamTemplate->assign('BUTTON_CHECKOUT', '<a class="button" href="' . vam_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL') . '">' . vam_image_button('', IMAGE_BUTTON_CHECKOUT) . '</a>'); } else { // empty cart $cart_empty = true; if ($_GET['info_message']) { $vamTemplate->assign('info_message', str_replace('+', ' ', htmlspecialchars($_GET['info_message']))); } $vamTemplate->assign('cart_empty', $cart_empty); $vamTemplate->assign('BUTTON_CONTINUE', '<a class="button close" href="javascript:void(0);">' . vam_image_button('', IMAGE_BUTTON_CONTINUE) . '</a>'); } $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->caching = 0; echo $vamTemplate->fetch(CURRENT_TEMPLATE . '/module/shopping_cart.html');
unset($_SESSION['affiliate_id']); if (isset($_SESSION['affiliate_id'])) { $result = 0; } else { $result = 1; } //session_destroy(); if (!empty($old_user)) { if ($result) { // if they were logged in and are not logged out $info = 0; } else { // they were logged in and could not be logged out $info = 1; } } else { // if they weren't logged in but came to this page somehow $info = 2; } $vamTemplate->assign('info', $info); $vamTemplate->assign('LINK_DEFAULT', '<a class="button" href="' . vam_href_link(FILENAME_DEFAULT) . '">' . vam_image_button('submit.png', IMAGE_BUTTON_CONTINUE) . '</a>'); $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->caching = 0; $main_content = $vamTemplate->fetch(CURRENT_TEMPLATE . '/module/affiliate_logout.html'); $vamTemplate->assign('main_content', $main_content); $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->caching = 0; if (!defined(RM)) { $vamTemplate->load_filter('output', 'note'); } $vamTemplate->display(CURRENT_TEMPLATE . '/index.html');
while ($history = vam_db_fetch_array($history_query)) { $products_query = vam_db_query("select count(*) as count from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . $history['orders_id'] . "'"); $products = vam_db_fetch_array($products_query); if (vam_not_null($history['delivery_name'])) { $order_type = TEXT_ORDER_SHIPPED_TO; $order_name = $history['delivery_name']; } else { $order_type = TEXT_ORDER_BILLED_TO; $order_name = $history['billing_name']; } $module_content[] = array('ORDER_ID' => $history['orders_id'], 'ORDER_STATUS' => $history['orders_status_name'], 'ORDER_DATE' => vam_date_long($history['date_purchased']), 'ORDER_PRODUCTS' => $products['count'], 'ORDER_TOTAL' => strip_tags($history['order_total']), 'ORDER_BUTTON' => '<a class="button" href="' . vam_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'page=' . (empty($_GET['page']) ? "1" : (int) $_GET['page']) . '&order_id=' . $history['orders_id'], 'SSL') . '">' . vam_image_button('view.png', SMALL_IMAGE_BUTTON_VIEW) . '</a>'); } } if ($orders_total > 0) { $vamTemplate->assign('SPLIT_BAR', TEXT_RESULT_PAGE . ' ' . $history_split->display_links(MAX_DISPLAY_PAGE_LINKS, vam_get_all_get_params(array('page', 'info', 'x', 'y')))); $vamTemplate->assign('SPLIT_BAR_PAGES', $history_split->display_count(TEXT_DISPLAY_NUMBER_OF_ORDERS)); } $vamTemplate->assign('order_content', $module_content); $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->assign('BUTTON_BACK', '<a class="button" href="' . vam_href_link(FILENAME_ACCOUNT, '', 'SSL') . '">' . vam_image_button('back.png', IMAGE_BUTTON_BACK) . '</a>'); $vamTemplate->caching = 0; $main_content = $vamTemplate->fetch(CURRENT_TEMPLATE . '/module/account_history.html'); $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->assign('main_content', $main_content); $vamTemplate->caching = 0; if (!defined(RM)) { $vamTemplate->load_filter('output', 'note'); } $template = file_exists('templates/' . CURRENT_TEMPLATE . '/' . FILENAME_ACCOUNT_HISTORY . '.html') ? CURRENT_TEMPLATE . '/' . FILENAME_ACCOUNT_HISTORY . '.html' : CURRENT_TEMPLATE . '/index.html'; $vamTemplate->display($template); include 'includes/application_bottom.php';
$gv_query = vam_db_query("insert into " . TABLE_COUPONS . " (coupon_type, coupon_code, date_created, coupon_amount) values ('G', '" . $id1 . "', NOW(), '" . str_replace(",", ".", vam_db_input($vamPrice->CalculateCurrEx($_POST['amount'], DEFAULT_CURRENCY))) . "')"); $insert_id = vam_db_insert_id($gv_query); $gv_query = vam_db_query("insert into " . TABLE_COUPON_EMAIL_TRACK . " (coupon_id, customer_id_sent, sent_firstname, sent_lastname, emailed_to, date_sent) values ('" . $insert_id . "' ,'" . $_SESSION['customer_id'] . "', '" . addslashes($gv_customer['customers_firstname']) . "', '" . addslashes($gv_customer['customers_lastname']) . "', '" . vam_db_input($_POST['email']) . "', now())"); $gv_email_subject = sprintf(EMAIL_GV_TEXT_SUBJECT, stripslashes($_POST['send_name'])); $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/'); $vamTemplate->assign('logo_path', HTTP_SERVER . DIR_WS_CATALOG . 'templates/' . CURRENT_TEMPLATE . '/img/'); $vamTemplate->assign('GIFT_LINK', vam_href_link(FILENAME_GV_REDEEM, 'gv_no=' . $id1, 'NONSSL', false)); $vamTemplate->assign('AMMOUNT', $vamPrice->Format(str_replace(",", ".", $_POST['amount']), true)); $vamTemplate->assign('GIFT_CODE', $id1); $vamTemplate->assign('MESSAGE', $_POST['message']); $vamTemplate->assign('NAME', $_POST['to_name']); $vamTemplate->assign('FROM_NAME', $_POST['send_name']); // dont allow cache $vamTemplate->caching = false; $html_mail = $vamTemplate->fetch(CURRENT_TEMPLATE . '/mail/' . $_SESSION['language'] . '/send_gift_to_friend.html'); $txt_mail = $vamTemplate->fetch(CURRENT_TEMPLATE . '/mail/' . $_SESSION['language'] . '/send_gift_to_friend.txt'); // send mail vam_php_mail(EMAIL_BILLING_ADDRESS, EMAIL_BILLING_NAME, $_POST['email'], $_POST['to_name'], '', EMAIL_BILLING_REPLY_ADDRESS, EMAIL_BILLING_REPLY_ADDRESS_NAME, '', '', $gv_email_subject, $html_mail, $txt_mail); } } $breadcrumb->add(NAVBAR_GV_SEND); require DIR_WS_INCLUDES . 'header.php'; if ($_GET['action'] == 'process') { $vamTemplate->assign('action', 'process'); $vamTemplate->assign('LINK_DEFAULT', '<a class="button" href="' . vam_href_link(FILENAME_DEFAULT, '', 'NONSSL') . '">' . vam_image_button('submit.png', IMAGE_BUTTON_CONTINUE) . '</a>'); } if ($_GET['action'] == 'send' && !$error) { $vamTemplate->assign('action', 'send'); // validate entries $gv_amount = (double) $gv_amount;
} } } $breadcrumb->add(NAVBAR_TITLE_1_ACCOUNT_PASSWORD, vam_href_link(FILENAME_ACCOUNT, '', 'SSL')); $breadcrumb->add(NAVBAR_TITLE_2_ACCOUNT_PASSWORD, vam_href_link(FILENAME_ACCOUNT_PASSWORD, '', 'SSL')); require DIR_WS_INCLUDES . 'header.php'; if ($messageStack->size('account_password') > 0) { $vamTemplate->assign('error', $messageStack->output('account_password')); } $vamTemplate->assign('FORM_ACTION', vam_draw_form('account_password', vam_href_link(FILENAME_ACCOUNT_PASSWORD, '', 'SSL'), 'post', 'onsubmit="return checkform(this);"') . vam_draw_hidden_field('action', 'process') . vam_draw_hidden_field('required', 'password_current,password_new,password_confirmation', 'id="required"')); $vamTemplate->assign('INPUT_ACTUAL', vam_draw_password_fieldNote(array('name' => 'password_current', 'text' => ' ' . (vam_not_null(ENTRY_PASSWORD_CURRENT_TEXT) ? '<span class="Requirement">' . ENTRY_PASSWORD_CURRENT_TEXT . '</span>' : '')), '', 'id="password_current"')); $vamTemplate->assign('ENTRY_PASSWORD_CURRENT_ERROR', ENTRY_PASSWORD_CURRENT_ERROR); $vamTemplate->assign('INPUT_NEW', vam_draw_password_fieldNote(array('name' => 'password_new', 'text' => ' ' . (vam_not_null(ENTRY_PASSWORD_NEW_TEXT) ? '<span class="Requirement">' . ENTRY_PASSWORD_NEW_TEXT . '</span>' : '')), '', 'id="password_new"')); $vamTemplate->assign('ENTRY_PASSWORD_NEW_ERROR', ENTRY_PASSWORD_NEW_ERROR); $vamTemplate->assign('INPUT_CONFIRM', vam_draw_password_fieldNote(array('name' => 'password_confirmation', 'text' => ' ' . (vam_not_null(ENTRY_PASSWORD_CONFIRMATION_TEXT) ? '<span class="Requirement">' . ENTRY_PASSWORD_CONFIRMATION_TEXT . '</span>' : '')), '', 'id="password_confirmation"')); $vamTemplate->assign('ENTRY_PASSWORD_ERROR_NOT_MATCHING', ENTRY_PASSWORD_ERROR_NOT_MATCHING); $vamTemplate->assign('BUTTON_BACK', '<a class="button" href="' . vam_href_link(FILENAME_ACCOUNT, '', 'SSL') . '">' . vam_image_button('back.png', IMAGE_BUTTON_BACK) . '</a>'); $vamTemplate->assign('BUTTON_SUBMIT', vam_image_submit('submit.png', IMAGE_BUTTON_CONTINUE)); $vamTemplate->assign('FORM_END', '</form>'); $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->caching = 0; $main_content = $vamTemplate->fetch(CURRENT_TEMPLATE . '/module/account_password.html'); $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->assign('main_content', $main_content); $vamTemplate->caching = 0; if (!defined(RM)) { $vamTemplate->load_filter('output', 'note'); } $template = file_exists('templates/' . CURRENT_TEMPLATE . '/' . FILENAME_ACCOUNT_PASSWORD . '.html') ? CURRENT_TEMPLATE . '/' . FILENAME_ACCOUNT_PASSWORD . '.html' : CURRENT_TEMPLATE . '/index.html'; $vamTemplate->display($template); include 'includes/application_bottom.php';
$cache_id = $_SESSION['language'] . $current_category_id . '1111111'; } //if (!$box->is_cached(CURRENT_TEMPLATE.'/boxes/box_best_sellers.html', $cache_id) || !$cache) { require_once DIR_FS_INC . 'vam_row_number_format.inc.php'; //fsk18 lock $fsk_lock = ''; if ($_SESSION['customers_status']['customers_fsk18_display'] == '0') { $fsk_lock = ' and p.products_fsk18!=1'; } if (GROUP_CHECK == 'true') { $group_check = " and p.group_permission_" . $_SESSION['customers_status']['customers_status_id'] . "=1 "; } $wats_new_query = "SELECT distinct\n p.products_id,\n pd.products_name,\n p.products_fsk18,\n p.products_image,\n p.products_tax_class_id,\n p.products_vpe,\n p.products_vpe_status,\n p.products_vpe_value,\n p.products_price,\n IFNULL(cd3.categories_name, IFNULL(cd2.categories_name, IFNULL(cd1.categories_name, cd.categories_name))) as categories_name\n FROM " . TABLE_PRODUCTS . " p\n\t\t\t\t\t\tINNER JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON pd.products_id = p.products_id \n\t\t\t\t\t\t\tAND pd.language_id = '" . (int) $_SESSION['languages_id'] . "'\n\t\t\t\t\t\tINNER JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc ON ptc.products_id = p.products_id\n\t\t\t\t\t\tINNER JOIN " . TABLE_CATEGORIES . " c ON c.categories_id = ptc.categories_id\n\t\t\t\t\t\tINNER JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON cd.categories_id = c.categories_id\n\t\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES . " c1 ON c1.categories_id = c.parent_id\n\t\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd1 ON cd1.categories_id = c1.categories_id\n\t\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES . " c2 ON c2.categories_id = c1.parent_id\n\t\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd2 ON cd2.categories_id = c2.categories_id\n\t\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES . " c3 ON c3.categories_id = c2.parent_id\n\t\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd3 ON cd3.categories_id = c3.categories_id \n WHERE p.products_status=1\n\t\t\t\t\tAND p.products_startpage = 1\n\t\t\t\t\t" . $group_check . "\n\t\t\t\t\t" . $fsk_lock . "\n\t\t\t\t\tand c.categories_status=1"; $news_by_date = " ORDER BY p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS; if ($cache) { $box_whats_new = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_tops_list.html', $cache_id); } else { $wats_new_query = vamDBquery($wats_new_query . $news_by_date); // если новинок нет выбрать те что отмечены "на главной" if (vam_db_num_rows($wats_new_query, true) == 0) { $news_by_marked = " AND p.products_startpage = 1 limit " . MAX_DISPLAY_NEW_PRODUCTS; $wats_new_query = vamDBquery($wats_new_query . $news_by_marked); } if (vam_db_num_rows($wats_new_query, true) >= 0) { $rows = 0; $box_content = array(); while ($wats_new = vam_db_fetch_array($wats_new_query, true)) { $rows++; $wats_new = array_merge($wats_new, array('ID' => vam_row_number_format($rows))); $box_content[] = $product->buildDataArray($wats_new); }
} } } else { vam_redirect(FILENAME_DEFAULT); } if (!$error && isset($_SESSION['customer_id'])) { // Update redeem status $gv_query = vam_db_query("insert into " . TABLE_COUPON_REDEEM_TRACK . " (coupon_id, customer_id, redeem_date, redeem_ip) values ('" . $coupon['coupon_id'] . "', '" . $_SESSION['customer_id'] . "', now(),'" . $REMOTE_ADDR . "')"); $gv_update = vam_db_query("update " . TABLE_COUPONS . " set coupon_active = 'N' where coupon_id = '" . $coupon['coupon_id'] . "'"); vam_gv_account_update($_SESSION['customer_id'], $_SESSION['gv_id']); unset($_SESSION['gv_id']); } $breadcrumb->add(NAVBAR_GV_REDEEM); $coupon_r = $vamPrice->CalculateCurr($coupon['coupon_amount']); // if we get here then either the url gv_no was not set or it was invalid // so output a message. $vamTemplate->assign('coupon_amount', $vamPrice->Format($coupon_r, true)); $vamTemplate->assign('error', $error); $vamTemplate->assign('LINK_DEFAULT', '<a class="button" href="' . vam_href_link(FILENAME_DEFAULT) . '">' . vam_image_button('submit.png', IMAGE_BUTTON_CONTINUE) . '</a>'); $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->caching = 0; $main_content = $vamTemplate->fetch(CURRENT_TEMPLATE . '/module/gv_redeem.html'); $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->assign('main_content', $main_content); $vamTemplate->caching = 0; if (!defined(RM)) { $vamTemplate->load_filter('output', 'note'); } $template = file_exists('templates/' . CURRENT_TEMPLATE . '/' . FILENAME_GV_REDEEM . '.html') ? CURRENT_TEMPLATE . '/' . FILENAME_GV_REDEEM . '.html' : CURRENT_TEMPLATE . '/index.html'; $vamTemplate->display($template); include 'includes/application_bottom.php';
$selection[$i]['selection'] = vam_draw_radio_field('payment', $selection[$i]['id'], $selection[$i]['id'] == $selection[0]['id'], 'id="' . $selection[$i]['id'] . '"'); } else { $selection[$i]['selection'] = vam_draw_hidden_field('payment', $selection[$i]['id']); } $selection[$i]['id'] = $selection[$i]['id']; if (isset($selection[$i]['error'])) { } else { $radio_buttons++; } } $module->assign('module_content', $selection); if (ACTIVATE_GIFT_SYSTEM == 'true') { $vamTemplate->assign('module_gift', $order_total_modules->credit_selection()); } $module->caching = 0; $payment_block = $module->fetch(CURRENT_TEMPLATE . '/module/checkout_payment_block.html'); $vamTemplate->assign('COMMENTS', vam_draw_textarea_field('comments', 'soft', '60', '5', $_POST['comments']) . vam_draw_hidden_field('comments_added', 'YES')); $vamTemplate->assign('conditions', 'false'); //check if display conditions on checkout page is true if (DISPLAY_CONDITIONS_ON_CHECKOUT == 'true') { $vamTemplate->assign('conditions', 'true'); if (GROUP_CHECK == 'true') { $group_check = "and group_ids LIKE '%c_" . $_SESSION['customers_status']['customers_status_id'] . "_group%'"; } $shop_content_query = vam_db_query("SELECT\n\t content_title,\n\t content_heading,\n\t content_text,\n\t content_file\n\t FROM " . TABLE_CONTENT_MANAGER . "\n\t WHERE content_group='3' " . $group_check . "\n\t AND languages_id='" . $_SESSION['languages_id'] . "'"); $shop_content_data = vam_db_fetch_array($shop_content_query); if ($shop_content_data['content_file'] != '') { $conditions = '<iframe SRC="' . DIR_WS_CATALOG . 'media/content/' . $shop_content_data['content_file'] . '" width="100%" height="300">'; $conditions .= '</iframe>'; } else { $conditions = '<textarea name="blabla" cols="60" rows="10" readonly="readonly">' . strip_tags(str_replace('<br />', "\n", $shop_content_data['content_text'])) . '</textarea>';
----------------------------------------------------------------------------------------- Released under the GNU General Public License ---------------------------------------------------------------------------------------*/ $box = new vamTemplate(); $box->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/'); $sql = "\n SELECT\n news_id,\n headline,\n content,\n date_added\n FROM " . TABLE_LATEST_NEWS . "\n WHERE\n status = '1'\n and language = '" . (int) $_SESSION['languages_id'] . "'\n ORDER BY date_added DESC\n LIMIT " . MAX_DISPLAY_LATEST_NEWS . "\n "; $module_content = array(); $query = vamDBquery($sql); while ($one = vam_db_fetch_array($query, true)) { $SEF_parameter = ''; if (SEARCH_ENGINE_FRIENDLY_URLS == 'true') { $SEF_parameter = '&headline=' . vam_cleanName($one['headline']); } $module_content[] = array('NEWS_HEADING' => $one['headline'], 'NEWS_CONTENT' => $one['content'], 'NEWS_ID' => $one['news_id'], 'NEWS_DATA' => vam_date_short($one['date_added']), 'NEWS_LINK_MORE' => vam_href_link(FILENAME_NEWS, 'news_id=' . $one['news_id'] . $SEF_parameter, 'NONSSL')); } if (sizeof($module_content) > 0) { $box->assign('NEWS_LINK', vam_href_link(FILENAME_NEWS)); $box->assign('language', $_SESSION['language']); $box->assign('module_content', $module_content); // set cache ID if (USE_CACHE == 'false') { $box->caching = 0; $module = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_latest_news.html'); } else { $box->caching = 1; $box->cache_lifetime = CACHE_LIFETIME; $box->cache_modified_check = CACHE_CHECK; $module = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_latest_news.html', $cache_id); } $vamTemplate->assign('box_LATESTNEWS', $module); }
// $email .= sprintf(EMAIL_TEXT_NEWCUST_INTRO, $mline); // } else { // $email .= sprintf(EMAIL_TEXT_CURCUST_INTRO, $mline); // } // $email .= sprintf(EMAIL_TEXT_COMMON_BODY, $mline) . "\n". $_POST['message']; $custname = $inrec['fname'] . " " . $inrec['lname']; // assign language to template for caching $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->caching = false; $vamTemplate->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/'); $vamTemplate->assign('logo_path', HTTP_SERVER . DIR_WS_CATALOG . 'templates/' . CURRENT_TEMPLATE . '/img/'); $vamTemplate->assign('STORE_NAME', STORE_NAME); $vamTemplate->assign('NAME', $custname); $vamTemplate->assign('MESSAGE', $_POST['message']); $vamTemplate->assign('PRODUCTS', $mline); $html_mail = $vamTemplate->fetch(CURRENT_TEMPLATE . '/admin/mail/' . $_SESSION['language'] . '/recover_cart_mail.html'); $txt_mail = $vamTemplate->fetch(CURRENT_TEMPLATE . '/admin/mail/' . $_SESSION['language'] . '/recover_cart_mail.txt'); vam_php_mail(EMAIL_BILLING_ADDRESS, EMAIL_BILLING_NAME, $inrec['email'], $custname, '', EMAIL_BILLING_REPLY_ADDRESS, EMAIL_BILLING_REPLY_ADDRESS_NAME, '', '', EMAIL_TEXT_SUBJECT, $html_mail, $txt_mail); $mline = ""; // vam_php_mail($custname, $inrec['email'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); // $mline = ""; vam_db_query("insert into " . TABLE_SCART . " (customers_id, dateadded ) values ('" . $cid . "', '" . seadate('0') . "')"); echo $cline; $cline = ""; } } $tcart_formated = $currencies->format($tprice); echo "<tr> <td class='dataTableContent' align='right' colspan='8'><b>" . TABLE_CART_TOTAL . "</b>" . $tcart_formated . "</td> </tr>"; echo "<tr><td colspan=6 align=center><a class=button href=" . vam_href_link(FILENAME_RECOVER_CART_SALES) . "><span>" . TEXT_RETURN . "</span></a></td></tr>"; } else { //
---------------------------------------------------------------------------------------*/ $box = new vamTemplate(); $box->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/'); $box_content = ''; // include needed functions require_once DIR_FS_INC . 'vam_random_select.inc.php'; require_once DIR_FS_INC . 'vam_row_number_format.inc.php'; //fsk18 lock $fsk_lock = ''; if ($_SESSION['customers_status']['customers_fsk18_display'] == '0') { $fsk_lock = ' and p.products_fsk18!=1'; } if (GROUP_CHECK == 'true') { $group_check = " and p.group_permission_" . $_SESSION['customers_status']['customers_status_id'] . "=1 "; } $random_product = "select\n p.products_id,\n pd.products_name,\n p.products_price,\n p.products_tax_class_id,\n p.products_image,\n f.expires_date,\n p.products_vpe,\n\t\t\t\t p.products_vpe_status,\n\t\t\t\t p.products_vpe_value\n from " . TABLE_PRODUCTS . " p,\n " . TABLE_PRODUCTS_DESCRIPTION . " pd,\n " . TABLE_FEATURED . " f where p.products_status = '1'\n and p.products_id = f.products_id\n and pd.products_id = f.products_id\n and pd.language_id = '" . $_SESSION['languages_id'] . "'\n and f.status = '1'\n " . $group_check . "\n " . $fsk_lock . " \n order by rand()\n desc limit 3"; $feat_q = vamDBquery($random_product); if (vam_db_num_rows($feat_q, true) >= 0) { $rows = 0; $box_content = array(); while ($feat = vam_db_fetch_array($feat_q, true)) { $rows++; //$feat = array_merge($feat, array ('ID' => vam_row_number_format($rows))); $box_content[] = $product->buildDataArray($feat); } } $box->assign('box_content', $box_content); $box->assign('FEATURED_LINK', vam_href_link(FILENAME_FEATURED)); $box->assign('language', $_SESSION['language']); $box_featured = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_feature.html'); $vamTemplate->assign('box_FEATURE', $box_featured);
$state_input = vam_draw_pull_down_menuNote(array('name' => 'state', 'text' => ' ' . (vam_not_null(ENTRY_STATE_TEXT) ? '<span class="Requirement">' . ENTRY_STATE_TEXT . '</span>' : '')), $zones_array, vam_get_zone_name($entry['entry_country_id'], $entry['entry_zone_id'], $entry['entry_state']), ' id="state"'); } else { $state_input = vam_draw_input_fieldNote(array('name' => 'state', 'text' => ' ' . (vam_not_null(ENTRY_STATE_TEXT) ? '<span class="Requirement">' . ENTRY_STATE_TEXT . '</span>' : '')), vam_get_zone_name(STORE_COUNTRY, STORE_ZONE), ' id="state"'); } $module->assign('INPUT_STATE', $state_input); } else { $module->assign('state', '0'); } if ($_POST['country']) { $selected = $_POST['country']; } else { $selected = $entry['entry_country_id']; } if (ACCOUNT_COUNTRY == 'true') { $module->assign('country', '1'); if ($process == true) { $entry['entry_country_id'] = (int) $_POST['country']; } $module->assign('SELECT_COUNTRY', vam_get_country_list('country', $entry['entry_country_id'], 'id="country"') . (vam_not_null(ENTRY_COUNTRY_TEXT) ? '<span class="Requirement">' . ENTRY_COUNTRY_TEXT . '</span>' : '')); $module->assign('SELECT_COUNTRY_NOSCRIPT', '<noscript><br />' . vam_image_submit('update.png', IMAGE_BUTTON_UPDATE, 'name=loadStateXML') . '<br />' . ENTRY_STATE_RELOAD . '</noscript>'); } else { $vamTemplate->assign('country', '0'); } if (isset($_GET['edit']) && $_SESSION['customer_default_address_id'] != $_GET['edit'] || isset($_GET['edit']) == false) { $module->assign('new', '1'); $module->assign('CHECKBOX_PRIMARY', vam_draw_checkbox_field('primary', 'on', false, 'id="primary"')); } $module->assign('language', $_SESSION['language']); $module->caching = 0; $main_content = $module->fetch(CURRENT_TEMPLATE . '/module/address_book_details.html'); $vamTemplate->assign('MODULE_address_book_details', $main_content);
} //if (!$box->is_cached(CURRENT_TEMPLATE.'/boxes/box_best_sellers.html', $cache_id) || !$cache) { // include needed functions require_once DIR_FS_INC . 'vam_row_number_format.inc.php'; //fsk18 lock $fsk_lock = ''; if ($_SESSION['customers_status']['customers_fsk18_display'] == '0') { $fsk_lock = ' and p.products_fsk18!=1'; } if (GROUP_CHECK == 'true') { $group_check = " and p.group_permission_" . $_SESSION['customers_status']['customers_status_id'] . "=1 "; } $best_sellers_query = "SELECT\r\n p.products_id,\r\n pd.products_name,\r\n p.products_price,\r\n p.products_tax_class_id,\r\n p.products_image,\r\n p.products_fsk18,\r\n p.products_vpe,\r\n p.products_vpe_status,\r\n p.products_vpe_value,\r\n\t\t\t\t\t IFNULL(cd3.categories_name, IFNULL(cd2.categories_name, IFNULL(cd1.categories_name, cd.categories_name))) as categories_name\r\n FROM " . TABLE_PRODUCTS . " p \r\n\t\t\t\t\tINNER JOIN " . TABLE_FEATURED . " s ON s.products_id = p.products_id AND s.status = '1'\r\n\t\t\t\t\tINNER JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON pd.products_id = p.products_id \r\n\t\t\t\t\t\t\tAND pd.language_id = '" . (int) $_SESSION['languages_id'] . "'\r\n\t\t\t\t\tINNER JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc ON ptc.products_id = p.products_id\r\n\t\t\t\t\tINNER JOIN " . TABLE_CATEGORIES . " c ON c.categories_id = ptc.categories_id\r\n\t\t\t\t\tINNER JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON cd.categories_id = c.categories_id\r\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES . " c1 ON c1.categories_id = c.parent_id\r\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd1 ON cd1.categories_id = c1.categories_id\r\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES . " c2 ON c2.categories_id = c1.parent_id\r\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd2 ON cd2.categories_id = c2.categories_id\r\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES . " c3 ON c3.categories_id = c2.parent_id\r\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd3 ON cd3.categories_id = c3.categories_id \r\n " . $group_check . "\r\n " . $fsk_lock . " LIMIT " . MAX_RANDOM_SELECT_FEATURED; // set cache ID if ($cache) { $box_best_sellers = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_tops_list.html', $cache_id); $vamTemplate->assign('box_BESTSELLERS', $box_best_sellers); } else { $best_sellers_query = vamDBquery($best_sellers_query); //if (vam_db_num_rows($best_sellers_query, true) == 0) //$best_sellers_query = vamDBquery($on_start_products_query); $rows = 0; $box_content = array(); while ($best_sellers = vam_db_fetch_array($best_sellers_query, true)) { $rows++; $best_sellers = array_merge($best_sellers, array('ID' => vam_row_number_format($rows))); $box_content[] = $product->buildDataArray($best_sellers); } $box->assign('box_content', $box_content); $box->assign('box_mark', 'best_sellers_mark'); $box->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/');
} } } if ($_GET['info_message']) { $vamTemplate->assign('info_message', str_replace('+', ' ', htmlspecialchars($_GET['info_message']))); } $vamTemplate->assign('BUTTON_RELOAD', vam_image_submit('update.png', IMAGE_BUTTON_UPDATE_CART)); $vamTemplate->assign('BUTTON_CHECKOUT', '<a class="button" href="' . vam_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL') . '">' . vam_image_button('', IMAGE_BUTTON_CHECKOUT) . '</a>'); } else { // empty cart $cart_empty = true; if ($_GET['info_message']) { $vamTemplate->assign('info_message', str_replace('+', ' ', htmlspecialchars($_GET['info_message']))); } $vamTemplate->assign('cart_empty', $cart_empty); $vamTemplate->assign('BUTTON_CONTINUE', '<a class="button" href="' . vam_href_link(FILENAME_DEFAULT) . '">' . vam_image_button('', IMAGE_BUTTON_CONTINUE) . '</a>'); } $vamTemplate->assign('continue_url', '/'); $vamTemplate->assign('script_reload_page', '<script type="text/javascript">var reload_page = true;</script>'); $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->caching = 0; $main_content = $vamTemplate->fetch(CURRENT_TEMPLATE . '/module/shopping_cart.html'); $vamTemplate->assign('main_content', $main_content); $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->caching = 0; if (!defined(RM)) { $vamTemplate->load_filter('output', 'note'); } $template = file_exists('templates/' . CURRENT_TEMPLATE . '/' . FILENAME_SHOPPING_CART . '.html') ? CURRENT_TEMPLATE . '/' . FILENAME_SHOPPING_CART . '.html' : CURRENT_TEMPLATE . '/index.html'; $vamTemplate->display($template); include 'includes/application_bottom.php';
function before_process() { global $customer_id, $order, $vamPrice, $order_totals, $sendto, $billto, $languages_id, $payment, $currencies, $cart; global ${$payment}; $order_id = substr($_SESSION['cart_yandex_id'], strpos($_SESSION['cart_yandex_id'], '-') + 1); // initialized for the email confirmation $products_ordered = ''; $subtotal = 0; $total_tax = 0; for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) { // Stock Update - Joao Correia if (STOCK_LIMITED == 'true') { if (DOWNLOAD_ENABLED == 'true') { $stock_query_raw = "SELECT products_quantity, pad.products_attributes_filename, pad.products_attributes_is_pin \n FROM " . TABLE_PRODUCTS . " p\n LEFT JOIN " . TABLE_PRODUCTS_ATTRIBUTES . " pa\n ON p.products_id=pa.products_id\n LEFT JOIN " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " pad\n ON pa.products_attributes_id=pad.products_attributes_id\n WHERE p.products_id = '" . vam_get_prid($order->products[$i]['id']) . "'"; // Will work with only one option for downloadable products // otherwise, we have to build the query dynamically with a loop $products_attributes = $order->products[$i]['attributes']; if (is_array($products_attributes)) { $stock_query_raw .= " AND pa.options_id = '" . $products_attributes[0]['option_id'] . "' AND pa.options_values_id = '" . $products_attributes[0]['value_id'] . "'"; } $stock_query = vam_db_query($stock_query_raw); } else { $stock_query = vam_db_query("select products_quantity from " . TABLE_PRODUCTS . " where products_id = '" . vam_get_prid($order->products[$i]['id']) . "'"); } if (vam_db_num_rows($stock_query) > 0) { $stock_values = vam_db_fetch_array($stock_query); // do not decrement quantities if products_attributes_filename exists if (DOWNLOAD_ENABLED != 'true' || !$stock_values['products_attributes_filename'] || $stock_values['products_attributes_is_pin'] == 1) { $stock_left = $stock_values['products_quantity'] - $order->products[$i]['qty']; } else { $stock_left = $stock_values['products_quantity']; } vam_db_query("update " . TABLE_PRODUCTS . " set products_quantity = '" . $stock_left . "' where products_id = '" . vam_get_prid($order->products[$i]['id']) . "'"); if ($stock_left < 1 && STOCK_ALLOW_CHECKOUT == 'false') { vam_db_query("update " . TABLE_PRODUCTS . " set products_status = '0' where products_id = '" . vam_get_prid($order->products[$i]['id']) . "'"); } } } // Update products_ordered (for bestsellers list) vam_db_query("update " . TABLE_PRODUCTS . " set products_ordered = products_ordered + " . sprintf('%d', $order->products[$i]['qty']) . " where products_id = '" . vam_get_prid($order->products[$i]['id']) . "'"); //------insert customer choosen option to order-------- $attributes_exist = '0'; $products_ordered_attributes = ''; if (isset($order->products[$i]['attributes'])) { $attributes_exist = '1'; for ($j = 0, $n2 = sizeof($order->products[$i]['attributes']); $j < $n2; $j++) { if (DOWNLOAD_ENABLED == 'true') { $attributes_query = "select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix, pad.products_attributes_maxdays, pad.products_attributes_maxcount , pad.products_attributes_filename, pad.products_attributes_is_pin\n from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa\n left join " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " pad\n on pa.products_attributes_id=pad.products_attributes_id\n where pa.products_id = '" . $order->products[$i]['id'] . "'\n and pa.options_id = '" . $order->products[$i]['attributes'][$j]['option_id'] . "'\n and pa.options_id = popt.products_options_id\n and pa.options_values_id = '" . $order->products[$i]['attributes'][$j]['value_id'] . "'\n and pa.options_values_id = poval.products_options_values_id\n and popt.language_id = '" . $_SESSION['languages_id'] . "'\n and poval.language_id = '" . $_SESSION['languages_id'] . "'"; $attributes = vam_db_query($attributes_query); } else { $attributes = vam_db_query("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa where pa.products_id = '" . $order->products[$i]['id'] . "' and pa.options_id = '" . $order->products[$i]['attributes'][$j]['option_id'] . "' and pa.options_id = popt.products_options_id and pa.options_values_id = '" . $order->products[$i]['attributes'][$j]['value_id'] . "' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '" . $_SESSION['languages_id'] . "' and poval.language_id = '" . $_SESSION['languages_id'] . "'"); } $attributes_values = vam_db_fetch_array($attributes); $products_ordered_attributes .= "\n\t" . $attributes_values['products_options_name'] . ' ' . $attributes_values['products_options_values_name']; } } //------insert customer choosen option eof ---- $total_weight += $order->products[$i]['qty'] * $order->products[$i]['weight']; $total_tax += vam_calculate_tax($total_products_price, $products_tax) * $order->products[$i]['qty']; $total_cost += $total_products_price; $products_ordered .= $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name'] . ' (' . $order->products[$i]['model'] . ') = ' . $vamPrice->Format($order->products[$i]['final_price'], true) . $products_ordered_attributes . "\n"; } // initialize templates $vamTemplate = new vamTemplate(); $vamTemplate->assign('address_label_customer', vam_address_format($order->customer['format_id'], $order->customer, 1, '', '<br />')); $vamTemplate->assign('address_label_shipping', vam_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br />')); if ($_SESSION['credit_covers'] != '1') { $vamTemplate->assign('address_label_payment', vam_address_format($order->billing['format_id'], $order->billing, 1, '', '<br />')); } $vamTemplate->assign('csID', $order->customer['csID']); $it = 0; $semextrfields = vamDBquery("select * from " . TABLE_EXTRA_FIELDS . " where fields_required_email = '1'"); while ($dataexfes = vam_db_fetch_array($semextrfields, true)) { $cusextrfields = vamDBquery("select * from " . TABLE_CUSTOMERS_TO_EXTRA_FIELDS . " where customers_id = '" . (int) $_SESSION['customer_id'] . "' and fields_id = '" . $dataexfes['fields_id'] . "'"); $rescusextrfields = vam_db_fetch_array($cusextrfields, true); $extrfieldsinf = vamDBquery("select fields_name from " . TABLE_EXTRA_FIELDS_INFO . " where fields_id = '" . $dataexfes['fields_id'] . "' and languages_id = '" . $_SESSION['languages_id'] . "'"); $extrfieldsres = vam_db_fetch_array($extrfieldsinf, true); $extra_fields .= $extrfieldsres['fields_name'] . ' : ' . $rescusextrfields['value'] . "\n"; $vamTemplate->assign('customer_extra_fields', $extra_fields); } $order_total = $order->getTotalData($order_id); $vamTemplate->assign('order_data', $order->getOrderData($order_id)); $vamTemplate->assign('order_total', $order_total['data']); // assign language to template for caching $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/'); $vamTemplate->assign('logo_path', HTTP_SERVER . DIR_WS_CATALOG . 'templates/' . CURRENT_TEMPLATE . '/img/'); $vamTemplate->assign('oID', $order_id); if ($order->info['payment_method'] != '' && $order->info['payment_method'] != 'no_payment') { include DIR_WS_LANGUAGES . $_SESSION['language'] . '/modules/payment/' . $order->info['payment_method'] . '.php'; $payment_method = constant(strtoupper('MODULE_PAYMENT_' . $order->info['payment_method'] . '_TEXT_TITLE')); } $vamTemplate->assign('PAYMENT_METHOD', $payment_method); if ($order->info['shipping_method'] != '') { $shipping_method = $order->info['shipping_method']; } $vamTemplate->assign('SHIPPING_METHOD', $shipping_method); $vamTemplate->assign('DATE', vam_date_long($order->info['date_purchased'])); $vamTemplate->assign('NAME', $order->customer['firstname'] . ' ' . $order->customer['lastname']); $vamTemplate->assign('COMMENTS', $order->info['comments']); $vamTemplate->assign('EMAIL', $order->customer['email_address']); $vamTemplate->assign('PHONE', $order->customer['telephone']); // dont allow cache $vamTemplate->caching = false; $html_mail = $vamTemplate->fetch(CURRENT_TEMPLATE . '/mail/' . $_SESSION['language'] . '/order_mail.html'); $txt_mail = $vamTemplate->fetch(CURRENT_TEMPLATE . '/mail/' . $_SESSION['language'] . '/order_mail.txt'); // create subject $order_subject = str_replace('{$nr}', $order_id, EMAIL_BILLING_SUBJECT_ORDER); $order_subject = str_replace('{$date}', strftime(DATE_FORMAT_LONG), $order_subject); $order_subject = str_replace('{$lastname}', $order->customer['lastname'], $order_subject); $order_subject = str_replace('{$firstname}', $order->customer['firstname'], $order_subject); // send mail to admin vam_php_mail(EMAIL_BILLING_ADDRESS, EMAIL_BILLING_NAME, EMAIL_BILLING_ADDRESS, STORE_NAME, EMAIL_BILLING_FORWARDING_STRING, $order->customer['email_address'], $order->customer['firstname'], '', '', $order_subject, $html_mail, $txt_mail); // send mail to customer vam_php_mail(EMAIL_BILLING_ADDRESS, EMAIL_BILLING_NAME, $order->customer['email_address'], $order->customer['firstname'] . ' ' . $order->customer['lastname'], '', EMAIL_BILLING_REPLY_ADDRESS, EMAIL_BILLING_REPLY_ADDRESS_NAME, '', '', $order_subject, $html_mail, $txt_mail); // load the after_process function from the payment modules $this->after_process(); require_once DIR_WS_INCLUDES . 'affiliate_checkout_process.php'; $_SESSION['cart']->reset(true); // unregister session variables used during checkout unset($_SESSION['sendto']); unset($_SESSION['billto']); unset($_SESSION['shipping']); unset($_SESSION['payment']); unset($_SESSION['comments']); unset($_SESSION['cart_yandex_id']); vam_redirect(vam_href_link(FILENAME_CHECKOUT_SUCCESS, '', 'SSL')); }
*/ $SEF_parameter = ''; if (SEARCH_ENGINE_FRIENDLY_URLS == 'true') { $SEF_parameter = '&article=' . vam_cleanName($articles['articles_name']); } $SEF_parameter_author = ''; if (SEARCH_ENGINE_FRIENDLY_URLS == 'true') { $SEF_parameter_author = '&author=' . vam_cleanName($articles['authors_name']); } $SEF_parameter_category = ''; if (SEARCH_ENGINE_FRIENDLY_URLS == 'true') { $SEF_parameter_category = '&category=' . vam_cleanName($articles['topics_name']); } $module_content[] = array('ARTICLE_ID' => $articles['articles_id'], 'ARTICLE_NAME' => $articles['articles_name'], 'ARTICLE_IMAGE' => $articles['articles_image'], 'ARTICLE_SHORT_DESCRIPTION' => strip_tags($articles['articles_description']), 'ARTICLE_DATE' => vam_date_long($articles['articles_date_added']), 'ARTICLE_LINK' => vam_href_link(FILENAME_ARTICLE_INFO, 'articles_id=' . $articles['articles_id'] . $SEF_parameter), 'AUTHOR_NAME' => $articles['authors_name'], 'AUTHOR_LINK' => vam_href_link(FILENAME_ARTICLES, 'authors_id=' . $articles['authors_id'] . $SEF_parameter_author), 'ARTICLE_CATEGORY_NAME' => $articles['topics_name'], 'ARTICLE_CATEGORY_LINK' => vam_href_link(FILENAME_ARTICLES, 'tPath=' . $articles['topics_id'] . $SEF_parameter_category)); } } else { $vamTemplate->assign('no_articles', 'true'); } $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->caching = 0; $vamTemplate->assign('module_content', $module_content); $main_content = $vamTemplate->fetch(CURRENT_TEMPLATE . '/module/articles.html'); $vamTemplate->assign('main_content', $main_content); $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->caching = 0; if (!defined(RM)) { $vamTemplate->load_filter('output', 'note'); } $template = file_exists('templates/' . CURRENT_TEMPLATE . '/' . FILENAME_ARTICLES . '.html') ? CURRENT_TEMPLATE . '/' . FILENAME_ARTICLES . '.html' : CURRENT_TEMPLATE . '/index.html'; $vamTemplate->display($template); include 'includes/application_bottom.php';
require_once DIR_WS_INCLUDES . 'external/slider/Slider.class.inc.php'; $s = new Slider(); $simages = $s->grepIMGfromHTML($s1['slider_config']); if ($_GET['dbg'] == 1) { print_r($simages); } // set cache ID if (!CacheCheck()) { $cache = false; $box->caching = 0; } else { $cache = true; $box->caching = 1; $box->cache_lifetime = CACHE_LIFETIME; $box->cache_modified_check = CACHE_CHECK; $cache_id = $_SESSION['language'] . $_SESSION['customers_status']['customers_status_id'] . $current_category_id; } if (!$box->is_cached(CURRENT_TEMPLATE . '/boxes/box_slider_category.html', $cache_id) || !$cache) { $box->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/'); } if (count($simages[0]) > 0) { $box->assign('SLIDERS', $simages[0]); $box->assign('DELAY', $s1['slider_delay']); } // set cache ID if (!$cache) { $box_mainslider = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_slider_category.html'); } else { $box_mainslider = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_slider_category.html', $cache_id); } $vamTemplate->assign('box_SLIDER_CATEGORY', $box_mainslider);
$box->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/'); $box_content = ''; // include needed functions require_once DIR_FS_INC . 'vam_random_select.inc.php'; //fsk18 lock $fsk_lock = ''; if ($_SESSION['customers_status']['customers_fsk18_display'] == '0') { $fsk_lock = ' and p.products_fsk18!=1'; } if (GROUP_CHECK == 'true') { $group_check = " and p.group_permission_" . $_SESSION['customers_status']['customers_status_id'] . "=1 "; } if ($random_product = vam_random_select("select\n p.products_id,\n pd.products_name,\n p.products_price,\n p.products_tax_class_id,\n p.products_image,\n s.expires_date,\n p.products_vpe,\n\t\t\t\t p.products_vpe_status,\n\t\t\t\t p.products_vpe_value,\n s.specials_new_products_price\n from " . TABLE_PRODUCTS . " p,\n " . TABLE_PRODUCTS_DESCRIPTION . " pd,\n " . TABLE_SPECIALS . " s where p.products_status = '1'\n and p.products_id = s.products_id\n and pd.products_id = s.products_id\n and pd.language_id = '" . $_SESSION['languages_id'] . "'\n and s.status = '1'\n " . $group_check . "\n " . $fsk_lock . " \n order by s.specials_date_added\n desc limit " . MAX_RANDOM_SELECT_SPECIALS)) { $box->assign('box_content', $product->buildDataArray($random_product)); $box->assign('SPECIALS_LINK', vam_href_link(FILENAME_SPECIALS)); $box->assign('language', $_SESSION['language']); if ($random_product["products_id"] != '') { // set cache ID if (!CacheCheck()) { $box->caching = 0; $box_specials = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_specials.html'); } else { $box->caching = 1; $box->cache_lifetime = CACHE_LIFETIME; $box->cache_modified_check = CACHE_CHECK; $cache_id = $_SESSION['language'] . $random_product["products_id"] . $_SESSION['customers_status']['customers_status_name']; $box_specials = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_specials.html', $cache_id); } $vamTemplate->assign('box_SPECIALS', $box_specials); } }
$vamTemplate->assign('REVIEWS_TEXT', nl2br($reviews_text)); $vamTemplate->assign('RATING', vam_image('templates/' . CURRENT_TEMPLATE . '/img/stars_' . $reviews['reviews_rating'] . '.gif', sprintf(TEXT_OF_5_STARS, $reviews['reviews_rating']))); $vamTemplate->assign('PRODUCTS_LINK', vam_href_link(FILENAME_PRODUCT_INFO, vam_product_link($reviews['products_id'], $reviews['products_name']))); $vamTemplate->assign('BUTTON_BACK', '<a class="button" href="' . vam_href_link(FILENAME_PRODUCT_REVIEWS, $get_params) . '">' . vam_image_button('back.png', IMAGE_BUTTON_BACK) . '</a>'); $vamTemplate->assign('BUTTON_BUY_NOW', '<a class="button" href="' . vam_href_link(FILENAME_DEFAULT, 'action=buy_now&BUYproducts_id=' . $reviews['products_id']) . '">' . vam_image_button('buy.png', IMAGE_BUTTON_IN_CART) . '</a>'); $products_image = DIR_WS_THUMBNAIL_IMAGES . $reviews['products_image']; if (!is_file($products_image)) { $products_image = DIR_WS_THUMBNAIL_IMAGES . '../noimage.gif'; } $image = vam_image($products_image, $reviews['products_name'], '', '', 'hspace="5" vspace="5"'); $vamTemplate->assign('IMAGE', $image); $vamTemplate->assign('language', $_SESSION['language']); // set cache ID if (!CacheCheck()) { $vamTemplate->caching = 0; $main_content = $vamTemplate->fetch(CURRENT_TEMPLATE . '/module/product_reviews_info.html'); } else { $vamTemplate->caching = 1; $vamTemplate->cache_lifetime = CACHE_LIFETIME; $vamTemplate->cache_modified_check = CACHE_CHECK; $cache_id = $_SESSION['language'] . $reviews['reviews_id']; $main_content = $vamTemplate->fetch(CURRENT_TEMPLATE . '/module/product_reviews_info.html', $cache_id); } $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->assign('main_content', $main_content); $vamTemplate->caching = 0; if (!defined(RM)) { $vamTemplate->load_filter('output', 'note'); } $template = file_exists('templates/' . CURRENT_TEMPLATE . '/' . FILENAME_PRODUCT_REVIEWS_INFO . '.html') ? CURRENT_TEMPLATE . '/' . FILENAME_PRODUCT_REVIEWS_INFO . '.html' : CURRENT_TEMPLATE . '/index.html'; $vamTemplate->display($template);
if ($downloads_values['download_is_pin'] == 1) { //PIN processing $pinstring = $downloads_values['download_pin_code']; $box_content .= $downloads_values['products_name'] . ': ' . $pinstring . '<br />'; } else { //usual stuff // The link will appear only if: // - Download remaining count is > 0, AND // - The file is present in the DOWNLOAD directory, AND EITHER // - No expiry date is enforced (maxdays == 0), OR // - The expiry date is not reached if ($downloads_values['download_count'] > 0 && file_exists(DIR_FS_DOWNLOAD . $downloads_values['orders_products_filename']) && ($downloads_values['download_maxdays'] == 0 || $download_timestamp > time())) { $box_content .= BOX_TEXT_DOWNLOAD . '<br /><br /><a href="' . vam_href_link(FILENAME_DOWNLOAD, 'order=' . $last_order . '&id=' . $downloads_values['orders_products_download_id']) . '">' . $downloads_values['products_name'] . '</a><br /><a href="' . vam_href_link(FILENAME_DOWNLOAD, 'order=' . $last_order . '&id=' . $downloads_values['orders_products_download_id']) . '"><span class="Requirement"><strong>' . BOX_TEXT_DOWNLOAD_NOW . '</strong></span></a><br /><br />'; } else { $box_content .= $downloads_values['products_name']; } $box_content .= TABLE_HEADING_DOWNLOAD_DATE . vam_date_short($download_expiry) . '<br />'; $box_content .= TABLE_HEADING_DOWNLOAD_COUNT . $downloads_values['download_count'] . '<br /><br />'; } } if (!strstr($_SERVER['SCRIPT_NAME'], FILENAME_ACCOUNT_HISTORY_INFO)) { $box_content .= TEXT_FOOTER_DOWNLOAD . '<a href="' . vam_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL') . '">' . TEXT_DOWNLOAD_MY_ACCOUNT . '</a>'; } $box->assign('BOX_CONTENT', $box_content); $box->caching = 0; $box->assign('language', $_SESSION['language']); $box_download = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_download.html'); $vamTemplate->assign('box_DOWNLOADS', $box_download); } } // /downloads
(c) 2004 xt:Commerce (cookie_usage.php,v 1.9 2003/08/17); xt-commerce.com Released under the GNU General Public License ---------------------------------------------------------------------------------------*/ include 'includes/application_top.php'; $vamTemplate = new vamTemplate(); // include boxes require DIR_FS_CATALOG . 'templates/' . CURRENT_TEMPLATE . '/source/boxes.php'; $breadcrumb->add(NAVBAR_TITLE_COOKIE_USAGE, vam_href_link(FILENAME_COOKIE_USAGE)); require DIR_WS_INCLUDES . 'header.php'; $vamTemplate->assign('BUTTON_CONTINUE', '<a class="button" href="' . vam_href_link(FILENAME_DEFAULT) . '">' . vam_image_button('submit.png', IMAGE_BUTTON_CONTINUE) . '</a>'); $vamTemplate->assign('language', $_SESSION['language']); // set cache ID if (!CacheCheck()) { $vamTemplate->caching = 0; $main_content = $vamTemplate->fetch(CURRENT_TEMPLATE . '/module/cookie_usage.html'); } else { $vamTemplate->caching = 1; $vamTemplate->cache_lifetime = CACHE_LIFETIME; $vamTemplate->cache_modified_check = CACHE_CHECK; $cache_id = $_SESSION['language']; $main_content = $vamTemplate->fetch(CURRENT_TEMPLATE . '/module/cookie_usage.html', $cache_id); } $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->assign('main_content', $main_content); $vamTemplate->caching = 0; if (!defined(RM)) { $vamTemplate->load_filter('output', 'note'); } $template = file_exists('templates/' . CURRENT_TEMPLATE . '/' . FILENAME_COOKIE_USAGE . '.html') ? CURRENT_TEMPLATE . '/' . FILENAME_COOKIE_USAGE . '.html' : CURRENT_TEMPLATE . '/index.html'; $vamTemplate->display($template);
if ($check_status['orders_status'] != $status) { vam_db_query("update " . TABLE_ORDERS . " set orders_status = '" . vam_db_input($status) . "', last_modified = now() where orders_id = '" . (int) $this_orderID . "'"); $customer_notified = '0'; if (isset($_POST['notify'])) { $notify_comments = ''; // assign language to template for caching $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->caching = false; $vamTemplate->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/'); $vamTemplate->assign('logo_path', HTTP_SERVER . DIR_WS_CATALOG . 'templates/' . CURRENT_TEMPLATE . '/img/'); $vamTemplate->assign('NAME', $check_status['customers_name']); $vamTemplate->assign('ORDER_NR', $this_orderID); $vamTemplate->assign('ORDER_LINK', vam_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $_POST['multi_orders'], 'SSL')); $vamTemplate->assign('ORDER_DATE', vam_date_long($check_status['date_purchased'])); $vamTemplate->assign('ORDER_STATUS', $orders_status_array[$status]); $html_mail = $vamTemplate->fetch(CURRENT_TEMPLATE . '/admin/mail/' . $_SESSION['language'] . '/change_order_mail.html'); $txt_mail = $vamTemplate->fetch(CURRENT_TEMPLATE . '/admin/mail/' . $_SESSION['language'] . '/change_order_mail.txt'); // create subject $billing_subject = str_replace('{$nr}', $this_orderID, EMAIL_BILLING_SUBJECT); vam_php_mail(EMAIL_BILLING_ADDRESS, EMAIL_BILLING_NAME, $check_status['customers_email_address'], $check_status['customers_name'], '', EMAIL_BILLING_REPLY_ADDRESS, EMAIL_BILLING_REPLY_ADDRESS_NAME, '', '', $billing_subject, $html_mail, $txt_mail); $customer_notified = '1'; } vam_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, comments) values ('" . (int) $this_orderID . "', '" . vam_db_input($status) . "', now(), '" . vam_db_input($customer_notified) . "', '" . vam_db_input($comments) . "')"); $order_updated = true; // denuz added accumulated discount $changed = false; $check_group_query = vam_db_query("select customers_status_id from " . TABLE_CUSTOMERS_STATUS_ORDERS_STATUS . " where orders_status_id = " . $status); if (vam_db_num_rows($check_group_query)) { while ($groups = vam_db_fetch_array($check_group_query)) { // calculating total customers purchase // building query
(c) 2000-2001 The Exchange Project (earlier name of osCommerce) (c) 2002-2003 osCommerce(search.php,v 1.22 2003/02/10); www.oscommerce.com (c) 2003 nextcommerce (search.php,v 1.9 2003/08/17); www.nextcommerce.org (c) 2004 xt:Commerce (search.php,v 1.9 2003/08/13); xt-commerce.com Released under the GNU General Public License ---------------------------------------------------------------------------------------*/ $box = new vamTemplate(); $box->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/'); $box_content = ''; require_once DIR_FS_INC . 'vam_image_submit.inc.php'; require_once DIR_FS_INC . 'vam_hide_session_id.inc.php'; $box->assign('FORM_ACTION', vam_draw_form('quick_find', vam_href_link(FILENAME_ADVANCED_SEARCH_RESULT, '', 'NONSSL', false), 'get') . vam_hide_session_id()); $box->assign('INPUT_SEARCH', vam_draw_input_field('keywords', '', 'id="quick_find_keyword"')); $box->assign('BUTTON_SUBMIT', vam_image_submit('', IMAGE_BUTTON_SEARCH)); $box->assign('FORM_END', '</form>'); $box->assign('LINK_ADVANCED', vam_href_link(FILENAME_ADVANCED_SEARCH)); $box->assign('BOX_CONTENT', $box_content); $box->assign('language', $_SESSION['language']); // set cache ID if (!CacheCheck()) { $box->caching = 0; $box_search = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_search.html'); } else { $box->caching = 1; $box->cache_lifetime = CACHE_LIFETIME; $box->cache_modified_check = CACHE_CHECK; $cache_id = $_SESSION['language']; $box_search = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_search.html', $cache_id); } $vamTemplate->assign('box_SEARCH', $box_search);
$from = vam_db_prepare_input($_POST['from']); $subject = vam_db_prepare_input($_POST['subject']); while ($mail = vam_db_fetch_array($mail_query)) { $id1 = create_coupon_code($mail['customers_email_address']); // assign language to template for caching $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->caching = false; $vamTemplate->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/'); $vamTemplate->assign('logo_path', HTTP_SERVER . DIR_WS_CATALOG . 'templates/' . CURRENT_TEMPLATE . '/img/'); $vamTemplate->assign('AMMOUNT', $currencies->format($_POST['amount'])); $vamTemplate->assign('MESSAGE', $_POST['message']); $vamTemplate->assign('GIFT_ID', $id1); $vamTemplate->assign('WEBSITE', HTTP_SERVER . DIR_WS_CATALOG); $link = HTTP_SERVER . DIR_WS_CATALOG . 'gv_redeem.php' . '?gv_no=' . $id1; $vamTemplate->assign('GIFT_LINK', $link); $html_mail = $vamTemplate->fetch(CURRENT_TEMPLATE . '/admin/mail/' . $_SESSION['language'] . '/send_gift.html'); $txt_mail = $vamTemplate->fetch(CURRENT_TEMPLATE . '/admin/mail/' . $_SESSION['language'] . '/send_gift.txt'); if ($subject == '') { $subject = EMAIL_BILLING_SUBJECT; } vam_php_mail(EMAIL_BILLING_ADDRESS, EMAIL_BILLING_NAME, $mail['customers_email_address'], $mail['customers_firstname'] . ' ' . $mail['customers_lastname'], '', EMAIL_BILLING_REPLY_ADDRESS, EMAIL_BILLING_REPLY_ADDRESS_NAME, '', '', $subject, $html_mail, $txt_mail); // Now create the coupon main and email entry $insert_query = vam_db_query("insert into " . TABLE_COUPONS . " (coupon_code, coupon_type, coupon_amount, date_created) values ('" . $id1 . "', 'G', '" . $_POST['amount'] . "', now())"); $insert_id = vam_db_insert_id($insert_query); $insert_query = vam_db_query("insert into " . TABLE_COUPON_EMAIL_TRACK . " (coupon_id, customer_id_sent, sent_firstname, emailed_to, date_sent) values ('" . $insert_id . "', '0', 'Admin', '" . $mail['customers_email_address'] . "', now() )"); } if ($_POST['email_to']) { $id1 = create_coupon_code($_POST['email_to']); // assign language to template for caching $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->caching = false;