<!-- bof: dgReviews-->
$review_status = " and r.status = ‘1’";
/* This is where you change the parameter value to output 1000 charaters or equivelent */
r
e
v
i
e
w
s
q
u
e
r
y
r
a
w
=
"
s
e
l
e
c
t
r
.
r
e
v
i
e
w
s
i
d
,
l
e
f
t
(
r
d
.
r
e
v
i
e
w
s
t
e
x
t
,
1000
)
a
s
r
e
v
i
e
w
s
t
e
x
t
,
r
.
r
e
v
i
e
w
s
r
a
t
i
n
g
,
r
.
d
a
t
e
a
d
d
e
d
,
r
.
c
u
s
t
o
m
e
r
s
n
a
m
e
f
r
o
m
"
.
T
A
B
L
E
R
E
V
I
E
W
S
.
"
r
,
"
.
T
A
B
L
E
R
E
V
I
E
W
S
D
E
S
C
R
I
P
T
I
O
N
.
"
r
d
w
h
e
r
e
r
.
p
r
o
d
u
c
t
s
i
d
=
′
"
.
(
i
n
t
)
reviews_query_raw = "select r.reviews_id, left(rd.reviews_text, 1000) as reviews_text, r.reviews_rating, r.date_added, r.customers_name from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd where r.products_id = '" . (int)
reviewsqueryraw="selectr.reviewsid,left(rd.reviewstext,1000)asreviewstext,r.reviewsrating,r.dateadded,r.customersnamefrom".TABLEREVIEWS."r,".TABLEREVIEWSDESCRIPTION."rdwherer.productsid=′".(int)_GET[‘products_id’] . “’
and r.reviews_id = rd.reviews_id
and rd.languages_id = '” . (int)$_SESSION[‘languages_id’] . “’” .
$review_status . "
order by r.reviews_id desc";
r e v i e w s s p l i t = n e w s p l i t P a g e R e s u l t s ( reviews_split = new splitPageResults( reviewssplit=newsplitPageResults(reviews_query_raw, MAX_DISPLAY_NEW_REVIEWS);
if ($reviews_split->number_of_rows > 0) {
if ((PREV_NEXT_BAR_LOCATION == ‘1’) || (PREV_NEXT_BAR_LOCATION == ‘3’)) {
?>
<?php }
$reviews = $db->Execute($reviews_split->sql_query);
while (!$reviews->EOF) {
?>
<?php // change the class name here to reflect your CSS page ?>' . zen_break_string(zen_output_string_protected(stripslashes($reviews->fields['reviews_text'])), 35, ''); ?>
<div class="navSplitPagesResult"><?php echo $reviews_split->display_count(TEXT_DISPLAY_NUMBER_OF_REVIEWS); ?></div>