mailer project continued:
[mailer.git] / inc / modules / admin / what-list_refs.php
index 2c410a5e8af5954a446d4af0a4f0abd04323e441..c1367118a8d10893ff35070b51487fb07197680f 100644 (file)
@@ -11,7 +11,7 @@
  * Kurzbeschreibung  : Alle generierten Refs eines Mitgliedes anzeigen  *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
+ * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
  * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -48,15 +48,16 @@ if (isGetRequestElementSet('userid')) {
        // User found?
        if (fetchUserData($userid)) {
                // Get total refs
-               $menge =     countSumTotalData($userid, 'user_data', 'userid', 'refid', true);
-               $menge_lck = countSumTotalData($userid, 'user_data', 'userid', 'refid', true, " AND `status` != 'CONFIRMED'");
+               $totalReferrals       = getUsersTotalReferrals($userid);
+               $totalLockedReferrals = getUsersTotalLockedReferrals($userid);
 
                // Output info message
-               displayMessage(sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), generateUserProfileLink(getRequestElement('userid')), $menge, $menge_lck));
+               displayMessage(sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), generateUserProfileLink(getRequestElement('userid')), $totalReferrals, $totalLockedReferrals));
 
                // Load all referral levels
                $result_levels = SQL_QUERY("SELECT
-       `level`,`percents`
+       `level`,
+       `percents`
 FROM
        `{?_MYSQL_PREFIX?}_refdepths`
 WHERE
@@ -80,11 +81,11 @@ ORDER BY
                                // Do we have levels?
                                if (!SQL_HASZERONUMS($result_refs)) {
                                        // Count entries
-                                       $menge =     countSumTotalData($userid, 'user_data', 'userid', 'refid', true);
-                                       $menge_lck = countSumTotalData($userid, 'user_data', 'userid', 'refid', true, " AND `status` != 'CONFIRMED'");
+                                       $totalReferrals       = getUsersTotalReferrals($userid, $levels['level']);
+                                       $totalLockedReferrals = getUsersTotalLockedReferrals($userid, $levels['level']);
 
                                        // Output info message
-                                       $levels['info'] = sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), generateUserProfileLink($userid), $menge, $menge_lck);
+                                       $levels['info'] = sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), generateUserProfileLink($userid), $totalReferrals, $totalLockedReferrals);
 
                                        // Init variables
                                        $OUT_REFS = '';
@@ -100,12 +101,8 @@ ORDER BY
                                                        // @TODO Try to rewrite some to EL
                                                        $content = array(
                                                                'userid'     => getUserData('userid'),
-                                                               'gender'     => getUserData('gender'),
-                                                               'refs_link'  => 0,
-                                                               'surname'    => getUserData('surname'),
-                                                               'family'     => getUserData('family'),
+                                                               'refs_link'  => '0',
                                                                'email'      => '[<a href="' . generateEmailLink(getUserData('email'), 'user_data') . '">' . getUserData('email') . '</a>]',
-                                                               'status'     => getUserData('status'),
                                                                'registered' => generateDateTime(getUserData('joined'), 3),
                                                        );