+// Is the cookie set?
+if (isSessionVariableSet('lead_userid')) {
+ // Is the user-account unlocked and valid?
+ $result = SQL_QUERY_ESC("SELECT `email` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s AND `status`='CONFIRMED' LIMIT 1",
+ array(bigintval(getSession('lead_userid'))), __FILE__, __LINE__);
+ if (SQL_NUMROWS($result) == 1) {
+ // Secure the ID number
+ $content['lead_userid'] = bigintval(getSession('lead_userid'));
+
+ // Load the email address
+ list($email) = SQL_FETCHROW($result);