log intel changes

[ndwebbie.git] / ND / IRC / Access.pm

diff --git a/ND/IRC/Access.pm b/ND/IRC/Access.pm
index 91b800253d8cd999eca95f756db4a93ef37946d8..c3f9ef1eb0f5d34421715723a4ada572ba8e0614 100644 (file)
--- a/ND/IRC/Access.pm
+++ b/ND/IRC/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 ?");
+       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($ND::address);
-       if ($f->fetchrow()){
-               return 1;
-       }
-       return 0;
+       return $f->fetchrow_hashref;
 };
 
 1;