Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

whaou

Archived
  • Posts

    19
  • Joined

  • Last visited

Profile Information

  • Real Name
    whaou75

whaou's Achievements

  1. excuse me, why anybody forward a new contributions of Bundle (ex Bundle 1.1 WITH ALL FIXES) on this url: OSC/Contributions ? Because, the fixes are not easy to apply for a newbie :blush:
  2. I try to find a solution for the same problem that Ludo: :huh: somebody have a id?e ?
  3. i ve got the same pb that Toddw, it' impossible to contact the author Matt Fletcher, there isn't his e-mail in the install.txt ;)
  4. Sorry, But where do you do the corrections (about the fix of Monk) ? in which file ?
  5. Hi, I install the contribution pollbooth_v2.1, i read all the topics for the diff?rents bugs and corrections. But i have got a bug whith this contribution: When a use the default languague on my e-shop, and when i read the results of the polls, there aren't any problems. But when i chose an other languagues, when i vote, the result of the polls are wrong, not equal at 100% !!! :angry: Do you know the correction which i must make ??? NB: sorry for my english
  6. Thanks for your help strictlypc, I did the correction, i didn't saw the " }" above // update bundle contents ;) But after the correction, when i do in my back office a preview of an item and an update, i saw the same error message that jhdesign: 1062 - Duplicata du champ '45-21' pour la clef 1 insert into products_to_categories (products_id, categories_id) values ('45', '21') [TEP STOP] :unsure: :(
  7. 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.
  8. Thanks for your help, but i think, that i should wait an update of this contribution <_< Because, i'm not very strong with php. And this contibution doesn't function perfectly. chers fred
  9. Why this contribution seams to function with scrapart and it's impossible for me to use this contribution :blink: I try to change in my database tinytext by tinyint but i've got the same pb: when i fill the fields of the bundle wthit the drop zone menu and i do preview then update. When i come back in the card-index product, the fields with the items that compose the bundle, don't exist any more lushlongboards use this contrib on his website without any problems !
  10. i have got a pb whith this contribution, when i fill the fields of the bundle wthit the drop zone menu and i do preview then update. When i come back in the card-index product, the fields with the items that compose the bundle, don't exist any more ?? :(
×
×
  • Create New...