X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-edit_sponsor.php;h=04707bc3c13dd5e7644ee9d67d67394eba9f9dc3;hb=98b92ea5ba992a63304091fa1b57f477befffc22;hp=059fce33be377a3814bc9317184646c0f697166d;hpb=fc162164725588cf75969f707faead9c9cd8e68b;p=mailer.git

diff --git a/inc/modules/admin/what-edit_sponsor.php b/inc/modules/admin/what-edit_sponsor.php
index 059fce33be..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] = '';
@@ -92,16 +89,16 @@ 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'], '{--ADMIN_SPONSOR_ADD_POINTS_SUBJ--}', $message);
+						sendEmail($content['email'], '{--ADMIN_SPONSOR_ADD_POINTS_SUBJECT--}', $message);
 						$message = '{--ADMIN_SPONSOR_POINTS_ADDED--}';
 					} else {
 						// No points entered to add!
@@ -115,16 +112,16 @@ 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'], '{--ADMIN_SPONSOR_SUB_POINTS_SUBJ--}', $message);
+						sendEmail($content['email'], '{--ADMIN_SPONSOR_SUB_POINTS_SUBJECT--}', $message);
 						$message = '{--ADMIN_SPONSOR_POINTS_SUBTRACTED--}';
 					} else {
 						// No points entered to add!
@@ -146,7 +143,7 @@ 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')));
@@ -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')));