PayPal

[jareau]

Originally Posted by nmb1

im running 4.1.5 and i cant get it work either, sign up works, payment taken, subscriber table is populated, but it says account expired when you try to log in

In your PAYMENT.PHP file, do this:

Find this:

 $return = $config['BASE_URL']. '/pmt_success.php?pack=' .$pack_id. '&is_success=1&period=' .$s_period.';

Replace it with this:

 $return = $config['BASE_URL']. '/pmt_success.php?pack=' .$pack_id. '&is_success=1&period=' .$s_period. '&a='.$UID.'';

NOTICE the last variable a='.$UID.' ... this is going to place your new users ID in the URL


--Then--

Go to your PMT_SUCCESS.PHP file and add this directly under the 2 "require" statements:

$pack_id = ( isset($_GET['pack']) ) ? intval($_GET['pack']) : NULL;
$userid = ( isset($_GET['a']) ) ? intval($_GET['a']) : NULL;

The above pieces of code will get your PACK id and UserID from the URL, and make them available for the SQL statement


Next

Find this code:

$is_success = 'false';
if ( isset($_GET['is_success']) && $_GET['is_success'] ) {
	$success = 'true';
	STemplate::assign('exp_date', date('Y-m-d', strtotime("+$_GET[period]")));

And replace it with this code

$is_success = 'false';
if ( isset($_GET['is_success']) && $_GET['is_success'] ) {
	$success = 'true';
	STemplate::assign('exp_date', date('Y-m-d', strtotime("+$_GET[period]")));

	$expired_time = date("Y-m-d H:i:s", strtotime("+$_GET[period]"));

	$sql = "update subscriber set
			pack_id=$pack_id,
			subscribe_time='".date("Y-m-d H:i:s")."',
			expired_time='$expired_time'
			where UID = $userid";
	$conn->execute($sql);
	
	$sql = "update signup set
			account_status = 'Active'
			where UID=$userid";
	$conn->execute($sql);
}

[ushanbb]

I found this worked for me - and I have to tell you it is a monkey off my back.

I highly recommend the fix to anyone who wants paypal and subscriptions working together on their site.

Thank you!!

Originally Posted by jareau

In your PAYMENT.PHP file, do this:

Find this:

 $return = $config['BASE_URL']. '/pmt_success.php?pack=' .$pack_id. '&is_success=1&period=' .$s_period.';

Replace it with this:

 $return = $config['BASE_URL']. '/pmt_success.php?pack=' .$pack_id. '&is_success=1&period=' .$s_period. '&a='.$UID.'';

NOTICE the last variable a='.$UID.' ... this is going to place your new users ID in the URL


--Then--

Go to your PMT_SUCCESS.PHP file and add this directly under the 2 "require" statements:

$pack_id = ( isset($_GET['pack']) ) ? intval($_GET['pack']) : NULL;
$userid = ( isset($_GET['a']) ) ? intval($_GET['a']) : NULL;

The above pieces of code will get your PACK id and UserID from the URL, and make them available for the SQL statement


Next

Find this code:

$is_success = 'false';
if ( isset($_GET['is_success']) && $_GET['is_success'] ) {
	$success = 'true';
	STemplate::assign('exp_date', date('Y-m-d', strtotime("+$_GET[period]")));

And replace it with this code

$is_success = 'false';
if ( isset($_GET['is_success']) && $_GET['is_success'] ) {
	$success = 'true';
	STemplate::assign('exp_date', date('Y-m-d', strtotime("+$_GET[period]")));

	$expired_time = date("Y-m-d H:i:s", strtotime("+$_GET[period]"));

	$sql = "update subscriber set
			pack_id=$pack_id,
			subscribe_time='".date("Y-m-d H:i:s")."',
			expired_time='$expired_time'
			where UID = $userid";
	$conn->execute($sql);
	
	$sql = "update signup set
			account_status = 'Active'
			where UID=$userid";
	$conn->execute($sql);
}

[stav]

You must block direct access to the pmt_success.php
The referrer must be paypal

Becouse if user go manualy to submit this url

http://www.yourdomain.com/pmt_succes...=1Month& a=26

where pack=2 is the id of the pack
period=1Month or 1Year is for how long wil update the subscription
a=26 is the user id that will be updated

The subscription will be updated in the database without paypal payment