Hallo, ich habe den Fehler behoben. Ich habe keine Ahnung wie das passiert ist, jedoch fehlten in meiner "/admin/includes/classes/categories.php" ganze Zeilenblöcke die den Fehler verursachten!
Mir half mal jemand eine änderung am shop durchzuführen, ansonsten wüsste ich nicht wie es dazu kommen konnte!?
Ich Danke Dir herzlich. Werde in Zukunft niemanden mehr an den Shop lassen!
Ab Zeile 165 fehlt der Block für die DB-Einträge
[code=php]<?php
/* --------------------------------------------------------------
$Id: categories.php 1318 2005-10-21 19:40:59Z mz $
XT-Commerce - community made shopping
http://www.(( Wir dulden keine kommerziellen Werbelinks - Bitte Forenregeln beachten! ))
Copyright (c) 2003 XT-Commerce
--------------------------------------------------------------
based on:
(c) 2000-2001 The Exchange Project (earlier name of osCommerce)
(c) 2002-2003 osCommerce(categories.php,v 1.140 2003/03/24);
www.oscommerce.com (c) 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 (c) 2002-2003 Copyright Elari elari@free.fr |
www.unlockgsm.com/dload-osc/ | CVS :
http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/elari/?sortby=date#dirlist Released under the GNU General Public License
--------------------------------------------------------------
--------------------------------------------------------------
"xtc Keep Image Names v1" - Version 1 vom 18. Juli 2007
Einige Änderungen, um die Dateinamen der hochgeladenen Bilder
nicht komplett zu verlieren.
- Sonderzeichen im ursprünglichen Bildnamen werden gewandelt
- Die Kennzeichnung durch "ID plus Unterstrich" bleibt
- Beim Kopieren von Artikeln und Kategorien werden die neuen
Bilder wie gewohnt ausschließlich aus der "ID" gebildet
--------------------------------------------------------------
Die geänderten Zeilen und die neu hinzugefügten Funktionen
sind durch Kommentarmarken "//GUNNART" gekennzeichnet.
Bitte nicht sofort auf einem Live-System ausprobieren!
Weitere Infos:
http://www.gunnart.de/?p=324 --------------------------------------------------------------
*/
// ----------------------------------------------------------------------------------------------------- //
function unArrayCleanImgName($Input) { //GUNNART
$Count = 0;
while ( $Count < count($Input) ) {
$Name .= cleanImgName($Input[$Count]);
$Count++;
}
return $Name;
}
function cleanImgName($Name){ //GUNNART
$Name = htmlentities($Name, ENT_QUOTES);
$Name = preg_replace("/(&([AaOoUu])[^;]*
/",'$2e',$Name);
$Name = preg_replace("/(&([Ss])[^;]*
/",'$2$2',$Name);
$Name = preg_replace("/(&([CcIiZzEeNn])[^;]*
/",'$2',$Name);
$Name = preg_replace("/(&[^;]*
/",'',$Name);
return preg_replace("/([^0-9a-zA-Z])/",'_',$Name);
}
// holds functions for manipulating products & categories
defined('_VALID_XTC') or die('Direct Access to this location is not allowed.');
class categories {
// ----------------------------------------------------------------------------------------------------- //
// deletes an array of categories, with products
// makes use of remove_category, remove_product
function remove_categories($category_id) {
$categories = xtc_get_category_tree($category_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 ++) {
$this->remove_category($categories[$i]['id']);
}
reset($products_delete);
while (list ($key) = each($products_delete)) {
$this->remove_product($key);
}
} // remove_categories ends
// ----------------------------------------------------------------------------------------------------- //
// deletes a single category, without products
function remove_category($category_id) {
$category_image_query = xtc_db_query("SELECT categories_image FROM ".TABLE_CATEGORIES." WHERE categories_id = '".xtc_db_input($category_id)."'");
$category_image = xtc_db_fetch_array($category_image_query);
$duplicate_image_query = xtc_db_query("SELECT count(*) AS total FROM ".TABLE_CATEGORIES." WHERE categories_image = '".xtc_db_input($category_image['categories_image'])."'");
$duplicate_image = xtc_db_fetch_array($duplicate_image_query);
if ($duplicate_image['total'] < 2) {
if (file_exists(DIR_FS_CATALOG_IMAGES.'categories/'.$category_image['categories_image'])) {
@ unlink(DIR_FS_CATALOG_IMAGES.'categories/'.$category_image['categories_image']);
}
}
xtc_db_query("DELETE FROM ".TABLE_CATEGORIES." WHERE categories_id = '".xtc_db_input($category_id)."'");
xtc_db_query("DELETE FROM ".TABLE_CATEGORIES_DESCRIPTION." WHERE categories_id = '".xtc_db_input($category_id)."'");
xtc_db_query("DELETE FROM ".TABLE_PRODUCTS_TO_CATEGORIES." WHERE categories_id = '".xtc_db_input($category_id)."'");
if (USE_CACHE == 'true') {
xtc_reset_cache_block('categories');
xtc_reset_cache_block('also_purchased');
}
} // remove_category ends
// ----------------------------------------------------------------------------------------------------- //
// inserts / updates a category from given $categories_data array
// Needed fields: id, sort_order, status, array(groups), products_sorting, products_sorting2, category_template,
// listing_template, previous_image, array[name][lang_id], array[heading_title][lang_id], array[description][lang_id],
// array[meta_title][lang_id], array[meta_description][lang_id], array[meta_keywords][lang_id]
function insert_category($categories_data, $dest_category_id, $action = 'insert') {
$categories_id = xtc_db_prepare_input($categories_data['categories_id']);
$sort_order = xtc_db_prepare_input($categories_data['sort_order']);
$categories_status = xtc_db_prepare_input($categories_data['status']);
$customers_statuses_array = xtc_get_customers_statuses();
$permission = array ();
for ($i = 0; $n = sizeof($customers_statuses_array), $i < $n; $i ++) {
if (isset($customers_statuses_array[$i]['id']))
$permission[$customers_statuses_array[$i]['id']] = 0;
}
if (isset ($categories_data['groups']))
foreach ($categories_data['groups'] AS $dummy => $b) {
$permission[$b] = 1;
}
// build array
if ($permission['all']==1) {
$permission = array ();
end($customers_statuses_array);
for ($i = 0; $n = key($customers_statuses_array), $i < $n+1; $i ++) {
if (isset($customers_statuses_array[$i]['id']))
$permission[$customers_statuses_array[$i]['id']] = 1;
}
}
$permission_array = array ();
// set pointer to last key
end($customers_statuses_array);
for ($i = 0; $n = key($customers_statuses_array), $i < $n+1; $i ++) {
if (isset($customers_statuses_array[$i]['id'])) {
$permission_array = array_merge($permission_array, array ('group_permission_'.$customers_statuses_array[$i]['id'] => $permission[$customers_statuses_array[$i]['id']]));
}
}
$sql_data_array = array ('sort_order' => $sort_order, 'categories_status' => $categories_status, 'products_sorting' => xtc_db_prepare_input($categories_data['products_sorting']), 'products_sorting2' => xtc_db_prepare_input($categories_data['products_sorting2']), 'categories_template' => xtc_db_prepare_input($categories_data['categories_template']), 'listing_template' => xtc_db_prepare_input($categories_data['listing_template']));
$sql_data_array = array_merge($sql_data_array,$permission_array);
if ($action == 'insert') {
$insert_sql_data = array ('parent_id' => $dest_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 ($action == 'update') {
$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, $
