Unlock of booked URLs in surfbar added, fix for URL-encoded links in loader module

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

diff --git a/inc/modules/admin/what-list_norefs.php b/inc/modules/admin/what-list_norefs.php
index 313ccfc2481236b8747809ea84ed75597995b516..d751a994e0d7b1b2dbf4f5b608ae6cdf3d06c28c 100644 (file)
--- a/inc/modules/admin/what-list_norefs.php
+++ b/inc/modules/admin/what-list_norefs.php
@@ -56,21 +56,21 @@ if (empty($_GET['page']))   { $_GET['page']   = "1";      }
 // Set base URL
 $BASE = "<A href=\"".URL."/modules.php?module=admin";
 
-$WHERE = " WHERE refid='0'";
+$whereStatement = " WHERE refid='0'";
 if (($_GET['letter'] != _ALL2) && ($_GET['letter'] != _OTHERS) && (!empty($_GET['letter'])))
 {
        // List only persons w
-       $WHERE = " WHERE refid='0' AND family LIKE '".$_GET['letter']."%'";
+       $whereStatement = " WHERE refid='0' AND family LIKE '".$_GET['letter']."%'";
 }
 if ($_GET['sortby'] == "family_name") $_GET['sortby'] = "family";
-$SQL = "SELECT userid, sex, surname, family, email, REMOTE_ADDR, refid, status".$MORE." FROM "._MYSQL_PREFIX."_user_data".$WHERE." ORDER BY ".$_GET['sortby'];
+$SQL = "SELECT userid, sex, surname, family, email, REMOTE_ADDR, refid, status".$MORE." FROM "._MYSQL_PREFIX."_user_data".$whereStatement." ORDER BY ".$_GET['sortby'];
 $result_master = SQL_QUERY($SQL, __FILE__, __LINE__);
 
 // Calculate page count (0.5 fixes a bug with page count)
-$PAGES = round(SQL_NUMROWS($result_master) / $CONFIG['user_limit'] + 0.5);
+$PAGES = round(SQL_NUMROWS($result_master) / $_CONFIG['user_limit'] + 0.5);
 
 if (empty($_GET['page']))   $_GET['page']   = "1";
-if (empty($_GET['offset'])) $_GET['offset'] = $CONFIG['user_limit'];
+if (empty($_GET['offset'])) $_GET['offset'] = $_CONFIG['user_limit'];
 
 // Add limitation to SQL string and run him again
 $SQL .= " LIMIT ".($_GET['offset'] * $_GET['page'] - $_GET['offset']).", ".$_GET['offset'];
@@ -93,7 +93,7 @@ if (SQL_NUMROWS($result_master) > 0)
        define('__SORT_LINKS', SortLinks($_GET['letter'], $_GET['sortby'], $colspan, true));
        if ($PAGES > 1)
        {
-               define('__PAGE_NAV', ADD_PAGENAV($PAGES, $CONFIG['user_limit'], true, $colspan, true));
+               define('__PAGE_NAV', ADD_PAGENAV($PAGES, $_CONFIG['user_limit'], true, $colspan, true));
        }
         else
        {
@@ -130,7 +130,7 @@ if (SQL_NUMROWS($result_master) > 0)
                        'sex'    => TRANSLATE_SEX($sex),
                        'sname'  => $sname,
                        'fname'  => $fname,
-                       'email'  => "<A href=\"".CREATE_EMAIL_LINK($email, "user_data")."\">".stripslashes($email)."</A>",
+                       'email'  => "<A href=\"".CREATE_EMAIL_LINK($email, "user_data")."\">".$email."</A>",
                        'addr'   => $IP,
                        'ref'    => $ref,
                        'status' => TRANSLATE_STATUS($status),