X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=lead-confirm.php;h=d9724b76969187bf92cc7e7ccc3dc63a71d19147;hp=bb4112b0f912d09ab4e0bf37130420265b518743;hb=09f71ca6aae11f51fa5c32379cb790d93964610f;hpb=0e899620c7a065952d6787c236fb2b33ae337d6a

diff --git a/lead-confirm.php b/lead-confirm.php
index bb4112b0f9..d9724b7696 100644
--- a/lead-confirm.php
+++ b/lead-confirm.php
@@ -46,7 +46,7 @@ $GLOBALS['module'] = "lead-confirm";
 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;