Hallo MrWhite,
hab mir Deine Erweiterung in den Testshop eingebaut - zuerst die im 1. Beitrag verlinkte V1.6 um dann festzustellen, daß das mit SP1c eine Fehlermeldung gibt beim Attribut öffnen.
Nochmal gesucht und auch die Lösung hier gefunden und entdeckt, daß es in einer V1.7 bereits gelöst ist.
Danke für Deine tolle Erweiterung.
Jetzt hab ich aber ein größeres Problem. Die admin/products_attributes.php wo ja so ab ca. Zeile 33 bis 138 der entsprechende Teil auskommentiert worden ist.
Ich bin gerade dabei etwas einzubauen, wo ich aber in dem auskommentierten Teil etwas ändern muß. Bin drauf gekommen, daß der auskommentierte Teil in abgeänderter Form in der products_attributes_action.php wieder zu finden ist.
Und da hänge ich nun fest. Könntest Du mir da bitte weiterhelfen? Es geht um diesen Teil (normalerweise admin/products_attributes.php ca. Zeile 49):
$option_name = $_POST['option_name']; for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { xtc_db_query
("insert into " . TABLE_PRODUCTS_OPTIONS
. " (products_options_id, products_options_sortorder, products_options_name, language_id) values ('" . $_POST['products_options_id'] . "', '" . $_POST['products_options_sortorder'] . "', '" . $option_name[$languages[$i]['id']] . "', '" . $languages[$i]['id'] . "')"); der gegen
$option_name = $_POST['option_name']; $description = $_POST['description']; for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { xtc_db_query
("insert into " . TABLE_PRODUCTS_OPTIONS
. " (products_options_id, products_options_sortorder, products_options_name, description, language_id, multiselect, mengenfeld) values ('" . $_POST['products_options_id'] . "', '" . $_POST['products_options_sortorder'] . "', '" . addslashes($option_name[$languages[$i]['id']]) . "', '" . addslashes($description[$languages[$i]['id']]) . "', '" . $languages[$i]['id'] . "', '" . $_POST['multiselect'] . "', '" . $_POST['mengenfeld'] . "')"); if ($new_image = & xtc_try_upload
('image_'.$languages[$i]['id'], DIR_FS_CATALOG_IMAGES
.'options/')) { $cname_arr = explode('.', $new_image->filename); $cnsuffix = array_pop($cname_arr); $new_image_name = $_POST['products_options_id'].'_'.$languages[$i]['id'].'.'.$cnsuffix; @ unlink(DIR_FS_CATALOG_IMAGES
.'options/'.$new_image_name); rename(DIR_FS_CATALOG_IMAGES
.'options/'.$new_image->filename, DIR_FS_CATALOG_IMAGES
.'options/'.$new_image_name); xtc_db_query
("UPDATE ".TABLE_PRODUCTS_OPTIONS
."
SET image = '".xtc_db_input
($new_image_name)."'
WHERE products_options_id = '".$_POST['products_options_id']."' and language_id = '" . $languages[$i]['id'] . "'"); } ersetzt werden soll und gleiche Datei nochmal ca. Zeile 70:
xtc_db_query("insert into " . TABLE_PRODUCTS_OPTIONS_VALUES . " (products_options_values_id, language_id, products_options_values_name) values ('" . $_POST['value_id'] . "', '" . $languages[$i]['id'] . "', '" . $value_name[$languages[$i]['id']] . "')");
gegen
$description = $_POST['description']; if ($_POST['is_product']==1){ xtc_db_query
("insert into " . TABLE_PRODUCTS_OPTIONS_VALUES
. " (products_options_values_id, language_id, products_options_values_name, description, is_product) values ('" . $_POST['value_id'] . "', '" . $languages[$i]['id'] . "', '" . addslashes($value_name[$languages[$i]['id']]) . "', '" . addslashes($description[$languages[$i]['id']]) . "' ,'".str_replace('prod_','',$_POST['prod_as_attr'])."')"); }else{ xtc_db_query
("insert into " . TABLE_PRODUCTS_OPTIONS_VALUES
. " (products_options_values_id, language_id, products_options_values_name, description) values ('" . $_POST['value_id'] . "', '" . $languages[$i]['id'] . "', '" . addslashes($value_name[$languages[$i]['id']]) . "', '" . addslashes($description[$languages[$i]['id']]) . "')"); } if ($new_image = & xtc_try_upload
('image_'.$languages[$i]['id'], DIR_FS_CATALOG_IMAGES
.'options_values/original_images/')) { $cname_arr = explode('.', $new_image->filename); $cnsuffix = array_pop($cname_arr); $new_image_name = $_POST['value_id'].'_'.$languages[$i]['id'].'.'.$cnsuffix; @ unlink(DIR_FS_CATALOG_IMAGES
.'options_values/original_images/'.$new_image_name); rename(DIR_FS_CATALOG_IMAGES
.'options_values/original_images/'.$new_image->filename, DIR_FS_CATALOG_IMAGES
.'options_values/original_images/'.$new_image_name); xtc_db_query
("UPDATE ".TABLE_PRODUCTS_OPTIONS_VALUES
."
SET image = '".xtc_db_input
($new_image_name)."'
WHERE products_options_values_id = '".$_POST['value_id']."' and language_id = '" . $languages[$i]['id'] . "'"); require (DIR_WS_INCLUDES
.'product_thumbnail_ov_images.php'); require (DIR_WS_INCLUDES
.'product_info_ov_images.php'); require (DIR_WS_INCLUDES
.'product_popup_ov_images.php'); } und nochmal in der gleichen Datei Zeile 111:
//BOF - web28 - 2010-07-11 - BUGFIX no entry stored for previous deactivated languages $products_options_query = xtc_db_query
("select * from ".TABLE_PRODUCTS_OPTIONS
." where language_id = '".$languages[$i]['id']."' and products_options_id = '".$_POST['option_id']."'"); if (xtc_db_num_rows
($products_options_query) == 0) xtc_db_perform
(TABLE_PRODUCTS_OPTIONS
, array ('products_options_id' => $_POST['option_id'], 'language_id' => $languages[$i]['id'])); //EOF - web28 - 2010-07-11 - BUGFIX no entry stored for previous deactivated languages xtc_db_query
("update " . TABLE_PRODUCTS_OPTIONS
. " set products_options_name = '" . $option_name[$languages[$i]['id']] . "', products_options_sortorder = '" . $_POST['products_options_sortorder'] . "' where products_options_id = '" . $_POST['option_id'] . "' and language_id = '" . $languages[$i]['id'] . "'"); gegen
$description = $_POST['description']; xtc_db_query
("update " . TABLE_PRODUCTS_OPTIONS
. " set mengenfeld = '" . $_POST['mengenfeld'] . "', multiselect = '" . $_POST['multiselect'] . "', products_options_name = '" . $option_name[$languages[$i]['id']] . "', description = '" . $description[$languages[$i]['id']] . "', products_options_sortorder = '" . $_POST['products_options_sortorder'] . "' where products_options_id = '" . $_POST['option_id'] . "' and language_id = '" . $languages[$i]['id'] . "'"); if ($new_image = & xtc_try_upload
('image_'.$languages[$i]['id'], DIR_FS_CATALOG_IMAGES
.'options/')) { $cname_arr = explode('.', $new_image->filename); $cnsuffix = array_pop($cname_arr); $new_image_name = $_POST['option_id'].'_'.$languages[$i]['id'].'.'.$cnsuffix; @ unlink(DIR_FS_CATALOG_IMAGES
.'options/'.$new_image_name); rename(DIR_FS_CATALOG_IMAGES
.'options/'.$new_image->filename, DIR_FS_CATALOG_IMAGES
.'options/'.$new_image_name); xtc_db_query
("UPDATE ".TABLE_PRODUCTS_OPTIONS
."
SET image = '".xtc_db_input
($new_image_name)."'
WHERE products_options_id = '".$_POST['option_id']."' and language_id = '" . $languages[$i]['id'] . "'"); } und nochmal Zeile 128:
$value_name = $_POST['value_name']; for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { //BOF - web28 - 2010-07-11 - BUGFIX no entry stored for previous deactivated languages $products_options_values_query = xtc_db_query
("select * from ".TABLE_PRODUCTS_OPTIONS_VALUES
." where language_id = '".$languages[$i]['id']."' and products_options_values_id = '".$_POST['value_id']."'"); if (xtc_db_num_rows
($products_options_values_query) == 0) xtc_db_perform
(TABLE_PRODUCTS_OPTIONS_VALUES
, array ('products_options_values_id' => $_POST['value_id'], 'language_id' => $languages[$i]['id'])); //EOF - web28 - 2010-07-11 - BUGFIX no entry stored for previous deactivated languages xtc_db_query
("update " . TABLE_PRODUCTS_OPTIONS_VALUES
. " set products_options_values_name = '" . $value_name[$languages[$i]['id']] . "' where products_options_values_id = '" . $_POST['value_id'] . "' and language_id = '" . $languages[$i]['id'] . "'"); gegen
$value_name = $_POST['value_name']; $description = $_POST['description']; for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { xtc_db_query
("update " . TABLE_PRODUCTS_OPTIONS_VALUES
. " set products_options_values_name = '" . $value_name[$languages[$i]['id']] . "', description = '" . $description[$languages[$i]['id']] . "' where products_options_values_id = '" . $_POST['value_id'] . "' and language_id = '" . $languages[$i]['id'] . "'"); if ($new_image = & xtc_try_upload
('image_'.$languages[$i]['id'], DIR_FS_CATALOG_IMAGES
.'options_values/original_images/')) { $cname_arr = explode('.', $new_image->filename); $cnsuffix = array_pop($cname_arr); $new_image_name = $_POST['value_id'].'_'.$languages[$i]['id'].'.'.$cnsuffix; @ unlink(DIR_FS_CATALOG_IMAGES
.'options_values/original_images/'.$new_image_name); rename(DIR_FS_CATALOG_IMAGES
.'options_values/original_images/'.$new_image->filename, DIR_FS_CATALOG_IMAGES
.'options_values/original_images/'.$new_image_name); xtc_db_query
("UPDATE ".TABLE_PRODUCTS_OPTIONS_VALUES
."
SET image = '".xtc_db_input
($new_image_name)."'
WHERE products_options_values_id = '".$_POST['value_id']."' and language_id = '" . $languages[$i]['id'] . "'"); require (DIR_WS_INCLUDES
.'product_thumbnail_ov_images.php'); require (DIR_WS_INCLUDES
.'product_info_ov_images.php'); require (DIR_WS_INCLUDES
.'product_popup_ov_images.php'); } Vielleicht kannst Du mir da helfen?
Danke
Gerd