Major Additions - Add Google Checkout to Paid Subscriptions

This is my first released mod, so please rate!

This modification will allow you to use Google Checkout as a payment processor for paid subscriptions.

Google Checkout Steps
-Under Settings->Preferences, select the option to automatically authorize and charge
-Under Settings->Integration, uncheck the digitally signed cart box
-For the API Callback URL, enter in the following:
http://path to your forum/payment_gateway.php?method=gcheckout
-Select the Notification Serial # method
-Select API version 2.5 (do NOT check the notification filtering checkbox!)
-Note your Merchant ID and Merchant Key on the right-hand side (will need for below)

vBulletin Steps
-Upload class_gcheckout.php to <forum base>/includes/paymentapi
-Install product
-Under Paid Subscriptions->Payment API Manager->Google Checkout, enter in the merchant ID and key found under your Settings.
-Activate Google Checkout payment API
-Optionally run "Test Communication" under Paid Subscriptions to ensure successful setup and integration

Known Issues
-Incorrect operation on 32bit systems! (found 12/14/2010)
-Only works with curl installed
-Chargeback handling not implemented yet

Release notes
1.01
-Replaced mysql_ function in install code with vB SQL wrapper
1.0
- Original version

[CaseLogic]

-FTP access or someone to upload an updated PHP file for me
-Template modification access

The only thing that needs to change between the two versions is the template-related code (the template itself and the code fetching the template).

[Tasking Mickey]

With my test transaction, the Integration Console showed these errors:
One of the times you entered is too far in the past.

XML Recieved: _type=notification-history-request&start-time=2007-01-01T05:00:00Z&end-time=2010-01-01T05:00:00Z
XML Sent: _type=error&error-message=One+of+the+times+you+entered+is+too+far+in +the+past&serial-number=241005a8-7749-4c68-a756-259b85e4278a

Invalid Serial Number

XML we sent: _type=error&error-message=Invalid+serial+number%3A+&serial-number=4fd97cf1-33dd-40f3-8f0f-556f3f18c289
XML we recieved: _type=notification-history-request&serial-number=

[CaseLogic]

Originally Posted by desi5257

With my test transaction, the Integration Console showed these errors:
One of the times you entered is too far in the past.

Invalid Serial Number

by test transaction, are you referring to when you do "test communications" via vB admin panel? Or are you running an actual transaction?

The notification history request start/end time stuff is part of the test communications function. All it's trying to do is verify that we can communicate with Google. The error can be ignored. I'm not positive on the serial # part though. The dashes look suspect though.

Please let me know what steps you took to produce this error.

[Tasking Mickey]

By test transaction, I mean an actual transaction. It never showed up in vB.

I made a test subscription (only $0.50).
I purchased the test subscription.
Entered credit card info.
Submitted the order, success.
Went back to vB, saw no record of the order being completed.

[CaseLogic]

Originally Posted by desi5257

By test transaction, I mean an actual transaction. It never showed up in vB.

I made a test subscription (only $0.50).
I purchased the test subscription.
Entered credit card info.
Submitted the order, success.
Went back to vB, saw no record of the order being completed.

Sorry for the slow response, I've been busy the past week.

Did you by chance get any transactions working in this time, or are you still encountering this issue?

Verify that your Google Merchant account is setup properly (see mod details above), and verify your google ID/key.

[Tasking Mickey]

As far as I know, I setup the mod right.

I also see the transaction in the log, with this error:

API
vb_error_code invalid_payment_amount

[CaseLogic]

Originally Posted by desi5257

As far as I know, I setup the mod right.

I also see the transaction in the log, with this error:

API
vb_error_code invalid_payment_amount

Are you doing transactions in USD or another currency?

[jayhawk785]

I'm seeing the same error 'One of the times you entered is too far in the past' - I'll recheck merchant keys & such, but i copied and pasted so I doubt they are wrong. I've also setup a .50cent subscription for testing, and I do not see anything coming back (yet) in the transaction logs. USD is the currency.

[jayhawk785]

This shows in the google log, as the other error (if you wan to ignore the time one for testing communication):

xml we received:

_type=notification-history-request&serial-number=

xml we sent:

_type=error&error-message=Invalid+serial+number%3A+&serial-number=f31af266-de3e-42c2-ab82-a58654b56cc9

[CaseLogic]

From my memory the "time you entered too far in the past" is simply because I used an old timestamp when doing the "Test communication" function. It shouldn't have any real impact other than annoyance for triggering an error.

As for the serial # error, what kind of system are you running? Can you link me to your forum? I should be able to see if the form information is being sent properly to Google's API