[TEP-COMMIT] [CVS admin] Specials Update.

mevans-OfajU3CKLf1/[email protected] 31 Oct 2004 09:43:38 -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">specials.php</a></tt></td><td align="right" id="added">+28</td><td align="right" id="removed">-15</td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/specials.php?rev=1.43&amp;content-type=text/vnd.viewcvs-markup">1.43</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/specials.php.diff?r1=1.43&amp;r2=1.44">-&gt;</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/specials.php?rev=1.44&amp;content-type=text/vnd.viewcvs-markup">1.44</a></td></tr>
<tr class="alt"><td><tt>includes/languages/english/<a href="#file2">specials.php</a></tt></td><td align="right" id="added">+4</td><td></td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/english/specials.php?rev=1.11&amp;content-type=text/vnd.viewcvs-markup">1.11</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/english/specials.php.diff?r1=1.11&amp;r2=1.12">-&gt;</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/english/specials.php?rev=1.12&amp;content-type=text/vnd.viewcvs-markup">1.12</a></td></tr>
<tr><td><tt>includes/languages/espanol/<a href="#file3">specials.php</a></tt></td><td align="right" id="added">+4</td><td></td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/espanol/specials.php?rev=1.12&amp;content-type=text/vnd.viewcvs-markup">1.12</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/espanol/specials.php.diff?r1=1.12&amp;r2=1.13">-&gt;</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/espanol/specials.php?rev=1.13&amp;content-type=text/vnd.viewcvs-markup">1.13</a></td></tr>
<tr class="alt"><td><tt>includes/languages/german/<a href="#file4">specials.php</a></tt></td><td align="right" id="added">+4</td><td></td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/german/specials.php?rev=1.11&amp;content-type=text/vnd.viewcvs-markup">1.11</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/german/specials.php.diff?r1=1.11&amp;r2=1.12">-&gt;</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/german/specials.php?rev=1.12&amp;content-type=text/vnd.viewcvs-markup">1.12</a></td></tr>
<tr><td><tt>templates/pages/<a href="#file5">specials_edit.php</a></tt></td><td align="right" id="added">+6</td><td align="right" id="removed">-2</td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/specials_edit.php?rev=1.2&amp;content-type=text/vnd.viewcvs-markup">1.2</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/specials_edit.php.diff?r1=1.2&amp;r2=1.3">-&gt;</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/specials_edit.php?rev=1.3&amp;content-type=text/vnd.viewcvs-markup">1.3</a></td></tr>
<tr><td></td><td align="right" id="added">+46</td><td align="right" id="removed">-17</td><td></td></tr>
</table>
<small id="info">5 modified files</small><br />
<pre class="comment">
Specials Update.

* Now a service module
* Can be scheduled in the future
* Price cannot be negative amount
</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>specials.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/specials.php?rev=1.43&amp;content-type=text/vnd.viewcvs-markup">1.43</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/specials.php.diff?r1=1.43&amp;r2=1.44">-&gt;</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/specials.php?rev=1.44&amp;content-type=text/vnd.viewcvs-markup">1.44</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.43 -r1.44
--- specials.php	2004/10/28 18:59:51	1.43
+++ specials.php	2004/10/31 09:43:32	1.44
@@ -23,6 +23,7 @@
</small></pre><pre class="diff" id="context">   if (!empty($action)) {
     switch ($action) {
       case 'save':
</pre><pre class="diff" id="added">+        $error = false;
</pre><pre class="diff" id="context">         $Qproduct = $osC_Database-&gt;query('select products_price from :table_products where products_id = :products_id');
         $Qproduct-&gt;bindTable(':table_products', TABLE_PRODUCTS);
         $Qproduct-&gt;bindInt(':products_id', $_POST['products_id']);
</pre><pre class="diff"><small id="info">@@ -35,26 +36,38 @@
</small></pre><pre class="diff" id="context">             $specials_price = $Qproduct-&gt;valueDecimal('products_price') - (((double)$specials_price / 100) * $Qproduct-&gt;valueDecimal('products_price'));
           }
 
</pre><pre class="diff" id="removed">-          if (isset($_GET['sID']) &amp;&amp; is_numeric($_GET['sID'])) {
-            $Qspecial = $osC_Database-&gt;query('update :table_specials set specials_new_products_price = :specials_new_products_price, specials_last_modified = now(), expires_date = :expires_date, status = :status where specials_id = :specials_id');
-            $Qspecial-&gt;bindInt(':specials_id', $_GET['sID']);
-          } else {
-            $Qspecial = $osC_Database-&gt;query('insert into :table_specials (products_id, specials_new_products_price, specials_date_added, expires_date, status) values (:products_id, :specials_new_products_price, now(), :expires_date, :status)');
-            $Qspecial-&gt;bindInt(':products_id', $_POST['products_id']);
</pre><pre class="diff" id="added">+          if ( ($specials_price &lt; '0.00') || ($specials_price &gt;= $Qproduct-&gt;valueDecimal('products_price')) ) {
+            $error = true;
+            $osC_MessageStack-&gt;add_session('header', ERROR_SPECIALS_PRICE, 'error');
</pre><pre class="diff" id="context">           }
</pre><pre class="diff" id="removed">-          $Qspecial-&gt;bindTable(':table_specials', TABLE_SPECIALS);
-          $Qspecial-&gt;bindValue(':specials_new_products_price', $specials_price);
-          $Qspecial-&gt;bindValue(':expires_date', $_POST['specials_expires_date']);
-          $Qspecial-&gt;bindInt(':status', (isset($_POST['specials_status']) &amp;&amp; ($_POST['specials_status'] == '1') ? '1' : '0'));
-          $Qspecial-&gt;execute();
</pre><pre class="diff" id="context"> 
</pre><pre class="diff" id="removed">-          if ($osC_Database-&gt;isError() === false) {
</pre><pre class="diff" id="added">+          if ($_POST['specials_expires_date'] &lt; $_POST['specials_start_date']) {
+            $error = true;
+            $osC_MessageStack-&gt;add_session('header', ERROR_SPECIALS_DATE, 'error');
+          }
+          
+          if ($error == false) {
+          	if (isset($_GET['sID']) &amp;&amp; is_numeric($_GET['sID'])) {
+              $Qspecial = $osC_Database-&gt;query('update :table_specials set specials_new_products_price = :specials_new_products_price, specials_last_modified = now(), expires_date = :expires_date, start_date = :start_date, status = :status where specials_id = :specials_id');
+              $Qspecial-&gt;bindInt(':specials_id', $_GET['sID']);
+            } else {
+              $Qspecial = $osC_Database-&gt;query('insert into :table_specials (products_id, specials_new_products_price, specials_date_added, expires_date, start_date, status) values (:products_id, :specials_new_products_price, now(), :expires_date, :start_date, :status)');
+              $Qspecial-&gt;bindInt(':products_id', $_POST['products_id']);
+            }
+            $Qspecial-&gt;bindTable(':table_specials', TABLE_SPECIALS);
+            $Qspecial-&gt;bindValue(':specials_new_products_price', $specials_price);
+            $Qspecial-&gt;bindValue(':expires_date', $_POST['specials_expires_date']);
+            $Qspecial-&gt;bindValue(':start_date', $_POST['specials_start_date']);
+            $Qspecial-&gt;bindInt(':status', (isset($_POST['specials_status']) &amp;&amp; ($_POST['specials_status'] == '1') ? '1' : '0'));
+            $Qspecial-&gt;execute();
+
+            if ($osC_Database-&gt;isError() === false) {
</pre><pre class="diff" id="context">             $osC_MessageStack-&gt;add_session('header', SUCCESS_DB_ROWS_UPDATED, 'success');
</pre><pre class="diff" id="removed">-          } else {
</pre><pre class="diff" id="added">+          <span id="addedchars">&nbsp;&nbsp;</span>} else {
</pre><pre class="diff" id="context">             $osC_MessageStack-&gt;add_session('header', ERROR_DB_ROWS_NOT_UPDATED, 'error');
</pre><pre class="diff" id="removed">-          }
</pre><pre class="diff" id="added">+          <span id="addedchars">&nbsp;&nbsp;</span>}
+          }          	
</pre><pre class="diff" id="context">         }
</pre><pre class="diff" id="removed">-
</pre><pre class="diff" id="context">         tep_redirect(tep_href_link(FILENAME_SPECIALS, 'page=' . $_GET['page'] . (isset($_GET['sID']) ? '&amp;sID=' . $_GET['sID'] : '')));
         break;
       case 'deleteconfirm':
</pre></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>/<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>specials.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/english/specials.php?rev=1.11&amp;content-type=text/vnd.viewcvs-markup">1.11</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/english/specials.php.diff?r1=1.11&amp;r2=1.12">-&gt;</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/english/specials.php?rev=1.12&amp;content-type=text/vnd.viewcvs-markup">1.12</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.11 -r1.12
--- specials.php	2004/07/22 23:17:20	1.11
+++ specials.php	2004/10/31 09:43:33	1.12
@@ -20,6 +20,7 @@
</small></pre><pre class="diff" id="context"> define('TEXT_SPECIALS_PRODUCT', 'Product:');
 define('TEXT_SPECIALS_SPECIAL_PRICE', 'Special Price:');
 define('TEXT_SPECIALS_STATUS', 'Status:');
</pre><pre class="diff" id="added">+define('TEXT_SPECIALS_START_DATE', 'Start Date:');
</pre><pre class="diff" id="context"> define('TEXT_SPECIALS_EXPIRES_DATE', 'Expiry Date:');
 define('TEXT_SPECIALS_PRICE_TIP', '&lt;b&gt;Specials Notes:&lt;/b&gt;&lt;ul&gt;&lt;li&gt;You can enter a percentage to deduct in the Specials Price field, for example: &lt;b&gt;20%&lt;/b&gt;&lt;/li&gt;&lt;li&gt;If you enter a new price, the decimal separator must be a \'.\' (decimal-point), example: &lt;b&gt;49.99&lt;/b&gt;&lt;/li&gt;&lt;li&gt;Leave the expiry date empty for no expiration&lt;/li&gt;&lt;/ul&gt;');
 
</pre><pre class="diff"><small id="info">@@ -33,4 +34,7 @@
</small></pre><pre class="diff" id="context"> 
 define('TEXT_INFO_HEADING_DELETE_SPECIALS', 'Delete Special');
 define('TEXT_INFO_DELETE_INTRO', 'Are you sure you want to delete the special products price?');
</pre><pre class="diff" id="added">+
+define('ERROR_SPECIALS_PRICE', 'Specials price cannot be negative or greater than original price');
+define('ERROR_SPECIALS_DATE', 'The expiry date is before the start date');
</pre><pre class="diff" id="context"> ?&gt;
</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>/<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>specials.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/espanol/specials.php?rev=1.12&amp;content-type=text/vnd.viewcvs-markup">1.12</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/espanol/specials.php.diff?r1=1.12&amp;r2=1.13">-&gt;</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/espanol/specials.php?rev=1.13&amp;content-type=text/vnd.viewcvs-markup">1.13</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.12 -r1.13
--- specials.php	2004/07/22 23:18:42	1.12
+++ specials.php	2004/10/31 09:43:34	1.13
@@ -20,6 +20,7 @@
</small></pre><pre class="diff" id="context"> define('TEXT_SPECIALS_PRODUCT', 'Producto:');
 define('TEXT_SPECIALS_SPECIAL_PRICE', 'Precio de Oferta:');
 define('TEXT_SPECIALS_STATUS', 'Status:');
</pre><pre class="diff" id="added">+define('TEXT_SPECIALS_START_DATE', 'Start Date:');
</pre><pre class="diff" id="context"> define('TEXT_SPECIALS_EXPIRES_DATE', 'Fecha de Caducidad:');
 define('TEXT_SPECIALS_PRICE_TIP', '&lt;b&gt;Notas:&lt;/b&gt;&lt;ul&gt;&lt;li&gt;Puedes introducir un porcentaje de reduccion del precio del producto, por ejemplo: &lt;b&gt;20%&lt;/b&gt;&lt;/li&gt;&lt;li&gt;Si por el contrario, introduces un precio de oferta debes de usar el punto como separador decimal \'.\' (punto decimal), por ejemplo: &lt;b&gt;49.99&lt;/b&gt;&lt;/li&gt;&lt;li&gt;Deja la fecha de caducidad vacia si no quieres caducidad&lt;/li&gt;&lt;/ul&gt;');
 
</pre><pre class="diff"><small id="info">@@ -33,4 +34,7 @@
</small></pre><pre class="diff" id="context"> 
 define('TEXT_INFO_HEADING_DELETE_SPECIALS', 'Eliminar Oferta');
 define('TEXT_INFO_DELETE_INTRO', 'Seguro que desea eliminar este precio de oferta?');
</pre><pre class="diff" id="added">+
+define('ERROR_SPECIALS_PRICE', 'Specials price cannot be negative or greater than original price');
+define('ERROR_SPECIALS_DATE', 'The expiry date is before the start date');
</pre><pre class="diff" id="context"> ?&gt;
</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>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/german">german</a><br /></span>
<div class="fileheader"><big><b>specials.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/german/specials.php?rev=1.11&amp;content-type=text/vnd.viewcvs-markup">1.11</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/german/specials.php.diff?r1=1.11&amp;r2=1.12">-&gt;</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/includes/languages/german/specials.php?rev=1.12&amp;content-type=text/vnd.viewcvs-markup">1.12</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.11 -r1.12
--- specials.php	2004/07/22 23:19:57	1.11
+++ specials.php	2004/10/31 09:43:34	1.12
@@ -20,6 +20,7 @@
</small></pre><pre class="diff" id="context"> define('TEXT_SPECIALS_PRODUCT', 'Produkt:');
 define('TEXT_SPECIALS_SPECIAL_PRICE', 'Angebotspreis:');
 define('TEXT_SPECIALS_STATUS', 'Status:');
</pre><pre class="diff" id="added">+define('TEXT_SPECIALS_START_DATE', 'Start Date:');
</pre><pre class="diff" id="context"> define('TEXT_SPECIALS_EXPIRES_DATE', 'G&amp;uuml;ltig bis:&lt;br&gt;&lt;small&gt;(dd.mm.yyyy)&lt;/small&gt;');
 define('TEXT_SPECIALS_PRICE_TIP', '&lt;b&gt;Bemerkung:&lt;/b&gt;&lt;ul&gt;&lt;li&gt;Sie k&amp;ouml;nnen im Feld Angebotspreis auch prozentuale Werte angeben, z.B.: &lt;b&gt;20%&lt;/b&gt;&lt;/li&gt;&lt;li&gt;Wenn Sie einen neuen Preis eingeben, m&amp;uuml;ssen die Nachkommastellen mit einem \'.\' getrennt werden, z.B.: &lt;b&gt;49.99&lt;/b&gt;&lt;/li&gt;&lt;li&gt;Lassen Sie das Feld &lt;b&gt;\'Gltig bis\'&lt;/b&gt; leer, wenn der Angebotspreis zeitlich unbegrenzt gelten soll.&lt;/li&gt;&lt;/ul&gt;');
 
</pre><pre class="diff"><small id="info">@@ -33,4 +34,7 @@
</small></pre><pre class="diff" id="context"> 
 define('TEXT_INFO_HEADING_DELETE_SPECIALS', 'Sonderangebot l&amp;ouml;schen');
 define('TEXT_INFO_DELETE_INTRO', 'Sind Sie sicher, dass Sie das Sonderangebot l&amp;ouml;schen m&amp;ouml;chten?');
</pre><pre class="diff" id="added">+
+define('ERROR_SPECIALS_PRICE', 'Specials price cannot be negative or greater than original price');
+define('ERROR_SPECIALS_DATE', 'The expiry date is before the start date');
</pre><pre class="diff" id="context"> ?&gt;
</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/templates">templates</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages">pages</a><br /></span>
<div class="fileheader"><big><b>specials_edit.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/specials_edit.php?rev=1.2&amp;content-type=text/vnd.viewcvs-markup">1.2</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/specials_edit.php.diff?r1=1.2&amp;r2=1.3">-&gt;</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/admin/admin/templates/pages/specials_edit.php?rev=1.3&amp;content-type=text/vnd.viewcvs-markup">1.3</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.2 -r1.3
--- specials_edit.php	2004/08/02 12:35:56	1.2
+++ specials_edit.php	2004/10/31 09:43:35	1.3
@@ -11,7 +11,7 @@
</small></pre><pre class="diff" id="context"> */
 
   if (($action == 'sEdit') &amp;&amp; isset($_GET['sID'])) {
</pre><pre class="diff" id="removed">-    $Qspecial = $osC_Database-&gt;query('select p.products_id, pd.products_name, p.products_price, s.specials_new_products_price, s.expires_date, s.status from :table_specials s, :table_products p, :table_products_description pd where s.specials_id = :specials_id and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = :language_id');
</pre><pre class="diff" id="added">+    $Qspecial = $osC_Database-&gt;query('select p.products_id, pd.products_name, p.products_price, s.specials_new_products_price, s.expires_date, s.sta<span id="addedchars">rt_date,&nbsp;s.sta</span>tus from :table_specials s, :table_products p, :table_products_description pd where s.specials_id = :specials_id and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = :language_id');
</pre><pre class="diff" id="context">     $Qspecial-&gt;bindTable(':table_specials', TABLE_SPECIALS);
     $Qspecial-&gt;bindTable(':table_products', TABLE_PRODUCTS);
     $Qspecial-&gt;bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
</pre><pre class="diff"><small id="info">@@ -61,8 +61,12 @@
</small></pre><pre class="diff" id="context">     &lt;td class="main"&gt;&lt;?php echo osc_draw_checkbox_field('specials_status', '1', (isset($sInfo) ? $sInfo-&gt;status : '')); ?&gt;&lt;/td&gt;
   &lt;/tr&gt;
   &lt;tr&gt;
</pre><pre class="diff" id="added">+    &lt;td class="main"&gt;&lt;?php echo TEXT_SPECIALS_START_DATE; ?&gt;&lt;/td&gt;
+    &lt;td class="main"&gt;&lt;?php echo osc_draw_input_field('specials_start_date', (isset($sInfo) ? $sInfo-&gt;start_date : ''), 'id="calendarValueStartDate"'); ?&gt;&lt;input type="button" value="..." id="calendarTriggerStartDate" class="operationButton"&gt;&lt;script type="text/javascript"&gt;Calendar.setup( { inputField: "calendarValueStartDate", ifFormat: "%Y-%m-%d", button: "calendarTriggerStartDate" } );&lt;/script&gt;&lt;/td&gt;
+  &lt;/tr&gt;
+  &lt;tr&gt;
</pre><pre class="diff" id="context">     &lt;td class="main"&gt;&lt;?php echo TEXT_SPECIALS_EXPIRES_DATE; ?&gt;&lt;/td&gt;
</pre><pre class="diff" id="removed">-    &lt;td class="main"&gt;&lt;?php echo osc_draw_input_field('specials_expires_date', (isset($sInfo) ? $sInfo-&gt;expires_date : ''), 'id="calendarValue"'); ?&gt;&lt;input type="button" value="..." id="calendarTrigger" class="operationButton"&gt;&lt;script type="text/javascript"&gt;Calendar.setup( { inputField: "calendarValue", ifFormat: "%Y-%m-%d", button: "calendarTrigger" } );&lt;/script&gt;&lt;/td&gt;
</pre><pre class="diff" id="added">+    &lt;td class="main"&gt;&lt;?php echo osc_draw_input_field('specials_expires_date', (isset($sInfo) ? $sInfo-&gt;expires_date : ''), 'id="calendarValueEndDate"'); ?&gt;&lt;input type="button" value="..." id="calendarTriggerEndDate" class="operationButton"&gt;&lt;script type="text/javascript"&gt;Calendar.setup( { inputField: "calendarValueEndDate", ifFormat: "%Y-%m-%d", button: "calendarTriggerEndDate" } );&lt;/script&gt;&lt;/td&gt;
</pre><pre class="diff" id="context">   &lt;/tr&gt;
 &lt;/table&gt;
 
</pre></div>
<center><small><a href="http://www.badgers-in-foil.co.uk/projects/cvsspam/" title="commit -&gt; 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