Re-added height, but smaller to make most menus appear shorter

[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 7c4d99b46210c35ce8adb71bff4bb467ec8592e1..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 - 2012 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,7 +43,7 @@ if (isGetRequestElementSet('userid')) {
        $userid = bigintval(getRequestElement('userid'));
 
        // Fix missing variable
-       $result_levels = false;
+       $result_levels = FALSE;
 
        // User found?
        if (fetchUserData($userid)) {
@@ -55,7 +55,7 @@ if (isGetRequestElementSet('userid')) {
                displayMessage(sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), generateUserProfileLink(getRequestElement('userid')), $totalReferrals, $totalLockedReferrals));
 
                // Load all referral levels
-               $result_levels = SQL_QUERY("SELECT
+               $result_levels = sqlQuery("SELECT
        `level`,
        `percents`
 FROM
@@ -66,20 +66,20 @@ 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));
 
                                // Is there levels?
-                               if (!SQL_HASZERONUMS($result_refs)) {
+                               if (!ifSqlHasZeroNums($result_refs)) {
                                        // Count entries
                                        $totalReferrals       = getUsersTotalReferrals($userid, $levels['level']);
                                        $totalLockedReferrals = getUsersTotalLockedReferrals($userid, $levels['level']);
@@ -91,11 +91,11 @@ ORDER BY
                                        $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
@@ -112,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
@@ -126,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
@@ -143,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') . '%}');