X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-edit_sponsor.php;h=81d68c22284844be1c10787b320c9d846ab76505;hp=c6a793cd2e123c7a3e08e579d138c466c363b7ba;hb=a4dd1eb45ae25ed017a862a4edac1e2828acbee6;hpb=1fd39b2564946ce7f19776abab8d65a31928fba1

diff --git a/inc/modules/admin/what-edit_sponsor.php b/inc/modules/admin/what-edit_sponsor.php
index c6a793cd2e..81d68c2228 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,7 +89,7 @@ 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
@@ -105,7 +102,7 @@ LIMIT 1",
 						$message = '{--ADMIN_SPONSOR_POINTS_ADDED--}';
 					} else {
 						// No points entered to add!
-						$message = '{--ADMIN_SPONSPOR_NO_POINTS_TO_ADD--}';
+						$message = '{--ADMIN_SPONSOR_NO_POINTS_TO_ADD--}';
 					}
 					break;
 
@@ -115,7 +112,7 @@ 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
@@ -128,7 +125,7 @@ LIMIT 1",
 						$message = '{--ADMIN_SPONSOR_POINTS_SUBTRACTED--}';
 					} else {
 						// No points entered to add!
-						$message = '{--ADMIN_SPONSPOR_NO_POINTS_TO_SUBTRACT--}';
+						$message = '{--ADMIN_SPONSOR_NO_POINTS_TO_SUBTRACT--}';
 					}
 					break;
 
@@ -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')));
@@ -171,10 +168,10 @@ LIMIT 1",
 			} // END - if
 		} 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')));