[SOLVED] Remove reactivate upgrade button

Hi,
I am using a group of CB fields in workflow to automatically offer a list of upgrade plans in cbsubs.
Trying to have the ticks selected by default, but this has been raised in seperate post.

Other problem is: for first offer, the user is faced with list of upgrade options and can select all of them with "ticks". Then pay for all of them together.

When these all expire (eg Next year) ... each plan has a seperate "reactivate button" which means each needs to be paid seperately. This is very painful if many plans. (upto 15 to be paid each year)

Can you suggest solution? or SQL that I can run on "expire" that will allow the upgrade "tick" to be displayed rather than the button so the user can pay for all plans together.

I could run "delete plan" for all users, but this also appears to remove any historical payment records, so would prefer avoid this solution. If this is the only way, can you suggest sql to do it?

thanks

You can't bulk renew. Plans must be renewed individually.

Thanks Kyle for prompt reply,

Do you have a list of cbsubs fields and their possible contents, so I can build some sql? or is there a tool to assist in doing this ?

I was thinking of writing sql that runs on expiry and deletes the record, so the user can then select the plan as if they never had one.

Can you provide the sql that runs when the "delete button" is pushed (or ticked)in a user > subscription back end.

Not an elegant approach, more like a sledgehammer.

Obviously I would be testing sql in an offline environment.
thanks

Do you have a list of cbsubs fields and their possible contents, so I can build some sql? or is there a tool to assist in doing this ?

No, we do not advise tampering with the CBSubs database tables.

I was thinking of writing sql that runs on expiry and deletes the record, so the user can then select the plan as if they never had one.

I suggest using CB Auto Actions as it now has a CB Paid Subscriptions action and it's capable of safely deleting subscriptions if you absolutely want this. You can configure it to delete whatever subscription you like on plan status change trigger for example. Example as follows.

Type: CB Paid Subscriptions 3.x
Triggers: onCPayUserStateChange
Access: Everybody
Conditional 1: [var2] Equal To X
Conditional 2: [var3] Equal To 1
Plans: Your Plans To Delete
Mode: Delete

Change "1" for "Conditional 2" to the Plan ID you're expecting to expire. The first conditional checks that the plan is expired.

thankyou, I seem to have this working .. still testing various options.

Using your code I would need to have a cb auto action for each plan. This is ok but ... now having played with this (very powerful) plugin,

As most of my plans expire on a certain date for everybody that has those plans.
Can I combine (and delete for everybody) a bunch of plans by:

Different trigger ?
Condition 1: if after date 30th June 2013
Plans: can select multiple plans now using control key.
Mode: Delete

if so, code for condition 1? or different trigger ?

Using your code I would need to have a cb auto action for each plan.

Yup.

Can I combine (and delete for everybody) a bunch of plans by:

Sure, but I'd set the conditionals as follows.

Conditional 1: [var2] Equal To X

Just exclude the Plan ID check. This way it deletes them all when any plan expires. You could also use the below, which will match against multiple Plan IDs.

Conditional 1: [var2] Equal To X
Conditional 2: [var3] Is REGEX \(^1$)|(^2$)|(^3$)|(^4$)\

The above uses REGEX to match the Plan ID. You'd separate additional IDs with |. The above matches plans 1, 2, 3, and 4 for example. The (^PLAN_ID$) usage is needed to avoid partial ID matching.