Paid Subscription Plugin Variables

[m002.p]

Hello everyone.

I am trying to code a plugin so that when one of my paid subscriptions is completed by a user (ie they have paid) then I update another database using some MYSQL queries.

Now, I know how to code the queries I want to run, but I do not know a) what plugin hook to use (paidsub_complete?) and b) what variables to understand which userid completed the transaction and obviously ensuring its the right paid subscription I want to write info for.

Any ideas on the variables to use?

Thanks in advance

Matt