X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-unlock_sponsor.php;h=65418b104b5864f4332cc2e03673fc7747259304;hp=7b90daf6fe65b494c0728ba6d4106a631ed1473d;hb=81bfbcd72e424060ea1223b49ad92fcfa150f361;hpb=a090e351c49fe021fb3064325694da03402332e0

diff --git a/inc/modules/admin/what-unlock_sponsor.php b/inc/modules/admin/what-unlock_sponsor.php
index 7b90daf6fe..65418b104b 100644
--- a/inc/modules/admin/what-unlock_sponsor.php
+++ b/inc/modules/admin/what-unlock_sponsor.php
@@ -38,7 +38,7 @@
 
 // Some security stuff...
 if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
-	$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4)."/security.php";
+	$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php';
 	require($INC);
 }
 
@@ -48,7 +48,7 @@ ADD_DESCR('admin', __FILE__);
 // Check if admin has submitted form
 if (IS_FORM_SENT()) {
 	// Does he have selected at least one sponsor?
-	if (SELECTION_COUNT(REQUEST_POST('id')) > 0) {
+	if (countSelection(REQUEST_POST('id')) > 0) {
 		// At least one entry selected
 		foreach (REQUEST_POST('id') as $id => $selected) {
 			// Secure ID number and init $content
@@ -65,7 +65,7 @@ WHERE `status`='PENDING' AND id='%s' LIMIT 1",
 
 			if (SQL_NUMROWS($result_main) == 1) {
 				// Load data
-				$content = SQL_FETCHROW($result_main);
+				$content = SQL_FETCHARRAY($result_main);
 
 				// Check for open payments and close them
 				$result = SQL_QUERY_ESC("SELECT DISTINCT so.aid, so.pay_count, so.pay_ordered, so.pay_status,
@@ -84,16 +84,16 @@ ORDER BY sp.pay_name",
 
 						// Set default email
 						$content['email'] = getMessage('SPONSOR_NO_ADMIN');
-						if ($content['aid'] > "0") {
+						if ($content['aid'] > '0') {
 							// Load admin's email address for contact
-							$content['email'] = GET_ADMIN_EMAIL($content['aid']);
+							$content['email'] = getAdminEmail($content['aid']);
 						} // END - if
 
 						// Transfer data to array
 						$data = array(
 							'aid'   => $content['email'],
 							'order' => ($content['pay_count'] * $content['pay_rate'])." ".$content['pay_currency'],
-							'stamp' => MAKE_DATETIME($content['pay_ordered'], "2"),
+							'stamp' => generateDateTime($content['pay_ordered'], '2'),
 							'pname' => $content['pay_name'],
 						);
 	
@@ -114,7 +114,7 @@ ORDER BY sp.pay_name",
 
 			// Unlock sponsor account
 			SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_sponsor_data` SET `status`='CONFIRMED'
-WHERE id='%s' AND `status`='PENDING' LIMIT 1",
+WHERE `id`='%s' AND `status`='PENDING' LIMIT 1",
 				array($content['id']), __FILE__, __LINE__);
 
 			// Update, if applyable, referal count and points
@@ -122,7 +122,7 @@ WHERE id='%s' AND `status`='PENDING' LIMIT 1",
 				// Update referal account
 				SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_sponsor_data`
 SET points_amount=points_amount+%s, ref_count=ref_count+1
-WHERE id='%s' LIMIT 1",
+WHERE `id`='%s' LIMIT 1",
 					array(getConfig('sponsor_ref_points'), bigintval($content['refid'])), __FILE__, __LINE__);
 
 				// Whas that update fine?
@@ -131,20 +131,20 @@ WHERE id='%s' LIMIT 1",
 					$result = SQL_QUERY_ESC("SELECT id, gender, surname, family, email,
 (points_amount - points_used) AS points, receive_warnings, ref_count AS refs
 FROM `{!_MYSQL_PREFIX!}_sponsor_data`
-WHERE id='%s' LIMIT 1",
+WHERE `id`='%s' LIMIT 1",
 						array(bigintval($content['refid'])), __FILE__, __LINE__);
 					$REFERRAL = SQL_FETCHARRAY($result);
 
 					// Send warnings out?
 					if ($REFERRAL['receive_warnings'] == 'Y') {
 						// Translate some data
-						$REFERRAL['points']     = TRANSLATE_COMMA($REFERRAL['points']);
-						$REFERRAL['ref_points'] = TRANSLATE_COMMA(getConfig('sponsor_ref_points'));
-						$REFERRAL['gender']     = TRANSLATE_GENDER($REFERRAL['gender']);
+						$REFERRAL['points']     = translateComma($REFERRAL['points']);
+						$REFERRAL['ref_points'] = translateComma(getConfig('sponsor_ref_points'));
+						$REFERRAL['gender']     = translateGender($REFERRAL['gender']);
 
 						// Send notification to referal
 						$REF_MSG = LOAD_EMAIL_TEMPLATE("sponsor_ref_notify", $REFERRAL);
-						SEND_EMAIL($REFERRAL['email'], getMessage('SPONSOR_REF_NOTIFY_SUBJ'), $REF_MSG);
+						sendEmail($REFERRAL['email'], getMessage('SPONSOR_REF_NOTIFY_SUBJ'), $REF_MSG);
 					}
 
 					// Free memory
@@ -153,13 +153,13 @@ WHERE id='%s' LIMIT 1",
 			}
 
 			// Transfer data to array
-			$content['gender']   = TRANSLATE_GENDER($content['gender']);
+			$content['gender']   = translateGender($content['gender']);
 			$content['sponsor']  = $content['id'];
-			$content['points']   = TRANSLATE_COMMA($content['points_amount']);
+			$content['points']   = translateComma($content['points_amount']);
 
 			// So let's send the email away
 			$msg = LOAD_EMAIL_TEMPLATE("sponsor_unlocked", $content);
-			SEND_EMAIL($content['email'], getMessage('SPONSOR_UNLOCKED_SUBJ'), $msg);
+			sendEmail($content['email'], getMessage('SPONSOR_UNLOCKED_SUBJ'), $msg);
 		}
 	} else {
 		// Nothing selected
@@ -189,12 +189,12 @@ if (SQL_NUMROWS($result) > 0) {
 		$content = array(
 			'sw'      => $SW,
 			'id'      => $content['id'],
-			'gender'   => TRANSLATE_GENDER($content['gender']),
+			'gender'   => translateGender($content['gender']),
 			'surname' => $content['surname'],
 			'family'  => $content['family'],
 			'email'   => "mailto:".$content['email'],
 			'remote'  => $content['remote_addr'],
-			'created' => MAKE_DATETIME($content['sponsor_created'], "2"),
+			'created' => generateDateTime($content['sponsor_created'], '2'),
 		);
 
 		// Load row template and switch colors