X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-sub_points.php;h=92d91b275cd3c62796cbd5015f660484ba15c9fc;hp=f4348b36d768645e65f7ab2b8bfe586a2f71784c;hb=155492a5b96cec674846973a8524238b0365a848;hpb=64c8349613addc3da2242c5cd6b99d64e3fb5f8e

diff --git a/inc/modules/admin/what-sub_points.php b/inc/modules/admin/what-sub_points.php
index f4348b36d7..92d91b275c 100644
--- a/inc/modules/admin/what-sub_points.php
+++ b/inc/modules/admin/what-sub_points.php
@@ -1,7 +1,7 @@
 <?php
 /************************************************************************
- * MXChange v0.2.1                                    Start: 11/23/2003 *
- * ===============                              Last change: 09/23/2004 *
+ * Mailer v0.2.1-FINAL                                Start: 11/23/2003 *
+ * ===================                          Last change: 09/23/2004 *
  *                                                                      *
  * -------------------------------------------------------------------- *
  * File              : what-sub_points.php                              *
@@ -14,11 +14,10 @@
  * $Date::                                                            $ *
  * $Tag:: 0.2.1-FINAL                                                 $ *
  * $Author::                                                          $ *
- * Needs to be in all Files and every File needs "svn propset           *
- * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * For more information visit: http://www.mxchange.org                  *
+ * Copyright (c) 2009 - 2013 by Mailer Developer Team                   *
+ * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * 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 *
@@ -39,81 +38,85 @@
 // Some security stuff...
 if ((!defined('__SECURITY')) || (!isAdmin())) {
 	die();
-}
+} // END - if
 
 // Add description as navigation point
-addMenuDescription('admin', __FILE__);
+addYouAreHereLink('admin', __FILE__);
 
 if (getRequestElement('userid') == 'all') {
-	// Add points to all accounts
-	$content['points'] = bigintval(postRequestElement('points'));
-
 	// Is the form sent?
 	if ((isFormSent()) && (postRequestElement('points') > 0)) {
-		$result_main = SQL_QUERY("SELECT userid, email FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `status`='CONFIRMED' ORDER BY `userid` ASC",
-		__FILE__, __LINE__);
-		while ($content = merge_array($content, SQL_FETCHARRAY($result_main))) {
-			// Ok, add points to used points and send an email to him...
-			subtractPoints('admin_all', $content['userid'], postRequestElement('points'));
+		// Add points to all accounts
+		$content['points'] = bigintval(postRequestElement('points'));
 
-			// Add more content
-			$content['text']   = SQL_ESCAPE(postRequestElement('reason'));
-			$content['points'] = bigintval(postRequestElement('points'));
+		// Load userid
+		$result_main = sqlQuery("SELECT `userid`, `email` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `status`='CONFIRMED' ORDER BY `userid` ASC",
+			__FILE__, __LINE__);
+		while ($row = sqlFetchArray($result_main)) {
+			// Merge both arrays
+			$content = merge_array($content, $row);
+
+			// Ok, add points to used points, send an email to him and ignore return status
+			subtractPoints('admin_sub_all', $content['userid'], postRequestElement('points'));
+
+			// Prepare content
+			$content = array(
+				'reason'  => sqlEscapeString(postRequestElement('reason')),
+				'points'  => bigintval(postRequestElement('points')),
+				'subject' => 'admin_sub_all',
+			);
 
 			// Load message and send it away
-			$message = loadEmailTemplate('sub-points', $content, bigintval($content['userid']));
-			sendEmail($content['email'], getMessage('ADMIN_SUB_SUBJ'), $message);
+			$message = loadEmailTemplate('member_sub_points', $content, bigintval($content['userid']));
+			sendEmail($row['userid'], '{--ADMIN_SUB_POINTS_SUBJECT--}', $message);
 		} // END - while
 
 		// Free memory
-		SQL_FREERESULT($result_main);
+		sqlFreeResult($result_main);
 
 		// Output message
-		loadTemplate('admin_settings_saved', false, getMessage('ADMIN_ALL_POINTS_SUBTRACTED'));
+		displayMessage('{--ADMIN_ALL_POINTS_SUB_DONE--}');
 	} else {
 		// Display form add points
 		loadTemplate('admin_sub_points_all');
 	}
 } elseif (isGetRequestElementSet('userid')) {
-	// User ID found in URL so we use this give him some credits
-	$result = SQL_QUERY_ESC("SELECT `surname`, `family`, `email` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s AND `status`='CONFIRMED' LIMIT 1",
-		array(bigintval(getRequestElement('userid'))),__FILE__, __LINE__);
-	if (SQL_NUMROWS($result) == 1) {
+	// User id found in URL so we use this give him some credits
+	if (fetchUserData(getRequestElement('userid'))) {
 		// Selected user does exist
-		$content = SQL_FETCHARRAY($result);
+		$content = getUserDataArray();
 
-		if ((isFormSent()) && (isPostRequestElementSet(('points')))) {
-			// Ok, add to used points and send an email to him...
-			subtractPoints('admin_single', bigintval(getRequestElement('userid')), postRequestElement('points'));
+		if ((isFormSent()) && (isPostRequestElementSet('points'))) {
+			// Ok, add to used points, send an email to him and ignore return status
+			subtractPoints('admin_sub_single', bigintval(getRequestElement('userid')), postRequestElement('points'));
 
-			// Add more content
-			$content['text']   = SQL_ESCAPE(postRequestElement('reason'));
-			$content['points'] = bigintval(postRequestElement('points'));
+			// Prepare content
+			$content = array(
+				'reason'  => sqlEscapeString(postRequestElement('reason')),
+				'points'  => bigintval(postRequestElement('points')),
+				'subject' => 'admin_sub_single',
+			);
 
 			// Load email and send it away
-			$message = loadEmailTemplate('sub-points', $content, bigintval(getRequestElement('userid')));
-			sendEmail($content['email'], getMessage('ADMIN_SUB_SUBJ'), $message);
+			$message = loadEmailTemplate('member_sub_points', $content, bigintval(getRequestElement('userid')));
+			sendEmail(getRequestElement('userid'), '{--ADMIN_SUB_POINTS_SUBJECT--}', $message);
 
 			// Output message
-			loadTemplate('admin_settings_saved', false, getMessage('ADMIN_POINTS_SUBTRACTED'));
+			displayMessage('{--ADMIN_POINTS_SUBTRACTED--}');
 		} else {
 			// Prepare content
-			$content['user']   = "<a href=\"".generateEmailLink($content['email'], 'user_data')."\">".$content['surname']." ".$content['family']."</a>";
 			$content['userid'] = bigintval(getRequestElement('userid'));
 
 			// Load form
-			loadTemplate('admin_sub_points', false, $content);
+			loadTemplate('admin_sub_points', FALSE, $content);
 		}
 	} else {
-		// User not found!
-		loadTemplate('admin_settings_saved', false, "<div class=\"admin_failed\">".sprintf(getMessage('ADMIN_MEMBER_404'), getRequestElement('userid'))."</div>");
+		// User not found
+		displayErrorMessage('{%message,ADMIN_MEMBER_404=' . bigintval(getRequestElement('userid')) . '%}');
 	}
-
-	// Free result
-	SQL_FREERESULT($result);
 } else {
 	// Output selection form with all confirmed user accounts listed
-	addMemberSelectionBox('0', true);
+	addMemberSelectionBox(0, TRUE);
 }
 
 // [EOF]