Product Attributes - Option Type Feature

1 of 1494   Next >   Last >>   The following osCommerce contribution is a free Opensource code originated from official osCommerce website and provided for your reference only, you may download the original contribution file(s) and install it on your own; or you may request a Paid Installation Service from Agents Of Power; Agents Of Power does the "AS IS" installation on your website, we do not guarantee it will work properly on your website. Extra Paid service is available for repairing the problem from the original contribution or from your website. I can't take credit for this but user sirspongey sent me his code that fixed this issue and it worked perfectly for me as well. I also noticed that the same issue was occurring in the confirmation emails that went out...the fix for that is listed below as well. In the paypal_standard.php file do the following: SEARCH FOR (at about line 245): $sql_data_array = array('orders_id' => $insert_id, 'orders_products_id' => $order_products_id, 'products_options' => $attr_name, 'products_options_values' => $order->products[$i]['attributes'][$j]['value'], 'options_values_price' => $attributes_values['options_values_price'], 'price_prefix' => $attributes_values['price_prefix']); tep_db_perform(TABLE_ORDERS_PRODUCTS_ATTRIBUTES, $sql_data_array); REPLACE WITH: // BOF Option Type Feature $attr_name = $attributes_values['products_options_name']; if ($attributes_values['products_options_id'] == PRODUCTS_OPTIONS_VALUE_TEXT_ID) { $attr_name_sql_raw = 'SELECT po.products_options_name FROM ' . TABLE_PRODUCTS_OPTIONS . ' po, ' . TABLE_PRODUCTS_ATTRIBUTES . ' pa WHERE ' . ' pa.products_id="' . tep_get_prid($order->products[$i]['id']) . '" AND ' . ' pa.options_id="' . $order->products[$i]['attributes'][$j]['option_id'] . '" AND ' . ' pa.options_id=po.products_options_id AND ' . ' po.language_id="' . $languages_id . '" '; $attr_name_sql = tep_db_query($attr_name_sql_raw); if ($arr = tep_db_fetch_array($attr_name_sql)) { $attr_name = $arr['products_options_name']; } } //EOF Option Type Feature $sql_data_array = array('orders_id' => $insert_id, 'orders_products_id' => $order_products_id, // BOF Option Type Feature //'products_options' => $attributes_values['products_options_name'], //'products_options_values' => $attributes_values['products_options_values_name'], 'products_options' => $attr_name, 'products_options_values' => $order->products[$i]['attributes'][$j]['value'], // EOF Option Type Feature 'options_values_price' => $attributes_values['options_values_price'], 'price_prefix' => $attributes_values['price_prefix']); tep_db_perform(TABLE_ORDERS_PRODUCTS_ATTRIBUTES, $sql_data_array); SEARCH FOR in the "before_process()" also in paypal_standard.php: $products_ordered_attributes .= "nt" . $attributes_values['products_options_name'] . ' ' . $attributes_values['products_options_values_name']; REPLACE WITH: //$products_ordered_attributes .= "nt" . $attributes_values['products_options_name'] . ' ' . $attributes_values['products_options_values_name']; $products_ordered_attributes .= "nt" . $attributes_values['products_options_name'] . ' ' . tep_decode_specialchars($order->products[$i]['attributes'][$j]['value']); No file contribution here... Just a note, that if downloading this module or the various "fixes", note that if you add a product with a text option to your cart, and subsequently add the same product with different text entered for the option, it will overwrite the first (as opposed creating a wholly new product, which is the expected behavior) Lors du rappel d'un article depuis le panier, la valeur des TEXTAREA ne s'affiche pas. Textarea zeigt den Wert nicht / Textarea doesn't show the value wenn ein Artikel vom shopping cart aufgerufen wird. Recalling an article from the shopping cart, the TEXTAREA value is not shown.    Posted on: 09/09/2008     See contribution details Request Installation with Paid service