X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-edit_sponsor.php;h=455d3c7fa6d727b5283671bfe514e70a0e6404ce;hb=refs%2Fheads%2F0.2.1-FINAL;hp=c377966e43b41486ec5d54d47a06067425a6e095;hpb=1d22c70e65e858422ee0d17a7612f4b5c0757a42;p=mailer.git

diff --git a/inc/modules/admin/what-edit_sponsor.php b/inc/modules/admin/what-edit_sponsor.php
index c377966e43..455d3c7fa6 100644
--- a/inc/modules/admin/what-edit_sponsor.php
+++ b/inc/modules/admin/what-edit_sponsor.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
+ * Copyright (c) 2009 - 2016 by Mailer Developer Team                   *
  * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -45,8 +45,8 @@ addYouAreHereLink('admin', __FILE__);
 
 if ((isGetRequestElementSet('id')) && (isGetRequestElementSet('do'))) {
 	// Check for selected sponsor
-	$result_main = SQL_QUERY_ESC("SELECT
-	`id`, `company`, `position`, `gender`, `surname`, `family`,
+	$result_main = sqlQueryEscaped("SELECT
+	`id`, `company`, `position`, `sex`, `surname`, `family`,
 	`street_nr1`, `street_nr2`, `zip`, `city`, `country`,
 	`phone`, `fax`, `cell`, `email`, `url`, `tax_ident`,
 	`receive_warnings`, `warning_interval`
@@ -56,16 +56,16 @@ WHERE
 	`id`=%s
 LIMIT 1",
 		array(bigintval(getRequestElement('id'))), __FILE__, __LINE__);
-	if (SQL_NUMROWS($result_main) == 1) {
+	if (sqlNumRows($result_main) == 1) {
 		// Load sponsor details
-		$content = SQL_FETCHARRAY($result_main);
+		$content = sqlFetchArray($result_main);
 
 		//  Warning because low points
 		$content['receive_warnings'] = addSelectionBox('yn', $content['receive_warnings'], 'receive_warning');
 		$content['warning_interval'] = createTimeSelections($content['warning_interval'], 'warning_interval', 'MWDh');
 
 		// Init variables here
-		$TPL = sprintf("admin_edit_sponsor_%s", getRequestElement('do'));
+		$TPL = sprintf('admin_edit_sponsor_%s', getRequestElement('do'));
 		initSqls();
 
 		// Sponsor was found
@@ -78,8 +78,12 @@ LIMIT 1",
 						$points = bigintval(convertCommaToDot(postRequestElement('points')));
 
 						// Add points to account
-						SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `points_amount`=`points_amount`+%s WHERE `id`=%s LIMIT 1",
-							array($points, bigintval(getRequestElement('id'))), __FILE__, __LINE__);
+						sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `points_amount`=`points_amount`+%s WHERE `id`=%s LIMIT 1",
+							array(
+								$points,
+								bigintval(getRequestElement('id'))
+							), __FILE__, __LINE__
+						);
 
 						// Remember points /reason for the template
 						$content['points'] = $points;
@@ -101,7 +105,7 @@ LIMIT 1",
 						$points = bigintval(convertCommaToDot(postRequestElement('points')));
 
 						// Add points to account
-						SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `points_used`=`points_used`+%s WHERE `id`=%s LIMIT 1",
+						sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `points_used`=`points_used`+%s WHERE `id`=%s LIMIT 1",
 							array($points, bigintval(getRequestElement('id'))), __FILE__, __LINE__);
 
 						// Remember points /reason for the template
@@ -134,7 +138,7 @@ LIMIT 1",
 					handleSponsorRequest(postRequestArray());
 
 					// Convert some data for the email template
-					postRequestElement('gender'          , '{%pipe,translateGender=' . postRequestElement('gender') . '%}');
+					postRequestElement('sex'          , '{%pipe,translateSex=' . postRequestElement('sex') . '%}');
 					postRequestElement('warning_interval', '{%pipe,createFancyTime=' . postRequestElement('warning_interval') . '%}');
 
 					if ($PASS === FALSE) setPostRequestElement('password1', '{--SPONSOR_PASS_UNCHANGED--}');
@@ -145,16 +149,16 @@ LIMIT 1",
 					break;
 
 				default: // Unknown mode
-					logDebugMessage(__FILE__, __LINE__, sprintf("Unknown mode %s detected.", getRequestElement('do')));
+					logDebugMessage(__FILE__, __LINE__, sprintf('Unknown mode %s detected.', getRequestElement('do')));
 					$message = '{%message,ADMIN_SPONSOR_INVALID_MODE=' . getRequestElement('do') . '%}';
 					break;
-			}
+			} // END - switch
 
 			if (!empty($message)) {
 				// Output message
 				displayMessage($message);
 			} // END - if
-		} elseif (isFileReadable(sprintf("%stemplates/%s/html/admin/%s.tpl", getPath(), getLanguage(), $TPL))) {
+		} elseif (isFileReadable(sprintf('%s/admin/%s.tpl', getTemplateBasePath('html'), $TPL))) {
 			// Create mailto link
 			$content['contact'] = '<a href="' . generateSponsorEmailLink($content['email'], 'sponsor_data') . '">' . $content['surname'] . ' ' . $content['family'] . '</a>';
 
@@ -170,7 +174,7 @@ LIMIT 1",
 	}
 
 	// Free result
-	SQL_FREERESULT($result_main);
+	sqlFreeResult($result_main);
 } else {
 	// Not called by what-list_sponsor.php
 	displayMessage('{--ADMIN_CALL_NOT_DIRECTLY--}');