X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fsponsor_functions.php;h=fb8ac7bf8902071708d2ba1b0b49d5e4a2ae26b8;hp=1d19320d9319ee0f9f31bcb5244e820d866a7f9e;hb=f928ad2bed60fa256d0641eaf6d2c027a2944688;hpb=7b0f17cd637e388049d2167811e4332cec1e979b

diff --git a/inc/libs/sponsor_functions.php b/inc/libs/sponsor_functions.php
index 1d19320d93..fb8ac7bf89 100644
--- a/inc/libs/sponsor_functions.php
+++ b/inc/libs/sponsor_functions.php
@@ -53,161 +53,161 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $messageArray=array()
 	// Skip these entries
 	$SKIPPED = array(
 		'ok', 'edit', 'terms', 'pay_type'
-	);
+		);
 
-	// Save sponsor data
-	$DATA = array(
+		// Save sponsor data
+		$DATA = array(
 		'keys'   => array(),
 		'values' => array()
-	);
-
- 	// Check if sponsor already exists
-	foreach ($POST as $k => $v) {
-		if (!(array_search($k, $SKIPPED) > -1)) {
-			// Check only posted input entries not the submit button
-			switch ($k)
-			{
-			case 'email':
-				$ALREADY = false;
-				if (!VALIDATE_EMAIL($v)) {
-					// Email address is not valid
-					$SAVE = false;
-				} else {
-					// Do we want to add a new sponsor or update his data?
-					$result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_sponsor_data` WHERE email='%s' LIMIT 1",
-						array($POST['email']), __FUNCTION__, __LINE__);
-
-					// Is a sponsor alread in the db?
-					if (SQL_NUMROWS($result) == 1) {
-						// Yes, he is!
-						if (($GLOBALS['what'] == "add_sponsor") || ($NO_UPDATE)) {
-							// Already found!
-							$ALREADY = true;
+		);
+
+		// Check if sponsor already exists
+		foreach ($POST as $k => $v) {
+			if (!(array_search($k, $SKIPPED) > -1)) {
+				// Check only posted input entries not the submit button
+				switch ($k)
+				{
+					case 'email':
+						$ALREADY = false;
+						if (!isEmailValid($v)) {
+							// Email address is not valid
+							$SAVE = false;
 						} else {
-							// Update his data
-							$UPDATE = true;
+							// Do we want to add a new sponsor or update his data?
+							$result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_sponsor_data` WHERE email='%s' LIMIT 1",
+							array($POST['email']), __FUNCTION__, __LINE__);
+
+							// Is a sponsor alread in the db?
+							if (SQL_NUMROWS($result) == 1) {
+								// Yes, he is!
+								if ((getWhat() == 'add_sponsor') || ($NO_UPDATE)) {
+									// Already found!
+									$ALREADY = true;
+								} else {
+									// Update his data
+									$UPDATE = true;
+								}
+							}
+
+							// Free memory
+							SQL_FREERESULT($result);
 						}
-					}
-
-					// Free memory
-					SQL_FREERESULT($result);
-				}
-				break;
+						break;
 
-			case "pass1":
-				$k = ''; $v = '';
-				break;
+					case 'pass1':
+						$k = ''; $v = '';
+						break;
 
-			case "pass2":
-				$k = "password"; $v = md5($v);
-				break;
+					case 'pass2':
+						$k = 'password'; $v = md5($v);
+						break;
 
-			case "url":
-				if (!isUrlValid($v)) $SAVE = false;
-				break;
+					case 'url':
+						if (!isUrlValid($v)) $SAVE = false;
+						break;
 
-			default:
-				// Test if there is are time selections
-				convertSelectionsToTimestamp($POST, $DATA, $k, $skip);
-				break;
-			}
+					default:
+						// Test if there is are time selections
+						convertSelectionsToTimestamp($POST, $DATA, $k, $skip);
+						break;
+				}
 
-			if ((!empty($k)) && ($skip == false)) {
-				// Add data
-				$DATA['keys'][] = $k; $DATA['values'][] = $v;
+				if ((!empty($k)) && ($skip == false)) {
+					// Add data
+					$DATA['keys'][] = $k; $DATA['values'][] = $v;
+				}
 			}
 		}
-	}
 
-	// Save sponsor?
-	if ($SAVE) {
-		// Default is no force even when a guest want to abuse this force switch
-		if ((empty($POST['force'])) || (!IS_ADMIN())) $POST['force'] = 0;
+		// Save sponsor?
+		if ($SAVE === true) {
+			// Default is no force even when a guest want to abuse this force switch
+			if ((empty($POST['force'])) || (!IS_ADMIN())) $POST['force'] = 0;
 
-		// SQL and message string is empty by default
-		$sql = ''; $message = '';
+			// SQL and message string is empty by default
+			$sql = ''; $message = '';
 
-		// Update?
-		if ($UPDATE) {
-			// Update his data
-			$sql = "UPDATE `{!_MYSQL_PREFIX!}_sponsor_data` SET ";
-			foreach ($DATA['keys'] as $k => $v) {
-				$sql .= $v."='%s', ";
-			}
+			// Update?
+			if ($UPDATE) {
+				// Update his data
+				$sql = "UPDATE `{!_MYSQL_PREFIX!}_sponsor_data` SET ";
+				foreach ($DATA['keys'] as $k => $v) {
+					$sql .= $v."='%s', ";
+				}
 
-			// Remove last ", " from SQL string
-			$sql = substr($sql, 0, -2)." WHERE `id`='%s' LIMIT 1";
-			$DATA['values'][] = bigintval(REQUEST_GET('id'));
-
-			// Generate message
-			$message = SPONSOR_GET_MESSAGE(ADMIN_SPONSOR_UPDATED, "updated", $messageArray);
-			$ret = "updated";
-		} elseif ((!$ALREADY) || (($POST['force'] == "1") && (IS_ADMIN()))) {
-			// Add new sponsor, first add more data
-			$DATA['keys'][] = "sponsor_created"; $DATA['values'][] = time();
-			$DATA['keys'][] = 'status';
-			if ((!$NO_UPDATE) && (IS_ADMIN()) && ($GLOBALS['what'] == "add_sponsor")) {
-				// Only allowed for admin
-				$DATA['values'][] = "PENDING";
-			} else {
-				// Guest area
-				$DATA['values'][] = "UNCONFIRMED";
-
-				// Generate hash code
-				$DATA['keys'][] = "hash";
-				$DATA['values'][] = md5(session_id().':'.$POST['email'].':'.detectRemoteAddr().':'.detectUserAgent().':'.time());
-				$DATA['keys'][] = "remote_addr";
-				$DATA['values'][] = detectRemoteAddr();
-			}
+				// Remove last ", " from SQL string
+				$sql = substr($sql, 0, -2)." WHERE `id`='%s' LIMIT 1";
+				$DATA['values'][] = bigintval(REQUEST_GET('id'));
+
+				// Generate message
+				$message = SPONSOR_GET_MESSAGE(ADMIN_SPONSOR_UPDATED, "updated", $messageArray);
+				$ret = "updated";
+			} elseif ((!$ALREADY) || (($POST['force'] == '1') && (IS_ADMIN()))) {
+				// Add new sponsor, first add more data
+				$DATA['keys'][] = "sponsor_created"; $DATA['values'][] = time();
+				$DATA['keys'][] = 'status';
+				if ((!$NO_UPDATE) && (IS_ADMIN()) && (getWhat() == "add_sponsor")) {
+					// Only allowed for admin
+					$DATA['values'][] = 'PENDING';
+				} else {
+					// Guest area
+					$DATA['values'][] = 'UNCONFIRMED';
+
+					// Generate hash code
+					$DATA['keys'][] = "hash";
+					$DATA['values'][] = md5(session_id().':'.$POST['email'].':'.detectRemoteAddr().':'.detectUserAgent().':'.time());
+					$DATA['keys'][] = "remote_addr";
+					$DATA['values'][] = detectRemoteAddr();
+				}
 
-			// Implode all data into strings
-			$KEYS   = implode(", "  , $DATA['keys']);
-			$valueS = str_repeat("%s', '", count($DATA['values']) - 1);
-
-			// Generate string
-			$sql = "INSERT INTO `{!_MYSQL_PREFIX!}_sponsor_data` (".$KEYS.") VALUES ('".$valueS."%s')";
-
-			// Generate message
-			$message = SPONSOR_GET_MESSAGE(getMessage('ADMIN_SPONSOR_ADDED'), "added", $messageArray);
-			$ret = "added";
-		} elseif ((!$NO_UPDATE) && (IS_ADMIN())) {
-			// Add all data as hidden data
-			$OUT = '';
-			foreach ($POST as $k => $v) {
-				// Do not add 'force' !
-				if ($k != "force") {
-					$OUT .= "<input type=\"hidden\" name=\"".$k."\" value=\"".stripslashes($v)."\" />\n";
+				// Implode all data into strings
+				$KEYS   = implode(", "  , $DATA['keys']);
+				$valueS = str_repeat("%s', '", count($DATA['values']) - 1);
+
+				// Generate string
+				$sql = "INSERT INTO `{!_MYSQL_PREFIX!}_sponsor_data` (".$KEYS.") VALUES ('".$valueS."%s')";
+
+				// Generate message
+				$message = SPONSOR_GET_MESSAGE(getMessage('ADMIN_SPONSOR_ADDED'), "added", $messageArray);
+				$ret = "added";
+			} elseif ((!$NO_UPDATE) && (IS_ADMIN())) {
+				// Add all data as hidden data
+				$OUT = '';
+				foreach ($POST as $k => $v) {
+					// Do not add 'force' !
+					if ($k != "force") {
+						$OUT .= "<input type=\"hidden\" name=\"".$k."\" value=\"".stripslashes($v)."\" />\n";
+					}
 				}
-			}
-			define('__HIDDEN_DATA', $OUT);
-			define('__EMAIL'      , $POST['email']);
+				define('__HIDDEN_DATA', $OUT);
+				define('__EMAIL'      , $POST['email']);
 
-			// Ask for adding a sponsor with same email address
-			LOAD_TEMPLATE("admin_add_sponsor_already");
-			return;
-		} else {
-			// Already added!
-			$message = sprintf(getMessage('SPONSOR_ALREADY_FOUND', $POST['email']));
-			$ret = "already";
-		}
+				// Ask for adding a sponsor with same email address
+				LOAD_TEMPLATE("admin_add_sponsor_already");
+				return;
+			} else {
+				// Already added!
+				$message = sprintf(getMessage('SPONSOR_ALREADY_FOUND', $POST['email']));
+				$ret = 'already';
+			}
 
-		if (!empty($sql)) {
-			// Run SQL command
-			$result = SQL_QUERY_ESC($sql, $DATA['values'], __FUNCTION__, __LINE__);
-		}
+			if (!empty($sql)) {
+				// Run SQL command
+				$result = SQL_QUERY_ESC($sql, $DATA['values'], __FUNCTION__, __LINE__);
+			} // END - if
 
-		// Output message
-		if ((!$NO_UPDATE) && (IS_ADMIN())) {
+			// Output message
+			if ((!$NO_UPDATE) && (IS_ADMIN())) {
+				LOAD_TEMPLATE('admin_settings_saved', false, $message);
+			} // END - if
+		} else {
+			// Error found!
+			$message = SPONSOR_GET_MESSAGE(getMessage('SPONSOR_DATA_NOT_SAVED'), 'failed', $messageArray);
 			LOAD_TEMPLATE('admin_settings_saved', false, $message);
 		}
-	} else {
-		// Error found!
-		$message = SPONSOR_GET_MESSAGE(getMessage('SPONSOR_DATA_NOT_SAVED'), "failed", $messageArray);
-		LOAD_TEMPLATE('admin_settings_saved', false, $message);
-	}
 
-	// Shall we return the status?
-	if ($RET_STATUS) return $ret;
+		// Shall we return the status?
+		if ($RET_STATUS === true) return $ret;
 }
 //
 function sponsorTranslateUserStatus ($status) {
@@ -228,20 +228,20 @@ function sponsorTranslateUserStatus ($status) {
 // Search for an email address in the database
 function SPONSOR_FOUND_EMAIL_DB ($email) {
 	// Do we already have the provided email address in our DB?
-	$ret = (GET_TOTAL_DATA($email, "sponsor_data", "id", 'email', true) == 1);
+	$ret = (GET_TOTAL_DATA($email, "sponsor_data", 'id', 'email', true) == 1);
 
 	// Return result
 	return $ret;
 }
 //
-function SPONSOR_GET_MESSAGE ($msg, $pos, $array) {
+function SPONSOR_GET_MESSAGE ($message, $pos, $array) {
 	// Check if the requested message was found in array
 	if (isset($array[$pos])) {
 		// ... if yes then use it!
 		$ret = $array[$pos];
 	} else {
 		// ... else use default message
-		$ret = $msg;
+		$ret = $message;
 	}
 
 	// Return result
@@ -254,24 +254,32 @@ function IS_SPONSOR () {
 	$ret = false;
 	if ((isSessionVariableSet('sponsorid')) && (isSessionVariableSet('sponsorpass'))) {
 		// Check cookies against database records...
-		$result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_sponsor_data`
-WHERE `id`='%s' AND password='%s' AND `status`='CONFIRMED' LIMIT 1",
-			array(bigintval(getSession('sponsorid')), getSession('sponsorpass')), __FUNCTION__, __LINE__);
+		$result = SQL_QUERY_ESC("SELECT
+	`id`
+FROM
+	`{!_MYSQL_PREFIX!}_sponsor_data`
+WHERE
+	`id`='%s' AND `password`='%s' AND `status`='CONFIRMED'
+LIMIT 1",
+			array(
+				bigintval(getSession('sponsorid')),
+				getSession('sponsorpass')
+			), __FUNCTION__, __LINE__);
 		if (SQL_NUMROWS($result) == 1) {
 			// All is fine
 			$ret = true;
-		}
+		} // END - if
 
 		// Free memory
 		SQL_FREERESULT($result);
-	}
+	} // END - if
 
 	// Return status
 	return $ret;
 }
+
 //
-function GENERATE_SPONSOR_MENU($current)
-{
+function GENERATE_SPONSOR_MENU ($current) {
 	$OUT = '';
 	$WHERE = " AND active='Y'";
 	if (IS_ADMIN()) $WHERE = '';
@@ -287,7 +295,7 @@ ORDER BY `sort`", __FUNCTION__, __LINE__);
 			$result_sub = SQL_QUERY_ESC("SELECT what AS sub_what, title AS sub_title FROM `{!_MYSQL_PREFIX!}_sponsor_menu`
 WHERE `action`='%s' AND `what` != '' AND `what` IS NOT NULL ".$WHERE."
 ORDER BY `sort`",
-				array($content['main_action']), __FUNCTION__, __LINE__);
+			array($content['main_action']), __FUNCTION__, __LINE__);
 			if (SQL_NUMROWS($result_sub) > 0) {
 				// Load sub menus
 				$SUB = '';
@@ -363,7 +371,7 @@ function UPDATE_SPONSOR_LOGIN () {
 		SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_sponsor_data`
 SET last_online=UNIX_TIMESTAMP()
 WHERE `id`='%s' AND password='%s' LIMIT 1",
-			array(bigintval(getSession('sponsorid')), getSession('sponsorpass')), __FUNCTION__, __LINE__);
+		array(bigintval(getSession('sponsorid')), getSession('sponsorpass')), __FUNCTION__, __LINE__);
 
 		// This update went fine?
 		$login = (SQL_AFFECTEDROWS() == 1);
@@ -439,36 +447,36 @@ function SPONSOR_SAVE_DATA ($POST, $content) {
 	$DATA[] = getSession('sponsorpass');
 
 	// Saving data was completed... ufff...
-	switch ($GLOBALS['what'])
+	switch (getWhat())
 	{
-	case "account": // Change account data
-		if ($EMAIL === true) {
-			$message   = getMessage('SPONSOR_ACCOUNT_EMAIL_CHANGED');
-			$templ = "admin_sponsor_change_email";
-			$subj  = getMessage('ADMIN_SPONSOR_ACC_EMAIL_SUBJ');
-		} else {
-			$message   = getMessage('SPONSOR_ACCOUNT_DATA_SAVED');
-			$templ = "admin_sponsor_change_data";
-			$subj  = getMessage('ADMIN_SPONSOR_ACC_DATA_SUBJ');
-		}
-		break;
-
-	case "settings": // Change settings
-		// Translate some data
-		$content['receive']  = translateYesNo($content['receive_warnings']);
-		$content['interval'] = createFancyTime($content['warning_interval']);
-
-		// Set message template and subject for admin
-		$message   = getMessage('SPONSOR_SETTINGS_SAVED');
-		$templ = "admin_sponsor_settings";
-		$subj  = getMessage('ADMIN_SPONSOR_SETTINGS_SUBJ');
-		break;
-
-	default: // Unknown sponsor what value!
-		DEBUG_LOG(__FUNCTION__, __LINE__, sprintf("Unknown sponsor module (what) %s detected.", $GLOBALS['what']));
-		$message = sprintf(getMessage('SPONSOR_UNKNOWN_WHAT'), $GLOBALS['what']);
-		$templ = ''; $subj = '';
-		break;
+		case 'account': // Change account data
+			if ($EMAIL === true) {
+				$message   = getMessage('SPONSOR_ACCOUNT_EMAIL_CHANGED');
+				$templ = 'admin_sponsor_change_email';
+				$subj  = getMessage('ADMIN_SPONSOR_ACC_EMAIL_SUBJ');
+			} else {
+				$message   = getMessage('SPONSOR_ACCOUNT_DATA_SAVED');
+				$templ = 'admin_sponsor_change_data';
+				$subj  = getMessage('ADMIN_SPONSOR_ACC_DATA_SUBJ');
+			}
+			break;
+
+		case 'settings': // Change settings
+			// Translate some data
+			$content['receive']  = translateYesNo($content['receive_warnings']);
+			$content['interval'] = createFancyTime($content['warning_interval']);
+
+			// Set message template and subject for admin
+			$message   = getMessage('SPONSOR_SETTINGS_SAVED');
+			$templ = 'admin_sponsor_settings';
+			$subj  = getMessage('ADMIN_SPONSOR_SETTINGS_SUBJ');
+			break;
+
+		default: // Unknown sponsor what value!
+			DEBUG_LOG(__FUNCTION__, __LINE__, sprintf("Unknown sponsor module (what) %s detected.", getWhat()));
+			$message = sprintf(getMessage('SPONSOR_UNKNOWN_WHAT'), getWhat());
+			$templ = ''; $subj = '';
+			break;
 	}
 
 	if (SQL_AFFECTEDROWS() == 1) {
@@ -481,8 +489,8 @@ function SPONSOR_SAVE_DATA ($POST, $content) {
 			$DATA = $POST;
 
 			// Change some data
-			if (isset($content['gender'])) $content['gender'] = translateGender($content['gender']);
-			if (isset($DATA['gender']))    $DATA['gender']    = translateGender($DATA['gender']);
+			if (isset($content['gender']))           $content['gender']   = translateGender($content['gender']);
+			if (isset($DATA['gender']))              $DATA['gender']      = translateGender($DATA['gender']);
 			if (isset($content['receive_warnings'])) $DATA['receive']     = translateYesNo($POST['receive_warnings']);
 			if (isset($content['warning_interval'])) $DATA['interval']    = createFancyTime($POST['warning_interval']);
 
@@ -495,27 +503,27 @@ function SPONSOR_SAVE_DATA ($POST, $content) {
 				// to the old address
 
 				// First to old address
-				switch ($GLOBALS['what'])
+				switch (getWhat())
 				{
-				case "account": // Change account data
-					$email_msg = LOAD_EMAIL_TEMPLATE("sponsor_change_data", $content);
-					sendEmail($content['email'], getMessage('SPONSOR_ACC_DATA_SUBJ'), $email_msg);
+					case 'account': // Change account data
+						$email_msg = LOAD_EMAIL_TEMPLATE('sponsor_change_data', $content);
+						sendEmail($content['email'], getMessage('SPONSOR_ACC_DATA_SUBJ'), $email_msg);
 
-					if ($EMAIL === true) {
-						// Add hash code to content array
-						$content['hash'] = $HASH;
+						if ($EMAIL === true) {
+							// Add hash code to content array
+							$content['hash'] = $HASH;
 
-						// Second mail goes to the new address
-						$email_msg = LOAD_EMAIL_TEMPLATE("sponsor_change_email", $content);
-						sendEmail($content['email'], getMessage('SPONSOR_ACC_EMAIL_SUBJ'), $email_msg);
-					}
-					break;
+							// Second mail goes to the new address
+							$email_msg = LOAD_EMAIL_TEMPLATE('sponsor_change_email', $content);
+							sendEmail($content['email'], getMessage('SPONSOR_ACC_EMAIL_SUBJ'), $email_msg);
+						}
+						break;
 
-				case "settings": // Change settings
-					// Send email
-					$email_msg = LOAD_EMAIL_TEMPLATE("sponsor_settings", $content);
-					sendEmail($content['email'], getMessage('SPONSOR_SETTINGS_SUBJ'), $email_msg);
-					break;
+					case 'settings': // Change settings
+						// Send email
+						$email_msg = LOAD_EMAIL_TEMPLATE('sponsor_settings', $content);
+						sendEmail($content['email'], getMessage('SPONSOR_SETTINGS_SUBJ'), $email_msg);
+						break;
 				}
 			} // END - if
 		} // END - if