We have no functionality to auto downgrade someone into a different plan on expiration. Generally you just let the user do that themselves if they choose to not renew. It's possible to automate this with CB Auto Actions though. You'd use the same plan expiration logic I provided earlier.

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

The above will work with any auto action type. So if you want to subscribe them into a new plan for example set the Type to CB Paid Subscriptions and configure the Action tab accordingly to your needs.

That should be a pretty simple straight forward configuration. Do you have email confirmation and/or admin approval enabled? That'd change things a little bit since you'd probably want to wait for them to be confirmed and/or approved before forcing them to join. The below for example is without confirmation or admin approval.

Registered
Global
Triggers: onAfterUserRegistration
Type: CB GroupJive
User: Automatic
Access: Everybody
Action
Mode: Join Groups
Groups: SELECT_GROUPS_HERE

That's all there is to it. They'd be placed in whatever groups you selected after they register. If you have confirmation and want to wait for them to be confirmed you can use the below. Basically just a trigger change with a condition to ensure confirmation state is switching to confirmed

Confirmed
Global
Triggers: onAfterUserConfirm
Type: CB GroupJive
User: Automatic
Access: Everybody
Conditions
Field: Custom > Value
Custom Value: [var2]
Operator: Equal To
Value: 1
Action
Mode: Join Groups
Groups: SELECT_GROUPS_HERE

Now when they confirm their email they'll be placed in the groups instead of directly after registering. If you have moderator approval it's again just a relatively simply change. Is actually just a literal trigger change from the above.

Approved
Global
Triggers: onAfterUserApproval
Type: CB GroupJive
User: Automatic
Access: Everybody
Conditions
Field: Custom > Value
Custom Value: [var2]
Operator: Equal To
Value: 1
Action
Mode: Join Groups
Groups: SELECT_GROUPS_HERE

Now when you confirm their account they'll be placed in the selected groups. Note you only need to use one of the above. Don't use all 3. Which you use is entirely up to you and your configuration.

PS: We inaugurate our community site tonight, I added your name in the credits

I appreciate it, but no need to credit me personally. We're a team here so if you do want to credit us just credit Joomlapolis. 😊

The below should work then. Since the option was pushed to a field that'll be the easiest way to condition against the selection.

Plan Active
Global
Triggers: onCPayUserStateChange
Type: Usergroups
User: Automatic
Access: Everybody
Conditions
Condition 1
Field: cb_category_access
Operator: Equal To
Value: OPTION_VALUE_HERE
Condition 2
Field: Custom > Value
Custom Value: [var3]
Operator: Equal To
Value: PLAN_ID_HERE
Condition 3
Field: Custom > Value
Custom Value: [var2]
Operator: Equal To
Value: A
Action
Mode: Add Usergroups
Groups: SELECT_USERGROUPS_HERE
Parameters
Reload User: Yes

Replace OPTION_VALUE_HERE with whatever your option value. Replace PLAN_ID_HERE with whatever the plan id is. For SELECT_USERGROUPS_HERE select whatever usergroups that option should give. You can also remove usergroups added by other options here as well.

You'll need 1 auto action per cb_category_access value so that you can uniquely add your usergroups per option value.

Plan Expired
Global
Triggers: onCPayUserStateChange
Type: Usergroups
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
Action
Mode: Remove Usergroups
Groups: SELECT_USERGROUPS_HERE

As like before set PLAN_ID_HERE to your plan id and then for SELECT_USERGROUPS_HERE select all the usergroups added by your options so that they get cleared if their plan expires. You don't need multiple of these for the different cb_category_access options. This single auto action should be responsible for clearing their usergroups.

CB GroupJive doesn't have that functionality so no it's not doable without implementing it yourself. It however can be implemented using CB Auto Actions. The below should work.

Global
Triggers: gj_onAfterCreateGroup
Type: Email
User: Automatic
Access: Everybody
Action
To: query
To Query: Subject: EMAIL_SUBJECT_HERE
Body: EMAIL_MESSAGE_HERE

That should email every user when a group is created. I would recommend caution with this. It'd be easy to spam users with too many emails by doing this and could result in your email domain being blacklisted if too many people report you as spam.

The below would mimic what the internal behavior is doing.

Global
Triggers: onAfterUserRegistration
Type: CB Activity
User: Automatic
Access: Everybody
Action
Mode: Activity
Method: Create
Stream: Profile Activity
Asset: profile.[user_id].registration
Load By: None

That asset would just result in the same title displayed as the internal activity, which is "joined the site". Note that is a language string so you could just override it for example. To avoid that you could create your own asset. Below for example would work fine.

Asset: profile.[user_id].registered
Title: My Title
Message: My Message

Sure, that would rely on a Joomla content event. You can find more information about Joomla content events below.

manual.joomla.org/docs/next/building-extensions/plugins/plugin-events/content/

Specifically you'll be using onContentAfterSave and to use a Joomla event in CB Auto Actions you'll need to prefix it with joomla_ giving joomla_onContentAfterSave. Since these are filtered by context you'll need an article context with is com_content.article. Below is the details for the onContentAfterSave event and what variables it contains.

manual.joomla.org/docs/next/building-extensions/plugins/plugin-events/content/#oncontentaftersave

This can all be put together using the below example.

Global
Triggers: joomla_onContentAfterSave
Type: Email
User: Automatic
Access: Everybody
Conditions
Condition 1
Field: Custom > Value
Custom Value: [var1]
Operator: Equal To
Value: com_content.article
Condition 2
Field: Custom > Value
Custom Value: [var3]
Operator: Equal To
Value: 1
Condition 3
Field: Custom > Value
Custom Value: [var2_catid]
Operator: Equal To
Value: CATEGORY_ID_HERE

Replace CATEGORY_ID_HERE with the id of the category you want this applying to. You can use an "In" condition to supply a comma list of category ids as well if you need more than 1 category. It should only apply to newly created articles due to the var3 ($isNew) check. Next just configure the rest of the email however you like.

Ok, latest CB Gallery build release now has the slashed eye indicator for published state implemented. I've implemented it throughout all views that have indicator icons including grid views for both albums and media. Even media modal windows will indicate unpublished next to the menu dropdown.

I am not (yet) familiar with autoaction plugin, so i will be happy if you can provide such example, thank you !

This might be quite complicated if you've no CB Auto Actions experience, but the configuration example is as follows for the auto action. Basically what we'll be doing is overriding the date handling for the CB Activity logging behavior for CB Gallery activity. Some of the below might be confusing if you've no CB Auto Actions experience so I'd recommend just installing it and exploring it first before putting together auto actions. This assumes you still want to go through with doing this. I don't particularly recommend it since it causes media to go outside the flow of things, but it's up to you.

Global
Triggers: activity_onBeforeActivityEntitySave
Type: Code
User: Automatic
Access: Everybody
Conditions
Field: Custom > Value
Custom Value: [cb:parse function="getAsset" class="var1" /]
Format Functions: Yes
Operator: Is REGEXP
REGEXP: /^gallery\./
Action
Method: PHP
Code: Parameters
Reference Variables: Variable 1

I've confirmed the above works to force the activity date to be the current datetime causing it to ignore the date of the gallery entry itself.

By sending an email I meant use an Email action. That's what I used in my tests with success. Are you sure your gateway id is correct? You need to provide the number under the Id column and not under the # column.

It's possible to act on payment state change as well. That maybe more ideal since you're just needing to act on successful payments from paypal. Below is tested working as well.

Global
Triggers: onCPayAfterPaymentStatusChange
User: Automatic
Access: Everybody
Conditions
Condition 1
Field: Custom > Value
Custom Value: [var4]
Operator: Equal To
Value: Completed
Condition 2
Field: Custom > Value
Custom Value: [var2_gateway_account]
Operator: Equal To
Value: YOUR_PAYPAL_GATEWAY_ID_HERE

This is just acting on a payment basket being marked completed for a specific payment gateway. Below was used in both test examples.

Global
Type: Email
Action
Subject: Payment Test Email
Body: Success!

Ok, took a bit longer but have a much cleaner solution. Format Functions in CB Auto Actions now support inline Query and Code execution (must be a Super User to toggle on and use these!). This allows substantially easier inserting of the invoice HTML wherever you like in whatever auto action you like. The below for example will example the invoice HTML. Note you'll need to update to latest CB Auto Actions build release before you can utilize this.

Global
Triggers: onCPayAfterPaymentStatusChange
Type: Email
User: Automatic
Access: Everybody
Conditions
Field: Custom > Value
Custom Value: [var4]
Operator: Equal To
Value: Completed
Action
Subject: Invoice
Body: Parameters
Format Functions: Yes
Format Code Function: Yes

The complicate comes from determining if the basket contains merchandise payments or not. This would apply to all baskets basically. So to find if a merchandise was purchased it'll require an additional condition that checks what is in the basket. The below should work for that.

Field: Code
Custom Code: Operator: Equal To
Value: 1

This should allow the condition to match if the basket contains at least 1 row item that's a merchandise.

Your conditions are probably is what is failing. The database state is considered in transit. It can change based off webhooks, what state they're moving into/from, etc..

Are you needing to act on the payment status change or the subscription status change? onCPayAfterPaymentStatusChange is the correct trigger for payment status changes and onCPayUserStateChange is the correct trigger for subscription status changes. With both you should be using the variables already provided to them instead of querying for information. After selecting either trigger you should see what variables are available to them just below the Triggers parameter.

Since you mentioned payment being finalized and subscription being active I'd act on subscription state change with onCPayUserStateChange. The below for example should work fine.

Global
Triggers: onCPayUserStateChange
User: Automatic
Access: Everybody
Conditions
Condition 1
Field: Custom > Value
Custom Value: [var2]
Operator: Equal To
Value: A
Condition 2
Field: Custom > Code
Code: Operator: Equal To
Value: YOUR_PAYPAL_GATEWAY_ID_HERE

This will work on renewals as well. If you only want it on first payment you'll need to add a condition against the $reason. Example as follows.

Field: Custom > Value
Custom Value: [var6]
Operator: Not Equal To
Value: R