DragonByte Tech | vBulletin Mods & Addons - Powered by vBulletin





User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 2 of 2

Thread: vBMail - sql


Forum: vBMail Lite Support

Questions & Answers for vBMail.
Click here to buy!

  1. #1
    Member
    Level 1 (1,050 Loyalty Points)

    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Aug 2014
    Posts
    61
    Rep Power
    4

    Default vBMail - sql

    Hi Fillip,

    our server got hacked last month and was used as part of a botnet, sending out tons of spam. Of course we´ve got blacklisted and had to switch servers, had to clean our closet and have now a database with 35.000 users, which have become flagged as bounced since the blacklisting-bouncers (Error 554).

    1. Could you provide me with a sql-query, that can unflag those thousands of users?
    2. Is there any chance, to alter this query to select a time frame, that users before the incident flagged as bounced, are ignored by the mass-unflag sql-query?

    Regards,
    Marv.
    0 0 0
     
    vBMail - sql 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,738
    Blog Entries
    13
    Rep Power
    10

    Default

    Sadly, this is impossible. There is no way to tell which users were legitimately unsubscribed, who clicked unsubscribe and who never subscribed in the first place.

    As far as I can tell, your only two options are to ask users to re-subscribe or to create a new mailing list with the same auto-subscribed parameters as your existing one (risking the ire of your users and potentially a more serious blacklist flag).
    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
     
    vBMail - sql Send PM  

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. vBMail v1.1.10 Released!
    By Belazor in forum DragonByte Technologies News
    Replies: 0
    Last Post: 13th April 2013, 00:17
  2. [German] vBMail
    By lolly in forum Translations
    Replies: 0
    Last Post: 2nd November 2011, 15:39
  3. [Completed] vBMail
    By Belazor in forum Documentation Forum
    Replies: 0
    Last Post: 29th October 2011, 05:32
  4. [French] vBMail
    By dadoo in forum Translations
    Replies: 1
    Last Post: 19th September 2011, 08:47

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.