X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=lead-confirm.php;h=c5cab5847bd97a513a6aadcd76f80c338faaabd8;hp=0f62cef8d79b88088c43a879977cb3383e25d572;hb=4bd12d7c844163f67cca3489aa0b6c9af61d8adb;hpb=b56eadb18a023f4d2d712e8936b4dc1ad31fd580 diff --git a/lead-confirm.php b/lead-confirm.php index 0f62cef8d7..c5cab5847b 100644 --- a/lead-confirm.php +++ b/lead-confirm.php @@ -43,7 +43,7 @@ $GLOBALS['what'] = ""; $GLOBALS['action'] = ""; $GLOBALS['module'] = "lead-confirm"; // Load config.php -require ("inc/config.php"); +require("inc/config.php"); // Is the script installed? if (isBooleanConstantAndTrue('mxchange_installed')) { @@ -59,14 +59,17 @@ if (isBooleanConstantAndTrue('mxchange_installed')) { // 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", + $result = SQL_QUERY_ESC("SELECT email FROM `"._MYSQL_PREFIX."_user_data` WHERE userid=%s AND status='CONFIRMED' LIMIT 1", array(bigintval(get_session('lead_uid'))), __FILE__, __LINE__); if (SQL_NUMROWS($result) == 1) { // Secure the ID number $content['lead_uid'] = bigintval(get_session('lead_uid')); // Load the email address - list($content['lead_email']) = COMPILE_CODE(SQL_FETCHROW($result)); + list($email) = SQL_FETCHROW($result); + + // Compile email + $content['lead_email'] = COMPILE_CODE($email); } else { // Not found! $content['lead_uid'] = 0;