Please Log in to join the conversation.
UPDATE `#__cbsubs_plans` SET `allow_newsubscriptions` = 0 WHERE `id` = '[plan_id]' AND ( ( SELECT COUNT(*) FROM `#__cbsubs_subscriptions` WHERE `plan_id` = '[plan_id]' ) + 1 ) >= 50
Please Log in to join the conversation.
Please Log in to join the conversation.
erilam wrote: I think it will also be necessary to be attentive to the renewals because if you set cbsubs to let a time to renewal for your members, the total number of subscription will be less than your limit for a moment.
Please Log in to join the conversation.
Please Log in to join the conversation.
krileon wrote: Just update the already provided SQL in my above reply to exclude renewals. Check for a status of "A" to only count active subscriptions.
Please Log in to join the conversation.