Question vBMail - sql

Status
Not open for further replies.

Marv

Customer
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.
 
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).
 
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