I'm not against creating the list using myPHPadmin but unsure what SELECT statement might yield the results I'm looking for. Is that possible?
Of course, you'd need to join the users and subscriptions table then filter accordingly. Simple example as follows.
Code:
SELECT s1.`id` AS subscription, u.*
FROM `jos_users` AS u
INNER JOIN `jos_cbsubs_subscriptions` AS s1
ON s1.`user_id` = u.`id`
AND s1.`plan_id` = PLAN_ID_HERE
LEFT JOIN `jos_cbsubs_subscriptions` AS s2
ON s2.`user_id` = u.`id`
AND s2.`status` = 'A'
AND s2.`plan_id` != PLAN_ID_HERE
WHERE s2.`id` IS NULL
That should give you a list of users that have a subscription to PLAN_ID_HERE of any kind (active, expired, etc..) and do not have an active subscription to any other plan. Note it's setup for phpmyadmin so replace jos_ with whatever your table prefix actually is.
The easiest solution though is to just edit your free plan, change it to free lifetime, then find all the users who have an active subscription to it and force renew them.
krileon
