Originally Posted by sundance
We use to only have about 4k in returns and we do send the emails with a message on how to remove yourself from the email notifications.

But it is not possible to re move 13k in emails one at a time. So the big question is how to capture all of the returns and then do an export of that data / emails only and then remove it from the UBB database email?

Originally Posted by isaac
If 13K came back to you, then you already know their addresses are "UNdeliverable."

Write a SQL query and execute it within the CONTROL PANEL > DATABASE TOOLS > SQL COMMAND page.

Similar to the following:

update ubbt_USER_PROFILE
set USER_ACCEPT_ADMIN_EMAILS = 'off'
where USER_REAL_EMAIL = 'mail@example.com'

mail@example.com would be where you insert the address you wanted to disable admin emails for. Do this for each address.

Write a batch to update your forum.
update ubbt_USER_PROFILE set USER_ACCEPT_ADMIN_EMAILS = 'off' where USER_REAL_EMAIL = 'mail@example.com'


Originally Posted by sundance
how to capture all of the returns

Originally Posted by sundance
13K are coming back

That set of data that comes back to you seems like a good place to begin generating a list with.


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com