X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=ND%2FAuthHandler.pm;h=b7cc70037c3a454ee156b9ed141f00a66384d53f;hb=accb7993672db2b43ee7a6feb1a0dcde4fe39e9b;hp=af113d952e9880a9361a01933a4cb16a7df1fe5f;hpb=40f379f98b8350710b02d1f68a90d337ad13ab92;p=ndwebbie.git

diff --git a/ND/AuthHandler.pm b/ND/AuthHandler.pm
index af113d9..b7cc700 100644
--- 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;
 	}