Need an idea on how to do this..

[0ptima]

I have set up Paypal subscriptions on my forum and when someone subscribes, they get an additional usergroup. The only problem is that once someone pays via paypal, I have to manually change which Display Group is being displayed.

The new additional user group ID is 12 and the following SQL can be used to update which user group is displayed.

update user
set displaygroupid = 12
where membergroupids = 12 and displaygroupid = 0;

I would like this to be automated, preferably the moment that they pay for the subscription. Does anyone have an idea on how I could automate this?