 |
|
Re:CB,Yanc, Registration, autocheck
|
|
Date: 2006/10/04 17:22
|
By: rswennen
|
Status: User
|
|
|
Karma: 0
|
|
Junior Joomlapolitan
| Posts: 33 |   |
|
|
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
|
|
The topic has been locked. |
|
 |
|
Re:CB,Yanc, Registration, autocheck
|
|
Date: 2006/10/04 18:03
|
By: beat
|
Status: Admin
|
|
|
Karma: 256
|
|
Admin
| Posts: 4215 | |
|
|
The latest YanC 1.4 RC release should have the import with autocheck feature implemented...
Beat  - Developer on Community Builder core Team
- If you like CB and this forum, you will love Nick's CB 1.2 RC4 reference manual !  : Click here to Get it now
- Would like to help us move faster ? Get it, and/or help us spend more time coding by helping others in this forum, many thanks
|
|
|
The topic has been locked. |
|
|
|
|
Re:CB,Yanc, Registration, autocheck
|
|
Date: 2006/10/04 19:12
|
By: rswennen
|
Status: User
|
|
|
Karma: 0
|
|
Junior Joomlapolitan
| Posts: 33 | |
|
|
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
|
|
|
The topic has been locked. |
|
|
|
|
Re:CB,Yanc, Registration, autocheck
|
|
Date: 2006/10/05 00:53
|
By: beat
|
Status: Admin
|
|
|
Karma: 256
|
|
Admin
| Posts: 4215 | |
|
|
- 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 - Developer on Community Builder core Team
- If you like CB and this forum, you will love Nick's CB 1.2 RC4 reference manual ! : Click here to Get it now
- Would like to help us move faster ? Get it, and/or help us spend more time coding by helping others in this forum, many thanks
|
|
|
The topic has been locked. |
|
|
