Reviews pages are not working.

[telemere]

When you look at the reviews page there are icons that when they are clicked

on they go to a page that does not work. Also there is an icon in the

review box that goes to that same page with the same problem.

http://www.nutracelllabs.com/reviews.php?o...e0da4f05977cab0

618b

 

When your there click any review icon and you go to

 

http://www.nutracelllabs.com/product_revie...e0da4f05977cab0

 

Here's the code for the page you go to when you click on an item (the link above).

 

<?php

/*

$Id: product_reviews_info.php,v 1.50 2003/06/20 14:25:58 hpdl Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright ? 2003 osCommerce

 

Released under the GNU General Public License

*/

 

require('includes/application_top.php');

 

if (isset($HTTP_GET_VARS['reviews_id']) &&

tep_not_null($HTTP_GET_VARS['reviews_id']) &&

isset($HTTP_GET_VARS['products_id']) &&

tep_not_null($HTTP_GET_VARS['products_id'])) {

$review_check_query = tep_db_query("select count(*) as total from " .

TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd where r.reviews_id

= '" . (int)$HTTP_GET_VARS['reviews_id'] . "' and r.products_id = '" .

(int)$HTTP_GET_VARS['products_id'] . "' and r.reviews_id = rd.reviews_id and

rd.languages_id = '" . (int)$languages_id . "'");

$review_check = tep_db_fetch_array($review_check_query);

 

if ($review_check['total'] < 1) {

tep_redirect(tep_href_link(FILENAME_PRODUCT_REVIEWS,

tep_get_all_get_params(array('reviews_id'))));

}

} else {

tep_redirect(tep_href_link(FILENAME_PRODUCT_REVIEWS,

tep_get_all_get_params(array('reviews_id'))));

}

 

tep_db_query("update " . TABLE_REVIEWS . " set reviews_read =

reviews_read+1 where reviews_id = '" . (int)$HTTP_GET_VARS['reviews_id'] .

"'");

 

$review_query = tep_db_query("select rd.reviews_text, r.reviews_rating,

r.reviews_id, r.customers_name, r.date_added, r.reviews_read, p.products_id,

p.products_price, p.products_tax_class_id, p.products_image,

p.products_model, pd.products_name from " . TABLE_REVIEWS . " r, " .

TABLE_REVIEWS_DESCRIPTION . " rd, " . TABLE_PRODUCTS . " p, " .

TABLE_PRODUCTS_DESCRIPTION . " pd where r.reviews_id = '" .

(int)$HTTP_GET_VARS['reviews_id'] . "' and r.reviews_id = rd.reviews_id and

rd.languages_id = '" . (int)$languages_id . "' and r.products_id =

p.products_id and p.products_status = '1' and p.products_id = pd.products_id

and pd.language_id = '". (int)$languages_id . "'");

$review = tep_db_fetch_array($review_query);

 

if ($new_price = tep_get_products_special_price($review['products_id'])) {

$products_price = '<s>' .

$currencies->display_price($review['products_price'],

tep_get_tax_rate($review['products_tax_class_id'])) . '</s> <span

class="productSpecialPrice">' . $currencies->display_price($new_price,

tep_get_tax_rate($review['products_tax_class_id'])) . '</span>';

} else {

$products_price = $currencies->display_price($review['products_price'],

tep_get_tax_rate($review['products_tax_class_id']));

}

 

if (tep_not_null($review['products_model'])) {

$products_name = $review['products_name'] . '<br><span

class="smallText">[' . $review['products_model'] . ']</span>';

} else {

$products_name = $review['products_name'];

}

 

require(DIR_WS_LANGUAGES . $language . '/' .

FILENAME_PRODUCT_REVIEWS_INFO);

 

$breadcrumb->add(NAvb script:popupWindow(\\\'' .

tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $review['products_id']) .

'\\\')">' . tep_image(DIR_WS_IMAGES . $review['products_image'],

addslashes($review['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT,

'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>');

//--></script> <noscript> <?php echo '<a href="' .

tep_href_link(DIR_WS_IMAGES .

$review['products_image']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES

$review['products_image'], $review['products_name'], SMALL_IMAGE_WIDTH,

SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' .

TEXT_CLICK_TO_ENLARGE . '</a>'; ?> </noscript> <?php

}

 

echo '<p><a href="' . tep_href_link(basename($PHP_SELF),

tep_get_all_get_params(array('action')) . 'action=buy_now') . '">' .

tep_image_button('button_in_cart.gif', IMAGE_BUTTON_IN_CART) . '</a></p>';

?>

</td>

</tr>

</table>

</td>

</table></td>

</tr>

</table></td>

 

</tr>

</table>

<!-- body_eof //-->

 

<!-- footer //-->

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //-->

 

</td>

</tr>

</table>

<p><br>

</p>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

[Guest]

do you have the review box on left column or the right one? we found one today, that in the left column clicking on the link it was corrupt yet when in the right column (same exact program called) it worked with no problem.