Jump to content

PopTheTop

Members
  • Content count

    879
  • Joined

  • Last visited

Everything posted by PopTheTop

  1. Admin Notes v1.0 by PopTheTop of http://www.popthetop.com This will add a section under Admin / Tools where you may enter personal notes about anything you wish. You can save your notes to an unlimited number of categories, move or copy them from one category to another, go back and add to or modify your notes, delete them when they are no longer needed, preview the notes you have entered, sort your notes by title, status in ascending or descending view. I needed a place to easily store my notes about various contributions, suppliers, customers, order details, shipping and so on. I got tired of having little pieces of paper all over my desk reminding me of stuff. So in order to clean up a bit, I decided to build this little contribution. This is also a great way to keep track of your suppliers, contributions, gift certificates and so on. It is very simple to install. Just upload a few files, add 2 new tables in your database and make 2 small changes to 2 files. ----------------------------- If you need any support, this is the place to find it. ----------------------------- You may get this contribution from
  2. Reviews in Product Display v2.0 This mod will show the reviews for a product on its description page (if any). Set the number of reviews you'd like shown by changing the number in the Admin » Configuration » Maximum Values. A setting of 0 will disable this mod completely (default setting is 3). If disabled, it uses the original osC code. Download from: http://www.oscommerce.com/community/contributions,734
  3. Support for... Fancier Invoice & Packingslip v1.0 by PopTheTop *advertising offsite link This will replace your current boring invoice and packing slip with a much nicer, cleaner and fancier invoice and packing slip. I added a box around certain sections with a drop shadow. Also, I added a few other goodies as well as the order number to both.
  4. Customer Mismatched State & Zipcode Report v2.0 This will look through the database and report the names / id of customers whose zipcode does not match up with the State in their Address Book. It will search for both so either the zipcode is wrong or the State is wrong. If there are no incorrect entries found, nothing will be reported. This way, you can notify the customer and let them know that they need to update their account info. It may be the shipping address or billing address This is compatible with the Admin DHTML Menus contribution HERE
  5. PopTheTop

    Accept eCheck Payments v2.0

    ----------------------------------------------------- ONLINE ECHECK PAYMENT MODULE Accept eCheck Payments v2.0 Require: MS1 or osC v2.2 MS2 Download from: http://www.oscommerce.com/community/contributions,2557 ----------------------------------------------------- SCREENSHOT INCLUDED! This will allow you to be able to accept online eCheck payments by phone, fax or e-mail. Using software like eChex 2000 (available from http://www.cardhost.com/files/eChex2000.zip), you simply input your customers banking account info into eChex 2000 and print a check draft ready for deposit. No signature is ever required on any bank draft. You deposit them just like any other check and ALL US banks accept them. NOTE: This payment module is for US Bank Account Holders only. Backup your files and database! EASY installation, just copy 2 files to your server and modify the files as instructed below. Then activate it in Admin / Modules / Payment.
  6. PopTheTop

    [Contribution] Admin Notes

    You have to call the $cInfo->customers_notes from the customers database table in addition to the tables in orders.
  7. PopTheTop

    [Contribution] Admin Notes

    Yes, that is very possible but I do not have the time to do it right now.
  8. PopTheTop

    Accept eCheck Payments v2.0

    It is in admin\includes\languages\english\orders.php make sure you uploaded it and that you uploaded it into your admin\includes\languages\english\orders.php
  9. PopTheTop

    Automatically send data feed to Froogle

    I have a MOD that send me e-mails whenever there is an error on my site or someone tries to hack into the site, like try to get into the Admin. For months now, I have been getting this e-mail when Google visits my site and sometimes MSNBot for various product pages and so on... ------------------------------------------- Site: http://www.popthetop.com Error Code: 404 - File or Page Not Found Occurred: 08/28/2005 7:55:44 Requested URL: http://www.popthetop.com/catalog/product_info.php%3Fcurrency%3DUSD&products_id%3D324&fr=AM0D2pquQxgKeI9frlt5U5R8v6OCmDEu09vJmtrY-N41AAAAAAAAAAA User IP Address: 66.249.65.66 User Agent: Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) Referer: ------------------------------------------- As you can see, Google is trying to load pages that the links have converted = signs and question marks. %3F is supposed to be ? %3D is supposed to be = If I turn http://www.popthetop.com/catalog/product_info.php%3Fcurrency%3DUSD&products_id%3D324&fr=AM0D2pquQxgKeI9frlt5U5R8v6OCmDEu09vJmtrY-N41AAAAAAAAAAA into this http://www.popthetop.com/catalog/product_info.php?currency=USD&products_id=324&fr=AM0D2pquQxgKeI9frlt5U5R8v6OCmDEu09vJmtrY-N41AAAAAAAAAAA The links work. Is there any way to fix this so that the correct pages get loaded? Is there any way to convert %3F to ? and %3D to = when a page loads?
  10. PopTheTop

    Fancier Invoice & Packingslip v1.0

    Hmm, looks like you have 2 thing contridicting one another. Your E-mail Options should look like this... What is the line that sets a template called fancy.php? You have 2 template settings there. This must be your problem.
  11. I am having some big problems and wonder if this has been looked into or if anyone knows how to add this on... I have products that have options the customer can add. For instance, I sell a 12 volt portable air conditioner for $39.95 with 4 options to choose from: 1) Igloo Family 25qt Cooler (+ $29.95) 2) AC / DC Converter (+ $24.95) 3) Portable Power Pack (+ $59.95) 4) PVC Air Flow Elbow (+ $3.95) My problem is this, #1, 2 and 3 above add quit a bit of shipping for me to ship. #3 is really heavy and cost me the most. But at checkout, shipping is only added for the weight of the item itself so I am loosing a lot of money when my customers buy the extra options. Usually just break even and sometimes process that sale at a small loss. How can I get extra shipping to be added to the options?
  12. PopTheTop

    Fancier Invoice & Packingslip v1.0

    Looks to me that you either failed to upload all the files, uploaded them in BINARY mode instead of ASCII mode or uploaded the files in the wrong folders. Some files have the same name and go in both the catalog side and the admin side. I suggest uploading your files again and make certain you are uploading them into the correct folders on the server. Also, check your paths. My store is in the catalog sub folder of my domain. (http://www.popthetop.com/catalog). If your store is in any other sub folder than catalog, then you may have to update the paths in the contribution. Some code may be calling files in the /catalog folder, I forget.
  13. PopTheTop

    Automatically send data feed to Froogle

    peacem_categories = categories Call it by calling categories peacem_ is just a prefix.
  14. PopTheTop

    Fancier Invoice & Packingslip v1.0

    Yes, you can do that.
  15. PopTheTop

    Fancier Invoice & Packingslip v1.0

    Did you install the language files? And did you install ALL of them in the CORRECT folders? You have them in both catalog/admin/includes/languages AND catalog/includes/languages.
  16. PopTheTop

    Fancier Invoice & Packingslip v1.0

    Check your paths. Right-click on the missing images and look at the path they are calling through properties. If your store is not in the catalog sub folder, then this is probably your problem.
  17. PopTheTop

    Fancier Invoice & Packingslip v1.0

    Yep, that will do it for you.
  18. PopTheTop

    Fancier Invoice & Packingslip v1.0

    Try using the path catalog/admin/images/logo.jpg or images/logo.jpg Chances are that images/logo.jpg is the one you need to use. Take a look at the border paths and use the same path that they use. This is my setting and my store is located at www.xxx.com/catalog/admin/... //Change this to match your logo image and foler it is in define('INVOICE_IMAGE', 'images/pop-the-top_logo1.gif');
  19. PopTheTop

    Fancier Invoice & Packingslip v1.0

    No, not really. It should load the invoice. Try re-uploading the template files and the print_invoice file. If you want, I can send you a direct copy of mine for you to use. In fact, here it is anyway... try it out. print_my_invoice.php <?php /* $Id: print_my_invoice.php,v 6.0 2005/06/01 23:03:52 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'); if (!tep_session_is_registered('customer_id')) { $navigation->set_snapshot(); tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL')); } if (!isset($HTTP_GET_VARS['order_id']) || (isset($HTTP_GET_VARS['order_id']) && !is_numeric($HTTP_GET_VARS['order_id']))) { tep_redirect(tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL')); } $orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where orders_id = '" . tep_db_input($oID) . "'"); $customer_info_query = tep_db_query("select customers_id from " . TABLE_ORDERS . " where orders_id = '". (int)$HTTP_GET_VARS['order_id'] . "'"); $customer_info = tep_db_fetch_array($customer_info_query); if ($customer_info['customers_id'] != $customer_id) { tep_redirect(tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL')); } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ORDERS_PRINTABLE_INFO); $breadcrumb->add(NAVBAR_TITLE_1, tep_href_link(FILENAME_ACCOUNT, '', 'SSL')); $breadcrumb->add(NAVBAR_TITLE_2, tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL')); $breadcrumb->add(sprintf(NAVBAR_TITLE_3, $HTTP_GET_VARS['order_id']), tep_href_link(FILENAME_ORDERS_PRINTABLE_INFO, 'order_id=' . $HTTP_GET_VARS['order_id'], 'SSL')); require(DIR_WS_CLASSES . 'order.php'); $order = new order($HTTP_GET_VARS['order_id']); $date = date('M d, 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 INVOICE_TEXT_INVOICE; ?> <?php echo INVOICE_TEXT_NUMBER_SIGN; ?><?php echo date("y"); ?><?php echo INVOICE_TEXT_DASH; ?><?php echo $order_id;; ?></title> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" onload="window.print();return false"> <!-- body_text //--> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td align="left"><?php echo '<input type="image" src="' . INVOICE_IMAGE . '" width="' . INVOICE_IMAGE_WIDTH . '" height="' . INVOICE_IMAGE_HEIGHT . '" " alt="' . INVOICE_IMAGE_ALT_TEXT . '">'; ?></td> <TD ALIGN="right" VALIGN="top"><FONT COLOR="#006699" SIZE="2" FACE="Verdana"><strong><?php echo INVOICE_TEXT_INVOICE; ?> <?php echo INVOICE_TEXT_NUMBER_SIGN; ?> <?php echo date("y"); ?><?php echo INVOICE_TEXT_DASH; ?><?php echo $order_id; ?><BR><?php echo $date; ?></strong></font></TD> </tr> <tr> <td colspan="2"> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <TD COLSPAN="2" ALIGN="right" class="smallAddressBlue_INVOICE"><FONT FACE="Verdana" SIZE="1" COLOR="#006699"><strong><?php echo nl2br(STORE_NAME_ADDRESS); ?></strong></font></TD> </tr> <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" class="pageHeading_INVOICE"><em><b><?php echo INVOICE_TEXT_INVOICE; ?></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/maingrey_01.gif" width="11" height="16" alt=""></td> <td background="images/borders/maingrey_02.gif"><img src="images/borders/maingrey_02.gif" width="24" height="16" alt="" ></td> <td width="19"><img src="images/borders/maingrey_03.gif" width="19" height="16" alt=""></td> </tr> <tr> <td background="images/borders/maingrey_04.gif"><img src="images/borders/maingrey_04.gif" width="11" height="21" alt=""></td> <td align="center" bgcolor="#F2F2F2"> <table width="100%" border="0" cellspacing="0" cellpadding="0" class="main_INVOICE"> <tr> <td align="left" valign="top" class="order_infobox_heading_INVOICE"><b><?php echo ENTRY_SOLD_TO; ?></b></td> </tr> <tr> <td class="order_infobox_data_INVOICE"> <?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td> </tr> <tr> <td class="order_infobox_data_INVOICE"> <?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br> '); ?></td> </tr> <tr> <td class="order_infobox_data_INVOICE"> <?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="order_infobox_data_INVOICE"> <?php echo $order->customer['telephone']; ?></td> </tr> <tr> <td class="order_infobox_data_INVOICE"> <?php echo $order->customer['email_address']; ?></td> </tr> <tr> <td class="order_infobox_data_INVOICE"><?php echo tep_draw_separator('pixel_trans.gif', '1', '7'); ?></td> </tr> </table></td> <td background="images/borders/maingrey_06.gif"><img src="images/borders/maingrey_06.gif" width="19" height="21" alt=""></td> </tr> <tr> <td><img src="images/borders/maingrey_07.gif" width="11" height="18" alt=""></td> <td background="images/borders/maingrey_08.gif"><img src="images/borders/maingrey_08.gif" width="24" height="18" alt=""></td> <td><img src="images/borders/maingrey_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_INVOICE"> <tr> <td align="left" valign="top" class="order_infobox_heading_INVOICE"><b><?php echo ENTRY_SHIP_TO; ?></b></td> </tr> <tr> <td class="order_infobox_data_INVOICE"> <?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td> </tr> <tr> <td class="order_infobox_data_INVOICE"> <?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br> '); ?></td> </tr> <tr> <td class="order_infobox_data_INVOICE"> <?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="order_infobox_data_INVOICE"> </td> </tr> <tr> <td class="order_infobox_data_INVOICE"> </td> </tr> <tr> <td class="order_infobox_data_INVOICE"><?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/maingrey_01.gif" width="11" height="16" alt=""></td> <td background="images/borders/maingrey_02.gif"><img src="images/borders/maingrey_02.gif" width="24" height="16" alt="" ></td> <td width="19"><img src="images/borders/maingrey_03.gif" width="19" height="16" alt=""></td> </tr> <tr> <td background="images/borders/maingrey_04.gif"><img src="images/borders/maingrey_04.gif" width="11" height="21" alt=""></td> <td align="center" bgcolor="#F2F2F2"> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main_INVOICE"> <tr> <td width="33%" class="order_infobox_data_INVOICE"><strong> <?php echo INVOICE_TEXT_ORDER; ?> <?php echo INVOICE_TEXT_NUMBER_SIGN; ?><?php echo INVOICE_TEXT_COLON; ?></strong> <?php echo tep_db_input( $order_id); ?></td> <td width="33%" class="order_infobox_data_INVOICE"><strong> <?php echo INVOICE_TEXT_DATE_OF_ORDER; ?><?php echo INVOICE_TEXT_COLON; ?> </strong><?php echo tep_date_short($order->info['date_purchased']); ?></td> <?php if (tep_not_null($order->info['cc_number'])) { $this->cc_card_number_less_middle_digits = substr($order->info['cc_number'], 0, 4) . str_repeat('x', (strlen($order->info['cc_number']) - 8)) . substr($order->info['cc_number'], -4); ?> <td class="order_infobox_data_INVOICE"><span class="order_infobox_heading_INVOICE"> <b><?php echo ENTRY_PAYMENT_METHOD; ?></b></span> <?php echo $order->info['payment_method']; ?> (<?php echo $order->info['cc_type']; ?>)<br> <?php echo tep_draw_separator('pixel_trans.gif', '100%', '6'); ?><br> <span class="order_infobox_heading_INVOICE"> <b><?php echo ENTRY_PAYMENT_CC_NUMBER; ?></b></span> <?php echo $this->cc_card_number_less_middle_digits; ?></td> <?php } else { ?> <td class="order_infobox_data_INVOICE"><span class="order_infobox_heading_INVOICE"> <b><?php echo ENTRY_PAYMENT_METHOD; ?></b></span> <?php echo $order->info['payment_method']; ?></td> <?php } ?> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '7'); ?></td> </tr> </table></td> <td background="images/borders/maingrey_06.gif"><img src="images/borders/maingrey_06.gif" width="19" height="21" alt=""></td> </tr> <tr> <td><img src="images/borders/maingrey_07.gif" width="11" height="18" alt=""></td> <td background="images/borders/maingrey_08.gif"><img src="images/borders/maingrey_08.gif" width="24" height="18" alt=""></td> <td><img src="images/borders/maingrey_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%', '20'); ?></td> </tr> <tr> <TD COLSPAN="2" align="center"> <table border="0" width="98%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow_INVOICE"> <td colspan="2" class="dataTableHeadingContent_INVOICE"> <font color="#000000"><?php echo TABLE_HEADING_PRODUCTS; ?></font></td> <td WIDTH="80" class="dataTableHeadingContent_INVOICE"><font color="#000000"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></font></td> <td WIDTH="80" align="right" class="dataTableHeadingContent_INVOICE"><font color="#000000"><?php echo TABLE_HEADING_UNIT_PRICE; ?></font></td> <TD WIDTH="80" ALIGN="right" CLASS="dataTableHeadingContent_INVOICE"><font color="#000000"><?php echo TABLE_HEADING_TOTAL; ?></font> </TD> </tr> <?php for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) { echo ' <tr class="dataTableRow_INVOICE">' . "\n" . ' <td class="dataTableContent_INVOICE" valign="top" align="right">' . $order->products[$i]['qty'] . ' x</td>' . "\n" . ' <td class="dataTableContent_INVOICE" 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>'; } } echo ' </td>' . "\n" . ' <td WIDTH="80" class="dataTableContent_INVOICE" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n"; echo ' <td WIDTH="80" class="dataTableContent_INVOICE" align="right" valign="top">' . $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) . '</td>' . "\n" . ' <td WIDTH="80" class="dataTableContent_INVOICE" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ' </b></td>' . "\n"; echo ' </tr>' . "\n"; } ?> <tr> <td align="right" colspan="5"> <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_INVOIVE">' . $order->totals[$i]['title'] . '</td>' . "\n" . ' <td align="right" class="smallText_INVOIVE">' . $order->totals[$i]['text'] . '</td>' . "\n" . ' </tr>' . "\n"; } ?> </table></td> </tr> </table></td> </tr> <!-- ORDER COMMENTS CODE STARTS HERE //--> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '18'); ?></td> </tr> <tr> <TD> <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/maingrey_01.gif" width="11" height="16" alt=""></td> <td background="images/borders/maingrey_02.gif"><img src="images/borders/maingrey_02.gif" width="24" height="16" alt="" ></td> <td width="19"><img src="images/borders/maingrey_03.gif" width="19" height="16" alt=""></td> </tr> <tr> <td background="images/borders/maingrey_04.gif"><img src="images/borders/maingrey_04.gif" width="11" height="21" alt=""></td> <td align="center" bgcolor="#F2F2F2"> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main"> <!-- backorder addition --> <?php $orders_history_backorder_query = tep_db_query("select backorders from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . (int)$HTTP_GET_VARS['order_id'] . "'"); $orders_history_backorder = tep_db_fetch_array($orders_history_backorder_query); if (tep_not_null($orders_history_backorder['backorders'])) { ?> <tr> <td colspan="3" align="left" valign="top" class="order_infobox_heading"><b>BACKORDER INSTRUCTIONS:</b></td> </tr> <tr> <td valign="top" class="product_infobox_data" width="114"><br> <strong><?php echo tep_date_short($order->info['date_purchased']); ?></strong></td> <td colspan="2" valign="top" class="product_infobox_data"><br><?php echo tep_db_output($orders_history_backorder['backorders']); ?></td> </tr> <tr> <td colspan="3"><?php echo tep_draw_separator('pixel_trans.gif', '100', '20'); ?></td> </tr> <?php } ?> <!-- end backorder addition --> <tr> <td colspan="3" align="left" valign="top" class="order_infobox_heading"><b>ORDER COMMENTS:</b></td> </tr> <?php $statuses_query = tep_db_query("select os.orders_status_name, osh.date_added, osh.comments, osh.backorders from " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh where osh.orders_id = '" . (int)$HTTP_GET_VARS['order_id'] . "' and osh.orders_status_id = os.orders_status_id and os.language_id = '" . (int)$languages_id . "' order by osh.date_added"); while ($statuses = tep_db_fetch_array($statuses_query)) { echo ' <tr>' . "\n"; echo ' <td valign="top" class="product_infobox_data" width="114"><br> <strong>' . tep_date_short($statuses['date_added']) . '</strong></td>' . "\n"; echo ' <td valign="top" class="product_infobox_data" width="85"><br>' . $statuses['orders_status_name'] . '</td>' . "\n"; echo ' <td valign="top" class="product_infobox_data"><br>' . (empty($statuses['comments']) ? ' ' : nl2br(tep_output_string_protected($statuses['comments']))) . '</td>' . "\n"; echo ' </tr>' . "\n"; } ?> <tr> <td colspan="3"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '7'); ?></td> </tr> </table> </td> <td background="images/borders/maingrey_06.gif"><img src="images/borders/maingrey_06.gif" width="19" height="21" alt=""></td> </tr> <tr> <td><img src="images/borders/maingrey_07.gif" width="11" height="18" alt=""></td> <td background="images/borders/maingrey_08.gif"><img src="images/borders/maingrey_08.gif" width="24" height="18" alt=""></td> <td><img src="images/borders/maingrey_09.gif" width="19" height="18" alt=""></td> </tr> </table> </td> </tr> </table> <!-- ORDER COMMENTS CODE ENDS HERE //--> <br> <CENTER><span class="smallText_INVOIVE"><FONT FACE="Verdana" COLOR="#006699"><strong><?php echo INVOICE_TEXT_THANK_YOU; ?><BR><?php echo STORE_NAME; ?><BR><?php echo STORE_URL_ADDRESS; ?></strong></font></span></CENTER> <!-- body_text_eof //--> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  20. PopTheTop

    Fancier Invoice & Packingslip v1.0

    The SQL error is no longer there...
  21. PopTheTop

    Fancier Invoice & Packingslip v1.0

    Look at the path/code being called for that pop-up page to be printed. It is opening: https://www.kimandjason.com/shop/print_my_invoice.php/order_id/14?osCsid=4ce407b7a6fee00e928f67dd0be6d42c Instead of https://www.kimandjason.com/shop/print_my_invoice.php?order_id=14&osCsid=4ce407b7a6fee00e928f67dd0be6d42c Look at the bold. By the way, in the catagory looking at the product lists, when you click on your BUY button, you get the following SQL error. To bypass it, you have to view the product and THEN hit add to wagon (cart).
  22. PopTheTop

    Fancier Invoice & Packingslip v1.0

    It is telling you that it can not find the file. Therefore, it is telling you to check your paths. Is your store in the sub folder called "catalog"? If not, then there is your problem. Edit line number 255 and look at the path it is calling.
  23. PopTheTop

    Email Invoice 1.0

    If you download and use the templates found in http://www.oscommerce.com/community/contributions,2861 then you should be OK. I have the comments in them already and I think there are 4 templates with it that you can use. They should still work for you but if not, you can compare the templates with your templates and see how I added the comments and such.
  24. PopTheTop

    Email Invoice 1.0

    Hey I just made a test order and your template file is screwed up. It states this when you try to open it...
×