X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=lead-confirm.php;h=c5cab5847bd97a513a6aadcd76f80c338faaabd8;hb=310ab1fd53100627fa054ea5579f283ed77bfaec;hp=bb4112b0f912d09ab4e0bf37130420265b518743;hpb=0e899620c7a065952d6787c236fb2b33ae337d6a;p=mailer.git

diff --git a/lead-confirm.php b/lead-confirm.php
index bb4112b0f9..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=%d 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;