- $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