[SOLVED] Plan Integrations / SQL Actions
krileon
Team Member- OFFLINE
- Posts: 68521
- Thanks: 9091
- Karma: 1434
1 year 9 months ago #330052
by krileon
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Replied by krileon on topic 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.
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
The following user(s) said Thank You: boyjahq
Please Log in to join the conversation.
- boyjahq
- OFFLINE
-
Platinum Member
- Posts: 508
- Thanks: 35
- Karma: 3
1 year 9 months ago #330061
by boyjahq
Replied by boyjahq on topic Plan Integrations / SQL Actions
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)?
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.
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';
Please Log in to join the conversation.
- krileon
- Team Member
- OFFLINE
- Posts: 68521
- Thanks: 9091
- Karma: 1434
1 year 9 months ago #330062
by krileon
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.
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Replied by krileon on topic Plan Integrations / SQL Actions
Yes.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?
You can use the below to execute actions on subscription status.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)?
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.
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
The following user(s) said Thank You: boyjahq
Please Log in to join the conversation.
- boyjahq
- OFFLINE
-
Platinum Member
- Posts: 508
- Thanks: 35
- Karma: 3
1 year 8 months ago #330265
by boyjahq
Replied by boyjahq on topic Plan Integrations / SQL Actions
It works as needed. Thank you!
The following user(s) said Thank You: krileon
Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.210 seconds
-
You are here:
- Home
- Forums
- Support and Presales
- Developer Members Support
- [SOLVED] Plan Integrations / SQL Actions