Jump to content

Stevio

Members
  • Content count

    10
  • Joined

  • Last visited

  1. 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?
  2. Stevio

    AJAX Attribute Manager support

    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?
  3. Stevio

    AJAX Attribute Manager support

    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?
  4. Stevio

    Imprint to confirmation email

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

    Imprint to confirmation email

    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 :)
  6. Stevio

    Imprint to confirmation email

    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
×