|
|
[TEP-COMMIT] [CVS catalog] Specials Update.: msg#00020
|
Subject: |
[TEP-COMMIT] [CVS catalog] Specials Update. |
1 added + 1 removed + 13 modified, total 15 files
catalog/catalog
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 @@
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') . "'");
- if ($new_price = tep_get_products_special_price($product_info['products_id'])) {
+ if ( ($osC_Services->isStarted('specials')) && ($new_price = $osC_Specials->getPrice($product_info['products_id'])) ) {
$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']);
catalog/catalog
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 @@
$product_info = tep_db_fetch_array($product_info_query);
}
- if ($new_price = tep_get_products_special_price($product_info['products_id'])) {
+ if ( ($osC_Services->isStarted('specials')) && ($new_price = $osC_Specials->getPrice($product_info['products_id'])) ) {
$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']);
catalog/catalog
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 @@
$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);
- if ($new_price = tep_get_products_special_price($review['products_id'])) {
+ if ( ($osC_Services->isStarted('specials')) && ($new_price = $osC_Specials->getPrice($review['products_id'])) ) {
$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']);
catalog/catalog
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 @@
}
}
- if ($new_price = tep_get_products_special_price($product_info['products_id'])) {
+ if ( ($osC_Services->isStarted('specials')) && ($new_price = $osC_Specials->getPrice($product_info['products_id'])) ) {
$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']);
catalog/catalog
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 @@
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)) {
- if ($new_price = tep_get_products_special_price($products_new['products_id'])) {
+ if ( ($osC_Services->isStarted('specials')) && ($new_price = $osC_Specials->getPrice($products_new['products_id'])) ) {
$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']);
catalog/catalog
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 @@
require('includes/application_top.php');
+ if (!$osC_Services->isStarted('specials')) {
+ tep_redirect(tep_href_link(FILENAME_DEFAULT));
+ }
+
require(DIR_WS_LANGUAGES . $osC_Session->value('language') . '/' . FILENAME_SPECIALS);
$breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_SPECIALS));
catalog/catalog/includes/boxes
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 @@
Released under the GNU General Public License
*/
- $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 ($osC_Services->isStarted('specials')) {
- if ($Qspecials->executeRandomMulti()) {
+ $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()) {
?>
<!-- specials //-->
<tr>
<td>
<?php
- $info_box_contents = array();
- $info_box_contents[] = array('text' => BOX_HEADING_SPECIALS);
+ $info_box_contents = array();
+ $info_box_contents[] = array('text' => BOX_HEADING_SPECIALS);
- new infoBoxHeading($info_box_contents, false, false, tep_href_link(FILENAME_SPECIALS));
+ new infoBoxHeading($info_box_contents, false, false, tep_href_link(FILENAME_SPECIALS));
- $info_box_contents = array();
- $info_box_contents[] = array('align' => 'center',
- 'text' => '<a href="">' . tep_image(DIR_WS_IMAGES . $Qspecials->value('products_image'), $Qspecials->value('products_name'), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="">' . $Qspecials->value('products_name') . '</a><br><s>' . $osC_Currencies->displayPrice($Qspecials->valueDecimal('products_price'), $Qspecials->valueInt('products_tax_class_id')) . '</s> <span class="productSpecialPrice">' . $osC_Currencies->displayPrice($Qspecials->valueDecimal('specials_new_products_price'), $Qspecials->valueInt('products_tax_class_id')) . '</span>');
+ $info_box_contents = array();
+ $info_box_contents[] = array('align' => 'center',
+ 'text' => '<a href="">' . tep_image(DIR_WS_IMAGES . $Qspecials->value('products_image'), $Qspecials->value('products_name'), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="">' . $Qspecials->value('products_name') . '</a><br><s>' . $osC_Currencies->displayPrice($Qspecials->valueDecimal('products_price'), $Qspecials->valueInt('products_tax_class_id')) . '</s> <span class="productSpecialPrice">' . $osC_Currencies->displayPrice($Qspecials->valueDecimal('specials_new_products_price'), $Qspecials->valueInt('products_tax_class_id')) . '</span>');
- new infoBox($info_box_contents);
+ new infoBox($info_box_contents);
?>
</td>
</tr>
<!-- specials_eof //-->
<?php
- $Qspecials->freeResult();
+ $Qspecials->freeResult();
+ }
}
?>
catalog/catalog/includes/boxes
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 @@
<td>
<?php
$new_products_name = tep_get_products_name($Qwhatsnew->valueInt('products_id'));
- $new_products_specials_price = tep_get_products_special_price($Qwhatsnew->valueInt('products_id'));
+ if ($osC_Services->isStarted('specials')) {
+ $new_products_specials_price = $osC_Specials->getPrice($Qwhatsnew->valueInt('products_id'));
+ }
+
$info_box_contents = array();
$info_box_contents[] = array('text' => BOX_HEADING_WHATS_NEW);
catalog/catalog/includes/classes
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 @@
+<?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;
+ }
+ }
+?>
\ No newline at end of file
catalog/catalog/includes/functions
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 @@
}
////
-// 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;
- }
-
-////
// Return a product's stock
// TABLES: products
function tep_get_products_stock($products_id) {
catalog/catalog/includes/functions
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 @@
-<?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();
- }
-?>
catalog/catalog/includes/modules
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 @@
$info_box_contents = array();
while ($Qnewproducts->next()) {
- $specials_price = tep_get_products_special_price($Qnewproducts->valueInt('products_id'));
+
+ if ($osC_Services->isStarted('specials')) {
+ $specials_price = $osC_Specials->getPrice($Qnewproducts->valueInt('products_id'));
+ }
$products_price = $osC_Currencies->displayPrice($Qnewproducts->valueDecimal('products_price'), $Qnewproducts->valueInt('products_tax_class_id'));
catalog/catalog/includes/modules/services
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 @@
class osC_Services_specials {
var $title = 'Specials',
- $description = 'Prepare the products that are on special.',
+ $description = 'Enable Product Specials.',
$uninstallable = true,
$depends,
$preceeds;
function start() {
- include('includes/functions/specials.php');
+ global $osC_Specials;
+ include('includes/classes/specials.php');
- tep_expire_specials();
-
+ $osC_Specials = new osC_Specials();
return true;
}
@@ -30,15 +30,16 @@
}
function install() {
- return false;
+ 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())");
}
function remove() {
- return false;
+ tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
}
function keys() {
- return false;
+ return array('MAX_DISPLAY_SPECIAL_PRODUCTS', 'MAX_RANDOM_SELECT_SPECIALS');
}
}
?>
catalog/catalog/install
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 @@
specials_new_products_price decimal(15,4) NOT NULL,
specials_date_added datetime,
specials_last_modified datetime,
+ start_date datetime,
expires_date datetime,
date_status_change datetime,
status int(1) NOT NULL DEFAULT '1',
@@ -642,7 +643,7 @@
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());
-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());
+
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());
@@ -651,7 +652,7 @@
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());
-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());
+
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());
@@ -776,6 +777,8 @@
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());
+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());
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');
catalog/catalog/install
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 @@
INSERT INTO osc_reviews_description VALUES (1,1, 'this has to be one of the funniest movies released for 1999!');
-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');
+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');
CVSspam 0.2.9
-------------------------------------------------------
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
|
| |
