X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=lead-confirm.php;h=c5cab5847bd97a513a6aadcd76f80c338faaabd8;hp=5c806993e114fe18f3b41b2989beee16d7b10cd6;hb=27f65d023a3388a8bd85be8ee5991f776f541847;hpb=43885129ac24cee5545a8a5ad51e90aa182fdf46 diff --git a/lead-confirm.php b/lead-confirm.php index 5c806993e1..c5cab5847b 100644 --- a/lead-confirm.php +++ b/lead-confirm.php @@ -43,10 +43,10 @@ $GLOBALS['what'] = ""; $GLOBALS['action'] = ""; $GLOBALS['module'] = "lead-confirm"; // Load config.php -require ("inc/config.php"); +require("inc/config.php"); // Is the script installed? -if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_installed'))) { +if (isBooleanConstantAndTrue('mxchange_installed')) { // Header require(PATH."inc/header.php"); @@ -59,14 +59,17 @@ if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_install // 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;