X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-add_points.php;h=f96c1e1dc394cd70d5e116533438f6bb33c9327b;hb=22a33b87f9894a94efb71de7630f12129e34f83b;hp=683da19824b61a92dcccfcd2093f09196bc7203c;hpb=1c004d0ffe3d1bfee3ea2128f6c0165eda61baf3;p=mailer.git

diff --git a/inc/modules/admin/what-add_points.php b/inc/modules/admin/what-add_points.php
index 683da19824..f96c1e1dc3 100644
--- a/inc/modules/admin/what-add_points.php
+++ b/inc/modules/admin/what-add_points.php
@@ -47,32 +47,26 @@ if ($_GET['u_id'] == "all") {
 	// Add points to all accounts
 	if ((isset($_POST['ok'])) && ($_POST['points'] > 0)) {
 		define('__POINTS_VALUE', $_POST['points']);
-		$result_main = SQL_QUERY("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE status='CONFIRMED' ORDER BY userid", __FILE__, __LINE__);
+		$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__);
-			if (SQL_NUMROWS($result) == 1) {
-				// Selected user does exist
-				list($sname, $fname, $email) = SQL_FETCHROW($result);
-				SQL_FREERESULT($result);
+			// Remove depth to prevent booking errors. This is a bad coding
+			// practice, thats also why we need to write this project from
+			// scratch...
+			$GLOBALS['ref_level'] = -1;
 
-				if ((isset($_POST['ok'])) && (!empty($_POST['points']))) {
-					// Ok, add points and send an email to him...
-					ADD_POINTS_REFSYSTEM($uid, bigintval($_POST['points']), false, "0", false, "direct");
+			// Ok, add points and send an email to him...
+			ADD_POINTS_REFSYSTEM("admin_all", $uid, bigintval($_POST['points']), false, "0", false, "direct");
 
-					// Prepare content
-					$content = array(
-						'text'   => SQL_ESCAPE($_POST['reason']),
-						'points' => bigintval($_POST['points'])
-					);
+			// Prepare content
+			$content = array(
+				'text'   => SQL_ESCAPE($_POST['reason']),
+				'points' => bigintval($_POST['points'])
+			);
 
-					// Load email template and send email away
-					$msg = LOAD_EMAIL_TEMPLATE("add-points", $content, bigintval($uid));
-					SEND_EMAIL(bigintval($uid), ADMIN_ADD_SUBJ, $msg);
-				}
-			}
-		}
+			// Load email template and send email away
+			$msg = LOAD_EMAIL_TEMPLATE("add-points", $content, bigintval($uid));
+			SEND_EMAIL(bigintval($uid), ADMIN_ADD_SUBJ, $msg);
+		} // END - while
 
 		// Free memory
 		SQL_FREERESULT($result_main);
@@ -85,22 +79,21 @@ if ($_GET['u_id'] == "all") {
 	}
 } elseif (!empty($_GET['u_id'])) {
 	// 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($_GET['u_id'])), __FILE__, __LINE__);
+	$result = SQL_QUERY_ESC("SELECT surname, family, email FROM `"._MYSQL_PREFIX."_user_data` WHERE userid=%s AND status='CONFIRMED' LIMIT 1",
+		array(bigintval($_GET['u_id'])), __FILE__, __LINE__);
 	if (SQL_NUMROWS($result) == 1) {
 		// Selected user does exist
 		list($sname, $fname, $email) = SQL_FETCHROW($result);
 		SQL_FREERESULT($result);
 
 		if ((isset($_POST['ok'])) && (!empty($_POST['points']))) {
-			global $DEPTH;
 			// Remove depth to prevent booking errors. This is a bad coding
 			// practice, thats also why we need to write this project from
 			// scratch...
-			unset($DEPTH);
+			unset($GLOBALS['ref_level']);
 
 			// Ok, add points and send an email to him...
-			ADD_POINTS_REFSYSTEM(bigintval($_GET['u_id']), bigintval($_POST['points']), false, "0", false, "direct");
+			ADD_POINTS_REFSYSTEM("admin_single", bigintval($_GET['u_id']), bigintval($_POST['points']), false, "0", false, "direct");
 
 			// Prepare content
 			$content = array(