X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-sub_points.php;h=cab446b0723e528ef4290521878df86ba0d3cfb5;hb=aa63aed07428a99ea09002c8d072990677700080;hp=775fdaeac3f10b58553f1f8218e17394ce742014;hpb=d8148e3f1f3a6762b2e786dbe99ada269dcf2ea0;p=mailer.git

diff --git a/inc/modules/admin/what-sub_points.php b/inc/modules/admin/what-sub_points.php
index 775fdaeac3..cab446b072 100644
--- a/inc/modules/admin/what-sub_points.php
+++ b/inc/modules/admin/what-sub_points.php
@@ -10,7 +10,12 @@
  * -------------------------------------------------------------------- *
  * Kurzbeschreibung  : Manuell einem Mitglied Punkte gutschreiben       *
  * -------------------------------------------------------------------- *
- *                                                                      *
+ * $Revision::                                                        $ *
+ * $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 - 2008 by Roland Haeder                           *
  * For more information visit: http://www.mxchange.org                  *
@@ -33,94 +38,84 @@
 
 // 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);
 }
 
 // Add description as navigation point
-ADD_DESCR("admin", __FILE__);
+ADD_DESCR('admin', __FILE__);
 
 // Fix a notice
-if (!REQUEST_ISSET_GET(('uid'))) REQUEST_SET_GET('uid', "");
+if (!REQUEST_ISSET_GET('uid')) REQUEST_SET_GET('uid', '');
 
 if (REQUEST_GET('uid') == "all") {
 	// Add points to all accounts
+	// @TODO Rewrite this constant
 	define('__POINTS_VALUE', REQUEST_POST('points'));
+
+	// Is the form sent?
 	if ((IS_FORM_SENT()) && (REQUEST_POST('points') > 0)) {
-		$result_main = SQL_QUERY("SELECT userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE `status`='CONFIRMED' ORDER BY userid", __FILE__, __LINE__);
-		while (list($uid) = SQL_FETCHROW($result_main)) {
-			// 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($uid)), __FILE__, __LINE__);
-
-			// Entry found?
-			if (SQL_NUMROWS($result) == 1) {
-				// Selected user does exist
-				list($sname, $fname, $email) = SQL_FETCHROW($result);
-
-				// Free result
-				SQL_FREERESULT($result);
-
-				if ((IS_FORM_SENT()) && (REQUEST_ISSET_POST(('points')))) {
-					// Ok, add points to used points and send an email to him...
-					SUB_POINTS("admin_all", $uid, REQUEST_POST('points'));
-
-					// Prepare content
-					$content = array(
-						'text'   => SQL_ESCAPE(REQUEST_POST('reason')),
-						'points' => bigintval(REQUEST_POST('points'))
-					);
-
-					// Load message and send it away
-					$msg = LOAD_EMAIL_TEMPLATE("sub-points", $content, bigintval($uid));
-					SEND_EMAIL(bigintval($uid), getMessage('ADMIN_SUB_SUBJ'), $msg);
-				}
-			}
-		}
+		$result_main = SQL_QUERY("SELECT userid, email FROM `{!_MYSQL_PREFIX!}_user_data` WHERE `status`='CONFIRMED' ORDER BY userid",
+			__FILE__, __LINE__);
+		while ($content = SQL_FETCHARRAY($result_main)) {
+			// Ok, add points to used points and send an email to him...
+			SUB_POINTS("admin_all", $content['userid'], REQUEST_POST('points'));
+
+			// Add more content
+			$content['text']   = SQL_ESCAPE(REQUEST_POST('reason'));
+			$content['points'] = bigintval(REQUEST_POST('points'));
+
+			// Load message and send it away
+			$msg = LOAD_EMAIL_TEMPLATE("sub-points", $content, bigintval($content['userid']));
+			SEND_EMAIL($content['email'], getMessage('ADMIN_SUB_SUBJ'), $msg);
+		} // END - while
+
 		// Free memory
 		SQL_FREERESULT($result_main);
 
 		// Output message
-		LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_ALL_POINTS_SUBTRACTED'));
+		LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_ALL_POINTS_SUBTRACTED'));
 	} else {
 		// Display form add points
 		LOAD_TEMPLATE("admin_sub_points_all");
 	}
-} elseif (REQUEST_ISSET_GET(('uid'))) {
+} elseif (REQUEST_ISSET_GET('uid')) {
 	// 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(REQUEST_GET('uid'))),__FILE__, __LINE__);
 	if (SQL_NUMROWS($result) == 1) {
 		// Selected user does exist
-		list($sname, $fname, $email) = SQL_FETCHROW($result);
-		SQL_FREERESULT($result);
+		$content = SQL_FETCHARRAY($result);
 
 		if ((IS_FORM_SENT()) && (REQUEST_ISSET_POST(('points')))) {
 			// Ok, add to used points and send an email to him...
 			SUB_POINTS("admin_single", bigintval(REQUEST_GET('uid')), REQUEST_POST('points'));
 
-			// Prepare content
-			$content = array(
-				'text'   => SQL_ESCAPE(REQUEST_POST('reason')),
-				'points' => bigintval(REQUEST_POST('points'))
-			);
+			// Add more content
+			$content['text']   = SQL_ESCAPE(REQUEST_POST('reason'));
+			$content['points'] = bigintval(REQUEST_POST('points'));
 
 			// Load email and send it away
 			$msg = LOAD_EMAIL_TEMPLATE("sub-points", $content, bigintval(REQUEST_GET('uid')));
-			SEND_EMAIL(bigintval(REQUEST_GET('uid')), getMessage('ADMIN_SUB_SUBJ'), $msg);
+			SEND_EMAIL($content['email'], getMessage('ADMIN_SUB_SUBJ'), $msg);
 
 			// Output message
-			LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_POINTS_SUBTRACTED'));
+			LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_POINTS_SUBTRACTED'));
 		} else {
-			// Opps, missing form here
-			define('__USER_VALUE', "<a href=\"".CREATE_EMAIL_LINK($email, "user_data")."\">".$sname." ".$fname."</a>");
+			// @TODO Rewrite these constants
+			define('__USER_VALUE', "<a href=\"".CREATE_EMAIL_LINK($content['email'], "user_data")."\">".$content['surname']." ".$content['family']."</a>");
 			define('__UID', bigintval(REQUEST_GET('uid')));
+
+			// Load form
 			LOAD_TEMPLATE("admin_sub_points");
 		}
 	} else {
 		// User not found!
-		LOAD_TEMPLATE("admin_settings_saved", false, "<div class=\"admin_failed\">".sprintf(getMessage('ADMIN_MEMBER_404'), REQUEST_GET('uid'))."</div>");
+		LOAD_TEMPLATE('admin_settings_saved', false, "<div class=\"admin_failed\">".sprintf(getMessage('ADMIN_MEMBER_404'), REQUEST_GET('uid'))."</div>");
 	}
+
+	// Free result
+	SQL_FREERESULT($result);
 } else {
 	// Output selection form with all confirmed user accounts listed
 	ADD_MEMBER_SELECTION_BOX("0", true);