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

diff --git a/lead-confirm.php b/lead-confirm.php
index bb4112b0f9..1214fec931 100644
--- a/lead-confirm.php
+++ b/lead-confirm.php
@@ -32,7 +32,7 @@
  ************************************************************************/
 
 // Load security stuff here (Oh, I hope this is not unsecure? Am I paranoia??? ;-) )
-require_once("inc/libs/security_functions.php");
+require("inc/libs/security_functions.php");
 
 // Init "action" and "what"
 global $what, $action, $startTime;
@@ -42,13 +42,16 @@ $GLOBALS['what'] = ""; $GLOBALS['action'] = "";
 // Set module
 $GLOBALS['module'] = "lead-confirm";
 
+// Set "CSS-Mode"
+$CSS = "0";
+
 // 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");
+	LOAD_INC("inc/header.php");
 
 	// Initialize the array for the template
 	$content = array(
@@ -59,30 +62,33 @@ 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;
 		}
 	} else {
 		// Maybe spider?
-		$content['lead_email'] = WEBMASTER;
+		$content['lead_email'] = constant('WEBMASTER');
 	}
 
 	// Load the lead template
 	LOAD_TEMPLATE("lead_code", false, $content);
 
 	// Footer
-	require(PATH."inc/footer.php");
+	LOAD_INC("inc/footer.php");
 } else {
-	// You have to configure first!
+	// You have to install first!
 	LOAD_URL("install.php");
 }