Bilder-?berschreiben

Ape50 · #1 (**permalink**) 26.02.2006, 18:58

Hallo
Ich habe mir schon etwas einfallen lassen damit die Bilder die ich Hochlade im Adminbereich die Artike-ID haben...

Nur ich habe ein Problem, kann mir jemand diese Php Datei umschreiben. Wenn Z.B von dem Artikel schon ein Bild vorhanden ist einfach das Bild ?berschrieben wird wenn ich ein neues Hochladen m?chte:

Hier die catergories.php

[code]<?php
/* --------------------------------------------------------------
$Id: categories.php,v 1.45 2004/04/25 13:58:08 fanta2k Exp $

XT-Commerce - community made shopping
http://www.xt-commerce.com

Copyright © 2003 XT-Commerce und hubbabubba 2005
--------------------------------------------------------------
Patch 31.08.2005, save productimages name of ID, from hubbabubba int.ltd.
--------------------------------------------------------------
based on:
© 2000-2001 The Exchange Project (earlier name of osCommerce)
© 2002-2003 osCommerce(categories.php,v 1.140 2003/03/24); www.oscommerce.com
© 2003 nextcommerce (categories.php,v 1.37 2003/08/18); www.nextcommerce.org

Released under the GNU General Public License
--------------------------------------------------------------
Third Party contribution:
Enable_Disable_Categories 1.3 Autor: Mikel Williams | mikel@ladykatcostumes.com
New Attribute Manager v4b Autor: Mike G | mp3man@internetwork.net | http://downloads.ephing.com
Category Descriptions (Version: 1.5 MS2) Original Author: Brian Lowe <blowe@wpcusrgrp.org> | Editor: Lord Illicious <shaolin-venoms@illicious.net>
Customers Status v3.x © 2002-2003 Copyright Elari elari@free.fr | www.unlockgsm.com/dload-osc/ | CVS : http://cvs.sourceforge.net/cgi-bin/viewcvs...by=date#dirlist

Released under the GNU General Public License
--------------------------------------------------------------*/

require('includes/application_top.php');
include ('includes/classes/image_manipulator.php');
require_once(DIR_FS_INC .'xtc_get_tax_rate.inc.php');
require(DIR_WS_CLASSES . 'currencies.php');
$currencies = new currencies();

if ($_GET['function']) {
switch ($_GET['function']) {
case 'delete':
xtc_db_query("DELETE FROM personal_offers_by_customers_status_" . (int)$_GET['statusID'] . " WHERE products_id = '" . (int)$_GET['pID'] . "' AND quantity = '" . (int)$_GET['quantity'] . "'");
break;
}
xtc_redirect(xtc_href_link(FILENAME_CATEGORIES, 'cPath=' . $_GET['cPath'] . '&action=new_product&pID=' . (int)$_GET['pID']));
}
if ($_GET['action']) {
switch ($_GET['action']) {
case 'setflag':
if ( ($_GET['flag'] == '0') || ($_GET['flag'] == '1') ) {
if ($_GET['pID']) {
xtc_set_product_status($_GET['pID'], $_GET['flag']);
}
if ($_GET['cID']) {
xtc_set_categories_rekursiv($_GET['cID'], $_GET['flag']);
}
}

xtc_redirect(xtc_href_link(FILENAME_CATEGORIES, 'cPath=' . $_GET['cPath']));
break;

case 'new_category':
case 'edit_category':
if (ALLOW_CATEGORY_DESCRIPTIONS == 'true')
$_GET['action']=$_GET['action'] . '_ACD';
break;

case 'insert_category':
case 'update_category':
if (($_POST['edit_x']) || ($_POST['edit_y'])) {
$_GET['action'] = 'edit_category_ACD';
} else {
$categories_id = xtc_db_prepare_input($_POST['categories_id']);
if ($categories_id == '') {
$categories_id = xtc_db_prepare_input($_GET['cID']);
}
$sort_order = xtc_db_prepare_input($_POST['sort_order']);
$categories_status = xtc_db_prepare_input($_POST['categories_status']);

// set allowed c.groups
$group_ids='';
if(isset($_POST['groups'])) foreach($_POST['groups'] as $b){
$group_ids .= 'c_'.$b."_group ,";
}
$customers_statuses_array=xtc_get_customers_status es();
if (strstr($group_ids,'c_all_group')) {
$group_ids='c_all_group,';
for ($i=0;$n=sizeof($customers_statuses_array),$i<$n;$ i++) {
$group_ids .='c_'.$customers_statuses_array[$i]['id'].'_group,';
}
}
$sql_data_array = array( 'sort_order' => $sort_order,
'group_ids'=>$group_ids,
'categories_status' => $categories_status,
'products_sorting' => xtc_db_prepare_input($_POST['products_sorting']),
'products_sorting2' => xtc_db_prepare_input($_POST['products_sorting2']),
'categories_template'=>xtc_db_prepare_input($_P OST['categorie_template']),
'listing_template'=>xtc_db_prepare_input($_POST['listing_template']));

if ($_GET['action'] == 'insert_category') {
$insert_sql_data = array('parent_id' => $current_category_id,
'date_added' => 'now()');
$sql_data_array = xtc_array_merge($sql_data_array, $insert_sql_data);
xtc_db_perform(TABLE_CATEGORIES, $sql_data_array);
$categories_id = xtc_db_insert_id();
} elseif ($_GET['action'] == 'update_category') {
$update_sql_data = array('last_modified' => 'now()');
$sql_data_array = xtc_array_merge($sql_data_array, $update_sql_data);
xtc_db_perform(TABLE_CATEGORIES, $sql_data_array, 'update', 'categories_id = \'' . $categories_id . '\'');
}
xtc_set_groups($categories_id,$group_ids);
$languages = xtc_get_languages();
for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
$categories_name_array = $_POST['categories_name'];
$language_id = $languages[$i]['id'];
$sql_data_array = array('categories_name' => xtc_db_prepare_input($categories_name_array[$language_id]));
if (ALLOW_CATEGORY_DESCRIPTIONS == 'true') {
$sql_data_array = array('categories_name' => xtc_db_prepare_input($_POST['categories_name'][$language_id]),
'categories_heading_title' => xtc_db_prepare_input($_POST['categories_heading_title'][$language_id]),
'categories_description' => xtc_db_prepare_input($_POST['categories_description'][$language_id]),
'categories_meta_title' => xtc_db_prepare_input($_POST['categories_meta_title'][$language_id]),
'categories_meta_description' => xtc_db_prepare_input($_POST['categories_meta_description'][$language_id]),
'categories_meta_keywords' => xtc_db_prepare_input($_POST['categories_meta_keywords'][$language_id]));
}

if ($_GET['action'] == 'insert_category') {
$insert_sql_data = array('categories_id' => $categories_id,
'language_id' => $languages[$i]['id']);
$sql_data_array = xtc_array_merge($sql_data_array, $insert_sql_data);
xtc_db_perform(TABLE_CATEGORIES_DESCRIPTION, $sql_data_array);
} elseif ($_GET['action'] == 'update_category') {
xtc_db_perform(TABLE_CATEGORIES_DESCRIPTION, $sql_data_array, 'update', 'categories_id = \'' . $categories_id . '\' and language_id = \'' . $languages[$i]['id'] . '\'');
}
}

if ($categories_image = new upload('categories_image', DIR_FS_CATALOG_IMAGES.'categories/')) {
xtc_db_query("update " . TABLE_CATEGORIES . " set categories_image = '" . xtc_db_input($categories_image->filename) . "' where categories_id = '" . (int)$categories_id . "'");
}

xtc_redirect(xtc_href_link(FILENAME_CATEGORIES, 'cPath=' . $_GET['cPath'] . '&cID=' . $categories_id));
}
break;

case 'delete_category_confirm':
if ($_POST['categories_id']) {
$categories_id = xtc_db_prepare_input($_POST['categories_id']);

$categories = xtc_get_category_tree($categories_id, '', '0', '', true);
$products = array();
$products_delete = array();

for ($i = 0, $n = sizeof($categories); $i < $n; $i++) {
$product_ids_query = xtc_db_query("select products_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . $categories[$i]['id'] . "'");
while ($product_ids = xtc_db_fetch_array($product_ids_query)) {
$products[$product_ids['products_id']]['categories'][] = $categories[$i]['id'];
}
}

reset($products);
while (list($key, $value) = each($products)) {
$category_ids = '';
for ($i = 0, $n = sizeof($value['categories']); $i < $n; $i++) {
$category_ids .= '\'' . $value['categories'][$i] . '\', ';
}
$category_ids = substr($category_ids, 0, -2);

$check_query = xtc_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . $key . "' and categories_id not in (" . $category_ids . ")");
$check = xtc_db_fetch_array($check_query);
if ($check['total'] < '1') {
$products_delete[$key] = $key;
}
}

// Removing categories can be a lengthy process
@xtc_set_time_limit(0);
for ($i = 0, $n = sizeof($categories); $i < $n; $i++) {
xtc_remove_category($categories[$i]['id']);
}

reset($products_delete);
while (list($key) = each($products_delete)) {
xtc_remove_product($key);
}
}

xtc_redirect(xtc_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath));
break;
case 'delete_product_confirm':
if ( ($_POST['products_id']) && (is_array($_POST['product_categories'])) ) {
$product_id = xtc_db_prepare_input($_POST['products_id']);
$product_categories = $_POST['product_categories'];

for ($i = 0, $n = sizeof($product_categories); $i < $n; $i++) {
xtc_db_query("delete from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . xtc_db_input($product_id) . "' and categories_id = '" . xtc_db_input($product_categories[$i]) . "'");
}

$product_categories_query = xtc_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . xtc_db_input($product_id) . "'");
$product_categories = xtc_db_fetch_array($product_categories_query);

if ($product_categories['total'] == '0') {
xtc_remove_product($product_id);
}
}

xtc_redirect(xtc_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath));
break;
case 'move_category_confirm':
if ( ($_POST['categories_id']) && ($_POST['categories_id'] != $_POST['move_to_category_id']) ) {
$categories_id = xtc_db_prepare_input($_POST['categories_id']);
$new_parent_id = xtc_db_prepare_input($_POST['move_to_category_id']);
xtc_db_query("update " . TABLE_CATEGORIES . " set parent_id = '" . xtc_db_input($new_parent_id) . "', last_modified = now() where categories_id = '" . xtc_db_input($categories_id) . "'");
}

xtc_redirect(xtc_href_link(FILENAME_CATEGORIES, 'cPath=' . $new_parent_id . '&cID=' . $categories_id));
break;
case 'move_product_confirm':
$products_id = xtc_db_prepare_input($_POST['products_id']);
$new_parent_id = xtc_db_prepare_input($_POST['move_to_category_id']);

$duplicate_check_query = xtc_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . xtc_db_input($products_id) . "' and categories_id = '" . xtc_db_input($new_parent_id) . "'");
$duplicate_check = xtc_db_fetch_array($duplicate_check_query);
if ($duplicate_check['total'] < 1) xtc_db_query("update " . TABLE_PRODUCTS_TO_CATEGORIES . " set categories_id = '" . xtc_db_input($new_parent_id) . "' where products_id = '" . xtc_db_input($products_id) . "' and categories_id = '" . $current_category_id . "'");

xtc_redirect(xtc_href_link(FILENAME_CATEGORIES, 'cPath=' . $new_parent_id . '&pID=' . $products_id));
break;
case 'insert_product':
case 'update_product':
if (PRICE_IS_BRUTTO=='true' && $_POST['products_price']){
$_POST['products_price'] = ($_POST['products_price']/(xtc_get_tax_rate($_POST['products_tax_class_id'])+100)*100);
}
if ( ($_POST['edit_x']) || ($_POST['edit_y']) ) {
$_GET['action'] = 'new_product';
} else {
$products_id = xtc_db_prepare_input($_GET['pID']);
$products_date_available = xtc_db_prepare_input($_POST['products_date_available']);

$products_date_available = (date('Y-m-d') < $products_date_available) ? $products_date_available : 'null';

// set allowed c.groups
$group_ids='';
if(isset($_POST['groups'])) foreach($_POST['groups'] as $b){
$group_ids .= 'c_'.$b."_group ,";
}
$customers_statuses_array=xtc_get_customers_status es();
if (strstr($group_ids,'c_all_group')) {
$group_ids='c_all_group,';
for ($i=0;$n=sizeof($customers_statuses_array),$i<$n;$ i++) {
$group_ids .='c_'.$customers_statuses_array[$i]['id'].'_group,';
}
}

$sql_data_array = array('products_quantity' => xtc_db_prepare_input($_POST['products_quantity']),
'products_model' => xtc_db_prepare_input($_POST['products_model']),
'products_price' => xtc_db_prepare_input($_POST['products_price']),
'products_sort' => xtc_db_prepare_input($_POST['products_sort']),
'group_ids'=>$group_ids,
'products_shippingtime' => xtc_db_prepare_input($_POST['shipping_status']),
'products_discount_allowed' => xtc_db_prepare_input($_POST['products_discount_allowed']),
'products_date_available' => $products_date_available,
'products_weight' => xtc_db_prepare_input($_POST['products_weight']),
'products_status' => xtc_db_prepare_input($_POST['products_status']),
'products_tax_class_id' => xtc_db_prepare_input($_POST['products_tax_class_id']),
'product_template' => xtc_db_prepare_input($_POST['info_template']),
'options_template' => xtc_db_prepare_input($_POST['options_template']),
'manufacturers_id' => xtc_db_prepare_input($_POST['manufacturers_id']),
'products_fsk18' => xtc_db_prepare_input($_POST['fsk18']));
if (isset($_POST['products_image']) && xtc_not_null($_POST['products_image']) && ($_POST['products_image'] != 'none')) {
$sql_data_array['products_image'] = xtc_db_prepare_input($_POST['products_image']);
}

if ($_GET['action'] == 'insert_product') {
$insert_sql_data = array('products_date_added' => 'now()');
$sql_data_array = xtc_array_merge($sql_data_array, $insert_sql_data);
xtc_db_perform(TABLE_PRODUCTS, $sql_data_array);
$products_id = xtc_db_insert_id();
xtc_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . $products_id . "', '" . $current_category_id . "')");
} elseif ($_GET['action'] == 'update_product') {
$update_sql_data = array('products_last_modified' => 'now()');
$sql_data_array = xtc_array_merge($sql_data_array, $update_sql_data);
xtc_db_perform(TABLE_PRODUCTS, $sql_data_array, 'update', 'products_id = \'' . xtc_db_input($products_id) . '\'');
}

if ($products_image = new upload('products_image', DIR_FS_CATALOG_ORIGINAL_IMAGES, '777', '', true)) {
$products_image_name = $products_image->filename;
// ----------- Einf?gung Beginn --------------------------------------------- }
if( preg_match('/(^.*)\.(.*$)/', $products_image_name, $treffer) ) {
// $p_name=$treffer[1];
$p_ext =$treffer[2];
// $pn_name=strtolower($_POST['products_model']);
$pn_name=$products_id;

$pn_filename = $pn_name.".".$p_ext;
if( file_exists(DIR_FS_CATALOG_ORIGINAL_IMAGES.$pn_fil ename) ) {
unlink(DIR_FS_CATALOG_ORIGINAL_IMAGES.$pn_filename );
}
rename( DIR_FS_CATALOG_ORIGINAL_IMAGES.$products_image_nam e,
DIR_FS_CATALOG_ORIGINAL_IMAGES.$pn_filename);

xtc_db_query("update " . TABLE_PRODUCTS . " set products_image = '" . $pn_filename . "' where products_id = '" . (int)$products_id . "'");
$products_image_name=$pn_filename;
}
// ----------- Einf?gung Ende --------------------------------------------- }
$sql_data_array['products_image'] = xtc_db_prepare_input($products_image_name);

require(DIR_WS_INCLUDES . 'product_thumbnail_images.php');
require(DIR_WS_INCLUDES . 'product_info_images.php');
require(DIR_WS_INCLUDES . 'product_popup_images.php');

} else {
$products_image_name = $_POST['products_previous_image'];
}

$languages = xtc_get_languages();
// Here we go, lets write Group prices into db
// start
$i = 0;
$group_query = xtc_db_query("SELECT customers_status_id FROM " . TABLE_CUSTOMERS_STATUS . " WHERE language_id = '" . (int)$_SESSION['languages_id'] . "' AND customers_status_id != '0'");
while ($group_values = xtc_db_fetch_array($group_query)) {
// load data into array
$i++;
$group_data[$i] = array('STATUS_ID' => $group_values['customers_status_id']);
}
for ($col = 0, $n = sizeof($group_data); $col < $n+1; $col++) {
if ($group_data[$col]['STATUS_ID'] != '') {
$personal_price = xtc_db_prepare_input($_POST['products_price_' . $group_data[$col]['STATUS_ID']]);
if ($personal_price == '' or $personal_price=='0.0000') {
$personal_price = '0.00';
} else {
if (PRICE_IS_BRUTTO=='true'){
$personal_price= ($personal_price/(xtc_get_tax_rate($_POST['products_tax_class_id']) +100)*100);
}
$personal_price=xtc_round($personal_price,PRICE_PR ECISION);
}

xtc_db_query("UPDATE personal_offers_by_customers_status_" . $group_data[$col]['STATUS_ID'] . " SET personal_offer = '" . $personal_price . "' WHERE products_id = '" . $products_id . "' AND quantity = '1'");
}
}
// end
// ok, lets check write new staffelpreis into db (if there is one)
$i = 0;
$group_query = xtc_db_query("SELECT customers_status_id FROM " . TABLE_CUSTOMERS_STATUS . " WHERE language_id = '" . (int)$_SESSION['languages_id'] . "' AND customers_status_id != '0'");
while ($group_values = xtc_db_fetch_array($group_query)) {
// load data into array
$i++;
$group_data[$i]=array('STATUS_ID' => $group_values['customers_status_id']);
}
for ($col = 0, $n = sizeof($group_data); $col < $n+1; $col++) {
if ($group_data[$col]['STATUS_ID'] != '') {
$quantity = xtc_db_prepare_input($_POST['products_quantity_staffel_' . $group_data[$col]['STATUS_ID']]);
$staffelpreis = xtc_db_prepare_input($_POST['products_price_staffel_' . $group_data[$col]['STATUS_ID']]);
if (PRICE_IS_BRUTTO=='true'){
$staffelpreis= ($staffelpreis/(xtc_get_tax_rate($_POST['products_tax_class_id']) +100)*100);
}
$staffelpreis=xtc_round($staffelpreis,PRICE_PRECIS ION);

if ($staffelpreis!='' && $quantity!='') {

// ok, lets check entered data to get rid of user faults
if ($quantity<=1) $quantity=2;
$check_query=xtc_db_query("SELECT
quantity FROM
personal_offers_by_customers_status_" . $group_data[$col]['STATUS_ID'] . "
WHERE products_id='". $products_id."'
and quantity='".$quantity."'");
// dont insert if same qty!
if (xtc_db_num_rows($check_query)<1) {
xtc_db_query("INSERT INTO personal_offers_by_customers_status_" . $group_data[$col]['STATUS_ID'] . " (price_id, products_id, quantity, personal_offer) VALUES ('', '" . $products_id . "', '" . $quantity . "', '" . $staffelpreis . "')");
}
}
}
}
for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
$language_id = $languages[$i]['id'];
$sql_data_array = array('products_name' => xtc_db_prepare_input($_POST['products_name'][$language_id]),
'products_description' => xtc_db_prepare_input($_POST['products_description_'.$language_id]),
'products_short_description' => xtc_db_prepare_input($_POST['products_short_description_'.$language_id]),
'products_url' => xtc_db_prepare_input($_POST['products_url'][$language_id]),
'products_meta_title' => xtc_db_prepare_input($_POST['products_meta_title'][$language_id]),
'products_meta_description' => xtc_db_prepare_input($_POST['products_meta_description'][$language_id]),
'products_meta_keywords' => xtc_db_prepare_input($_POST['products_meta_keywords'][$language_id]));

if ($_GET['action'] == 'insert_product') {
$insert_sql_data = array('products_id' => $products_id,
'language_id' => $language_id);
$sql_data_array = xtc_array_merge($sql_data_array, $insert_sql_data);

xtc_db_perform(TABLE_PRODUCTS_DESCRIPTION, $sql_data_array);
} elseif ($_GET['action'] == 'update_product') {
xtc_db_perform(TABLE_PRODUCTS_DESCRIPTION, $sql_data_array, 'update', 'products_id = \'' . xtc_db_input($products_id) . '\' and language_id = \'' . $language_id . '\'');
}
}

xtc_redirect(xtc_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $products_id));
}
break;
case 'copy_to_confirm':

if(isset($_POST['cat_ids']) && $_POST['copy_as'] == 'link') {
$products_id = xtc_db_prepare_input($_POST['products_id']);

foreach($_POST['cat_ids'] as $key){
$check_query = xtc_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . $products_id . "' and categories_id = '" . $key . "'");
$check = xtc_db_fetch_array($check_query);
if ($check['total'] < '1') {
xtc_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . $products_id . "', '" . $key . "')");
} else {
$messageStack->add_session(ERROR_CANNOT_LINK_TO_SAME_CATEGORY, 'error');
}

}
break;
}
if ( (xtc_not_null($_POST['products_id'])) && (xtc_not_null($_POST['categories_id'])) ) {
$products_id = xtc_db_prepare_input($_POST['products_id']);

$categories_id = xtc_db_prepare_input($_POST['categories_id']);
if(isset($_POST['cat_ids'])) {
$cat_ids=$_POST['cat_ids'];
} else {
$cat_ids=array('0'=>$categories_id);
}

foreach($cat_ids as $key) {
$categories_id=$key;

if ($_POST['copy_as'] == 'link') {
if ($_POST['categories_id'] != $current_category_id) {
$check_query = xtc_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . xtc_db_input($products_id) . "' and categories_id = '" . xtc_db_input($categories_id) . "'");
$check = xtc_db_fetch_array($check_query);
if ($check['total'] < '1') {
xtc_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . xtc_db_input($products_id) . "', '" . xtc_db_input($categories_id) . "')");
}
} else {
$messageStack->add_session(ERROR_CANNOT_LINK_TO_SAME_CATEGORY, 'error');
}
} elseif ($_POST['copy_as'] == 'duplicate') {
$product_query = xtc_db_query("select
products_quantity,
products_model,
products_shippingtime,
group_ids,
products_sort,
products_image,
products_price,
products_discount_allowed,
products_date_available,
products_weight,
products_tax_class_id,
manufacturers_id,
product_template,
options_template,
products_fsk18
from " . TABLE_PRODUCTS . "
where products_id = '" . xtc_db_input($products_id) . "'");

$product = xtc_db_fetch_array($product_query);
xtc_db_query("insert into " . TABLE_PRODUCTS . "
(products_quantity,
products_model,
products_shippingtime,
group_ids,
products_sort,
products_image,
products_price,
products_discount_allowed,
products_date_added,
products_date_available,
products_weight,
products_status,
products_tax_class_id,
manufacturers_id,
product_template,
options_template,
products_fsk18)
values
('" . $product['products_quantity'] . "',
'" . $product['products_model'] . "',
'" . $product['products_shippingtime'] . "',
'" . $product['products_sort'] . "',
'" . $product['products_model'] . "',
'" . $product['products_image'] . "',
'" . $product['products_price'] . "',
'" . $product['products_discount_allowed'] . "',
now(),
'" . $product['products_date_available'] . "',
'" . $product['products_weight'] . "',
'0',
'" . $product['products_tax_class_id'] . "',
'" . $product['manufacturers_id'] . "',
'" . $product['product_template'] . "',
'" . $product['options_template'] . "',
'" . $product['products_fsk18'] . "'
)");

$dup_products_id = xtc_db_insert_id();

$description_query = xtc_db_query("select
language_id,
products_name,
products_description,
products_short_description,
products_meta_title,
products_meta_description,
products_meta_keywords,
products_url
from " . TABLE_PRODUCTS_DESCRIPTION . "
where products_id = '" . xtc_db_input($products_id) . "'");
$old_products_id=xtc_db_input($products_id);
while ($description = xtc_db_fetch_array($description_query)) {
xtc_db_query("insert into " . TABLE_PRODUCTS_DESCRIPTION . "
(products_id,
language_id,
products_name,
products_description,
products_short_description,
products_meta_title,
products_meta_description,
products_meta_keywords,
products_url,
products_viewed)
values (
'" . $dup_products_id . "',
'" . $description['language_id'] . "',
'" . addslashes($description['products_name']) . "',
'" . addslashes($description['products_description']) . "',
'" . addslashes($description['products_short_description']) . "',
'" . addslashes($description['products_meta_title']) . "',
'" . addslashes($description['products_meta_description']) . "',
'" . addslashes($description['products_meta_keywords']) . "',
'" . $description['products_url'] . "',
'0')");
}

xtc_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . $dup_products_id . "', '" . xtc_db_input($categories_id) . "')");

$products_id = $dup_products_id;
$i = 0;
$group_query = xtc_db_query("SELECT customers_status_id FROM " . TABLE_CUSTOMERS_STATUS . " WHERE language_id = '" . (int)$_SESSION['languages_id'] . "' AND customers_status_id != '0'");
while ($group_values = xtc_db_fetch_array($group_query)) {
// load data into array
$i++;
$group_data[$i]=array('STATUS_ID' => $group_values['customers_status_id']);
}
for ($col = 0, $n = sizeof($group_data); $col < $n+1; $col++) {
if ($group_data[$col]['STATUS_ID'] != '') {

$copy_query=xtc_db_query("SELECT
quantity,
personal_offer
FROM personal_offers_by_customers_status_" . $group_data[$col]['STATUS_ID'] . "
WHERE products_id='".$old_products_id."'");
while ($copy_data=xtc_db_fetch_array($copy_query)) {

xtc_db_query("INSERT INTO
personal_offers_by_customers_status_" . $group_data[$col]['STATUS_ID'] . "
(price_id, products_id, quantity, personal_offer)
VALUES ('', '" . $products_id . "', '" . $copy_data['quantity']. "', '" . $copy_data['personal_offer'] . "')");

}
}

}
}
}

}

xtc_redirect(xtc_href_link(FILENAME_CATEGORIES, 'cPath=' . $categories_id . '&pID=' . $products_id));
break;
}
}

// check if the catalog image directory exists
if (is_dir(DIR_FS_CATALOG_IMAGES)) {
if (!is_writeable(DIR_FS_CATALOG_IMAGES)) $messageStack->add(ERROR_CATALOG_IMAGE_DIRECTORY_NOT_WRITEABLE , 'error');
} else {
$messageStack->add(ERROR_CATALOG_IMAGE_DIRECTORY_DOES_NOT_EXIS T, 'error');
}
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Tra

Quoted post

Ape50 · #2 (**permalink**) 27.02.2006, 09:51

Hallo
Bekommt man hier ?berhaupt eine Hilfe. Ich habe dieses Shop zuf?llig bei euch gekauft.

Na ok wenn Ihr meint, n?chstes mal wird es halt doch ein anderer.

chpohl · #3 (**permalink**) 27.02.2006, 10:52

Zitat:

Bekommt man hier ?berhaupt eine Hilfe. Ich habe dieses Shop zuf?llig bei euch gekauft.

Na ok wenn Ihr meint, n?chstes mal wird es halt doch ein anderer.

bei uns gekauft?????????????

Meinst du, du hast den Sponsorenbeitrag bezahlt? Wenn ja, wann? Du bist noch kein Sponsor. Wenn du bezahlt hast und noch nicht freigeschaltet bist, schreib bitte eine Mail an office@xt-commerce.com, dann wird das ?berpr?ft.

Ansonsten: hier im offenen Forum findet kein Entwickler-/Mod.-Support statt. Hab diesen Beitrag eben auch nur durch Zufall gefunden.

Gru?,
Chris

Themen-Optionen
Druckbare Version zeigen Jemanden per E-Mail auf dieses Thema hinweisen
Ansicht
Linear-Darstellung Zur Hybrid-Darstellung wechseln Zur Baum-Darstellung wechseln