]> git.mxchange.org Git - mailer.git/blobdiff - inc/modules/admin/what-sub_points.php
New function isDirectory() introduced, fixed GET_DIR_AS_ARRAY() (replaces scandir())
[mailer.git] / inc / modules / admin / what-sub_points.php
index 775fdaeac3f10b58553f1f8218e17394ce742014..eca645661c69b9e712e6f48b3a7e768d774db3c7 100644 (file)
  * -------------------------------------------------------------------- *
  * Kurzbeschreibung  : Manuell einem Mitglied Punkte gutschreiben       *
  * -------------------------------------------------------------------- *
- *                                                                      *
+ * $Revision:: 856                                                    $ *
+ * $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                  *
@@ -45,38 +50,26 @@ 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);
 
@@ -92,35 +85,37 @@ if (REQUEST_GET('uid') == "all") {
                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'));
                } 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>");
        }
+
+       // Free result
+       SQL_FREERESULT($result);
 } else {
        // Output selection form with all confirmed user accounts listed
        ADD_MEMBER_SELECTION_BOX("0", true);