strictlypc, thanks for your help.
But when you say, In admin\categories.php if you move "}" like your screencopy that fix the pb number 1:
1) In Admin - if I set it to "yes" and put some products to bundle with and hit preview/update. ONLY the yes gets saved, if i go back to edit the product, the bundles prod's are not there any more.
Im my case, it's not possible to acces a the menu categories of the admin and i ve got this error message:
Parse error: parse error, unexpected T_CASE in d:\web\easyphp1-7\www\catalog\admin\categories.php on line 440
my file admin\categories.php:
// update bundle contents
? ? if ($HTTP_POST_VARS['products_bundle'] = "yes") {
? ?tep_db_query("DELETE FROM products_bundles WHERE bundle_id = '" . $products_id . "'");
? ?
? ?for ($i=0, $n=6; $i<$n; $i++) {
? if (isset($HTTP_POST_VARS['subproduct_' . $i . '_qty']) && $HTTP_POST_VARS['subproduct_' . $i . '_qty'] > 0) {
? ? tep_db_query("INSERT INTO products_bundles (bundle_id, subproduct_id, subproduct_qty) VALUES ('" . $products_id . "', '" . $HTTP_POST_VARS['subproduct_' . $i . '_id'] . "', '" . $HTTP_POST_VARS['subproduct_' . $i . '_qty'] . "')");
? ?
? ? ?}
? ? ? }
? ? ? ? ? ?tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$products_id . "', '" . (int)$current_category_id . "')");
? ? ? ? ?} elseif ($action == 'update_product') {
? ? ? ? ? ?$update_sql_data = array('products_last_modified' => 'now()');
? ? ? ? ? ?$sql_data_array = array_merge($sql_data_array, $update_sql_data);
? ? ? ? ? ?tep_db_perform(TABLE_PRODUCTS, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "'");
? ? ? ? ?}
? ? ? ? ?$languages = tep_get_languages();
? ? ? ? ?for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
? ? ? ? ? ?$language_id = $languages[$i]['id'];
? ? ? ? ? ?$sql_data_array = array('products_name' => tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id]),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_description' => tep_db_prepare_input($HTTP_POST_VARS['products_description'][$language_id]),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_url' => tep_db_prepare_input($HTTP_POST_VARS['products_url'][$language_id]),
? ? ? ? 'products_head_title_tag' => tep_db_prepare_input($HTTP_POST_VARS['products_head_title_tag'][$language_id]),
? ? ? ? ? ? ? ?'products_head_desc_tag' => tep_db_prepare_input($HTTP_POST_VARS['products_head_desc_tag'][$language_id]),
? ? ? ? ? ? ? ?'products_head_keywords_tag' => tep_db_prepare_input($HTTP_POST_VARS['products_head_keywords_tag'][$language_id]));
? ? ? ? ? ?if ($action == 'insert_product') {
? ? ? ? ? ? ?$insert_sql_data = array('products_id' => $products_id,
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 'language_id' => $language_id);
? ? ? ? ? ? ?$sql_data_array = array_merge($sql_data_array, $insert_sql_data);
? ? ? ? ? ? ?tep_db_perform(TABLE_PRODUCTS_DESCRIPTION, $sql_data_array);
? ? ? ? ? ?} elseif ($action == 'update_product') {
? ? ? ? ? ? ?tep_db_perform(TABLE_PRODUCTS_DESCRIPTION, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "' and language_id = '" . (int)$language_id . "'");
? ? ? ? ? ?}
? ? ? ? ?}
? ? ? ? ?if (USE_CACHE == 'true') {
? ? ? ? ? ?tep_reset_cache_block('categories');
? ? ? ? ? ?tep_reset_cache_block('also_purchased');
? ? ? ? ?}
? ? ? ? ?tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $products_id));
? ? ? ?}
? ? ? ?break;
? ? ?case 'copy_to_confirm':
? ? ? ?if (isset($HTTP_POST_VARS['products_id']) && isset($HTTP_POST_VARS['categories_id'])) {
? ? ? ? ?$products_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']);
? ? ? ? ?$categories_id = tep_db_prepare_input($HTTP_POST_VARS['categories_id']);
? ? ? ? ?if ($HTTP_POST_VARS['copy_as'] == 'link') {
? ? ? ? ? ?if ($categories_id != $current_category_id) {
? ? ? ? ? ? ?$check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$products_id . "' and categories_id = '" . (int)$categories_id . "'");
? ? ? ? ? ? ?$check = tep_db_fetch_array($check_query);
? ? ? ? ? ? ?if ($check['total'] < '1') {
? ? ? ? ? ? ? ?tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$products_id . "', '" . (int)$categories_id . "')");
? ? ? ? ? ? ?}
? ? ? ? ? ?} else {
? ? ? ? ? ? ?$messageStack->add_session(ERROR_CANNOT_LINK_TO_SAME_CATEGORY, 'error');
? ? ? ? ? ?}
? ? ? ? ?} elseif ($HTTP_POST_VARS['copy_as'] == 'duplicate') {
? ? ? ? ? ?//PRODUCT_SORT_ORDER ADDED TO THIS SELECT
? ? ? ? ? ? $product_query = tep_db_query("select products_quantity, products_model, products_image, products_image_med, products_image_lrg, products_image_sm_1, products_image_xl_1, products_image_sm_2, products_image_xl_2, products_image_sm_3, products_image_xl_3, products_image_sm_4, products_image_xl_4, products_image_sm_5, products_image_xl_5, products_image_sm_6, products_image_xl_6, products_price, products_date_added, products_date_available, products_weight, products_tax_class_id, manufacturers_id, products_sort_order from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'");
? ?$product = tep_db_fetch_array($product_query);
? //PRODUCT_SORT_ORDER ADDED TO THIS INSERT
? ? ? ? ? ?tep_db_query("insert into " . TABLE_PRODUCTS . " (products_quantity, products_model, products_image, products_image_med, products_image_lrg, products_image_sm_1, products_image_xl_1, products_image_sm_2, products_image_xl_2, products_image_sm_3, products_image_xl_3, products_image_sm_4, products_image_xl_4, products_image_sm_5, products_image_xl_5, products_image_sm_6, products_image_xl_6, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_sort_order) values ('" . tep_db_input($product['products_quantity']) . "', '" . tep_db_input($product['products_model']) . "', '" . tep_db_input($product['products_image']) . "', '" . tep_db_input($product['products_image_med']) . "', '" . tep_db_input($product['products_image_lrg']) . "', '" . tep_db_input($product['products_image_sm_1']) . "', '" . tep_db_input($product['products_image_xl_1']) . "', '" . tep_db_input($product['products_image_sm_2']) . "',
? ? ? ? ? ? '" . tep_db_input($product['products_image_xl_2']) . "', '" . tep_db_input($product['products_image_sm_3']) . "', '" . tep_db_input($product['products_image_xl_3']) . "', '" . tep_db_input($product['products_image_sm_4']) . "', '" . tep_db_input($product['products_image_xl_4']) . "', '" . tep_db_input($product['products_image_sm_5']) . "', '" . tep_db_input($product['products_image_xl_5']) . "', '" . tep_db_input($product['products_image_sm_6']) . "', '" . tep_db_input($product['products_image_xl_6']) . "', '" . tep_db_input($product['products_price']) . "', ?now(), '" . tep_db_input($product['products_date_available']) . "', '" . tep_db_input($product['products_weight']) . "', '0', '" . (int)$product['products_tax_class_id'] . "', '" . (int)$product['manufacturers_id'] . "', '" . (int)$product['products_sort_order'] . "')");
? $dup_products_id = tep_db_insert_id();
? ? ? ? ? ?$description_query = tep_db_query("select language_id, products_name, products_description, products_head_title_tag, products_head_desc_tag, products_head_keywords_tag, products_url from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$products_id . "'");
? ? ? ? ? ?while ($description = tep_db_fetch_array($description_query)) {
? ? ? ? ? ? ?tep_db_query("insert into " . TABLE_PRODUCTS_DESCRIPTION . " (products_id, language_id, products_name, products_description, products_head_title_tag, products_head_desc_tag, products_head_keywords_tag, products_url, products_viewed) values ('" . (int)$dup_products_id . "', '" . (int)$description['language_id'] . "', '" . tep_db_input($description['products_name']) . "', '" . tep_db_input($description['products_description']) . "', '" . tep_db_input($description['products_head_title_tag']) . "', '" . tep_db_input($description['products_head_desc_tag']) . "', '" . tep_db_input($description['products_head_keywords_tag']) . "', '" . tep_db_input($description['products_url']) . "', '0')");
? ? ? ? ? ?} ? ?
? ? ? ? ? ?tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$dup_products_id . "', '" . (int)$categories_id . "')");
? ? ? ? ? ?$products_id = $dup_products_id;
? ? ? ? ?}
? ? ? ? ?if (USE_CACHE == 'true') {
? ? ? ? ? ?tep_reset_cache_block('categories');
? ? ? ? ? ?tep_reset_cache_block('also_purchased');
? ? ? ? ?}
? ? ? ?}
? ? ? ?tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $categories_id . '&pID=' . $products_id));
? ? ? ?break;
? ? ? ?
sorry for my english.