function sendemail($emailtext, $email)
{
    $usersql = SELECT_ALL . TABLE_CUSTOMERS . SQL_WHERE . "customers_email_address ='" . $email . APOS;
    $myuser = olc_db_query($usersql);
    $myuser_values = olc_db_fetch_array($myuser);
    $stack = explode(COLON, $myuser_values['customers_password']);
    $link0 = HTTP_CATALOG_SERVER . DIR_WS_CATALOG;
    $link = $link0 . FILENAME_CUSTOMER_DEFAULT;
    $smarty->assign('HOME_LINK', $link);
    $link = $link0 . FILENAME_LOGIN . "?action=auction&email_address=" . $email . "&password="******"stylesheet.css";
    $debug_output = "file: " . $file . HTML_BR;
    if (file_exists($file)) {
        $style = file_get_contents($file);
        $poss = strpos($style, "body");
        if (!($poss === false)) {
            $pose = strpos($style, "}", $poss);
            if (!($pose === false)) {
                $style_body = substr($style, 0, $pose + 1);
                $s = "\t\t\t";
                $style_body = str_replace("../../", HTTP_SERVER . DIR_WS_CATALOG, $style_body);
                $style_body = $s . str_replace(NEW_LINE, NEW_LINE . $s, $style_body);
                $smarty->assign('STYLE', $style_body);
            }
        }
    }
    $template = ADMIN_PATH_PREFIX . 'order_mail_ebay';
    $html_mail = $smarty->fetch($template . HTML_EXT);
    $firstname = $myuser_values['customers_firstname'];
    $lastname = $myuser_values['customers_lastname'];
    // create subject
    $order_subject = str_replace('{$nr}', $insert_id, EMAIL_BILLING_SUBJECT_ORDER);
    $order_subject = str_replace('{$date}', strftime(DATE_FORMAT_LONG), $order_subject);
    $order_subject = str_replace('{$firstname}', $firstname, $order_subject);
    $order_subject = str_replace('{$lastname}', $lastname, $order_subject);
    $eMail = $order->customer['email_address'];
    $name = trim($firstname . BLANK . $lastname);
    // send mail to admin
    olc_php_mail($email, $name, EMAIL_BILLING_FORWARDING_STRING, STORE_NAME, EMPTY_STRING, EMPTY_STRING, EMPTY_STRING, EMPTY_STRING, EMPTY_STRING, AUCTIONS_TEXT_AUCTION_SOLD_EMAIL_SUBJECT, $html_mail, EMPTY_STRING, EMAIL_TYPE_HTML);
    // send mail to customer
    olc_php_mail(EMAIL_BILLING_ADDRESS, EMAIL_BILLING_NAME, $email, $name, EMPTY_STRING, EMAIL_BILLING_REPLY_ADDRESS, EMAIL_BILLING_REPLY_ADDRESS_NAME, EMPTY_STRING, EMPTY_STRING, AUCTIONS_TEXT_AUCTION_SOLD_EMAIL_SUBJECT, $html_mail, EMPTY_STRING, EMAIL_TYPE_HTML);
    /*
    $emailcontent = "Guten Tag ".trim($myuser_values['customers_firstname'].BLANK.$myuser_values['customers_lastname'])."!\n\n";
    $emailcontent .= "Sie haben folgende Artikel bei unserer Ebay-Auktion ersteigert:\n";
    $emailcontent .= $emailtext."\n\n";
    $emailcontent .= "Die Artikel warten bereits im Warenkorb unseres Onlineshops auf Sie.\n";
    $emailcontent .= "Über diesen Link ".$link." kommen sie direkt zu den ersteigerten Artikeln.\n\n";
    $emailcontent .= "Dankesfloskel\n";
    $emailcontent .= "Mit freundlichen Grüßen\n";
    $emailcontent .= STORE_NAME.NEW_LINE.STORE_OWNER;
    olc_mail($myuser_values['customers_firstname'].BLANK.$myuser_values['customers_lastname'],$email,
    "Ebay Auktion - Abwicklung", $emailcontent, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
    */
}
include 'includes/application_top.php';
// include needed functions
require_once DIR_FS_INC . 'olc_break_string.inc.php';
require_once DIR_FS_INC . 'olc_date_long.inc.php';
require_once DIR_FS_INC . 'olc_image_button.inc.php';
// lets retrieve all $HTTP_GET_VARS keys and values..
$get_params = olc_get_all_get_params(array('reviews_id'));
$get_params = substr($get_params, 0, -1);
//remove trailing &
$reviews_query = olc_db_query("select rd.reviews_text, r.reviews_rating, r.reviews_id, r.products_id, r.customers_name, r.date_added, r.last_modified, r.reviews_read, p.products_id, pd.products_name, p.products_image from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd left join " . TABLE_PRODUCTS . " p on (r.products_id = p.products_id) left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on (p.products_id = pd.products_id and pd.language_id = '" . SESSION_LANGUAGE_ID . "') where r.reviews_id = '" . (int) $_GET['reviews_id'] . "' and r.reviews_id = rd.reviews_id and p.products_status = '1'");
if (!olc_db_num_rows($reviews_query)) {
    olc_redirect(olc_href_link(FILENAME_REVIEWS));
}
$reviews = olc_db_fetch_array($reviews_query);
$breadcrumb->add(NAVBAR_TITLE_PRODUCT_REVIEWS, olc_href_link(FILENAME_PRODUCT_REVIEWS, $get_params));
olc_db_query(SQL_UPDATE . TABLE_REVIEWS . " set reviews_read = reviews_read+1 where reviews_id = '" . $reviews['reviews_id'] . APOS);
$reviews_text = olc_break_string(htmlspecialchars($reviews['reviews_text']), 60, '-<br/>');
require DIR_WS_INCLUDES . 'header.php';
$smarty->assign('PRODUCTS_NAME', $reviews['products_name']);
$smarty->assign('AUTHOR', $reviews['customers_name']);
$smarty->assign('DATE', olc_date_long($reviews['date_added']));
$smarty->assign('REVIEWS_TEXT', nl2br($reviews_text));
$smarty->assign('RATING', olc_image(DIR_WS_IMAGES . 'stars_' . $reviews['reviews_rating'] . '.gif', sprintf(BOX_REVIEWS_TEXT_OF_5_STARS, $reviews['reviews_rating'])));
$link = olc_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $reviews['products_id'], NONSSL, false, true, false);
$smarty->assign('PRODUCTS_LINK', $link);
$smarty->assign('BUTTON_BACK', HTML_A_START . olc_href_link(FILENAME_PRODUCT_REVIEWS, $get_params) . '">' . olc_image_button('button_back.gif', IMAGE_BUTTON_BACK) . HTML_A_END);
$smarty->assign('PRODUCTS_BUTTON_BUY_NOW', HTML_A_START . olc_href_link(FILENAME_DEFAULT, 'action=buy_now&BUYproducts_id=' . $reviews['products_id']) . '">' . olc_image_button('button_in_cart.gif', IMAGE_BUTTON_IN_CART) . HTML_A_END);
$smarty->assign('IMAGE', HTML_A_START . 'javascript:popupImageWindow(\'' . olc_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $reviews['products_id']) . '\')">' . olc_image(DIR_WS_THUMBNAIL_IMAGES . $reviews['products_image'], $reviews['products_name'], '', '', 'align="center" hspace="5" vspace="5"') . '<br/></a>');
$main_content = $smarty->fetch(CURRENT_TEMPLATE_MODULE . 'product_reviews_info' . HTML_EXT, SMARTY_CACHE_ID);
require BOXES;
$smarty->display(INDEX_HTML);
     }
     $messageStack->add_session(SUCCESS_BILLING, 'success');
     olc_redirect(olc_href_link(FILENAME_AFFILIATE_PAYMENT, olc_get_all_get_params(array('action')) . 'action=edit'));
     break;
 case 'update_payment':
     $pID = olc_db_prepare_input($_GET['pID']);
     $status = olc_db_prepare_input($_POST['status']);
     $payment_updated = false;
     $check_status_query = olc_db_query("select af.affiliate_email_address, ap.affiliate_lastname, ap.affiliate_firstname, ap.affiliate_payment_status, ap.affiliate_payment_date, ap.affiliate_payment_date from " . TABLE_AFFILIATE_PAYMENT . " ap, " . TABLE_AFFILIATE . " af where affiliate_payment_id = '" . olc_db_input($pID) . "' and af.affiliate_id = ap.affiliate_id ");
     $check_status = olc_db_fetch_array($check_status_query);
     if ($check_status['affiliate_payment_status'] != $status) {
         olc_db_query(SQL_UPDATE . TABLE_AFFILIATE_PAYMENT . " set affiliate_payment_status = '" . olc_db_input($status) . "', affiliate_last_modified = now() where affiliate_payment_id = '" . olc_db_input($pID) . APOS);
         $affiliate_notified = '0';
         // Notify Affiliate
         if ($_POST['notify'] == 'on') {
             $email = STORE_NAME . NEW_LINE . EMAIL_SEPARATOR . NEW_LINE . EMAIL_TEXT_AFFILIATE_PAYMENT_NUMBER . BLANK . $pID . NEW_LINE . EMAIL_TEXT_INVOICE_URL . BLANK . olc_catalog_href_link(FILENAME_CATALOG_AFFILIATE_PAYMENT_INFO, 'payment_id=' . $pID, SSL) . NEW_LINE . EMAIL_TEXT_PAYMENT_BILLED . BLANK . olc_date_long($check_status['affiliate_payment_date']) . "\n\n" . sprintf(EMAIL_TEXT_STATUS_UPDATE, $payments_status_array[$status]);
             olc_mail($check_status['affiliate_firstname'] . BLANK . $check_status['affiliate_lastname'], $check_status['affiliate_email_address'], EMAIL_TEXT_SUBJECT, nl2br($email), STORE_OWNER, AFFILIATE_EMAIL_ADDRESS);
             $affiliate_notified = '1';
         }
         olc_db_query(INSERT_INTO . TABLE_AFFILIATE_PAYMENT_STATUS_HISTORY . " (affiliate_payment_id, affiliate_new_value, affiliate_old_value, affiliate_date_added, affiliate_notified) values ('" . olc_db_input($pID) . "', '" . olc_db_input($status) . "', '" . $check_status['affiliate_payment_status'] . "', now(), '" . $affiliate_notified . "')");
         $order_updated = true;
     }
     if ($order_updated) {
         $messageStack->add_session(SUCCESS_PAYMENT_UPDATED, 'success');
     }
     olc_redirect(olc_href_link(FILENAME_AFFILIATE_PAYMENT, olc_get_all_get_params(array('action')) . 'action=edit'));
     break;
 case 'deleteconfirm':
     $pID = olc_db_prepare_input($_GET['pID']);
     olc_db_query(DELETE_FROM . TABLE_AFFILIATE_PAYMENT . " where affiliate_payment_id = '" . olc_db_input($pID) . APOS);
     olc_db_query(DELETE_FROM . TABLE_AFFILIATE_PAYMENT_STATUS_HISTORY . " where affiliate_payment_id = '" . olc_db_input($pID) . APOS);
            $attributes_model = EMPTY_STRING;
            while ($attributes_data_values = olc_db_fetch_array($attributes_query)) {
                $attributes_data .= HTML_BR . $attributes_data_values['products_options'] . ': ' . $attributes_data_values['products_options_values'];
                $attributes_model .= HTML_BR . olc_get_attributes_model($order_data_values['products_id'], $attributes_data_values['products_options_values']);
            }
            $order_data[] = array('PRODUCTS_MODEL' => $order_data_values['products_model'], 'PRODUCTS_NAME' => $order_data_values['products_name'], 'PRODUCTS_ATTRIBUTES' => $attributes_data, 'PRODUCTS_ATTRIBUTES_MODEL' => $attributes_model, 'PRODUCTS_PRICE' => olc_format_price_order($order_data_values['final_price'], 1, $order->info['currency']), 'PRODUCTS_QTY' => $order_data_values['products_quantity']);
        }
        // get order_total data
        $oder_total_query = olc_db_query("SELECT\n                      title,\n                      text,\n                      class,\n                      value,\n                      sort_order\n                      FROM " . TABLE_ORDERS_TOTAL . "\n                      WHERE orders_id='" . $oID . "'\n                      ORDER BY sort_order ASC");
        $order_total = array();
        while ($oder_total_values = olc_db_fetch_array($oder_total_query)) {
            $order_total[] = array('TITLE' => $oder_total_values['title'], 'CLASS' => $oder_total_values['class'], 'VALUE' => $oder_total_values['value'], 'TEXT' => $oder_total_values['text']);
            if ($oder_total_values['class'] = 'ot_total') {
                $total = $oder_total_values['value'];
            }
        }
        $smarty->assign('oID', $oID);
        if ($order->info['payment_method'] != EMPTY_STRING && $order->info['payment_method'] != 'no_payment') {
            include DIR_FS_CATALOG . 'lang/' . SESSION_LANGUAGE . '/modules/payment/' . $order->info['payment_method'] . PHP;
            $payment_method = constant(strtoupper('MODULE_PAYMENT_' . $order->info['payment_method'] . '_TEXT_TITLE'));
            $smarty->assign('PAYMENT_METHOD', $payment_method);
        }
        $smarty->assign('DATE', olc_date_long($order->info['date_purchased']));
        $smarty->assign('order_data', $order_data);
        $smarty->assign('order_total', $order_total);
        $smarty->display(ADMIN_PATH_PREFIX . FULL_CURRENT_TEMPLATE . 'admin/print_packingslip' . HTML_EXT);
    }
} else {
    $smarty->assign('ERROR', TEXT_NO_ORDER_DISPLAY);
    $smarty->display(CURRENT_TEMPLATE_MODULE . 'error_message' . HTML_EXT);
}
<!-- left box -->
<?php 
        // 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['download_count'] > 0 && file_exists(DIR_FS_DOWNLOAD . $downloads['orders_products_filename']) && ($downloads['download_maxdays'] == 0 || $download_timestamp > time())) {
            echo '            <td class="main"><a href="' . olc_href_link(FILENAME_DOWNLOAD, 'order=' . $last_order . '&id=' . $downloads['orders_products_download_id']) . '">' . $downloads['products_name'] . '</a></td>' . NEW_LINE;
        } else {
            echo '            <td class="main">' . $downloads['products_name'] . '</td>' . NEW_LINE;
        }
        ?>
<!-- right box -->
<?php 
        echo '            <td class="main">' . TABLE_HEADING_DOWNLOAD_DATE . olc_date_long($download_expiry) . '</td>' . NEW_LINE . '            <td class="main" align="right">' . $downloads['download_count'] . TABLE_HEADING_DOWNLOAD_COUNT . '</td>' . NEW_LINE . '          </tr>' . NEW_LINE;
    }
    ?>
          </tr>
        </table></td>
      </tr>
<?php 
    if (!strstr($PHP_SELF, FILENAME_ACCOUNT_HISTORY_INFO)) {
        ?>
      <tr>
        <td><?php 
        echo olc_draw_separator('pixel_trans.gif', '100%', '10');
        ?>
</td>
      </tr>
      <tr>
        ?>
                    <tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'">
<?php 
        switch ($srView) {
            case '3':
                ?>
                      <td class="dataTableContent" align="right"><?php 
                echo olc_date_long(date("Y-m-d\\ H:i:s", $sr->showDate)) . " - " . olc_date_short(date("Y-m-d\\ H:i:s", $sr->showDateEnd));
                ?>
</td>
<?php 
                break;
            case '4':
                ?>
                      <td class="dataTableContent" align="right"><?php 
                echo olc_date_long(date("Y-m-d\\ H:i:s", $sr->showDate));
                ?>
</td>
<?php 
                break;
            default:
                ?>
                      <td class="dataTableContent" align="right"><?php 
                echo olc_date_short(date("Y-m-d\\ H:i:s", $sr->showDate)) . " - " . olc_date_short(date("Y-m-d\\ H:i:s", $sr->showDateEnd));
                ?>
</td>
<?php 
        }
        ?>
                      <td class="dataTableContent" align="right"><?php 
        echo $info[0]['order'];
function OrderUpdate()
{
    global $_POST, $LangID;
    $schema = '<?xml version="1.0" encoding="' . CHARSET . '"?>' . "\n" . "\n";
    if (isset($_POST['order_id']) && isset($_POST['status'])) {
        // Per Post übergebene Variablen
        $oID = $_POST['order_id'];
        $status = $_POST['status'];
        $comments = olc_db_prepare_input($_POST['comments']);
        //Status überprüfen
        $check_status_query = olc_db_query("select * from " . TABLE_ORDERS . " where orders_id = '" . olc_db_input($oID) . "'");
        if ($check_status = olc_db_fetch_array($check_status_query)) {
            if ($check_status['orders_status'] != $status || $comments != '') {
                olc_db_query("update " . TABLE_ORDERS . " set orders_status = '" . olc_db_input($status) . "', last_modified = now() where orders_id = '" . olc_db_input($oID) . "'");
                $customer_notified = '0';
                if ($_POST['notify'] == 'on') {
                    // Falls eine Sprach ID zur Order existiert die Emailbestätigung in dieser Sprache ausführen
                    if (isset($check_status['orders_language_id']) && $check_status['orders_language_id'] > 0) {
                        $orders_status_query = olc_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . $check_status['orders_language_id'] . "'");
                        if (olc_db_num_rows($orders_status_query) == 0) {
                            $orders_status_query = olc_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . $languages_id . "'");
                        }
                    } else {
                        $orders_status_query = olc_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . $languages_id . "'");
                    }
                    $orders_statuses = array();
                    $orders_status_array = array();
                    while ($orders_status = olc_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'];
                    }
                    // status query
                    $orders_status_query = olc_db_query("select orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . $LangID . "' and orders_status_id='" . $status . "'");
                    $o_status = olc_db_fetch_array($orders_status_query);
                    $o_status = $o_status['orders_status_name'];
                    //ok lets generate the html/txt mail from Template
                    if ($_POST['notify_comments'] == 'on') {
                        $notify_comments = sprintf(EMAIL_TEXT_COMMENTS_UPDATE, $comments) . "\n\n";
                    } else {
                        $comments = '';
                    }
                    // require functionblock for mails
                    require_once DIR_WS_CLASSES . 'class.phpmailer.php';
                    require_once DIR_FS_INC . 'olc_php_mail.inc.php';
                    require_once DIR_FS_INC . 'olc_add_tax.inc.php';
                    require_once DIR_FS_INC . 'olc_not_null.inc.php';
                    require_once DIR_FS_INC . 'changedataout.inc.php';
                    require_once DIR_FS_INC . 'olc_href_link.inc.php';
                    require_once DIR_FS_INC . 'olc_date_long.inc.php';
                    require_once DIR_FS_INC . 'olc_check_agent.inc.php';
                    $smarty = new Smarty();
                    $smarty->assign('language', $check_status['language']);
                    $smarty->caching = false;
                    $smarty->template_dir = DIR_FS_CATALOG . 'templates';
                    $smarty->compile_dir = DIR_FS_CATALOG . 'cache/templates_c';
                    $smarty->config_dir = DIR_FS_CATALOG . 'lang';
                    $smarty->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/');
                    $smarty->assign('logo_path', HTTP_SERVER . DIR_WS_CATALOG . 'templates/' . CURRENT_TEMPLATE . '/images/');
                    $smarty->assign('NAME', $check_status['customers_name']);
                    $smarty->assign('ORDER_NR', $oID);
                    $smarty->assign('ORDER_LINK', olc_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL'));
                    $smarty->assign('ORDER_DATE', olc_date_long($check_status['date_purchased']));
                    $smarty->assign('NOTIFY_COMMENTS', $comments);
                    $smarty->assign('ORDER_STATUS', $o_status);
                    $html_mail = $smarty->fetch(CURRENT_TEMPLATE . '/admin/mail/' . $check_status['language'] . '/change_order_mail.html');
                    $txt_mail = $smarty->fetch(CURRENT_TEMPLATE . '/admin/mail/' . $check_status['language'] . '/change_order_mail.txt');
                    // send mail with html/txt template
                    olc_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, '', '', EMAIL_BILLING_SUBJECT, $html_mail, $txt_mail);
                    $customer_notified = '1';
                }
                olc_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, comments) values ('" . olc_db_input($oID) . "', '" . olc_db_input($status) . "', now(), '" . $customer_notified . "', '" . olc_db_input($comments) . "')");
                $schema .= '<STATUS>' . "\n" . '<STATUS_DATA>' . "\n" . '<ORDER_ID>' . $oID . '</ORDER_ID>' . "\n" . '<ORDER_STATUS>' . $status . '</ORDER_STATUS>' . "\n" . '<ACTION>' . $_POST['action'] . '</ACTION>' . "\n" . '<CODE>' . '0' . '</CODE>' . "\n" . '<MESSAGE>' . 'OK' . '</MESSAGE>' . "\n" . '</STATUS_DATA>' . "\n" . '</STATUS>' . "\n";
            } else {
                if ($check_status['orders_status'] == $status) {
                    // Status ist bereits gesetzt
                    $schema .= '<STATUS>' . "\n" . '<STATUS_DATA>' . "\n" . '<ORDER_ID>' . $oID . '</ORDER_ID>' . "\n" . '<ORDER_STATUS>' . $status . '</ORDER_STATUS>' . "\n" . '<ACTION>' . $_POST['action'] . '</ACTION>' . "\n" . '<CODE>' . '1' . '</CODE>' . "\n" . '<MESSAGE>' . 'NO STATUS CHANGE' . '</MESSAGE>' . "\n" . '</STATUS_DATA>' . "\n" . '</STATUS>' . "\n";
                }
            }
        } else {
            // Fehler Order existiert nicht
            $schema .= '<STATUS>' . "\n" . '<STATUS_DATA>' . "\n" . '<ORDER_ID>' . $oID . '</ORDER_ID>' . "\n" . '<ACTION>' . $_POST['action'] . '</ACTION>' . "\n" . '<CODE>' . '2' . '</CODE>' . "\n" . '<MESSAGE>' . 'ORDER_ID NOT FOUND OR SET' . '</MESSAGE>' . "\n" . '</STATUS_DATA>' . "\n" . '</STATUS>' . "\n";
        }
    } else {
        $schema = '<?xml version="1.0" encoding="' . CHARSET . '"?>' . "\n" . '<STATUS>' . "\n" . '<STATUS_DATA>' . "\n" . '<ACTION>' . $_POST['action'] . '</ACTION>' . "\n" . '<CODE>' . '99' . '</CODE>' . "\n" . '<MESSAGE>' . 'PARAMETER ERROR' . '</MESSAGE>' . "\n" . '</STATUS_DATA>' . "\n" . '</STATUS>' . "\n\n";
    }
    echo $schema;
}
$module_content = array();
if (($orders_total = olc_count_customer_orders()) > 0) {
    $history_query_raw = "select o.orders_id, o.date_purchased, o.delivery_name, o.billing_name, ot.text as order_total, s.orders_status_name from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot, " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int) $_SESSION['customer_id'] . "' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '" . SESSION_LANGUAGE_ID . "' order by orders_id DESC";
    $history_split = new splitPageResults($history_query_raw, $_GET['page'], MAX_DISPLAY_ORDER_HISTORY);
    $history_query = olc_db_query($history_split->sql_query);
    while ($history = olc_db_fetch_array($history_query)) {
        $products_query = olc_db_query("select count(*) as count from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . $history['orders_id'] . APOS);
        $products = olc_db_fetch_array($products_query);
        if (olc_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' => olc_date_long($history['date_purchased']), 'ORDER_PRODUCTS' => $products['count'], 'ORDER_TOTAL' => strip_tags($history['order_total']), 'ORDER_BUTTON' => HTML_A_START . olc_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'page=' . $_GET['page'] . '&order_id=' . $history['orders_id'], SSL) . '">' . olc_image_button('small_view.gif', SMALL_IMAGE_BUTTON_VIEW) . HTML_A_END);
    }
}
if ($orders_total > 0) {
    $smarty->assign('SPLIT_BAR', '
          <tr>
            <td class="smallText" valign="top">' . $history_split->display_count(TEXT_DISPLAY_NUMBER_OF_ORDERS) . '</td>
            <td class="smallText" align="right">' . TEXT_RESULT_PAGE . BLANK . $history_split->display_links(MAX_DISPLAY_PAGE_LINKS, olc_get_all_get_params(array('page', 'info', 'x', 'y'))) . '</td>
          </tr>');
}
$smarty->assign('order_content', $module_content);
$smarty->assign('BUTTON_BACK', HTML_A_START . olc_href_link(FILENAME_ACCOUNT, '', SSL) . '">' . olc_image_button('button_back.gif', IMAGE_BUTTON_BACK) . HTML_A_END);
$main_content = $smarty->fetch(CURRENT_TEMPLATE_MODULE . 'account_history' . HTML_EXT, SMARTY_CACHE_ID);
$smarty->assign(MAIN_CONTENT, $main_content);
require BOXES;
$smarty->display(INDEX_HTML);