- // Load the email address
- list($content['lead_email']) = COMPILE_CODE(SQL_FETCHROW($result));
- } else {
- // Not found!
- $content['lead_uid'] = 0;
- }
- } else {
- // Maybe spider?
- $content['lead_email'] = WEBMASTER;
- }
+// Initialize the array for the template
+$content = array(
+ 'lead_uid' => -1,
+ 'lead_email' => 'INVALID@EMAIL'
+);
+
+// Is the cookie set?
+if (isSessionVariableSet('lead_uid')) {
+ // 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_uid'))), __FILE__, __LINE__);
+ if (SQL_NUMROWS($result) == 1) {
+ // Secure the ID number
+ $content['lead_uid'] = bigintval(getSession('lead_uid'));