I've setup a simple cart where users choose how much they would like to deposit as virtual currency using the PayPal sandbox - I've tested it and it works great. So far I've got to successful money transfers between accounts and notifications.
However what I can't figure out is how to give the account on my website the virtual credit after the user pays. I want to store the value in a SQL column next to their username; doing so is easy - but how do I execute that SQL command only when a user has genuinely paid?
To clarify, this is a script that allows users to deposit money to their website account using paypal - I've got as far as the transactions (sending and receiving the money) and notifications. What I'm stuck with is adding the transaction value to the users account on my website.
Can anyone with previous experience please assist?