Jump to content

Jet200

Members
  • Content count

    106
  • Joined

  • Last visited

  • Days Won

    1

Jet200 last won the day on February 5 2010

Jet200 had the most liked content!

Profile Information

  • Real Name
    Mark Houghton
  1. I was having a similar problem. I can't explain what the numbers mean, but I do know that your code change worked and now my dates are correct. Thanks!
  2. Jet200

    News Blog V1.0

    Can anyone tell me why my layout looks like this? http://jet200.com/catalog/news.php Every news page appears in a small right hand column. Where do I look to sort out what needs to change. I can only assume there are some extra tables in the code or table properties that do not need to be there.
  3. Jet200

    PayLeap

    Anyone using this service and module? Did a search but have come up empty. I would appreciate any and all feedback. Thanks http://www.payleap.com/merchants-account-services.html
  4. Jet200

    Products Location add-on

    Ugh. What line of code controls the input?
  5. Jet200

    Products Location add-on

    It only displays the first character. If I then go into the db and edit, it will display the full number. For some reason it's only capturing that first character when entered on the categories page.
  6. Jet200

    Products Location add-on

    table:products_description products_id int(11) language_id int(11) products_name varchar(64) products_url varchar(255) products_viewed int(5) products_locate varchar(30) it lets me enter however many i want, but only stores the first character in the db
  7. Jet200

    Products Location add-on

    it's definitely limiting the input. not sure where to address this - categories.php - which part of the code defines this?
  8. Jet200

    Products Location add-on

    I explained that I added those things. I've gone back to the original code with your add-ons as specified. (screen shot below) <?php /* $Id: packingslip.php,v 6.1 2005/06/05 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 */ require('includes/application_top.php'); require(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies(); $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']); $orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'"); include(DIR_WS_CLASSES . 'order.php'); $order = new order($oID); $date = date('d M, Y'); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo STORE_NAME; ?> <?php echo TITLE_PACKING; ?> <?php// echo date("y"); ?><?php echo $oID; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <!-- body_text //--> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <TD ALIGN="left" VALIGN="top"><span class="pageHeadingSM"><FONT FACE="Verdana" SIZE="1" COLOR="#006699"><strong><?php echo nl2br(STORE_NAME_ADDRESS); ?></strong></font></span><br><br><FONT FACE="Verdana" SIZE="2" COLOR="#006699"><strong><?php echo INVOICE_TEXT_INVOICE_NR; ?> <?php// echo INVOICE_TEXT_NUMBER_SIGN; ?> <?php// echo date("y"); ?><?php// echo INVOICE_TEXT_DASH; ?> <?php echo $oID; ?><BR><?php echo ORDER_DATE; ?><?php echo tep_date_short($order->info['date_purchased']); ?></strong></font></TD> <td style="padding: 10px 10px 0px 0px; vertical-align: top;" align="right"><?php echo '<input type="image" src="' . INVOICE_IMAGE . '" width="' . INVOICE_IMAGE_WIDTH . '" height="' . INVOICE_IMAGE_HEIGHT . '" " alt="' . INVOICE_IMAGE_ALT_TEXT . '" onClick="javascript:ShowHide(\'comments_open\',\'comments_close\');">'; ?></td> </tr> <tr> <td colspan="2"> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <TD> <table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr> <td colspan="4"> <table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr> <td width="10%"><hr size="2"></td> <td align="center" nowrap class="pageHeading"><em><b><?php echo TITLE_PACKING; ?></b></em></td> <td width="100%"><hr size="2"></td> </tr> </table> </td> </tr> <tr> <td colspan="4"><?php echo tep_draw_separator('pixel_trans.gif', '100', '5'); ?></td> </tr> <tr> <td width="3"> </td> <td valign="top"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="11"><img src="../images/borders/mainwhite_01.gif" width="11" height="16" alt=""></td> <td background="../images/borders/mainwhite_02.gif"><img src="../images/borders/mainwhite_02.gif" width="24" height="16" alt="" ></td> <td width="19"><img src="../images/borders/mainwhite_03.gif" width="19" height="16" alt=""></td> </tr> <tr> <td background="../images/borders/mainwhite_04.gif"><img src="../images/borders/mainwhite_04.gif" width="11" height="21" alt=""></td> <td align="center" style="background-color: white;"> <table width="100%" border="0" cellspacing="0" cellpadding="0" class="main"> <tr> <td align="left" valign="top"><b><?php echo ENTRY_SOLD_TO; ?></b></td> </tr> <tr> <td> <?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td> </tr> <tr> <td> <?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br> '); ?></td> </tr> <tr> <td> <?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td> <?php echo $order->customer['telephone']; ?></td> </tr> <tr> <td> <?php echo $order->customer['email_address']; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '7'); ?></td> </tr> </table> </td> <td background="../images/borders/mainwhite_06.gif"><img src="../images/borders/mainwhite_06.gif" width="19" height="21" alt=""></td> </tr> <tr> <td><img src="../images/borders/mainwhite_07.gif" width="11" height="18" alt=""></td> <td background="../images/borders/mainwhite_08.gif"><img src="../images/borders/mainwhite_08.gif" width="24" height="18" alt=""></td> <td><img src="../images/borders/mainwhite_09.gif" width="19" height="18" alt=""></td> </tr> </table> </td> <td width="45"> </td> <td valign="top"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="11"><img src="../images/borders/mainwhite_01.gif" width="11" height="16" alt=""></td> <td background="../images/borders/mainwhite_02.gif"><img src="../images/borders/mainwhite_02.gif" width="24" height="16" alt=""></td> <td width="19"><img src="../images/borders/mainwhite_03.gif" width="19" height="16" alt=""></td> </tr> <tr> <td background="../images/borders/mainwhite_04.gif"><img src="../images/borders/mainwhite_04.gif" width="11" height="21" alt=""></td> <td align="center" bgcolor="#FFFFFF"> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main"> <tr> <td align="left" valign="top"><b><?php echo ENTRY_SHIP_TO; ?></b></td> </tr> <tr> <td> <?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td> </tr> <tr> <td> <?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br> '); ?></td> </tr> <tr> <td> <?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '7'); ?></td> </tr> </table> </td> <td background="../images/borders/mainwhite_06.gif"><img src="../images/borders/mainwhite_06.gif" width="19" height="21" alt=""></td> </tr> <tr> <td><img src="../images/borders/mainwhite_07.gif" width="11" height="18" alt=""></td> <td background="../images/borders/mainwhite_08.gif"><img src="../images/borders/mainwhite_08.gif" width="24" height="18" alt=""></td> <td><img src="../images/borders/mainwhite_09.gif" width="19" height="18" alt=""></td> </tr> </table> </td> </tr> </table> </TD> </tr> <tr> <TD COLSPAN="2"><?php echo tep_draw_separator('pixel_trans.gif', '100', '15'); ?></td> </tr> <tr> <TD COLSPAN="2"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="9"> </td> <td> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="11"><img src="../images/borders/mainwhite_01.gif" width="11" height="16" alt=""></td> <td background="../images/borders/mainwhite_02.gif"><img src="../images/borders/mainwhite_02.gif" width="24" height="16" alt="" ></td> <td width="19"><img src="../images/borders/mainwhite_03.gif" width="19" height="16" alt=""></td> </tr> <tr> <td background="../images/borders/mainwhite_04.gif"><img src="../images/borders/mainwhite_04.gif" width="11" height="21" alt=""></td> <td align="center" style="background-color: white;"> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main"> <tr> <td width="33%"> <b><?php echo ORDER_NUMBER; ?></b> <?php echo tep_db_input($oID); ?></td> <td width="33%"> <b><?php echo ORDER_DATE; ?> </b><?php echo tep_date_short($order->info['date_purchased']); ?></td> <td> <b><?php echo ENTRY_PAYMENT_METHOD; ?></b> <?php echo $order->info['payment_method']; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '7'); ?></td> </tr> </table> </td> <td background="../images/borders/mainwhite_06.gif"><img src="../images/borders/mainwhite_06.gif" width="19" height="21" alt=""></td> </tr> <tr> <td><img src="../images/borders/mainwhite_07.gif" width="11" height="18" alt=""></td> <td background="../images/borders/mainwhite_08.gif"><img src="../images/borders/mainwhite_08.gif" width="24" height="18" alt=""></td> <td><img src="../images/borders/mainwhite_09.gif" width="19" height="18" alt=""></td> </tr> </table> </td> </tr> </table> </td> </tr> <tr> <TD COLSPAN="3"><?php echo tep_draw_separator('pixel_trans.gif', '1', '15'); ?></td> </tr> <tr> <TD COLSPAN="3"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <TD COLSPAN="3"> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" colspan="1"><?php echo TABLE_HEADING_PRODUCTS; ?></td> <td WIDTH="80" class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td> </tr> <?php for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) { $product_query = tep_db_query("select products_locate from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . $order->products[$i]['id'] . "'"); $info_product = tep_db_fetch_array($product_query); $hold_locate = ''; if ($info_product['products_locate']){$hold_locate = ' L(' . $info_product['products_locate'] . ')';} 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 (sizeof($order->products[$i]['attributes']) > 0) { for ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) { echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value']; echo '</i></small></nobr>'; } } echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . $hold_locate . '</td>' . "\n" . ' </tr>' . "\n"; } ?> </table> </td> </tr> </table> </td> </tr> </table> <!-- body_text_eof //--> <P> </P> <P> </P> <CENTER><FONT FACE="Verdana" SIZE="2" COLOR="#006699"><strong><?php echo STORE_NAME; ?><BR><?php echo STORE_URL_ADDRESS; ?></strong></font></CENTER> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> This is exactly how it looked when I first installed your code. Two issues - 1. Only one character of the location number is displaying (see where it shows L(A) after the product number). 2. I can't figure out how to restore the columns correctly. I then tried to bust out the location number into it's own column which is the code you saw above. Either one will work for me, I just need to get this to display the entire location number. Thanks
  9. Jet200

    Products Location add-on

    <?php /* $Id: packingslip.php,v 6.1 2005/06/05 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 */ require('includes/application_top.php'); require(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies(); $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']); $orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'"); include(DIR_WS_CLASSES . 'order.php'); $order = new order($oID); $date = date('d M, Y'); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo STORE_NAME; ?> <?php echo TITLE_PACKING; ?> <?php// echo date("y"); ?><?php echo $oID; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <!-- body_text //--> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <TD ALIGN="left" VALIGN="top"><span class="pageHeadingSM"><FONT FACE="Verdana" SIZE="1" COLOR="#006699"><strong><?php echo nl2br(STORE_NAME_ADDRESS); ?></strong></font></span><br><br><FONT FACE="Verdana" SIZE="2" COLOR="#006699"><strong><?php echo INVOICE_TEXT_INVOICE_NR; ?> <?php// echo INVOICE_TEXT_NUMBER_SIGN; ?> <?php// echo date("y"); ?><?php// echo INVOICE_TEXT_DASH; ?> <?php echo $oID; ?><BR><?php echo ORDER_DATE; ?><?php echo tep_date_short($order->info['date_purchased']); ?></strong></font></TD> <td style="padding: 10px 10px 0px 0px; vertical-align: top;" align="right"><?php echo '<input type="image" src="' . INVOICE_IMAGE . '" width="' . INVOICE_IMAGE_WIDTH . '" height="' . INVOICE_IMAGE_HEIGHT . '" " alt="' . INVOICE_IMAGE_ALT_TEXT . '" onClick="javascript:ShowHide(\'comments_open\',\'comments_close\');">'; ?></td> </tr> <tr> <td colspan="2"> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <TD> <table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr> <td colspan="4"> <table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr> <td width="10%"><hr size="2"></td> <td align="center" nowrap class="pageHeading"><em><b><?php echo TITLE_PACKING; ?></b></em></td> <td width="100%"><hr size="2"></td> </tr> </table> </td> </tr> <tr> <td colspan="4"><?php echo tep_draw_separator('pixel_trans.gif', '100', '5'); ?></td> </tr> <tr> <td width="3"> </td> <td valign="top"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="11"><img src="../images/borders/mainwhite_01.gif" width="11" height="16" alt=""></td> <td background="../images/borders/mainwhite_02.gif"><img src="../images/borders/mainwhite_02.gif" width="24" height="16" alt="" ></td> <td width="19"><img src="../images/borders/mainwhite_03.gif" width="19" height="16" alt=""></td> </tr> <tr> <td background="../images/borders/mainwhite_04.gif"><img src="../images/borders/mainwhite_04.gif" width="11" height="21" alt=""></td> <td align="center" style="background-color: white;"> <table width="100%" border="0" cellspacing="0" cellpadding="0" class="main"> <tr> <td align="left" valign="top"><b><?php echo ENTRY_SOLD_TO; ?></b></td> </tr> <tr> <td> <?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td> </tr> <tr> <td> <?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br> '); ?></td> </tr> <tr> <td> <?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td> <?php echo $order->customer['telephone']; ?></td> </tr> <tr> <td> <?php echo $order->customer['email_address']; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '7'); ?></td> </tr> </table> </td> <td background="../images/borders/mainwhite_06.gif"><img src="../images/borders/mainwhite_06.gif" width="19" height="21" alt=""></td> </tr> <tr> <td><img src="../images/borders/mainwhite_07.gif" width="11" height="18" alt=""></td> <td background="../images/borders/mainwhite_08.gif"><img src="../images/borders/mainwhite_08.gif" width="24" height="18" alt=""></td> <td><img src="../images/borders/mainwhite_09.gif" width="19" height="18" alt=""></td> </tr> </table> </td> <td width="45"> </td> <td valign="top"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="11"><img src="../images/borders/mainwhite_01.gif" width="11" height="16" alt=""></td> <td background="../images/borders/mainwhite_02.gif"><img src="../images/borders/mainwhite_02.gif" width="24" height="16" alt=""></td> <td width="19"><img src="../images/borders/mainwhite_03.gif" width="19" height="16" alt=""></td> </tr> <tr> <td background="../images/borders/mainwhite_04.gif"><img src="../images/borders/mainwhite_04.gif" width="11" height="21" alt=""></td> <td align="center" bgcolor="#FFFFFF"> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main"> <tr> <td align="left" valign="top"><b><?php echo ENTRY_SHIP_TO; ?></b></td> </tr> <tr> <td> <?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td> </tr> <tr> <td> <?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br> '); ?></td> </tr> <tr> <td> <?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '7'); ?></td> </tr> </table> </td> <td background="../images/borders/mainwhite_06.gif"><img src="../images/borders/mainwhite_06.gif" width="19" height="21" alt=""></td> </tr> <tr> <td><img src="../images/borders/mainwhite_07.gif" width="11" height="18" alt=""></td> <td background="../images/borders/mainwhite_08.gif"><img src="../images/borders/mainwhite_08.gif" width="24" height="18" alt=""></td> <td><img src="../images/borders/mainwhite_09.gif" width="19" height="18" alt=""></td> </tr> </table> </td> </tr> </table> </TD> </tr> <tr> <TD COLSPAN="2"><?php echo tep_draw_separator('pixel_trans.gif', '100', '15'); ?></td> </tr> <tr> <TD COLSPAN="2"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="9"> </td> <td> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="11"><img src="../images/borders/mainwhite_01.gif" width="11" height="16" alt=""></td> <td background="../images/borders/mainwhite_02.gif"><img src="../images/borders/mainwhite_02.gif" width="24" height="16" alt="" ></td> <td width="19"><img src="../images/borders/mainwhite_03.gif" width="19" height="16" alt=""></td> </tr> <tr> <td background="../images/borders/mainwhite_04.gif"><img src="../images/borders/mainwhite_04.gif" width="11" height="21" alt=""></td> <td align="center" style="background-color: white;"> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main"> <tr> <td width="33%"> <b><?php echo ORDER_NUMBER; ?></b> <?php echo tep_db_input($oID); ?></td> <td width="33%"> <b><?php echo ORDER_DATE; ?> </b><?php echo tep_date_short($order->info['date_purchased']); ?></td> <td> <b><?php echo ENTRY_PAYMENT_METHOD; ?></b> <?php echo $order->info['payment_method']; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '7'); ?></td> </tr> </table> </td> <td background="../images/borders/mainwhite_06.gif"><img src="../images/borders/mainwhite_06.gif" width="19" height="21" alt=""></td> </tr> <tr> <td><img src="../images/borders/mainwhite_07.gif" width="11" height="18" alt=""></td> <td background="../images/borders/mainwhite_08.gif"><img src="../images/borders/mainwhite_08.gif" width="24" height="18" alt=""></td> <td><img src="../images/borders/mainwhite_09.gif" width="19" height="18" alt=""></td> </tr> </table> </td> </tr> </table> </td> </tr> <tr> <TD COLSPAN="3"><?php echo tep_draw_separator('pixel_trans.gif', '1', '15'); ?></td> </tr> <tr> <TD COLSPAN="3"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <TD COLSPAN="3"> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" colspan="1"><?php echo TABLE_HEADING_PRODUCTS; ?></td> <td WIDTH="80" class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td> <td WIDTH="80" class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_LOCATION; ?></td> </tr> <?php for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) { echo ' <tr class="dataTableRow">' . "\n" . ' <td class="dataTableContent" valign="top" align="left">' . $order->products[$i]['qty'] . ' x'. $order->products[$i]['name'] ; if (isset($order->products[$i]['attributes']) && (sizeof($order->products[$i]['attributes']) > 0)) { for ($j=0, $k=sizeof($order->products[$i]['attributes']); $j<$k; $j++) { echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value']; echo '</i></small></nobr>'; } } echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n" . ' </tr>' . "\n"; } ?> </table> </td> </tr> </table> </td> </tr> </table> <!-- body_text_eof //--> <P> </P> <P> </P> <CENTER><FONT FACE="Verdana" SIZE="2" COLOR="#006699"><strong><?php echo STORE_NAME; ?><BR><?php echo STORE_URL_ADDRESS; ?></strong></font></CENTER> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  10. Jet200

    Products Location add-on

    Sorry - that is my current code. When replaced as in the instructions I get the problem described above - everything jammed into one narrow column with the location only dislaying one character (beyond the "(L that proceeds the location number). The way I have it now - everything is still aligned in columns but I cannot get the Location to display nor can I get it to display more characters.
  11. Hi there - I was excited to see this contribution but am having some trouble getting the location to display correctly on my modified packing slip. I use a table layout with seperate columns for qty, description, model#, and now location. Using your code changes, my packing slip stuffs everything into one small column and will only display the first character of the location number. For instance, if the location is AAA-33, all that will display is (LA) after the model number. Here's the contribution: http://addons.oscommerce.com/info/6335 Here's my code portion for the packing slip in question: <tr> <TD COLSPAN="3"><?php echo tep_draw_separator('pixel_trans.gif', '1', '15'); ?></td> </tr> <tr> <TD COLSPAN="3"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <TD COLSPAN="3"> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" colspan="1"><?php echo TABLE_HEADING_PRODUCTS; ?></td> <td WIDTH="180" class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td> <td WIDTH="80" class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_LOCATION; ?></td> </tr> <?php for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) { echo ' <tr class="dataTableRow">' . "\n" . ' <td class="dataTableContent" valign="top" align="left">' . $order->products[$i]['qty'] . ' x '. $order->products[$i]['name'] ; if (isset($order->products[$i]['attributes']) && (sizeof($order->products[$i]['attributes']) > 0)) { for ($j=0, $k=sizeof($order->products[$i]['attributes']); $j<$k; $j++) { echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value']; echo '</i></small></nobr>'; } } echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n" . ' </tr>' . "\n"; } ?> </table> </td> </tr> </table> </td> </tr> </table> <!-- body_text_eof //--> <P> </P> <P> </P> <CENTER><FONT FACE="Verdana" SIZE="2" COLOR="#006699"><strong><?php echo STORE_NAME; ?><BR><?php echo STORE_URL_ADDRESS; ?></strong></font></CENTER> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  12. Jet200

    News Blog V1.0

    Okay. Must not be a lot of support for this :(
  13. Jet200

    News Blog V1.0

    I get the following SQL error: Error SQL query: -- phpMyAdmin SQL Dump -- version 2.9.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jan 18, 2007 at 07:25 PM -- Server version: 4.1.20 -- PHP Version: 4.3.9 -- -- -------------------------------------------------------- -- -- Table structure for table `news` -- INSERT INTO configuration_group( configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible ) VALUES ( '367', 'News Blog', 'News Blog Configuration', 200, 1 ); MySQL said: Documentation #1062 - Duplicate entry '367' for key 1 And when navigating to the news page I get this (and yes I have published an article): Parse error: syntax error, unexpected $end in .../jet200.com/catalog/news.php on line 343 I'm sure it's something simple but I'm not the best when trying to solve PHP mysteries. Thanks
  14. Jet200

    Bundled Products

    Can someone upload screenshots of the admin and customer side? I am in desperate need to for something like this as I have many "kits" that are comprised of many individual parts - all of which customers can also buy individually. i need something that is invisible to the customer and just appears as one product. on the admin side it should list the products within the bundle for easy and accurate order fullfillment. make sense?
×