Jump to content
dev osCommerce
Forum
  • Checkout
  • Login
  • Contact Us
  • Get in touch

osCommerce

The e-commerce.

New Demo
Our Partners

whaou

Archived
 View Profile  See their activity

  • Posts

    19

  • Joined

  • Last visited

 Content Type 

Posts posted by whaou

    YASU

    in General Add-Ons Support

    Posted

    I try to find a solution for the same problem that Ludo:

     

    Hello,

     

    i don't understand how to make the modifications to change '+' --> '-'

     

    I would like to make modification to change all ' ?, ?, ?, ? ....' --> 'e, e, u, a ....' and all ",' ... to --> space

     

    Thanks

     

    Ludo

     

    :huh:

     

    somebody have a id?e ?

    pollbooth_v2.1

    in General Add-Ons Support

    Posted

    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

    Bundled products

    in General Add-Ons Support

    Posted

    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: :(

    Bundled products

    in General Add-Ons Support

    Posted · Edited by whaou

    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.

    Bundled products

    in General Add-Ons Support

    Posted

    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 !

    Bundled products

    in General Add-Ons Support

    Posted

    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...