0.2.1/inc/modules/admin/what-list_refs.php

   1 <?php\r
   2 /************************************************************************\r
   3  * MXChange v0.2.1                                    Start: 01/28/2004 *\r
   4  * ================                             Last change: 06/10/2004 *\r
   5  *                                                                      *\r
   6  * -------------------------------------------------------------------- *\r
   7  * File              : what-list_refs.php                               *\r
   8  * -------------------------------------------------------------------- *\r
   9  * Short description : Show all referrals made by a member              *\r
  10  * -------------------------------------------------------------------- *\r
  11  * Kurzbeschreibung  : Alle generierten Refs eines Mitgliedes anzeigen  *\r
  12  * -------------------------------------------------------------------- *\r
  13  *                                                                      *\r
  14  *    Mod created by : Lars M�hlenbruch ( http://www.surfo.net )        *\r
  15  *                                                                      *\r
  16  * -------------------------------------------------------------------- *\r
  17  *                                                                      *\r
  18  *                 Highly modified by Roland Haeder                     *\r
  19  *                                                                      *\r
  20  * -------------------------------------------------------------------- *\r
  21  * Copyright (c) 2003 - 2008 by Roland Haeder                           *\r
  22  * For more information visit: http://www.mxchange.org                  *\r
  23  *                                                                      *\r
  24  * This program is free software; you can redistribute it and/or modify *\r
  25  * it under the terms of the GNU General Public License as published by *\r
  26  * the Free Software Foundation; either version 2 of the License, or    *\r
  27  * (at your option) any later version.                                  *\r
  28  *                                                                      *\r
  29  * This program is distributed in the hope that it will be useful,      *\r
  30  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *\r
  31  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *\r
  32  * GNU General Public License for more details.                         *\r
  33  *                                                                      *\r
  34  * You should have received a copy of the GNU General Public License    *\r
  35  * along with this program; if not, write to the Free Software          *\r
  36  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *\r
  37  * MA  02110-1301  USA                                                  *\r
  38  ************************************************************************/\r
  39 \r
  40 // Some security stuff...\r
  41 if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!IS_ADMIN()))\r
  42 {\r
  43         $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4)."/security.php";\r
  44         require($INC);\r
  45 }\r
  46 \r
  47 // Add description as navigation point\r
  48 ADD_DESCR("admin", basename(__FILE__));\r
  49 \r
  50 OPEN_TABLE("100%", "admin_content admin_content_align", "");\r
  51 if (!empty($_GET['u_id']))\r
  52 {\r
  53         // Check if the user already exists\r
  54         $result = SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE userid=%d LIMIT 1",\r
  55          array(bigintval($_GET['u_id'])), __FILE__, __LINE__);\r
  56         if (SQL_NUMROWS($result) == 1)\r
  57         {\r
  58                 // Free memory\r
  59                 SQL_FREERESULT($result);\r
  60 \r
  61                 // Loads surname, family's name and the email address\r
  62                 $result     = SQL_QUERY_ESC("SELECT COUNT(*) FROM "._MYSQL_PREFIX."_user_data WHERE refid=%d",\r
  63                  array(bigintval($_GET['u_id'])), __FILE__, __LINE__);\r
  64                 $result_lck = SQL_QUERY_ESC("SELECT COUNT(*) FROM "._MYSQL_PREFIX."_user_data WHERE refid=%d AND status != 'CONFIRMED' ORDER BY userid",\r
  65                  array(bigintval($_GET['u_id'])), __FILE__, __LINE__);\r
  66                 $menge      = SQL_RESULT($result    , 0, 0);\r
  67                 $menge_lck  = SQL_RESULT($result_lck, 0, 0);\r
  68 \r
  69                 // Free memory\r
  70                 SQL_FREERESULT($result);\r
  71                 SQL_FREERESULT($result_lck);\r
  72 \r
  73                 $result = SQL_QUERY_ESC("SELECT userid, sex, surname, family, email, status, joined FROM "._MYSQL_PREFIX."_user_data WHERE refid=%d ORDER BY userid",\r
  74                  array(bigintval($_GET['u_id'])), __FILE__, __LINE__);\r
  75 \r
  76                 OUTPUT_HTML (ADMIN_TOTAL_REFS_1."".ADMIN_USER_PROFILE_LINK($_GET['u_id'])."".ADMIN_TOTAL_REFS_2.$menge.ADMIN_TOTAL_REFS_3.$menge_lck.ADMIN_TOTAL_REFS_4."<BR><BR>");\r
  77                 if ($result)\r
  78                 {\r
  79                         $rows = SQL_NUMROWS($result);\r
  80                         if ($rows > 0)\r
  81                         {\r
  82                                 // Load all referrals\r
  83                                 $SW = "2"; $OUT = "";\r
  84                                 while ($row = SQL_FETCHROW($result))\r
  85                                 {\r
  86                                         // Check for referrals\r
  87                                         $result_refs = SQL_QUERY_ESC("SELECT COUNT(userid) FROM "._MYSQL_PREFIX."_user_data WHERE refid=%d",\r
  88                                          array(bigintval($row[0])), __FILE__, __LINE__);\r
  89                                         $refs_cnt = SQL_RESULT($result_refs, 0, 0);\r
  90                                         SQL_FREERESULT($result_refs);\r
  91 \r
  92                                         // Prepare data for the template\r
  93                                         $content = array(\r
  94                                                 'sw'         => $SW,\r
  95                                                 'u_link'     => ADMIN_USER_PROFILE_LINK($row[0]),\r
  96                                                 'salut'      => TRANSLATE_SEX($row[1]),\r
  97                                                 'refs_link'  => "0",\r
  98                                                 'surname'    => $row[2],\r
  99                                                 'family'     => $row[3],\r
 100                                                 'email'      => "<A href=\"".CREATE_EMAIL_LINK($row[4], "user_data")."\">".$row[4]."</A>",\r
 101                                                 'status'     => TRANSLATE_STATUS($row[5]),\r
 102                                                 'registered' => MAKE_DATETIME($row[6], "3"),\r
 103                                         );\r
 104 \r
 105                                         // Check if referral count is larger 0 and update link\r
 106                                         if ($refs_cnt > 0) $content['refs_link'] = ADMIN_USER_PROFILE_LINK($row[0], $refs_cnt, "list_refs");\r
 107 \r
 108                                         // Load row template and switch color\r
 109                                         $OUT .= LOAD_TEMPLATE("admin_list_refs_row", true, $content);\r
 110                                         $SW = 3 - $SW;\r
 111                                 }\r
 112 \r
 113                                 // Free memory\r
 114                                 SQL_FREERESULT($result);\r
 115                                 define('__REF_ROWS', $OUT);\r
 116 \r
 117                                 // Load main template\r
 118                                 LOAD_TEMPLATE("admin_list_refs");\r
 119                         }\r
 120                 }\r
 121                  else\r
 122                 {\r
 123                         // No referrals made so far\r
 124                         LOAD_TEMPLATE("admin_settings_saved", false, USER_REF_404);\r
 125                 }\r
 126         }\r
 127          else\r
 128         {\r
 129                 // User not found\r
 130                 LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_MEMBER_404_1.$_GET['u_id'].ADMIN_MEMBER_404_2);\r
 131         }\r
 132 }\r
 133  else\r
 134 {\r
 135         // Output selection form with all confirmed user accounts listed\r
 136         ADD_MEMBER_SELECTION_BOX();\r
 137 }\r
 138 CLOSE_TABLE();\r
 139 \r
 140 //\r
 141 ?>\r