X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-unlock_sponsor.php;h=81328dc904de2e6dbe57e5788d4055953c1f03d1;hp=d8018db2d332e2acf86cf9dd0906daf4e42dd045;hb=6586600d8020147192e5f28ca2a3a0153f774d3c;hpb=9beb33ae0c3194b05d172508768a833b1b69af2f

diff --git a/inc/modules/admin/what-unlock_sponsor.php b/inc/modules/admin/what-unlock_sponsor.php
index d8018db2d3..81328dc904 100644
--- a/inc/modules/admin/what-unlock_sponsor.php
+++ b/inc/modules/admin/what-unlock_sponsor.php
@@ -1,7 +1,7 @@
 <?php
 /************************************************************************
- * MXChange v0.2.1                                    Start: 04/23/2005 *
- * ===============                              Last change: 05/18/2008 *
+ * M-XChange v0.2.1                                   Start: 04/23/2005 *
+ * ================                             Last change: 05/19/2008 *
  *                                                                      *
  * -------------------------------------------------------------------- *
  * File              : what-unlock_sponsor.php                          *
@@ -15,9 +15,10 @@
  * Copyright (c) 2003 - 2008 by Roland Haeder                           *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
- * This program is free software. You can redistribute it and/or modify *
+ * This program is free software; you can redistribute it and/or modify *
  * it under the terms of the GNU General Public License as published by *
- * the Free Software Foundation; either version 2 of the License.       *
+ * the Free Software Foundation; either version 2 of the License, or    *
+ * (at your option) any later version.                                  *
  *                                                                      *
  * This program is distributed in the hope that it will be useful,      *
  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *
@@ -31,34 +32,32 @@
  ************************************************************************/
 
 // Some security stuff...
-if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!is_admin()))
-{
+if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
 	$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4)."/security.php";
 	require($INC);
 }
 
 // Add description as navigation point
-ADD_DESCR("admin", basename(__FILE__));
+ADD_DESCR("admin", __FILE__);
 
 // Check if admin has submitted form
-if (isset($HTTP_POST_VARS['ok']))
-{
+if (isset($_POST['ok'])) {
 	// Does he have selected at least one sponsor?
-	if (SELECTION_COUNT($HTTP_POST_VARS['id']) > 0)
-	{
+	if (SELECTION_COUNT($_POST['id']) > 0) {
 		// At least one entry selected
-		foreach ($HTTP_POST_VARS['id'] as $id=>$sel)
-		{
+		foreach ($_POST['id'] as $id => $sel) {
+			// Secure ID number
+			$id = bigintval($id);
+
 			// Load his personal data
-			$result_main = SQL_QUERY_ESC("SELECT salut, surname, family, email, remote_addr, sponsor_created, points_amount, refid
+			$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(bigintval($id)), __FILE__, __LINE__);
+ array($id), __FILE__, __LINE__);
 			$refid = 0;
-			if (SQL_NUMROWS($result_main) == 1)
-			{
+			if (SQL_NUMROWS($result_main) == 1) {
 				// Load data and free memory
-				list($salut, $sname, $fname, $email, $ip, $created, $points, $refid) = SQL_FETCHROW($result_main);
+				list($gender, $sname, $fname, $email, $ip, $created, $points, $refid) = SQL_FETCHROW($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,
@@ -68,32 +67,21 @@ LEFT JOIN "._MYSQL_PREFIX."_sponsor_paytypes AS sp
 ON sp.id=so.payid
 WHERE so.sponsorid='%s'
 ORDER BY sp.pay_name",
- array(bigintval($id)), __FILE__, __LINE__);
-				if (SQL_NUMROWS($result) > 0)
-				{
+ array($id), __FILE__, __LINE__);
+				if (SQL_NUMROWS($result) > 0) {
 					// Payment does exist
 					while(list($aid, $count, $ordered, $status, $pname, $prate, $pcurr) = SQL_FETCHROW($result))
 					{
-						if ($aid == "0")
-						{
-							// No admin assigned!
-							$aid = SPONSOR_NO_ADMIN;
-						}
-						 else
-						{
+						// Set default email
+						$email = SPONSOR_NO_ADMIN;
+						if ($aid > "0") {
 							// Load admin's email address for contact
-							$result_aid = SQL_QUERY_ESC("SELECT email FROM "._MYSQL_PREFIX."_admins WHERE id='%s' LIMIT 1",
-							 array(bigintval($aid)), __FILE__, __LINE__);
-							list($aid) = SQL_FETCHROW($result_aid);
-							SQL_FREERESULT($result_aid);
-
-							// Check if admin login is still in db
-							if (empty($aid)) $aid = ADMIN_NOT_FOUND;
+							$email = GET_ADMIN_EMAIL($aid);
 						}
 
 						// Transfer data to array
 						$content = array(
-							'aid'   => $aid,
+							'aid'   => $email,
 							'order' => ($count * $prate)." ".$pcurr,
 							'stamp' => MAKE_DATETIME($ordered, "2"),
 							'pname' => $pname,
@@ -102,9 +90,7 @@ ORDER BY sp.pay_name",
 						// Load email template
 						$content['msg'] = LOAD_EMAIL_TEMPLATE("sponsor_unlock_sponsor_pay", $content, $id);
 					}
-				}
-					 else
-				{
+				} else {
 					// No payments found
 					$content['msg'] = SPONSOR_NO_PAYMENTS_FOUND;
 				}
@@ -119,34 +105,34 @@ ORDER BY sp.pay_name",
 			// Unlock sponsor account
 			$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_sponsor_data SET status='CONFIRMED'
 WHERE id='%s' AND status='PENDING' LIMIT 1",
- array(bigintval($id)), __FILE__, __LINE__);
+ array($id), __FILE__, __LINE__);
 
-			// Update, if applyable, referral count and points
-			if (($refid > 0) && ($refid != $id))
-			{
-				// Update referral account
+			// Update, if applyable, referal count and points
+			if (($refid > 0) && ($refid != $id)) {
+				// Update referal account
 				$result = 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($_CONFIG['sponsor_ref_points'], bigintval($refid)), __FILE__, __LINE__);
 
-				// Load referral's data
-				if (SQL_AFFECTED_ROWS($link) == 1)
-				{
-					$result = SQL_QUERY_ESC("SELECT id, salut, surname, family, email,
+				// 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
 WHERE id='%s' LIMIT 1",
  array(bigintval($refid)), __FILE__, __LINE__);
 					$REFERRAL = SQL_FETCHARRAY($result);
-					if ($REFERRAL['receive_warnings'] == "Y")
-					{
+
+					// 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['salut']      = TRANSLATE_SEX($REFERRAL['salut']);
+						$REFERRAL['ref_points'] = TRANSLATE_COMMA($_CONFIG['sponsor_ref_points']);
+						$REFERRAL['gender']      = TRANSLATE_GENDER($REFERRAL['gender']);
 
-						// Send notification to referral
+						// Send notification to referal
 						$REF_MSG = LOAD_EMAIL_TEMPLATE("sponsor_ref_notify", $REFERRAL);
 						SEND_EMAIL($REFERRAL['email'], SPONSOR_REF_NOTIFY_SUBJ, $REF_MSG);
 					}
@@ -157,7 +143,7 @@ WHERE id='%s' LIMIT 1",
 			}
 
 			// Transfer data to array
-			$content['salut']   = TRANSLATE_SEX($salut);
+			$content['gender']   = TRANSLATE_GENDER($gender);
 			$content['surname'] = $sname;
 			$content['family']  = $fname;
 			$content['sponsor'] = $id;
@@ -167,33 +153,29 @@ WHERE id='%s' LIMIT 1",
 			$msg = LOAD_EMAIL_TEMPLATE("sponsor_unlocked", $content);
 			SEND_EMAIL($email, SPONSOR_UNLOCKED_SUBJ, $msg);
 		}
-	}
-	 else
-	{
+	} else {
 		// Nothing selected
 		LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_SPONSOR_NONE_SELECTED_UNLOCK);
 	}
 
 	// Add seperator
-	OUTPUT_HTML("<BR>");
+	OUTPUT_HTML("<br />");
 }
 
 // Begin listing of all pending sponsor accounts
-$result = SQL_QUERY("SELECT id, salut, surname, family, email, remote_addr, sponsor_created
+$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)
-{
+if (SQL_NUMROWS($result) > 0) {
 	// Entries found so let's list them!
 	$OUT = ""; $SW = 2;
-	while(list($id, $salut, $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,
 			'id'      => $id,
-			'salut'   => TRANSLATE_SEX($salut),
+			'gender'   => TRANSLATE_GENDER($gender),
 			'surname' => $sname,
 			'family'  => $fname,
 			'email'   => "mailto:".$email,
@@ -209,9 +191,7 @@ if (SQL_NUMROWS($result) > 0)
 
 	// Load template
 	LOAD_TEMPLATE("admin_unlock_sponsor");
-}
- else
-{
+} else {
 	// No pending accounts found
 	LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_SPONSOR_NONE_PENDING);
 }