Paypal_shopping_cart_IPN 3.1.5 and PHP5

[trevorgreen]

My shop is hosted on my friends computer and he just upgraded to PHP5. I applied all the recommended changes to OS Commerce but my Paypal shopping cart IPN 3.1.5 no longer works. Does anyone know what changes I need to make to make it PHP 5 compliant?

[iecwillow]

I got problem in Paypal_Shopping_Cart_IPN and PHP5 too.

 

It happened since I moved the site to another hosting company, the difference as I know is PHP Version changed to 5.2.3, and now the status of my order won't changed, transaction activity always shows:

 

No PayPal Transaction Information Available.

 

 

I have to check the emails I received from Paypal and manually change the status one by one.

 

Anyone please help?

Edited November 21, 2008 by iecwillow

[iecwillow]

Just received the following notice from Paypal:

 

Please check your server that handles PayPal Instant Payment Notifications (IPN). IPNs sent to the following URL(s) are failing:

 

ipn.php

 

If you do not recognize this URL, you may be using a service provider that is using IPN on your behalf. Please contact your service provider with the above information. If this problem continues, IPNs may be disabled for your account.

 

Thank you for your prompt attention to this issue.

 

Anyone please help? Thanks for any advice.

[satish]

probably the IPN code not in place or no proper permission on that IPN code.

 

Satish

[Guest]

Just received the following notice from Paypal:

 

Please check your server that handles PayPal Instant Payment Notifications (IPN). IPNs sent to the following URL(s) are failing:

 

ipn.php

 

In your paypal account > profile summary > Instant Payment Notification Preferences > Instant Payment Notification (IPN) URL:

you need to specify the entire URL (http://.....) - maybe you only provided a relative URL which would work internally on your site but not for paypal?

[iecwillow]

In your paypal account > profile summary > Instant Payment Notification Preferences > Instant Payment Notification (IPN) URL:

you need to specify the entire URL (http://.....) - maybe you only provided a relative URL which would work internally on your site but not for paypal?

 

I actually always leave it blank, and never got the problem before. And I just confirmed with my friend's working site, he also leave the Instand Payment Notification URL blank but the status post back to the shopping cart without any problem.

[iecwillow]

I received another email from Paypal saying:

 

After checking with technician about IPN issue, I was notified that they found you set incorrect value for the variable 'notify_url', the value you are using at this moment is 'ipn.php' ,which obviously is not a complete and valid URL. Besides, the URL for both variable 'return' and 'cancel_return' are invalid. So

some variables are missing at your site, as a result, you send a relative address instead of the absolute address in this case. You need to fix it at your side. Please try to contact third party provider to work out the issue.

[satish]

If You look into the class file You will find values for notifu url and other values.

 

Probably your configuaration values might be messing up.

 

so just place actual hard code value.

 

Satish

[iecwillow]

Do you mean the IPN.class which is stored in catalog/includes/modules/payment/paypal/classes/ folder? I actually did not change anything here, and as I remember, this modules really do not need to manually provided the 'notify_url' or 'return url'.

 

Could you please take a look at the code of my IPN.class file and let me know if anything I need to change? Thank you.

 

Below is the code of IPN.class:

 

<?php
/*
 $Id: IPN.class.php,v 1.1.1.1 2004/09/22 13:45:13 devosc Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 DevosC, Developing open source Code
 http://www.devosc.com

 Copyright (c) 2003 osCommerce
 Copyright (c) 2004 DevosC.com

 Released under the GNU General Public License

*/

//admin workaround!
$modules_directory = defined('DIR_FS_CATALOG_MODULES') ? DIR_FS_CATALOG_MODULES : DIR_WS_MODULES;

require_once($modules_directory . 'payment/paypal/classes/Client/Connector.class.php');

class PayPal_IPN extends PayPal_Client_Connector {

 function PayPal_IPN($post_vars) {
global $debug;
if (!in_array($post_vars['payment_type'],array('instant','echeck'))) {
  if ($debug->enabled) $debug->add(UNKNOWN_TXN_TYPE,sprintf(UNKNOWN_TXN_TYPE_MSG,$post_vars['payment_type']));
} else if(strlen($post_vars['txn_id']) == 17) {
  $this->init($post_vars); //Looks like a PayPal transaction
} else {
  if ($debug->enabled) $debug->add(UNKNOWN_POST,sprintf(UNKNOWN_POST_MSG,$_SERVER['REMOTE_ADDR']));
}
$this->setTestMode('Off');
register_shutdown_function(array($this,'_PayPal_IPN'));
 }

 function _PayPal_IPN() {
global $debug;
if ($debug->enabled) $debug->sendEmail();
 }

 function init($post_vars) {
global $debug;
$debug_string = '';
$this->key = array();
$this->response_string = 'cmd=_notify-validate';
reset($post_vars);
foreach ($post_vars as $var => $val) {
  $var = urldecode($var); $val = stripslashes(urldecode($val));
  if ($debug->enabled) $debug_string .= $var . '=' . $val .'&';
  if (!strcasecmp($var,'cmd') || !eregi("^[_0-9a-z-]{1,32}$",$var)) {
	unset($var); unset($val);
  } elseif (!empty($var)) {
	if($var === 'custom') {
	  $this->setTxnSignature($val);
	} else {
	  $this->key[$var] = $val;
	}
	$this->response_string .= '&' . urlencode($var) . '=' . urlencode($val);
  }
}
if ($debug->enabled) $debug->init($debug_string);
unset($post_vars, $debug_string);
 }

 function insert($paypal_id = '') {
global $debug;
$key_vars = array(
	'txn_type', 'reason_code', 'payment_type',
	'payment_status', 'pending_reason', 'invoice',
	'mc_currency', 'first_name', 'last_name',
	'payer_business_name', 'address_name', 'address_street',
	'address_city', 'address_state', 'address_zip',
	'address_country', 'address_status', 'payer_email',
	'payer_id', 'payer_status', 'business',
	'receiver_email', 'receiver_id', 'txn_id',
	'parent_txn_id', 'mc_gross', 'mc_fee',
	'payment_gross', 'payment_fee', 'settle_amount',
	'settle_currency', 'exchange_rate', 'for_auction',
	'auction_buyer_id', 'auction_multi_item',
	'quantity', 'tax', 'notify_version',
	'verify_sign', 'memo'
  );
$sql_data_array = $this->setSQLDataElements($key_vars);
$sql_data_array['num_cart_items'] = $this->txnType('cart') ? $this->key['num_cart_items'] : '1';
$sql_data_array['payment_date'] = $this->datetime_to_sql_format($this->key['payment_date']);
$sql_data_array['payment_time_zone'] = $this->paymentTimeZone($this->key['payment_date']);
$sql_data_array['auction_closing_date'] = $this->datetime_to_sql_format($this->key['auction_closing_date']);
$sql_data_array['date_added'] = 'now()';
tep_db_perform(TABLE_PAYPAL, $sql_data_array);
$this->ipnID = tep_db_insert_id();
$this->updatePaymentStatusHistory( !empty($paypal_id) ? $paypal_id : $this->ipnID );
if($this->isAuction()) $this->processAuction($this->ipnID);
if($debug->enabled) $debug->add(IPN_TXN_INSERT,sprintf(IPN_TXN_INSERT_MSG,$this->ipnID));
return $this->ipnID;
 }

 function updatePaymentStatusHistory($paypal_id) {
$sql_data_array  = $this->setSQLDataElements(array('payment_status', 'pending_reason', 'reason'));
$sql_data_array['paypal_id'] = $paypal_id;
$sql_data_array['date_added'] = 'now()';
tep_db_perform(TABLE_PAYPAL_PAYMENT_STATUS_HISTORY, $sql_data_array);
 }

 function updateStatus($paypal_id) {

$key_vars = array(
					'first_name', 'last_name', 'payer_business_name',
					'address_name', 'address_street', 'address_city',
					'address_state','address_zip', 'address_country',
					'address_status',
					'mc_gross', 'mc_currency', 'mc_fee',
					'settle_amount', 'settle_currency',
					'exchange_rate',
					'payment_status'
				 );
$sql_data_array  = $this->setSQLDataElements($key_vars);
$sql_data_array['last_modified'] = 'now()';
tep_db_perform(TABLE_PAYPAL, $sql_data_array, 'update', "paypal_id = '" . (int)$paypal_id . "'");
$this->updatePaymentStatusHistory($paypal_id);
 }

 function updateOrderStatus($paypal_id,$status) {
//Orders
$sql_data_array = array(
						  'orders_status'	=> tep_db_input($status),
						  'last_modified'	=> 'now()'
						);
tep_db_perform(TABLE_ORDERS, $sql_data_array, 'update', "payment_id = '" . (int)$paypal_id . "'");

//Orders Status History
$sql_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where payment_id = '" . (int)$paypal_id . "'");
$sql_result = tep_db_fetch_array($sql_query);
$sql_data_array = array(
						  'orders_id'	 => $sql_result['orders_id'],
						  'orders_status_id' => tep_db_input($status),
						  'date_added'	=> 'now()'
						);
tep_db_perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array, 'insert');
 }

 function queryTxnID($txn_id) {
$sql_query = tep_db_query("select paypal_id from " . TABLE_PAYPAL . " where txn_id = '" . tep_db_input($txn_id) . "' limit 0,1");
return tep_db_fetch_array($sql_query);
 }

 function queryPendingStatus($txn_id) {
$sql_query = tep_db_query("select paypal_id, payment_status, pending_reason from " . TABLE_PAYPAL . " where txn_id = '" . tep_db_input($txn_id) . "' limit 0,1");
return tep_db_fetch_array($sql_query);
 }

 function authenticate($domain, $success = 'VERIFIED') {
$paypal_response = $this->getResponse($domain);
$paypal_verification = $this->getVerificationResponse($paypal_response);
return strstr($paypal_verification,$success);
 }

 function uniqueTxnID() {
global $debug;
if (isset($this->uniqueTxnID)) {
  return $this->uniqueTxnID;
} else {
  $txn_id_query = tep_db_query("select txn_id from " . TABLE_PAYPAL . " where txn_id = '" . tep_db_input($this->txnID()) . "' limit 0,1");
  if (!tep_db_num_rows($txn_id_query)) { //txn_id doesn't exist
	$this->uniqueTxnID = true;
	return $this->uniqueTxnID;
  } else {
	if($debug->enabled) $debug->add(TXN_DUPLICATE,sprintf(TXN_DUPLICATE_MSG,$this->txnID()));
	$this->uniqueTxnID = false;
	return $this->uniqueTxnID;
  }
}
 }

 function validPayment($amount,$currency) {
if (MODULE_PAYMENT_PAYPAL_IPN_CART_TEST == 'Off') return true;
return parent::validPayment($amount,$currency);
 }

 //returns TABLE_PAYPAL.paypal_id
 function ID() {
return $this->ipnID;
 }

 function txnID() {
return $this->key['txn_id'];
 }

 //returns the transaction type (paypal.txn_type)
 function txnType($txnTypeName = '') {
if(!empty($txnTypeName)) {
  return ($this->key['txn_type'] === $txnTypeName);
}

return $this->key['txn_type'];
 }

 function paymentStatus($statusName = '') {
if(!empty($statusName)) {
  return ($this->key['payment_status'] == $statusName);
}

return $this->key['payment_status'];
 }

 function isCartPayment() {
return in_array($this->key['txn_type'],array('web_accept','cart'));
 }

 function isReversal() {
return in_array($this->key['payment_status'],array('Refunded','Reversed','Canceled_Reversal'));
 }

 function reversalType() {
return $this->key['payment_status'];
 }

 function datetime_to_sql_format($paypalDateTime) {
$months = array('Jan' => '01', 'Feb' => '02', 'Mar' => '03', 'Apr' => '04', 'May' => '05',  'Jun' => '06',  'Jul' => '07', 'Aug' => '08', 'Sep' => '09', 'Oct' => '10', 'Nov' => '11', 'Dec' => '12');
$array = explode(" ",$paypalDateTime);
$time = explode(":",$array[0]);
$hour = $time[0];$minute = $time[1];$second = $time[2];
$month = $months[$array[1]];
$day = substr_replace($array[2],'',-1,1);
$year = $array[3];
return ($year . "-" . $month . "-" . $day . " " . $hour . ":" . $minute . ":" . $second);
 }

 function paymentTimeZone($paypalDateTime) {
$array = explode(" ",$paypalDateTime);
return $array[4];
 }

 function setSQLDataElements($varnames) {
$sql_data_array = array();
$nVars = count($varnames);
for($i=0; $i<$nVars; $i++) {
  if(isset($this->key[$varnames[$i]]) && !empty($this->key[$varnames[$i]]) && trim($this->key[$varnames[$i]]) != '')
	$sql_data_array[$varnames[$i]] = $this->key[$varnames[$i]];
}
return $sql_data_array;
 }

 function isAuction() {
return (isset($this->key['for_auction']) && $this->key['for_auction'] === 'true');
 }

 function processAuction($paypal_id) {
if(defined('TABLE_PAYPAL_AUCTION')) {
  if($this->isAuction() && strlen($this->key['item_number']) > 0) {
	$items = explode(',', $this->key['item_number']);
	foreach($items as $key => $item_id) {
	  // Save the auction IDs for correlation later
	  $txn_check = tep_db_query("select auction_buyer_id from " . TABLE_PAYPAL_AUCTION . " where paypal_id = '" . (int)$paypal_id . "' and item_number = '" . tep_db_input($item_id) . "'");
	  if (!tep_db_num_rows($txn_check)) {
		$sql_data_array = $this->setSQLDataElements(array('auction_buyer_id','auction_multi_item'));
		$sql_data_array['paypal_id'] = (int)$paypal_id;
		$sql_data_array['item_number'] = $item_id;
		tep_db_perform(TABLE_PAYPAL_AUCTION, $sql_data_array);
	  }
	 }
   }
}
 }

 function setTxnSignature($txnSignature = '') {
if(!isset($this->txnSignature)) $this->txnSignature = $txnSignature;
 }

 function txnSignature() {
return $this->txnSignature;
 }

 /*
 //Test that the store owner's 'custom' transaction signature doesn't exist
 //Really this is only for preventing mistakes via the IPN Test Panel
 function uniqueTxnSignature() {
global $debug;

if(!$this->isTestMode()) return true;

if (isset($this->uniqueTxnSignature)) {
  return $this->uniqueTxnSignature;
} else {
  $txn_sign_query = tep_db_query("select txn_sign from " . TABLE_PAYPAL . " where txn_sign = '" . tep_db_input($this->txnSignature()) . "' limit 0,1");
  if (!tep_db_num_rows($txn_sign_query)) { //txn_sign doesn't exist
	$this->uniqueTxnSignature = true;
	return $this->uniqueTxnSignature;
  } else {
	if($debug->enabled) $debug->add(TXN_DUPLICATE_SIGNATURE,sprintf(TXN_DUPLICATE_SIGNATURE_MSG,$this->txnSignature()));
	$this->uniqueTxnSignature = false;
	return $this->uniqueTxnSignature;
  }
}
 }*/
}//end class
?>