X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-edit_sponsor.php;h=04707bc3c13dd5e7644ee9d67d67394eba9f9dc3;hb=1c7baeb4bdbc27de48da5a338e9e5d0a894d5abc;hp=c906266a750856930b328e9a0ce7c18033585137;hpb=09f5758c42a33a56bdd461c946ffe759a59c54aa;p=mailer.git

diff --git a/inc/modules/admin/what-edit_sponsor.php b/inc/modules/admin/what-edit_sponsor.php
index c906266a75..04707bc3c1 100644
--- a/inc/modules/admin/what-edit_sponsor.php
+++ b/inc/modules/admin/what-edit_sponsor.php
@@ -40,7 +40,7 @@
 // Some security stuff...
 if ((!defined('__SECURITY')) || (!isAdmin())) {
 	die();
-}
+} // END - if
 
 // Add description as navigation point
 addMenuDescription('admin', __FILE__);
@@ -48,14 +48,14 @@ addMenuDescription('admin', __FILE__);
 if ((isGetRequestParameterSet('id')) && (isGetRequestParameterSet('mode'))) {
 	// Check for selected sponsor
 	$result_main = SQL_QUERY_ESC("SELECT
-	`company`, `position`, `gender`, `surname`, `family`,
+	`id`, `company`, `position`, `gender`, `surname`, `family`,
 	`street_nr1`, `street_nr2`, `zip`, `city`, `country`,
 	`phone`, `fax`, `cell`, `email`, `url`, `tax_ident`,
 	`receive_warnings`, `warning_interval`
 FROM
 	`{?_MYSQL_PREFIX?}_sponsor_data`
 WHERE
-	`id`='%s'
+	`id`=%s
 LIMIT 1",
 		array(bigintval(getRequestParameter('id'))), __FILE__, __LINE__);
 	if (SQL_NUMROWS($result_main) == 1) {
@@ -63,9 +63,6 @@ LIMIT 1",
 		$content = SQL_FETCHARRAY($result_main);
 
 		// Prepare all data for the template
-		//  Sponsor's id
-		$content['id'] = bigintval(getRequestParameter('id'));
-
 		// Init gender
 		foreach (array('m', 'f', 'c') as $gender) {
 			$content['gender_' . $gender] = '';
@@ -76,14 +73,14 @@ LIMIT 1",
 
 		//  Warning because low points
 		$content['receive_warnings'] = addSelectionBox('yn', $content['receive_warnings'], 'receive_warning');
-		$content['interval']         = createTimeSelections($content['warning_interval'], 'warning_interval', 'MWDh');
+		$content['warning_interval'] = createTimeSelections($content['warning_interval'], 'warning_interval', 'MWDh');
 
 		// Init variables here
 		$TPL = sprintf("admin_edit_sponsor_%s", getRequestParameter('mode'));
 		initSqls();
 
 		// Sponsor was found
-		if ((isFormSent()) || (isPostRequestParameterSet('edit'))) {
+		if ((isFormSent()) || (isFormSent('edit'))) {
 			// Perform action on mode
 			switch (getRequestParameter('mode')) {
 				case 'add_points': // Add points
@@ -92,20 +89,20 @@ LIMIT 1",
 						$points = bigintval(convertCommaToDot(postRequestParameter('points')));
 
 						// Add points to account
-						SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `points_amount`=`points_amount`+%s WHERE `id`='%s' LIMIT 1",
+						SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `points_amount`=`points_amount`+%s WHERE `id`=%s LIMIT 1",
 							array($points, bigintval(getRequestParameter('id'))), __FILE__, __LINE__);
 
 						// Remember points /reason for the template
-						$content['points'] = translateComma($points);
+						$content['points'] = $points;
 						$content['reason'] = secureString(postRequestParameter('reason'));
 
 						// Send email
 						$message = loadEmailTemplate('sponsor_add_points', $content);
-						sendEmail($content['email'], getMessage('ADMIN_SPONSOR_ADD_POINTS_SUBJ'), $message);
-						$message = getMessage('ADMIN_SPONSOR_POINTS_ADDED');
+						sendEmail($content['email'], '{--ADMIN_SPONSOR_ADD_POINTS_SUBJECT--}', $message);
+						$message = '{--ADMIN_SPONSOR_POINTS_ADDED--}';
 					} else {
 						// No points entered to add!
-						$message = getMessage('ADMIN_SPONSPOR_NO_POINTS_TO_ADD');
+						$message = '{--ADMIN_SPONSPOR_NO_POINTS_TO_ADD--}';
 					}
 					break;
 
@@ -115,20 +112,20 @@ LIMIT 1",
 						$points = bigintval(convertCommaToDot(postRequestParameter('points')));
 
 						// Add points to account
-						SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `points_used`=`points_used`+%s WHERE `id`='%s' LIMIT 1",
+						SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `points_used`=`points_used`+%s WHERE `id`=%s LIMIT 1",
 							array($points, bigintval(getRequestParameter('id'))), __FILE__, __LINE__);
 
 						// Remember points /reason for the template
-						$content['points'] = translateComma($points);
+						$content['points'] = $points;
 						$content['reason'] = secureString(postRequestParameter('reason'));
 
 						// Send email
 						$message = loadEmailTemplate('sponsor_sub_points', $content);
-						sendEmail($content['email'], getMessage('ADMIN_SPONSOR_SUB_POINTS_SUBJ'), $message);
-						$message = getMessage('ADMIN_SPONSOR_POINTS_SUBTRACTED');
+						sendEmail($content['email'], '{--ADMIN_SPONSOR_SUB_POINTS_SUBJECT--}', $message);
+						$message = '{--ADMIN_SPONSOR_POINTS_SUBTRACTED--}';
 					} else {
 						// No points entered to add!
-						$message = getMessage('ADMIN_SPONSPOR_NO_POINTS_TO_SUBTRACT');
+						$message = '{--ADMIN_SPONSPOR_NO_POINTS_TO_SUBTRACT--}';
 					}
 					break;
 
@@ -146,17 +143,17 @@ LIMIT 1",
 					convertSelectionsToTimestamp(postRequestArray(), $DATA, $id, $skip);
 
 					// Save the sponsor
-					handlSponsorRequest(postRequestArray());
+					handleSponsorRequest(postRequestArray());
 
 					// Convert some data for the email template
 					postRequestParameter('gender'          , translateGender(postRequestParameter('gender')));
 					postRequestParameter('warning_interval', createFancyTime(postRequestParameter('warning_interval')));
 
-					if ($PASS === false) setPostRequestParameter('pass1', getMessage('SPONSOR_PASS_UNCHANGED'));
+					if ($PASS === false) setPostRequestParameter('pass1', '{--SPONSOR_PASS_UNCHANGED--}');
 
 					// Load email template and send the mail away
 					$message = loadEmailTemplate('admin_sponsor_edit', postRequestArray(), false);
-					sendEmail(postRequestParameter('email'), getMessage('ADMIN_SPONSOR_EDIT_SUBJECT'), $message);
+					sendEmail(postRequestParameter('email'), '{--ADMIN_SPONSOR_EDIT_SUBJECT--}', $message);
 					break;
 
 				default: // Unknown mode
@@ -169,12 +166,12 @@ LIMIT 1",
 				// Output message
 				loadTemplate('admin_settings_saved', false, $message);
 			} // END - if
-		} elseif (isFileReadable(sprintf("%stemplates/%s/html/admin/%s.tpl", getConfig('PATH'), getLanguage(), $TPL))) {
+		} elseif (isFileReadable(sprintf("%stemplates/%s/html/admin/%s.tpl", getPath(), getLanguage(), $TPL))) {
 			// Create mailto link
-			$content['contact'] = '<a href="' . generateEmailLink($content['email'], 'sponsor_data') . '">' . $content['surname'] . ' ' . $content['family'] . '</a>';
+			$content['contact'] = '<a href="' . generateSponsorEmailLink($content['email'], 'sponsor_data') . '">' . $content['surname'] . ' ' . $content['family'] . '</a>';
 
 			// Load mode template
-			loadTemplate($TPL);
+			loadTemplate($TPL, false, $content);
 		} else {
 			// Template not found!
 			loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_SPONSOR_MODUS_TPL_404', getRequestParameter('mode')));
@@ -188,7 +185,7 @@ LIMIT 1",
 	SQL_FREERESULT($result_main);
 } else {
 	// Not called by what-list_sponsor.php
-	loadTemplate('admin_settings_saved', false, getMessage('ADMIN_CALL_NOT_DIRECTLY'));
+	loadTemplate('admin_settings_saved', false, '{--ADMIN_CALL_NOT_DIRECTLY--}');
 }
 
 // [EOF]