[TEP-COMMIT] [CVS catalog] Specials Update.
mevans-OfajU3CKLf1/[email protected] 31 Oct 2004 09:46:31 -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>catalog/catalog</tt></b><span id="info"> on MAIN</span></td></tr>
<tr><td><tt><a href="#file1">product_info.php</a></tt></td><td align="right" id="added">+1</td><td align="right" id="removed">-1</td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_info.php?rev=1.104&content-type=text/vnd.viewcvs-markup">1.104</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_info.php.diff?r1=1.104&r2=1.105">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_info.php?rev=1.105&content-type=text/vnd.viewcvs-markup">1.105</a></td></tr>
<tr class="alt"><td><tt><a href="#file2">product_reviews.php</a></tt></td><td align="right" id="added">+1</td><td align="right" id="removed">-1</td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_reviews.php?rev=1.53&content-type=text/vnd.viewcvs-markup">1.53</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_reviews.php.diff?r1=1.53&r2=1.54">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_reviews.php?rev=1.54&content-type=text/vnd.viewcvs-markup">1.54</a></td></tr>
<tr><td><tt><a href="#file3">product_reviews_info.php</a></tt></td><td align="right" id="added">+1</td><td align="right" id="removed">-1</td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_reviews_info.php?rev=1.54&content-type=text/vnd.viewcvs-markup">1.54</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_reviews_info.php.diff?r1=1.54&r2=1.55">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_reviews_info.php?rev=1.55&content-type=text/vnd.viewcvs-markup">1.55</a></td></tr>
<tr class="alt"><td><tt><a href="#file4">product_reviews_write.php</a></tt></td><td align="right" id="added">+1</td><td align="right" id="removed">-1</td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_reviews_write.php?rev=1.59&content-type=text/vnd.viewcvs-markup">1.59</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_reviews_write.php.diff?r1=1.59&r2=1.60">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_reviews_write.php?rev=1.60&content-type=text/vnd.viewcvs-markup">1.60</a></td></tr>
<tr><td><tt><a href="#file5">products_new.php</a></tt></td><td align="right" id="added">+1</td><td align="right" id="removed">-1</td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/products_new.php?rev=1.30&content-type=text/vnd.viewcvs-markup">1.30</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/products_new.php.diff?r1=1.30&r2=1.31">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/products_new.php?rev=1.31&content-type=text/vnd.viewcvs-markup">1.31</a></td></tr>
<tr class="alt"><td><tt><a href="#file6">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/catalog/catalog/specials.php?rev=1.51&content-type=text/vnd.viewcvs-markup">1.51</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/specials.php.diff?r1=1.51&r2=1.52">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/specials.php?rev=1.52&content-type=text/vnd.viewcvs-markup">1.52</a></td></tr>
<tr><td><tt>includes/boxes/<a href="#file7">specials.php</a></tt></td><td align="right" id="added">+18</td><td align="right" id="removed">-15</td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/boxes/specials.php?rev=1.34&content-type=text/vnd.viewcvs-markup">1.34</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/boxes/specials.php.diff?r1=1.34&r2=1.35">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/boxes/specials.php?rev=1.35&content-type=text/vnd.viewcvs-markup">1.35</a></td></tr>
<tr class="alt"><td><tt> /<a href="#file8">whats_new.php</a></tt></td><td align="right" id="added">+4</td><td align="right" id="removed">-1</td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/boxes/whats_new.php?rev=1.35&content-type=text/vnd.viewcvs-markup">1.35</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/boxes/whats_new.php.diff?r1=1.35&r2=1.36">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/boxes/whats_new.php?rev=1.36&content-type=text/vnd.viewcvs-markup">1.36</a></td></tr>
<tr><td><tt>includes/classes/<a href="#file9"><span id="added">specials.php</span></a></tt></td><td align="right" id="added">+79</td><td></td><td nowrap="nowrap" align="right">added <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/classes/specials.php?rev=1.1&content-type=text/vnd.viewcvs-markup">1.1</a></td></tr>
<tr class="alt"><td><tt>includes/functions/<a href="#file10">general.php</a></tt></td><td></td><td align="right" id="removed">-22</td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/functions/general.php?rev=1.241&content-type=text/vnd.viewcvs-markup">1.241</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/functions/general.php.diff?r1=1.241&r2=1.242">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/functions/general.php?rev=1.242&content-type=text/vnd.viewcvs-markup">1.242</a></td></tr>
<tr><td><tt> /<span id="removed">specials.php</span></tt></td><td></td><td></td><td nowrap="nowrap"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/functions/specials.php?rev=1.7&content-type=text/vnd.viewcvs-markup">1.7</a> removed</td></tr>
<tr class="alt"><td><tt>includes/modules/<a href="#file12">new_products.php</a></tt></td><td align="right" id="added">+4</td><td align="right" id="removed">-1</td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules/new_products.php?rev=1.38&content-type=text/vnd.viewcvs-markup">1.38</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules/new_products.php.diff?r1=1.38&r2=1.39">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules/new_products.php?rev=1.39&content-type=text/vnd.viewcvs-markup">1.39</a></td></tr>
<tr><td><tt>includes/modules/services/<a href="#file13">specials.php</a></tt></td><td align="right" id="added">+8</td><td align="right" id="removed">-7</td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules/services/specials.php?rev=1.1&content-type=text/vnd.viewcvs-markup">1.1</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules/services/specials.php.diff?r1=1.1&r2=1.2">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules/services/specials.php?rev=1.2&content-type=text/vnd.viewcvs-markup">1.2</a></td></tr>
<tr class="alt"><td><tt>install/<a href="#file14">oscommerce.sql</a></tt></td><td align="right" id="added">+5</td><td align="right" id="removed">-2</td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/install/oscommerce.sql?rev=1.102&content-type=text/vnd.viewcvs-markup">1.102</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/install/oscommerce.sql.diff?r1=1.102&r2=1.103">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/install/oscommerce.sql?rev=1.103&content-type=text/vnd.viewcvs-markup">1.103</a></td></tr>
<tr><td><tt> /<a href="#file15">oscommerce_sample_data.sql</a></tt></td><td align="right" id="added">+4</td><td align="right" id="removed">-4</td><td nowrap="nowrap" align="center"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/install/oscommerce_sample_data.sql?rev=1.5&content-type=text/vnd.viewcvs-markup">1.5</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/install/oscommerce_sample_data.sql.diff?r1=1.5&r2=1.6">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/install/oscommerce_sample_data.sql?rev=1.6&content-type=text/vnd.viewcvs-markup">1.6</a></td></tr>
<tr><td></td><td align="right" id="added">+131</td><td align="right" id="removed">-57</td><td></td></tr>
</table>
<small id="info">1 added + 1 removed + 13 modified, total 15 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/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog">catalog</a><br /></span>
<div class="fileheader"><big><b>product_info.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_info.php?rev=1.104&content-type=text/vnd.viewcvs-markup">1.104</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_info.php.diff?r1=1.104&r2=1.105">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_info.php?rev=1.105&content-type=text/vnd.viewcvs-markup">1.105</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.104 -r1.105
--- product_info.php 2004/07/22 17:23:53 1.104
+++ product_info.php 2004/10/31 09:46:08 1.105
@@ -74,7 +74,7 @@
</small></pre><pre class="diff" id="context">
tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$_GET['products_id'] . "' and language_id = '" . (int)$osC_Session->value('languages_id') . "'");
</pre><pre class="diff" id="removed">- if ($new_price = tep_get_products_special_price($product_info['products_id'])) {
</pre><pre class="diff" id="added">+ if ( ($osC_Services->isStarted('specials')) && ($new_price = $osC_Specials->getPrice($product_info['products_id'])) ) {
</pre><pre class="diff" id="context"> $products_price = '<s>' . $osC_Currencies->displayPrice($product_info['products_price'], $product_info['products_tax_class_id']) . '</s> <span class="productSpecialPrice">' . $osC_Currencies->displayPrice($new_price, $product_info['products_tax_class_id']) . '</span>';
} else {
$products_price = $osC_Currencies->displayPrice($product_info['products_price'], $product_info['products_tax_class_id']);
</pre></div>
<hr /><a name="file2" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog">catalog</a><br /></span>
<div class="fileheader"><big><b>product_reviews.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_reviews.php?rev=1.53&content-type=text/vnd.viewcvs-markup">1.53</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_reviews.php.diff?r1=1.53&r2=1.54">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_reviews.php?rev=1.54&content-type=text/vnd.viewcvs-markup">1.54</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.53 -r1.54
--- product_reviews.php 2004/04/13 07:52:41 1.53
+++ product_reviews.php 2004/10/31 09:46:08 1.54
@@ -19,7 +19,7 @@
</small></pre><pre class="diff" id="context"> $product_info = tep_db_fetch_array($product_info_query);
}
</pre><pre class="diff" id="removed">- if ($new_price = tep_get_products_special_price($product_info['products_id'])) {
</pre><pre class="diff" id="added">+ if ( ($osC_Services->isStarted('specials')) && ($new_price = $osC_Specials->getPrice($product_info['products_id'])) ) {
</pre><pre class="diff" id="context"> $products_price = '<s>' . $osC_Currencies->displayPrice($product_info['products_price'], $product_info['products_tax_class_id']) . '</s> <span class="productSpecialPrice">' . $osC_Currencies->displayPrice($new_price, $product_info['products_tax_class_id']) . '</span>';
} else {
$products_price = $osC_Currencies->displayPrice($product_info['products_price'], $product_info['products_tax_class_id']);
</pre></div>
<hr /><a name="file3" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog">catalog</a><br /></span>
<div class="fileheader"><big><b>product_reviews_info.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_reviews_info.php?rev=1.54&content-type=text/vnd.viewcvs-markup">1.54</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_reviews_info.php.diff?r1=1.54&r2=1.55">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_reviews_info.php?rev=1.55&content-type=text/vnd.viewcvs-markup">1.55</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.54 -r1.55
--- product_reviews_info.php 2004/04/13 07:52:41 1.54
+++ product_reviews_info.php 2004/10/31 09:46:09 1.55
@@ -28,7 +28,7 @@
</small></pre><pre class="diff" id="context"> $review_query = tep_db_query("select rd.reviews_text, r.reviews_rating, r.reviews_id, r.customers_name, r.date_added, r.reviews_read, p.products_id, p.products_price, p.products_tax_class_id, p.products_image, p.products_model, pd.products_name from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where r.reviews_id = '" . (int)$_GET['reviews_id'] . "' and r.reviews_id = rd.reviews_id and rd.languages_id = '" . (int)$osC_Session->value('languages_id') . "' and r.products_id = p.products_id and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '". (int)$osC_Session->value('languages_id') . "'");
$review = tep_db_fetch_array($review_query);
</pre><pre class="diff" id="removed">- if ($new_price = tep_get_products_special_price($review['products_id'])) {
</pre><pre class="diff" id="added">+ if ( ($osC_Services->isStarted('specials')) && ($new_price = $osC_Specials->getPrice($review['products_id'])) ) {
</pre><pre class="diff" id="context"> $products_price = '<s>' . $osC_Currencies->displayPrice($review['products_price'], $review['products_tax_class_id']) . '</s> <span class="productSpecialPrice">' . $osC_Currencies->displayPrice($new_price, $review['products_tax_class_id']) . '</span>';
} else {
$products_price = $osC_Currencies->displayPrice($review['products_price'], $review['products_tax_class_id']);
</pre></div>
<hr /><a name="file4" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog">catalog</a><br /></span>
<div class="fileheader"><big><b>product_reviews_write.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_reviews_write.php?rev=1.59&content-type=text/vnd.viewcvs-markup">1.59</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_reviews_write.php.diff?r1=1.59&r2=1.60">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/product_reviews_write.php?rev=1.60&content-type=text/vnd.viewcvs-markup">1.60</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.59 -r1.60
--- product_reviews_write.php 2004/07/22 17:23:53 1.59
+++ product_reviews_write.php 2004/10/31 09:46:09 1.60
@@ -55,7 +55,7 @@
</small></pre><pre class="diff" id="context"> }
}
</pre><pre class="diff" id="removed">- if ($new_price = tep_get_products_special_price($product_info['products_id'])) {
</pre><pre class="diff" id="added">+ if ( ($osC_Services->isStarted('specials')) && ($new_price = $osC_Specials->getPrice($product_info['products_id'])) ) {
</pre><pre class="diff" id="context"> $products_price = '<s>' . $osC_Currencies->displayPrice($product_info['products_price'], $product_info['products_tax_class_id']) . '</s> <span class="productSpecialPrice">' . $osC_Currencies->displayPrice($new_price, $product_info['products_tax_class_id']) . '</span>';
} else {
$products_price = $osC_Currencies->displayPrice($product_info['products_price'], $product_info['products_tax_class_id']);
</pre></div>
<hr /><a name="file5" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog">catalog</a><br /></span>
<div class="fileheader"><big><b>products_new.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/products_new.php?rev=1.30&content-type=text/vnd.viewcvs-markup">1.30</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/products_new.php.diff?r1=1.30&r2=1.31">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/products_new.php?rev=1.31&content-type=text/vnd.viewcvs-markup">1.31</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.30 -r1.31
--- products_new.php 2003/12/18 23:52:14 1.30
+++ products_new.php 2004/10/31 09:46:09 1.31
@@ -78,7 +78,7 @@
</small></pre><pre class="diff" id="context"> if ($products_new_split->number_of_rows > 0) {
$products_new_query = tep_db_query($products_new_split->sql_query);
while ($products_new = tep_db_fetch_array($products_new_query)) {
</pre><pre class="diff" id="removed">- if ($new_price = tep_get_products_special_price($products_new['products_id'])) {
</pre><pre class="diff" id="added">+ if ( ($osC_Services->isStarted('specials')) && ($new_price = $osC_Specials->getPrice($products_new['products_id'])) ) {
</pre><pre class="diff" id="context"> $products_price = '<s>' . $osC_Currencies->displayPrice($products_new['products_price'], $products_new['products_tax_class_id']) . '</s> <span class="productSpecialPrice">' . $osC_Currencies->displayPrice($new_price, $products_new['products_tax_class_id']) . '</span>';
} else {
$products_price = $osC_Currencies->displayPrice($products_new['products_price'], $products_new['products_tax_class_id']);
</pre></div>
<hr /><a name="file6" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog">catalog</a><br /></span>
<div class="fileheader"><big><b>specials.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/specials.php?rev=1.51&content-type=text/vnd.viewcvs-markup">1.51</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/specials.php.diff?r1=1.51&r2=1.52">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/specials.php?rev=1.52&content-type=text/vnd.viewcvs-markup">1.52</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.51 -r1.52
--- specials.php 2003/12/18 23:52:14 1.51
+++ specials.php 2004/10/31 09:46:09 1.52
@@ -12,6 +12,10 @@
</small></pre><pre class="diff" id="context">
require('includes/application_top.php');
</pre><pre class="diff" id="added">+ if (!$osC_Services->isStarted('specials')) {
+ tep_redirect(tep_href_link(FILENAME_DEFAULT));
+ }
+
</pre><pre class="diff" id="context"> require(DIR_WS_LANGUAGES . $osC_Session->value('language') . '/' . FILENAME_SPECIALS);
$breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_SPECIALS));
</pre></div>
<hr /><a name="file7" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes">includes</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/boxes">boxes</a><br /></span>
<div class="fileheader"><big><b>specials.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/boxes/specials.php?rev=1.34&content-type=text/vnd.viewcvs-markup">1.34</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/boxes/specials.php.diff?r1=1.34&r2=1.35">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/boxes/specials.php?rev=1.35&content-type=text/vnd.viewcvs-markup">1.35</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.34 -r1.35
--- specials.php 2004/02/16 07:26:29 1.34
+++ specials.php 2004/10/31 09:46:13 1.35
@@ -10,34 +10,37 @@
</small></pre><pre class="diff" id="context"> Released under the GNU General Public License
*/
</pre><pre class="diff" id="removed">- $Qspecials = $osC_Database->query('select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from :table_products p, :table_products_description pd, :table_specials s where s.status = 1 and s.products_id = p.products_id and p.products_status = 1 and p.products_id = pd.products_id and pd.language_id = :language_id order by s.specials_date_added desc limit :max_random_select_specials');
- $Qspecials->bindRaw(':table_products', TABLE_PRODUCTS);
- $Qspecials->bindRaw(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
- $Qspecials->bindRaw(':table_specials', TABLE_SPECIALS);
- $Qspecials->bindInt(':language_id', $osC_Session->value('languages_id'));
- $Qspecials->bindInt(':max_random_select_specials', MAX_RANDOM_SELECT_SPECIALS);
</pre><pre class="diff" id="added">+ if ($osC_Services->isStarted('specials')) {
</pre><pre class="diff" id="context">
</pre><pre class="diff" id="removed">- if ($Qspecials->executeRandomMulti()) {
</pre><pre class="diff" id="added">+ $Qspecials = $osC_Database->query('select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from :table_products p, :table_products_description pd, :table_specials s where s.status = 1 and s.products_id = p.products_id and p.products_status = 1 and p.products_id = pd.products_id and pd.language_id = :language_id order by s.specials_date_added desc limit :max_random_select_specials');
+ $Qspecials->bindRaw(':table_products', TABLE_PRODUCTS);
+ $Qspecials->bindRaw(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
+ $Qspecials->bindRaw(':table_specials', TABLE_SPECIALS);
+ $Qspecials->bindInt(':language_id', $osC_Session->value('languages_id'));
+ $Qspecials->bindInt(':max_random_select_specials', MAX_RANDOM_SELECT_SPECIALS);
+
+ if ($Qspecials->executeRandomMulti()) {
</pre><pre class="diff" id="context"> ?>
<!-- specials //-->
<tr>
<td>
<?php
</pre><pre class="diff" id="removed">- $info_box_contents = array();
- $info_box_contents[] = array('text' => BOX_HEADING_SPECIALS);
</pre><pre class="diff" id="added">+ $info_box_contents = array();
+ $info_box_contents[] = array('text' => BOX_HEADING_SPECIALS);
</pre><pre class="diff" id="context">
</pre><pre class="diff" id="removed">- new infoBoxHeading($info_box_contents, false, false, tep_href_link(FILENAME_SPECIALS));
</pre><pre class="diff" id="added">+ <span id="addedchars"> </span>new infoBoxHeading($info_box_contents, false, false, tep_href_link(FILENAME_SPECIALS));
</pre><pre class="diff" id="context">
</pre><pre class="diff" id="removed">- $info_box_contents = array();
- $info_box_contents[] = array('align' => 'center',
- 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $Qspecials->valueInt('products_id')) . '">' . tep_image(DIR_WS_IMAGES . $Qspecials->value('products_image'), $Qspecials->value('products_name'), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $Qspecials->valueInt('products_id')) . '">' . $Qspecials->value('products_name') . '</a><br><s>' . $osC_Currencies->displayPrice($Qspecials->valueDecimal('products_price'), $Qspecials->valueInt('products_tax_class_id')) . '</s>&nbsp;<span class="productSpecialPrice">' . $osC_Currencies->displayPrice($Qspecials->valueDecimal('specials_new_products_price'), $Qspecials->valueInt('products_tax_class_id')) . '</span>');
</pre><pre class="diff" id="added">+ $info_box_contents = array();
+ $info_box_contents[] = array('align' => 'center',
+ 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $Qspecials->valueInt('products_id')) . '">' . tep_image(DIR_WS_IMAGES . $Qspecials->value('products_image'), $Qspecials->value('products_name'), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $Qspecials->valueInt('products_id')) . '">' . $Qspecials->value('products_name') . '</a><br><s>' . $osC_Currencies->displayPrice($Qspecials->valueDecimal('products_price'), $Qspecials->valueInt('products_tax_class_id')) . '</s>&nbsp;<span class="productSpecialPrice">' . $osC_Currencies->displayPrice($Qspecials->valueDecimal('specials_new_products_price'), $Qspecials->valueInt('products_tax_class_id')) . '</span>');
</pre><pre class="diff" id="context">
</pre><pre class="diff" id="removed">- new infoBox($info_box_contents);
</pre><pre class="diff" id="added">+ <span id="addedchars"> </span>new infoBox($info_box_contents);
</pre><pre class="diff" id="context"> ?>
</td>
</tr>
<!-- specials_eof //-->
<?php
</pre><pre class="diff" id="removed">- $Qspecials->freeResult();
</pre><pre class="diff" id="added">+ <span id="addedchars"> </span>$Qspecials->freeResult();
+ }
</pre><pre class="diff" id="context"> }
?>
</pre></div>
<hr /><a name="file8" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes">includes</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/boxes">boxes</a><br /></span>
<div class="fileheader"><big><b>whats_new.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/boxes/whats_new.php?rev=1.35&content-type=text/vnd.viewcvs-markup">1.35</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/boxes/whats_new.php.diff?r1=1.35&r2=1.36">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/boxes/whats_new.php?rev=1.36&content-type=text/vnd.viewcvs-markup">1.36</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.35 -r1.36
--- whats_new.php 2004/05/03 19:43:24 1.35
+++ whats_new.php 2004/10/31 09:46:14 1.36
@@ -21,8 +21,11 @@
</small></pre><pre class="diff" id="context"> <td>
<?php
$new_products_name = tep_get_products_name($Qwhatsnew->valueInt('products_id'));
</pre><pre class="diff" id="removed">- $new_products_specials_price = tep_get_products_special_price($Qwhatsnew->valueInt('products_id'));
</pre><pre class="diff" id="context">
</pre><pre class="diff" id="added">+ if ($osC_Services->isStarted('specials')) {
+ $new_products_specials_price = $osC_Specials->getPrice($Qwhatsnew->valueInt('products_id'));
+ }
+
</pre><pre class="diff" id="context"> $info_box_contents = array();
$info_box_contents[] = array('text' => BOX_HEADING_WHATS_NEW);
</pre></div>
<hr /><a name="file9" /><div class="file">
<span class="pathname" id="added"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes">includes</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/classes">classes</a><br /></span>
<div class="fileheader" id="added"><big><b>specials.php</b></big> <small id="info">added at <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/classes/specials.php?rev=1.1&content-type=text/vnd.viewcvs-markup">1.1</a></small></div>
<pre class="diff"><small id="info">diff -N specials.php
--- /dev/null Sun Oct 31 10:46:04 2004
+++ /tmp/cvsAAAIKay9P Sun Oct 31 10:46:16 2004
@@ -0,0 +1,79 @@
</small></pre><pre class="diff" id="added">+<?php
+/*
+ $Id$
+
+ osCommerce, Open Source E-Commerce Solutions
+ http://www.oscommerce.com
+
+ Copyright (c) 2004 osCommerce
+
+ Released under the GNU General Public License
+*/
+
+ class osC_Specials {
+
+// class constructor
+ function osC_Specials() {
+
+ $this->expireSpecials();
+ $this->activateSpecials();
+ }
+
+ function expireSpecials() {
+ global $osC_Database, $osC_Session;
+
+ $Qspecials = $osC_Database->query('select specials_id from :table_specials where status = 1 and now() >= expires_date and expires_date > 0');
+ $Qspecials->bindRaw(':table_specials', TABLE_SPECIALS);
+ $Qspecials->execute();
+
+ while ($Qspecials->next()) {
+ $this->setStatus($Qspecials->valueInt('specials_id'), '0');
+ }
+
+ $Qspecials->freeResult();
+ }
+
+ function activateSpecials() {
+ global $osC_Database, $osC_Session;
+
+ $Qspecials = $osC_Database->query('select specials_id from :table_specials where status = 0 and now() >= start_date and start_date > 0 and now() < expires_date');
+ $Qspecials->bindRaw(':table_specials', TABLE_SPECIALS);
+ $Qspecials->execute();
+
+ while ($Qspecials->next()) {
+ $this->setStatus($Qspecials->valueInt('specials_id'), '1');
+ }
+
+ $Qspecials->freeResult();
+ }
+
+ function setStatus($specials_id, $status) {
+ global $osC_Database;
+
+ $QspecialsStatus = $osC_Database->query('update :table_specials set status = :status, date_status_change = now() where specials_id = :specials_id');
+ $QspecialsStatus->bindRaw(':table_specials', TABLE_SPECIALS);
+ $QspecialsStatus->bindInt(':status', $status);
+ $QspecialsStatus->bindInt(':specials_id', $specials_id);
+ $QspecialsStatus->execute();
+ }
+
+ function getPrice($product_id) {
+ global $osC_Database;
+
+ $Qspecial = $osC_Database->query('select specials_new_products_price from :table_specials where products_id = :products_id and status = 1');
+ $Qspecial->bindRaw(':table_specials', TABLE_SPECIALS);
+ $Qspecial->bindInt(':products_id', $product_id);
+ $Qspecial->execute();
+
+ if ($Qspecial->numberOfRows()) {
+ $special_price = $Qspecial->valueDecimal('specials_new_products_price');
+ } else {
+ $special_price = false;
+ }
+
+ $Qspecial->freeResult();
+
+ return $special_price;
+ }
+ }
+?>
</pre><pre class="diff"><small id="info">\ No newline at end of file
</small></pre></div>
<hr /><a name="file10" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes">includes</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/functions">functions</a><br /></span>
<div class="fileheader"><big><b>general.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/functions/general.php?rev=1.241&content-type=text/vnd.viewcvs-markup">1.241</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/functions/general.php.diff?r1=1.241&r2=1.242">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/functions/general.php?rev=1.242&content-type=text/vnd.viewcvs-markup">1.242</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.241 -r1.242
--- general.php 2004/07/22 16:53:53 1.241
+++ general.php 2004/10/31 09:46:16 1.242
@@ -95,28 +95,6 @@
</small></pre><pre class="diff" id="context"> }
////
</pre><pre class="diff" id="removed">-// Return a product's special price (returns nothing if there is no offer)
-// TABLES: products
- function tep_get_products_special_price($product_id) {
- global $osC_Database;
-
- $Qspecial = $osC_Database->query('select specials_new_products_price from :table_specials where products_id = :products_id and status = 1');
- $Qspecial->bindRaw(':table_specials', TABLE_SPECIALS);
- $Qspecial->bindInt(':products_id', $product_id);
- $Qspecial->execute();
-
- if ($Qspecial->numberOfRows()) {
- $special_price = $Qspecial->valueDecimal('specials_new_products_price');
- } else {
- $special_price = false;
- }
-
- $Qspecial->freeResult();
-
- return $special_price;
- }
-
-////
</pre><pre class="diff" id="context"> // Return a product's stock
// TABLES: products
function tep_get_products_stock($products_id) {
</pre></div>
<hr /><a name="file11" /><div class="file">
<span class="pathname" id="removed"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes">includes</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/functions">functions</a><br /></span>
<div class="fileheader" id="removed"><big><b>specials.php</b></big> <small id="info">removed after <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/functions/specials.php?rev=1.7&content-type=text/vnd.viewcvs-markup">1.7</a></small></div>
<pre class="diff"><small id="info">diff -N specials.php
--- /tmp/cvsAAA7XaG.P Sun Oct 31 10:46:17 2004
+++ /dev/null Sun Oct 31 10:46:04 2004
@@ -1,40 +0,0 @@
</small></pre><pre class="diff" id="removed">-<?php
-/*
- $Id$
-
- osCommerce, Open Source E-Commerce Solutions
- http://www.oscommerce.com
-
- Copyright (c) 2004 osCommerce
-
- Released under the GNU General Public License
-*/
-
-////
-// Sets the status of a special product
- function tep_set_specials_status($specials_id, $status) {
- global $osC_Database;
-
- $Qspecials = $osC_Database->query('update :table_specials set status = :status, date_status_change = now() where specials_id = :specials_id');
- $Qspecials->bindRaw(':table_specials', TABLE_SPECIALS);
- $Qspecials->bindInt(':status', $status);
- $Qspecials->bindInt(':specials_id', $specials_id);
- $Qspecials->execute();
- }
-
-////
-// Auto expire products on special
- function tep_expire_specials() {
- global $osC_Database;
-
- $Qspecials = $osC_Database->query('select specials_id from :table_specials where status = 1 and now() >= expires_date and expires_date > 0');
- $Qspecials->bindRaw(':table_specials', TABLE_SPECIALS);
- $Qspecials->execute();
-
- while ($Qspecials->next()) {
- tep_set_specials_status($Qspecials->valueInt('specials_id'), '0');
- }
-
- $Qspecials->freeResult();
- }
-?>
<hr /><a name="file12" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes">includes</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules">modules</a><br /></span>
<div class="fileheader"><big><b>new_products.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules/new_products.php?rev=1.38&content-type=text/vnd.viewcvs-markup">1.38</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules/new_products.php.diff?r1=1.38&r2=1.39">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules/new_products.php?rev=1.39&content-type=text/vnd.viewcvs-markup">1.39</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.38 -r1.39
--- new_products.php 2004/02/16 07:29:50 1.38
+++ new_products.php 2004/10/31 09:46:17 1.39
@@ -46,7 +46,10 @@
</small></pre><pre class="diff" id="context"> $info_box_contents = array();
while ($Qnewproducts->next()) {
</pre><pre class="diff" id="removed">- $specials_price = tep_get_products_special_price($Qnewproducts->valueInt('products_id'));
</pre><pre class="diff" id="added">+
+ if ($osC_Services->isStarted('specials')) {
+ $specials_price = $osC_Specials->getPrice($Qnewproducts->valueInt('products_id'));
+ }
</pre><pre class="diff" id="context">
$products_price = $osC_Currencies->displayPrice($Qnewproducts->valueDecimal('products_price'), $Qnewproducts->valueInt('products_tax_class_id'));
</pre></div>
<hr /><a name="file13" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes">includes</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules">modules</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules/services">services</a><br /></span>
<div class="fileheader"><big><b>specials.php</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules/services/specials.php?rev=1.1&content-type=text/vnd.viewcvs-markup">1.1</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules/services/specials.php.diff?r1=1.1&r2=1.2">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/includes/modules/services/specials.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
--- specials.php 2004/04/13 08:02:18 1.1
+++ specials.php 2004/10/31 09:46:19 1.2
@@ -12,16 +12,16 @@
</small></pre><pre class="diff" id="context">
class osC_Services_specials {
var $title = 'Specials',
</pre><pre class="diff" id="removed">- $description = 'Prepare the products that are on special.',
</pre><pre class="diff" id="added">+ $description = 'Enable Product Specials.',
</pre><pre class="diff" id="context"> $uninstallable = true,
$depends,
$preceeds;
function start() {
</pre><pre class="diff" id="removed">- include('includes/functions/specials.php');
</pre><pre class="diff" id="added">+ global $osC_Specials;
+ include('includes/classes/specials.php');
</pre><pre class="diff" id="context">
</pre><pre class="diff" id="removed">- tep_expire_specials();
-
</pre><pre class="diff" id="added">+ $osC_Specials = new osC_Specials();
</pre><pre class="diff" id="context"> return true;
}
</pre><pre class="diff"><small id="info">@@ -30,15 +30,16 @@
</small></pre><pre class="diff" id="context"> }
function install() {
</pre><pre class="diff" id="removed">- return false;
</pre><pre class="diff" id="added">+ tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Special Products', 'MAX_DISPLAY_SPECIAL_PRODUCTS', '9', 'Maximum number of products on special to display', '6', '0', now())");
+ tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Selection of Products on Special', 'MAX_RANDOM_SELECT_SPECIALS', '10', 'How many records to select from to choose one random product special to display', '6', '0', now())");
</pre><pre class="diff" id="context"> }
function remove() {
</pre><pre class="diff" id="removed">- return false;
</pre><pre class="diff" id="added">+ tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
</pre><pre class="diff" id="context"> }
function keys() {
</pre><pre class="diff" id="removed">- return false;
</pre><pre class="diff" id="added">+ return array('MAX_DISPLAY_SPECIAL_PRODUCTS', 'MAX_RANDOM_SELECT_SPECIALS');
</pre><pre class="diff" id="context"> }
}
?>
</pre></div>
<hr /><a name="file14" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/install">install</a><br /></span>
<div class="fileheader"><big><b>oscommerce.sql</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/install/oscommerce.sql?rev=1.102&content-type=text/vnd.viewcvs-markup">1.102</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/install/oscommerce.sql.diff?r1=1.102&r2=1.103">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/install/oscommerce.sql?rev=1.103&content-type=text/vnd.viewcvs-markup">1.103</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.102 -r1.103
--- oscommerce.sql 2004/08/17 23:47:54 1.102
+++ oscommerce.sql 2004/10/31 09:46:20 1.103
@@ -518,6 +518,7 @@
</small></pre><pre class="diff" id="context"> specials_new_products_price decimal(15,4) NOT NULL,
specials_date_added datetime,
specials_last_modified datetime,
</pre><pre class="diff" id="added">+ start_date datetime,
</pre><pre class="diff" id="context"> expires_date datetime,
date_status_change datetime,
status int(1) NOT NULL DEFAULT '1',
</pre><pre class="diff"><small id="info">@@ -642,7 +643,7 @@
</small></pre><pre class="diff" id="context"> INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Address Book Entries', 'MAX_ADDRESS_BOOK_ENTRIES', '5', 'Maximum address book entries a customer is allowed to have', '3', '1', now());
INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Search Results', 'MAX_DISPLAY_SEARCH_RESULTS', '20', 'Amount of products to list', '3', '2', now());
INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Page Links', 'MAX_DISPLAY_PAGE_LINKS', '5', 'Number of \'number\' links use for page-sets', '3', '3', now());
</pre><pre class="diff" id="removed">-INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Special Products', 'MAX_DISPLAY_SPECIAL_PRODUCTS', '9', 'Maximum number of products on special to display', '3', '4', now());
</pre><pre class="diff" id="added">+
</pre><pre class="diff" id="context"> INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('New Products Module', 'MAX_DISPLAY_NEW_PRODUCTS', '9', 'Maximum number of new products to display in a category', '3', '5', now());
INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Products Expected', 'MAX_DISPLAY_UPCOMING_PRODUCTS', '10', 'Maximum number of products expected to display', '3', '6', now());
INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Manufacturers List', 'MAX_DISPLAY_MANUFACTURERS_IN_A_LIST', '0', 'Used in manufacturers box; when the number of manufacturers exceeds this number, a drop-down list will be displayed instead of the default list', '3', '7', now());
</pre><pre class="diff"><small id="info">@@ -651,7 +652,7 @@
</small></pre><pre class="diff" id="context"> INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('New Reviews', 'MAX_DISPLAY_NEW_REVIEWS', '6', 'Maximum number of new reviews to display', '3', '9', now());
INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Selection of Random Reviews', 'MAX_RANDOM_SELECT_REVIEWS', '10', 'How many records to select from to choose one random product review', '3', '10', now());
INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Selection of Random New Products', 'MAX_RANDOM_SELECT_NEW', '10', 'How many records to select from to choose one random new product to display', '3', '11', now());
</pre><pre class="diff" id="removed">-INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Selection of Products on Special', 'MAX_RANDOM_SELECT_SPECIALS', '10', 'How many records to select from to choose one random product special to display', '3', '12', now());
</pre><pre class="diff" id="added">+
</pre><pre class="diff" id="context"> INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Categories To List Per Row', 'MAX_DISPLAY_CATEGORIES_PER_ROW', '3', 'How many categories to list per row', '3', '13', now());
INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('New Products Listing', 'MAX_DISPLAY_PRODUCTS_NEW', '10', 'Maximum number of new products to display in new products page', '3', '14', now());
INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Best Sellers', 'MAX_DISPLAY_BESTSELLERS', '10', 'Maximum number of best sellers to display', '3', '15', now());
</pre><pre class="diff"><small id="info">@@ -776,6 +777,8 @@
</small></pre><pre class="diff" id="context"> INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Check IP Address', 'SERVICE_SESSION_CHECK_IP_ADDRESS', 'False', 'Check the IP address on every page request.', '6', '0', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now());
INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Regenerate Session ID', 'SERVICE_SESSION_REGENERATE_ID', 'False', 'Regenerate the session ID when a customer logs on or creates an account (requires PHP >= 4.1).', '6', '0', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now());
INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Detect Search Engine Spider Robots', 'SERVICE_WHOS_ONLINE_SPIDER_DETECTION', 'True', 'Detect search engine spider robots (GoogleBot, Yahoo, etc).', '6', '0', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now());
</pre><pre class="diff" id="added">+INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Special Products', 'MAX_DISPLAY_SPECIAL_PRODUCTS', '9', 'Maximum number of products on special to display', '6', '0', now());
+INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Selection of Products on Special', 'MAX_RANDOM_SELECT_SPECIALS', '10', 'How many records to select from to choose one random product special to display', '6', '0', now());
</pre><pre class="diff" id="context">
INSERT INTO osc_configuration_group VALUES ('1', 'My Store', 'General information about my store', '1', '1');
INSERT INTO osc_configuration_group VALUES ('2', 'Minimum Values', 'The minimum values for functions / data', '2', '1');
</pre></div>
<hr /><a name="file15" /><div class="file">
<span class="pathname"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog">catalog</a>/<a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/install">install</a><br /></span>
<div class="fileheader"><big><b>oscommerce_sample_data.sql</b></big> <small id="info"><a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/install/oscommerce_sample_data.sql?rev=1.5&content-type=text/vnd.viewcvs-markup">1.5</a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/install/oscommerce_sample_data.sql.diff?r1=1.5&r2=1.6">-></a> <a href="http://cvs.oscommerce.com/viewcvs.cgi/catalog/catalog/install/oscommerce_sample_data.sql?rev=1.6&content-type=text/vnd.viewcvs-markup">1.6</a></small></div>
<pre class="diff"><small id="info">diff -u -r1.5 -r1.6
--- oscommerce_sample_data.sql 2004/07/22 21:03:35 1.5
+++ oscommerce_sample_data.sql 2004/10/31 09:46:21 1.6
@@ -367,7 +367,7 @@
</small></pre><pre class="diff" id="context">
INSERT INTO osc_reviews_description VALUES (1,1, 'this has to be one of the funniest movies released for 1999!');
</pre><pre class="diff" id="removed">-INSERT INTO osc_specials VALUES (1,3, 39.99, now(), '', '', '', '1');
-INSERT INTO osc_specials VALUES (2,5, 30.00, now(), '', '', '', '1');
-INSERT INTO osc_specials VALUES (3,6, 30.00, now(), '', '', '', '1');
-INSERT INTO osc_specials VALUES (4,16, 29.99, now(), '', '', '', '1');
</pre><pre class="diff" id="added">+INSERT INTO osc_specials VALUES (1,3, 39.99, now(), '', '', '', '', '1');
+INSERT INTO osc_specials VALUES (2,5, 30.00, now(), '', '', '', '', '1');
+INSERT INTO osc_specials VALUES (3,6, 30.00, now(), '', '', '', '', '1');
+INSERT INTO osc_specials VALUES (4,16, 29.99, now(), '', '', '', '', '1');
</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