Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Catagory tree for review box.


Guest

Recommended Posts

Im trying to get the review box to show only random products when in its proper catagory.

 

Could someone help me with this coding?

 

  $info_box_contents = array();



  if ($HTTP_GET_VARS['cPath']); 

 if ($random_product) {

// display random review box

   $review_query = tep_db_query("select etc etc etc);

 

Whole code:

<!-- 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 = '" . $languages_id . "' and p.products_id = pd.products_id and pd.language_id = '" . $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 ($HTTP_GET_VARS['cPath']); 

 if ($random_product) {

// display random review box

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

   $review = tep_db_fetch_array($review_query);



   $review = htmlspecialchars($review['reviews_text']);

   $review = tep_break_string($review, 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']) . '">' . $review . ' ..</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

The following code, which is located at the top of your default.php, determines the Category level. Its not exactly what you are looking for, but hopefully, this will give you a starting point.

 

Good Luck.

 

-R

// the following cPath references come from application_top.php

 $category_depth = 'top';

 if ($cPath) {

   $categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . $current_category_id . "'");

   $cateqories_products = tep_db_fetch_array($categories_products_query);

   if ($cateqories_products['total'] > 0) {

     $category_depth = 'products'; // display products

   } else {

     $category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . $current_category_id . "'");

     $category_parent = tep_db_fetch_array($category_parent_query);

     if ($category_parent['total'] > 0) {

       $category_depth = 'nested'; // navigate through the categories

     } else {

       $category_depth = 'products'; // category has no products, but display the 'no products' message

     }

   }

 }

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...