ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => Customization, Integration => Topic started by: gluntz on July 24, 2008, 12:42:56 pm

Title: Checking for unconfirmed email
Post by: gluntz on July 24, 2008, 12:42:56 pm

While adding from querystring method to a list is there a way to return a customized error message in the event that a person is marked as 'unconfirmed' in the list?

Title: Checking for unconfirmed email
Post by: DW on July 24, 2008, 01:33:52 pm

By querystring method do you mean you are using an insertion script similar to as seen here (http://listmailpro.com/forum/index.php?topic=1160.0)?

Can you tell me more about what you are doing?  It sounds like you are trying to warn users who were added, in a previous execution of the addition script, to confirm?

Regards

Title: Checking for unconfirmed email
Post by: gluntz on July 24, 2008, 03:02:09 pm

Similar, yes, but not exactly; the overwrite switch won't work in my case due to the nature of the welcome email being generated is variable based on their !user1 value.

In my case I have a list with multiple entrance points; so I need a way to say "hey - you're unconfirmed; please confirm your email to proceed"

Title: Checking for unconfirmed email
Post by: DW on July 25, 2008, 10:50:19 am

Do you have a place within your setup to perform MySQL database queries?  A user is unconfirmed when they are on the list with a "cnf" field value of "0".

Code: [Select]

list($unconfirmed)=@mysql_fetch_row(mysql_query("select email from lm_users where list = '1' and email like '".addslashes($email)."' and cnf = '0';"));

if($unconfirmed){
  echo "Please confirm";
}
Regards