Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Reviews Working, but not Reviews Box


jspstorm

Recommended Posts

The reviews box I have in the right column shows no image, name, rating star image, or description for reviews. If I look at these reviews on the reviews page, or from the admin panel, they work fine. The link I get from right clicking on a broken image link for one of the reviews box items is "http://rotw.exofire.net/catalog/product_reviews_info.php?products_id=&reviews_id="

There are no numbers for products_id or reviews_id! But it works for reviews.php. I'm using the latest oscommerce version, and I've only removed currencies and languages from the column, and installed the random specials box contribution, hardly anything else is modified. Certainly not the reviews pages. Does anyone know whats going on?

 

My Oscommerce Site

Link to comment
Share on other sites

<?php

/*

$Id: reviews.php 1739 2007-12-20 00:52:16Z hpdl $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

?>

<!-- reviews //-->

<tr>

<td>

<?php

$info_box_contents = array();

$info_box_contents[] = array('text' => BOX_HEADING_REVIEWS);

 

new infoBoxHeading($info_box_contents, false, false, tep_href_link(FILENAME_REVIEWS));

 

$random_select = "select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name 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)$languages_id . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'";

if (isset($HTTP_GET_VARS['products_id'])) {

$random_select .= " and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'";

}

$random_select .= " order by r.reviews_id desc limit " . MAX_RANDOM_SELECT_REVIEWS;

$random_product = tep_random_select($random_select);

 

$info_box_contents = array();

 

if ($random_product) {

// display random review box

$rand_review_query = tep_db_query("select substring(reviews_text, 1, 60) as reviews_text from " . TABLE_REVIEWS_DESCRIPTION . " where reviews_id = '" . (int)$random_product['reviews_id'] . "' and languages_id = '" . (int)$languages_id . "'");

$rand_review = tep_db_fetch_array($rand_review_query);

 

$rand_review_text = tep_break_string(tep_output_string_protected($rand_review['reviews_text']), 15, '-<br>');

 

$info_box_contents[] = array('text' => '<div align="center"><a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $random_product['products_id'] . '&reviews_id=' . $random_product['reviews_id']) . '">' . tep_image(DIR_WS_IMAGES . $random_product['products_image'], $random_product['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a></div><a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $random_product['products_id'] . '&reviews_id=' . $random_product['reviews_id']) . '">' . $rand_review_text . ' ..</a><br><div align="center">' . tep_image(DIR_WS_IMAGES . 'stars_' . $random_product['reviews_rating'] . '.gif' , sprintf(BOX_REVIEWS_TEXT_OF_5_STARS, $random_product['reviews_rating'])) . '</div>');

} elseif (isset($HTTP_GET_VARS['products_id'])) {

// display 'write a review' box

$info_box_contents[] = array('text' => '<table border="0" cellspacing="0" cellpadding="2"><tr><td class="infoBoxContents"><a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, 'products_id=' . $HTTP_GET_VARS['products_id']) . '">' . tep_image(DIR_WS_IMAGES . 'box_write_review.gif', IMAGE_BUTTON_WRITE_REVIEW) . '</a></td><td class="infoBoxContents"><a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, 'products_id=' . $HTTP_GET_VARS['products_id']) . '">' . BOX_REVIEWS_WRITE_REVIEW .'</a></td></tr></table>');

} else {

// display 'no reviews' box

$info_box_contents[] = array('text' => BOX_REVIEWS_NO_REVIEWS);

}

 

new infoBox($info_box_contents);

?>

</td>

</tr>

<!-- reviews_eof //-->

Link to comment
Share on other sites

Login to your Admin.

 

Click on "Configuration" then "Maximum Values".

 

On that page does the field '"Selection of Random Reviews" contain a numeric value greater than ZERO?

:unsure:

If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Link to comment
Share on other sites

Yes it's three, if I make it zero, then I says there are currently no reviews, if I made it anything over zero, it simply shows a broken image with .. for review text and "of 5 Stars!" below that with no image for stars.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...