New function fetchUserData() introduced to API, total rewrite (not all)
[mailer.git] / lead-confirm.php
index 133c95a..47024cf 100644 (file)
@@ -69,14 +69,12 @@ $content = array(
 // 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) {
+       if (fetchUserData(getSession('lead_userid'))) {
                // Secure the id number
                $content['lead_userid'] = bigintval(getSession('lead_userid'));
 
                // Load the email address
-               list($email) = SQL_FETCHROW($result);
+               $content['lead_email'] = getUserData('email');
        } else {
                // Not found!
                $content['lead_userid'] = 0;