Jump to content
Sign in to follow this  
devosc

[Contribution]Paypal IPN - Devosc

Recommended Posts

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 by taz1

Share this post


Link to post
Share on other sites

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 :(


Robert

 

We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;)

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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

------------------------------------------------------

business=payment@mydomain.com

receiver_email=payment@mydomain.com

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: payment@mydomain.com

Business ID: payment@mydomain.com

------------------------------------------------------

PayPal Configuration Settings

Primary PayPal Email Address: payment@mydomain.com

Business ID: payment@mydomain.com

 

 

 

------------------------------------------------------

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.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

Ok i found a prob in the languages files, i chaned paypal to paypal - something :-(

 

my orders output looks like this now: paypal.gif

 

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 ?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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


Robert

 

We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;)

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

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 by Undefined

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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


I live in my own little world. But it's OK. They know me here.

Share this post


Link to post
Share on other sites
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 !


Robert

 

We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;)

Share this post


Link to post
Share on other sites

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


Robert

 

We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;)

Share this post


Link to post
Share on other sites

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 by StarryJen

Share this post


Link to post
Share on other sites
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


Robert

 

We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;)

Share this post


Link to post
Share on other sites

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)

Share this post


Link to post
Share on other sites
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


Robert

 

We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×