X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=lead-confirm.php;h=6b53ae93b1a599f13ac307c78175f4f7732d88b7;hb=d0d885e08aba45b77818d49bcf40396bf788c386;hp=6f2b0ef79d55ce252b547cc943234fc4062a2c95;hpb=64c8349613addc3da2242c5cd6b99d64e3fb5f8e;p=mailer.git

diff --git a/lead-confirm.php b/lead-confirm.php
index 6f2b0ef79d..6b53ae93b1 100644
--- a/lead-confirm.php
+++ b/lead-confirm.php
@@ -69,17 +69,15 @@ $content = array(
 // Is the cookie set?
 if (isSessionVariableSet('lead_userid')) {
 	// 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",
-		array(bigintval(getSession('lead_userid'))), __FILE__, __LINE__);
-	if (SQL_NUMROWS($result) == 1) {
-		// Secure the ID number
+	if (fetchUserData(getSession('lead_userid'))) {
+		// Secure the id number
 		$content['lead_userid'] = bigintval(getSession('lead_userid'));
 
 		// Load the email address
-		list($email) = SQL_FETCHROW($result);
+		$content['lead_email'] = getUserData('email');
 	} else {
 		// Not found!
-		$content['lead_userid'] = 0;
+		$content['lead_userid'] = '0';
 	}
 } else {
 	// Maybe spider?