All database names are now 'back-ticked' and constant _MYSQL_PREFIX is wrapped. Partl...

[mailer.git] / lead-confirm.php

diff --git a/lead-confirm.php b/lead-confirm.php
index 0f62cef8d79b88088c43a879977cb3383e25d572..4ba44b42b6073d4a923750fd45792cf587e10342 100644 (file)
--- 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;
@@ -82,7 +85,7 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
        // Footer
        require(PATH."inc/footer.php");
 } else {
-       // You have to configure first!
+       // You have to install first!
        LOAD_URL("install.php");
 }