$reviews_limit = 3; $reviews_query = tep_db_query("select reviews_id, customers_name, reviews_text, reviews_vote, date_added, products_id, reviews_types_id from " . TABLE_REVIEWS . " where products_id = '" . (int) $products_id . "' and reviews_status = '1' and reviews_types_id >= '1' order by date_added desc limit " . $reviews_limit); if (tep_db_num_rows($reviews_query) > 0) { while ($reviews = tep_db_fetch_array($reviews_query)) { if ($reviews['products_id'] == $products_id) { $page_numbers_query = tep_db_query("select * from " . TABLE_REVIEWS . " where reviews_types_id = '" . (int) $reviews['reviews_types_id'] . "' and reviews_status = '1' and date_added >= '" . tep_db_input($reviews['date_added']) . "'"); $page_numbers_count = tep_db_num_rows($page_numbers_query); $page_number = ceil($page_numbers_count / MAX_DISPLAY_REVIEWS_RESULTS); $reviews_description = $reviews['reviews_text']; $reviews_description = str_replace('<br />', "\n", $reviews_description); $reviews_description = str_replace('<p>', '', $reviews_description); $reviews_description = str_replace('</p>', "\n\n", $reviews_description); while (strpos($reviews_description, "\n\n") !== false) { $reviews_description = trim(str_replace("\n\n", "\n", $reviews_description)); } $reviews_short_description = tep_cut_string($reviews_description, 350) . '...'; $reviews_string .= '<div class="product_review" id="rfd' . $reviews['reviews_id'] . '" style="margin: 0;"><div style="float: right;">' . str_repeat(tep_image(DIR_WS_TEMPLATES_IMAGES . 'star.gif', sprintf(TEXT_REVIEW_VOTES_OF, $reviews['reviews_vote'], 5)), $reviews['reviews_vote']) . '</div><strong>' . tep_date_long($reviews['date_added']) . '</strong> ' . $reviews['customers_name'] . ' – ' . TEXT_REVIEW_OF . ' ' . ($block_authors_name ? $block_authors_name . ', ' : '') . $block_products_name . "\n" . '<div id="rsd' . $reviews['reviews_id'] . '">' . nl2br($reviews_short_description) . '</div>' . "\n" . '<a href="' . tep_href_link(FILENAME_REVIEWS, 'reviews_id=' . $reviews['reviews_id'] . ($page_number > 1 ? '&page=' . $page_number : '')) . '#rd' . $reviews['reviews_id'] . '"' . 'class="mediumText">' . VIEW_FULL_REVIEW . '</a></div><br /><br />' . "\n\n"; } } $product_reviews_count_check_query = tep_db_query("select count(*) as total from " . TABLE_REVIEWS . " where products_id = '" . (int) $products_id . "' and reviews_status = '1' and reviews_types_id >= '1'"); $product_reviews_count_check = tep_db_fetch_array($product_reviews_count_check_query); if ($product_reviews_count_check['total'] > $reviews_limit) { $reviews_string .= '<div><a href="' . tep_href_link(FILENAME_REVIEWS, 'products_id=' . $products_id) . '">' . sprintf(TEXT_ALL_PRODUCT_REVIEWS, $block_product_name) . '</a></div><br />' . "\n"; } } else { $reviews_string .= TEXT_NO_PRODUCT_REVIEWS . '<br /><br />' . "\n"; } $votes_check_query = tep_db_query("select count(*) as total from " . TABLE_REVIEWS . " where products_id = '" . (int) $products_id . "' and reviews_types_id = '1' and reviews_ip = '" . tep_db_input($_SERVER['REMOTE_ADDR']) . "' and reviews_agent = '" . tep_db_input(tep_db_prepare_input($_SERVER['HTTP_USER_AGENT'])) . "' and date_added > '" . date('Y-m-d H:i:s', time() - 60 * 60 * 24) . "'"); $votes_check = tep_db_fetch_array($votes_check_query); if ($votes_check['total'] < 1) { if (strpos(REQUEST_URI, 'action') !== false) {
} $listing_sql .= ")"; } } $listing_sql .= " order by date_added desc"; $listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_NEWS_RESULTS, 'news_id'); if ($listing_split->number_of_rows > 0) { $listing_query = tep_db_query($listing_split->sql_query); while ($listing = tep_db_fetch_array($listing_query)) { $news_type_info_query = tep_db_query("select news_types_name from " . TABLE_NEWS_TYPES . " where news_types_id = '" . (int) $listing['news_types_id'] . "' and language_id = '" . (int) $languages_id . "'"); $news_type_info = tep_db_fetch_array($news_type_info_query); $news_description = $listing['news_description']; $news_description = str_replace('<p>', '', $news_description); $news_description = str_replace(array('<br />', '<br>', '</p>'), "\n", $news_description); $news_description = trim(preg_replace("/[\r\n]+/", "\n", $news_description)); $news_short_description = tep_cut_string($news_description, 200); if (strlen($news_description) > 200) { $news_short_description .= '...'; } $news_image = ''; if (tep_not_null($listing['news_image'])) { $news_image = str_replace('news/', 'news/thumbs/', $listing['news_image']); if (!file_exists(DIR_FS_CATALOG . 'images/' . $news_image)) { $news_image = ''; } } $news_link = tep_href_link(FILENAME_NEWS, 'news_id=' . $listing['news_id'] . ($news_type_id > 0 ? '&tPath=' . $news_type_id : '')); echo '<br clear="right" />' . "\n" . '<strong><a href="' . $news_link . '">' . $listing['news_name'] . '</a></strong><br />' . "\n" . (tep_not_null($news_image) ? '<a href="' . $news_link . '">' . tep_image(DIR_WS_IMAGES . $news_image, $listing['news_name'], '', '', 'class="one_image"') . '</a>' : '') . ($news_type_id == 0 ? '<a href="' . tep_href_link(FILENAME_NEWS, 'tPath=' . $listing['news_types_id']) . '" class="mediumText">' . $news_type_info['news_types_name'] . '</a>' . "\n" : '') . '<div class="smallText">' . tep_date_long($listing['date_added']) . '</div>' . "\n" . '' . nl2br($news_short_description) . '<br />' . "\n"; } ?> <br clear="all" /><div id="listing-split">
$author_info = array(); } $product_info = array_merge($product_info, $author_info); $title = tep_get_products_info($listing['products_id'], DEFAULT_LANGUAGE_ID); if (tep_not_null($product_info['authors_name'])) { $title = $product_info['authors_name'] . ': ' . $title; } $show_full_description = false; $reviews_description = $listing['reviews_text']; $reviews_description = str_replace('<br />', "\n", $reviews_description); $reviews_description = str_replace('<p>', '', $reviews_description); $reviews_description = str_replace('</p>', "\n\n", $reviews_description); while (strpos($reviews_description, "\n\n") !== false) { $reviews_description = trim(str_replace("\n\n", "\n", $reviews_description)); } $reviews_short_description = tep_cut_string($reviews_description, 300); if (strlen($reviews_description) > 300) { $reviews_short_description .= '...'; $show_full_description = true; } $stars_string = str_repeat(tep_image(DIR_WS_TEMPLATES_IMAGES . 'star.gif', sprintf(TEXT_REVIEW_VOTES_OF, $listing['reviews_vote'], 5)), $listing['reviews_vote']); echo '<a name="rd' . $listing['reviews_id'] . '"></a><br />' . "\n" . '<div class="reviews_block' . ($HTTP_GET_VARS['reviews_id'] == $listing['reviews_id'] ? '_active' : '') . '" id="rfd' . $listing['reviews_id'] . '">' . "\n" . '<div style="float: right;">' . $stars_string . '</div>' . "\n" . '<div class="reviews_title"><strong><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $listing['products_id']) . '">' . $title . '</a></strong></div>' . "\n" . '<div class="mediumText">' . tep_date_long($listing['date_added']) . ', ' . $listing['customers_name'] . '</div>' . "\n"; if ($HTTP_GET_VARS['reviews_id'] == $listing['reviews_id'] || $show_full_description == false) { echo '<div class="reviews_description">' . nl2br($reviews_description) . '</div>' . "\n"; } else { echo '<div class="reviews_description" id="rsd' . $listing['reviews_id'] . '">' . nl2br($reviews_short_description) . '</div>' . "\n" . '<a href="' . tep_href_link(FILENAME_REVIEWS, 'reviews_id=' . $listing['reviews_id'] . (isset($HTTP_GET_VARS['page']) ? '&page=' . $HTTP_GET_VARS['page'] : '')) . '#rd' . $listing['reviews_id'] . '" onclick="getXMLDOM(\'' . tep_href_link(FILENAME_LOADER, 'action=load_review&reviews_id=' . $listing['reviews_id']) . '\', \'rsd' . $listing['reviews_id'] . '\'); document.getElementById(\'rfd' . $listing['reviews_id'] . '\').style.backgroundColor = \'#eeeeee\'; this.style.display = \'none\'; return false;" class="mediumText">' . VIEW_FULL_REVIEW . '</a>'; } echo '</div><br />' . "\n"; } ?> <div id="listing-split">