if (strlen($rows) < 2) {
$rows = '0' . $rows;
}
?>
<tr class="dataTableRow" onMouseOver="rowOverEffect(this)" onMouseOut="rowOutEffect(this)" onClick="document.location.href='<?php
echo tep_href_link(FILENAME_CUSTOMERS, 'search=' . tep_customers_lname($customers['customers_id']), 'NONSSL');
?>
'">
<td class="dataTableContent"><?php
echo $rows;
?>
.</td>
<td class="dataTableContent"><?php
echo '<a href="' . tep_href_link(FILENAME_CUSTOMERS, 'search=' . tep_customers_lname($customers['customers_id']), 'NONSSL') . '">' . tep_customers_name($customers['customers_id']) . '</a>';
?>
</td>
<td class="dataTableContent" align="center"><?php
echo $currencies->format(0);
?>
</td>
<td class="dataTableContent" align="right"><?php
echo tep_date_short(tep_customers_join_date($customers['customers_id']));
?>
</td>
</tr>
<?php
}
?>
</table></td>
tep_db_query("update " . TABLE_REVIEWS . " set reviews_rating = '" . tep_db_input($reviews_rating) . "', reviews_status = '" . tep_db_input($reviews_status) . "', last_modified = now() where reviews_id = '" . (int) $reviews_id . "'");
tep_db_query("update " . TABLE_REVIEWS_DESCRIPTION . " set reviews_text = '" . tep_db_input($reviews_text) . "' where reviews_id = '" . (int) $reviews_id . "'");
tep_redirect(tep_href_link('reviews.php', 'page=' . $HTTP_GET_VARS['page'] . '&rID=' . $reviews_id));
break;
case 'deleteconfirm':
$reviews_id = tep_db_prepare_input($HTTP_GET_VARS['rID']);
tep_db_query("delete from " . TABLE_REVIEWS . " where reviews_id = '" . (int) $reviews_id . "'");
tep_db_query("delete from " . TABLE_REVIEWS_DESCRIPTION . " where reviews_id = '" . (int) $reviews_id . "'");
tep_redirect(tep_href_link('reviews.php', 'page=' . $HTTP_GET_VARS['page']));
break;
case 'addnew':
$products_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']);
$customers_id = tep_db_prepare_input($HTTP_POST_VARS['customer_id']);
$review = tep_db_prepare_input($HTTP_POST_VARS['reviews_text']);
$rating = tep_db_prepare_input($HTTP_POST_VARS['rating']);
tep_db_query("insert into " . TABLE_REVIEWS . " (products_id, customers_id, customers_name, reviews_rating, date_added, reviews_status) values ('" . (int) $products_id . "', '" . (int) $customers_id . "', '" . tep_customers_name($customers_id) . "', '" . (int) $rating . "', now(), 1)");
$insert_id = tep_db_insert_id();
tep_db_query("insert into " . TABLE_REVIEWS_DESCRIPTION . " (reviews_id, languages_id, reviews_text) values ('" . (int) $insert_id . "', '" . (int) $languages_id . "', '" . $review . "')");
tep_redirect(tep_href_link('reviews.php', tep_get_all_get_params(array('action'))));
break;
}
}
require 'includes/template_top.php';
?>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="pageHeading"><?php
echo HEADING_TITLE;
