New 
Stevio
-
Posts
10 -
Joined
-
Last visited
Posts posted by Stevio
-
-
No such option in OSC ... TEXT field type is a part of another contribution.
Thx for answering, but I know and already post that in my other post. The problem is that the option type contribution doesnt work with this Ajax Attribute Manager. What i want to know, is this common or are there people who have this work?
-
First i want to say this contrib is awesome. It saves me a lot of time. :)
But I've got a little problem using the AJAX Attribute Manager. Can't add the TEXT field which is from the Option Type contribution. When trying to add a TEXT field to a product nothing happens? (the other standard attributes does work well)
Is this common? Or isnt it implented yet?
-
Thanks for all the help, much appreciated. Here the solution (thanx to zrxRaver Oscommerce.nl)
<?php /* $Id: box_invoice.php,v 5.5 2005/05/15 00:37:30 PopTheTop Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ class objectInfo { // class constructor function objectInfo($object_array) { reset($object_array); while (list($key, $value) = each($object_array)) { $this->$key = tep_db_prepare_input($value); } } } ?> <html> <head> <title><?php echo STORE_NAME; ?> <?php echo INVOICE_TEXT_INVOICE; ?> <?php echo INVOICE_TEXT_NUMBER_SIGN; ?><?php echo INVOICE_TEXT_CURRENT_YEAR; ?><?php echo INVOICE_TEXT_DASH; ?><?php echo $oID; ?></title> <link rel="stylesheet" type="text/css" href="<?php echo $ei_css_path; ?>stylesheet.css"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head> <body bgcolor="#FFFFFF" leftmargin=10 topmargin=10> <table width="600"> <tr> <td height="6" colspan="2"> </td> </tr> <tr> <td width="4"> </td> <td> <!-- START Top Header --> <table width=100% bgcolor="#FFFFFF" cellpadding="5" style="border-collapse: collapse" bordercolor="#EEEEEE" cellspacing="0" border="3"> <tr> <td width="100%"> <table width="100%"> <tr> <td align="left"><img src="http://www.ranonkel.com/catalog/admin/images/oscommerce.gif"></td> <TD ALIGN="right" VALIGN="top" NOWRAP> <FONT FACE="Arial" SIZE="2"><strong>Bestelnummer: <?php echo $oID; ?><BR> <?php echo $date; ?></strong></font><br><br><span class="pageHeadingSM"><FONT FACE="Arial" SIZE="1"><strong><?php echo nl2br(STORE_NAME_ADDRESS); ?></strong></font></span></TD> </tr> </table> </td> </tr> </table> <!-- END Top Header --> <!-- START INVOICE --> <table width=100% cellpadding="2" bgcolor="#248D43"> <tr class="dataTableHeadingRow"> <td bgcolor="#248D43"> <font face="Arial Black" size="3" color="#FFFFFF">Overzicht van uw bestelling</font></td> </tr> </table> <!-- END INVOICE --> <table width="100%" border="3" cellpadding="5" bordercolor="#EEEEEE" bgcolor="#FFFFFF" style="border-collapse: collapse"> <tr> <td width="50%" valign="top"> <!-- START Billing Info --> <table width="100%" border="0" cellspacing="0" cellpadding="0" class="main"> <tr> <td align="left" valign="top"><FONT FACE="Arial" SIZE="2" COLOR="#000000"><b><?php echo ENTRY_SOLD_TO; ?></b></font></td> </tr> <tr> <td> <img src="<?php echo $ei_image_dir; ?>pixel_trans.gif" width="1" height="5" alt=""></td> </tr> <tr> <td NOWRAP> <FONT FACE="Arial" SIZE="2" COLOR="#000000"><?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br> '); ?></font></td> </tr> <tr> <td> <img src="<?php echo $ei_image_dir; ?>pixel_trans.gif" width="1" height="10" alt=""></td> </tr> <tr> <td NOWRAP> <FONT FACE="Arial" SIZE="2" COLOR="#000000"><?php echo $order->customer['telephone']; ?></font></td> </tr> <tr> <td NOWRAP> <FONT FACE="Arial" SIZE="2" COLOR="#000000"><?php echo $order->customer['email_address']; ?></font></td> </tr> <tr> <td><img src="<?php echo $ei_image_dir; ?>pixel_trans.gif" width="1" height="7" alt=""></td> </tr> </table> <!-- END Billing Info --> </td> <td width="50%" valign="top"> <!-- START Shipping Info --> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main"> <tr> <td align="left" valign="top"><FONT FACE="Arial" SIZE="2" COLOR="#000000"><b><?php echo ENTRY_SHIP_TO; ?></b></font></td> </tr> <tr> <td> <img src="<?php echo $ei_image_dir; ?>pixel_trans.gif" width="1" height="5" alt=""></td> </tr> <tr> <td NOWRAP> <FONT FACE="Arial" SIZE="2" COLOR="#000000"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br> '); ?></font></td> </tr> <tr> <td> <img src="<?php echo $ei_image_dir; ?>pixel_trans.gif" width="1" height="10" alt=""></td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr> <tr> <td><img src="<?php echo $ei_image_dir; ?>pixel_trans.gif" width="1" height="7" alt=""></td> </tr> </table> <!-- END Shipping Info --> </td> </tr> </table> <!-- START Product Info --> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <td colspan="2" bgcolor="#248D43" class="dataTableHeadingContent"> <font color="#FFFFFF"><?php echo TABLE_HEADING_PRODUCTS; ?></font></td> <td align="right" bgcolor="#248D43" class="dataTableHeadingContent"><font color="#FFFFFF"><?php echo TABLE_HEADING_MODEL; ?></font></td> <td align="right" bgcolor="#248D43" class="dataTableHeadingContent"><font color="#FFFFFF"><?php echo TABLE_HEADING_TAX; ?></font></td> <td align="right" bgcolor="#248D43" class="dataTableHeadingContent"><font color="#FFFFFF"><?php echo TABLE_HEADING_UNIT_PRICE; ?></font></td> <TD ALIGN="right" bgcolor="#248D43" CLASS="dataTableHeadingContent"><font color="#FFFFFF"><?php echo TABLE_HEADING_TOTAL; ?></font> </TD> </tr> <?php for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) { echo ' <tr class="dataTableRow">' . "\n" . ' <td class="dataTableContent" valign="top" align="right">' . $order->products[$i]['qty'] . ' x</td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['name']; if (isset($order->products[$i]['attributes']) && (($k = sizeof($order->products[$i]['attributes'])) > 0)) { for ($j = 0; $j < $k; $j++) { echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value']; if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')'; echo '</i></small></nobr>'; } } // 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 = $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 echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n"; echo ' <td class="dataTableContent" align="right" valign="top">19%</td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n"; echo ' </tr>' . "\n"; } ?> <tr> <td colspan="5" align="right" bgcolor="#FFFFFF"> <table border="0" cellspacing="0" cellpadding="2"> <?php for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) { echo ' <tr>' . "\n" . ' <td align="right" class="smallText">' . $order->totals[$i]['title'] . '</td>' . "\n" . ' <td align="right" class="smallText">' . $order->totals[$i]['text'] . '</td>' . "\n" . ' </tr>' . "\n"; } ?> </table></td> </tr> </table> <!-- END Product Info --> <!-- START Customer Thank You and Order Link --> <table width="100%" border="3" cellpadding="5" bordercolor="#EEEEEE" bgcolor="#FFFFFF" style="border-collapse: collapse"> <tr> <td colspan="2" align="center"><br> <font size=2 face="Arial">Bedankt voor uw aankoop bij <?php echo STORE_NAME; ?><br> <br> <?php echo STORE_URL_ADDRESS; ?><br> <br> U kunt dit overzicht uitprinten voor uw eigen administratie.</font><br> <br></td> </tr> <!-- END Customer Thank You and Order Link --> </table> <!-- START Footer --> <table width=100% cellpadding="2"> <tr class="dataTableHeadingRow"> <td height="23" bgcolor="#248D43" class="dataTableHeadingContent"> <STRONG><FONT COLOR="#ffffff" size="2" face="Arial, Helvetica, sans-serif">Copyright ? 20<?php echo INVOICE_TEXT_CURRENT_YEAR; ?> <?php echo STORE_NAME; ?>, All Rights Reserved</FONT></STRONG></td> </tr> </table> <!-- END Footer --> </td> </tr> </table> </body> </html> -
Well i changed this:
$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");In:
$attr_q = tep_db_query("SELECT * FROM orders_text_attributes WHERE orders_id = $oID");The only problem now: all the attributes are the same under each product. Trying to fix this, but if ur able to help, saves me a lot of frustration :)
-
Has anyone resolved the Imprint contrib text attributes to confirmation email ?
Thanks,
Royal
I am also wondering how to fix this i tried to implent the code from the admin into the e-mail script but without succes.
This is what i have on the box_invoice:
<?php require('includes/application_top.php'); /* $Id: box_invoice.php,v 5.5 2005/05/15 00:37:30 PopTheTop Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ class objectInfo { // class constructor function objectInfo($object_array) { reset($object_array); while (list($key, $value) = each($object_array)) { $this->$key = tep_db_prepare_input($value); } } } ?> <html> <head> <title><?php echo STORE_NAME; ?> <?php echo INVOICE_TEXT_INVOICE; ?> <?php echo INVOICE_TEXT_NUMBER_SIGN; ?><?php echo INVOICE_TEXT_CURRENT_YEAR; ?><?php echo INVOICE_TEXT_DASH; ?><?php echo $oID; ?></title> <link rel="stylesheet" type="text/css" href="<?php echo $ei_css_path; ?>stylesheet.css"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head> <body bgcolor="#FFFFFF" leftmargin=10 topmargin=10> <table width="600"> <tr> <td height="6" colspan="2"> </td> </tr> <tr> <td width="4"> </td> <td> <!-- START Top Header --> <table width=100% bgcolor="#FFFFFF" cellpadding="5" style="border-collapse: collapse" bordercolor="#EEEEEE" cellspacing="0" border="3"> <tr> <td width="100%"> <table width="100%"> <tr> <td align="left"><img src="http://www.ranonkel.com/catalog/admin/images/oscommerce.gif"></td> <TD ALIGN="right" VALIGN="top" NOWRAP> <FONT FACE="Arial" SIZE="2"><strong>Bestelnummer: <?php echo $oID; ?><BR> <?php echo $date; ?></strong></font><br><br><span class="pageHeadingSM"><FONT FACE="Arial" SIZE="1"><strong><?php echo nl2br(STORE_NAME_ADDRESS); ?></strong></font></span></TD> </tr> </table> </td> </tr> </table> <!-- END Top Header --> <!-- START INVOICE --> <table width=100% cellpadding="2" bgcolor="#248D43"> <tr class="dataTableHeadingRow"> <td bgcolor="#248D43">?<font face="Arial Black" size="3" color="#FFFFFF">Overzicht van uw bestelling</font></td> </tr> </table> <!-- END INVOICE --> <table width="100%" border="3" cellpadding="5" bordercolor="#EEEEEE" bgcolor="#FFFFFF" style="border-collapse: collapse"> <tr> <td width="50%" valign="top"> <!-- START Billing Info --> <table width="100%" border="0" cellspacing="0" cellpadding="0" class="main"> <tr> <td align="left" valign="top"><FONT FACE="Arial" SIZE="2" COLOR="#000000"><b><?php echo ENTRY_SOLD_TO; ?></b></font></td> </tr> <tr> <td>????<img src="<?php echo $ei_image_dir; ?>pixel_trans.gif" width="1" height="5" alt=""></td> </tr> <tr> <td NOWRAP>????<FONT FACE="Arial" SIZE="2" COLOR="#000000"><?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>????'); ?></font></td> </tr> <tr> <td>????<img src="<?php echo $ei_image_dir; ?>pixel_trans.gif" width="1" height="10" alt=""></td> </tr> <tr> <td NOWRAP>????<FONT FACE="Arial" SIZE="2" COLOR="#000000"><?php echo $order->customer['telephone']; ?></font></td> </tr> <tr> <td NOWRAP>????<FONT FACE="Arial" SIZE="2" COLOR="#000000"><?php echo $order->customer['email_address']; ?></font></td> </tr> <tr> <td><img src="<?php echo $ei_image_dir; ?>pixel_trans.gif" width="1" height="7" alt=""></td> </tr> </table> <!-- END Billing Info --> </td> <td width="50%" valign="top"> <!-- START Shipping Info --> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main"> <tr> <td align="left" valign="top"><FONT FACE="Arial" SIZE="2" COLOR="#000000"><b><?php echo ENTRY_SHIP_TO; ?></b></font></td> </tr> <tr> <td>????<img src="<?php echo $ei_image_dir; ?>pixel_trans.gif" width="1" height="5" alt=""></td> </tr> <tr> <td NOWRAP>????<FONT FACE="Arial" SIZE="2" COLOR="#000000"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>????'); ?></font></td> </tr> <tr> <td>????<img src="<?php echo $ei_image_dir; ?>pixel_trans.gif" width="1" height="10" alt=""></td> </tr> <tr> <td>????</td> </tr> <tr> <td>????</td> </tr> <tr> <td><img src="<?php echo $ei_image_dir; ?>pixel_trans.gif" width="1" height="7" alt=""></td> </tr> </table> <!-- END Shipping Info --> </td> </tr> </table> <!-- START Product Info --> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <td colspan="2" bgcolor="#248D43" class="dataTableHeadingContent">?<font color="#FFFFFF"><?php echo TABLE_HEADING_PRODUCTS; ?></font></td> <td WIDTH="80" bgcolor="#248D43" class="dataTableHeadingContent"><font color="#FFFFFF"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></font></td> <td WIDTH="80" align="right" bgcolor="#248D43" class="dataTableHeadingContent"><font color="#FFFFFF"><?php echo TABLE_HEADING_UNIT_PRICE; ?></font></td> <TD WIDTH="80" ALIGN="right" bgcolor="#248D43" CLASS="dataTableHeadingContent"><font color="#FFFFFF"><?php echo TABLE_HEADING_TOTAL; ?></font>?</TD> </tr> <?php for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) { echo ' <tr class="dataTableRow">' . "\n" . ' <td class="dataTableContent" valign="top" align="right">' . $order->products[$i]['qty'] . '?x</td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['name']; if (isset($order->products[$i]['attributes']) && (($k = sizeof($order->products[$i]['attributes'])) > 0)) { for ($j = 0; $j < $k; $j++) { echo '<br><nobr><small>?<i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value']; if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')'; echo '</i></small></nobr>'; } } // 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 echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n"; echo ' <td class="dataTableContent" align="right" valign="top">19%</td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n"; echo ' </tr>' . "\n"; } ?> <tr> <td colspan="5" align="right" bgcolor="#FFFFFF"> <table border="0" cellspacing="0" cellpadding="2"> <?php for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) { echo ' <tr>' . "\n" . ' <td align="right" class="smallText">' . $order->totals[$i]['title'] . '</td>' . "\n" . ' <td align="right" class="smallText">' . $order->totals[$i]['text'] . '</td>' . "\n" . ' </tr>' . "\n"; } ?> </table></td> </tr> </table> <!-- END Product Info --> <!-- START Customer Thank You and Order Link --> <table width="100%" border="3" cellpadding="5" bordercolor="#EEEEEE" bgcolor="#FFFFFF" style="border-collapse: collapse"> <tr> <td colspan="2" align="center"><br> <font size=2 face="Arial">Bedankt voor uw aankoop bij <?php echo STORE_NAME; ?><br> <br> <?php echo STORE_URL_ADDRESS; ?><br> <br> U kunt dit overzicht uitprinten voor uw eigen administratie.</font><br> <br></td> </tr> <!-- END Customer Thank You and Order Link --> </table> <!-- START Footer --> <table width=100% cellpadding="2"> <tr class="dataTableHeadingRow"> <td height="23" bgcolor="#248D43" class="dataTableHeadingContent">?<STRONG><FONT COLOR="#ffffff" size="2" face="Arial, Helvetica, sans-serif">Copyright ? 20<?php echo INVOICE_TEXT_CURRENT_YEAR; ?> <?php echo STORE_NAME; ?>, All Rights Reserved</FONT></STRONG></td> </tr> </table> <!-- END Footer --> </td> </tr> </table> </body> </html>This is the error i get:
Fatal error: Cannot redeclare tep_db_connect() (previously declared in /home/blaat/domains/blaat.com/public_html/catalog/includes/functions/database.php:13) in /home/blaat/domains/blaat.com/public_html/catalog/includes/functions/database.php on line 13
If i remove the following line: require('includes/application_top.php');
I get the following error:
1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'and ota.products_id = 29 and pta.products_text_attributes_id = select ota.*, pta.products_text_attributes_name from orders_text_attributes as ota, products_text_attributes as pta where ota.orders_id = and ota.products_id = 29 and pta.products_text_attributes_id = ota.products_text_attributes_id
I hope someone is willing to help. Thanx in advance
Option Type Feature v1.6 (for osc 2.2 MS2)
in General Add-Ons Support
Posted
I've got a little problem using the Option Type Module with the AJAX Attribute Manager. Can't add the TEXT field which is from the Option Type contribution. When trying to add a TEXT field to a product nothing happens? (the other standard attributes does work well)
My question are more people running in this problem? Is this common? Or isnt it implented yet?