X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fsponsor_functions.php;h=024a0c9089a633d24a958dec757942aca3c7a58e;hp=6e07f8f46c89513a469ccac4cd7a46da3e29617f;hb=f18a3b60125c8c65861e3205da40447b227f89c9;hpb=62b16291efe168636f5eda2c8644f6770382fb1e

diff --git a/inc/libs/sponsor_functions.php b/inc/libs/sponsor_functions.php
index 6e07f8f46c..024a0c9089 100644
--- a/inc/libs/sponsor_functions.php
+++ b/inc/libs/sponsor_functions.php
@@ -69,7 +69,7 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S
 					$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",
+					$result = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_sponsor_data` WHERE email='%s' LIMIT 1",
 						array($POST['email']), __FILE__, __LINE__);
 
 					// Is a sponsor alread in the db?
@@ -125,7 +125,7 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S
 		// Update?
 		if ($UPDATE) {
 			// Update his data
-			$SQL = "UPDATE `"._MYSQL_PREFIX."_sponsor_data` SET ";
+			$SQL = "UPDATE `{!_MYSQL_PREFIX!}_sponsor_data` SET ";
 			foreach ($DATA['keys'] as $k => $v) {
 				$SQL .= $v."='%s', ";
 			}
@@ -144,7 +144,7 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S
 			if ((!$NO_UPDATE) && (IS_ADMIN()) && ($GLOBALS['what'] == "add_sponsor")) {
 				// Only allowed for admin
 				$DATA['values'][] = "PENDING";
-			} elsen{
+			} else {
 				// Guest area
 				$DATA['values'][] = "UNCONFIRMED";
 
@@ -160,10 +160,10 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S
 			$VALUES = str_repeat("%s', '", count($DATA['values']) - 1);
 
 			// Generate string
-			$SQL = "INSERT INTO `"._MYSQL_PREFIX."_sponsor_data` (".$KEYS.") VALUES ('".$VALUES."%s')";
+			$SQL = "INSERT INTO `{!_MYSQL_PREFIX!}_sponsor_data` (".$KEYS.") VALUES ('".$VALUES."%s')";
 
 			// Generate message
-			$MSG = SPONSOR_GET_MESSAGE(ADMIN_SPONSOR_ADDED, "added", $MSGs);
+			$MSG = SPONSOR_GET_MESSAGE(getMessage('ADMIN_SPONSOR_ADDED'), "added", $MSGs);
 			$ret = "added";
 		} elseif ((!$NO_UPDATE) && (IS_ADMIN())) {
 			// Add all data as hidden data
@@ -171,7 +171,7 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S
 			foreach ($POST as $k => $v) {
 				// Do not add 'force' !
 				if ($k != "force") {
-					$OUT .= "<INPUT type=\"hidden\" name=\"".$k."\" value=\"".stripslashes($v)."\">\n";
+					$OUT .= "<input type=\"hidden\" name=\"".$k."\" value=\"".stripslashes($v)."\" />\n";
 				}
 			}
 			define('__HIDDEN_DATA', $OUT);
@@ -182,7 +182,7 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S
 			return;
 		} else {
 			// Already added!
-			$MSG = SPONSOR_ALREADY_FOUND_1.$POST['email'].SPONSOR_ALREADY_FOUND_2;
+			$MSG = sprintf(getMessage('SPONSOR_ALREADY_FOUND', $POST['email']));
 			$ret = "already";
 		}
 
@@ -197,7 +197,7 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S
 		}
 	} else {
 		// Error found!
-		$MSG = SPONSOR_GET_MESSAGE(SPONSOR_DATA_NOT_SAVED, "failed", $MSGs);
+		$MSG = SPONSOR_GET_MESSAGE(getMessage('SPONSOR_DATA_NOT_SAVED'), "failed", $MSGs);
 		LOAD_TEMPLATE("admin_settings_saved", false, $MSG);
 	}
 
@@ -205,33 +205,18 @@ function SPONSOR_HANDLE_SPONSOR (&$POST, $NO_UPDATE=false, $MSGs=array(), $RET_S
 	if ($RET_STATUS) return $ret;
 }
 //
-function SPONSOR_TRANSLATE_STATUS($status) {
-	switch ($status)
-	{
-	case "UNCONFIRMED":
-		$ret = ACCOUNT_UNCONFIRMED;
-		break;
-
-	case "CONFIRMED":
-		$ret = ACCOUNT_CONFIRMED;
-		break;
-
-	case "LOCKED":
-		$ret = ACCOUNT_LOCKED;
-		break;
-
-	case "PENDING":
-		$ret = ACCOUNT_PENDING;
-		break;
-
-	case "EMAIL":
-		$ret = ACCOUNT_EMAIL;
-		break;
-
-	default:
+function SPONSOR_TRANSLATE_STATUS ($status) {
+	// Construct constant name
+	$constantName = sprintf("ACCOUNT_%s", $status);
+
+	// Is the constant there?
+	if (defined($constantName)) {
+		// Then use it
+		$ret = constant($constantName);
+	} else {
+		// Not found!
 		DEBUG_LOG(__FUNCTION__, __LINE__, sprintf("Unknown status %s detected.", $status));
-		$ret = UNKNOWN_STATUS_1.$status.UNKNOWN_STATUS_2;
-		break;
+		$ret = sprintf(getMessage('UNKNOWN_STATUS'), $status);
 	}
 	return $ret;
 }
@@ -262,10 +247,10 @@ function SPONSOR_GET_MESSAGE ($msg, $pos, $array) {
 function IS_SPONSOR () {
 	// Failed...
 	$ret = false;
-	if ((isSessionVariableSet('sponsorid'))) && (isSessionVariableSet('sponsorpass')))) {
+	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",
+		$result = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_sponsor_data`
+WHERE id='%s' AND password='%s' AND `status`='CONFIRMED' LIMIT 1",
 			array(bigintval(get_session('sponsorid')), get_session('sponsorpass')), __FILE__, __LINE__);
 		if (SQL_NUMROWS($result) == 1) {
 			// All is fine
@@ -287,23 +272,23 @@ function GENERATE_SPONSOR_MENU($current)
 	if (IS_ADMIN()) $WHERE = "";
 
 	// Load main menu entries
-	$result_main = SQL_QUERY("SELECT action, title FROM `"._MYSQL_PREFIX."_sponsor_menu`
-WHERE (what='' OR what IS NULL) ".$WHERE."
-ORDER BY sort", __FILE__, __LINE__);
+	$result_main = SQL_QUERY("SELECT action, title FROM `{!_MYSQL_PREFIX!}_sponsor_menu`
+WHERE (what='' OR `what` IS NULL) ".$WHERE."
+ORDER BY `sort`", __FILE__, __LINE__);
 	if (SQL_NUMROWS($result_main) > 0)
 	{
 		// Load every menu and it's sub menus
-		while(list($action, $title_main) = SQL_FETCHROW($result_main))
+		while (list($action, $title_main) = SQL_FETCHROW($result_main))
 		{
 			// Load sub menus
-			$result_sub = SQL_QUERY_ESC("SELECT what, title FROM `"._MYSQL_PREFIX."_sponsor_menu`
-WHERE action='%s' AND what != '' AND what IS NOT NULL ".$WHERE."
-ORDER BY sort", array($action), __FILE__, __LINE__);
+			$result_sub = SQL_QUERY_ESC("SELECT what, title FROM `{!_MYSQL_PREFIX!}_sponsor_menu`
+WHERE `action`='%s' AND `what` != '' AND `what` IS NOT NULL ".$WHERE."
+ORDER BY `sort`", array($action), __FILE__, __LINE__);
 			if (SQL_NUMROWS($result_sub) > 0)
 			{
 				// Load sub menus
 				$SUB = "";
-				while(list($what, $title_sub) = SQL_FETCHROW($result_sub))
+				while (list($what, $title_sub) = SQL_FETCHROW($result_sub))
 				{
 					// Check if current selected menu is matching the loaded one
 					if ($current == $what) $title_sub = "<strong>".$title_sub."</strong>";
@@ -352,12 +337,11 @@ ORDER BY sort", array($action), __FILE__, __LINE__);
 //
 function GENERATE_SPONSOR_CONTENT($what)
 {
-	global $_CONFIG;
 	$OUT = "";
-	$FILE = sprintf("%sinc/modules/sponsor/%s.php", PATH, $what);
-	if (FILE_READABLE($FILE)) {
+	$INC = sprintf("inc/modules/sponsor/%s.php", $what);
+	if (FILE_READABLE($INC)) {
 		// Every sponsor action will output nothing directly. It will be written into $OUT!
-		require_once($FILE);
+		LOAD_INC_ONCE($INC);
 	} else {
 		// File not found!
 		$OUT .= LOAD_TEMPLATE("admin_settings_saved", true, SPONSOR_CONTENT_404_1.$what.SPONSOR_CONTENT_404_2);
@@ -374,7 +358,7 @@ function UPDATE_SPONSOR_LOGIN () {
 	// Is sponsor?
 	if (IS_SPONSOR()) {
 		// Update last online timestamp
-		SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_sponsor_data`
+		SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_sponsor_data`
 SET last_online=UNIX_TIMESTAMP()
 WHERE id='%s' AND password='%s' LIMIT 1",
 			array(bigintval(get_session('sponsorid')), get_session('sponsorpass')), __FILE__, __LINE__);
@@ -417,7 +401,7 @@ function SPONSOR_SAVE_DATA ($POST, $content) {
 	$DATA = array();
 
 	// Prepare SQL string
-	$SQL = "UPDATE `"._MYSQL_PREFIX."_sponsor_data` SET";
+	$SQL = "UPDATE `{!_MYSQL_PREFIX!}_sponsor_data` SET";
 	foreach ($POST as $key => $value) {
 		// Mmmmm, too less security here???
 		$SQL   .= " ".strip_tags($key)."='%s',";
@@ -436,7 +420,7 @@ function SPONSOR_SAVE_DATA ($POST, $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
 			$HASH = md5(session_id().":".$POST['email'].":".GET_REMOTE_ADDR().":".GET_USER_AGENT().":".time());
@@ -456,16 +440,14 @@ function SPONSOR_SAVE_DATA ($POST, $content) {
 	switch ($GLOBALS['what'])
 	{
 	case "account": // Change account data
-		if ($EMAIL) {
-			$MSG   = SPONSOR_ACCOUNT_EMAIL_CHANGED;
+		if ($EMAIL === true) {
+			$MSG   = getMessage('SPONSOR_ACCOUNT_EMAIL_CHANGED');
 			$templ = "admin_sponsor_change_email";
-			$subj  = ADMIN_SPONSOR_ACC_EMAIL_SUBJ;
-		}
-		 else
-		{
-			$MSG   = SPONSOR_ACCOUNT_DATA_SAVED;
+			$subj  = getMessage('ADMIN_SPONSOR_ACC_EMAIL_SUBJ');
+		} else {
+			$MSG   = getMessage('SPONSOR_ACCOUNT_DATA_SAVED');
 			$templ = "admin_sponsor_change_data";
-			$subj  = ADMIN_SPONSOR_ACC_DATA_SUBJ;
+			$subj  = getMessage('ADMIN_SPONSOR_ACC_DATA_SUBJ');
 		}
 		break;
 
@@ -475,22 +457,20 @@ function SPONSOR_SAVE_DATA ($POST, $content) {
 		$content['interval'] = CREATE_FANCY_TIME($content['warning_interval']);
 
 		// Set message template and subject for admin
-		$MSG   = SPONSOR_SETTINGS_SAVED;
+		$MSG   = getMessage('SPONSOR_SETTINGS_SAVED');
 		$templ = "admin_sponsor_settings";
-		$subj  = ADMIN_SPONSOR_SETTINGS_SUBJ;
+		$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']));
-		$MSG = SPONSOR_UNKNOWN_WHAT_1.$GLOBALS['what'].SPONSOR_UNKNOWN_WHAT_2;
+		$MSG = sprintf(getMessage('SPONSOR_UNKNOWN_WHAT'), $GLOBALS['what']);
 		$templ = ""; $subj = "";
 		break;
 	}
 
-	if (SQL_AFFECTEDROWS() == 1)
-	{
-		if (!empty($templ) && !empty($subj))
-		{
+	if (SQL_AFFECTEDROWS() == 1) {
+		if (!empty($templ) && !empty($subj)) {
 			// Run SQL command and check for success
 			$result = SQL_QUERY_ESC($SQL, $DATA, __FILE__, __LINE__);
 
@@ -508,8 +488,7 @@ function SPONSOR_SAVE_DATA ($POST, $content) {
 			SEND_ADMIN_NOTIFICATION($subj, $templ, $content);
 
 			// Shall we send mail to the sponsor's new email address?
-			if ($content['receive_warnings'] == "Y")
-			{
+			if ($content['receive_warnings'] == "Y") {
 				// Okay send email with confirmation link to new address and with no confirmation link
 				// to the old address
 
@@ -518,23 +497,22 @@ function SPONSOR_SAVE_DATA ($POST, $content) {
 				{
 				case "account": // Change account data
 					$email_msg = LOAD_EMAIL_TEMPLATE("sponsor_change_data", $content);
-					SEND_EMAIL($content['email'], SPONSOR_ACC_DATA_SUBJ, $email_msg);
+					SEND_EMAIL($content['email'], getMessage('SPONSOR_ACC_DATA_SUBJ'), $email_msg);
 
-					if ($EMAIL)
-					{
+					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);
-						SEND_EMAIL($content['email'], SPONSOR_ACC_EMAIL_SUBJ, $email_msg);
+						SEND_EMAIL($content['email'], getMessage('SPONSOR_ACC_EMAIL_SUBJ'), $email_msg);
 					}
 					break;
 
 				case "settings": // Change settings
 					// Send email
 					$email_msg = LOAD_EMAIL_TEMPLATE("sponsor_settings", $content);
-					SEND_EMAIL($content['email'], SPONSOR_SETTINGS_SUBJ, $email_msg);
+					SEND_EMAIL($content['email'], getMessage('SPONSOR_SETTINGS_SUBJ'), $email_msg);
 					break;
 				}
 			}
@@ -544,5 +522,6 @@ function SPONSOR_SAVE_DATA ($POST, $content) {
 	// Return final message
 	return $MSG;
 }
+
 //
 ?>