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?

have you added mod to 'rotate' products .. it will not rotate/scroll without a mod

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?

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

It is actually not changing to another review when browsing to other pages. Is there a bug?

has anyone figured out this issue yet

Test this ... use in the:
/includes/modules/sideboxes/reviews.php

<?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?

thank you i'll play with it tonight and let you know

problem now solved thank you again your always a great help

the name on the product is gone in the sidebox it just shows 2 dots in place of the name of product

Try using this as the:
/includes/templates/your_template_dir/sideboxes/tpl_reviews_random.php

<?php
/**
 * Side Box Template
 *
 * @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: tpl_reviews_random.php 14007 2009-07-30 14:35:22Z ajeh $
 */
  $content = "";
  $review_box_counter = 0;
  while (!$random_review_sidebox_product->EOF) {
    $review_box_counter++;
    $content .= '<div id="' . str_replace('_', '-', $box_id . 'Content') . '" class="sideBoxContent centeredContent">';
    $content .= '<a href="' . zen_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $random_review_sidebox_product->fields['products_id'] . '&reviews_id=' . $random_review_sidebox_product->fields['reviews_id']) . '">' . zen_image(DIR_WS_IMAGES . $random_review_sidebox_product->fields['products_image'], $random_review_sidebox_product->fields['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '<br />' . zen_break_string(nl2br(zen_output_string_protected(stripslashes($random_review_sidebox_product->fields['reviews_text']))), 60, '-<br />') . ' ..</a><br /><br />' . zen_image(DIR_WS_TEMPLATE_IMAGES . 'stars_' . $random_review_sidebox_product->fields['reviews_rating'] . '.gif' , sprintf(BOX_REVIEWS_TEXT_OF_5_STARS, $random_review_sidebox_product->fields['reviews_rating']));
    $content .= '</div>';
    $random_review_sidebox_product->MoveNextRandom();
  }
?>

that's kinda cool that code adds the reviewers content text in the side box, which is nicer then then just having the product name but can you cut down the content to 30 characters, as it looks like it displays the whole review in the sidebox

again thanks again linda

Change the 60 to what you want ...

If you need the name in there, you could add it between the image and the description by referencing it like it is on the alt tag of the image:
$random_review_sidebox_product->fields['products_name']

yeah i was hoping that was it but nothing happens until i get it don to about 8 then then it start screwing around with the width of the content in the side box but the full review is still displayed just over more rows

right now i changed the 60 to a 10 with no real change

Put the 60 back and add a substr around the text ... for example:

substr($random_review_sidebox_product->fields['reviews_text'], 0, 20)

worked perfectly thank you again

You are most welcome ... thanks for the update! :smile:

ohh if you want feedback i tried to adjust how much text could be displayed in the side box with this part of the code ```
, 0, 20)

I used:

    $content .= '<a href="' . zen_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $random_review_sidebox_product->fields['products_id'] . '&reviews_id=' . $random_review_sidebox_product->fields['reviews_id']) . '">' . zen_image(DIR_WS_IMAGES . $random_review_sidebox_product->fields['products_image'], $random_review_sidebox_product->fields['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '<br />' . zen_break_string(nl2br(zen_output_string_protected(stripslashes([B]substr($random_review_sidebox_product->fields['reviews_text'], 0, 20)[/B]))), 60, '-<br />') . ' ..</a><br /><br />' . zen_image(DIR_WS_TEMPLATE_IMAGES . 'stars_' . $random_review_sidebox_product->fields['reviews_rating'] . '.gif' , sprintf(BOX_REVIEWS_TEXT_OF_5_STARS, $random_review_sidebox_product->fields['reviews_rating']));

Meanwhile, glad you have it working now ... :smile:

Ajeh:

You are most welcome ... thanks for the update! :smile:

Great mod it worked for me too. However having made the mod I now have two strange problems and I am not sure if it is related to the mod.

my site is https://www.fastbikegear.co.nz and I am using the ZJ black template.

The first problem is that my manufacturer's info side box now has the same contents as my new products info side box?

The second problem is that the order that my side boxes appears in does not match that set in my Layout Box Controller?

Is anyone able to shed any light on what I have done wrong and what I need to do to fix this?

Many thanks in advance