Checking for unconfirmed email

[gluntz]

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]

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]

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]

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