Author Topic: Checking for unconfirmed email (Read 4287 times)

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?

DW · « **Reply #1 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?

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

gluntz · « **Reply #2 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"

DW · « **Reply #3 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