RecordCount() > 0) { // display random review box $review_box_text_query = "select substring(reviews_text, 1, 60) as reviews_text from " . TABLE_REVIEWS_DESCRIPTION . " where reviews_id = '" . (int)$random_review_sidebox_product->fields['reviews_id'] . "' and languages_id = '" . (int)$_SESSION['languages_id'] . "'"; $review_box_text = $db->Execute($review_box_text_query); // $review_box_text = zen_break_string(zen_output_string_protected($review_box_text->fields['reviews_text']), 15, '-
'); $review_box_text = zen_break_string(nl2br(zen_output_string_protected(stripslashes($review_box_text->fields['reviews_text']))), 60, '-
'); require($template->get_template_dir('tpl_reviews_random.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_reviews_random.php'); } elseif (isset($_GET['products_id']) and zen_products_id_valid($_GET['products_id'])) { // display 'write a review' box require($template->get_template_dir('tpl_reviews_write.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_reviews_write.php'); } else { // display 'no reviews' box require($template->get_template_dir('tpl_reviews_none.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_reviews_none.php'); } $title = BOX_HEADING_REVIEWS; $title_link = FILENAME_REVIEWS; require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default); ?>