New function fetchUserData() introduced to API, total rewrite (not all)

[mailer.git] / lead-confirm.php

diff --git a/lead-confirm.php b/lead-confirm.php
index 133c95a66cde52375f340b51d0daa0c35486b820..47024cf435ab0e061e6c3ad18507ebf7b780dac2 100644 (file)
--- a/lead-confirm.php
+++ b/lead-confirm.php
@@ -69,14 +69,12 @@ $content = array(
 // Is the cookie set?
 if (isSessionVariableSet('lead_userid')) {
        // Is the user-account unlocked and valid?
 // 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
                // 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;
        } else {
                // Not found!
                $content['lead_userid'] = 0;