Paid Subscriptions - adding a query when payment is confirmed
 

Hello. As the title says, I need to run a mysql query when the payment is confirmed and the user return to the forum.

Can someone please, PLEASE, point me to a direction? I can't find the hook location, neither where the actual php code lies inside vb files. Also, I need to know the name of the variable that indicates subscription's ID.

I would also like to customize the email that is being sent to the user after the purchase.

Many thanks!

--------------- Added [DATE]1295100872[/DATE] at [TIME]1295100872[/TIME] ---------------

Ok, I managed to make the plugin work. The problem is I can't get the variables for userid and user's email, they come blank. I'm using the following code:

The above code goes inside a plugin located in the paidsub_build hook.

I also tried $bbuserinfo[userid], with the same results.

Any suggestion on getting those vars? Thanks.

Solved it!

If anyone needs this, I got the vars by using $user[userid], $user[email] and $sub['subscriptionid'].