http://www.ol-commerce.com, http://www.seifenparadies.de
Copyright (c) 2004 OL-Commerce , 2006 Dipl.-Ing.(TH) Winfried Kaiser (w.kaiser@fortune.de, info@seifenparadies.de)
-----------------------------------------------------------------------------------------
based on:
(c) 2000-2001 The Exchange Project (earlier name of osCommerce)
(c) 2002-2003 osCommerce(new_products.php,v 1.33 2003/02/12); www.oscommerce.com
(c) 2003 nextcommerce (new_products.php,v 1.9 2003/08/17); www.nextcommerce.org
(c) 2004 XT - Commerce; www.xt-commerce.com
Released under the GNU General Public License
-----------------------------------------------------------------------------------------
Third Party contributions:
Enable_Disable_Categories 1.3 Autor: Mikel Williams | mikel@ladykatcostumes.com
Released under the GNU General Public License
---------------------------------------------------------------------------------------*/
//W. Kaiser - AJAX
$stand_alone = !defined('DIR_FS_INC');
if ($stand_alone) {
include 'includes/application_top.php';
}
$products_listing_sql_main = olc_standard_products_query($new_products_category_id) . "\n\tand (p.products_date_available IS NULL OR\n\t\t(p.products_date_available IS NOT NULL AND to_days(p.products_date_available)<=to_days(now()))\n\t)\n order by p.products_id DESC\n limit " . MAX_DISPLAY_NEW_PRODUCTS;
$breadcrumb_link = FILENAME_NEW_PRODUCTS;
$smarty_config_section = "new_products";
${$categories_name_main} = TEXT_CAT_NEW_PRODUCTS;
$categories_description_main = TEXT_OUR_NEW_PRODUCTS;
$force_stand_alone = !$force_stand_alone_deny;
$ignore_scripts = CURRENT_SCRIPT;
include DIR_FS_INC . 'olc_prepare_specials_whatsnew_modules.inc.php';
$force_stand_alone = false;
olc_smarty_init($module_smarty, $cache_id);
$basket_query = olc_db_query(SELECT_ALL . TABLE_CUSTOMERS_BASKET_SAVE_BASKETS . $where_cid . ' order by basket_date_added DESC');
if (olc_db_num_rows($basket_query)) {
require_once DIR_FS_INC . 'olc_draw_radio_field.inc.php';
require_once DIR_FS_INC . 'olc_draw_checkbox_field.inc.php';
require_once DIR_FS_INC . 'olc_get_prid.inc.php';
require_once DIR_FS_INC . 'olc_get_smarty_config_variable.inc.php';
$module_content = array();
while ($basket = olc_db_fetch_array($basket_query)) {
$basket_id = $basket['customers_basket_id'];
$show_order_details = $basket_id == $bid;
if ($show_order_details) {
$where_bid = $sql_where . "customers_basket_id='" . $basket_id . APOS;
$products_basket_query = olc_db_query(SELECT_ALL . TABLE_CUSTOMERS_BASKET_SAVE . $where_bid);
if (olc_db_num_rows($products_basket_query) > 0) {
$products_query_sql0 = olc_standard_products_query();
/*
$products_query_sql0="
select
p.products_id,
pd.products_name,
p.products_image,
p.products_model,
p.products_price,
p.products_discount_allowed,
p.products_weight,
p.products_tax_class_id
from " .
TABLE_PRODUCTS . " p, " .
TABLE_PRODUCTS_DESCRIPTION . " pd
where
Released under the GNU General Public License
--------------------------------------------------------------*/
$pID = $_GET['pID'];
$is_post = false;
if ($_POST) {
$is_post = true;
$pInfo = new objectInfo($_POST);
$products_name = $_POST['products_name'];
$products_description = $_POST['products_description'];
$products_short_description = $_POST['products_short_description'];
$products_meta_title = $_POST['products_meta_title'];
$products_meta_description = $_POST['products_meta_description'];
$products_meta_keywords = $_POST['products_meta_keywords'];
$products_url = $_POST['products_url'];
} elseif ($pID) {
$product_query = olc_standard_products_query() . SQL_AND . 'p.products_id=' . $pID;
$product_query = olc_db_query($product_query);
//W. Kaiser - Baseprice
$product = olc_db_fetch_array($product_query);
$pInfo = new objectInfo($product);
$products_name = stripslashes($pInfo->products_name);
$products_name = str_replace('\\', EMPTY_STRING, $products_name);
} else {
$pInfo = new objectInfo(array());
}
$manufacturers_array = array(array('id' => EMPTY_STRING, 'text' => TEXT_NONE));
$manufacturers_query = olc_db_query("select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS . " order by manufacturers_name");
while ($manufacturers = olc_db_fetch_array($manufacturers_query)) {
$manufacturers_array[] = array('id' => $manufacturers['manufacturers_id'], 'text' => $manufacturers['manufacturers_name']);
}
$vpe_array = array(array('id' => EMPTY_STRING, 'text' => TEXT_NONE));
}
if ($products_id) {
$searchkey .= "=" . $products_id;
$searchkey0 = "products_" . $searchkey;
$searchkey = " and p." . $searchkey0;
$s = 'products_id_full';
if (isset($_SESSION[$s])) {
$products_id_full = $_SESSION[$s];
unset($_SESSION[$s]);
}
//
//W. Kaiser - allow search by 'products_model' (better approach for 'deep linking')!
//
//
//W. Kaiser - Baseprice
$product_info_query = olc_standard_products_query(EMPTY_STRING) . $searchkey;
$product_info_query = olc_db_query($product_info_query);
//W. Kaiser - Baseprice
//
//W. Kaiser - allow search by 'products_model' (better approach for 'deep linking') !
//
if (olc_db_num_rows($product_info_query)) {
$product_info = olc_db_fetch_array($product_info_query);
$products_name = str_replace(array(HTML_BR, strtoupper(HTML_BR)), BLANK, $product_info['products_name']);
$products_name = str_replace(HTML_AMP, AMP, $products_name);
$products_name = str_replace('\\', EMPTY_STRING, $products_name);
//W. Kaiser - AJAX
$parameter = 'action=add_product';
if (USE_AJAX) {
require_once DIR_FS_INC . 'olc_get_uprid.inc.php';
//Note: the quantity will no longer be added to the cart-quantity, but is set as the t o t a l quatity!
$module = EMPTY_STRING;
$status_cond = 'products_status=1';
$lowest_text = 'lowest';
$highest_text = 'highest';
$lowest_id = $_SESSION[$lowest_text];
if (!$lowest_id) {
$product_query_text = SELECT . 'min(products_id) as lowest, max(products_id) as highest FROM ' . TABLE_PRODUCTS . SQL_WHERE . $status_cond;
$product_query = olc_db_query($product_query_text);
$product_query = olc_db_fetch_array($product_query);
$lowest_id = $product_query[$lowest_text];
$highest_id = $product_query[$highest_text];
$_SESSION[$lowest_text] = $lowest_id;
$_SESSION[$highest_text] = $highest_id;
}
$highest_id = $_SESSION[$highest_text];
$products_listing_sql0 = olc_standard_products_query(EMPTY_STRING) . "\n\t \tand p.products_id = @\n \tand p." . $status_cond . "\n \tLIMIT 1";
while (true) {
$products_id = (int) olc_rand($lowest_id, $highest_id);
$products_listing_sql = str_replace(ATSIGN, $products_id, $products_listing_sql0);
$product_query = olc_db_query($products_listing_sql);
if (olc_db_num_rows($product_query) > 0) {
if ($products_id != $_SESSION[$last_slide_text]) {
$_SESSION[$last_slide_text] = $products_id;
break;
}
}
}
/*
$products_listing_sql="
select distinct
p.products_id,
<?php /* ----------------------------------------------------------------------------------------- $Id: upcoming_products.php,v 1.1.1.1.2.1 2007/04/08 07:18:02 gswkaiser Exp $ OL-Commerce Version 5.x/AJAX http://www.ol-commerce.com, http://www.seifenparadies.de Copyright (c) 2004 OL-Commerce , 2006 Dipl.-Ing.(TH) Winfried Kaiser (w.kaiser@fortune.de, info@seifenparadies.de) ----------------------------------------------------------------------------------------- based on: (c) 2000-2001 The Exchange Project (earlier name of osCommerce) (c) 2002-2003 osCommerce(upcoming_products.php,v 1.23 2003/02/12); www.oscommerce.com (c) 2003 nextcommerce (upcoming_products.php,v 1.7 2003/08/22); www.nextcommerce.org (c) 2004 XT - Commerce; www.xt-commerce.com Released under the GNU General Public License ---------------------------------------------------------------------------------------*/ //$products_listing_sql = " $products_listing_sql_main = olc_standard_products_query($current_category_id) . "\n and to_days(p.products_date_available) > to_days(now())\n order by products_date_available " . EXPECTED_PRODUCTS_SORT . " limit " . MAX_DISPLAY_UPCOMING_PRODUCTS; unset($module_smarty); $breadcrumb_link = FILENAME_UPCOMING_PRODUCTS; $smarty_config_section = "upcoming_products"; $categories_name = TEXT_CAT_UPCOMING_PRODUCTS; $categories_description = TEXT_OUR_UPCOMING_PRODUCTS; $force_stand_alone = !$force_stand_alone_deny; $ignore_scripts = CURRENT_SCRIPT; include DIR_FS_INC . 'olc_prepare_specials_whatsnew_modules.inc.php'; $force_stand_alone = false;
<?php
/* -----------------------------------------------------------------------------------------
$Id: products_promotion.php,v 1.1.1.1 2006/12/22 13:43:03 gswkaiser Exp $
OL-Commerce Version 5.x/AJAX
http://www.ol-commerce.com, http://www.seifenparadies.de
Copyright (c) 2006 Dipl.-Ing.(TH) Winfried Kaiser (w.kaiser@fortune.de, info@seifenparadies.de)
All rights reserved!
N o t (!) released under the GNU General Public License
---------------------------------------------------------------------------------------*/
if (DO_PROMOTION) {
$products_listing_sql_main = olc_standard_products_query(EMPTY_STRING) . "\nand p.products_promotion = '1'\nand p.products_price >= 0\nORDER BY p.products_id DESC";
unset($module_smarty);
$smarty_config_section = 'products_promotion';
$products_listing_template = $smarty_config_section . HTML_EXT;
$breadcrumb_link = FILENAME_PROMOTION_PRODUCTS;
$categories_name = TEXT_CAT_PROMOTION_PRODUCTS;
$categories_description = TEXT_OUR_PROMOTION_PRODUCTS;
$force_stand_alone = !$force_stand_alone_deny;
$ignore_scripts = CURRENT_SCRIPT;
$is_promotion = true;
include DIR_FS_INC . 'olc_prepare_specials_whatsnew_modules.inc.php';
$force_stand_alone = false;
/*
olc_smarty_init($module_smarty,$cacheid);
$pp_query_sql=
$pp_query = olc_dbquery($pp_query_sql);
$row = 0;
