X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FAuth%2FUser.pm;h=c5738c3db3c464e93eedd23112e3788450998f41;hb=6772ec335287679e8837ebe85b8b1218cc2be8ff;hp=c19ba2b097b85bf54f4d3c224e52097a5483314d;hpb=b49322dc8ac6ddc3d988caa5cd92b397fb8d0c31;p=ndwebbie.git

diff --git a/lib/NDWeb/Auth/User.pm b/lib/NDWeb/Auth/User.pm
index c19ba2b..c5738c3 100644
--- a/lib/NDWeb/Auth/User.pm
+++ b/lib/NDWeb/Auth/User.pm
@@ -31,7 +31,7 @@ sub load {
 
 	if (exists $authinfo->{id}){
 		$self->{id} = $dbh->selectrow_array(q{
-			SELECT uid FROM users WHERE lower(username) = lower(?)
+			SELECT uid FROM users WHERE username = ?
 		},undef,$authinfo->{id});
 	}elsif (exists $authinfo->{uid}){
 		$self->{id} = $authinfo->{uid};
@@ -42,7 +42,7 @@ sub load {
 	}
 
 	($self->{planet},$self->{username},$self->{css}) = $dbh->selectrow_array(q{
-		SELECT planet,username,css FROM users WHERE uid = ?
+		SELECT pid,username,css FROM users WHERE uid = ?
 		},undef,$self->{id}) or die $dbh->errstr;
 
 	return $self;