Question Importing users

Status
Not open for further replies.
Website
http://sp411.cc
Product version
2.1.3
Forum version
vBulletin 4.2.x
#1
Belazor

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!
 

Belazor

Staff member
Owner
Developer
Customer
#2
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.
 
#3
Belazor

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
 

Belazor

Staff member
Owner
Developer
Customer
#5
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)?
 

Belazor

Staff member
Owner
Developer
Customer
#7
Code:
INSERT INTO dbtech_vbmail_subscription
(userid, mailinglistid, subscribed)
SELECT userid, '3', '1' FROM user
That should work :)
 

Belazor

Staff member
Owner
Developer
Customer
#8
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.

vBMail

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