Maxxius Posted April 1, 2020 Share Posted April 1, 2020 hi, I recently got into email list cleaning since my community is 14 years as of 2 days ago. 🙂 I know yaaay 😄 so I discovered neverbounce.com they do a solid work and even offer 1000 free cleans on a new account. Thing is I exported some emails from IPS ACP members list. fed it to neverbounce it spit back out a list of non-existant, not working and otherwise unusable email boxes in a csv format. 1m dollar question now is how do I unsubscribe from receiving my emails in BULK those members which have those bad emails? Link to comment Share on other sites More sharing options...
bfarber Posted April 1, 2020 Share Posted April 1, 2020 For those email addresses in core_members.email, change the column core_members.allow_admin_mails to 0. Link to comment Share on other sites More sharing options...
Maxxius Posted April 1, 2020 Author Share Posted April 1, 2020 you mean opening database in phpmyadmin and go manually thru every email entry? I don't really understand how that could speed things up unless some sort of if query is made. Link to comment Share on other sites More sharing options...
bfarber Posted April 2, 2020 Share Posted April 2, 2020 What I would do personally is to take the CSV file and open it in my editor, and then use regular expressions in the search/replace feature of my editor to turn something like (assuming the email address is the only column)... ^(.+?)$ into UPDATE core_members SET allow_admin_mails=0 WHERE email='$1'; I don't know the specific format of your CSV file though, what editor you might use, your skill level with regular expressions, etc. I was just giving you generalized "this is how you turn off bulk mails for an email address" information so you could formulate a better plan on how to do it in bulk. Maxxius 1 Link to comment Share on other sites More sharing options...
Maxxius Posted May 7, 2020 Author Share Posted May 7, 2020 (edited) @bfarber first when I saw your reply I did not entirely understood what you have meant by this and this morning when I revisited it there was this AHA moment. Thanks, I'll be generating a bunch of queries and executing them like that. 🙂 Edited May 7, 2020 by Maxxius Link to comment Share on other sites More sharing options...
Maxxius Posted May 17, 2020 Author Share Posted May 17, 2020 @bfarber since you are good with regex and notpad++ can you help me crack this case I have. Back in v3 days I made some custom bbcode spoiler reveal tag which after upgrading to v4 sort of locked the text between those tags. I investigated and eventually found out that I should run a mass replace query on a notepad++ but I can't figure out an exact command to achieve this. This is how a post look in the database <div class=\"bbc_spoiler\">\n <span class=\"spoiler_title\">Next move</span> <input type=\"button\" class=\"bbc_spoiler_show\" value=\"Rodyti\"><div class=\"bbc_spoiler_wrapper\"><div class=\"bbc_spoiler_content\" style=\"display:none;\">THE HIDDEN TEXT</div></div>\n</div> and I must replace it to this for it to work normally <div class=\"ipsSpoiler\" data-ipsSpoiler=\"\"><div class=\"ipsSpoiler_header\"><span></span></div><div class=\"ipsSpoiler_contents\"><p>THE HIDDEN TEXT</p></div></div> But the problem is that in the first line ends with </div></div>\n</div> and should be changed to </div></div> and I can't figure out how to make a replacement query that would remove one /div. Thing is that there is about 1300 other instances of </div></div>\n</div> in other bbcodes so if I mass replace that - then I mess up something else entirely in working posts. Link to comment Share on other sites More sharing options...
jaeitee Posted September 9, 2020 Share Posted September 9, 2020 On 4/1/2020 at 11:19 PM, bfarber said: For those email addresses in core_members.email, change the column core_members.allow_admin_mails to 0. Will this also disable them receiving emails from any content they follow throughout the community? Link to comment Share on other sites More sharing options...
bfarber Posted September 9, 2020 Share Posted September 9, 2020 No Link to comment Share on other sites More sharing options...
Recommended Posts