Help Text Area Field

[fraternalawards]

ok i installed text field module and it seems ok but it wont go into the sale area and wont email to me.That is the info entered in text field wont email with the other info something is not right.If anyone you could please check it out I would be greatful.

www.fraternalawards.com and go to: name badges and then buy one and it eill bring you to the area where the text field is and you can enter info in it and go to next page all info will carry over to this page and then when you go to checkout it seems to get lost.seems to be a database error of some sort.I would appreiate the help thank you

[Guest]

not a database error, your missing an addition in your code.

 

i can't remeber the exact files but it is the 3(one is shopping_cart.php) that are in the catalog folder for this mod, but the variables $option and $value need to be $option_id and $value_id. Compare the original files included in this mod with the modified files to pick out these changes.

 

          //CLR 020607 determine if attribute is a text attribute

         $text_attribute = ($value_id == PRODUCTS_OPTIONS_VALUE_TEXT_ID);



         $attributes = tep_db_query("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix

                                     from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa

                                     where pa.products_id = '" . $products[$i]['id'] . "'

                                      and pa.options_id = '" . $option_id . "'

                                      and pa.options_id = popt.products_options_id

                                      and pa.options_values_id = '" . $value_id . "'

                                      and pa.options_values_id = poval.products_options_values_id

                                      and popt.language_id = '" . $languages_id . "'

                                      and poval.language_id = '" . $languages_id . "'");

         $attributes_values = tep_db_fetch_array($attributes);

 

 

barry

[Guest]

I meant to add in that post that the code quoted is from shopping_cart.php and shows the 2 variables mentioned changed to allow the mod to work properly.

 

cheers

barry

[fraternalawards]

well it seems tobe working it gets to me in the email but i cant seem to add another line what i mean is can i have like for lines?Seems like it should work but it doesnt come up