Renamed more:

[mailer.git] / inc / modules / admin / what-list_refs.php

diff --git a/inc/modules/admin/what-list_refs.php b/inc/modules/admin/what-list_refs.php
index 2c410a5e8af5954a446d4af0a4f0abd04323e441..eab2b6a291809ab83a00e42854c1c58241fd6d10 100644 (file)
--- a/inc/modules/admin/what-list_refs.php
+++ b/inc/modules/admin/what-list_refs.php
@@ -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 - 2013 by Mailer Developer Team                   *
  * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -43,20 +43,21 @@ if (isGetRequestElementSet('userid')) {
        $userid = bigintval(getRequestElement('userid'));
 
        // Fix missing variable
-       $result_levels = false;
+       $result_levels = FALSE;
 
        // 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`
+               $result_levels = sqlQuery("SELECT
+       `level`,
+       `percents`
 FROM
        `{?_MYSQL_PREFIX?}_refdepths`
 WHERE
@@ -65,47 +66,43 @@ ORDER BY
        `level` ASC", __FILE__, __LINE__);
 
                // Are there some levels (VERY BAD IF NONE!)
-               if (!SQL_HASZERONUMS($result_levels)) {
+               if (!ifSqlHasZeroNums($result_levels)) {
                        // List all ref levels or entries if no refback is installed
                        $OUT = '';
-                       while ($levels = SQL_FETCHARRAY($result_levels)) {
+                       while ($levels = sqlFetchArray($result_levels)) {
                                // Load all refs of this user
-                               $result_refs = SQL_QUERY_ESC("SELECT `refid` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `userid`=%s AND `level`=%s ORDER BY `refid` ASC",
+                               $result_refs = sqlQueryEscaped("SELECT `refid` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `userid`=%s AND `level`=%s ORDER BY `refid` ASC",
                                        array(
                                                $userid,
                                                $levels['level']
                                        ), __FILE__, __LINE__);
-                               //* DEBUG: */ debugOutput($userid.'/'.$levels['level'].'/'.SQL_NUMROWS($result_refs));
+                               //* DEBUG: */ debugOutput($userid.'/'.$levels['level'].'/'.sqlNumRows($result_refs));
 
-                               // Do we have levels?
-                               if (!SQL_HASZERONUMS($result_refs)) {
+                               // Is there levels?
+                               if (!ifSqlHasZeroNums($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 = '';
 
                                        // Load all refs
-                                       while ($content = SQL_FETCHARRAY($result_refs)) {
+                                       while ($content = sqlFetchArray($result_refs)) {
                                                // Is the data there?
                                                if (fetchUserData($content['refid'])) {
                                                        // Check for referrals
-                                                       $refs_cnt = countSumTotalData(getUserData('userid'), 'user_refs', 'id', 'userid', true);
+                                                       $refs_cnt = countSumTotalData(getUserData('userid'), 'user_refs', 'id', 'userid', TRUE);
 
                                                        // Prepare data for the template
                                                        // @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),
                                                        );
 
@@ -115,10 +112,10 @@ ORDER BY
                                                        } // END - if
 
                                                        // Load template for level one
-                                                       $OUT_REFS .= loadTemplate('admin_list_refs_row', true, $content);
+                                                       $OUT_REFS .= loadTemplate('admin_list_refs_row', TRUE, $content);
                                                } else {
                                                        // No refs found
-                                                       $OUT_REFS = loadTemplate('admin_list_refs_nodata', true, $content);
+                                                       $OUT_REFS = loadTemplate('admin_list_refs_nodata', TRUE, $content);
                                                }
 
                                                // Add content
@@ -129,14 +126,14 @@ ORDER BY
                                        $levels['info'] = sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), generateUserProfileLink($userid), 0, 0);
 
                                        // No refs found
-                                       $levels['rows'] = loadTemplate('admin_list_refs_norefs', true, array('userid' => $userid));
+                                       $levels['rows'] = loadTemplate('admin_list_refs_norefs', TRUE, array('userid' => $userid));
                                }
 
                                // Free result
-                               SQL_FREERESULT($result_refs);
+                               sqlFreeResult($result_refs);
 
                                // Load level template
-                               $OUT .= loadTemplate('admin_list_refs_level', true, $levels);
+                               $OUT .= loadTemplate('admin_list_refs_level', TRUE, $levels);
                        } // END - while
 
                        // Prepare content
@@ -146,14 +143,14 @@ ORDER BY
                        );
 
                        // Load main template
-                       loadTemplate('admin_list_refs', false, $content);
+                       loadTemplate('admin_list_refs', FALSE, $content);
                } else {
                        // No refs made so far
                        displayMessage('{--USER_REFERRAL_404--}');
                }
 
                // Free result
-               SQL_FREERESULT($result_levels);
+               sqlFreeResult($result_levels);
        } else {
                // User not found
                displayMessage('{%message,ADMIN_MEMBER_404=' . getRequestElement('userid') . '%}');