X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-sub_points.php;h=38845b30c1737250ca1bc6945ede087c9b4c75fe;hb=e1235e719b767d6693976c3d24489beaa38a3667;hp=243d3497819764ff9d3814880ec405d53ed777bc;hpb=f2c43b993e03f90202044a0c2ea0abd0866ec6ee;p=mailer.git

diff --git a/inc/modules/admin/what-sub_points.php b/inc/modules/admin/what-sub_points.php
index 243d349781..38845b30c1 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                              *
@@ -51,7 +51,7 @@ if (getRequestElement('userid') == 'all') {
 	// 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__);
+			__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'));
@@ -76,11 +76,9 @@ if (getRequestElement('userid') == '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) {
+	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...
@@ -108,9 +106,6 @@ if (getRequestElement('userid') == 'all') {
 		// User not found!
 		loadTemplate('admin_settings_saved', false, "<div class=\"admin_failed\">".sprintf(getMessage('ADMIN_MEMBER_404'), getRequestElement('userid'))."</div>");
 	}
-
-	// Free result
-	SQL_FREERESULT($result);
 } else {
 	// Output selection form with all confirmed user accounts listed
 	addMemberSelectionBox(0, true);