Average Product Rating need help on it

[redrob]

I have just added this (Average Product Rating) but nothing has appeared has anyone used this add-on I am running v1.3.9g is anyone using this if so how have you installed it.

[redrob]

Any one?.

[Graphic Content]

Hey RedRob,

I have added this mod to the latest Zen and it is displaying but the average rating on the product page isn't updating for some reason! I have given a product 2 ratings but it still says average rating 0.

I really need this to work for my client so will be investigating further.

Are you getting nothing at all?

Matt

[Graphic Content]

right I have got this working. For some reason the Main_vars file was not outputting the data correctly so by moving the functions directly into the tpl_product_info_display it now works.

here is the code to add to your tpl_product_info_display.php file wherever you want it to appear. (this works in 1.3.9g)

<!--bof Reviews button and count-->
<?php
  if ($flag_show_product_info_reviews == 1) {
  
  $reviews_average_rating_query = "select avg(reviews_rating) as average_rating from " . TABLE_REVIEWS . " r, "
                                                           . TABLE_REVIEWS_DESCRIPTION . " rd
                           where r.products_id = '" . (int)$_GET['products_id'] . "'
                           and r.reviews_id = rd.reviews_id
                           and rd.languages_id = '" . (int)$_SESSION['languages_id'] . "'" .
                           $review_status;
        
        $reviews_average_rating = $db->Execute($reviews_average_rating_query);
  
    // if more than 0 reviews, then show reviews button; otherwise, show the "write review" button
    if ($reviews->fields['count'] > 0 ) { ?>
<div id="productReviewLink" class="buttonRow back"><?php echo '<a href="' . zen_href_link(FILENAME_PRODUCT_REVIEWS, zen_get_all_get_params()) . '">' . zen_image_button(BUTTON_IMAGE_REVIEWS, BUTTON_REVIEWS_ALT) . '</a>'; ?></div>
<br class="clearBoth" />
<?php // 2P modified BOF - Average Product Rating
  echo '<p class="reviewCount">';
  if ($flag_show_product_info_reviews_count == 1) {
    echo TEXT_CURRENT_REVIEWS . ' <strong>' . $reviews->fields['count'] . '</strong><br />';
    $stars_image_suffix = str_replace('.', '_', zen_round($reviews_average_rating->fields['average_rating'] * 2, 0) / 2); // for stars_0_5.gif, stars_1.gif, stars_1_5.gif etc.
    //echo "raw average:".$reviews_average_rating->fields['average_rating']." | ";
    //echo $reviews_average_rating_query;
    $average_rating = zen_round($reviews_average_rating->fields['average_rating'], 2);
    echo TEXT_CURRENT_REVIEWS_RATING . ' <strong>' . $average_rating . '</strong> ' . zen_image(DIR_WS_TEMPLATE_IMAGES . 'stars_' . $stars_image_suffix . '.gif', sprintf(BOX_REVIEWS_TEXT_OF_5_STARS, $average_rating));
  } else {
    echo '';
  }
  echo '</p>';
// 2P modified EOF - Average Product Rating ?>
<?php } else { ?>
<div id="productReviewLink" class="buttonRow back"><?php echo '<a href="' . zen_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, zen_get_all_get_params(array())) . '">' . zen_image_button(BUTTON_IMAGE_WRITE_REVIEW, BUTTON_WRITE_REVIEW_ALT) . '</a>'; ?></div>
<br class="clearBoth" />
<?php
  }
}
?>
<!--eof Reviews button and count -->

hope this helps
Matt