Package: freeradius-dialupadmin
Version: 1.0.2-4
Severity: normal

In badusers.php3 fieldnames are written with both high and low characters. The 
SQL query fails on my system. Lowering the characters fixes the 
problem.

Diff:

--- badusers.php3       2004-04-06 21:37:48.000000000 +0200
+++ /usr/share/freeradius-dialupadmin/htdocs/badusers.php3      2005-05-14 
19:28:03.920747864 +0200
@@ -73,12 +73,12 @@
 $link = @da_sql_connect($config);
 if ($link){
        $search = @da_sql_query($link,$config,
-       "SELECT id,Admin FROM $config[sql_badusers_table]
+       "SELECT id,admin FROM $config[sql_badusers_table]
        WHERE id = '$row_id';");
        if ($search){
                $row = @da_sql_fetch_array($search,$config);
                if ($row[id] == $row_id){
-                       $admin = "$row[Admin]";
+                       $admin = "$row[admin]";
                        if (($admin != '-' && 
$HTTP_SERVER_VARS["PHP_AUTH_USER"] == $admin) || $admin == '-'){
                                $sql_servers = array();
                                if ($config[sql_extra_servers] != '')
@@ -152,10 +152,10 @@
                while( $row = @da_sql_fetch_array($search,$config) ){
                        $num++;
                        $id = $row[id];
-                       $user = "$row[UserName]";
-                       $date = "$row[Date]";
-                       $reason = "$row[Reason]";
-                       $admin = "$row[Admin]";
+                       $user = "$row[username]";
+                       $date = "$row[date]";
+                       $reason = "$row[reason]";
+                       $admin = "$row[admin]";
                        if ($admin == $auth_user || $admin == '-')
        $action = "<td><input type=submit class=button value=\"Delete\" 
OnClick=\"this.form.do_delete.value=1;this.form.row_id.value=$id\"></td>";
                        else



-- System Information:
Debian Release: 3.1
Architecture: i386 (i686)
Kernel: Linux 2.6.8-2-386
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)

Versions of packages freeradius-dialupadmin depends on:
ii  apache [httpd]            1.3.33-6sarge1 versatile, high-performance HTTP s
ii  apache-ssl [httpd]        1.3.33-6sarge1 versatile, high-performance HTTP s
ii  php4                      4:4.3.10-16    server-side, HTML-embedded scripti

-- no debconf information


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Reply via email to