function execute()
{
global $languages_id, $HTTP_GET_VARS, $currencies, $oscTemplate;
$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 . "' and r.reviews_status = 1";
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);
$reviews_box_contents = '';
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 />');
$reviews_box_contents .= '<div class="ui-widget-content infoBoxContents"><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(MODULE_BOXES_REVIEWS_BOX_TEXT_OF_5_STARS, $random_product['reviews_rating'])) . '</div></div>';
} elseif (isset($HTTP_GET_VARS['products_id'])) {
// display 'write a review' box
$reviews_box_contents .= '<table border="0" cellspacing="0" cellpadding="2" class="ui-widget-content infoBoxContents"><tr><td><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><a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, 'products_id=' . $HTTP_GET_VARS['products_id']) . '">' . MODULE_BOXES_REVIEWS_BOX_WRITE_REVIEW . '</a></td></tr></table>';
} else {
// display 'no reviews' box
$reviews_box_contents .= '<div class="ui-widget-content infoBoxContents">' . MODULE_BOXES_REVIEWS_BOX_NO_REVIEWS . '</div>';
}
$data = '<div class="ui-widget infoBoxContainer">' . ' <div class="ui-widget-header infoBoxHeading"><a href="' . tep_href_link(FILENAME_REVIEWS) . '">' . MODULE_BOXES_REVIEWS_BOX_TITLE . '</a></div>' . ' ' . $reviews_box_contents . '</div>';
$oscTemplate->addBlock($data, $this->group);
}
function execute()
{
global $languages_id, $HTTP_GET_VARS, $currencies, $oscTemplate;
$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 . "' and r.reviews_status = 1";
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);
$reviews_box_contents = '';
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 />');
$reviews_box_contents .= '<div class="text-center"><a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, 'products_id=' . $random_product['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $random_product['products_image'], $random_product['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a></div><div><a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, 'products_id=' . $random_product['products_id']) . '">' . $rand_review_text . '</a>...</div><div class="text-center" title="' . sprintf(MODULE_BOXES_REVIEWS_BOX_TEXT_OF_5_STARS, $random_product['reviews_rating']) . '">' . tep_draw_stars($random_product['reviews_rating']) . '</div>';
} elseif (isset($HTTP_GET_VARS['products_id'])) {
// display 'write a review' box
$reviews_box_contents .= '<span class="fa fa-thumbs-up"></span> <a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, 'products_id=' . $HTTP_GET_VARS['products_id']) . '">' . MODULE_BOXES_REVIEWS_BOX_WRITE_REVIEW . '</a>';
} else {
// display 'no reviews' box
$reviews_box_contents .= '<p>' . MODULE_BOXES_REVIEWS_BOX_NO_REVIEWS . '</p>';
}
ob_start();
include DIR_WS_MODULES . 'boxes/templates/reviews.php';
$data = ob_get_clean();
$oscTemplate->addBlock($data, $this->group);
}
function execute()
{
global $languages_id, $HTTP_GET_VARS, $currencies, $oscTemplate;
$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 . "' and r.reviews_status = 1";
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);
$reviews_box_contents = '';
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 />');
$reviews_box_contents .= ' <ul class="module-content boxproduct">' . ' <li class="clearfix">' . ' <a class="boxproduct-img" 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 class="boxproduct-info">' . ' <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>' . ' <div class="rating-img">' . tep_draw_rating($random_product['reviews_rating']) . '</div>' . ' </div>' . ' </li>' . ' </ul>';
} elseif (isset($HTTP_GET_VARS['products_id'])) {
// display 'write a review' box
$reviews_box_contents .= ' <div class="module-content">' . ' <a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, 'products_id=' . $HTTP_GET_VARS['products_id']) . '">' . tep_draw_icon('fa-pencil') . MODULE_BOXES_REVIEWS_BOX_WRITE_REVIEW . '</a>' . ' </div>';
} else {
// display 'no reviews' box
$reviews_box_contents .= '<div class="module-content">' . MODULE_BOXES_REVIEWS_BOX_NO_REVIEWS . '</div>';
}
$data = '<div class="module reviews-box">' . ' <h3 class="module-heading"><a href="' . tep_href_link(FILENAME_REVIEWS) . '">' . MODULE_BOXES_REVIEWS_BOX_TITLE . '</a></h3>' . ' ' . $reviews_box_contents . '</div>';
$oscTemplate->addBlock($data, $this->group);
}
function execute()
{
global $languages_id, $HTTP_GET_VARS, $currencies, $oscTemplate;
$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 . "' and r.reviews_status = 1";
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);
$reviews_box_contents = '';
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 />');
$reviews_box_contents .= '<div class="text-center"><a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, 'products_id=' . $random_product['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $random_product['products_image'], $random_product['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a></div><div><a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, 'products_id=' . $random_product['products_id']) . '">' . $rand_review_text . '</a>...</div><div class="text-center" title="' . sprintf(MODULE_BOXES_REVIEWS_BOX_TEXT_OF_5_STARS, $random_product['reviews_rating']) . '">' . tep_draw_stars($random_product['reviews_rating']) . '</div>';
} elseif (isset($HTTP_GET_VARS['products_id'])) {
// display 'write a review' box
$reviews_box_contents .= '<span class="glyphicon glyphicon-thumbs-up"></span> <a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, 'products_id=' . $HTTP_GET_VARS['products_id']) . '">' . MODULE_BOXES_REVIEWS_BOX_WRITE_REVIEW . '</a>';
} else {
// display 'no reviews' box
$reviews_box_contents .= '<p>' . MODULE_BOXES_REVIEWS_BOX_NO_REVIEWS . '</p>';
}
$data = '<div class="panel panel-default">' . ' <div class="panel-heading"><a href="' . tep_href_link(FILENAME_REVIEWS) . '">' . MODULE_BOXES_REVIEWS_BOX_TITLE . '</a></div>' . ' <div class="panel-body">' . $reviews_box_contents . '</div>' . '</div>';
if ($this->group == 'boxes_product_page' && isset($HTTP_GET_VARS['products_id'])) {
$review_query = tep_db_query("select SUBSTRING_INDEX(rd.reviews_text, ' ', 20) as 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.products_id = '" . (int) $HTTP_GET_VARS['products_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 r.reviews_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int) $languages_id . "' order by r.reviews_rating DESC limit " . (int) MODULE_BOXES_REVIEWS_LISTING_LIMIT);
$data = NULL;
if (tep_db_num_rows($review_query) > 0) {
$data .= '<div class="reviews col-xs-12">';
$data .= '<h2>' . REVIEWS_TEXT_TITLE . '</h2><hr>';
while ($review = tep_db_fetch_array($review_query)) {
$data .= '<blockquote class="col-sm-6">';
$data .= ' <p>' . tep_output_string_protected($review['reviews_text']) . ' ... </p>';
$review_name = tep_output_string_protected($review['customers_name']);
$data .= ' <footer>' . sprintf(REVIEWS_TEXT_RATED, tep_draw_stars($review['reviews_rating']), $review_name, $review_name) . '</footer>';
$data .= '</blockquote>';
}
$data .= '</div>';
$data .= '<div class="clearfix"></div>';
}
}
$oscTemplate->addBlock($data, $this->group);
}
function execute()
{
global $currencies, $oscTemplate;
$OSCOM_Db = Registry::get('Db');
$OSCOM_Language = Registry::get('Language');
$reviews_box_contents = '';
$sql_query = 'select r.reviews_id from :table_reviews r, :table_reviews_description rd, :table_products p, :table_products_description pd where r.reviews_status = 1 and r.products_id = p.products_id and p.products_status = 1 and r.reviews_id = rd.reviews_id and rd.languages_id = :languages_id and p.products_id = pd.products_id and pd.language_id = rd.languages_id';
if (isset($_GET['products_id'])) {
$sql_query .= ' and p.products_id = :products_id';
}
$sql_query .= ' order by r.reviews_id desc limit ' . (int) MAX_RANDOM_SELECT_REVIEWS;
$Qcheck = $OSCOM_Db->prepare($sql_query);
$Qcheck->bindInt(':languages_id', $OSCOM_Language->getId());
if (isset($_GET['products_id'])) {
$Qcheck->bindInt(':products_id', $_GET['products_id']);
}
$Qcheck->execute();
$result = $Qcheck->fetchAll();
if (count($result) > 0) {
$result = $result[mt_rand(0, count($result) - 1)];
$Qreview = $OSCOM_Db->prepare('select r.reviews_id, r.reviews_rating, substring(rd.reviews_text, 1, 60) as reviews_text, 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 r.reviews_id = :reviews_id and r.reviews_id = rd.reviews_id and rd.languages_id = :languages_id and r.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = rd.languages_id');
$Qreview->bindInt(':reviews_id', $result['reviews_id']);
$Qreview->bindInt(':languages_id', $OSCOM_Language->getId());
$Qreview->execute();
if ($Qreview->fetch() !== false) {
// display random review box
$rand_review_text = tep_break_string($Qreview->valueProtected('reviews_text'), 15, '-<br />');
$reviews_box_contents = '<div class="text-center"><a href="' . OSCOM::link('product_reviews.php', 'products_id=' . $Qreview->valueInt('products_id')) . '">' . HTML::image(OSCOM::linkImage($Qreview->value('products_image')), $Qreview->value('products_name'), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a></div><div><a href="' . OSCOM::link('product_reviews.php', 'products_id=' . $Qreview->valueInt('products_id')) . '">' . $rand_review_text . '</a>...</div><div class="text-center" title="' . OSCOM::getDef('module_boxes_reviews_box_text_of_5_stars', ['reviews_rating' => $Qreview->valueInt('reviews_rating')]) . '">' . HTML::stars($Qreview->valueInt('reviews_rating')) . '</div>';
}
} elseif (isset($_GET['products_id'])) {
// display 'write a review' box
$reviews_box_contents = '<span class="fa fa-thumbs-up"></span> <a href="' . OSCOM::link('product_reviews_write.php', 'products_id=' . (int) $_GET['products_id']) . '">' . OSCOM::getDef('module_boxes_reviews_box_write_review') . '</a>';
} else {
// display 'no reviews' box
$reviews_box_contents = '<p>' . OSCOM::getDef('module_boxes_reviews_box_no_reviews') . '</p>';
}
ob_start();
include 'includes/modules/boxes/templates/reviews.php';
$data = ob_get_clean();
$oscTemplate->addBlock($data, $this->group);
}
<tr>
<td>
<table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
<tr class="infoBoxContents">
<td>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td width="10"><?php
echo tep_draw_separator('pixel_trans.gif', '10', '1');
?>
</td>
<td valign="top" class="main">
<table width="100%">
<tr>
<td valign="top" class="main" colspan="2"><?php
echo tep_break_string(tep_output_string_protected($reviews['reviews_text']), 60, '-<br>') . (strlen($reviews['reviews_text']) >= 100 ? '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $product_info['products_id'] . '&reviews_id=' . $reviews['reviews_id']) . '">' . TEXT_READ_MORE . '</a>' : '');
?>
</td>
</tr>
<tr>
<td valign="top" class="main"><?php
echo sprintf(TEXT_REVIEW_RATING, tep_image(DIR_WS_IMAGES . 'icons/stars_' . $reviews['reviews_rating'] . '.gif', sprintf(TEXT_OF_5_STARS, $reviews['reviews_rating'])), sprintf(TEXT_OF_5_STARS, $reviews['reviews_rating'])) . '</i>';
?>
</td>
<td align="right"><?php
echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $product_info['products_id'] . '&reviews_id=' . $reviews['reviews_id']) . '">' . tep_image_button('button_read_review.gif', $reviews['products_name']);
?>
</td>
</tr>
</table>
</td>
switch (substr($file, -3)) {
case 'zip':
$info['compression'] = 'ZIP';
break;
case '.gz':
$info['compression'] = 'GZIP';
break;
default:
$info['compression'] = OSCOM::getDef('text_no_extension');
break;
}
$buInfo = new objectInfo($info);
switch ($action) {
case 'restore':
$heading[] = array('text' => $buInfo->date);
$contents[] = array('text' => tep_break_string(OSCOM::getDef('text_info_restore', ['db_server' => OSCOM::getConfig('db_server'), 'db_user' => OSCOM::getConfig('db_server_username'), 'db_database' => OSCOM::getConfig('db_database'), 'backup_file' => $backup_directory . ($buInfo->compression != OSCOM::getDef('text_no_extension') ? substr($buInfo->file, 0, strrpos($buInfo->file, '.')) : $buInfo->file), 'extra_info' => $buInfo->compression != OSCOM::getDef('text_no_extension') ? OSCOM::getDef('text_info_unpack') : '']), 35, ' '));
$contents[] = array('text' => HTML::button(OSCOM::getDef('image_restore'), 'fa fa-repeat', OSCOM::link(FILENAME_BACKUP, 'file=' . $buInfo->file . '&action=restorenow'), null, 'btn-success') . HTML::button(OSCOM::getDef('image_cancel'), null, OSCOM::link(FILENAME_BACKUP), null, 'btn-link'));
break;
case 'delete':
$heading[] = array('text' => $buInfo->date);
$contents = array('form' => HTML::form('delete', OSCOM::link(FILENAME_BACKUP, 'file=' . $buInfo->file . '&action=deleteconfirm')));
$contents[] = array('text' => OSCOM::getDef('text_delete_intro'));
$contents[] = array('text' => '<strong>' . $buInfo->file . '</strong>');
$contents[] = array('text' => HTML::button(OSCOM::getDef('image_delete'), 'fa fa-trash', null, null, 'btn-danger') . HTML::button(OSCOM::getDef('image_cancel'), null, OSCOM::link(FILENAME_BACKUP), null, 'btn-link'));
break;
}
}
} else {
switch ($action) {
case 'backup':
$heading[] = array('text' => OSCOM::getDef('text_info_heading_new_backup'));
}
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(NAVBAR_TITLE, tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()));
include "includes/header.php";
$xoopsTpl->assign("products_name", $products_name);
$xoopsTpl->assign("products_price", $products_price);
$xoopsTpl->assign("seperator", tep_draw_separator('pixel_trans.gif', '100%', '10'));
$xoopsTpl->assign("review_text", sprintf(TEXT_REVIEW_BY, tep_output_string_protected($review['customers_name'])));
$xoopsTpl->assign("review_date", sprintf(TEXT_REVIEW_DATE_ADDED, tep_date_long($review['date_added'])));
$xoopsTpl->assign("seperator1", tep_draw_separator('pixel_trans.gif', '10', '1'));
$xoopsTpl->assign("review_text_long", tep_break_string(nl2br(tep_output_string_protected($review['reviews_text'])), 60, '-<br>') . '<br><br><i>' . sprintf(TEXT_REVIEW_RATING, tep_image(DIR_WS_IMAGES . 'stars_' . $review['reviews_rating'] . '.gif', sprintf(TEXT_OF_5_STARS, $review['reviews_rating'])), sprintf(TEXT_OF_5_STARS, $review['reviews_rating'])));
$xoopsTpl->assign("review_link", tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params(array('reviews_id'))));
$xoopsTpl->assign("bt_review", tep_image_button('button_write_review.gif', IMAGE_BUTTON_WRITE_REVIEW));
$xoopsTpl->assign("review_write_link", tep_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, tep_get_all_get_params(array('reviews_id'))));
$xoopsTpl->assign("bt_back", tep_image_button('button_back.gif', IMAGE_BUTTON_BACK));
$xoopsTpl->assign("width", SMALL_IMAGE_WIDTH + 10);
if (tep_not_null($review['products_image'])) {
$xoopsTpl->assign("image", 1);
$xoopsTpl->assign("popup_link", tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $review['products_id']));
$xoopsTpl->assign("popup_image", tep_image(DIR_WS_IMAGES . $review['products_image'], addslashes($review['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"'));
$xoopsTpl->assign("html_link", tep_href_link(DIR_WS_IMAGES . $review['products_image']));
$xoopsTpl->assign("html_image", tep_image(DIR_WS_IMAGES . $review['products_image'], $review['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"'));
}
$xoopsTpl->assign("buy_link", tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now'));
$xoopsTpl->assign("bt_cart", tep_image_button('button_in_cart.gif', IMAGE_BUTTON_IN_CART));
include_once XOOPS_ROOT_PATH . '/footer.php';
if (file_exists(LOCAL_EXE_GZIP)) {
$contents[] = array('text' => '<br>' . tep_draw_radio_field('compress', 'gzip') . ' ' . TEXT_INFO_USE_GZIP);
}
if (file_exists(LOCAL_EXE_ZIP)) {
$contents[] = array('text' => tep_draw_radio_field('compress', 'zip') . ' ' . TEXT_INFO_USE_ZIP);
}
if ($dir_ok == true) {
$contents[] = array('text' => '<br>' . tep_draw_checkbox_field('download', 'yes') . ' ' . TEXT_INFO_DOWNLOAD_ONLY . '*<br><br>*' . TEXT_INFO_BEST_THROUGH_HTTPS);
} else {
$contents[] = array('text' => '<br>' . tep_draw_radio_field('download', 'yes', true) . ' ' . TEXT_INFO_DOWNLOAD_ONLY . '*<br><br>*' . TEXT_INFO_BEST_THROUGH_HTTPS);
}
$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_backup.gif', IMAGE_BACKUP) . ' <a href="' . tep_href_link(FILENAME_BACKUP) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
break;
case 'restore':
$heading[] = array('text' => '<b>' . $buInfo->date . '</b>');
$contents[] = array('text' => tep_break_string(sprintf(TEXT_INFO_RESTORE, DIR_FS_BACKUP . ($buInfo->compression != TEXT_NO_EXTENSION ? substr($buInfo->file, 0, strrpos($buInfo->file, '.')) : $buInfo->file), $buInfo->compression != TEXT_NO_EXTENSION ? TEXT_INFO_UNPACK : ''), 35, ' '));
$contents[] = array('align' => 'center', 'text' => '<br><a href="' . tep_href_link(FILENAME_BACKUP, 'file=' . $buInfo->file . '&action=restorenow') . '">' . tep_image_button('button_restore.gif', IMAGE_RESTORE) . '</a> <a href="' . tep_href_link(FILENAME_BACKUP, 'file=' . $buInfo->file) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
break;
case 'restorelocal':
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_RESTORE_LOCAL . '</b>');
$contents = array('form' => tep_draw_form('restore', FILENAME_BACKUP, 'action=restorelocalnow', 'post', 'enctype="multipart/form-data"'));
$contents[] = array('text' => TEXT_INFO_RESTORE_LOCAL . '<br><br>' . TEXT_INFO_BEST_THROUGH_HTTPS);
$contents[] = array('text' => '<br>' . tep_draw_file_field('sql_file'));
$contents[] = array('text' => TEXT_INFO_RESTORE_LOCAL_RAW_FILE);
$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_restore.gif', IMAGE_RESTORE) . ' <a href="' . tep_href_link(FILENAME_BACKUP) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
break;
case 'delete':
$heading[] = array('text' => '<b>' . $buInfo->date . '</b>');
$contents = array('form' => tep_draw_form('delete', FILENAME_BACKUP, 'file=' . $buInfo->file . '&action=deleteconfirm'));
$contents[] = array('text' => TEXT_DELETE_INTRO);
$contents[] = array('text' => '<br><b>' . $buInfo->file . '</b>');
</table>
</td>
</tr>
<tr>
<td>
<table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
<tr class="infoBoxContents">
<td>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td width="10"><?php
echo tep_draw_separator('pixel_trans.gif', '10', '1');
?>
</td>
<td valign="top" class="main"><?php
echo tep_break_string(tep_output_string_protected($reviews['reviews_text']), 60, '-<br>') . '<br>' . '<a href="' . tep_href_link(FILENAME_ARTICLE_REVIEWS_INFO, 'articles_id=' . $article_info['articles_id'] . '&reviews_id=' . $reviews['reviews_id']) . '">' . TEXT_READ_REVIEW . '</a><br><br><i>' . sprintf(TEXT_REVIEW_RATING, tep_image(DIR_WS_IMAGES . 'icons/stars_' . $reviews['reviews_rating'] . '.gif', sprintf(TEXT_OF_5_STARS, $reviews['reviews_rating'])), sprintf(TEXT_OF_5_STARS, $reviews['reviews_rating'])) . '</i>';
?>
</td>
<td width="10" align="right"><?php
echo tep_draw_separator('pixel_trans.gif', '10', '1');
?>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td><?php
echo $reviews_split->display_count(TEXT_DISPLAY_NUMBER_OF_REVIEWS);
?>
</div>
<div class="col-xs-6"><?php
echo $reviews_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info'))) . '<span class="resultText">' . TEXT_RESULT_PAGE . '</span>';
?>
</div>
</div>
</div>
<?php
}
$reviews_query = tep_db_query($reviews_split->sql_query);
$reviewsContent = '';
$reviewsContent .= '<ul>';
while ($reviews = tep_db_fetch_array($reviews_query)) {
$reviewsContent .= '<li class="reviewsList">' . ' <h4><a class="product-name" href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $product_info['products_id'] . '&reviews_id=' . $reviews['reviews_id']) . '">' . sprintf(TEXT_REVIEW_BY, tep_output_string_protected($reviews['customers_name'])) . '</a></h4>' . ' <p class="mesInfo"><span class="dateAdded">' . sprintf(TEXT_REVIEW_DATE_ADDED, tep_date_long($reviews['date_added'])) . '</span></p>' . ' <div class="reviewRating">' . sprintf(TEXT_REVIEW_RATING, tep_draw_rating($reviews['reviews_rating']), sprintf(TEXT_OF_5_STARS, $reviews['reviews_rating'])) . '</div>' . ' <div class="reviewDescription">' . tep_break_string(tep_output_string_protected($reviews['reviews_text']), 60, '-<br />') . (strlen($reviews['reviews_text']) >= 100 ? '..' : '') . '</div>' . '</li>';
}
$reviewsContent .= '</ul>';
echo $reviewsContent;
} else {
?>
<div class="alert alert-warning"> <?php
echo TEXT_NO_REVIEWS;
?>
</div>
<?php
}
if ($reviews_split->number_of_rows > 0 && (PREV_NEXT_BAR_LOCATION == '2' || PREV_NEXT_BAR_LOCATION == '3')) {
?>
<div class="listing-panel bottom-panel">
<div class="row">
?>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="productinfo_description">
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td width="10"><?php
echo tep_draw_separator('pixel_trans.gif', '10', '1');
?>
</td>
<td valign="top" class="main"><?php
echo tep_break_string(nl2br(tep_output_string_protected($review['reviews_text'])), 60, '-<br>') . '<br><br><i>' . sprintf(TEXT_REVIEW_RATING, tep_image(DIR_WS_IMAGES . 'icons/stars_' . $review['reviews_rating'] . '.gif', sprintf(TEXT_OF_5_STARS, $review['reviews_rating'])), sprintf(TEXT_OF_5_STARS, $review['reviews_rating'])) . '</i>';
?>
</td>
<td width="10" align="right"><?php
echo tep_draw_separator('pixel_trans.gif', '10', '1');
?>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td><?php
echo tep_draw_separator('pixel_trans.gif', '100%', '10');
?>
</td>
}
?>
<div class="reviews-list block-content col-xs-8">
<h4><?php
echo sprintf(TEXT_REVIEW_BY, tep_output_string_protected($review['customers_name']));
?>
</h4>
<p class="mesInfo"><span class="date-added"><?php
echo sprintf(TEXT_REVIEW_DATE_ADDED, tep_date_long($review['date_added']));
?>
</span></p>
<?php
echo '<div class="reviewRating">' . sprintf(TEXT_REVIEW_RATING, tep_draw_rating($review['reviews_rating']), sprintf(TEXT_OF_5_STARS, $review['reviews_rating'])) . '</div>';
?>
<div class="reviewDescription"><?php
echo tep_break_string(nl2br(tep_output_string_protected($review['reviews_text'])), 60, '-<br />');
?>
</div>
</div>
<div class="button-container col-xs-12"> <?php
echo tep_draw_button(IMAGE_BUTTON_WRITE_REVIEW, 'comment btn btn-default pull-right', tep_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, tep_get_all_get_params(array('reviews_id'))), 'primary');
?>
<?php
echo tep_draw_button(IMAGE_BUTTON_BACK, 'btn btn-default', tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params(array('reviews_id'))));
?>
</div>
</div>
</div>
<?php
require DIR_WS_INCLUDES . 'template_bottom.php';
require DIR_WS_INCLUDES . 'application_bottom.php';
?>
</td>
</tr>
</table></td>
</tr>
<tr>
<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
<tr class="infoBoxContents">
<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td width="10"><?php
echo tep_draw_separator('pixel_trans.gif', '10', '1');
?>
</td>
<td valign="top" class="main"><?php
echo tep_break_string(nl2br($Qreview->valueProtected('reviews_text')), 60, '-<br>') . '<br><br><i>' . sprintf(TEXT_REVIEW_RATING, tep_image(DIR_WS_IMAGES . 'stars_' . $Qreview->valueInt('reviews_rating') . '.gif', sprintf(TEXT_OF_5_STARS, $Qreview->valueInt('reviews_rating'))), sprintf(TEXT_OF_5_STARS, $Qreview->value('reviews_rating'))) . '</i>';
?>
</td>
<td width="10" align="right"><?php
echo tep_draw_separator('pixel_trans.gif', '10', '1');
?>
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td><?php
echo tep_draw_separator('pixel_trans.gif', '100%', '10');
?>
echo $reviews_split->display_count(TEXT_DISPLAY_NUMBER_OF_REVIEWS);
?>
</div>
<div class="col-xs-6"><?php
echo $reviews_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info'))) . '<span class="resultText">' . TEXT_RESULT_PAGE . '</span>';
?>
</div>
</div>
</div>
<?php
}
$reviews_query = tep_db_query($reviews_split->sql_query);
$reviewContent = '';
$reviewContent .= '<ul>';
while ($reviews = tep_db_fetch_array($reviews_query)) {
$reviewContent .= '<li>' . ' <div class="reviewContainer row">' . ' <div class="reviewImage col-xs-4">' . ' <a class="product-image" href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $reviews['products_id'] . '&reviews_id=' . $reviews['reviews_id']) . '">' . tep_image(DIR_WS_IMAGES . $reviews['products_image'], $reviews['products_name'], HOMEPAGE_IMAGE_WIDTH, HOMEPAGE_IMAGE_HEIGHT, '', '') . '</a>' . ' </div>' . ' <div class="reviewContent col-xs-8">' . ' <div class="reviewInfo">' . ' <h4 class="product-name-box"><a class="product-name" href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $reviews['products_id'] . '&reviews_id=' . $reviews['reviews_id']) . '">' . $reviews['products_name'] . '</a></h4>' . ' <p class="mesInfo">' . ' <span class="authorName">' . sprintf(TEXT_REVIEW_BY, tep_output_string_protected($reviews['customers_name'])) . '</span>' . ' <span class="dateAdded">' . sprintf(TEXT_REVIEW_DATE_ADDED, tep_date_long($reviews['date_added'])) . '</span>' . ' </p>' . ' <div class="reviewRating">' . sprintf(TEXT_REVIEW_RATING, tep_draw_rating($reviews['reviews_rating']), sprintf(TEXT_OF_5_STARS, $reviews['reviews_rating'])) . '</div>' . ' </div>' . ' <div class="reviewDescription">' . tep_break_string(tep_output_string_protected($reviews['reviews_text']), 60, '-<br />') . (strlen($reviews['reviews_text']) >= 100 ? '..' : '') . '</div>' . ' </div>' . ' </div>' . '</li>';
}
$reviewContent .= '</ul>';
echo $reviewContent;
} else {
?>
<div class="alert alert-info"> <?php
echo TEXT_NO_REVIEWS;
?>
</div>
<?php
}
if ($reviews_split->number_of_rows > 0 && (PREV_NEXT_BAR_LOCATION == '2' || PREV_NEXT_BAR_LOCATION == '3')) {
?>
<div class="listing-panel bottom-panel">
<div class="row">
<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 //-->
</td>
<td class="main" align="right" valign="top"><?php
echo HTML::image(OSCOM::linkImage('Shop/' . $rInfo->products_image), $rInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"');
?>
</td>
</tr>
</table>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top" class="main"><strong><?php
echo OSCOM::getDef('entry_review');
?>
</strong><br /><br /><?php
echo nl2br(HTML::output(tep_break_string($rInfo->reviews_text, 15)));
?>
</td>
</tr>
</table></td>
</tr>
<tr>
<td class="main"><strong><?php
echo OSCOM::getDef('entry_rating');
?>
</strong> <?php
echo HTML::image(OSCOM::linkImage('Shop/stars_' . $rInfo->reviews_rating . '.gif'), OSCOM::getDef('text_of_5_stars', ['reviews_rating' => $rInfo->reviews_rating]));
?>
<small>[<?php
echo OSCOM::getDef('text_of_5_stars', ['reviews_rating' => $rInfo->reviews_rating]);
?>
$reviews_split = new splitPageResults($reviews_query_raw, MAX_DISPLAY_NEW_REVIEWS);
$xoopsTpl->assign("revsplit", $reviews_split->display_count(TEXT_DISPLAY_NUMBER_OF_REVIEWS));
$xoopsTpl->assign("revlinks", $reviews_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info'))));
if ($reviews_split->number_of_rows > 0) {
$xoopsTpl->assign("srevs", 1);
if (PREV_NEXT_BAR_LOCATION == '1' || PREV_NEXT_BAR_LOCATION == '3') {
$xoopsTpl->assign("sresult", 1);
}
$reviews_query = tep_db_query($reviews_split->sql_query);
$i = 0;
while ($reviews = tep_db_fetch_array($reviews_query)) {
$revs[$i] = $reviews;
$revs[$i]['link'] = tep_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $product_info['products_id'] . '&reviews_id=' . $reviews['reviews_id']);
$revs[$i]['customers_name'] = sprintf(TEXT_REVIEW_BY, tep_output_string_protected($reviews['customers_name']));
$revs[$i]['date_added'] = sprintf(TEXT_REVIEW_DATE_ADDED, tep_date_long($reviews['date_added']));
$revs[$i]['reviews_text'] = tep_break_string(tep_output_string_protected($reviews['reviews_text']), 60, '-<br>') . (strlen($reviews['reviews_text']) >= 100 ? '..' : '');
$revs[$i]['reviews_rating'] = sprintf(TEXT_REVIEW_RATING, tep_image(DIR_WS_IMAGES . 'stars_' . $reviews['reviews_rating'] . '.gif', sprintf(TEXT_OF_5_STARS, $reviews['reviews_rating'])), sprintf(TEXT_OF_5_STARS, $reviews['reviews_rating']));
$i++;
}
$xoopsTpl->assign("revs", $revs);
} else {
$notxt = new infoBox(array(array('text' => TEXT_NO_REVIEWS)));
$xoopsTpl->assign("notext", $notxt->content);
}
if ($reviews_split->number_of_rows > 0 && (PREV_NEXT_BAR_LOCATION == '2' || PREV_NEXT_BAR_LOCATION == '3')) {
$xoopsTpl->assign("srevsplit", 1);
}
$xoopsTpl->assign("product_info_link", tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params()));
$xoopsTpl->assign("product_review_link", tep_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, tep_get_all_get_params()));
$xoopsTpl->assign("bt_back", tep_image_button('button_back.gif', IMAGE_BUTTON_BACK));
$xoopsTpl->assign("bt_write", tep_image_button('button_write_review.gif', IMAGE_BUTTON_WRITE_REVIEW));
?>
</h2>
</div>
<div class="contentText">
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td width="<?php
echo SMALL_IMAGE_WIDTH + 10;
?>
" align="center" valign="top" class="main"><?php
echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $reviews['products_id'] . '&reviews_id=' . $reviews['reviews_id']) . '">' . tep_image(DIR_WS_IMAGES . $reviews['products_image'], $reviews['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>';
?>
</td>
<td valign="top"><?php
echo tep_break_string(tep_output_string_protected($reviews['reviews_text']), 60, '-<br />') . (strlen($reviews['reviews_text']) >= 100 ? '..' : '') . '<br /><br /><i>' . sprintf(TEXT_REVIEW_RATING, tep_image(DIR_WS_IMAGES . 'stars_' . $reviews['reviews_rating'] . '.gif', sprintf(TEXT_OF_5_STARS, $reviews['reviews_rating'])), sprintf(TEXT_OF_5_STARS, $reviews['reviews_rating'])) . '</i>';
?>
</td>
</tr>
</table>
</div>
<?php
}
} else {
?>
<div class="contentText">
<?php
echo TEXT_NO_REVIEWS;
?>
$Qreviews->bindRaw(':table_products', TABLE_PRODUCTS);
$Qreviews->bindRaw(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
$Qreviews->bindInt(':language_id', $osC_Session->value('languages_id'));
$Qreviews->bindInt(':language_id', $osC_Session->value('languages_id'));
$Qreviews->bindRaw(':max_random_select_reviews', MAX_RANDOM_SELECT_REVIEWS);
if (isset($_GET['products_id']) && is_numeric($_GET['products_id'])) {
$Qreviews->bindInt(':products_id', $_GET['products_id']);
}
if ($Qreviews->executeRandomMulti()) {
// display random review box
$Qreview_text = $osC_Database->query('select substring(reviews_text, 1, 60) as reviews_text from :table_reviews where reviews_id = :reviews_id and languages_id = :languages_id');
$Qreview_text->bindRaw(':table_reviews', TABLE_REVIEWS);
$Qreview_text->bindInt(':reviews_id', $Qreviews->valueInt('reviews_id'));
$Qreview_text->bindInt(':languages_id', $osC_Session->value('languages_id'));
$Qreview_text->execute();
$review_text = tep_break_string($Qreview_text->valueProtected('reviews_text'), 15, '-<br>');
$info_box_contents[] = array('text' => '<div align="center"><a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $Qreviews->valueInt('products_id') . '&reviews_id=' . $Qreviews->valueInt('reviews_id')) . '">' . tep_image(DIR_WS_IMAGES . $Qreviews->value('products_image'), $Qreviews->value('products_name'), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a></div><a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $Qreviews->valueInt('products_id') . '&reviews_id=' . $Qreviews->valueInt('reviews_id')) . '">' . $review_text . ' ..</a><br><div align="center">' . tep_image(DIR_WS_IMAGES . 'stars_' . $Qreviews->valueInt('reviews_rating') . '.gif', sprintf(BOX_REVIEWS_TEXT_OF_5_STARS, $Qreviews->valueInt('reviews_rating'))) . '</div>');
$Qreview_text->freeResult();
$Qreviews->freeResult();
} elseif (isset($_GET['products_id']) && is_numeric($_GET['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=' . $_GET['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=' . $_GET['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 //-->
