$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">
