X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fsponsor_functions.php;h=a2b9d11c336de89adfec42d2ea8b1607826a8a4c;hb=64eecfb13d8618ddcf0e9d53920a21b0401b3971;hp=77e0654db9a01aa8007b76ce3e31cadd3d3537a4;hpb=6b35670152207024eac824879ceeffdaf847c972;p=mailer.git

diff --git a/inc/libs/sponsor_functions.php b/inc/libs/sponsor_functions.php
index 77e0654db9..a2b9d11c33 100644
--- a/inc/libs/sponsor_functions.php
+++ b/inc/libs/sponsor_functions.php
@@ -17,7 +17,7 @@
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
  * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
- * For more information visit: http://www.mxchange.org                  *
+ * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
  * it under the terms of the GNU General Public License as published by *
@@ -135,7 +135,7 @@ function handleSponsorRequest ($postData, $update=false, $messageArray = array()
 
 				// Remove last ", " from SQL string
 				$sql = substr($sql, 0, -2)." WHERE `id`=%s LIMIT 1";
-				$DATA['values'][] = bigintval(getRequestParameter('id'));
+				$DATA['values'][] = bigintval(getRequestElement('id'));
 
 				// Generate message
 				$message = getMessageFromIndexedArray('{--ADMIN_SPONSOR_UPDATED--}', 'updated', $messageArray);
@@ -157,7 +157,7 @@ function handleSponsorRequest ($postData, $update=false, $messageArray = array()
 					// Generate hash code
 					$DATA['keys'][] = 'hash';
 					// @TODO Rewrite this to API function
-					$DATA['values'][] = md5(session_id() . getEncryptSeperator() . $postData['email'] . getEncryptSeperator() . detectRemoteAddr() . getEncryptSeperator() . detectUserAgent() . getEncryptSeperator() . time());
+					$DATA['values'][] = md5(session_id() . getEncryptSeparator() . $postData['email'] . getEncryptSeparator() . detectRemoteAddr() . getEncryptSeparator() . detectUserAgent() . getEncryptSeparator() . time());
 					$DATA['keys'][] = 'remote_addr';
 					$DATA['values'][] = detectRemoteAddr();
 				}
@@ -269,7 +269,8 @@ function addSponsorMenu ($current) {
 
 	// Load main menu entries
 	$result_main = SQL_QUERY("SELECT
-	`action` AS `main_action`,`title` AS `main_title`
+	`action` AS `main_action`,
+	`title` AS `main_title`
 FROM
 	`{?_MYSQL_PREFIX?}_sponsor_menu`
 WHERE
@@ -282,7 +283,8 @@ ORDER BY
 		while ($content = SQL_FETCHARRAY($result_main)) {
 			// Load sub menus
 			$result_sub = SQL_QUERY_ESC("SELECT
-	`what` AS `sub_what`,`title` AS `sub_title`
+	`what` AS `sub_what`,
+	`title` AS `sub_title`
 FROM
 	`{?_MYSQL_PREFIX?}_sponsor_menu`
 WHERE
@@ -424,11 +426,11 @@ function saveSponsorData ($postData, $content) {
 			$EMAIL = true;
 
 			// Okay, has changed then add status with UNCONFIRMED and new hash code
-			$sql .= " `status`='EMAIL', `hash`='%s',";
+			$sql .= " `status`='EMAIL',`hash`='%s',";
 
 			// Generate hash code
 			// @TODO Rewrite this to API function
-			$HASH = md5(session_id() . getEncryptSeperator() . $postData['email'] . getEncryptSeperator() . detectRemoteAddr() . getEncryptSeperator() . detectUserAgent() . getEncryptSeperator() . time());
+			$HASH = md5(session_id() . getEncryptSeparator() . $postData['email'] . getEncryptSeparator() . detectRemoteAddr() . getEncryptSeparator() . detectUserAgent() . getEncryptSeparator() . time());
 			$DATA[] = $HASH;
 		} // END - if
 	} // END - if
@@ -436,7 +438,7 @@ function saveSponsorData ($postData, $content) {
 	$sql = substr($sql, 0, -1);
 
 	// Add last_change
-	$sql .= ', `last_change`=NOW()';
+	$sql .= ',`last_change`=NOW()';
 
 	// Add SQL tail data
 	$sql .= " WHERE `id`=%s AND `password`='%s' LIMIT 1";
@@ -535,7 +537,8 @@ function generateSponsorEmailLink ($email, $mod = 'admin') {
 FROM
 	`{?_MYSQL_PREFIX?}_sponsor_data`
 WHERE
-	`email`='%s'" . $locked."
+	'%s' REGEXP `email`
+	" . $locked . "
 LIMIT 1",
 		array($email), __FUNCTION__, __LINE__);
 	if (SQL_NUMROWS($result) == 1) {
@@ -565,8 +568,8 @@ function doProcessSponsorFormRequest ($messageArray = array()) {
 	switch ($status) {
 		case 'added': // Sponsor successfully added with account status = UNCONFIRMED!
 			// Check for his id number
-			$result = SQL_QUERY_ESC("SELECT `id`,`hash` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE `email`='%s' LIMIT 1",
-				array(postRequestParameter('email')), __FUNCTION__, __LINE__);
+			$result = SQL_QUERY_ESC("SELECT `id`,`hash` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE '%s' REGEXP `email` LIMIT 1",
+				array(postRequestElement('email')), __FUNCTION__, __LINE__);
 			if (SQL_NUMROWS($result) == 1) {
 				// id found so let's load it for the confirmation email
 				list($id, $hash) = SQL_FETCHROW($result);
@@ -574,15 +577,15 @@ function doProcessSponsorFormRequest ($messageArray = array()) {
 				// Prepare data for the email template
 				$content['id']        = $id;
 				$content['hash']      = $hash;
-				$content['email']     = postRequestParameter('email');
-				$content['surname']   = postRequestParameter('surname');
-				$content['family']    = postRequestParameter('family');
+				$content['email']     = postRequestElement('email');
+				$content['surname']   = postRequestElement('surname');
+				$content['family']    = postRequestElement('family');
 				$content['timestamp'] = generateDateTime(time(), 0);
-				$content['password']  = postRequestParameter('pass1');
+				$content['password']  = postRequestElement('pass1');
 
 				// Generate email and send it to the new sponsor
 				$message = loadEmailTemplate('sponsor_confirm', $content, $id);
-				sendEmail(postRequestParameter('email'), '{--SPONSOR_PLEASE_CONFIRM_SUBJECT--}', $message);
+				sendEmail(postRequestElement('email'), '{--SPONSOR_PLEASE_CONFIRM_SUBJECT--}', $message);
 
 				// Send mail to admin
 				sendAdminNotification('{--ADMIN_NEW_SPONSOR--}', 'admin_sponsor_reg', $content);
@@ -591,7 +594,7 @@ function doProcessSponsorFormRequest ($messageArray = array()) {
 				$message = $messageArray['added'];
 			} else {
 				// Sponsor account not found???
-				$message = '{%message,SPONSOR_EMAIL_404=' . postRequestParameter('email') . '%}';
+				$message = '{%message,SPONSOR_EMAIL_404=' . postRequestElement('email') . '%}';
 			}
 
 			// Free memory