Listing of coupons rewritten to more clear

[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 0be210ce71a89b2e810f27866edbed29a397eac6..3f8f0e760a5d2c5e9c12620ec0187d325a119e79 100644 (file)
--- a/inc/modules/admin/what-list_refs.php
+++ b/inc/modules/admin/what-list_refs.php
@@ -64,7 +64,7 @@ if (isGetRequestParameterSet('userid')) {
 
                // Load all referal levels
                $result_levels = SQL_QUERY("SELECT
-       `level`, `percents`
+       `level`,`percents`
 FROM
        `{?_MYSQL_PREFIX?}_refdepths`
 WHERE
@@ -80,7 +80,7 @@ ORDER BY
                                // Is the refback still active? ;-)
                                if (isExtensionActive('refback')) {
                                        // 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 = SQL_QUERY_ESC("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));
 
@@ -192,7 +192,7 @@ ORDER BY
                SQL_FREERESULT($result_levels);
        } else {
                // User not found
-               displayMessage(getMaskedMessage('ADMIN_MEMBER_404', getRequestParameter('userid')));
+               displayMessage('{%message,ADMIN_MEMBER_404=' . getRequestParameter('userid') . '%}');
        }
 } else {
        // Output selection form with all confirmed user accounts listed