Try this SQL statement, it worked for me

insert ignore into `jos_newsletter_subscribers` (SELECT '1', jos_comprofiler.user_id, '', jos_users.name, '', '1', now( ) , '1'
FROM `jos_comprofiler`, `jos_users`
WHERE jos_comprofiler.confirmed = '1' and jos_comprofiler.user_id = jos_users.id)

Post edited by: rswennen, at: 2006/10/06 14:04

Sorry, haven't really checked that

But if it does it will probably send out confirmations to everyone.

For those interested, I made a small CB plugin that automatically subscribes all new registering users to newsletter 1.



Post edited by: rswennen, at: 2006/10/06 14:04