X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=lead-confirm.php;h=47024cf435ab0e061e6c3ad18507ebf7b780dac2;hp=133c95a66cde52375f340b51d0daa0c35486b820;hb=9f6c30cc0e06098171d773d671292081ecee3d29;hpb=7bfee4bc71e5b7b741f3451b27ba0a09574dfca8 diff --git a/lead-confirm.php b/lead-confirm.php index 133c95a66c..47024cf435 100644 --- 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? - $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;