Please let me know the progress of this!! It will make my life much easier when dealing with my client's Membership Chair and Board of Directors.
In the short term, I added a SQL action:
UPDATE `jos_cbsubs_subscriptions` SET `expiry_date` = '2011-11-01' WHERE `user_id` = [user_id] AND `plan_id` = [plan_id] AND `status` = 'A'
I added this to the "Activation" Action, plus on the renewal action I added:
UPDATE `jos_cbsubs_subscriptions` SET `expiry_date` = '2012-11-01' WHERE `user_id` = [user_id] AND `plan_id` = [plan_id] AND `status` = 'A'
(The only difference is that the year is 2012 on that one.)
ONE PROBLEM >>>>> When I hit "Save" I got a 403 error "Attempted SQL injection in POST"
I resorted to first saving the Integration using a bogus database name (altered by one letter), then using PHPMyAdmin I edited the SQL plans table and inserted the correct database name.
Tomorrow my client adds a new user, so we'll see if it works.
Thought you should be aware of the error, though.
Can't wait for the feature update in the core product!!!
Thanks!