/**
* Return table heading with sorting capabilities
*
* @param $sortby
* @param $colnum,
* @param $heading
* @return string
*/
function oos_create_sort_heading($sortby, $colnum, $heading)
{
global $sPage, $aLang;
$sort_prefix = '';
$sort_suffix = '';
if ($sortby) {
$sort_prefix = '<a href="' . oos_href_link($sPage, oos_get_all_get_parameters(array('page', 'info', 'sort')) . 'page=1&sort=' . $colnum . ($sortby == $colnum . 'a' ? 'd' : 'a')) . '" title="' . $aLang['text_sort_products'] . ($sortby == $colnum . 'd' || substr($sortby, 0, 1) != $colnum ? $aLang['text_ascendingly'] : $aLang['text_descendingly']) . $aLang['text_by'] . $heading . '">';
$sort_suffix = (substr($sortby, 0, 1) == $colnum ? substr($sortby, 1, 1) == 'a' ? '+' : '-' : '') . '</a>';
}
return $sort_prefix . $heading . $sort_suffix;
}
function set_snapshot($aSetPage = '')
{
global $sPage, $request_type;
if (is_array($aSetPage)) {
$this->snapshot = array('page' => $aSetPage['page'], 'mode' => $aSetPage['mode'], 'get' => $aSetPage['get']);
} else {
$get_all = '';
if (isset($_GET)) {
$get_all = oos_get_all_get_parameters();
$get_all = oos_remove_trailing($get_all);
}
$this->snapshot = array('page' => $sPage, 'mode' => $request_type, 'get' => $get_all);
}
}
if ($option_values['options_values_price'] != 0) {
$attributes_print .= '<td align="right"><small><i>' . $option_values['price_prefix'] . $oCurrencies->display_price($option_values['options_values_price'], oos_get_tax_rate($wishlist_product['products_tax_class_id'])) . '</i></small></td>';
} else {
$attributes_print .= '<td><small><i> </i></small></td>';
}
$attributes_print .= ' </tr>';
$attributes_result->MoveNext();
}
$aWishlist[] = array('products_id' => $wishlist_product['products_id'], 'wl_products_id' => $wl_products_id, 'products_image' => $wishlist_product['products_image'], 'products_name' => $wishlist_product['products_name'], 'product_price' => $wishlist_product_price, 'product_special_price' => $wishlist_product_special_price, 'max_product_discount' => $wishlist_product_discount, 'product_discount_price' => $wishlist_product_discount_price, 'base_product_price' => $wishlist_base_product_price, 'base_product_special_price' => $wishlist_base_product_special_price, 'products_base_price' => $wishlist_product['products_base_price'], 'products_base_unit' => $wishlist_product['products_base_unit'], 'attributes_print' => $attributes_print);
$wishlist_result->MoveNext();
}
// links breadcrumb
$oBreadcrumb->add($customer . $aLang['navbar_title'], oos_href_link($aPages['main_wishlist']), bookmark);
$aOption['template_main'] = $sTheme . '/modules/wishlist.html';
$aOption['page_heading'] = $sTheme . '/heading/page_heading.html';
$aOption['page_navigation'] = $sTheme . '/heading/page_navigation.html';
$aOption['breadcrumb'] = 'default/system/breadcrumb.html';
$nPageType = OOS_PAGE_TYPE_CATALOG;
require 'includes/oos_system.php';
if (!isset($option)) {
require 'includes/info_message.php';
require 'includes/oos_blocks.php';
}
// assign Smarty variables;
$oSmarty->assign(array('oos_breadcrumb' => $oBreadcrumb->trail(BREADCRUMB_SEPARATOR), 'oos_heading_title' => $customer . $aLang['heading_title'], 'oos_heading_image' => 'wishlist.gif', 'oos_page_split' => $wishlist_split->display_count($wishlist_numrows, MAX_DISPLAY_WISHLIST_PRODUCTS, $_GET['page'], $aLang['text_display_number_of_wishlist']), 'oos_display_links' => $wishlist_split->display_links($wishlist_numrows, MAX_DISPLAY_WISHLIST_PRODUCTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], oos_get_all_get_parameters(array('page', 'info'))), 'oos_page_numrows' => $wishlist_numrows, 'wishlist_array' => $aWishlist));
$oSmarty->assign('oosPageNavigation', $oSmarty->fetch($aOption['page_navigation']));
$oSmarty->assign('oosBreadcrumb', $oSmarty->fetch($aOption['breadcrumb']));
$oSmarty->assign('oosPageHeading', $oSmarty->fetch($aOption['page_heading']));
$oSmarty->assign('contents', $oSmarty->fetch($aOption['template_main']));
// display the template
require 'includes/oos_display.php';
require 'includes/oos_blocks.php';
}
$oos_pagetitle = $oBreadcrumb->trail_title(' » ');
$oos_pagetitle .= '»' . OOS_META_TITLE;
// assign Smarty variables;
$oSmarty->assign(
array(
'pagetitle' => htmlspecialchars($oos_pagetitle),
'meta_description' => htmlspecialchars($oos_meta_description),
'meta_keywords' => htmlspecialchars($oos_meta_keywords),
'oos_breadcrumb' => $oBreadcrumb->trail(BREADCRUMB_SEPARATOR),
'oos_heading_title' => $customer . $aLang['heading_title'],
'oos_heading_image' => 'wishlist.gif',
'oos_page_split' => $wishlist_split->display_count($wishlist_numrows, MAX_DISPLAY_WISHLIST_PRODUCTS, $_GET['page'], $aLang['text_display_number_of_wishlist']),
'oos_display_links' => $wishlist_split->display_links($wishlist_numrows, MAX_DISPLAY_WISHLIST_PRODUCTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], oos_get_all_get_parameters(array('page', 'info'))),
'oos_page_numrows' => $wishlist_numrows,
'wishlist_array' => $aWishlist
)
);
$oSmarty->assign('oosPageNavigation', $oSmarty->fetch($aOption['page_navigation']));
$oSmarty->assign('oosPageHeading', $oSmarty->fetch($aOption['page_heading']));
$oSmarty->assign('contents', $oSmarty->fetch($aOption['template_main']));
// display the template
require 'includes/oos_display.php';
ob_end_clean();
$aOption['template_main'] = $sTheme . '/modules/user_create_account.html';
$aOption['page_heading'] = $sTheme . '/heading/page_heading.html';
$nPageType = OOS_PAGE_TYPE_ACCOUNT;
require 'includes/oos_system.php';
if (!isset($option)) {
require 'includes/info_message.php';
require 'includes/oos_blocks.php';
require 'includes/oos_counter.php';
}
$read = '0';
$oSmarty->assign('read', $read);
$oSmarty->assign('oos_js', $javascript);
// assign Smarty variables;
$oSmarty->assign(array('oos_breadcrumb' => $oBreadcrumb->trail(BREADCRUMB_SEPARATOR), 'oos_heading_title' => $aLang['heading_title'], 'oos_heading_image' => 'account.gif'));
$oSmarty->assign('account', $account);
$oSmarty->assign('email_address', $email_address);
if (CUSTOMER_NOT_LOGIN == '1' or MAKE_PASSWORD == '1') {
$show_password = false;
} else {
$show_password = '******';
}
$oSmarty->assign('show_password', $show_password);
$oSmarty->assign('snapshot', $snapshot);
$oSmarty->assign('login_orgin_text', sprintf($aLang['text_origin_login'], oos_href_link($aModules['user'], $aFilename['login'], oos_get_all_get_parameters(), 'SSL')));
$oSmarty->assign('newsletter_ids', array(0, 1));
$oSmarty->assign('newsletter', array($aLang['entry_newsletter_no'], $aLang['entry_newsletter_yes']));
$oSmarty->assign('oosPageHeading', $oSmarty->fetch($aOption['page_heading']));
$oSmarty->assign('contents', $oSmarty->fetch($aOption['template_main']));
// display the template
require 'includes/oos_display.php';
'new_special_price' => $new_special_price,
'new_product_discount_price' => $new_product_discount_price,
'new_base_product_price' => $new_base_product_price,
'new_base_product_special_price' => $new_base_product_special_price,
'products_base_price' => $order_history['products_base_price'],
'new_products_base_unit' => $order_history['products_base_unit'],
'date_added' => $order_history['products_date_added'],
'manufacturer' => $order_history['manufacturers_name']);
$order_history_result->MoveNext();
}
// assign Smarty variables;
$oSmarty->assign(
array(
'oos_page_split' => $order_history_split->display_count($order_history_numrows, MAX_DISPLAY_SEARCH_RESULTS, $nCurrentPageNumber, $aLang['text_display_number_of_products']),
'oos_display_links' => $order_history_split->display_links($order_history_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $nCurrentPageNumber, oos_get_all_get_parameters(array('nv', 'info'))),
'oos_page_numrows' => $order_history_numrows,
'products_image_box' => SMALL_IMAGE_WIDTH + 10,
'oos_order_history_array' => $order_history_array
)
);
}
// links breadcrumb
$oBreadcrumb->add($aLang['header_title_catalog'], oos_href_link($aPages['shop']));
$oBreadcrumb->add($aLang['navbar_title']);
$oos_pagetitle = $oBreadcrumb->trail_title(' » ');
$oos_pagetitle .= '»' . OOS_META_TITLE;
}
if ($_SESSION['error_cart_msg'] == '') {
MyOOS_CoreApi::redirect(oos_href_link($goto_file, oos_get_all_get_parameters($parameters), 'NONSSL'));
} else {
MyOOS_CoreApi::redirect(oos_href_link($aPages['product_info'], 'products_id=' . $_POST['products_id']));
}
}
break;
case 'frend_wishlist_add_product':
if (isset($_POST['products_id']) && is_numeric($_POST['cart_quantity'])) {
$cart_qty = $_SESSION['cart']->get_quantity(oos_get_uprid($_POST['products_id'], $_POST['id']));
$news_qty = $cart_qty + $cart_quantity;
$products_order_min = oos_get_products_quantity_order_min($_POST['products_id']);
$products_order_units = oos_get_products_quantity_order_units($_POST['products_id']);
if ($cart_quantity >= $products_order_min or $cart_qty >= $products_order_min) {
if ($cart_quantity % $products_order_units == 0 and $news_qty >= $products_order_min) {
$_SESSION['cart']->add_cart($_POST['products_id'], intval($news_qty), $_POST['id'], true, $_POST['to_wl_id']);
} else {
$_SESSION['error_cart_msg'] = $aLang['error_products_quantity_order_min_text'] . $aLang['error_products_units_invalid'] . $cart_quantity . ' - ' . $aLang['products_order_qty_unit_text_info'] . ' ' . $products_order_units;
}
} else {
$_SESSION['error_cart_msg'] = $aLang['error_products_quantity_order_min_text'] . $aLang['error_products_quantity_invalid'] . $cart_quantity . ' - ' . $aLang['products_order_qty_min_text_info'] . ' ' . $products_order_min;
}
if ($_SESSION['error_cart_msg'] == '') {
MyOOS_CoreApi::redirect(oos_href_link($goto_file, oos_get_all_get_parameters($parameters), 'NONSSL'));
} else {
MyOOS_CoreApi::redirect(oos_href_link($aPages['product_info'], 'products_id=' . $_POST['products_id']));
}
}
break;
}
$oos_pagetitle = $oBreadcrumb->trail_title(' » ');
$oos_pagetitle .= '»' . OOS_META_TITLE;
// assign Smarty variables;
$oSmarty->assign(
array(
'pagetitle' => htmlspecialchars($oos_pagetitle),
'meta_description' => htmlspecialchars($oos_meta_description),
'meta_keywords' => htmlspecialchars($oos_meta_keywords),
'oos_breadcrumb' => $oBreadcrumb->trail(BREADCRUMB_SEPARATOR),
'oos_heading_title' => $aLang['heading_title'],
'oos_heading_image' => 'specials.gif',
'oos_page_split' => $reviews_split->display_count($reviews_numrows, MAX_DISPLAY_NEW_REVIEWS, $nCurrentPageNumber, $aLang['text_display_number_of_reviews']),
'oos_display_links' => $reviews_split->display_links($reviews_numrows, MAX_DISPLAY_NEW_REVIEWS, MAX_DISPLAY_PAGE_LINKS, $nCurrentPageNumber, oos_get_all_get_parameters(array('nv', 'info'))),
'oos_page_numrows' => $reviews_numrows,
'oos_reviews_array' => $aReviews
)
);
}
$oSmarty->assign('oosPageNavigation', $oSmarty->fetch($aOption['page_navigation'], $contents_cache_id));
$oSmarty->assign('oosPageHeading', $oSmarty->fetch($aOption['page_heading'], $contents_cache_id));
$oSmarty->assign('contents', $oSmarty->fetch($aOption['template_main'], $contents_cache_id));
$oSmarty->caching = false;
// display the template
require 'includes/oos_display.php';
$new_product_special_price = $oCurrencies->display_price($new_special_price, oos_get_tax_rate($order_history['products_tax_class_id']));
} else {
$new_max_product_discount = min($order_history['products_discount_allowed'], $_SESSION['member']->group['discount']);
if ($new_max_product_discount != 0) {
$new_special_price = $order_history['products_price'] * (100 - $new_max_product_discount) / 100;
$new_product_discount_price = $oCurrencies->display_price($new_special_price, oos_get_tax_rate($order_history['products_tax_class_id']));
}
}
if ($order_history['products_base_price'] != 1) {
$new_base_product_price = $oCurrencies->display_price($order_history['products_price'] * $order_history['products_base_price'], oos_get_tax_rate($order_history['products_tax_class_id']));
if ($new_special_price != '') {
$new_base_product_special_price = $oCurrencies->display_price($new_special_price * $order_history['products_base_price'], oos_get_tax_rate($order_history['products_tax_class_id']));
}
}
$order_history_array[] = array('id' => $order_history['products_id'], 'name' => $order_history['products_name'], 'image' => $order_history['products_image'], 'new_product_price' => $new_product_price, 'new_product_special_price' => $new_product_special_price, 'new_max_product_discount' => $new_max_product_discount, 'new_special_price' => $new_special_price, 'new_product_discount_price' => $new_product_discount_price, 'new_base_product_price' => $new_base_product_price, 'new_base_product_special_price' => $new_base_product_special_price, 'products_base_price' => $order_history['products_base_price'], 'new_products_base_unit' => $order_history['products_base_unit'], 'date_added' => $order_history['products_date_added'], 'manufacturer' => $order_history['manufacturers_name']);
$order_history_result->MoveNext();
}
// assign Smarty variables;
$oSmarty->assign(array('oos_page_split' => $order_history_split->display_count($order_history_numrows, MAX_DISPLAY_SEARCH_RESULTS, $nCurrentPageNumber, $aLang['text_display_number_of_products']), 'oos_display_links' => $order_history_split->display_links($order_history_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $nCurrentPageNumber, oos_get_all_get_parameters(array('nv', 'info'))), 'oos_page_numrows' => $order_history_numrows, 'products_image_box' => SMALL_IMAGE_WIDTH + 10, 'oos_order_history_array' => $order_history_array));
}
// links breadcrumb
$oBreadcrumb->add($aLang['header_title_catalog'], oos_href_link($aPages['shop']));
$oBreadcrumb->add($aLang['navbar_title'], oos_href_link($aPages['account_order_history']), bookmark);
// assign Smarty variables;
$oSmarty->assign(array('oos_breadcrumb' => $oBreadcrumb->trail(BREADCRUMB_SEPARATOR), 'oos_heading_title' => $aLang['heading_title'], 'oos_heading_image' => 'products_new.gif'));
$oSmarty->assign('oosBreadcrumb', $oSmarty->fetch($aOption['breadcrumb']));
$oSmarty->assign('oosPageNavigation', $oSmarty->fetch($aOption['page_navigation']));
$oSmarty->assign('oosPageHeading', $oSmarty->fetch($aOption['page_heading']));
$oSmarty->assign('contents', $oSmarty->fetch($aOption['template_main']));
// display the template
require 'includes/oos_display.php';
}
if ($_SESSION['error_cart_msg'] == '') {
oos_redirect(oos_href_link($goto_mp, $goto_file, oos_get_all_get_parameters($parameters), 'NONSSL'));
} else {
oos_redirect(oos_href_link($aModules['products'], $aFilename['product_info'], 'products_id=' . $_POST['products_id']));
}
}
break;
case 'frend_wishlist_add_product':
if (isset($_POST['products_id']) && is_numeric($_POST['cart_quantity'])) {
$cart_qty = $_SESSION['cart']->get_quantity(oos_get_uprid($_POST['products_id'], $_POST['id']));
$news_qty = $cart_qty + $cart_quantity;
$products_order_min = oos_get_products_quantity_order_min($_POST['products_id']);
$products_order_units = oos_get_products_quantity_order_units($_POST['products_id']);
if ($cart_quantity >= $products_order_min or $cart_qty >= $products_order_min) {
if ($cart_quantity % $products_order_units == 0 and $news_qty >= $products_order_min) {
$_SESSION['cart']->add_cart($_POST['products_id'], intval($news_qty), $_POST['id'], true, $_POST['to_wl_id']);
} else {
$_SESSION['error_cart_msg'] = $aLang['error_products_quantity_order_min_text'] . $aLang['error_products_units_invalid'] . $cart_quantity . ' - ' . $aLang['products_order_qty_unit_text_info'] . ' ' . $products_order_units;
}
} else {
$_SESSION['error_cart_msg'] = $aLang['error_products_quantity_order_min_text'] . $aLang['error_products_quantity_invalid'] . $cart_quantity . ' - ' . $aLang['products_order_qty_min_text_info'] . ' ' . $products_order_min;
}
if ($_SESSION['error_cart_msg'] == '') {
oos_redirect(oos_href_link($goto_mp, $goto_file, oos_get_all_get_parameters($parameters), 'NONSSL'));
} else {
oos_redirect(oos_href_link($aModules['products'], $aFilename['product_info'], 'products_id=' . $_POST['products_id']));
}
}
break;
}
if (isset($products_new['specials_new_products_price'])) {
$new_special_price = $products_new['specials_new_products_price'];
$new_product_special_price = $oCurrencies->display_price($new_special_price, oos_get_tax_rate($products_new['products_tax_class_id']));
} else {
$new_max_product_discount = min($products_new['products_discount_allowed'], $_SESSION['member']->group['discount']);
if ($new_max_product_discount != 0) {
$new_special_price = $products_new['products_price'] * (100 - $new_max_product_discount) / 100;
$new_product_discount_price = $oCurrencies->display_price($new_special_price, oos_get_tax_rate($products_new['products_tax_class_id']));
}
}
if ($products_new['products_base_price'] != 1) {
$new_base_product_price = $oCurrencies->display_price($products_new['products_price'] * $products_new['products_base_price'], oos_get_tax_rate($products_new['products_tax_class_id']));
if ($new_special_price != '') {
$new_base_product_special_price = $oCurrencies->display_price($new_special_price * $products_new['products_base_price'], oos_get_tax_rate($products_new['products_tax_class_id']));
}
}
$products_new_array[] = array('id' => $products_new['products_id'], 'name' => $products_new['products_name'], 'image' => $products_new['products_image'], 'new_product_price' => $new_product_price, 'new_product_units' => $new_product_units, 'new_product_special_price' => $new_product_special_price, 'new_max_product_discount' => $new_max_product_discount, 'new_special_price' => $new_special_price, 'new_product_discount_price' => $new_product_discount_price, 'new_base_product_price' => $new_base_product_price, 'new_base_product_special_price' => $new_base_product_special_price, 'products_base_price' => $products_new['products_base_price'], 'new_products_base_unit' => $products_new['products_base_unit'], 'date_added' => $products_new['products_date_added'], 'manufacturer' => $products_new['manufacturers_name']);
$products_new_result->MoveNext();
}
// links breadcrumb
$oBreadcrumb->add($aLang['header_title_catalog'], oos_href_link($aModules['main'], $aFilename['shop']));
$oBreadcrumb->add($aLang['navbar_title'], oos_href_link($aModules['products'], $aFilename['products_new']));
// assign Smarty variables;
$oSmarty->assign(array('oos_breadcrumb' => $oBreadcrumb->trail(BREADCRUMB_SEPARATOR), 'oos_heading_title' => $aLang['heading_title'], 'oos_heading_image' => 'products_new.gif', 'oos_page_split' => $products_new_split->display_count($products_new_numrows, MAX_DISPLAY_PRODUCTS_NEW, $_GET['page'], $aLang['text_display_number_of_products_new']), 'oos_display_links' => $products_new_split->display_links($products_new_numrows, MAX_DISPLAY_PRODUCTS_NEW, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], oos_get_all_get_parameters(array('page', 'info'))), 'oos_page_numrows' => $products_new_numrows, 'products_image_box' => SMALL_IMAGE_WIDTH + 10, 'oos_products_new_array' => $products_new_array));
}
$oSmarty->assign('oosPageNavigation', $oSmarty->fetch($aOption['page_navigation'], $contents_cache_id));
$oSmarty->assign('oosPageHeading', $oSmarty->fetch($aOption['page_heading'], $contents_cache_id));
$oSmarty->assign('contents', $oSmarty->fetch($aOption['template_main'], $contents_cache_id));
$oSmarty->caching = false;
// display the template
require 'includes/oos_display.php';
$languagestable = $oostable['languages'];
$query = "SELECT name, iso_639_2, iso_639_1
FROM $languagestable
WHERE status = '1'
ORDER BY sort_order";
if (USE_DB_CACHE == '1') {
$languages_result = $dbconn->CacheExecute(3600, $query);
} else {
$languages_result = $dbconn->Execute($query);
}
if ($languages_result->RecordCount() >= 2) {
$languages_block = '1';
$lang_get_parameters = oos_get_all_get_parameters(array('language', 'currency'));
$lang_get_parameters = oos_remove_trailing($lang_get_parameters);
$oSmarty->assign('languages_contents', $languages_result->GetArray());
$oSmarty->assign(
array(
'block_heading_languages' => $block_heading,
'lang_get_parameters' => $lang_get_parameters
)
);
} else {
$blockstable = $oostable['block'];
$dbconn->Execute("UPDATE " . $blockstable . "
SET block_status = 0
WHERE block_file = 'languages'");
}
$oos_pagetitle = $oBreadcrumb->trail_title(' » ');
$oos_pagetitle .= '»' . OOS_META_TITLE;
// assign Smarty variables;
$oSmarty->assign(
array(
'pagetitle' => htmlspecialchars($oos_pagetitle),
'meta_description' => htmlspecialchars($oos_meta_description),
'meta_keywords' => htmlspecialchars($oos_meta_keywords),
'oos_breadcrumb' => $oBreadcrumb->trail(BREADCRUMB_SEPARATOR),
'oos_heading_title' => $aLang['heading_title'],
'oos_heading_image' => 'history.gif',
'oos_page_split' => $history_split->display_count($history_numrows, MAX_DISPLAY_ORDER_HISTORY, $nCurrentPageNumber, $aLang['text_display_number_of_orders']),
'oos_display_links' => $history_split->display_links($history_numrows, MAX_DISPLAY_ORDER_HISTORY, MAX_DISPLAY_PAGE_LINKS, $nCurrentPageNumber, oos_get_all_get_parameters(array('nv', 'info'))),
'oos_page_numrows' => $history_numrows,
'oos_history_array' => $aHistory
)
);
$oSmarty->assign('oosBreadcrumb', $oSmarty->fetch($aOption['breadcrumb']));
$oSmarty->assign('oosPageHeading', $oSmarty->fetch($aOption['page_heading']));
$oSmarty->assign('contents', $oSmarty->fetch($aOption['template_main']));
// display the template
require 'includes/oos_display.php';
$lc_text .= '<input type="hidden" name="file" value="' . $sFile . '">';
$lc_text .= '<input type="hidden" name="categories" value="' . $categories . '">';
$lc_text .= '<input type="hidden" name="formid" value="' . $sFormid . '">';
$lc_text .= oos_hide_session_id();
$lc_text .= oos_get_all_as_hidden_field(array('action'));
$lc_text .= $aLang['products_order_qty_text'];
$lc_text .= ' <input type="text" name="cart_quantity" value="' . $order_min . '" size="3" /><br />';
$lc_text .= oos_image_submit('buy_now.gif', $aLang['text_buy'] . $listing['products_name'] . $aLang['text_now']);
$lc_text .= '</form>';
} else {
$lc_text = '<a href="' . oos_href_link($sMp, $sFile, $all_get_listing . 'action=buy_now&products_id=' . $listing['products_id'] . '&cart_quantity=' . $order_min) . '">' . oos_image_button('buy_now.gif', $aLang['text_buy'] . $listing['products_name'] . $aLang['text_now']) . '</a> ';
}
} else {
$lc_text = ' ';
}
break;
case 'PRODUCT_LIST_SORT_ORDER':
$lc_align = 'center';
$lc_text = ' ' . $listing['products_sort_order'] . ' ';
break;
}
$list_box_contents[$cur_row][] = array('align' => $lc_align, 'params' => 'class="productListing-data"', 'text' => $lc_text);
}
// Move that ADOdb pointer!
$listing_result->MoveNext();
}
// Close result set
$listing_result->Close();
}
$oSmarty->assign(array('oos_page_split' => $listing_split->display_count($listing_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], $aLang['text_display_number_of_products']), 'oos_display_links' => $listing_split->display_links($listing_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], oos_get_all_get_parameters(array('page', 'info'))), 'oos_page_numrows' => $listing_numrows));
$oSmarty->assign('list_box_contents', $list_box_contents);
break;
case 'PRODUCT_LIST_PRICE':
$order_str .= "final_price " . ($sort_order == 'd' ? "desc" : "") . ", pd.products_name";
break;
default:
$order_str .= "pd.products_name";
break;
}
}
$listing_sql = $select_str . $from_str . $where_str . $order_str;
$aOption['template_main'] = $sTheme . '/modules/advanced_search_result.html';
$aOption['page_heading'] = $sTheme . '/heading/page_heading.html';
$aOption['page_navigation'] = $sTheme . '/heading/page_navigation.html';
$nPageType = OOS_PAGE_TYPE_CATALOG;
require 'includes/oos_system.php';
if (!isset($option)) {
require 'includes/info_message.php';
require 'includes/oos_blocks.php';
}
// assign Smarty variables;
$oSmarty->assign(array('oos_breadcrumb' => $oBreadcrumb->trail(BREADCRUMB_SEPARATOR), 'oos_heading_title' => $aLang['heading_title'], 'oos_heading_image' => 'browse.gif'));
require 'includes/modules/product_listing.php';
$oSmarty->assign('pw_mispell', $pw_mispell);
$oSmarty->assign('pw_string', $pw_string);
$oSmarty->assign('oos_get_all_get_params', oos_get_all_get_parameters(array('sort', 'page')));
$oSmarty->assign('oosPageNavigation', $oSmarty->fetch($aOption['page_navigation']));
$oSmarty->assign('oosPageHeading', $oSmarty->fetch($aOption['page_heading']));
$oSmarty->assign('contents', $oSmarty->fetch($aOption['template_main']));
// display the template
require 'includes/oos_display.php';
}
$oos_pagetitle = $oBreadcrumb->trail_title(' » ');
$oos_pagetitle .= '»' . OOS_META_TITLE;
// assign Smarty variables;
$oSmarty->assign(
array(
'pagetitle' => htmlspecialchars($oos_pagetitle),
'meta_description' => htmlspecialchars($oos_meta_description),
'meta_keywords' => htmlspecialchars($oos_meta_keywords),
'oos_breadcrumb' => $oBreadcrumb->trail(BREADCRUMB_SEPARATOR),
'oos_heading_title' => $aLang['heading_title'],
'oos_heading_image' => 'top_viewed.gif',
'oos_page_split' => $top_viewed_split->display_count($top_viewed_numrows, MAX_DISPLAY_PRODUCTS_NEW, $nCurrentPageNumber, $aLang['text_display_number_of_top_viewed']),
'oos_display_links' => $top_viewed_split->display_links($top_viewed_numrows, MAX_DISPLAY_PRODUCTS_NEW, MAX_DISPLAY_PAGE_LINKS, $nCurrentPageNumber, oos_get_all_get_parameters(array('nv', 'info'))),
'oos_page_numrows' => $top_viewed_numrows,
'products_image_box' => SMALL_IMAGE_WIDTH + 10,
'oos_top_viewed_array' => $top_viewed_array
)
);
}
$oSmarty->assign('oosPageNavigation', $oSmarty->fetch($aOption['page_navigation'], $contents_cache_id));
$oSmarty->assign('oosPageHeading', $oSmarty->fetch($aOption['page_heading'], $contents_cache_id));
$oSmarty->assign('contents', $oSmarty->fetch($aOption['template_main'], $contents_cache_id));
$oSmarty->caching = false;
// display the template
require 'includes/oos_display.php';
$oos_pagetitle = $oBreadcrumb->trail_title(' » ');
$oos_pagetitle .= '»' . OOS_META_TITLE;
// assign Smarty variables;
$oSmarty->assign(
array(
'pagetitle' => htmlspecialchars($oos_pagetitle),
'meta_description' => htmlspecialchars($oos_meta_description),
'meta_keywords' => htmlspecialchars($oos_meta_keywords),
'oos_breadcrumb' => $oBreadcrumb->trail(BREADCRUMB_SEPARATOR),
'oos_heading_title' => $aLang['heading_title'],
'oos_heading_image' => 'specials.gif',
'oos_page_split' => $specials_split->display_count($specials_numrows, MAX_DISPLAY_SPECIAL_PRODUCTS, $_GET['page'], $aLang['text_display_number_of_specials']),
'oos_display_links' => $specials_split->display_links($specials_numrows, MAX_DISPLAY_SPECIAL_PRODUCTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], oos_get_all_get_parameters(array('page', 'info'))),
'oos_page_numrows' => $specials_numrows,
'oos_specials_array' => $aSpecials
)
);
}
$oSmarty->assign('oosPageNavigation', $oSmarty->fetch($aOption['page_navigation'], $contents_cache_id));
$oSmarty->assign('oosPageHeading', $oSmarty->fetch($aOption['page_heading'], $contents_cache_id));
$oSmarty->assign('contents', $oSmarty->fetch($aOption['template_main'], $contents_cache_id));
$oSmarty->caching = false;
// display the template
require 'includes/oos_display.php';
Copyright (c) 2003 osCommerce
----------------------------------------------------------------------
Released under the GNU General Public License
---------------------------------------------------------------------- */
/** ensure this file is being included by a parent file */
defined('OOS_VALID_MOD') or die('Direct Access to this location is not allowed.');
if (!$oEvent->installed_plugin('reviews')) {
$_SESSION['navigation']->remove_current_page();
MyOOS_CoreApi::redirect(oos_href_link($aModules['main'], $aFilename['main']));
}
if (!isset($_GET['reviews_id'])) {
MyOOS_CoreApi::redirect(oos_href_link($aModules['reviews'], $aFilename['reviews_reviews']));
}
require 'includes/languages/' . $sLanguage . '/reviews_product_info.php';
// lets retrieve all $_GET keys and values..
$get_parameters = oos_get_all_get_parameters(array('reviews_id'));
$get_parameters = oos_remove_trailing($get_parameters);
$reviewstable = $oostable['reviews'];
$productstable = $oostable['products'];
$reviews_descriptiontable = $oostable['reviews_description'];
$products_descriptiontable = $oostable['products_description'];
$sql = "SELECT rd.reviews_text, r.reviews_rating, r.reviews_id, r.products_id,\n r.customers_name, r.date_added, r.last_modified, r.reviews_read,\n p.products_id, pd.products_name, p.products_model, p.products_image\n FROM {$reviewstable} r,\n {$reviews_descriptiontable} rd,\n {$productstable} p,\n {$products_descriptiontable} pd\n WHERE r.reviews_id = '" . intval($_GET['reviews_id']) . "'\n AND r.reviews_id = rd.reviews_id\n AND rd.reviews_languages_id = '" . intval($nLanguageID) . "'\n AND r.products_id = p.products_id\n AND p.products_status >= '1'\n AND p.products_id = pd.products_id\n AND pd.products_languages_id = '" . intval($nLanguageID) . "'";
$reviews_result = $dbconn->Execute($sql);
if (!$reviews_result->RecordCount()) {
MyOOS_CoreApi::redirect(oos_href_link($aModules['reviews'], $aFilename['reviews_reviews']));
}
$reviews = $reviews_result->fields;
$dbconn->Execute("UPDATE " . $oostable['reviews'] . "\n SET reviews_read = reviews_read+1\n WHERE reviews_id = '" . $reviews['reviews_id'] . "'");
// links breadcrumb
$oBreadcrumb->add($reviews['products_name'], oos_href_link($aModules['products'], $aFilename['product_info'], 'categories=' . $categories . '&products_id=' . $reviews['products_id']));
$oBreadcrumb->add($aLang['navbar_title'], oos_href_link($aModules['reviews'], $aFilename['product_reviews'], $get_parameters));
}
$oos_pagetitle = $oBreadcrumb->trail_title(' » ');
$oos_pagetitle .= '»' . OOS_META_TITLE;
// assign Smarty variables;
$oSmarty->assign(
array(
'pagetitle' => htmlspecialchars($oos_pagetitle),
'meta_description' => htmlspecialchars($oos_meta_description),
'meta_keywords' => htmlspecialchars($oos_meta_keywords),
'oos_breadcrumb' => $oBreadcrumb->trail(BREADCRUMB_SEPARATOR),
'oos_heading_title' => $aLang['heading_title'],
'oos_heading_image' => 'wishlist.gif',
'oos_page_split' => $wishlist_split->display_count($wishlist_numrows, MAX_DISPLAY_WISHLIST_PRODUCTS,$nCurrentPageNumber, $aLang['text_display_number_of_wishlist']),
'oos_display_links' => $wishlist_split->display_links($wishlist_numrows, MAX_DISPLAY_WISHLIST_PRODUCTS, MAX_DISPLAY_PAGE_LINKS,$nCurrentPageNumber, oos_get_all_get_parameters(array('nv', 'info'))),
'oos_page_numrows' => $wishlist_numrows,
'wishlist_array' => $aWishlist
)
);
$oSmarty->assign('oosPageNavigation', $oSmarty->fetch($aOption['page_navigation']));
$oSmarty->assign('oosBreadcrumb', $oSmarty->fetch($aOption['breadcrumb']));
$oSmarty->assign('oosPageHeading', $oSmarty->fetch($aOption['page_heading']));
$oSmarty->assign('contents', $oSmarty->fetch($aOption['template_main']));
// display the template
require 'includes/oos_display.php';
$aOption['template_main'] = $sTheme . '/modules/user_create_account.html';
$aOption['page_heading'] = $sTheme . '/heading/page_heading.html';
$aOption['breadcrumb'] = 'default/system/breadcrumb.html';
$nPageType = OOS_PAGE_TYPE_ACCOUNT;
require 'includes/oos_system.php';
if (!isset($option)) {
require 'includes/info_message.php';
require 'includes/oos_blocks.php';
}
$read = '0';
$oSmarty->assign('read', $read);
$oSmarty->assign('oos_js', $javascript);
// assign Smarty variables;
$oSmarty->assign(array('oos_breadcrumb' => $oBreadcrumb->trail(BREADCRUMB_SEPARATOR), 'oos_heading_title' => $aLang['heading_title'], 'oos_heading_image' => 'account.gif'));
$oSmarty->assign('account', $account);
$oSmarty->assign('email_address', $email_address);
if (CUSTOMER_NOT_LOGIN == '1' or MAKE_PASSWORD == '1') {
$show_password = false;
} else {
$show_password = '******';
}
$oSmarty->assign('show_password', $show_password);
$oSmarty->assign('snapshot', $snapshot);
$oSmarty->assign('login_orgin_text', sprintf($aLang['text_origin_login'], oos_href_link($aPages['login'], oos_get_all_get_parameters(), 'SSL')));
$oSmarty->assign('newsletter_ids', array(0, 1));
$oSmarty->assign('newsletter', array($aLang['entry_newsletter_no'], $aLang['entry_newsletter_yes']));
$oSmarty->assign('oosBreadcrumb', $oSmarty->fetch($aOption['breadcrumb']));
$oSmarty->assign('oosPageHeading', $oSmarty->fetch($aOption['page_heading']));
$oSmarty->assign('contents', $oSmarty->fetch($aOption['template_main']));
// display the template
require 'includes/oos_display.php';
$price_discount = $oCurrencies->display_price($product_info['products_discount3'], oos_get_tax_rate($product_info['products_tax_class_id']));
} elseif ($product_info['products_discount2'] > 0) {
$price_discount = $oCurrencies->display_price($product_info['products_discount2'], oos_get_tax_rate($product_info['products_tax_class_id']));
} elseif ($product_info['products_discount1'] > 0) {
$price_discount = $oCurrencies->display_price($product_info['products_discount1'], oos_get_tax_rate($product_info['products_tax_class_id']));
}
if (isset($price_discount)) {
$oSmarty->assign('price_discount', $price_discount);
}
}
}
require 'includes/modules/products_options.php';
// assign Smarty variables;
$oSmarty->assign(array('oos_breadcrumb' => $oBreadcrumb->trail(BREADCRUMB_SEPARATOR), 'discounts_price' => $discounts_price));
if (!isset($block_get_parameters)) {
$block_get_parameters = oos_get_all_get_parameters(array('action'));
$block_get_parameters = oos_remove_trailing($block_get_parameters);
$oSmarty->assign('get_params', $block_get_parameters);
}
$oSmarty->assign('product_info', $product_info);
$oSmarty->assign('options', $options);
$oSmarty->assign('redirect', oos_href_link($aPages['redirect'], 'action=url&goto=' . urlencode($product_info['products_url']), 'NONSSL', false, false));
$oSmarty->assign('oosDate', date("Y-m-d H:i:s", time()));
if (SOCIAL_BOOKMARKS == '1') {
$oSmarty->caching = true;
if (!$oSmarty->is_cached($aOption['social_bookmarks'], $oos_social_bookmarks_cache_id)) {
$oSmarty->assign('bookmark', oos_href_link($aPages['product_info'], 'products_id=' . intval($nProductsId), 'NONSSL', false));
$oSmarty->assign('bookmarktitle', STORE_NAME . ' - ' . $product_info['products_name']);
}
$oSmarty->assign('social_bookmarks', $oSmarty->fetch($aOption['social_bookmarks'], $oos_social_bookmarks_cache_id));
$oSmarty->caching = false;
$new_special_price = $top_viewed['specials_new_products_price'];
$new_product_special_price = $oCurrencies->display_price($new_special_price, oos_get_tax_rate($top_viewed['products_tax_class_id']));
} else {
$new_max_product_discount = min($top_viewed['products_discount_allowed'], $_SESSION['member']->group['discount']);
if ($new_max_product_discount != 0) {
$new_special_price = $top_viewed['products_price'] * (100 - $new_max_product_discount) / 100;
$new_product_discount_price = $oCurrencies->display_price($new_special_price, oos_get_tax_rate($top_viewed['products_tax_class_id']));
}
}
if ($top_viewed['products_base_price'] != 1) {
$new_base_product_price = $oCurrencies->display_price($top_viewed['products_price'] * $top_viewed['products_base_price'], oos_get_tax_rate($top_viewed['products_tax_class_id']));
if ($new_special_price != '') {
$new_base_product_special_price = $oCurrencies->display_price($new_special_price * $top_viewed['products_base_price'], oos_get_tax_rate($top_viewed['products_tax_class_id']));
}
}
$top_viewed_array[] = array('id' => $top_viewed['products_id'], 'name' => $top_viewed['products_name'], 'image' => $top_viewed['products_image'], 'new_product_price' => $new_product_price, 'new_product_units' => $new_product_units, 'new_product_special_price' => $new_product_special_price, 'new_max_product_discount' => $new_max_product_discount, 'new_special_price' => $new_special_price, 'new_product_discount_price' => $new_product_discount_price, 'new_base_product_price' => $new_base_product_price, 'new_base_product_special_price' => $new_base_product_special_price, 'products_base_price' => $top_viewed['products_base_price'], 'new_products_base_unit' => $top_viewed['products_base_unit'], 'date_added' => $top_viewed['products_date_added'], 'manufacturer' => $top_viewed['manufacturers_name']);
$top_viewed_result->MoveNext();
}
// links breadcrumb
$oBreadcrumb->add($aLang['header_title_catalog'], oos_href_link($aPages['shop']));
$oBreadcrumb->add($aLang['navbar_title'], oos_href_link($aPages['top_viewed']), bookmark);
// assign Smarty variables;
$oSmarty->assign(array('oos_breadcrumb' => $oBreadcrumb->trail(BREADCRUMB_SEPARATOR), 'oos_heading_title' => $aLang['heading_title'], 'oos_heading_image' => 'top_viewed.gif', 'oos_page_split' => $top_viewed_split->display_count($top_viewed_numrows, MAX_DISPLAY_PRODUCTS_NEW, $nCurrentPageNumber, $aLang['text_display_number_of_top_viewed']), 'oos_display_links' => $top_viewed_split->display_links($top_viewed_numrows, MAX_DISPLAY_PRODUCTS_NEW, MAX_DISPLAY_PAGE_LINKS, $nCurrentPageNumber, oos_get_all_get_parameters(array('nv', 'info'))), 'oos_page_numrows' => $top_viewed_numrows, 'products_image_box' => SMALL_IMAGE_WIDTH + 10, 'oos_top_viewed_array' => $top_viewed_array));
}
$oSmarty->assign('oosPageNavigation', $oSmarty->fetch($aOption['page_navigation'], $contents_cache_id));
$oSmarty->assign('oosBreadcrumb', $oSmarty->fetch($aOption['breadcrumb'], $contents_cache_id));
$oSmarty->assign('oosPageHeading', $oSmarty->fetch($aOption['page_heading'], $contents_cache_id));
$oSmarty->assign('contents', $oSmarty->fetch($aOption['template_main'], $contents_cache_id));
$oSmarty->caching = false;
// display the template
require 'includes/oos_display.php';
if ($history_result->RecordCount()) {
while ($history = $history_result->fields) {
$orders_productstable = $oostable['orders_products'];
$sql = "SELECT COUNT(*) AS total\n FROM {$orders_productstable}\n WHERE orders_id = '" . intval($history['orders_id']) . "'";
$products = $dbconn->Execute($sql);
$aHistory[] = array('orders_id' => $history['orders_id'], 'orders_status_name' => $history['orders_status_name'], 'date_purchased' => $history['date_purchased'], 'delivery_name' => $history['delivery_name'], 'products_total' => $products->fields['total'], 'order_total' => strip_tags($history['order_total']));
// Move that ADOdb pointer!
$history_result->MoveNext();
}
// Close result set
$history_result->Close();
}
// links breadcrumb
$oBreadcrumb->add($aLang['navbar_title_1'], oos_href_link($aPages['account'], '', 'SSL'));
$oBreadcrumb->add($aLang['navbar_title_2'], oos_href_link($aPages['account_history'], '', 'SSL'), bookmark);
$aOption['template_main'] = $sTheme . '/modules/account_history.html';
$aOption['page_heading'] = $sTheme . '/heading/page_heading.html';
$aOption['breadcrumb'] = 'default/system/breadcrumb.html';
$nPageType = OOS_PAGE_TYPE_ACCOUNT;
require 'includes/oos_system.php';
if (!isset($option)) {
require 'includes/info_message.php';
require 'includes/oos_blocks.php';
}
// assign Smarty variables;
$oSmarty->assign(array('oos_breadcrumb' => $oBreadcrumb->trail(BREADCRUMB_SEPARATOR), 'oos_heading_title' => $aLang['heading_title'], 'oos_heading_image' => 'history.gif', 'oos_page_split' => $history_split->display_count($history_numrows, MAX_DISPLAY_ORDER_HISTORY, $nCurrentPageNumber, $aLang['text_display_number_of_orders']), 'oos_display_links' => $history_split->display_links($history_numrows, MAX_DISPLAY_ORDER_HISTORY, MAX_DISPLAY_PAGE_LINKS, $nCurrentPageNumber, oos_get_all_get_parameters(array('nv', 'info'))), 'oos_page_numrows' => $history_numrows, 'oos_history_array' => $aHistory));
$oSmarty->assign('oosBreadcrumb', $oSmarty->fetch($aOption['breadcrumb']));
$oSmarty->assign('oosPageHeading', $oSmarty->fetch($aOption['page_heading']));
$oSmarty->assign('contents', $oSmarty->fetch($aOption['template_main']));
// display the template
require 'includes/oos_display.php';
$productstable = $oostable['products'];
$specialstable = $oostable['specials'];
$products_descriptiontable = $oostable['products_description'];
$specials_result_raw = "SELECT p.products_id, pd.products_name, p.products_image, p.products_price,\n p.products_base_price, p.products_base_unit, p.products_tax_class_id,\n p.products_units_id, p.products_image, s.specials_new_products_price,\n substring(pd.products_description, 1, 150) AS products_description\n FROM {$productstable} p,\n {$products_descriptiontable} pd,\n {$specialstable} s\n WHERE p.products_status >= '1'\n AND (p.products_access = '0' OR p.products_access = '" . intval($nGroupID) . "')\n AND s.products_id = p.products_id\n AND p.products_id = pd.products_id\n AND pd.products_languages_id = '" . intval($nLanguageID) . "'\n AND s.status = '1'\n ORDER BY s.specials_date_added DESC";
$specials_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SPECIAL_PRODUCTS, $specials_result_raw, $specials_numrows);
$specials_result = $dbconn->Execute($specials_result_raw);
$aSpecials = array();
while ($specials = $specials_result->fields) {
$specials_base_product_price = '';
$specials_base_product_special_price = '';
$specials_product_price = $oCurrencies->display_price($specials['products_price'], oos_get_tax_rate($specials['products_tax_class_id']));
$specials_product_special_price = $oCurrencies->display_price($specials['specials_new_products_price'], oos_get_tax_rate($specials['products_tax_class_id']));
if ($specials['products_base_price'] != 1) {
$specials_base_product_price = $oCurrencies->display_price($specials['products_price'] * $specials['products_base_price'], oos_get_tax_rate($specials['products_tax_class_id']));
$specials_base_product_special_price = $oCurrencies->display_price($specials['specials_new_products_price'] * $specials['products_base_price'], oos_get_tax_rate($specials['products_tax_class_id']));
}
$aSpecials[] = array('products_id' => $specials['products_id'], 'products_image' => $specials['products_image'], 'products_name' => $specials['products_name'], 'products_description' => $specials['products_description'], 'products_base_unit' => $specials['products_base_unit'], 'products_base_price' => $specials['products_base_price'], 'products_price' => $specials_product_price, 'products_special_price' => $specials_product_special_price, 'base_product_price' => $specials_base_product_price, 'base_product_special_price' => $specials_base_product_special_price);
$specials_result->MoveNext();
}
// links breadcrumb
$oBreadcrumb->add($aLang['navbar_title'], oos_href_link($aPages['specials']), bookmark);
// assign Smarty variables;
$oSmarty->assign(array('oos_breadcrumb' => $oBreadcrumb->trail(BREADCRUMB_SEPARATOR), 'oos_heading_title' => $aLang['heading_title'], 'oos_heading_image' => 'specials.gif', 'oos_page_split' => $specials_split->display_count($specials_numrows, MAX_DISPLAY_SPECIAL_PRODUCTS, $_GET['page'], $aLang['text_display_number_of_specials']), 'oos_display_links' => $specials_split->display_links($specials_numrows, MAX_DISPLAY_SPECIAL_PRODUCTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], oos_get_all_get_parameters(array('page', 'info'))), 'oos_page_numrows' => $specials_numrows, 'oos_specials_array' => $aSpecials));
}
$oSmarty->assign('oosPageNavigation', $oSmarty->fetch($aOption['page_navigation'], $contents_cache_id));
$oSmarty->assign('oosBreadcrumb', $oSmarty->fetch($aOption['breadcrumb'], $contents_cache_id));
$oSmarty->assign('oosPageHeading', $oSmarty->fetch($aOption['page_heading'], $contents_cache_id));
$oSmarty->assign('contents', $oSmarty->fetch($aOption['template_main'], $contents_cache_id));
$oSmarty->caching = false;
// display the template
require 'includes/oos_display.php';
require 'includes/oos_blocks.php';
}
if (USE_CACHE == '1' && !SID) {
$oSmarty->caching = 2;
$oSmarty->cache_lifetime = 2 * 24 * 3600;
}
if (!$oSmarty->is_cached($aOption['template_main'], $contents_cache_id)) {
require 'includes/languages/' . $sLanguage . '/reviews_reviews.php';
$reviewstable = $oostable['reviews'];
$productstable = $oostable['products'];
$reviews_descriptiontable = $oostable['reviews_description'];
$products_descriptiontable = $oostable['products_description'];
$reviews_result_raw = "SELECT r.reviews_id, rd.reviews_text, r.reviews_rating, r.date_added, p.products_id,\n pd.products_name, p.products_image, r.customers_name\n FROM {$reviewstable} r,{$reviews_descriptiontable} rd,\n {$productstable} p, {$products_descriptiontable} pd\n WHERE p.products_status >= '1'\n AND p.products_id = r.products_id\n AND r.reviews_id = rd.reviews_id\n AND p.products_id = pd.products_id\n AND pd.products_languages_id = '" . intval($nLanguageID) . "'\n AND rd.reviews_languages_id = '" . intval($nLanguageID) . "'\n ORDER BY r.reviews_id DESC";
$reviews_split = new splitPageResults($nCurrentPageNumber, MAX_DISPLAY_NEW_REVIEWS, $reviews_result_raw, $reviews_numrows);
$reviews_result = $dbconn->Execute($reviews_result_raw);
$aReviews = array();
while ($reviews = $reviews_result->fields) {
$aReviews[] = array('id' => $reviews['reviews_id'], 'products_id' => $reviews['products_id'], 'reviews_id' => $reviews['reviews_id'], 'products_name' => $reviews['products_name'], 'products_image' => $reviews['products_image'], 'authors_name' => $reviews['customers_name'], 'review' => htmlspecialchars(substr($reviews['reviews_text'], 0, 250)) . '..', 'rating' => $reviews['reviews_rating'], 'word_count' => oosWordCount($reviews['reviews_text'], ' '), 'date_added' => oos_date_long($reviews['date_added']));
$reviews_result->MoveNext();
}
// links breadcrumb
$oBreadcrumb->add($aLang['navbar_title'], oos_href_link($aPages['reviews']), bookmark);
$oSmarty->assign(array('oos_breadcrumb' => $oBreadcrumb->trail(BREADCRUMB_SEPARATOR), 'oos_heading_title' => $aLang['heading_title'], 'oos_heading_image' => 'specials.gif', 'oos_page_split' => $reviews_split->display_count($reviews_numrows, MAX_DISPLAY_NEW_REVIEWS, $nCurrentPageNumber, $aLang['text_display_number_of_reviews']), 'oos_display_links' => $reviews_split->display_links($reviews_numrows, MAX_DISPLAY_NEW_REVIEWS, MAX_DISPLAY_PAGE_LINKS, $nCurrentPageNumber, oos_get_all_get_parameters(array('nv', 'info'))), 'oos_page_numrows' => $reviews_numrows, 'oos_reviews_array' => $aReviews));
}
$oSmarty->assign('oosPageNavigation', $oSmarty->fetch($aOption['page_navigation'], $contents_cache_id));
$oSmarty->assign('oosBreadcrumb', $oSmarty->fetch($aOption['breadcrumb'], $contents_cache_id));
$oSmarty->assign('oosPageHeading', $oSmarty->fetch($aOption['page_heading'], $contents_cache_id));
$oSmarty->assign('contents', $oSmarty->fetch($aOption['template_main'], $contents_cache_id));
$oSmarty->caching = false;
// display the template
require 'includes/oos_display.php';
