Raven 76 v2 and NSN PayPal Question

Posted: Wed Jan 25, 2006 8:39 am

Ok, first off let me disclaimer - I realize NSN PayPal is a paid script - so if any of the Admins do not want this answered here, go ahead and remove in advance. But PM me please!! HA

Has anything been 'adjusted' in NSN Groups for the Raven 76 distro that would cause the NSN PayPal script to not work just 'out of the box'.

Everything loads up fine, everything runs through fine, paypal payment is made, the testing email is sent and the variables look good. The only thing that does not happen is the user's addition to the group.

I am fine tooth combing the code (disclaimer 2: which I paid for about a year ago) now, but I am stumped.

Also, can someone please explain to me the scenarios in which if (eregi statements need to be changed to if defined statements?

I have seen one or two statements in the NSN PayPal code that might fall into that scenario, but I am not sure I understand that part fully enough to intelligently speak on it as of yet...

Thanks in advance,

-sting

Posted: Wed Jan 25, 2006 8:49 am

The problem is *probably* with Paypal IPN system - they made some changes recently and as is their normal way of doing business deemed it not important enough to tell anyone.
http://www.paypaldev.org/topic.asp?TOPIC_ID=12191

This change has affected a number of scripts I use myself.

Posted: Wed Jan 25, 2006 9:20 am

Great lead - thanks, and it could be the right one. The returned value for option_name1 caught my attention last night, but had not gotten far enough in the code yet to research. Will focus there.

Thanks Guardian.

-sting

Posted: Wed Jan 25, 2006 9:28 am

Ok - a quick glance at the variables yields that they are actually being returned with data - which does not appear to be problematic at this time as they are defined within the NSN PayPal script itself.

Do you know of a way (potentially) to call the ipn referenced php file directly (by going to a URL) and passing test variables to it that are crafted like the Paypal page?

Thanks again

-sting

Posted: Wed Jan 25, 2006 9:33 am

Yes, I'm having the same problem with E-Solution which handles subsciptions on one of my sites as it too uses that variable and causes the users subscription to be processed with the same start and end date due to the pass-back for that variable no longer working in IPN due to the change at paypal.[/code]

Posted: Wed Jan 25, 2006 9:38 am

My system has two subscriptions.
1 month subscripton and 12 month subscription.
PayPal returns the variable "item_number: 4" for monthly and "item_number: 6" for 12 month.
So I created some extra switch/case elements to deal with those in my file that processes the IPN communication.

Code:

switch ($_PAYPAL[item_number]) { 


case "4": 


$_PAYPAL[option_name1]=12; 


break; 


case "6": 


$_PAYPAL[option_name1]=1; 


break; 


}

This might give you a clue as I am not familiar with the specific script you are using.

Posted: Wed Jan 25, 2006 1:33 pm

Good grief.

Two days. Three files. Dig Dig Dig.

I found the problem.

The SMALLEST of TYPOS in the original program. Bang Head

But hey - it works now.

-sting

Worker Joined: May 18, 2005 Posts: 119 Location: SVCDPlaza

And the typos where???
Because i have the same prob i sent a email tot bob 4 days ago but i have stil no replay of him.
I am using the laterst disto of raven and NSN PayPal 1.6.*

Posted: Wed Jan 25, 2006 4:19 pm

Yikes, I am hesitant to post any of his code without his express written permission in a public forum. If you will PM me or email me will be happy to discuss it.

-sting

Posted: Wed Jan 25, 2006 5:33 pm

Ok - after chatting with Raven, I am now more comfy about posting this here and at nukehaven.net (in the private forums).

It turns out this is in both copies I have of 1.6 - the NSN PayPal and the NSN PaySub (this one is the ps_ipn.php file though instead of the pp_ipn.php).

From my posting at Only registered users can see links on this board! Get registered or login!:

Quote:

Found a little bug in the original NSN-Paypal 1.60 - if you have not paid for this script, you may purchase it from nukescripts.net.

If you have this and did NOT pay for it, leave my board immediately.

In the pp_ipn.php file, there is a line that has a typo -

Code:




list($u_name) = $db_>sql_fetchrow($db->sql_query("SELECT username FROM ".$user_prefix."_users WHERE user_id='$custom'"));

Needs to be changed to

Code:




list($u_name) = $db->sql_fetchrow($db->sql_query("SELECT username FROM ".$user_prefix."_users WHERE user_id='$custom'"));

Notice there is an underscore "_" instead of a dash "-".

Two days of digging and assuming it was paypal, led to this discovery... lol.

-sting

Hope this helps

-sting

Posted: Thu Jan 26, 2006 12:34 am

Myn keep telling me IPN Failure on the mail but the mail looks corect .

cmd=_notify-validate

txn_type=web_accept

payment_date=00:59:51 Jan 22, 2006 PST

last_name=ike

option_selection1=3

item_name=Donation

payment_gross=5.00

mc_currency=USD

business=xxxxx@xxxxx.com

payment_type=instant

verify_sign=AuEeyMHFRFTgKJhpnMesxEj7Glw7AvQ1BNC0WJeYTulJKJzpdKNeXwlV

payer_status=verified

tax=0.00

payer_email=xxxxx@xxxxx.com

txn_id=58B07937VC055122G

quantity=1

receiver_email=xxxxx@xxxxx.com

first_name=ike

invoice=P00000002-1137920344

option_name1=Group ID

payer_id=DJCC7LHRN2F6N

receiver_id=7LWKSVFF4C4B8

item_number=

payment_status=Completed

payment_fee=0.50

mc_fee=0.50

that line is corect in the version i have But i found this DELETE INTO and i think this if (strcasecmp must be if (strcmp
I will look into it this evening wen a am back from my work

Posted: Thu Jan 26, 2006 8:44 am

Do you actually have IPN turned on at Paypal? If so - it is unnecessary.

I have version 1.60 as well, I am curious as to how yours differs from mine, but please do NOT post the code here in the public forums as it is not public domain.

DELETE INTO is not a command I am familiar with... DELETE x FROM is one I am familiar with.

I looked at the strcasecmp as well as I was not familiar with that one but it is a valid call, simply ignoring the case sensitivity of the string at hand and comparing to see if it is there.

If your receiver's email is not the same email as your email set in the configuration file of your pp_ipn.php then it will not work.

-sting

Posted: Thu Jan 26, 2006 1:35 pm

I have the NSN PayPal 1.6.* version of Oct 5 2005, 13:45:02 EDT .
And i have IPN turned on and put the richt file in there .
I use olso Donat o Meter module and ik have now set this up so it do the same as the NSN PayPal 1.6.* block but sins i have the NSN PayPal 1.6.* block i will recode this so it work as it must.

Posted: Thu Jan 26, 2006 1:40 pm

The NSN PayPal script references the pp_ipn.php on its own - you do not need to have IPN turned on at PayPal under the profile screen for this to work.

-sting

Posted: Thu Jan 26, 2006 1:48 pm

I better sent you a pm on your one site

edit . a pm is not posible so i @ you on msn

Posted: Thu Jan 26, 2006 4:00 pm

Yeah I put PM's in the Premium Area there, as well as forums and downloads. That way only the serious apply. Though for 2 bucks, you don't have to be that serious I suppose.

-sting

Posted: Fri Jan 27, 2006 12:02 am

I have found the problem in the latest version there olso are some typos but the script is now working Razz

Posted: Fri Jan 27, 2006 8:23 am

Congrats - I know how frustrating it is to go pulling your hair out for three days and just about the time your eyes pop out of your skull you see it....

_ or -. That is the question.

-sting

Regular Joined: Nov 28, 2005 Posts: 92 Location: UK

i am having the same problems as you all can you help please on a fix,

i have posted in the nsn groups on here but had little replies,

thanks in advance

B2Z