PDA

View Full Version : PayPal IPN > Update SQL Database & Forum Usergroup

DannyC55
04-24-2010, 05:28 PM
Hey!

Anyone able to help me out with a payment & update system.
I know there's a way, just not completely sure how..

I'm looking for users to make a payment through PayPal (using IPN), that will then update an SQL database & their usergroup on the forum.

I've been told it can be done using VSa - PayPal Donate (https://vborg.vbsupport.ru/showthread.php?t=236480). But I've no idea how to code...

If anyone can do this as a freebie then great, otherwise provide a price.
Bouncer222
04-25-2010, 12:02 AM
+1 I need this too!!!!

IPN verifies that they have made the payment right? I heared about it before but havent looked into it much.

Because I believe the default system of subscription for example... changes their usergroup without confirmation that payment went through, resulting in the person being able to cancel payment and still be in the new usergroup!?
Zachery
04-25-2010, 12:03 AM
So why not use the subscription system which does this.....
Bouncer222
04-25-2010, 12:12 AM
It doesn't check if the payment transaction has completed...therefore a user can delete his paypal transaction.

EX: Bank to paypall transfer takes couple days.
Zachery
04-25-2010, 12:19 AM
It should be, if it isn't send a bug report in. IPN reports when the process completes, so I cannot fathom why it wouldn't be working in vBulletin via the default subscription system.
Bouncer222
04-25-2010, 12:36 AM
vbulletin isnt based on ipn is it?
Zachery
04-25-2010, 04:11 AM
vBulletin's subscription system does use paypal, and thus IPN :)
DannyC55
04-25-2010, 03:58 PM
But doesn't update a separate SQL Database.
Only it's own...

I need it to update an sql database for a gaming server (to change their value of a cash for instance).
va1
07-20-2010, 12:02 PM
vBulletin's subscription system does use paypal, and thus IPN :)

So you mean that the in-built subscription system of VB would very well be able to change the user group from normal registered usergroup to some user define group say premiumgroup on successful completion of payment processing at the paypal end.
My requirement is that as soon as the paypal payment gets through the user should be promoted to a premium usergroup; so for that I do not have to wriite any extra code right? I am using vBulletin 4.0.4. Please answer !!