Export their user ids using phpmyadmin as a comma separated list then use the simple import feature, which uses a comma separated list of user ids. Ensure you're only doing this for active users. Example query as follows to accomplish this.
Code:
SELECT GROUP_CONCAT( DISTINCT a.`id` SEPARATOR ',' )
FROM `jos_comprofiler` AS a
INNER JOIN `jos_users` AS b
ON b.`id` = a.`id`
LEFT JOIN `jos_cbsubs_subscriptions` AS c
ON c.`user_id` = a.`id`
AND c.`id` IS NULL
WHERE a.`approved` = 1
AND a.`confirmed` = 1
AND b.`block` = 0
The above should grab the user id of all confirmed, approved, and not blocked users that do not have a subscription row. If your database table prefix isn't jos_ be sure to change it in the above query.
krileon
