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_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),
require 'includes/info_message.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($_GET['page'], 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($aModules['reviews'], $aFilename['reviews_reviews'])); $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, $_GET['page'], $aLang['text_display_number_of_reviews']), 'oos_display_links' => $reviews_split->display_links($reviews_numrows, MAX_DISPLAY_NEW_REVIEWS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], oos_get_all_get_parameters(array('page', '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';