X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-unlock_sponsor.php;h=e6924acb4f7d52700ac23069cd1f19d39b83f1de;hp=58a59baed3cde224f701dc268f23cbd8592afcd4;hb=57227d33e870ec5cd271209c4a978a52b45c2dd6;hpb=5071030af40e69ca4284642f44758964e18f5be8

diff --git a/inc/modules/admin/what-unlock_sponsor.php b/inc/modules/admin/what-unlock_sponsor.php
index 58a59baed3..e6924acb4f 100644
--- a/inc/modules/admin/what-unlock_sponsor.php
+++ b/inc/modules/admin/what-unlock_sponsor.php
@@ -1,7 +1,7 @@
 <?php
 /************************************************************************
- * M-XChange v0.2.1                                   Start: 04/23/2005 *
- * ================                             Last change: 05/19/2008 *
+ * Mailer v0.2.1-FINAL                                Start: 04/23/2005 *
+ * ===================                          Last change: 05/19/2008 *
  *                                                                      *
  * -------------------------------------------------------------------- *
  * File              : what-unlock_sponsor.php                          *
@@ -17,7 +17,7 @@
  * Needs to be in all Files and every File needs "svn propset           *
  * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
- * Copyright (c) 2003 - 2008 by Roland Haeder                           *
+ * Copyright (c) 2003 - 2009 by Roland Haeder                           *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -37,21 +37,20 @@
  ************************************************************************/
 
 // Some security stuff...
-if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
-	$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php';
-	require($INC);
+if ((!defined('__SECURITY')) || (!isAdmin())) {
+	die();
 }
 
 // Add description as navigation point
-ADD_DESCR('admin', __FILE__);
+addMenuDescription('admin', __FILE__);
 
 // Check if admin has submitted form
-if (IS_FORM_SENT()) {
+if (isFormSent()) {
 	// Does he have selected at least one sponsor?
-	if (countSelection(REQUEST_POST('id')) > 0) {
+	if (countSelection(postRequestParameter('id')) > 0) {
 		// At least one entry selected
-		foreach (REQUEST_POST('id') as $id => $selected) {
-			// Secure ID number and init $content
+		foreach (postRequestParameter('id') as $id => $selected) {
+			// Secure id number and init $content
 			$content = array(
 				'id'    => bigintval($id),
 				'refid' => 0
@@ -59,7 +58,7 @@ if (IS_FORM_SENT()) {
 
 			// 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`
+FROM `{?_MYSQL_PREFIX?}_sponsor_data`
 WHERE `status`='PENDING' AND id='%s' LIMIT 1",
 			array($content['id']), __FILE__, __LINE__);
 
@@ -68,10 +67,10 @@ WHERE `status`='PENDING' AND id='%s' LIMIT 1",
 				$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,
+				$result = SQL_QUERY_ESC("SELECT so.admin_id, 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",
@@ -84,25 +83,25 @@ ORDER BY sp.pay_name",
 
 						// Set default email
 						$content['email'] = getMessage('SPONSOR_NO_ADMIN');
-						if ($content['aid'] > '0') {
+						if ($content['admin_id'] > 0) {
 							// Load admin's email address for contact
-							$content['email'] = getAdminEmail($content['aid']);
+							$content['email'] = getAdminEmail($content['admin_id']);
 						} // END - if
 
 						// Transfer data to array
 						$data = array(
-							'aid'   => $content['email'],
-							'order' => ($content['pay_count'] * $content['pay_rate'])." ".$content['pay_currency'],
-							'stamp' => generateDateTime($content['pay_ordered'], '2'),
+							'admin_id'   => $content['email'],
+							'order' => ($content['pay_count'] * $content['pay_rate']) . ' ' . $content['pay_currency'],
+							'stamp' => generateDateTime($content['pay_ordered'], 2),
 							'pname' => $content['pay_name'],
 						);
 
 						// Load email template
-						$content['msg'] = LOAD_EMAIL_TEMPLATE("sponsor_unlock_sponsor_pay", $data, $content['id']);
+						$content['message'] = loadEmailTemplate('sponsor_unlock_sponsor_pay', $data, $content['id']);
 					}
 				} else {
 					// No payments found
-					$content['msg'] = getMessage('SPONSOR_NO_PAYMENTS_FOUND');
+					$content['message'] = getMessage('SPONSOR_NO_PAYMENTS_FOUND');
 				}
 
 				// Free memory
@@ -113,38 +112,42 @@ ORDER BY sp.pay_name",
 			SQL_FREERESULT($result_main);
 
 			// Unlock sponsor account
-			SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_sponsor_data` SET `status`='CONFIRMED'
+			SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `status`='CONFIRMED'
 WHERE `id`='%s' AND `status`='PENDING' LIMIT 1",
 			array($content['id']), __FILE__, __LINE__);
 
 			// Update, if applyable, referal count and points
 			if (($content['refid'] > 0) && ($content['refid'] != $content['id'])) {
 				// 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",
-				array(getConfig('sponsor_ref_points'), bigintval($content['refid'])), __FILE__, __LINE__);
+				SQL_QUERY_ESC("UPDATE
+	`{?_MYSQL_PREFIX?}_sponsor_data`
+SET
+	`points_amount`=`points_amount`+{?sponsor_ref_points?}, `ref_count`=`ref_count`+1
+WHERE
+	`id`='%s'
+LIMIT 1",
+					array(bigintval($content['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($content['refid'])), __FILE__, __LINE__);
-					$REFERRAL = SQL_FETCHARRAY($result);
+					$REFERAL = SQL_FETCHARRAY($result);
 
 					// Send warnings out?
-					if ($REFERRAL['receive_warnings'] == 'Y') {
+					if ($REFERAL['receive_warnings'] == 'Y') {
 						// Translate some data
-						$REFERRAL['points']     = translateComma($REFERRAL['points']);
-						$REFERRAL['ref_points'] = translateComma(getConfig('sponsor_ref_points'));
-						$REFERRAL['gender']     = translateGender($REFERRAL['gender']);
+						$REFERAL['points']     = translateComma($REFERAL['points']);
+						$REFERAL['ref_points'] = translateComma(getConfig('sponsor_ref_points'));
+						$REFERAL['gender']     = translateGender($REFERAL['gender']);
 
 						// Send notification to referal
-						$REF_MSG = LOAD_EMAIL_TEMPLATE("sponsor_ref_notify", $REFERRAL);
-						sendEmail($REFERRAL['email'], getMessage('SPONSOR_REF_NOTIFY_SUBJ'), $REF_MSG);
+						$REF_MSG = loadEmailTemplate('sponsor_ref_notify', $REFERAL);
+						sendEmail($REFERAL['email'], getMessage('SPONSOR_REF_NOTIFY_SUBJ'), $REF_MSG);
 					}
 
 					// Free memory
@@ -158,23 +161,23 @@ WHERE `id`='%s' LIMIT 1",
 			$content['points']   = translateComma($content['points_amount']);
 
 			// So let's send the email away
-			$msg = LOAD_EMAIL_TEMPLATE("sponsor_unlocked", $content);
-			sendEmail($content['email'], getMessage('SPONSOR_UNLOCKED_SUBJ'), $msg);
+			$message = loadEmailTemplate('sponsor_unlocked', $content);
+			sendEmail($content['email'], getMessage('SPONSOR_UNLOCKED_SUBJ'), $message);
 		}
 	} else {
 		// Nothing selected
-		LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_SPONSOR_NONE_SELECTED_UNLOCK'));
+		loadTemplate('admin_settings_saved', false, getMessage('ADMIN_SPONSOR_NONE_SELECTED_UNLOCK'));
 	}
 
 	// Add seperator
-	OUTPUT_HTML("<br />");
+	outputHtml('<br />');
 }
 
 // Begin listing of all pending sponsor accounts
 $result = SQL_QUERY("SELECT
-	id, gender, surname, family, email, remote_addr, sponsor_created
+	`id`, `gender`, `surname`, `family`, `email`, `remote_addr`, `sponsor_created`
 FROM
-	`{!_MYSQL_PREFIX!}_sponsor_data`
+	`{?_MYSQL_PREFIX?}_sponsor_data`
 WHERE
 	`status`='PENDING'
 ORDER BY
@@ -192,26 +195,25 @@ if (SQL_NUMROWS($result) > 0) {
 			'gender'   => translateGender($content['gender']),
 			'surname' => $content['surname'],
 			'family'  => $content['family'],
-			'email'   => "mailto:".$content['email'],
+			'email'   => generateEmailLink($content['email'], 'sponsor_data'),
 			'remote'  => $content['remote_addr'],
-			'created' => generateDateTime($content['sponsor_created'], '2'),
+			'created' => generateDateTime($content['sponsor_created'], 2),
 		);
 
 		// Load row template and switch colors
-		$OUT .= LOAD_TEMPLATE("admin_unlock_sponsor_row", true, $content);
+		$OUT .= loadTemplate('admin_unlock_sponsor_row', true, $content);
 		$SW = 3 - $SW;
 	}
-	define('__SPONSOR_ROWS', $OUT);
 
 	// Load template
-	LOAD_TEMPLATE("admin_unlock_sponsor");
+	loadTemplate('admin_unlock_sponsor', false, $OUT);
 } else {
 	// No pending accounts found
-	LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_SPONSOR_NONE_PENDING'));
+	loadTemplate('admin_settings_saved', false, getMessage('ADMIN_SPONSOR_NONE_PENDING'));
 }
 
 // Free memory
 SQL_FREERESULT($result);
 
-//
+// [EOF]
 ?>