not as wide

[ndwebbie.git] / ND / AuthHandler.pm

diff --git a/ND/AuthHandler.pm b/ND/AuthHandler.pm
index af113d952e9880a9361a01933a4cb16a7df1fe5f..b7cc70037c3a454ee156b9ed141f00a66384d53f 100644 (file)
--- a/ND/AuthHandler.pm
+++ b/ND/AuthHandler.pm
@@ -32,7 +32,8 @@ sub handler {
 
        my $dbh = ND::DB::DB();
        my ($count) = $dbh->selectrow_array(q{SELECT count(*) FROM users WHERE
-               username ILIKE ? AND password = MD5(?)},undef,$r->user,$sent_pw);
+               lower(username) = lower(?) AND password = MD5(?)},undef,$r->user,$sent_pw);
+       $dbh->disconnect;
        if ($count == 1){
                return Apache2::Const::OK;
        }