[SOLVED] Plan Integrations / SQL Actions

Was able to find the cause. Both issues fixed in latest build release and confirmed regular fields and status fields saving and working correctly.

If we are running only stable CB build releases on our live site, is it OK for us to update only Auto Actions to the new nightly build? Or is it necessary to update all plugins/components to nightly build versions for them to all work together properly?

And which auto action trigger should we use for these if we want this to happen once successful payment has been made for plan_id = 1 (plan 1 has become active)?

The following would be CB Paid Subscription actions.

Code:

DELETE FROM `y2vfp_cbsubs_subscriptions` WHERE `y2vfp_cbsubs_subscriptions`.`user_id` = [user_id] AND `plan_id` = '3'; DELETE FROM `y2vfp_cbsubs_subscriptions` WHERE `y2vfp_cbsubs_subscriptions`.`user_id` = [user_id] AND `plan_id` = '10';

If we are running only stable CB build releases on our live site, is it OK for us to update only Auto Actions to the new nightly build?

Yes.

And which auto action trigger should we use for these if we want this to happen once successful payment has been made for plan_id = 1 (plan 1 has become active)?

You can use the below to execute actions on subscription status.

Plan Active
Global
Triggers: onCPayUserStateChange
User: Automatic
Access: Everybody
Conditions
Condition 1
Field: Custom > Value
Custom Value: [var3]
Operator: Equal To
Value: PLAN_ID_HERE
Condition 2
Field: Custom > Value
Custom Value: [var2]
Operator: Equal To
Value: A

Plan Expired
Global
Triggers: onCPayUserStateChange
User: Automatic
Access: Everybody
Conditions
Condition 1
Field: Custom > Value
Custom Value: [var3]
Operator: Equal To
Value: PLAN_ID_HERE
Condition 2
Field: Custom > Value
Custom Value: [var2]
Operator: Not Equal To
Value: A

Be sure to replace PLAN_ID_HERE with the actual id of your plan as found in CBSubs > Plans.

It works as needed. Thank you!