Go Back   vb.org Archive > Community Discussions > Modification Requests/Questions (Unpaid)
Reload this Page PayPal IPN > Update SQL Database & Forum Usergroup
FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1  
Old 04-24-2010, 05:28 PM
DannyC55 DannyC55 is offline
 
Join Date: Feb 2007
Location: London, United Kingdom
Posts: 38
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default PayPal IPN > Update SQL Database & Forum Usergroup
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 . But I've no idea how to code...

If anyone can do this as a freebie then great, otherwise provide a price.
Reply With Quote
  #2  
Old 04-25-2010, 12:02 AM
Bouncer222 Bouncer222 is offline
 
Join Date: Oct 2009
Posts: 705
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
+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!?
Reply With Quote
  #3  
Old 04-25-2010, 12:03 AM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
So why not use the subscription system which does this.....
Reply With Quote
  #4  
Old 04-25-2010, 12:12 AM
Bouncer222 Bouncer222 is offline
 
Join Date: Oct 2009
Posts: 705
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
  #5  
Old 04-25-2010, 12:19 AM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
  #6  
Old 04-25-2010, 12:36 AM
Bouncer222 Bouncer222 is offline
 
Join Date: Oct 2009
Posts: 705
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
vbulletin isnt based on ipn is it?
Reply With Quote
  #7  
Old 04-25-2010, 04:11 AM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
vBulletin's subscription system does use paypal, and thus IPN
Reply With Quote
  #8  
Old 04-25-2010, 03:58 PM
DannyC55 DannyC55 is offline
 
Join Date: Feb 2007
Location: London, United Kingdom
Posts: 38
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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).
Reply With Quote
  #9  
Old 07-20-2010, 12:02 PM
va1 va1 is offline
 
Join Date: Jul 2010
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Zachery View Post
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 !!
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 01:08 AM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04178 seconds
  • Memory Usage 2,232KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (9)postbit
  • (9)postbit_onlinestatus
  • (9)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete