Jump to content

ttieben

Members
  • Content count

    3
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Tanner
  1. ttieben

    Imprint Text Options

    Okay. This code is what worked for me. I used this same code in orders.php, invoice.php and packingslip.php. My text shows in all of them. // denuz text attr $pid = @mysql_result(tep_db_query("select products_id from products_description where products_name='" . tep_db_input($order->products[$i]['name']) . "'"), 0, "products_id"); $attr_q = tep_db_query("select ota.*, pta.products_text_attributes_name from orders_text_attributes as ota, products_text_attributes as pta where ota.orders_id = " . $HTTP_GET_VARS['oID'] . " and ota.products_id = " . $pid . " and pta.products_text_attributes_id = ota.products_text_attributes_id"); while ($attr = tep_db_fetch_array($attr_q)) { echo '<br><nobr><small> <i> - ' . $attr['products_text_attributes_name'] . ': ' . stripslashes($attr['products_text_attributes_text']); echo '</i></small></nobr>'; } // eof denuz text attr
  2. ttieben

    Imprint Text Options

    Okay. So I was successful in getting it to email me the order with the text attributes. Here is the code I used around line 246 in my checkout_process.php: // denuz_arun text attr $pid = @mysql_result(tep_db_query("select products_id from products_description where products_name='" . tep_db_input($order->products[$i]['name']) . "'"), 0, "products_id"); $denux_arunQry = "select ota.*, pta.products_text_attributes_name from orders_text_attributes as ota, products_text_attributes as pta where ota.orders_id = " . $insert_id. //$HTTP_GET_VARS['oID'] . " and ota.products_id = " . $pid . " and pta.products_text_attributes_id = ota.products_text_attributes_id"; //echo ; $attr_q = tep_db_query($denux_arunQry); $denux_arun_ =''; while ($attr = tep_db_fetch_array($attr_q)) { $denux_arun_ .= $attr['products_text_attributes_name'] . ': ' . stripslashes($attr['products_text_attributes_text'])."\n"; } // eof denuz_arun text attr //------insert customer choosen option eof ---- $products_ordered .= $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name'] . ' (' . $order->products[$i]['model'] . ') = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . $products_ordered_attributes . "\n". $denux_arun_ . "\n"; } Although next, I have to work on the orders.php and the invoice.php and get the text attribute to show there. If anyone has done this successfully, please send me your code. Thanks.
  3. ttieben

    Imprint Text Options

    I'm in the same boat as: mrengland79. I have almost everything working with this addon. I am using OSC 2.3.3 and I also can't get the text attributes to come through in the order email, or the invoice. Any suggestions would be helpful. Thanks.
×