X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=Access.pm;h=77f88cb047fe13a018d38e1b37cc5abccfe75849;hb=46de469b2264dd5552b1f2c1c2606d58a2123964;hp=91b800253d8cd999eca95f756db4a93ef37946d8;hpb=9e84f393649d1ecbc24a94476352a28f49afa458;p=NDIRC.git

diff --git a/Access.pm b/Access.pm
index 91b8002..77f88cb 100644
--- a/Access.pm
+++ b/Access.pm
@@ -54,12 +54,9 @@ sub masterinvite {
 sub groupmember {
 	my ($groups) = @_;
 	$groups = join ",", map {"'$_'"} split //, $groups;
-	my $f = $ND::DBH->prepare("SELECT username FROM users NATURAL JOIN groupmembers NATURAL JOIN groups WHERE flag IN ('T',$groups) AND hostmask ILIKE ?");
-	$f->execute($ND::address);
-	if ($f->fetchrow()){
-		return 1;
-	}
-	return 0;
+	my $f = $ND::DBH->prepare("SELECT uid,username FROM users NATURAL JOIN groupmembers NATURAL JOIN groups WHERE flag IN ('T',$groups) AND lower(hostmask) = ?");
+	$f->execute(lc($ND::address));
+	return $f->fetchrow_hashref;
 };
 
 1;