</td>
<td class="main" align="right" valign="top"><?php
echo zen_image(DIR_WS_CATALOG_IMAGES . $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"><b><?php
echo ENTRY_REVIEW;
?>
</b><br><br><?php
echo nl2br(zen_db_output(zen_break_string($rInfo->reviews_text, 15)));
?>
</td>
</tr>
</table></td>
</tr>
<tr>
<td><?php
echo zen_draw_separator('pixel_trans.gif', '1', '10');
?>
</td>
</tr>
<tr>
<td class="main"><b><?php
echo ENTRY_RATING;
?>
if (@file_exists(LOCAL_EXE_ZIP)) {
$contents[] = array('text' => zen_draw_radio_field('compress', 'zip', !@file_exists(LOCAL_EXE_GZIP) ? true : false) . ' ' . TEXT_INFO_USE_ZIP);
}
$contents[] = array('text' => '<br />' . zen_draw_radio_field('skiplocks', 'yes', false) . ' ' . TEXT_INFO_SKIP_LOCKS);
// Download to file --- Should only be done if SSL is active, otherwise database is exposed as clear text
if ($dir_ok == true) {
$contents[] = array('text' => '<br />' . zen_draw_checkbox_field('download', 'yes') . ' ' . TEXT_INFO_DOWNLOAD_ONLY . '*<br /><span class="errorText">*' . TEXT_INFO_BEST_THROUGH_HTTPS . '</span>');
} else {
$contents[] = array('text' => '<br />' . zen_draw_radio_field('download', 'yes', true) . ' ' . TEXT_INFO_DOWNLOAD_ONLY . '*<br /><span class="errorText">*' . TEXT_INFO_BEST_THROUGH_HTTPS . '</span>');
}
// display backup button
$contents[] = array('align' => 'center', 'text' => '<br />' . zen_image_submit('button_backup.gif', IMAGE_BACKUP) . ' <a href="' . zen_href_link(FILENAME_BACKUP_MYSQL, $debug == 'ON' ? 'debug=ON' : '') . ($tables_to_export != '' ? '&tables=' . str_replace(' ', ',', $tables_to_export) : '') . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
break;
case 'restore':
$heading[] = array('text' => '<strong>' . $buInfo->date . '</strong>');
$contents[] = array('text' => zen_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="' . zen_href_link(FILENAME_BACKUP_MYSQL, 'file=' . $buInfo->file . '&action=restorenow' . ($debug == 'ON' ? '&debug=ON' : '')) . '">' . zen_image_button('button_restore.gif', IMAGE_RESTORE) . '</a> <a href="' . zen_href_link(FILENAME_BACKUP_MYSQL, 'file=' . $buInfo->file . ($debug == 'ON' ? '&debug=ON' : '')) . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
break;
case 'restorelocal':
$heading[] = array('text' => '<strong>' . TEXT_INFO_HEADING_RESTORE_LOCAL . '</strong>');
$contents = array('form' => zen_draw_form('restore', FILENAME_BACKUP_MYSQL, 'action=restorelocalnow' . ($debug == 'ON' ? '&debug=ON' : ''), 'post', 'enctype="multipart/form-data"'));
$contents[] = array('text' => TEXT_INFO_RESTORE_LOCAL . '<br /><br />' . TEXT_INFO_BEST_THROUGH_HTTPS);
$contents[] = array('text' => '<br />' . zen_draw_file_field('sql_file'));
$contents[] = array('text' => TEXT_INFO_RESTORE_LOCAL_RAW_FILE);
$contents[] = array('align' => 'center', 'text' => '<br />' . zen_image_submit('button_restore.gif', IMAGE_RESTORE) . ' <a href="' . zen_href_link(FILENAME_BACKUP_MYSQL, $debug == 'ON' ? 'debug=ON' : '') . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
break;
case 'delete':
if ($dir_ok == false) {
continue;
}
$heading[] = array('text' => '<strong>' . $buInfo->date . '</strong>');
<div class="rating"><?php
echo zen_image(DIR_WS_TEMPLATE_IMAGES . 'stars_' . $reviews->fields['reviews_rating'] . '.gif', sprintf(TEXT_OF_5_STARS, $reviews->fields['reviews_rating'])), sprintf(TEXT_OF_5_STARS, $reviews->fields['reviews_rating']);
?>
</div>
<div class="date-added"><?php
echo sprintf(TEXT_REVIEW_DATE_ADDED, zen_date_short($reviews->fields['date_added']));
?>
<?php
echo sprintf(TEXT_REVIEW_BY, zen_output_string_protected($reviews->fields['customers_name']));
?>
</div>
<div class="content"><?php
echo zen_break_string(nl2br(zen_output_string_protected(stripslashes($reviews->fields['reviews_text']))), 60, '-<br />') . (strlen($reviews->fields['reviews_text']) >= 100 ? '...' : '');
?>
</div>
<div class="rev-but">
<div class="btn1"><?php
echo '<a href="' . zen_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $reviews->fields['products_id'] . '&reviews_id=' . $reviews->fields['reviews_id']) . '">' . zen_image_button(BUTTON_IMAGE_READ_REVIEWS, BUTTON_READ_REVIEWS_ALT) . '</a>';
?>
</div>
<div class="btn1"><?php
echo '<a href="' . zen_href_link(zen_get_info_page($reviews->fields['products_id']), 'products_id=' . $reviews->fields['products_id']) . '">' . zen_image_button(BUTTON_IMAGE_GOTO_PROD_DETAILS, BUTTON_GOTO_PROD_DETAILS_ALT) . '</a>';
?>
</div>
</div>
<br class="clearBoth" />
?>
</td>
</tr>
<tr>
<td class="main"><span class="greetUser"><?php
echo sprintf(TEXT_REVIEW_BY, zen_output_string_protected($reviews->fields['customers_name']));
?>
<span></td>
<td class="smallText" align="right"><?php
echo sprintf(TEXT_REVIEW_DATE_ADDED, zen_date_short($reviews->fields['date_added']));
?>
</td>
</tr>
<tr>
<td valign="top" class="main" colspan="2"><?php
echo zen_break_string(zen_output_string_protected(stripslashes(substr($reviews->fields['reviews_text'], 0, 100))), 60, '-<br />') . (strlen($reviews->fields['reviews_text']) >= 100 ? '..' : '') . '<br /><br /><i>' . sprintf(TEXT_REVIEW_RATING, zen_image(DIR_WS_TEMPLATE_IMAGES . 'stars_' . $reviews->fields['reviews_rating'] . '.png', sprintf(TEXT_OF_5_STARS, $reviews->fields['reviews_rating'])), sprintf(TEXT_OF_5_STARS, $reviews->fields['reviews_rating'])) . '</i>';
?>
</td>
</tr>
<?php
$reviews->MoveNext();
}
} else {
?>
<tr>
<td align="left" class="smallText" colspan="2">
<?php
echo '<a href="' . zen_href_link(zen_get_info_page($_GET['products_id']), zen_get_all_get_params()) . '">' . TEXT_PRODUCT_INFO . '</a>';
?>
</td>
</tr>
<div class="productReviewsDefaultReviewer bold"><?php
echo sprintf(TEXT_REVIEW_DATE_ADDED, zen_date_short($reviews['dateAdded']));
?>
<?php
echo sprintf(TEXT_REVIEW_BY, zen_output_string_protected($reviews['customersName']));
?>
</div>
<div class="rating"><?php
echo zen_image(DIR_WS_TEMPLATE_IMAGES . 'stars_' . $reviews['reviewsRating'] . '.gif', sprintf(TEXT_OF_5_STARS, $reviews['reviewsRating'])), sprintf(TEXT_OF_5_STARS, $reviews['reviewsRating']);
?>
</div>
<div class="productReviewsDefaultProductMainContent content"><?php
echo zen_break_string(zen_output_string_protected(stripslashes($reviews['reviewsText'])), 600, '-<br />') . (strlen($reviews['reviewsText']) >= 100 ? '' : '');
?>
</div>
<br class="clearBoth" />
<?php
}
} else {
?>
<hr />
<div id="productReviewsDefaultNoReviews" class="content"><?php
echo TEXT_NO_REVIEWS . (REVIEWS_APPROVAL == '1' ? '<br />' . TEXT_APPROVAL_REQUIRED : '');
?>
</div>
<br class="clearBoth" />
</div> </div> <h1 id="reviewsInfoDefaultHeading"><?php echo $products_name . $products_model; ?> </h1> <h2 id="reviewsInfoDefaultPrice" class=""><?php echo $products_price; ?> </h2> <h3 class="rating"><?php echo zen_image(DIR_WS_TEMPLATE_IMAGES . 'stars_' . $review_info->fields['reviews_rating'] . '.gif', sprintf(TEXT_OF_5_STARS, $review_info->fields['reviews_rating'])), sprintf(TEXT_OF_5_STARS, $review_info->fields['reviews_rating']); ?> </h3> <div id="reviewsInfoDefaultMainContent" class="content"><?php echo zen_break_string(nl2br(zen_output_string_protected(stripslashes($review_info->fields['reviews_text']))), 60, '-<br />'); ?> </div> <div id="reviewsInfoDefaultDate" class="bold"><?php echo sprintf(TEXT_REVIEW_DATE_ADDED, zen_date_short($review_info->fields['date_added'])); ?> <?php echo sprintf(TEXT_REVIEW_BY, zen_output_string_protected($review_info->fields['customers_name'])); ?> </div> </div>
?>
</td>
</tr>
<tr>
<td class="main"><span class="greetUser"><?php
echo sprintf(TEXT_REVIEW_BY, zen_output_string_protected($review_info->fields['customers_name']));
?>
</span></td>
<td class="smallText" align="right"><?php
echo sprintf(TEXT_REVIEW_DATE_ADDED, zen_date_short($review_info->fields['date_added']));
?>
</td>
</tr>
<tr>
<td valign="top" class="main" colspan="2"><?php
echo zen_break_string(nl2br(zen_output_string_protected(stripslashes($review_info->fields['reviews_text']))), 60, '-<br />') . '<br /><br /><i>' . sprintf(TEXT_REVIEW_RATING, zen_image(DIR_WS_TEMPLATE_IMAGES . 'stars_' . $review_info->fields['reviews_rating'] . '.png', sprintf(TEXT_OF_5_STARS, $review_info->fields['reviews_rating'])), sprintf(TEXT_OF_5_STARS, $review_info->fields['reviews_rating'])) . '</i>';
?>
</td>
</tr>
<tr>
<td class="main"><?php
echo zen_back_link() . zen_image_button(BUTTON_IMAGE_BACK, BUTTON_BACK_ALT) . '</a>';
?>
</td>
<td class="main" align="right"><?php
echo '<a href="' . zen_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, zen_get_all_get_params(array('reviews_id'))) . '">' . zen_image_button(BUTTON_IMAGE_WRITE_REVIEW, BUTTON_WRITE_REVIEW_ALT) . '</a>';
?>
</td>
</tr>
</table>
$review_status = " and r.status = '1'";
/* This is where you change the parameter value to output 1000 charaters or equivelent */
$reviews_query_raw = "select r.reviews_id, left(rd.reviews_text, 1000) as reviews_text,\n r.reviews_rating, r.date_added, r.customers_name\n from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd\n where r.products_id = '" . (int) $_GET['products_id'] . "'\n and r.reviews_id = rd.reviews_id\n and rd.languages_id = '" . (int) $_SESSION['languages_id'] . "'" . $review_status . "\n order by r.date_added";
$reviews_split = new splitPageResults($reviews_query_raw, $review_display_limit);
$reviews = $db->Execute($reviews_split->sql_query);
while (!$reviews->EOF) {
?>
<?php
// change the class name here to reflect your CSS page
?>
<div class="product_info_ratings">
<h3>
<?php
echo sprintf(TEXT_REVIEW_BY, zen_output_string_protected($reviews->fields['customers_name']));
?>
</h3>
<p class="text">
<span class="product-rating">
<?php
echo sprintf(zen_image(DIR_WS_TEMPLATE_IMAGES . 'stars_' . $reviews->fields['reviews_rating'] . '_small.png'));
?>
</span>
<?php
echo zen_break_string(zen_output_string_protected(stripslashes($reviews->fields['reviews_text'])), 35, '-<br />');
?>
</p>
</div>
<?php
$reviews->MoveNext();
}
//this is the end of dgReview
<div id="productReviewsDefaultReviewer" class="bold"><?php
echo sprintf(TEXT_REVIEW_DATE_ADDED, zen_date_short($review['dateAdded']));
?>
<?php
echo sprintf(TEXT_REVIEW_BY, zen_output_string_protected($review['customersName']));
?>
</div>
<div class="rating"><?php
echo zen_image(DIR_WS_TEMPLATE_IMAGES . 'stars_' . $review['reviewsRating'] . '.gif', sprintf(TEXT_OF_5_STARS, $review['reviewsRating'])), sprintf(TEXT_OF_5_STARS, $review['reviewsRating']);
?>
</div>
<div id="productReviewsDefaultProductMainContent" class="content"><?php
echo zen_break_string(nl2br(zen_output_string_protected(stripslashes($review['reviewsText']))), 60, '-<br />');
?>
</div>
<br class="clearBoth" />
<?php
}
echo '<div class="view_all_reviws"><a href="' . zen_href_link($page = 'addon', $parameters = 'module=easy_reviews/product_reviews&products_id=' . (int) $_GET['products_id']) . '">' . VIEW_ALL_REVIEWS . '</a></div>';
} else {
?>
<hr />
<div id="productReviewsDefaultNoReviews" class="content"><?php
echo TEXT_NO_REVIEWS . (REVIEWS_APPROVAL == '1' ? '<br />' . TEXT_APPROVAL_REQUIRED : '');
?>
</div>
<div class="kuang1">
<div class="thename">
<?php
echo sprintf(TEXT_REVIEW_BY, zen_output_string_protected($reviews->fields['customers_name']));
?>
</div>
<div class="thedate">
<?php
echo sprintf(TEXT_REVIEW_DATE_ADDED, zen_date_short($reviews->fields['date_added']));
?>
</div>
</div>
<br class="clearBoth" />
<div valign="top" class="main123" colspan="2">
<div style="margin: 10px;"><?php
echo zen_break_string(zen_output_string_protected(stripslashes($reviews->fields['reviews_text'])), 35, '<br />') . '<br /><br />' . sprintf(TEXT_REVIEW_RATING, zen_image(DIR_WS_TEMPLATE_IMAGES . 'stars_' . $reviews->fields['reviews_rating'] . '.gif', sprintf('<a href="http://www.uslouisvuittononlineshop.com" title="Louis Vuitton Outlet Online">Louis Vuitton Outlet Online</a>', $reviews->fields['reviews_rating'])), sprintf('<a href="http://www.uslouisvuittononlineshop.com" title="Louis Vuitton Handbags">Louis Vuitton Handbags</a>', $reviews->fields['reviews_rating']));
?>
</div>
</div>
</div>
<?php
$reviews->MoveNext();
}
} else {
?>
<?php
}
if ($reviews_split->number_of_rows > 0 && (PREV_NEXT_BAR_LOCATION == '2' || PREV_NEXT_BAR_LOCATION == '3')) {
?>
<br>
<?php
echo sprintf(TEXT_REVIEW_BY, zen_output_string_protected($reviews['customersName']));
?>
</div>
<div class="rating">
<?php
echo BOX_REVIEWS_RANK . zen_image(DIR_WS_TEMPLATE_IMAGES . 'stars_' . $reviews['reviewsRating'] . '.gif', sprintf(TEXT_OF_5_STARS, $reviews['reviewsRating'])), sprintf(TEXT_OF_5_STARS, $reviews['reviewsRating']);
?>
</div>
<div id="productReviewsDefaultProductMainContent" class="content">
<?php
echo BOX_REVIEWS_COMMENT;
echo zen_break_string(zen_output_string_protected(stripslashes($reviews['reviewsText'])), 60, '') . (strlen($reviews['reviewsText']) >= 30 ? '...' : '');
?>
</div>
<?php
echo '<a href="' . zen_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . (int) $_GET['products_id'] . '&reviews_id=' . $reviews['id']) . '">' . BUTTON_READ_REVIEWS_ALT . '</a>';
?>
<?php
}
} else {
?>
<hr size="1" width="95%" align="center" color="<?php
echo MOBILE_THEME_COLOR;
?>
">