reviews sidebox!? main page problem
my review sidebox doesn't rotate the products on the main page. it's allways stuck on one product. but when i'm browsing the site it will change if i'm looking at a product that has client reviews the sidebox will then show that product.
what em i missing here. or is this the way it's supposed to work?
Re: reviews sidebox!? main page problem
have you added mod to 'rotate' products .. it will not rotate/scroll without a mod
Re: reviews sidebox!? main page problem
So where in admin do we go to activate the rotation so that it's not stuck on the same review. I'm having the same problem and I can't find it in admin. Am I missing something here?
Re: reviews sidebox!? main page problem
there are no rotation for review side box , the review changes as you navigate from page to page , showing product review randomly
im not sure if there is mod specifically made for review , but there is scroll mod for side box that might work for review side box or might be customized for review
Re: reviews sidebox!? main page problem
It is actually not changing to another review when browsing to other pages. Is there a bug?
Re: reviews sidebox!? main page problem
has anyone figured out this issue yet
Re: reviews sidebox!? main page problem
Test this ... use in the:
/includes/modules/sideboxes/reviews.php
Code:
<?php
/**
* reviews sidebox - displays a random product-review
*
* @package templateSystem
* @copyright Copyright 2003-2009 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: reviews.php 14007 2009-07-30 14:35:22Z ajeh $
*/
// if review must be approved or disabled do not show review
$review_status = " and r.status = 1 ";
$random_review_sidebox_select = "select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name,
reviews_text
from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd, "
. TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
where p.products_status = '1'
and p.products_id = r.products_id
and r.reviews_id = rd.reviews_id
and rd.languages_id = '" . (int)$_SESSION['languages_id'] . "'
and p.products_id = pd.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'" .
$review_status;
if (isset($_GET['products_id'])) {
$random_review_sidebox_select .= " and p.products_id = '" . (int)$_GET['products_id'] . "'";
}
$random_review_sidebox_product = $db->ExecuteRandomMulti($random_review_sidebox_select, MAX_RANDOM_SELECT_REVIEWS);
if ($random_review_sidebox_product->RecordCount() > 0) {
require($template->get_template_dir('tpl_reviews_random.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_reviews_random.php');
} elseif (isset($_GET['products_id']) and zen_products_id_valid($_GET['products_id'])) {
// display 'write a review' box
require($template->get_template_dir('tpl_reviews_write.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_reviews_write.php');
} else {
// display 'no reviews' box
require($template->get_template_dir('tpl_reviews_none.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_reviews_none.php');
}
$title = BOX_HEADING_REVIEWS;
$title_link = FILENAME_REVIEWS;
require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);
?>
does this work for you?
Re: reviews sidebox!? main page problem
thank you i'll play with it tonight and let you know
Re: reviews sidebox!? main page problem
problem now solved thank you again your always a great help
Re: reviews sidebox!? main page problem
the name on the product is gone in the sidebox it just shows 2 dots in place of the name of product