taz1 Posted September 5, 2004 Share Posted September 5, 2004 (edited) Hi greg i double checked more then 10 times but i realy don't get it to work :-( this is my orders.php <?php/* ? $Id: orders.php 100 2003-12-20 21:34:49Z dogu $ ? osCommerce, Open Source E-Commerce Solutions nicht ge?ndert ? http://www.oscommerce.com ? Copyright ? 2003 osCommerce ? Released under the GNU General Public License */ ? require('includes/application_top.php'); ? require(DIR_WS_CLASSES . 'currencies.php'); ? $currencies = new currencies(); ? $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 = '" . (int)$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']; ? } ? $action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : ''); ? if (tep_not_null($action)) { ? ? switch ($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 = '" . (int)$oID . "'"); ? ? ? ? $check_status = tep_db_fetch_array($check_status_query); // BOF: WebMakers.com Added: Downloads Controller // always update date and time on order_status // original? ? ? ? if ( ($check_status['orders_status'] != $status) || tep_not_null($comments)) { ? ? ? ? ? ? ? ? ? if ( ($check_status['orders_status'] != $status) || $comments != '' || ($status ==DOWNLOADS_ORDERS_STATUS_UPDATED_VALUE) ) { ? ? ? ? ? tep_db_query("update " . TABLE_ORDERS . " set orders_status = '" . tep_db_input($status) . "', last_modified = now() where orders_id = '" . (int)$oID . "'"); ? ? ? ? $check_status_query2 = tep_db_query("select customers_name, customers_email_address, orders_status, date_purchased from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'"); ? ? ? ? $check_status2 = tep_db_fetch_array($check_status_query2); ? ? ? if ( $check_status2['orders_status']==DOWNLOADS_ORDERS_STATUS_UPDATED_VALUE ) { ? ? ? ? tep_db_query("update " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " set download_maxdays = '" . tep_get_configuration_key_value('DOWNLOAD_MAX_DAYS') . "', download_count = '" . tep_get_configuration_key_value('DOWNLOAD_MAX_COUNT') . "' where orders_id = '" . (int)$oID . "'"); ? ? ? } // EOF: WebMakers.com Added: Downloads Controller ? ? ? ? ? ? ? ? $customer_notified = '0'; ? ? ? ? ? if (isset($HTTP_POST_VARS['notify']) && ($HTTP_POST_VARS['notify'] == 'on')) { ? ? ? ? ? ? $notify_comments = ''; // BOF: WebMakers.com Added: Downloads Controller - Only tell of comments if there are comments ? ? ? ? ? ? if (isset($HTTP_POST_VARS['notify_comments']) && ($HTTP_POST_VARS['notify_comments'] == 'on')) { ? ? ? ? ? ? ? $notify_comments = sprintf(EMAIL_TEXT_COMMENTS_UPDATE, $comments) . "\n\n"; ? ? ? ? ? ? } // EOF: WebMakers.com Added: Downloads Controller ? ? ? ? ? ? ? ? ? ? ? $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']) . "\n\n" . $notify_comments . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]); ? ? ? ? ? ? tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); ? ? ? ? ? ? $customer_notified = '1'; ? ? ? ? ? } ? ? ? ? ? tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, comments) values ('" . (int)$oID . "', '" . tep_db_input($status) . "', now(), '" . tep_db_input($customer_notified) . "', '" . tep_db_input($comments)? . "')"); ? ? ? ? ? $order_updated = true; ? ? ? ? } ? ? ? ? if ($order_updated == true) { ? ? ? ? $messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success'); ? ? ? ? } else { ? ? ? ? ? $messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning'); ? ? ? ? } ? ? ? ? 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']); ? ? ? ? // begin modification for banktransfer ? ? ? ? ? tep_db_query("DELETE FROM banktransfer WHERE orders_id = '" . (int)$oID . "'"); ? ? ? ? // end modification for banktransfer ? ? ? ? tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')))); ? ? ? ? break; ? ? } ? } ? if (($action == 'edit') && isset($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 = '" . (int)$oID . "'"); ? ? $order_exists = true; ? ? if (!tep_db_num_rows($orders_query)) { ? ? ? $order_exists = false; ? ? ? $messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error'); ? ? } ? } // BOF: WebMakers.com Added: Additional info for Orders // Look up things in orders $the_extra_query= tep_db_query("select * from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'"); $the_extra= tep_db_fetch_array($the_extra_query); $the_customers_id= $the_extra['customers_id']; // Look up things in customers $the_extra_query= tep_db_query("select * from " . TABLE_CUSTOMERS . " where customers_id = '" . $the_customers_id . "'"); $the_extra= tep_db_fetch_array($the_extra_query); $the_customers_fax= $the_extra['customers_fax']; // EOF: WebMakers.com Added: Additional info for Orders ? 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"> <script language="javascript" src="includes/general.js"></script> </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 (($action == 'edit') && ($order_exists == true)) { ? ? $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("edit_orders.php", tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> '; ?> <?php //begin PayPal_Shopping_Cart_IPN if (strtolower($order->info['payment_method']) == 'paypal' && isset($HTTP_GET_VARS['referer']) && $HTTP_GET_VARS['referer'] == 'ipn'){ ?> ? ? <td class="pageHeading" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_PAYPAL, tep_get_all_get_params(array('action','oID','referer'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td> <?php } else { ?> ? ? <td class="pageHeading" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action','referer'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td> <?php }//else not paypal //end PayPal_Shopping_Cart_IPN ?> </td> ? ? ? ? ? </tr> ? ? ? ? </table></td> ? ? ? </tr> ? ? ? <tr> ? ? ? ? <td><table width="100%" border="0" cellspacing="0" cellpadding="2"> ? ? ? ? ? <tr> ? ? ? ? ? ? <td colspan="3"><?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_NUMBER; ?></b></td> ? ? ? ? ? ? ? ? <td class="main"><?php echo $order->customer['telephone']; ?></td> ? ? ? ? ? ? ? </tr> <?php // BOF: WebMakers.com Added: Downloads Controller - Extra order info ?> ? ? ? ? ? ? ? <tr> ? ? ? ? ? ? ? ? <td class="main"><b><?php echo 'FAX #:'; ?></b></td> ? ? ? ? ? ? ? ? <td class="main"><?php echo $the_customers_fax; ?></td> ? ? ? ? ? ? ? </tr> <?php // EOF: WebMakers.com Added: Downloads Controller ?> ? ? ? ? ? ? ? <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_SHIPPING_ADDRESS; ?></b></td> ? ? ? ? ? ? ? ? <td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>'); ?></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_BILLING_ADDRESS; ?></b></td> ? ? ? ? ? ? ? ? <td class="main"><?php echo tep_address_format($order->billing['format_id'], $order->billing, 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"> <?php // BOF: WebMakers.com Added: Show Order Info ?> <!-- add Order # // --> <tr> <td class="main"><b>Order # </b></td> <td class="main"><?php echo tep_db_input($oID); ?></td> </tr> <!-- add date/time // --> <tr> <td class="main"><b>Order Date & Time</b></td> <td class="main"><?php echo tep_datetime_short($order->info['date_purchased']); ?></td> </tr> <?php // EOF: WebMakers.com Added: Show Order Info //begin PayPal_Shopping_Cart_IPN if (strtolower($order->info['payment_method']) == 'paypal') { include(DIR_FS_CATALOG_MODULES . 'payment/paypal/admin/orders.inc.php'); } else { ?> ? <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 }//else not paypal //end PayPal_Shopping_Cart_IPN ? ? if (tep_not_null($order->info['cc_type']) || tep_not_null($order->info['cc_owner']) || tep_not_null($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 ? ? } ? ? // begin modification for banktransfer ? ? $banktransfer_query = tep_db_query("select banktransfer_prz, banktransfer_status, banktransfer_owner, banktransfer_number, banktransfer_bankname, banktransfer_blz, banktransfer_fax from banktransfer where orders_id = '" . tep_db_input($HTTP_GET_VARS['oID']) . "'"); ? ? $banktransfer = tep_db_fetch_array($banktransfer_query); ? ? if (($banktransfer['banktransfer_bankname']) || ($banktransfer['banktransfer_blz']) || ($banktransfer['banktransfer_number'])) { ?> ? ? ? ? ? <tr> ? ? ? ? ? ? <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> ? ? ? ? ? </tr> ? ? ? ? ? <tr> ? ? ? ? ? ? <td class="main"><?php echo TEXT_BANK_NAME; ?></td> ? ? ? ? ? ? <td class="main"><?php echo $banktransfer['banktransfer_bankname']; ?></td> ? ? ? ? ? </tr> ? ? ? ? ? <tr> ? ? ? ? ? ? <td class="main"><?php echo TEXT_BANK_BLZ; ?></td> ? ? ? ? ? ? <td class="main"><?php echo $banktransfer['banktransfer_blz']; ?></td> ? ? ? ? ? </tr> ? ? ? ? ? <tr> ? ? ? ? ? ? <td class="main"><?php echo TEXT_BANK_NUMBER; ?></td> ? ? ? ? ? ? <td class="main"><?php echo $banktransfer['banktransfer_number']; ?></td> ? ? ? ? ? </tr> ? ? ? ? ? <tr> ? ? ? ? ? ? <td class="main"><?php echo TEXT_BANK_OWNER; ?></td> ? ? ? ? ? ? <td class="main"><?php echo $banktransfer['banktransfer_owner']; ?></td> ? ? ? ? ? </tr> <?php ? ? ? if ($banktransfer['banktransfer_status'] == 0) { ?> ? ? ? ? ? <tr> ? ? ? ? ? ? <td class="main"><?php echo TEXT_BANK_STATUS; ?></td> ? ? ? ? ? ? <td class="main"><?php echo "OK"; ?></td> ? ? ? ? ? </tr> <?php ? ? ? } else { ?> ? ? ? ? ? <tr> ? ? ? ? ? ? <td class="main"><?php echo TEXT_BANK_STATUS; ?></td> ? ? ? ? ? ? <td class="main"><?php echo $banktransfer['banktransfer_status']; ?></td> ? ? ? ? ? </tr> <?php ? ? ? ? switch ($banktransfer['banktransfer_status']) { ? ? ? ? ? case 1: $error_val = TEXT_BANK_ERROR_1; break; ? ? ? ? ? case 2: $error_val = TEXT_BANK_ERROR_2; break; ? ? ? ? ? case 3: $error_val = TEXT_BANK_ERROR_3; break; ? ? ? ? ? case 4: $error_val = TEXT_BANK_ERROR_4; break; ? ? ? ? ? case 5: $error_val = TEXT_BANK_ERROR_5; break; ? ? ? ? ? case 8: $error_val = TEXT_BANK_ERROR_8; break; ? ? ? ? ? case 9: $error_val = TEXT_BANK_ERROR_9; break; ? ? ? ? } ?> ? ? ? ? ? <tr> ? ? ? ? ? ? <td class="main"><?php echo TEXT_BANK_ERRORCODE; ?></td> ? ? ? ? ? ? <td class="main"><?php echo $error_val; ?></td> ? ? ? ? ? </tr> ? ? ? ? ? <tr> ? ? ? ? ? ? <td class="main"><?php echo TEXT_BANK_PRZ; ?></td> ? ? ? ? ? ? <td class="main"><?php echo $banktransfer['banktransfer_prz']; ?></td> ? ? ? ? ? </tr> <?php ? ? ? } ? ? } ? ? if ($banktransfer['banktransfer_fax']) { ?> ? ? ? ? ? <tr> ? ? ? ? ? ? <td class="main"><?php echo TEXT_BANK_FAX; ?></td> ? ? ? ? ? ? <td class="main"><?php echo $banktransfer['banktransfer_fax']; ?></td> ? ? ? ? ? </tr> <?php ? ? } ? ? // end modification for banktransfer ?> ? ? ? ? </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> ? ? ? ? ? ? <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, $n=sizeof($order->products); $i<$n; $i++) { ? ? ? echo '? ? ? ? ? <tr class="dataTableRow">' . "\n" . ? ? ? ? ? '? ? ? ? ? ? <td class="dataTableContent" valign="top" align="right">' . $order->products[$i]['qty'] . ' x</td>' . "\n" . ? ? ? ? ? '? ? ? ? ? ? <td class="dataTableContent" valign="top">' . $order->products[$i]['name']; ? ? ? if (isset($order->products[$i]['attributes']) && (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']; ? ? ? ? ? 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" . ? ? ? ? ? '? ? ? ? ? ? <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"; ? ? } ?> ? ? ? ? ? <tr> ? ? ? ? ? ? <td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2"> <?php ? ? for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) { ? ? ? echo '? ? ? ? ? ? ? <tr>' . "\n" . ? ? ? ? ? '? ? ? ? ? ? ? ? <td align="right" class="smallText">' . $order->totals[$i]['title'] . '</td>' . "\n" . ? ? ? ? ? '? ? ? ? ? ? ? ? <td align="right" class="smallText">' . $order->totals[$i]['text'] . '</td>' . "\n" . ? ? ? ? ? '? ? ? ? ? ? ? </tr>' . "\n"; ? ? } ?> ? ? ? ? ? ? </table></td> ? ? ? ? ? </tr> ? ? ? ? </table></td> ? ? ? </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_DATE_ADDED; ?></b></td> ? ? ? ? ? ? <td class="smallText" align="center"><b><?php echo TABLE_HEADING_CUSTOMER_NOTIFIED; ?></b></td> ? ? ? ? ? ? <td class="smallText" align="center"><b><?php echo TABLE_HEADING_STATUS; ?></b></td> ? ? ? ? ? ? <td class="smallText" align="center"><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td> ? ? ? ? ? </tr> <?php ? ? $orders_history_query = tep_db_query("select orders_status_id, date_added, customer_notified, comments from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . tep_db_input($oID) . "' order by date_added"); ? ? if (tep_db_num_rows($orders_history_query)) { ? ? ? while ($orders_history = tep_db_fetch_array($orders_history_query)) { ? ? ? ? echo '? ? ? ? ? <tr>' . "\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) . "</td>\n"; ? ? ? ? } else { ? ? ? ? ? echo tep_image(DIR_WS_ICONS . 'cross.gif', ICON_CROSS) . "</td>\n"; ? ? ? ? } ? ? ? ? echo '? ? ? ? ? ? <td class="smallText">' . $orders_status_array[$orders_history['orders_status_id']] . '</td>' . "\n" . ? ? ? ? ? ? '? ? ? ? ? ? <td class="smallText">' . nl2br(tep_db_output($orders_history['comments'])) . ' </td>' . "\n" . ? ? ? ? ? ? '? ? ? ? ? </tr>' . "\n"; ? ? ? } ? ? } else { ? ? ? ? echo '? ? ? ? ? <tr>' . "\n" . ? ? ? ? ? ? '? ? ? ? ? ? <td class="smallText" colspan="5">' . TEXT_NO_ORDER_HISTORY . '</td>' . "\n" . ? ? ? ? ? ? '? ? ? ? ? </tr>' . "\n"; ? ? } ?> ? ? ? ? </table></td> ? ? ? </tr> ? ? ? <tr> ? ? ? ? <td class="main"><br><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'); ?></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> ? ? ? ? ? ? ? ? <td class="main"><b><?php echo ENTRY_NOTIFY_COMMENTS; ?></b> <?php echo tep_draw_checkbox_field('notify_comments', '', 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> ? ? ? ? <?php ? //begin PayPal_Shopping_Cart_IPN ? if (strtolower($order->info['payment_method']) == 'paypal' && isset($HTTP_GET_VARS['referer']) && $HTTP_GET_VARS['referer'] == 'ipn'){ ? ?> ? ? ? <td colspan="2" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a> <a href="' . tep_href_link(FILENAME_PAYPAL, tep_get_all_get_params(array('action','oID','referer'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td> ? <?php ? } else { ? ?> ? ? ? <td colspan="2" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP) . '</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> ? <?php ? }//else not paypal ? //end PayPal_Shopping_Cart_IPN ? ?> ? ? ? </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', 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"> ? ? ? ? ? ? ? ? <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> ? ? ? ? ? ? ? ? <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 (isset($HTTP_GET_VARS['cID'])) { ? ? ? $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']); ? ? ? $orders_query_raw = "select 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 = '" . (int)$cID . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by orders_id DESC"; ? ? } elseif (isset($HTTP_GET_VARS['status'])) { ? ? ? $status = tep_db_prepare_input($HTTP_GET_VARS['status']); ? ? ? $orders_query_raw = "select 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 = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$status . "' and ot.class = 'ot_total' order by o.orders_id DESC"; ? ? } else { ? ? ? $orders_query_raw = "select 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 = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by o.orders_id DESC"; ? ? } ? ? $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 ((!isset($HTTP_GET_VARS['oID']) || (isset($HTTP_GET_VARS['oID']) && ($HTTP_GET_VARS['oID'] == $orders['orders_id']))) && !isset($oInfo)) { ? ? ? ? $oInfo = new objectInfo($orders); ? ? ? } ? ? ? if (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) { ? ? ? ? echo '? ? ? ? ? ? ? <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" 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="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID')) . 'oID=' . $orders['orders_id']) . '\'">' . "\n"; ? ? ? } ?> ? ? ? ? ? ? ? ? <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> ? ? ? ? ? ? ? ? <td class="dataTableContent" align="right"><?php echo $orders['orders_status_name']; ?></td> ? ? ? ? ? ? ? ? <td class="dataTableContent" align="right"><?php if (isset($oInfo) && 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 ($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 (isset($oInfo) && 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> <a href="' . tep_href_link(FILENAME_EDIT_ORDERS, 'oID=' . $oInfo->orders_id). '">' . tep_image_button('button_update.gif', IMAGE_UPDATE) . '</a>'); ? ? $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $oInfo->orders_id) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $oInfo->orders_id) . '" TARGET="_blank">' . tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP) . '</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); ? ? ? //begin PayPal_Shopping_Cart_IPN ? if (strtolower($oInfo->payment_method) == 'paypal') { ? ? ? include_once(DIR_FS_CATALOG_MODULES . 'payment/paypal/database_tables.inc.php'); ? ? ? $paypal_payment_status_query = tep_db_query("select p.payment_status from " . TABLE_PAYPAL . " p left join " . TABLE_ORDERS . " o on p.paypal_ipn_id = o.paypal_ipn_id where o.orders_id ='" . $oInfo->orders_id . "'"); ? ? ? $paypal_payment_status = tep_db_fetch_array($paypal_payment_status_query); ? ? ? //quick work around for unkown order status id ? ? ? $paypal_payment_status_value = (tep_not_null($paypal_payment_status['payment_status'])) ? $paypal_payment_status['payment_status'] : $oInfo->orders_status_name ; ? ? ? $contents[] = array('text' => TABLE_HEADING_PAYMENT_STATUS . ': ' . $paypal_payment_status_value ); ? } ? //end PayPal_shopping_Cart_IPN ? ? ? } ? ? ? 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'); ?> Edited September 5, 2004 by taz1 Quote Link to comment Share on other sites More sharing options...
Druide Posted September 5, 2004 Share Posted September 5, 2004 Taz: please dont post file contents in the forum use PM instead, some people try to browse through the forum but you dont make it easy on us :( Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
taz1 Posted September 5, 2004 Share Posted September 5, 2004 Druide, sorry for that Quote Link to comment Share on other sites More sharing options...
e-dard Posted September 5, 2004 Share Posted September 5, 2004 Hi, I have just installed IPN 2.6a for the 2.2m version of oscommerce.. Did all instructions as specified in install guide. When i go into my admin/configuration/modules i get the following errors.. Warning: main(/usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/includes/languages/english/modules/payment/application_bottom.inc.php): failed to open stream: No such file or directory in /usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/admin/modules.php on line 128 Warning: main(): Failed opening '/usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/includes/languages/english/modules/payment/application_bottom.inc.php' for inclusion (include_path='.:/usr/local/psa/apache/lib/php') in /usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/admin/modules.php on line 128 Warning: main(/usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/includes/languages/english/modules/payment/application_top.inc.php): failed to open stream: No such file or directory in /usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/admin/modules.php on line 128 Warning: main(): Failed opening '/usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/includes/languages/english/modules/payment/application_top.inc.php' for inclusion (include_path='.:/usr/local/psa/apache/lib/php') in /usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/admin/modules.php on line 128 Any ideas anyone?? I did search the forums but i couldn't find any posts top help thanks. Edd Quote Link to comment Share on other sites More sharing options...
Undefined Posted September 5, 2004 Share Posted September 5, 2004 Hello,I'm still a bit confused on how to test my site before I go live. I'm going to list the steps I've taken, and would appreciate any feedback. I've turned Test Mode On, and have enabled the Cart Test. I start to place an order as a new customer, and stop when I get to the Paypal "Payment Details" page. I goto the Admin 'orders' page, and look at the order that has just been created: The top half of the screen has all of my customers information. The bottom half of the screen, under the Paypal section, all of the fields are blank except for: Transaction Signature: 89b789cb873a496ea62f11d9f1c4bf83 MC Currency: Settle Amount MC Gross: Settle Currency MC Fee: Exchange Rate The Products line shows: 1x Product Name Price$0.05 (that's the price I set for the item) USPS: 4.85 Total: 4.90 I assume this is normal for when using Test Mode On? The instructions say on the Test IPN Page say to: Copy and paste the Transaction Signature into the above Custom field and into the Transaction ID field The Transaction Signature from above pastes into the Custom field as: 89b789cb873a496ea62f11d9f1c4bf83 However, it pastes into the Tranaction ID field as: 89b789cb873a496ea Is it supposed to be truncated? I click the Test button, and receive the following results (I have changed my domain to @mydomain.com): Test Complete! ------------------------------------------------------ Debug ------------------------------------------------------ Original Post ------------------------------------------------------ [email protected] [email protected] verify_sign=PAYPAL_SHOPPING_CART_IPN-TEST_TRANSACTION-00000000000000 payment_date=14:50:02 Sep 4, 2004 PDT digest_key=e4e123ca815b34b53a3905dea9f77e24 first_name=John last_name=Doe payer_business_name=ACME Inc. payer_email=root@localhost payer_id=PAYERID000000 payer_status=verified invoice= address_name=John Doe address_street=1 Way Street address_city=NeverNever address_state=CA address_zip=12345 address_country=United States address_status=confirmed payment_type=instant txn_type=cart custom=89b789cb873a496ea62f11d9f1c4bf83 txn_id=89b789cb873a496ea num_cart_items=1 notify_version=1.6 memo=PAYPAL_SHOPPING_CART_IPN TEST mc_currency=USD mc_gross=4.90 mc_fee=0.01 settle_amount=0.00 settle_currency= exchange_rate=0.00 payment_status=Completed pending_reason= reason_code= submit=Test IPN Reconstructed Post ------------------------------------------------------ cmd=_notify-validate business=payment%40mydomain.com receiver_email=payment%40mydomain.com verify_sign=PAYPAL_SHOPPING_CART_IPN-TEST_TRANSACTION-00000000000000 payment_date=14%3A50%3A02+Sep+4%2C+2004+PDT digest_key=e4e123ca815b34b53a3905dea9f77e24 first_name=John last_name=Doe payer_business_name=ACME+Inc. payer_email=root%40localhost payer_id=PAYERID000000 payer_status=verified invoice= address_name=John+Doe address_street=1+Way+Street address_city=NeverNever address_state=CA address_zip=12345 address_country=United+States address_status=confirmed payment_type=instant txn_type=cart custom=89b789cb873a496ea62f11d9f1c4bf83 txn_id=89b789cb873a496ea num_cart_items=1 notify_version=1.6 memo=PAYPAL_SHOPPING_CART_IPN+TEST mc_currency=USD mc_gross=4.90 mc_fee=0.01 settle_amount=0.00 settle_currency= exchange_rate=0.00 payment_status=Completed pending_reason= reason_code= submit=Test+IPN ------------------------------------------------------ Invalid PayPal Response ------------------------------------------------------ Connection Type ------------------------------------------------------ curl= 1, socket= , domain= www.paypal.com, port= PayPal Response ------------------------------------------------------ INVALID ------------------------------------------------------ Email and Business ID config ------------------------------------------------------ Store Configuration Settings Primary PayPal Email Address: [email protected] Business ID: [email protected] ------------------------------------------------------ PayPal Configuration Settings Primary PayPal Email Address: [email protected] Business ID: [email protected] ------------------------------------------------------ IPN INSERTED ------------------------------------------------------ IPN 3 has been inserted Does the above show a successful test? Are there any test emails I need to look at at this point? Is it now safe to turn test mode off, and try some test transactions with paypal (I'm going to skip using the developer's zone) Thanks in advance, C I am having the exact same problem as Pulp. This being my first post I would like to say that osCommerce is great and so is this contribution from what I can see so far. Any tips or suggestions would be greatly appreciated. Thanks in advance. Quote Link to comment Share on other sites More sharing options...
e-dard Posted September 6, 2004 Share Posted September 6, 2004 Hi, I have just installed IPN 2.6a for the 2.2m version of oscommerce.. Did all instructions as specified in install guide. When i go into my admin/configuration/modules i get the following errors.. CODE Warning: main(/usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/includes/languages/english/modules/payment/application_bottom.inc.php): failed to open stream: No such file or directory in /usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/admin/modules.php on line 128 Warning: main(): Failed opening '/usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/includes/languages/english/modules/payment/application_bottom.inc.php' for inclusion (include_path='.:/usr/local/psa/apache/lib/php') in /usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/admin/modules.php on line 128 Warning: main(/usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/includes/languages/english/modules/payment/application_top.inc.php): failed to open stream: No such file or directory in /usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/admin/modules.php on line 128 Warning: main(): Failed opening '/usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/includes/languages/english/modules/payment/application_top.inc.php' for inclusion (include_path='.:/usr/local/psa/apache/lib/php') in /usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/admin/modules.php on line 128 Any ideas anyone?? I did search the forums but i couldn't find any posts top help thanks. Edd For anyone who thinks they can help here is the modules.php code around line 128 $installed_modules = array(); for ($i=0, $n=sizeof($directory_array); $i<$n; $i++) { $file = $directory_array[$i]; include(DIR_FS_CATALOG_LANGUAGES . $language . '/modules/' . $module_type . '/' . $file); include($module_directory . $file); $class = substr($file, 0, strrpos($file, '.')); if (tep_class_exists($class)) { $module = new $class; if ($module->check() > 0) { if ($module->sort_order > 0) { $installed_modules[$module->sort_order] = $file; } else { $installed_modules[] = $file; } } Thanks alot guys. Edd Quote Link to comment Share on other sites More sharing options...
taz1 Posted September 6, 2004 Share Posted September 6, 2004 Ok i found a prob in the languages files, i chaned paypal to paypal - something :-( my orders output looks like this now: but i didn't get the ipn test to work. When i use Transaction Type: send_money it works even with a shuffle number. When i use the Transaction Type: cart i always get the error not a valid Transaction ID. Also my Transaction ID is much more larger and i used only the first 17 of the range. So does someone have an idea ? The other thin is the Stock update. how can i setup to update the stock ? I prefer to update the stock after the customer is redirected to the paypal site. Any ideas ? Quote Link to comment Share on other sites More sharing options...
Guest Posted September 6, 2004 Share Posted September 6, 2004 edard, I had errors similar to yours. What I ended up doing was getting a fresh copy of the affected file from a new OSc download, and then follow the install procedures for the IPN contrib again - double checking that everything was done to the letter. I found that I hadn't completely deleted the paypal directory and my affected file was also corrupt. I'm not real familiar with the functions of php, but my guess is that this directory doesn't exist on your side? DIR_FS_CATALOG_LANGUAGES Quote Link to comment Share on other sites More sharing options...
Druide Posted September 7, 2004 Share Posted September 7, 2004 Hi, I have just installed IPN 2.6a for the 2.2m version of oscommerce.. Did all instructions as specified in install guide. When i go into my admin/configuration/modules i get the following errors.. CODE Warning: main(/usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/includes/languages/english/modules/payment/application_bottom.inc.php): failed to open stream: No such file or directory in /usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/admin/modules.php on line 128 Warning: main(): Failed opening '/usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/includes/languages/english/modules/payment/application_bottom.inc.php' for inclusion (include_path='.:/usr/local/psa/apache/lib/php') in /usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/admin/modules.php on line 128 Warning: main(/usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/includes/languages/english/modules/payment/application_top.inc.php): failed to open stream: No such file or directory in /usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/admin/modules.php on line 128 Warning: main(): Failed opening '/usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/includes/languages/english/modules/payment/application_top.inc.php' for inclusion (include_path='.:/usr/local/psa/apache/lib/php') in /usr/local/psa/home/vhosts/*****.com/httpdocs/catalog/admin/modules.php on line 128 Any ideas anyone?? I did search the forums but i couldn't find any posts top help thanks. Edd For anyone who thinks they can help here is the modules.php code around line 128 $installed_modules = array(); for ($i=0, $n=sizeof($directory_array); $i<$n; $i++) { $file = $directory_array[$i]; include(DIR_FS_CATALOG_LANGUAGES . $language . '/modules/' . $module_type . '/' . $file); include($module_directory . $file); $class = substr($file, 0, strrpos($file, '.')); if (tep_class_exists($class)) { $module = new $class; if ($module->check() > 0) { if ($module->sort_order > 0) { $installed_modules[$module->sort_order] = $file; } else { $installed_modules[] = $file; } } Thanks alot guys. Edd looking at your errors m/httpdocs/catalog/includes/languages/english/modules/payment/application_top.inc.php that tells me you uploaded the files to the wrong locations there is NO SUCH FILE THERE and i have Paypal IPN 2.6a too installed works 100% out of the box IF you do EXACTLY what Gregory explains in the contribution Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
Guest Posted September 7, 2004 Share Posted September 7, 2004 Okay, so I started installing this contribution and got to the part where I was to copy catalog/info_paypal.php and it was not in the zip file. Anyone know why or where I can get it if I need it? Thanks! Quote Link to comment Share on other sites More sharing options...
Undefined Posted September 7, 2004 Share Posted September 7, 2004 Okay, so I started installing this contribution and got to the part where I was to copy catalog/info_paypal.php and it was not in the zip file. Anyone know why or where I can get it if I need it? Thanks! v2.6 users can just copy over the contrib files, however catalog/info_paypal.php has now been renamed to popup_paypal.php for STS compatibility This is in the release notes of the PayPal_Shopping_Cart_IPN version 2.6a, that is why there is no info_papypal.php Quote Link to comment Share on other sites More sharing options...
Guest Posted September 7, 2004 Share Posted September 7, 2004 if you read a bit further, you will see the file has changed names. the instructions tell this. Quote Link to comment Share on other sites More sharing options...
Undefined Posted September 7, 2004 Share Posted September 7, 2004 (edited) Just wanted to say thumbs up to greg and the developers of the osC cart. I got my problem fixed and everything is ok. Thanks for all your help. Edited September 7, 2004 by Undefined Quote Link to comment Share on other sites More sharing options...
Guest Posted September 7, 2004 Share Posted September 7, 2004 I've just finished an upgrade to 2.6a and now my admin/customers/orders screen is not updating. Has anyone come across this? Is there an easy fix? Quote Link to comment Share on other sites More sharing options...
Guest Posted September 7, 2004 Share Posted September 7, 2004 Nevermind. Lol I just found out that the customers had paid directly with paypal and not via the webstore. That's why there are no orders. Communication is everything, eh? Quote Link to comment Share on other sites More sharing options...
Undefined Posted September 7, 2004 Share Posted September 7, 2004 Well, Ithought i had it fixed, but as soon as i changed the e-mail info to the account i have set up on paypal It started back with the same thing. In the order section no info what so ever in the paypal information section accept for a long transaction signature. Also when I changed e-mails the debug e-mails stopped coming in. I'll keep trying to see whats going on, but if anyone has any recommendations or tips they would be greatly appreciated. Quote Link to comment Share on other sites More sharing options...
Undefined Posted September 7, 2004 Share Posted September 7, 2004 disregard.... silly me. Great contribution to a great cart. Sorry for taking up space with my countless and useless posts Quote Link to comment Share on other sites More sharing options...
Undefined Posted September 7, 2004 Share Posted September 7, 2004 does anyone know why when after a purchase is complete, and I return from paypal to the checkout_success page the url in my browser says catalog/checkout_success.php?action=success&tx=8Y668775UK2958430&st=Completed&amt=12.99&cc=USD&cm=56a8e2b1c627c475d9d03ce058d68cce&sig=pVMQrCWeWJ8/%2Bqx0Oj1sFDT7104zmxIRdMnNMufi7TPT0D0C6Kj4dmbIwxV8XMpPeN6T5kIOz7/gE9U4uvDtq19lsbZNNlFQUz91eJRvPU31rsJhpZx9uYclGyXUvGIqdpXQk4a3YaGsjZikxtYhwyU7kSE K0CFGNu2K%2BImQWvs%3D I think this is the root of my problem.... also my debug e-mails stopped once again Quote Link to comment Share on other sites More sharing options...
mrsC2003 Posted September 8, 2004 Share Posted September 8, 2004 I don't want to seem like I am complaining here because I am very thankful to all those who contribute. But there are so many folders in this contribution with so many of the same files, (I do mean the same because I used compare and merge to try and figure things out.) Which folder do I use ? There are even folders inside of folders that are inside of folders that have the complet file directory inside of them all over again. Why would you need to place so many replications in a contribution? Kel Quote I live in my own little world. But it's OK. They know me here. Link to comment Share on other sites More sharing options...
Druide Posted September 8, 2004 Share Posted September 8, 2004 I don't want to seem like I am complaining here because I am very thankful to all those who contribute. But there are so many folders in this contribution with so many of the same files, (I do mean the same because I used compare and merge to try and figure things out.) Which folder do I use ? There are even folders inside of folders that are inside of folders that have the complet file directory inside of them all over again. Why would you need to place so many replications in a contribution? Kel Kelley just do like Gregory explains in his GREAT and complete tutorial/install instructions, do yourself a favor and dont merge with original osc files because you get sooooooo stuck that you have to delete all your hard work. TRUST ME on this...LOL (i have some experience with it) Follow the install instructions and you will be able to update this contribution too, otherwise you will have to do everything all over again, and you dont want to go THERE ! There is only ONE way to injstall this contributionm the right way. Good luck on your decision ! Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
Druide Posted September 8, 2004 Share Posted September 8, 2004 for people using this contribution and who want to have a link in their admin area to login their paypal account quickly... add in admin/includes/boxes/customers.php '<a href="https://www.paypal.com/cgi-bin/webscr?cmd=_login-run&login_email=' . MODULE_PAYMENT_PAYPAL_BUSINESS_ID . '" class="menuBoxContentLink" target="paypal"><b><font color=purple>Login @ PayPal</font></a></b><br>' . you can do the same with the password (&login_password=) but since security is HOLY ;) we don't do that, and you don't either ! Don't even try... Thats too much of a risk for your information Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
Guest Posted September 8, 2004 Share Posted September 8, 2004 (edited) Greg, I kept reading your previous post and it finally struck me that the paypal ipn table auto increment had started over at 1. I set it to 77 according to the orders table, but I'm unsure if that was the correct table to check/high enough number. Is there another table I can look at to see what number I need to set the paypal ipns to begin? I want to make sure I get it right. :) This is the only thing remaining from what you mentioned that could be causing the issue of customers not being able to 'pay' with paypal. (logs them out when they hit the 'pay' buttoon) again, thank you for such a wonderful contrib and ongoing support! Edited September 8, 2004 by StarryJen Quote Link to comment Share on other sites More sharing options...
Druide Posted September 8, 2004 Share Posted September 8, 2004 does anyone know why when after a purchase is complete, and I return from paypal to the checkout_success page the url in my browser says catalog/checkout_success.php?action=success&tx=8Y668775UK2958430&st=Completed&amt=12.99&cc=USD&cm=56a8e2b1c627c475d9d03ce058d68cce&sig=pVMQrCWeWJ8/%2Bqx0Oj1sFDT7104zmxIRdMnNMufi7TPT0D0C6Kj4dmbIwxV8XMpPeN6T5kIOz7/gE9U4uvDtq19lsbZNNlFQUz91eJRvPU31rsJhpZx9uYclGyXUvGIqdpXQk4a3YaGsjZikxtYhwyU7kSE K0CFGNu2K%2BImQWvs%3D I think this is the root of my problem.... also my debug e-mails stopped once again That means you have PayPals PDT function enabled....LOL What that is ? paypal.typepad.com/ paypaltech.com/how-to/PDTvsIPN.htm Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
mijman2 Posted September 8, 2004 Share Posted September 8, 2004 Hi everyone, Great Contrib everything is working nicely. When I customer starts check out but decides not to pay, Do items in cart still count as items purchased? Does the stock go down? Is there a way to make it so that stock only goes down on successful payment? (if not already happening) Quote Link to comment Share on other sites More sharing options...
Druide Posted September 9, 2004 Share Posted September 9, 2004 Hi everyone,Great Contrib everything is working nicely. When I customer starts check out but decides not to pay, Do items in cart still count as items purchased? Does the stock go down? Is there a way to make it so that stock only goes down on successful payment? (if not already happening) look for the addon i wrote http://www.oscommerce.com/community/contributions,2416 which does exactly what you want BUT there are still some issues to figure out, i would not suggest to use it on a production site but just to test it. It's a contribution in development, when a customer pays by bank or credit card this 'addon' does NOT funtion properly i noticed 2day because it substracts the stock ONLY when a IPN Pending or Completed is received. I dunno when i can work on this more because i will be out of town most of the next 2 weeks, also my bithday in between where is the time that i need ? I guess something has to be put 'on hold' like the PayPal_Shopping_Cart_IPN_v2.6a (addon only) i wrote Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.