DragonByte Tech | vBulletin Mods & Addons - Powered by vBulletin





User Tag List

Results 1 to 8 of 8

Thread: Importing users


Forum: vBMail Lite Support

Questions & Answers for vBMail.
Click here to buy!

  1. #1
    Junior Member
    Level 0 (0 Loyalty Points)

    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Mar 2014
    Posts
    13
    Rep Power
    0

    Default Importing users

    @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!
    0 0 0
     
    Importing users Send PM  

  2. #2
    Founder
    Level 0 (0 Loyalty Points)
    Belazor's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Dec 2009
    Location
    Glasgow, United Kingdom
    Age
    30
    Posts
    27,730
    Blog Entries
    13
    Rep Power
    10

    Default

    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 Hannisdal
    Founder & Programming Director
    DragonByte Technologies http://www.DragonByte-Tech.com


    Please do not Private Message me with support requests or product questions. PMs are only for exchanging sensitive information (like FTP / AdminCP logins).
    Please do not Private Message me with business related queries (refunds, complaints, feedback, etc). Decado is the person to PM for those issues.
    Please do not Private Message Decado with support requests or forum errors.

    When I say "Hotfix Released" it means you should re-download the product and re-upload the files.
    Like our products? Want to be notified on social media networks when we release updates or new products? Click the buttons below to Like us on Facebook, Follow us on Twitter and Follow us on Google+!
    0 0 0
     
    Importing users Send PM  

  3. #3
    Junior Member
    Level 0 (0 Loyalty Points)

    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Mar 2014
    Posts
    13
    Rep Power
    0

    Default

    @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
    0 0 0
     
    Importing users Send PM  

  4. #4
    Junior Member
    Level 0 (0 Loyalty Points)

    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Mar 2014
    Posts
    13
    Rep Power
    0

    Default

    @Belazor

    Can you look on this?
    Can you give me the sql query to make all users set as subscribed to a mailing list?
    0 0 0
     
    Importing users Send PM  

  5. #5
    Founder
    Level 0 (0 Loyalty Points)
    Belazor's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Dec 2009
    Location
    Glasgow, United Kingdom
    Age
    30
    Posts
    27,730
    Blog Entries
    13
    Rep Power
    10

    Default

    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)?
    Fillip Hannisdal
    Founder & Programming Director
    DragonByte Technologies http://www.DragonByte-Tech.com


    Please do not Private Message me with support requests or product questions. PMs are only for exchanging sensitive information (like FTP / AdminCP logins).
    Please do not Private Message me with business related queries (refunds, complaints, feedback, etc). Decado is the person to PM for those issues.
    Please do not Private Message Decado with support requests or forum errors.

    When I say "Hotfix Released" it means you should re-download the product and re-upload the files.
    Like our products? Want to be notified on social media networks when we release updates or new products? Click the buttons below to Like us on Facebook, Follow us on Twitter and Follow us on Google+!
    0 0 0
     
    Importing users Send PM  

  6. #6
    Junior Member
    Level 0 (0 Loyalty Points)

    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Mar 2014
    Posts
    13
    Rep Power
    0

    Default

    @Belazor

    Mailing list ID is 3.. No table prefix
    0 0 0
     
    Importing users Send PM  

  7. #7
    Founder
    Level 0 (0 Loyalty Points)
    Belazor's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Dec 2009
    Location
    Glasgow, United Kingdom
    Age
    30
    Posts
    27,730
    Blog Entries
    13
    Rep Power
    10

    Default

    Code:
    INSERT INTO dbtech_vbmail_subscription
    (userid, mailinglistid, subscribed)
    SELECT userid, '3', '1' FROM user
    That should work
    Fillip Hannisdal
    Founder & Programming Director
    DragonByte Technologies http://www.DragonByte-Tech.com


    Please do not Private Message me with support requests or product questions. PMs are only for exchanging sensitive information (like FTP / AdminCP logins).
    Please do not Private Message me with business related queries (refunds, complaints, feedback, etc). Decado is the person to PM for those issues.
    Please do not Private Message Decado with support requests or forum errors.

    When I say "Hotfix Released" it means you should re-download the product and re-upload the files.
    Like our products? Want to be notified on social media networks when we release updates or new products? Click the buttons below to Like us on Facebook, Follow us on Twitter and Follow us on Google+!
    0 1 0
     
    Importing users Send PM  

  8. #8
    Founder
    Level 0 (0 Loyalty Points)
    Belazor's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Dec 2009
    Location
    Glasgow, United Kingdom
    Age
    30
    Posts
    27,730
    Blog Entries
    13
    Rep Power
    10

    Default

    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!
    Fillip Hannisdal
    Founder & Programming Director
    DragonByte Technologies http://www.DragonByte-Tech.com


    Please do not Private Message me with support requests or product questions. PMs are only for exchanging sensitive information (like FTP / AdminCP logins).
    Please do not Private Message me with business related queries (refunds, complaints, feedback, etc). Decado is the person to PM for those issues.
    Please do not Private Message Decado with support requests or forum errors.

    When I say "Hotfix Released" it means you should re-download the product and re-upload the files.
    Like our products? Want to be notified on social media networks when we release updates or new products? Click the buttons below to Like us on Facebook, Follow us on Twitter and Follow us on Google+!
    0 1 0
     
    Importing users Send PM  

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [vB 4.1.x] Importing
    By Steris56 in forum Advanced Post Thanks / Like Lite Support
    Replies: 7
    Last Post: 19th July 2013, 18:44
  2. [vB 3.8.x] Banned Users Showing Up In Active Users When Replying to Threads
    By Pandemikk in forum vBShout Lite Support
    Replies: 3
    Last Post: 18th July 2011, 21:51

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.