Jump to content

tkeats

Members
  • Content count

    288
  • Joined

  • Last visited

Everything posted by tkeats

  1. Does anyone know how to modify this code so you can include your 'affiliation link' to WesternUnion in the shopping cart process? I have looked and can not seem to find it.. Thomas Rainbow Computers http://www.stormpay.com/?50381&OSCF for a alternative to paypal.
  2. ok, so I dont have curl installed.. how do I get it installed ?? (Yes, I am root...) Thomas Keats
  3. I'm willing to try.. uhm, how do I know if cURL is on my webserver? ... Thomas Keats
  4. http://www.oscommerce.com/community/contributions,926
  5. On another note. The fact that its made a shippable product. Is there anyway to have it flagged as a 'downloadable' product? I havent seen that bug come up so I assume there is no 'shipping' charged to it.. ;) Thomas
  6. YOUTHEMANYOUTHEMANYOUTHEMAN!!! WOOOOHHOOOOOOOOOOO!!!! oh, btw, it works now ;) Thomas Keats
  7. tkeats

    UPS & USPS Shipping Modules...

    When I enable the UPS response in the ups.php script, I get this email, I am hoping this will help?? Thomas
  8. Having some problems with shipping modules. The following message I get for UPS (presently enabled) and USPS (presently disabled). United Parcel Service United Parcel Service We are unable to obtain a rate quote for UPS shipping. Please contact the store if no other alternative is shown. I have tried a couple different modification packages thinking they would help , but I fear I've fubared something... However, it was like this previously. ANyone have any clue that might guide me in the right direction??
  9. tkeats

    UPS & USPS Shipping Modules...

    OK, I downloaded 1.6 package. Ensured all the changes where made. Everything is correct to the best of what I can see... Now to be safe, thinking it might have something to do with that I am in Canada, I changed all the information to my US Presence address, including in 'my store' and 'shipping/payment' section in the main configuration section. Upon checkout, I get this in the shipping section (I am shipping from and to the same address basically and every other module makes a charge...) Table Rate Best Way $20.00 United Parcel Service (1 x 10lbs) United Parcel Service Any clues? Thomas Keats
  10. Ok, I had that right.... This is a snip of the changes I did.... // Define lookup variables // .com domains $comserver = "whois.internic.net"; // server to lookup for domain name $comnomatch = "No match"; // string returned by server if the domain is not found // .ca domains $comserver = "whois.cira.ca"; // server to lookup for domain name $comnomatch = "No match"; // string returned by server if the domain is not found // .net name search $netserver = "whois.internic.net"; // server to lookup for domain name $netnomatch = "No match"; // string returned by server if the domain is not found --snip-- // This function displays an available domain function dispav($what) { global $fontface, $fontsize, $fontacolor, $infolinks, $reglink, $regurl, $newcount, $type, $domain, $price, $domain_q$ echo "<tr> <td nowrap align=center>"; if ($reglink=="yes") { switch ($type) { case com: $price="15.99"; break; case ca: $price="55.99"; break; case org: $price="15.99"; break; case net: $price="15.99"; break; case couk: $price="3.99"; break; case info: $price="6.99"; break; case orguk: $price="9.99"; break; case ukcom: $price="15.99"; break; case eucom: $price="12.99"; case name: $price="74.99"; break; case meuk: $price="7.99"; break; case uknet: $price="5.99"; break; case gbcom: $price="4.99"; break; case gbnet: $price="12.99"; case tv: $price="64.99"; break; --snip-- <tr> <td align=right> <form method=post action=domain_search1.php> <input type=hidden name=action value=checkdom> <input type=hidden name=type value=$type> <input type=hidden name=price value=$price> <input type=text name=domain size=30 value=$domain> </td> <td align=left> <font face=$fontface size=$fontsize color=$stdcolor> <SELECT NAME=type SIZE=1> <OPTION selected; VALUE=com> .COM <OPTION VALUE=ca> .CA <OPTION VALUE=info> .INFO <OPTION VALUE=net> .NET <OPTION VALUE=org> .ORG <OPTION VALUE=couk> .CO.UK <Option value=orguk> .ORG.UK <option Value=ukcom> .UK.COM <OPTION VALUE=eucom> .EU.COM <OPTION VALUE=name> .NAME <OPTION VALUE=meuk> .ME.UK <OPTION VALUE=uknet> .UK.NET <Option value=gbcom> .GB.COM <OPTION VALUE=gbnet> .GB.NET <option value=tv> .TV </SELECT> <input type=submit name=button value=Check> </form> </td> </tr> --snip-- if($type == "com") { $comarray = array($domain.".com"); $comcount = count($comarray); $i=0; for ($i=0;$i<$comcount;$i++) { $domname = $comarray[$i]; $query = $domname."@".$comserver; $result = ""; $ns = fsockopen($comserver,43); fputs($ns,"$domnamern"); while(!feof($ns)) $result .= fgets($ns,128); fclose($ns); if (eregi($comnomatch,$result)) { dispav($domname); } else { dispun($domname,$comserver); } } echo "<tr><td colspan=5 bgcolor=$sepcolor><font face=$fontface size=$fontsize> </td></tr>"; } // trail for .ca names if($type == "ca") { $netarray = array($domain.".ca"); $netcount = count($netarray); $i=0; for ($i=0;$i<$netcount;$i++) { $domname = $netarray[$i]; $query = $domname."@".$netserver; $result = ""; $ns = fsockopen($netserver,43); fputs($ns,"$domnamern"); while(!feof($ns)) $result .= fgets($ns,128); fclose($ns); if (eregi($netnomatch,$result)) { dispav($domname); } else { dispun($domname,$netserver); } } echo "<tr><td colspan=5 bgcolor=$sepcolor><font face=$fontface size=$fontsize> </td></tr>"; } --snip-- Still something is wrong, I've shown what I have here for reference. All I did was take the entries for the .com and duplicated them and changing com/.com to ca/.ca with the .ca being the 2nd domain selectable. I've gone over my changes til the cows came in, and I cant for the life of me figure out what I'm doing wrong... (I've used whois.internic.ca and whois.cira.ca as the servers. Niether returns an error, and both return a chance to 'register'). Not to mention that my local server that this is running on., a whois -h whois.cira.ca rainbowcomputers.ca returns full data... Please help? Thomas Keats
  11. tkeats

    Domain Name Search & Register

    Has anyone successfully added additional 'domain nic's' to this script? I am having some issues with adding a .ca .. its saying domains that are not available are.. I've copied the .com part and changed all 'com' to 'ca' and changed the whois to whois.cira.ca/whois.internic.ca testing both, neither working. I have a feeling I am missing something but cant put my finger on it. Thomas
  12. Cool, thanks that solved that, now I have begun customizing.. I want to add .ca functionality along with .cn and more. My first shot worked with few problems, bug wise (I just duplicated the .com). Changed the whois to whois.internic.ca and it was operational. However, when I search a domain I know is taken, in fact I used the same server just now through intenic.ca to get the exact url for the setting. My problem is I get this... Search for a Domain Name Checking please wait.... Available Taken Register rainbowcomputers.ca Its saying its not taken, what have I done wrong? Another issue I have discovered, is it adds a product to the database, which is all fine and dandy, but it charges shipping on the item. How do you change this? Thomas
  13. I forgot way back I was told that this contrib wont work with the post nov 2002 checkout procedure, just wondering if anyone has it working? Thomas
  14. url http://test.rainbowcomputersystems.com/adm...D=1&action=edit To-wards the bottom of the page I am recieving an error still. I have even gone so far as to remove the last contribution that I added to that page and still it remains. Products Model UPC Tax Price (ex) Price (inc) Total (ex) Total (inc) 1 x Intel D845GERG2 Motherboard Fatal error: Call to undefined function: tep_currency_format() in /home/www/test.rainbowcomputers.ca/htdocs/admin/orders.php on line 219 Whats going on with this tep_currency_format() that its undefined? Thomas Keats RainbowComputerSystems.com [/b]
  15. tkeats

    One bug plaguing going live...

    ok, this is from my OLD (currently live) shop in the admin/orders.php <?php for ($i=0; $i<sizeof($order->products); $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 (sizeof($order->products[$i]['attributes']) > 0) { for ($j=0; $j<sizeof($order->products[$i]['attributes']); $j++) { echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value']; if ($order_packingslip == false) { 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 class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "n"; if ($order_packingslip == false) { echo ' <td class="dataTableContent" align="right" valign="top">' . tep_display_tax_value($order->products[$i]['tax']) . '%</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']), true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "n" . ' <td class="dataTableContent" 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" . ' <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"; } if ($order_packingslip == false) { ?> And this is the admin/orders.php in the September snapshot... <?php for ($i=0; $i<sizeof($order->products); $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 (sizeof($order->products[$i]['attributes']) > 0) { for ($j=0; $j<sizeof($order->products[$i]['attributes']); $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'] . tep_currency_format($order->products[$i]['attributes'][$j]['price']) . ')'; echo '</i></small></nobr>'; } } echo '</td>' . "n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "n" . // For UPC Code Mod ' <td class="dataTableContent" align="right" valign="top">' . $order->products[$i]['upc'] . '</td>' . "n" . // End UPC Code Mod ' <td class="dataTableContent" align="right" valign="top">' . tep_display_tax_value($order->products[$i]['tax']) . '%</td>' . "n" . // ' <td class="dataTableContent" align="right" valign="top">' . tep_currency_format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) . '</td>' . "n" . // ' <td class="dataTableContent" align="right" valign="top">' . tep_currency_format(($order->products[$i]['final_price'] * $order->products[$i]['tax']/100) + $order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) . '</td>' . "n" . // ' <td class="dataTableContent" align="right" valign="top"><b>' . tep_currency_format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "n" . // ' <td class="dataTableContent" align="right" valign="top"><b>' . tep_currency_format((($order->products[$i]['final_price'] * $order->products[$i]['qty']) * $order->products[$i]['tax']/100$ ' </tr>' . "n"; } ?> the only thing I see that comes near is tep_display_tax_value. Having a hard time reading this section period... Thomas Keats RainbowComputers.ca
  16. tkeats

    One bug plaguing going live...

    OK, I will check that, thanks.
  17. tkeats

    One bug plaguing going live...

    OK. I got the fatal error out, but simply by commenting out those 3 or 4 lines of code that placed tax and price info... Does anyone know what they SHOULD be replaced with??? Thomas Keats RainbowComputerSystems.com
  18. tkeats

    Sales Reports v.7

    I would like to add this, but want to check something ahead of time. Any special mod changes I will have to make? I have the IP address contrib installed, and also the SKU/UPC package installed (not yet fully working) ... Anything I should watch for in advance?? Thomas Keats RainbowComputers.ca
  19. tkeats

    Something nice..

    I would like to be able to report in the sent emails what currency was used. I have the Bank Transfer code in (Even duplicated it allowing for US and Canadian Banks...) but I thought after testing it a couple times. Ut-oh, what if a Customer uses the wrong currency while transfering the funds... There is nothing in the email that tells the customer, or me, what the currency was that was selected.. Thomas Keats .. always something new to come through my mind .. RainbowComputerSystems.com
  20. tkeats

    Bank Transfer Payment Option

    Ah, that would be Transit No. and Institution No. here... Thanks. I just renamed the files needed to cdnbanktransfer.php so I can allow for both Canada and US (I have a native US account.. will make it easier for shipping.. ;) ) THANKS A TON!! now if I can only get that damn sku/upc code to report in the reports section... Thomas Keats GOT IT FINALLY RainbowComputerSystems.com
  21. tkeats

    Bank Transfer Payment Option

    Ok, hang on a second, I think I just realized something. I was labouring under the assumption that this did it all automatically which isn't the case... It simply prints the information on the checkout screen's and in email to give the customer something for reference once they hit the bank. DOH!! Should I then simply be adding a field for Transit Number, and chance the sort code to Institute number?? Oh, but the way, It feels real foolish to have egg on one's face... ;) Thanks for the help thus far!! BTW, isnt posting that information public a security issue for your account? It's now available to anyone on the internet... Thomas Keats .. really starting to get the hang of it now .. RainbowComputerSystems.com
  22. tkeats

    Bank Transfer Payment Option

    Well, its installed, but I am unsure of some things... It involves the following.... Please use the following details to transfer your total order value: Account No.: 12345678 <--- This makes sense, does it matter the actual number of characters? Sort Code: 00-00-00 <-- Sort Code? whats a sort code? Account Name: Fred Bloggs Bank Name: The Bank Your order will not ship until we receive payment in the above account. Allow Bank Transfer Payment 1 Bank Sort Code 00-00-00 Bank Account No. 12345678 Bank Account Name Fred Bloggs Bank Name The Bank for instance.. my cheque is in the following format. Cheque No. Transit No. Institution No. Account No. 0001 86504 200 28996 ::: 17 Fictional information to be sure... ;) Any assistance would be appreciated.. Thomas Keats
  23. tkeats

    Bank Transfer Payment Option

    Question for you. Do they insist that you have a SME/Small business account with the bank to use this type of functionality? or is it simply off your personal account?? Trying to get setup on the cheap, then get everything done after the fact.. Thomas Keats RainbowComputerSystems.com
  24. Ok, I posted this a couple other times, but I think I've finally narrowed my problem down to one file. Long ass code included. (admin/orders.php) <?php /* $Id: orders.php,v 1.95 2002/04/12 22:16:16 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); $orders_statuses = array(); $orders_status_array = array(); $orders_status_query = tep_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . $languages_id . "'"); while ($orders_status = tep_db_fetch_array($orders_status_query)) { $orders_statuses[] = array('id' => $orders_status['orders_status_id'], 'text' => $orders_status['orders_status_name']); $orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name']; } switch ($HTTP_GET_VARS['action']) { case 'update_order': $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']); $status = tep_db_prepare_input($HTTP_POST_VARS['status']); $comments = tep_db_prepare_input($HTTP_POST_VARS['comments']); $order_updated = false; $check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, date_purchased from " . TABLE_ORDERS . " where orders_id = '" . tep_db_input($oID) . "'"); $check_status = tep_db_fetch_array($check_status_query); if ($check_status['orders_status'] != $status) { tep_db_query("update " . TABLE_ORDERS . " set orders_status = '" . tep_db_input($status) . "', last_modified = now() where orders_id = '" . tep_db_input($oID) . "'"); $customer_notified = '0'; if ($HTTP_POST_VARS['notify'] == 'on') { $email = STORE_NAME . "n" . EMAIL_SEPARATOR . "n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "n" . EMAIL_TEXT_DATE_ORDERED . ' ' . tep_date_long($check_status['date_purchased']) . "nn" . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]); tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, nl2br($email), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, ''); $customer_notified = '1'; } tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, new_value, old_value, date_added, customer_notified) values ('" . tep_db_input($oID) . "', '" . tep_db_input($status) . "', '" . $check_status['orders_status'] . "', now(), '" . $customer_notified . "')"); $order_updated = true; } if (tep_not_null($comments)) { tep_db_query("update " . TABLE_ORDERS . " set comments = '" . tep_db_input($comments) . "' where orders_id = '" . tep_db_input($oID) . "'"); $order_updated = true; } if ($order_updated) { $messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success'); } tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')) . 'action=edit')); break; case 'deleteconfirm': $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']); tep_remove_order($oID, $HTTP_POST_VARS['restock']); tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')))); break; } if ( ($HTTP_GET_VARS['action'] == 'edit') && ($HTTP_GET_VARS['oID']) ) { $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']); $orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where orders_id = '" . tep_db_input($oID) . "'"); $order_exists = true; if (!tep_db_num_rows($orders_query)) { $order_exists = false; $messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error'); } } include(DIR_WS_CLASSES . 'order.php'); ?> <!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 TITLE; ?></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"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <?php if ( ($HTTP_GET_VARS['action'] == 'edit') && ($order_exists) ) { $order = new order($oID); ?> <tr> <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td> <td class="pageHeading" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_PRINTORDERS, tep_get_all_get_params(array('action')) . 'action=edit') . '" TARGET="_blank">' . tep_image_button('button_print.gif', IMAGE_PRINT) . '</a><a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td> </tr> </table></td> </tr> <tr> <td><table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr> <td colspan="2"><?php echo tep_draw_separator(); ?></td> </tr> <tr> <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main" valign="top"><b><?php echo ENTRY_CUSTOMER; ?></b></td> <td class="main"><?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, ' ', '<br>'); ?></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td> </tr> <tr> <td class="main"><b><?php echo ENTRY_TELEPHONE; ?></b></td> <td class="main"><?php echo $order->customer['telephone']; ?></td> </tr> <tr> <td class="main"><b><?php echo ENTRY_EMAIL_ADDRESS; ?></b></td> <td class="main"><?php echo '<a href="mailto:' . $order->customer['email_address'] . '"><u>' . $order->customer['email_address'] . '</u></a>'; ?></td> </tr> </table></td> <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main" valign="top"><b><?php echo ENTRY_DELIVERY_TO; ?></b></td> <td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, ' ', '<br>'); ?></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td><table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td> <td class="main"><?php echo $order->info['payment_method']; ?></td> </tr> <?php if ( ($order->info['cc_type']) || ($order->info['cc_owner']) || ($order->info['cc_number']) ) { ?> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main"><?php echo ENTRY_CREDIT_CARD_TYPE; ?></td> <td class="main"><?php echo $order->info['cc_type']; ?></td> </tr> <tr> <td class="main"><?php echo ENTRY_CREDIT_CARD_OWNER; ?></td> <td class="main"><?php echo $order->info['cc_owner']; ?></td> </tr> <tr> <td class="main"><?php echo ENTRY_CREDIT_CARD_NUMBER; ?></td> <td class="main"><?php echo $order->info['cc_number']; ?></td> </tr> <tr> <td class="main"><?php echo ENTRY_CREDIT_CARD_EXPIRES; ?></td> <td class="main"><?php echo $order->info['cc_expires']; ?></td> </tr> <?php } ?> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_PRODUCTS; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td> <? // Added for UPC Code Mod // ?> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_UPC; ?> </td> <? // END UPC Code Mod // ?> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TAX; ?></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_EXCLUDING_TAX; ?></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_INCLUDING_TAX; ?></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_EXCLUDING_TAX; ?></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_INCLUDING_TAX; ?></td> </tr> <?php for ($i=0; $i<sizeof($order->products); $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 (sizeof($order->products[$i]['attributes']) > 0) { for ($j=0; $j<sizeof($order->products[$i]['attributes']); $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'] . tep_currency_format($order->products[$i]['attributes'][$j]['price']) . ')'; echo '</i></small></nobr>'; } } echo '</td>' . "n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "n" . // ' <td class="dataTableContent" valign="top">' . $order->products[$i]['upc'] . '</td>' . "n" . ' <td class="dataTableContent" align="right" valign="top">' . $order->products[$i]['upc'] . '</td>' . "n" . ' <td class="dataTableContent" align="right" valign="top">' . tep_display_tax_value($order->products[$i]['tax']) . '%</td>' . "n" . ' <td class="dataTableContent" align="right" valign="top">' . tep_currency_format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) . '</td>' . "n" . ' <td class="dataTableContent" align="right" valign="top">' . tep_currency_format(($order->products[$i]['final_price'] * $order->products[$i]['tax']/100) + $order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) . '</td>' . "n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . tep_currency_format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . tep_currency_format((($order->products[$i]['final_price'] * $order->products[$i]['qty']) * $order->products[$i]['tax']/100) + ($order->products[$i]['final_price'] * $order->products[$i]['qty']), true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "n" . ' </tr>' . "n"; } ?> <tr> <td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2"> <?php for ($i=0; $i<sizeof($order->totals); $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></td> </tr> <tr> <td class="main"><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td> </tr> <tr><?php echo tep_draw_form('status', FILENAME_ORDERS, tep_get_all_get_params(array('action')) . 'action=update_order'); ?> <td class="main"><?php echo tep_draw_textarea_field('comments', 'soft', '60', '5', $order->info['comments']); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td><table border="0" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main"><b><?php echo ENTRY_STATUS; ?></b> <?php echo tep_draw_pull_down_menu('status', $orders_statuses, $order->info['orders_status']); ?></td> </tr> <tr> <td class="main"><b><?php echo ENTRY_NOTIFY_CUSTOMER; ?></b> <?php echo tep_draw_checkbox_field('notify', '', true); ?></td> </tr> </table></td> <td valign="top"><?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?></td> </tr> </table></td> </form></tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main"><table border="1" cellspacing="0" cellpadding="5"> <tr> <td class="smallText" align="center"><b><?php echo TABLE_HEADING_NEW_VALUE; ?></b></td> <td class="smallText" align="center"><b><?php echo TABLE_HEADING_OLD_VALUE; ?></b></td> <td class="smallText" align="center"><b><?php echo TABLE_HEADING_DATE_ADDED; ?></b></td> <td class="smallText" align="center"><b><?php echo TABLE_HEADING_CUSTOMER_NOTIFIED; ?></b></td> </tr> <?php $orders_history_query = tep_db_query("select new_value, old_value, date_added, customer_notified from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . tep_db_input($oID) . "' order by orders_status_history_id desc"); if (tep_db_num_rows($orders_history_query)) { while ($orders_history = tep_db_fetch_array($orders_history_query)) { echo ' <tr>' . "n" . ' <td class="smallText">' . $orders_status_array[$orders_history['new_value']] . '</td>' . "n" . ' <td class="smallText">' . (tep_not_null($orders_history['old_value']) ? $orders_status_array[$orders_history['old_value']] : ' ') . '</td>' . "n" . ' <td class="smallText" align="center">' . tep_datetime_short($orders_history['date_added']) . '</td>' . "n" . ' <td class="smallText" align="center">'; if ($orders_history['customer_notified'] == '1') { echo tep_image(DIR_WS_ICONS . 'tick.gif', ICON_TICK); } else { echo tep_image(DIR_WS_ICONS . 'cross.gif', ICON_CROSS); } echo ' </tr>' . "n"; } } else { echo ' <tr>' . "n" . ' <td class="smallText" colspan="4">' . TEXT_NO_ORDER_HISTORY . '</td>' . "n" . ' </tr>' . "n"; } ?> </table></td> </tr> <tr> <td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td> </tr> <?php } else { ?> <tr> <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td> <td align="right"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr><?php echo tep_draw_form('orders', FILENAME_ORDERS, '', 'get'); ?> <td class="smallText" align="right"><?php echo HEADING_TITLE_SEARCH . ' ' . tep_draw_input_field('oID', '', 'size="12"') . tep_draw_hidden_field('action', 'edit'); ?></td> </form></tr> <tr><?php echo tep_draw_form('status', FILENAME_ORDERS, '', 'get'); ?> <td class="smallText" align="right"><?php echo HEADING_TITLE_STATUS . ' ' . tep_draw_pull_down_menu('status', tep_array_merge(array(array('id' => '', 'text' => TEXT_ALL_ORDERS)), $orders_statuses), '', 'onChange="this.form.submit();"'); ?></td> </form></tr> </table></td> </tr> </table></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <tr class="dataTableHeadingRow"> <?php // ADDED BY BURT ?> <td class="dataTableHeadingContent" align="center">Order #</td> <?php // END BURT ?> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td> <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_DATE_PURCHASED; ?></td> <?php // ADDED BY BURT ?> <td class="dataTableHeadingContent" align="center">IP Address</td> <?php // END BURT ?> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?> </td> </tr> <?php if ($HTTP_GET_VARS['cID']) { $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']); // NEW "IF ELSEIF ELSE" ADDED BY BURT SO REPLACE THE OLD ONE WITH THIS $orders_query_raw = "select o.ip_address, o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . tep_db_input($cID) . "' and o.orders_status = s.orders_status_id and s.language_id = '" . $languages_id . "' and ot.class = 'ot_total' order by orders_id DESC"; } elseif ($HTTP_GET_VARS['status']) { $status = tep_db_prepare_input($HTTP_GET_VARS['status']); $orders_query_raw = "select o.ip_address, o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . $languages_id . "' and s.orders_status_id = '" . tep_db_input($status) . "' and ot.class = 'ot_total' order by o.orders_id DESC"; } else { $orders_query_raw = "select o.ip_address, o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . $languages_id . "' and ot.class = 'ot_total' order by o.orders_id DESC"; } // END BURT $orders_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $orders_query_raw, $orders_query_numrows); $orders_query = tep_db_query($orders_query_raw); while ($orders = tep_db_fetch_array($orders_query)) { if (((!$HTTP_GET_VARS['oID']) || ($HTTP_GET_VARS['oID'] == $orders['orders_id'])) && (!$oInfo)) { $oInfo = new objectInfo($orders); } if ( (is_object($oInfo)) && ($orders['orders_id'] == $oInfo->orders_id) ) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor='hand'" onclick="document.location.href='' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit') . ''">' . "n"; } else { echo ' <tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" onclick="document.location.href='' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID')) . 'oID=' . $orders['orders_id']) . ''">' . "n"; } ?> <?php // ADDED BY BURT ?> <td class="dataTableContent" align="center"><b><?php echo $orders['orders_id']; ?></b></a> <?php // END BURT ?> <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $orders['orders_id'] . '&action=edit') . '">' . tep_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . '</a> ' . $orders['customers_name']; ?></td> <td class="dataTableContent" align="right"><?php echo strip_tags($orders['order_total']); ?></td> <td class="dataTableContent" align="center"><?php echo tep_datetime_short($orders['date_purchased']); ?></td> <?php // ADDED BY BURT ?> <td class="dataTableContent" align="center"><?php echo $orders['ip_address']; ?></td> <?php // END BURT ?> <td class="dataTableContent" align="right"><?php echo $orders['orders_status_name']; ?></td> <td class="dataTableContent" align="right"><?php if ( (is_object($oInfo)) && ($orders['orders_id'] == $oInfo->orders_id) ) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID')) . 'oID=' . $orders['orders_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td> </tr> <?php } ?> <tr> <td colspan="5"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="smallText" valign="top"><?php echo $orders_split->display_count($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_ORDERS); ?></td> <td class="smallText" align="right"><?php echo $orders_split->display_links($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'], tep_get_all_get_params(array('page', 'oID', 'action'))); ?></td> </tr> </table></td> </tr> </table></td> <?php $heading = array(); $contents = array(); switch ($HTTP_GET_VARS['action']) { case 'delete': $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_ORDER . '</b>'); $contents = array('form' => tep_draw_form('orders', FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=deleteconfirm')); $contents[] = array('text' => TEXT_INFO_DELETE_INTRO . '<br><br><b>' . $cInfo->customers_firstname . ' ' . $cInfo->customers_lastname . '</b>'); $contents[] = array('text' => '<br>' . tep_draw_checkbox_field('restock') . ' ' . TEXT_INFO_RESTOCK_PRODUCT_QUANTITY); $contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'); break; default: if (is_object($oInfo)) { $heading[] = array('text' => '<b>[' . $oInfo->orders_id . '] ' . tep_datetime_short($oInfo->date_purchased) . '</b>'); $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=delete') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a>'); $contents[] = array('text' => '<br>' . TEXT_DATE_ORDER_CREATED . ' ' . tep_date_short($oInfo->date_purchased)); if (tep_not_null($oInfo->last_modified)) $contents[] = array('text' => TEXT_DATE_ORDER_LAST_MODIFIED . ' ' . tep_date_short($oInfo->last_modified)); $contents[] = array('text' => '<br>' . TEXT_INFO_PAYMENT_METHOD . ' ' . $oInfo->payment_method); } break; } if ( (tep_not_null($heading)) && (tep_not_null($contents)) ) { echo ' <td width="25%" valign="top">' . "n"; $box = new box; echo $box->infoBox($heading, $contents); echo ' </td>' . "n"; } ?> </tr> </table></td> </tr> <?php } ?> </table></td> <!-- body_text_eof //--> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> This is the error I get in the reports section. Products Model TABLE_HEADING_PRODUCTS_UPC Tax Price (ex) Price (inc) Total (ex) Total (inc) 1 x Intel D845GERG2 Motherboard Fatal error: Call to undefined function: tep_currency_format() in /home/www/test.rainbowcomputers.ca/htdocs/admin/orders.php on line 220 Any thoughts would be appreciated, and I feel I am still missing something somewhere.. Thomas Keats RainbowComputerSystems.com
  25. tkeats

    Bank Transfer Payment Option

    New Procedure? Oi Vey, I am using one downloaded in September... not looking forward to constant changes upward...
×