[TEP-COMMIT] [CVS admin] New Reviews System
mevans-OfajU3CKLf1/[email protected] 3 Nov 2004 09:00:11 -0000
| Newsgroups | gmane.comp.web.oscommerce.cvs |
|---|---|
| Message-ID | <[email protected]> |
<html>
<head>
<style><!--
body {background-color:#ffffff;}
.file {border:1px solid #eeeeee;margin-top:1em;margin-bottom:1em;}
.pathname {font-family:monospace; float:right;}
.fileheader {margin-bottom:.5em;}
.diff {margin:0;}
.tasklist {padding:4px;border:1px dashed #000000;margin-top:1em;}
.tasklist ul {margin-top:0;margin-bottom:0;}
tr.alt {background-color:#eeeeee}
#added {background-color:#ddffdd;}
#addedchars {background-color:#99ff99;font-weight:bolder;}
tr.alt #added {background-color:#ccf7cc;}
#removed {background-color:#ffdddd;}
#removedchars {background-color:#ff9999;font-weight:bolder;}
tr.alt #removed {background-color:#f7cccc;}
#info {color:#888888;}
#context {background-color:#eeeeee;}
td {padding-left:.3em;padding-right:.3em;}
tr.head {border-bottom-width:1px;border-bottom-style:solid;}
tr.head td {padding:0;padding-top:.2em;}
.task {background-color:#ffff00;}
.comment {padding:4px;border:1px dashed #000000;background-color:#ffffdd}
.error {color:red;}
hr {border-width:0px;height:2px;background:black;}
--></style>
</head>
<body>
<table cellspacing="0" cellpadding="0" border="0" rules="cols">
<tr class="head"><td colspan="4">Commit in <b><tt>admin/admin</tt></b><span id="info"> on MAIN</span></td></tr>
<tr><td><tt><a href="#file1">backup.php</a></tt></td><td align="right" id="added">+1</td><td align="right" id="removed">-2</td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/backup.php?rev=1.64&content-type=text/vnd.viewcvs-markup">1.64</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/backup.php.diff?r1=1.64&r2=1.65">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/backup.php?rev=1.65&content-type=text/vnd.viewcvs-markup">1.65</a></td></tr>
<tr class="alt"><td><tt><a href="#file2">customers.php</a></tt></td><td align="right" id="added">+3</td><td align="right" id="removed">-22</td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/customers.php?rev=1.90&content-type=text/vnd.viewcvs-markup">1.90</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/customers.php.diff?r1=1.90&r2=1.91">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/customers.php?rev=1.91&content-type=text/vnd.viewcvs-markup">1.91</a></td></tr>
<tr><td><tt><a href="#file3">reviews.php</a></tt></td><td align="right" id="added">+46</td><td align="right" id="removed">-11</td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/reviews.php?rev=1.45&content-type=text/vnd.viewcvs-markup">1.45</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/reviews.php.diff?r1=1.45&r2=1.46">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/reviews.php?rev=1.46&content-type=text/vnd.viewcvs-markup">1.46</a></td></tr>
<tr class="alt"><td><tt>includes/languages/<a href="#file4">english.php</a></tt></td><td align="right" id="added">+2</td><td></td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/english.php?rev=1.122&content-type=text/vnd.viewcvs-markup">1.122</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/english.php.diff?r1=1.122&r2=1.123">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/english.php?rev=1.123&content-type=text/vnd.viewcvs-markup">1.123</a></td></tr>
<tr><td><tt> /<a href="#file5">espanol.php</a></tt></td><td align="right" id="added">+2</td><td></td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/espanol.php?rev=1.117&content-type=text/vnd.viewcvs-markup">1.117</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/espanol.php.diff?r1=1.117&r2=1.118">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/espanol.php?rev=1.118&content-type=text/vnd.viewcvs-markup">1.118</a></td></tr>
<tr class="alt"><td><tt> /<a href="#file6">german.php</a></tt></td><td align="right" id="added">+2</td><td></td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/german.php?rev=1.116&content-type=text/vnd.viewcvs-markup">1.116</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/german.php.diff?r1=1.116&r2=1.117">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/german.php?rev=1.117&content-type=text/vnd.viewcvs-markup">1.117</a></td></tr>
<tr><td><tt>includes/languages/english/<a href="#file7">reviews.php</a></tt></td><td align="right" id="added">+1</td><td></td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/english/reviews.php?rev=1.7&content-type=text/vnd.viewcvs-markup">1.7</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/english/reviews.php.diff?r1=1.7&r2=1.8">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/english/reviews.php?rev=1.8&content-type=text/vnd.viewcvs-markup">1.8</a></td></tr>
<tr class="alt"><td><tt>includes/languages/espanol/<a href="#file8">reviews.php</a></tt></td><td align="right" id="added">+1</td><td></td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/espanol/reviews.php?rev=1.6&content-type=text/vnd.viewcvs-markup">1.6</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/espanol/reviews.php.diff?r1=1.6&r2=1.7">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/espanol/reviews.php?rev=1.7&content-type=text/vnd.viewcvs-markup">1.7</a></td></tr>
<tr><td><tt>includes/languages/german/<a href="#file9">reviews.php</a></tt></td><td align="right" id="added">+1</td><td></td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/german/reviews.php?rev=1.7&content-type=text/vnd.viewcvs-markup">1.7</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/german/reviews.php.diff?r1=1.7&r2=1.8">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/german/reviews.php?rev=1.8&content-type=text/vnd.viewcvs-markup">1.8</a></td></tr>
<tr class="alt"><td><tt>includes/modules/summary/<a href="#file10">reviews.php</a></tt></td><td align="right" id="added">+1</td><td align="right" id="removed">-2</td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/modules/summary/reviews.php?rev=1.1&content-type=text/vnd.viewcvs-markup">1.1</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/modules/summary/reviews.php.diff?r1=1.1&r2=1.2">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/modules/summary/reviews.php?rev=1.2&content-type=text/vnd.viewcvs-markup">1.2</a></td></tr>
<tr><td><tt>templates/pages/<a href="#file11">reviews.php</a></tt></td><td align="right" id="added">+21</td><td align="right" id="removed">-4</td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/reviews.php?rev=1.1&content-type=text/vnd.viewcvs-markup">1.1</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/reviews.php.diff?r1=1.1&r2=1.2">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/reviews.php?rev=1.2&content-type=text/vnd.viewcvs-markup">1.2</a></td></tr>
<tr class="alt"><td><tt> /<a href="#file12">reviews_edit.php</a></tt></td><td align="right" id="added">+2</td><td align="right" id="removed">-4</td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/reviews_edit.php?rev=1.1&content-type=text/vnd.viewcvs-markup">1.1</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/reviews_edit.php.diff?r1=1.1&r2=1.2">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/reviews_edit.php?rev=1.2&content-type=text/vnd.viewcvs-markup">1.2</a></td></tr>
<tr><td><tt> /<a href="#file13">reviews_preview.php</a></tt></td><td align="right" id="added">+5</td><td align="right" id="removed">-4</td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/reviews_preview.php?rev=1.1&content-type=text/vnd.viewcvs-markup">1.1</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/reviews_preview.php.diff?r1=1.1&r2=1.2">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/reviews_preview.php?rev=1.2&content-type=text/vnd.viewcvs-markup">1.2</a></td></tr>
<tr><td></td><td align="right" id="added">+88</td><td align="right" id="removed">-49</td><td></td></tr>
</table>
<small id="info">13 modified files</small><br />
<pre class="comment">
New Reviews System
* Now a Service Module
* Guest Reviews Now Allowed
* Reviews Only after Purchase No Allowed
* Reviews Moderation
</pre>
<hr /><a name="file1" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin">admin</a><br /></span>
<div class="fileheader"><big><b>backup.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/backup.php?rev=1.64&content-type=text/vnd.viewcvs-markup">1.64</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/backup.php.diff?r1=1.64&r2=1.65">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/backup.php?rev=1.65&content-type=text/vnd.viewcvs-markup">1.65</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.64 -r1.65
--- backup.php 2004/10/28 18:59:47 1.64
+++ backup.php 2004/11/03 08:59:33 1.65
@@ -268,7 +268,7 @@
</small></pre><pre class="diff" id="context"> }
}
</pre><pre class="diff" id="removed">- $Qdrop = $osC_Database->query('drop table if exists :table_address_book, :table_address_format, :table_banners, :table_banners_history, :table_categories, :table_categories_description, :table_configuration, :table_configuration_group, :table_countries, :table_currencies, :table_customers, :table_customers_basket, :table_customers_basket_attributes, :table_customers_info, :table_languages, :table_manufacturers, :table_manufacturers_info, :table_newsletters, :table_orders, :table_orders_products, :table_orders_products_attributes, :table_orders_products_download, :table_orders_status, :table_orders_status_history, :table_orders_total, :table_products, :table_products_attributes, :table_products_attributes_download, :table_products_description, :table_products_notifications, :table_products_options, :table_products_options_values, :table_p
roducts_options_values_to_products_options, :table_products_to_categories, :table_reviews, :table_<span id="removedchars">reviews_description, :table_sessions, :tabl</span><strong class="error">[...]</strong>
</pre><pre class="diff" id="added">+ $Qdrop = $osC_Database->query('drop table if exists :table_address_book, :table_address_format, :table_banners, :table_banners_history, :table_categories, :table_categories_description, :table_configuration, :table_configuration_group, :table_countries, :table_currencies, :table_customers, :table_customers_basket, :table_customers_basket_attributes, :table_customers_info, :table_languages, :table_manufacturers, :table_manufacturers_info, :table_newsletters, :table_orders, :table_orders_products, :table_orders_products_attributes, :table_orders_products_download, :table_orders_status, :table_orders_status_history, :table_orders_total, :table_products, :table_products_attributes, :table_products_attributes_download, :table_products_description, :table_products_notifications, :table_products_options, :table_products_options_values, :table_pro
ducts_options_values_to_products_options, :table_products_to_categories, :table_reviews, :table_<span id="addedchars">sessions, :table_specials, :table_tax_class</span><strong class="error">[...]</strong>
</pre><pre class="diff" id="context"> $Qdrop->bindTable(':table_address_book', TABLE_ADDRESS_BOOK);
$Qdrop->bindTable(':table_address_format', TABLE_ADDRESS_FORMAT);
$Qdrop->bindTable(':table_banners', TABLE_BANNERS);
</pre><pre class="diff"><small id="info">@@ -304,7 +304,6 @@
</small></pre><pre class="diff" id="context"> $Qdrop->bindTable(':table_products_options_values_to_products_options', TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS);
$Qdrop->bindTable(':table_products_to_categories', TABLE_PRODUCTS_TO_CATEGORIES);
$Qdrop->bindTable(':table_reviews', TABLE_REVIEWS);
</pre><pre class="diff" id="removed">- $Qdrop->bindTable(':table_reviews_description', TABLE_REVIEWS_DESCRIPTION);
</pre><pre class="diff" id="context"> $Qdrop->bindTable(':table_sessions', TABLE_SESSIONS);
$Qdrop->bindTable(':table_specials', TABLE_SPECIALS);
$Qdrop->bindTable(':table_tax_class', TABLE_TAX_CLASS);
</pre><strong class="error" title="2 lines truncated at column 1000">[Note: Some over-long lines of diff output only partialy shown]</strong>
</div>
<hr /><a name="file2" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin">admin</a><br /></span>
<div class="fileheader"><big><b>customers.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/customers.php?rev=1.90&content-type=text/vnd.viewcvs-markup">1.90</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/customers.php.diff?r1=1.90&r2=1.91">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/customers.php?rev=1.91&content-type=text/vnd.viewcvs-markup">1.91</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.90 -r1.91
--- customers.php 2004/10/28 18:59:49 1.90
+++ customers.php 2004/11/03 08:59:33 1.91
@@ -368,32 +368,13 @@
</small></pre><pre class="diff" id="context"> $osC_Database->startTransaction();
if (isset($_POST['delete_reviews']) && ($_POST['delete_reviews'] == 'on')) {
</pre><pre class="diff" id="removed">- $Qreviews = $osC_Database->query('<span id="removedchars">select reviews_id</span> from :table_reviews where customers_id = :customers_id');
</pre><pre class="diff" id="added">+ $Qreviews = $osC_Database->query('<span id="addedchars">delete</span> from :table_reviews where customers_id = :customers_id');
</pre><pre class="diff" id="context"> $Qreviews->bindTable(':table_reviews', TABLE_REVIEWS);
$Qreviews->bindInt(':customers_id', $_GET['cID']);
$Qreviews->execute();
</pre><pre class="diff" id="removed">- while ($Qreviews->next()) {
- $Qrd = $osC_Database->query('delete from :table_reviews_description where reviews_id = :reviews_id');
- $Qrd->bindTable(':table_reviews_description', TABLE_REVIEWS_DESCRIPTION);
- $Qrd->bindInt(':reviews_id', $Qreviews->bindInt('reviews_id'));
- $Qrd->execute();
-
- if ($osC_Database->isError()) {
- $error = true;
- break;
- }
- }
-
- if ($error === false) {
- $Qreviews = $osC_Database->query('delete from :table_reviews where customers_id = :customers_id');
- $Qreviews->bindTable(':table_reviews', TABLE_REVIEWS);
- $Qreviews->bindInt(':customers_id', $_GET['cID']);
- $Qreviews->execute();
-
- if ($osC_Database->isError()) {
- $error = true;
- }
</pre><pre class="diff" id="added">+ if ($osC_Database->isError()) {
+ $error = true;
</pre><pre class="diff" id="context"> }
} else {
$Qcheck = $osC_Database->query('select reviews_id from :table_reviews where customers_id = :customers_id limit 1');
</pre></div>
<hr /><a name="file3" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin">admin</a><br /></span>
<div class="fileheader"><big><b>reviews.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/reviews.php?rev=1.45&content-type=text/vnd.viewcvs-markup">1.45</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/reviews.php.diff?r1=1.45&r2=1.46">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/reviews.php?rev=1.46&content-type=text/vnd.viewcvs-markup">1.46</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.45 -r1.46
--- reviews.php 2004/10/28 18:59:51 1.45
+++ reviews.php 2004/11/03 08:59:34 1.46
@@ -38,8 +38,8 @@
</small></pre><pre class="diff" id="context"> $Qreview->execute();
if ($osC_Database->isError() === false) {
</pre><pre class="diff" id="removed">- $Qrd = $osC_Database->query('update :table_reviews_description set reviews_text = :reviews_text where reviews_id = :reviews_id');
- $Qrd->bindTable(':table_reviews_description', TABLE_REVIEWS_DESCRIPTION);
</pre><pre class="diff" id="added">+ $Qrd = $osC_Database->query('update :table_reviews set reviews_text = :reviews_text where reviews_id = :reviews_id');
+ $Qrd->bindTable(':table_reviews', TABLE_REVIEWS);
</pre><pre class="diff" id="context"> $Qrd->bindValue(':reviews_text', $_POST['reviews_text']);
$Qrd->bindInt(':reviews_id', $_GET['rID']);
$Qrd->execute();
</pre><pre class="diff"><small id="info">@@ -77,19 +77,54 @@
</small></pre><pre class="diff" id="context"> $Qreview->execute();
if ($osC_Database->isError() === false) {
</pre><pre class="diff" id="removed">- $Qrd = $osC_Database->query('delete from :table_reviews_description where reviews_id = :reviews_id');
- $Qrd->bindTable(':table_reviews_description', TABLE_REVIEWS_DESCRIPTION);
- $Qrd->bindInt(':reviews_id', $_GET['rID']);
- $Qrd->execute();
</pre><pre class="diff" id="added">+ $osC_Database->commitTransaction();
</pre><pre class="diff" id="context">
</pre><pre class="diff" id="removed">- if ($osC_Database->isError()) {
- $error = true;
- }
</pre><pre class="diff" id="added">+ $messageStack->add_session(SUCCESS_DB_ROWS_UPDATED, 'success');
+ } else {
+ $osC_Database->rollbackTransaction();
+
+ $messageStack->add_session(ERROR_DB_ROWS_NOT_UPDATED, 'error');
+ }
+
+ tep_redirect(tep_href_link(FILENAME_REVIEWS, 'page=' . $_GET['page']));
+ }
+ break;
+ case 'rApprove':
+ if (isset($_GET['rID']) && is_numeric($_GET['rID'])) {
+ $error = false;
+
+ $osC_Database->startTransaction();
+
+ $Qreview = $osC_Database->query('update :table_reviews set reviews_status = 1 where reviews_id = :reviews_id');
+ $Qreview->bindTable(':table_reviews', TABLE_REVIEWS);
+ $Qreview->bindInt(':reviews_id', $_GET['rID']);
+ $Qreview->execute();
+
+ if ($osC_Database->isError() === false) {
+ $osC_Database->commitTransaction();
+
+ $messageStack->add_session(SUCCESS_DB_ROWS_UPDATED, 'success');
</pre><pre class="diff" id="context"> } else {
</pre><pre class="diff" id="removed">- $error = true;
</pre><pre class="diff" id="added">+ $osC_Database->rollbackTransaction();
+
+ $messageStack->add_session(ERROR_DB_ROWS_NOT_UPDATED, 'error');
</pre><pre class="diff" id="context"> }
</pre><pre class="diff" id="added">+
+ tep_redirect(tep_href_link(FILENAME_REVIEWS, 'page=' . $_GET['page']));
+ }
+ break;
+ case 'rReject':
+ if (isset($_GET['rID']) && is_numeric($_GET['rID'])) {
+ $error = false;
+
+ $osC_Database->startTransaction();
+
+ $Qreview = $osC_Database->query('update :table_reviews set reviews_status = 2 where reviews_id = :reviews_id');
+ $Qreview->bindTable(':table_reviews', TABLE_REVIEWS);
+ $Qreview->bindInt(':reviews_id', $_GET['rID']);
+ $Qreview->execute();
</pre><pre class="diff" id="context">
</pre><pre class="diff" id="removed">- if ($error === false) {
</pre><pre class="diff" id="added">+ if ($osC_Database->isError() === false) {
</pre><pre class="diff" id="context"> $osC_Database->commitTransaction();
$osC_MessageStack->add_session('header', SUCCESS_DB_ROWS_UPDATED, 'success');
</pre></div>
<hr /><a name="file4" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes">includes</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages">languages</a><br /></span>
<div class="fileheader"><big><b>english.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/english.php?rev=1.122&content-type=text/vnd.viewcvs-markup">1.122</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/english.php.diff?r1=1.122&r2=1.123">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/english.php?rev=1.123&content-type=text/vnd.viewcvs-markup">1.123</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.122 -r1.123
--- english.php 2004/10/26 20:20:02 1.122
+++ english.php 2004/11/03 08:59:38 1.123
@@ -184,6 +184,7 @@
</small></pre><pre class="diff" id="context">
// images
define('IMAGE_ANI_SEND_EMAIL', 'Sending E-Mail');
</pre><pre class="diff" id="added">+define('IMAGE_APPROVE', 'Approve');
</pre><pre class="diff" id="context"> define('IMAGE_BACK', 'Back');
define('IMAGE_BACKUP', 'Backup');
define('IMAGE_CANCEL', 'Cancel');
</pre><pre class="diff"><small id="info">@@ -222,6 +223,7 @@
</small></pre><pre class="diff" id="context"> define('IMAGE_ORDERS_INVOICE', 'Invoice');
define('IMAGE_ORDERS_PACKINGSLIP', 'Packing Slip');
define('IMAGE_PREVIEW', 'Preview');
</pre><pre class="diff" id="added">+define('IMAGE_REJECT', 'Reject');
</pre><pre class="diff" id="context"> define('IMAGE_RESTORE', 'Restore');
define('IMAGE_RESET', 'Reset');
define('IMAGE_SAVE', 'Save');
</pre></div>
<hr /><a name="file5" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes">includes</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages">languages</a><br /></span>
<div class="fileheader"><big><b>espanol.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/espanol.php?rev=1.117&content-type=text/vnd.viewcvs-markup">1.117</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/espanol.php.diff?r1=1.117&r2=1.118">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/espanol.php?rev=1.118&content-type=text/vnd.viewcvs-markup">1.118</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.117 -r1.118
--- espanol.php 2004/10/26 20:20:02 1.117
+++ espanol.php 2004/11/03 08:59:38 1.118
@@ -184,6 +184,7 @@
</small></pre><pre class="diff" id="context">
// images
define('IMAGE_ANI_SEND_EMAIL', 'Enviando E-Mail');
</pre><pre class="diff" id="added">+define('IMAGE_APPROVE', 'Approve');
</pre><pre class="diff" id="context"> define('IMAGE_BACK', 'Volver');
define('IMAGE_BACKUP', 'Copiar');
define('IMAGE_CANCEL', 'Cancelar');
</pre><pre class="diff"><small id="info">@@ -222,6 +223,7 @@
</small></pre><pre class="diff" id="context"> define('IMAGE_ORDERS_INVOICE', 'Factura');
define('IMAGE_ORDERS_PACKINGSLIP', 'Albar&aacute;n');
define('IMAGE_PREVIEW', 'Ver');
</pre><pre class="diff" id="added">+define('IMAGE_REJECT', 'Reject');
</pre><pre class="diff" id="context"> define('IMAGE_RESET', 'Resetear');
define('IMAGE_RESTORE', 'Restaurar');
define('IMAGE_SAVE', 'Grabar');
</pre></div>
<hr /><a name="file6" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes">includes</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages">languages</a><br /></span>
<div class="fileheader"><big><b>german.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/german.php?rev=1.116&content-type=text/vnd.viewcvs-markup">1.116</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/german.php.diff?r1=1.116&r2=1.117">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/german.php?rev=1.117&content-type=text/vnd.viewcvs-markup">1.117</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.116 -r1.117
--- german.php 2004/10/26 20:20:03 1.116
+++ german.php 2004/11/03 08:59:38 1.117
@@ -184,6 +184,7 @@
</small></pre><pre class="diff" id="context">
// images
define('IMAGE_ANI_SEND_EMAIL', 'eMail versenden');
</pre><pre class="diff" id="added">+define('IMAGE_APPROVE', 'Approve');
</pre><pre class="diff" id="context"> define('IMAGE_BACK', 'Zur&uuml;ck');
define('IMAGE_BACKUP', 'Datensicherung');
define('IMAGE_CANCEL', 'Abbruch');
</pre><pre class="diff"><small id="info">@@ -222,6 +223,7 @@
</small></pre><pre class="diff" id="context"> define('IMAGE_ORDERS_INVOICE', 'Rechnung');
define('IMAGE_ORDERS_PACKINGSLIP', 'Lieferschein');
define('IMAGE_PREVIEW', 'Vorschau');
</pre><pre class="diff" id="added">+define('IMAGE_REJECT', 'Reject');
</pre><pre class="diff" id="context"> define('IMAGE_RESTORE', 'Zur&uuml;cksichern');
define('IMAGE_RESET', 'Zur&uuml;cksetzen');
define('IMAGE_SAVE', 'Speichern');
</pre></div>
<hr /><a name="file7" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes">includes</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages">languages</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/english">english</a><br /></span>
<div class="fileheader"><big><b>reviews.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/english/reviews.php?rev=1.7&content-type=text/vnd.viewcvs-markup">1.7</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/english/reviews.php.diff?r1=1.7&r2=1.8">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/english/reviews.php?rev=1.8&content-type=text/vnd.viewcvs-markup">1.8</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.7 -r1.8
--- reviews.php 2004/07/22 23:17:20 1.7
+++ reviews.php 2004/11/03 08:59:42 1.8
@@ -16,6 +16,7 @@
</small></pre><pre class="diff" id="context"> define('TABLE_HEADING_LANGUAGE', 'Language');
define('TABLE_HEADING_RATING', 'Rating');
define('TABLE_HEADING_DATE_ADDED', 'Date Added');
</pre><pre class="diff" id="added">+define('TABLE_HEADING_STATUS', 'Status');
</pre><pre class="diff" id="context"> define('TABLE_HEADING_ACTION', 'Action');
define('ENTRY_PRODUCT', 'Product:');
</pre></div>
<hr /><a name="file8" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes">includes</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages">languages</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/espanol">espanol</a><br /></span>
<div class="fileheader"><big><b>reviews.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/espanol/reviews.php?rev=1.6&content-type=text/vnd.viewcvs-markup">1.6</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/espanol/reviews.php.diff?r1=1.6&r2=1.7">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/espanol/reviews.php?rev=1.7&content-type=text/vnd.viewcvs-markup">1.7</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.6 -r1.7
--- reviews.php 2004/07/22 23:18:42 1.6
+++ reviews.php 2004/11/03 08:59:43 1.7
@@ -16,6 +16,7 @@
</small></pre><pre class="diff" id="context"> define('TABLE_HEADING_LANGUAGE', 'Language');
define('TABLE_HEADING_RATING', 'Evaluaci&oacute;n');
define('TABLE_HEADING_DATE_ADDED', 'Fecha Alta');
</pre><pre class="diff" id="added">+define('TABLE_HEADING_STATUS', 'Estado');
</pre><pre class="diff" id="context"> define('TABLE_HEADING_ACTION', 'Acci&oacute;n');
define('ENTRY_PRODUCT', 'Producto:');
</pre></div>
<hr /><a name="file9" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes">includes</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages">languages</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/german">german</a><br /></span>
<div class="fileheader"><big><b>reviews.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/german/reviews.php?rev=1.7&content-type=text/vnd.viewcvs-markup">1.7</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/german/reviews.php.diff?r1=1.7&r2=1.8">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/german/reviews.php?rev=1.8&content-type=text/vnd.viewcvs-markup">1.8</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.7 -r1.8
--- reviews.php 2004/07/22 23:19:57 1.7
+++ reviews.php 2004/11/03 08:59:45 1.8
@@ -16,6 +16,7 @@
</small></pre><pre class="diff" id="context"> define('TABLE_HEADING_LANGUAGE', 'Language');
define('TABLE_HEADING_RATING', 'Bewertung');
define('TABLE_HEADING_DATE_ADDED', 'hinzugef&uuml;gt am');
</pre><pre class="diff" id="added">+define('TABLE_HEADING_STATUS', 'Status');
</pre><pre class="diff" id="context"> define('TABLE_HEADING_ACTION', 'Aktion');
define('ENTRY_PRODUCT', 'Artikel:');
</pre></div>
<hr /><a name="file10" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes">includes</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/modules">modules</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/modules/summary">summary</a><br /></span>
<div class="fileheader"><big><b>reviews.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/modules/summary/reviews.php?rev=1.1&content-type=text/vnd.viewcvs-markup">1.1</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/modules/summary/reviews.php.diff?r1=1.1&r2=1.2">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/modules/summary/reviews.php?rev=1.2&content-type=text/vnd.viewcvs-markup">1.2</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.1 -r1.2
--- reviews.php 2004/08/24 11:06:04 1.1
+++ reviews.php 2004/11/03 08:59:47 1.2
@@ -45,9 +45,8 @@
</small></pre><pre class="diff" id="context"> ' </thead>' .
' <tbody>';
</pre><pre class="diff" id="removed">- $Qreviews = $osC_Database->query('select r.reviews_id, r.products_id, greatest(r.date_added, r.last_modified) as date_last_modified, r.reviews_rating, pd.products_name, l.name as languages_name, l.directory as languages_directory, l.image as languages_image from :table_reviews r, :table_reviews_description rd left join :table_products_description pd on (r.products_id = pd.products_id and rd.languages_id = pd.language_id), :table_languages l where r.reviews_id = rd.reviews_id and rd.languages_id = l.languages_id order by date_last_modified desc limit 6');
</pre><pre class="diff" id="added">+ $Qreviews = $osC_Database->query('select r.reviews_id, r.products_id, greatest(r.date_added, r.last_modified) as date_last_modified, r.reviews_rating, pd.products_name, l.name as languages_name, l.directory as languages_directory, l.image as languages_image from :table_reviews r left join :table_products_description pd on (r.products_id = pd.products_id and r.languages_id = pd.language_id), :table_languages l where r.languages_id = l.languages_id order by date_last_modified desc limit 6');
</pre><pre class="diff" id="context"> $Qreviews->bindTable(':table_reviews', TABLE_REVIEWS);
</pre><pre class="diff" id="removed">- $Qreviews->bindTable(':table_reviews_description', TABLE_REVIEWS_DESCRIPTION);
</pre><pre class="diff" id="context"> $Qreviews->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
$Qreviews->bindTable(':table_languages', TABLE_LANGUAGES);
$Qreviews->execute();
</pre></div>
<hr /><a name="file11" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates">templates</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages">pages</a><br /></span>
<div class="fileheader"><big><b>reviews.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/reviews.php?rev=1.1&content-type=text/vnd.viewcvs-markup">1.1</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/reviews.php.diff?r1=1.1&r2=1.2">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/reviews.php?rev=1.2&content-type=text/vnd.viewcvs-markup">1.2</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.1 -r1.2
--- reviews.php 2004/07/22 23:30:26 1.1
+++ reviews.php 2004/11/03 08:59:50 1.2
@@ -21,14 +21,20 @@
</small></pre><pre class="diff" id="context"> <th><?php echo TABLE_HEADING_LANGUAGE; ?></th>
<th><?php echo TABLE_HEADING_RATING; ?></th>
<th><?php echo TABLE_HEADING_DATE_ADDED; ?></th>
</pre><pre class="diff" id="added">+<?php
+ if ( (defined('SERVICE_REVIEW_ENABLE_MODERATION')) && (SERVICE_REVIEW_ENABLE_MODERATION != -1) ) {
+?>
+ <th><?php echo TABLE_HEADING_STATUS; ?></th>
+<?php
+ }
+?>
</pre><pre class="diff" id="context"> <th><?php echo TABLE_HEADING_ACTION; ?></th>
</tr>
</thead>
<tbody>
<?php
</pre><pre class="diff" id="removed">- $Qreviews = $osC_Database->query('select r.reviews_id, r.products_id, r.date_added, r.last_modified, r.reviews_rating, rd.languages_id, pd.products_name, l.name as languages_name, l.directory as languages_directory, l.image as languages_image from :table_reviews r, :table_reviews_description rd left join :table_products_description pd on (r.products_id = pd.products_id and rd.languages_id = pd.language_id), :table_languages l where r.reviews_id = rd.reviews_id and rd.languages_id = l.languages_id order by r.date_added desc');
</pre><pre class="diff" id="added">+ $Qreviews = $osC_Database->query('select r.reviews_id, r.products_id, r.date_added, r.last_modified, r.reviews_rating, r.reviews_status, r.languages_id, pd.products_name, l.name as languages_name, l.directory as languages_directory, l.image as languages_image from :table_reviews r left join :table_products_description pd on (r.products_id = pd.products_id and r.languages_id = pd.language_id), :table_languages l where r.languages_id = l.languages_id order by r.date_added desc');
</pre><pre class="diff" id="context"> $Qreviews->bindTable(':table_reviews', TABLE_REVIEWS);
</pre><pre class="diff" id="removed">- $Qreviews->bindTable(':table_reviews_description', TABLE_REVIEWS_DESCRIPTION);
</pre><pre class="diff" id="context"> $Qreviews->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
$Qreviews->bindTable(':table_languages', TABLE_LANGUAGES);
$Qreviews->setBatchLimit($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS);
</pre><pre class="diff"><small id="info">@@ -36,9 +42,8 @@
</small></pre><pre class="diff" id="context">
while ($Qreviews->next()) {
if (!isset($rInfo) && (!isset($_GET['rID']) || (isset($_GET['rID']) && ($_GET['rID'] == $Qreviews->valueInt('reviews_id'))))) {
</pre><pre class="diff" id="removed">- $Qtext = $osC_Database->query('select r.reviews_read, r.customers_name, length(rd.reviews_text) as reviews_text_size from :table_reviews r, :table_reviews_description rd where r.reviews_id = :reviews_id and r.reviews_id = rd.reviews_id');
</pre><pre class="diff" id="added">+ $Qtext = $osC_Database->query('select r.reviews_read, r.customers_name, length(r.reviews_text) as reviews_text_size from :table_reviews r where r.reviews_id = :reviews_id');
</pre><pre class="diff" id="context"> $Qtext->bindTable(':table_reviews', TABLE_REVIEWS);
</pre><pre class="diff" id="removed">- $Qtext->bindTable(':table_reviews_description', TABLE_REVIEWS_DESCRIPTION);
</pre><pre class="diff" id="context"> $Qtext->bindInt(':reviews_id', $Qreviews->valueInt('reviews_id'));
$Qtext->execute();
</pre><pre class="diff"><small id="info">@@ -65,6 +70,18 @@
</small></pre><pre class="diff" id="context"> <td align="center"><?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $Qreviews->value('languages_directory') . '/images/' . $Qreviews->value('languages_image'), $Qreviews->value('languages_name')); ?></td>
<td align="center"><?php echo tep_image(HTTP_CATALOG_SERVER . DIR_WS_CATALOG_IMAGES . 'stars_' . $Qreviews->valueInt('reviews_rating') . '.gif', sprintf(TEXT_OF_5_STARS, $Qreviews->valueInt('reviews_rating'))); ?></td>
<td><?php echo tep_date_short($Qreviews->value('date_added')); ?></td>
</pre><pre class="diff" id="added">+<?php
+ if ( (defined('SERVICE_REVIEW_ENABLE_MODERATION')) && (SERVICE_REVIEW_ENABLE_MODERATION != -1) ) {
+ switch ($Qreviews->valueInt('reviews_status')) {
+ case 1: $status_image = 'checkbox_ticked.gif'; break;
+ case 2: $status_image = 'checkbox_crossed.gif'; break;
+ default: $status_image = 'checkbox.gif';
+ }
+?>
+ <td align="center"><?php echo tep_image('templates/' . $template . '/images/icons/' . $status_image); ?></td>
+<?php
+ }
+?>
</pre><pre class="diff" id="context"> <td align="right">
<?php
echo '<a href="' . tep_href_link(FILENAME_REVIEWS, 'page=' . $_GET['page'] . '&rID=' . $Qreviews->valueInt('reviews_id') . '&action=rEdit') . '">' . tep_image('templates/' . $template . '/images/icons/16x16/configure.png', IMAGE_EDIT, '16', '16') . '</a>&nbsp;';
</pre></div>
<hr /><a name="file12" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates">templates</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages">pages</a><br /></span>
<div class="fileheader"><big><b>reviews_edit.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/reviews_edit.php?rev=1.1&content-type=text/vnd.viewcvs-markup">1.1</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/reviews_edit.php.diff?r1=1.1&r2=1.2">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/reviews_edit.php?rev=1.2&content-type=text/vnd.viewcvs-markup">1.2</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.1 -r1.2
--- reviews_edit.php 2004/07/22 23:30:26 1.1
+++ reviews_edit.php 2004/11/03 08:59:50 1.2
@@ -11,9 +11,8 @@
</small></pre><pre class="diff" id="context"> */
if (empty($_POST)) {
</pre><pre class="diff" id="removed">- $Qreviews = $osC_Database->query('select r.reviews_id, r.products_id, r.customers_name, r.date_added, r.last_modified, r.reviews_read, rd.reviews_text, r.reviews_rating, p.products_image, pd.products_name from :table_reviews r, :table_reviews_description rd left join :table_products_description pd on (r.products_id = pd.products_id and rd.languages_id = pd.language_id) left join :table_products p on (r.products_id = p.products_id) where r.reviews_id = :reviews_id and r.reviews_id = rd.reviews_id');
</pre><pre class="diff" id="added">+ $Qreviews = $osC_Database->query('select r.reviews_id, r.products_id, r.customers_name, r.date_added, r.last_modified, r.reviews_read, r.reviews_text, r.reviews_rating, p.products_image, pd.products_name from :table_reviews r left join :table_products_description pd on (r.products_id = pd.products_id and r.languages_id = pd.language_id) left join :table_products p on (r.products_id = p.products_id) where r.reviews_id = :reviews_id');
</pre><pre class="diff" id="context"> $Qreviews->bindTable(':table_reviews', TABLE_REVIEWS);
</pre><pre class="diff" id="removed">- $Qreviews->bindTable(':table_reviews_description', TABLE_REVIEWS_DESCRIPTION);
</pre><pre class="diff" id="context"> $Qreviews->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
$Qreviews->bindTable(':table_products', TABLE_PRODUCTS);
$Qreviews->bindInt(':reviews_id', $_GET['rID']);
</pre><pre class="diff"><small id="info">@@ -21,9 +20,8 @@
</small></pre><pre class="diff" id="context">
$rInfo = new objectInfo($Qreviews->toArray());
} else {
</pre><pre class="diff" id="removed">- $Qreview = $osC_Database->query('select r.customers_name, r.date_added, 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.products_id = p.products_id and p.products_id = pd.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = pd.language_id');
</pre><pre class="diff" id="added">+ $Qreview = $osC_Database->query('select r.customers_name, r.date_added, p.products_image, pd.products_name from :table_reviews r, :table_products p, :table_products_description pd where r.reviews_id = :reviews_id and r.products_id = p.products_id and p.products_id = pd.products_id and r.languages_id = pd.language_id');
</pre><pre class="diff" id="context"> $Qreview->bindTable(':table_reviews', TABLE_REVIEWS);
</pre><pre class="diff" id="removed">- $Qreview->bindTable(':table_reviews_description', TABLE_REVIEWS_DESCRIPTION);
</pre><pre class="diff" id="context"> $Qreview->bindTable(':table_products', TABLE_PRODUCTS);
$Qreview->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
$Qreview->bindInt(':reviews_id', $_GET['rID']);
</pre></div>
<hr /><a name="file13" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin">admin</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates">templates</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages">pages</a><br /></span>
<div class="fileheader"><big><b>reviews_preview.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/reviews_preview.php?rev=1.1&content-type=text/vnd.viewcvs-markup">1.1</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/reviews_preview.php.diff?r1=1.1&r2=1.2">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/reviews_preview.php?rev=1.2&content-type=text/vnd.viewcvs-markup">1.2</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.1 -r1.2
--- reviews_preview.php 2004/07/22 23:30:26 1.1
+++ reviews_preview.php 2004/11/03 08:59:50 1.2
@@ -11,9 +11,8 @@
</small></pre><pre class="diff" id="context"> */
if (empty($_POST)) {
</pre><pre class="diff" id="removed">- $Qreviews = $osC_Database->query('select r.reviews_id, r.products_id, r.customers_name, r.date_added, r.last_modified, r.reviews_read, rd.reviews_text, r.reviews_rating, p.products_image, pd.products_name from :table_reviews r, :table_reviews_description rd left join :table_products_description pd on (r.products_id = pd.products_id and rd.languages_id = pd.language_id) left join :table_products p on (r.products_id = p.products_id) where r.reviews_id = :reviews_id and r.reviews_id = rd.reviews_id');
</pre><pre class="diff" id="added">+ $Qreviews = $osC_Database->query('select r.reviews_id, r.products_id, r.customers_name, r.date_added, r.last_modified, r.reviews_read, r.reviews_text, r.reviews_rating, p.products_image, pd.products_name from :table_reviews r left join :table_products_description pd on (r.products_id = pd.products_id and r.languages_id = pd.language_id) left join :table_products p on (r.products_id = p.products_id) where r.reviews_id = :reviews_id');
</pre><pre class="diff" id="context"> $Qreviews->bindTable(':table_reviews', TABLE_REVIEWS);
</pre><pre class="diff" id="removed">- $Qreviews->bindTable(':table_reviews_description', TABLE_REVIEWS_DESCRIPTION);
</pre><pre class="diff" id="context"> $Qreviews->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
$Qreviews->bindTable(':table_products', TABLE_PRODUCTS);
$Qreviews->bindInt(':reviews_id', $_GET['rID']);
</pre><pre class="diff"><small id="info">@@ -21,9 +20,8 @@
</small></pre><pre class="diff" id="context">
$rInfo = new objectInfo($Qreviews->toArray());
} else {
</pre><pre class="diff" id="removed">- $Qreview = $osC_Database->query('select r.customers_name, r.date_added, 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.products_id = p.products_id and p.products_id = pd.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = pd.language_id');
</pre><pre class="diff" id="added">+ $Qreview = $osC_Database->query('select r.customers_name, r.date_added, p.products_image, pd.products_name from :table_reviews r, :table_products p, :table_products_description pd where r.reviews_id = :reviews_id and r.products_id = p.products_id and p.products_id = pd.products_id and r.languages_id = pd.language_id');
</pre><pre class="diff" id="context"> $Qreview->bindTable(':table_reviews', TABLE_REVIEWS);
</pre><pre class="diff" id="removed">- $Qreview->bindTable(':table_reviews_description', TABLE_REVIEWS_DESCRIPTION);
</pre><pre class="diff" id="context"> $Qreview->bindTable(':table_products', TABLE_PRODUCTS);
$Qreview->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
$Qreview->bindInt(':reviews_id', $_GET['rID']);
</pre><pre class="diff"><small id="info">@@ -44,6 +42,9 @@
</small></pre><pre class="diff" id="context"> <?php
if (empty($_POST)) {
echo '<p align="right"><input type="button" value="' . IMAGE_BACK . '" class="operationButton" onClick="document.location.href=\'' . tep_href_link(FILENAME_REVIEWS, 'page=' . $_GET['page'] . '&rID=' . $_GET['rID']) . '\';"></p>';
</pre><pre class="diff" id="added">+ if ( (defined('SERVICE_REVIEW_ENABLE_MODERATION')) && (SERVICE_REVIEW_ENABLE_MODERATION != -1) ) {
+ echo '<p align="right"><input type="button" value="' . IMAGE_APPROVE . '" class="operationButton" onClick="document.location.href=\'' . tep_href_link(FILENAME_REVIEWS, 'page=' . $_GET['page'] . '&rID=' . $_GET['rID'] . '&action=rApprove') . '\';"> <input type="button" value="' . IMAGE_REJECT . '" class="operationButton" onClick="document.location.href=\'' . tep_href_link(FILENAME_REVIEWS, 'page=' . $_GET['page'] . '&rID=' . $_GET['rID'] . '&action=rReject') . '\';"></p>';
+ }
</pre><pre class="diff" id="context"> } else {
echo tep_draw_form('update', FILENAME_REVIEWS, 'page=' . $_GET['page'] . '&rID=' . $_GET['rID'] . '&action=update', 'post', 'enctype="multipart/form-data"');
</pre></div>
<center><small><a href="http://www.badgers-in-foil.co.uk/projects/cvsspam/" title="commit -> email">CVSspam</a> 0.2.9</small></center>
</body></html>
-------------------------------------------------------
This SF.Net email is sponsored by:
Sybase ASE Linux Express Edition - download now for FREE
LinuxWorld Reader's Choice Award Winner for best database on Linux.
http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click