A lot while() conditions rewritten to SQL_FETCHARRAY(), see bug #107, @TODO tags...

[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 8881b2f9fba60b92b6f7f3158009c5c6caf7a794..ad5d80972773a0a6fa8999385ff804b5a0c51129 100644 (file)
--- a/inc/modules/admin/what-list_refs.php
+++ b/inc/modules/admin/what-list_refs.php
@@ -116,12 +116,14 @@ ORDER BY level ASC", __FILE__, __LINE__);
                                                // Output info message
                                                $levels['info'] = sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), ADMIN_USER_PROFILE_LINK($uid), $menge, $menge_lck);
 
-                                               // Load all refs
+                                               // Init variables
                                                $OUT_REFS = ""; $SW = 2;
-                                               while (list($refid) = SQL_FETCHROW($result_refs)) {
+
+                                               // Load all refs
+                                               while ($content = SQL_FETCHARRAY($result_refs)) {
                                                        // Query for data
                                                        $result_user = SQL_QUERY_ESC("SELECT userid, gender, surname, family, email, status, joined FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
-                                                               array($refid), __FILE__, __LINE__);
+                                                               array($content['refid']), __FILE__, __LINE__);
 
                                                        // Is the data there?
                                                        if (SQL_NUMROWS($result_user) == 1) {
@@ -130,7 +132,7 @@ ORDER BY level ASC", __FILE__, __LINE__);
 
                                                                // Check for referals
                                                                $result_cnt = SQL_QUERY_ESC("SELECT COUNT(userid) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s",
-                                                                       array($refid), __FILE__, __LINE__);
+                                                                       array($content['refid']), __FILE__, __LINE__);
 
                                                                // Load refs
                                                                $refs_cnt = SQL_RESULT($result_cnt, 0, 0);
@@ -158,7 +160,7 @@ ORDER BY level ASC", __FILE__, __LINE__);
                                                                $OUT_REFS .= LOAD_TEMPLATE("admin_list_refs_row", true, $content);
                                                        } else {
                                                                // No refs found
-                                                               $OUT_REFS = LOAD_TEMPLATE("admin_list_refs_nodata", true, $refid);
+                                                               $OUT_REFS = LOAD_TEMPLATE("admin_list_refs_nodata", true, $content['refid']);
                                                        }
 
                                                        // Free result