CB,Yanc, Registration, autocheck

14 years 6 months ago #22021 by rswennen
Replied by rswennen on topic Re:CB,Yanc, Registration, autocheck
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
Attachments:

Please Log in to join the conversation.

14 years 6 months ago #22027 by beat
Replied by beat on topic Re:CB,Yanc, Registration, autocheck
The latest YanC 1.4 RC release should have the import with autocheck feature implemented...

Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info

Please Log in to join the conversation.

14 years 6 months ago #22030 by rswennen
Replied by rswennen on topic Re:CB,Yanc, Registration, autocheck
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.

Attachment yancautosub-10c6359b8848849d52f513b121c143d5.zip not found



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

Please Log in to join the conversation.

14 years 6 months ago #22053 by beat
Replied by beat on topic Re:CB,Yanc, Registration, autocheck
- Cool, thanks for sharing the plugin :) . If you wish it uploaded please do so or email to nant using contact form.

- latest YanC 1.4 has an option to upload silently (of course only do this for lists which have already been opted-in!...)

Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.412 seconds

Facebook Twitter LinkedIn