I want to allow my users access to certain features that are not part of the core Joomla functionality. We are creating custom scripts to manage these features.

I have created a table (#_cbsubs_dya_subscription_features) that contains the properties for each subscription level. The table is related to #_cbsubs_plans by #_cbsubs_plans.id.

Our scripts check #_cbsubs_dya_subscription_features to see if a user can perform a certain task or how many times they can perform it in some cases.

What I need to do is insert a new row in #_cbsubs_dya_subscription_features whenever a new plan is added to #_cbsubs_plans.

I tried adding a trigger to the #_cbsubs_plans table but that is giving me syntax problems. Before I sort out those issues, I'm wondering if this is the approach I should be taking or is there a better way I have not considered?

krileon wrote:

Just use CBSubs SQL Actions plugin. You can perform queries on activation and deactivation of a subscription. Structure is the same as using a standard query in PHP. It does support substitutions as well (see tutorials in signature for help with substitutions).

Thank you for your reply. The manual state:

"The sub-tab basically provides 5 paired parameters that contain SQL statement pairs
that are to be executed when a member first joins a plan or when a member leaves a
plan."

My action need to be fired when a new PLAN is created, not when a member joins or leaves a plan.

Does the CBSubs SQL Actions plugin support that case? It doesn't look like it to me.

Len