X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-unlock_sponsor.php;h=a4c552c97c0e0a71d63f67082dab01ac06a14177;hb=d5ee31ebfc85f22fc691b8c2753c42e188c1c4ef;hp=81328dc904de2e6dbe57e5788d4055953c1f03d1;hpb=2305bb069ede07db6227ab5e51960e501e75d7e6;p=mailer.git

diff --git a/inc/modules/admin/what-unlock_sponsor.php b/inc/modules/admin/what-unlock_sponsor.php
index 81328dc904..a4c552c97c 100644
--- a/inc/modules/admin/what-unlock_sponsor.php
+++ b/inc/modules/admin/what-unlock_sponsor.php
@@ -51,9 +51,9 @@ if (isset($_POST['ok'])) {
 
 			// Load his personal data
 			$result_main = SQL_QUERY_ESC("SELECT gender, surname, family, email, remote_addr, sponsor_created, points_amount, refid
-FROM "._MYSQL_PREFIX."_sponsor_data
-WHERE status='PENDING' AND id='%s' LIMIT 1",
- array($id), __FILE__, __LINE__);
+FROM `{!_MYSQL_PREFIX!}_sponsor_data`
+WHERE `status`='PENDING' AND id='%s' LIMIT 1",
+				array($id), __FILE__, __LINE__);
 			$refid = 0;
 			if (SQL_NUMROWS($result_main) == 1) {
 				// Load data and free memory
@@ -62,15 +62,15 @@ WHERE status='PENDING' AND id='%s' LIMIT 1",
 				// Check for open payments and close them
 				$result = SQL_QUERY_ESC("SELECT DISTINCT so.aid, so.pay_count, so.pay_ordered, so.pay_status,
 sp.pay_name, sp.pay_rate, sp.pay_currency
-FROM "._MYSQL_PREFIX."_sponsor_orders AS so
-LEFT JOIN "._MYSQL_PREFIX."_sponsor_paytypes AS sp
+FROM `{!_MYSQL_PREFIX!}_sponsor_orders` AS so
+LEFT JOIN `{!_MYSQL_PREFIX!}_sponsor_paytypes` AS sp
 ON sp.id=so.payid
 WHERE so.sponsorid='%s'
 ORDER BY sp.pay_name",
- array($id), __FILE__, __LINE__);
+					array($id), __FILE__, __LINE__);
 				if (SQL_NUMROWS($result) > 0) {
 					// Payment does exist
-					while(list($aid, $count, $ordered, $status, $pname, $prate, $pcurr) = SQL_FETCHROW($result))
+					while (list($aid, $count, $ordered, $status, $pname, $prate, $pcurr) = SQL_FETCHROW($result))
 					{
 						// Set default email
 						$email = SPONSOR_NO_ADMIN;
@@ -103,38 +103,38 @@ ORDER BY sp.pay_name",
 			SQL_FREERESULT($result_main);
 
 			// Unlock sponsor account
-			$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_sponsor_data SET status='CONFIRMED'
-WHERE id='%s' AND status='PENDING' LIMIT 1",
- array($id), __FILE__, __LINE__);
+			SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_sponsor_data` SET `status`='CONFIRMED'
+WHERE id='%s' AND `status`='PENDING' LIMIT 1",
+				array($id), __FILE__, __LINE__);
 
 			// Update, if applyable, referal count and points
 			if (($refid > 0) && ($refid != $id)) {
 				// Update referal account
-				$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_sponsor_data
+				SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_sponsor_data`
 SET points_amount=points_amount+%s, ref_count=ref_count+1
 WHERE id='%s' LIMIT 1",
- array($_CONFIG['sponsor_ref_points'], bigintval($refid)), __FILE__, __LINE__);
+					array(getConfig('sponsor_ref_points'), bigintval($refid)), __FILE__, __LINE__);
 
 				// Whas that update fine?
 				if (SQL_AFFECTEDROWS() == 1) {
 					// Load referal's data
 					$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
+FROM `{!_MYSQL_PREFIX!}_sponsor_data`
 WHERE id='%s' LIMIT 1",
- array(bigintval($refid)), __FILE__, __LINE__);
+						array(bigintval($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($_CONFIG['sponsor_ref_points']);
+						$REFERRAL['ref_points'] = TRANSLATE_COMMA(getConfig('sponsor_ref_points'));
 						$REFERRAL['gender']      = TRANSLATE_GENDER($REFERRAL['gender']);
 
 						// Send notification to referal
 						$REF_MSG = LOAD_EMAIL_TEMPLATE("sponsor_ref_notify", $REFERRAL);
-						SEND_EMAIL($REFERRAL['email'], SPONSOR_REF_NOTIFY_SUBJ, $REF_MSG);
+						SEND_EMAIL($REFERRAL['email'], getMessage('SPONSOR_REF_NOTIFY_SUBJ'), $REF_MSG);
 					}
 
 					// Free memory
@@ -151,11 +151,11 @@ WHERE id='%s' LIMIT 1",
 
 			// So let's send the email away
 			$msg = LOAD_EMAIL_TEMPLATE("sponsor_unlocked", $content);
-			SEND_EMAIL($email, SPONSOR_UNLOCKED_SUBJ, $msg);
+			SEND_EMAIL($email, getMessage('SPONSOR_UNLOCKED_SUBJ'), $msg);
 		}
 	} else {
 		// Nothing selected
-		LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_SPONSOR_NONE_SELECTED_UNLOCK);
+		LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_SPONSOR_NONE_SELECTED_UNLOCK'));
 	}
 
 	// Add seperator
@@ -163,14 +163,19 @@ WHERE id='%s' LIMIT 1",
 }
 
 // Begin listing of all pending sponsor accounts
-$result = SQL_QUERY("SELECT id, gender, surname, family, email, remote_addr, sponsor_created
-FROM "._MYSQL_PREFIX."_sponsor_data
-WHERE status='PENDING' ORDER BY id", __FILE__, __LINE__);
+$result = SQL_QUERY("SELECT
+	id, gender, surname, family, email, remote_addr, sponsor_created
+FROM
+	`{!_MYSQL_PREFIX!}_sponsor_data`
+WHERE
+	`status`='PENDING'
+ORDER BY
+	`id`", __FILE__, __LINE__);
 
 if (SQL_NUMROWS($result) > 0) {
 	// Entries found so let's list them!
 	$OUT = ""; $SW = 2;
-	while(list($id, $gender, $sname, $fname, $email, $ip, $created) = SQL_FETCHROW($result)) {
+	while (list($id, $gender, $sname, $fname, $email, $ip, $created) = SQL_FETCHROW($result)) {
 		// Transfer data to array
 		$content = array(
 			'sw'      => $SW,
@@ -193,7 +198,7 @@ if (SQL_NUMROWS($result) > 0) {
 	LOAD_TEMPLATE("admin_unlock_sponsor");
 } else {
 	// No pending accounts found
-	LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_SPONSOR_NONE_PENDING);
+	LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_SPONSOR_NONE_PENDING'));
 }
 
 // Free memory