Question Importing users

Status
Not open for further replies.

ExpressVB

New member
Fillip H.

How do I make all users automatically subscribed in the list?
I tried ticking auto subscribed to the usergroups but it wont appear on the subscribed list.

If it isnt possible, can you give me the sql query to make all users set as subscribed to a mailing list?

Thanks!
 
Auto subscribed only works if it's ticked during the creation of the mailing list. At all other times, it will only apply to new users.
 
Fillip H.

I cant make all users subscribed to the list.

Can you give me the sql query to make all users set as subscribed to a mailing list?

Thank you
 
Fillip H.

Can you look on this?
Can you give me the sql query to make all users set as subscribed to a mailing list?
 
What's your mailing list ID (mouse over the Edit link in the ACP) and do you use a table prefix (find it in config.php)?
 
Code:
INSERT INTO dbtech_vbmail_subscription
(userid, mailinglistid, subscribed)
SELECT userid, '3', '1' FROM user

That should work :)
 
Hello ExpressVB,

This ticket has now been closed with the status Answered.

We hope your issue or question has been addressed to your satisfaction. If not, please feel free to re-open it by clicking this link.

If you have any further issues or questions, please feel free to start a new support ticket via the button at the top of every page.

Thank you!
 
Status
Not open for further replies.

Legacy vBMail

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
732
Customer rating
0.00 star(s) 0 ratings
Back
Top