X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=ND%2FIRC%2FAccess.pm;h=03851bb382de69e33b08ba0f0d0851d4ab68ed26;hb=c529d3c79dcc8b8d9242d0d4d074fabc8cbbe106;hp=c3f9ef1eb0f5d34421715723a4ada572ba8e0614;hpb=645c4eb3a875e41cee1988b357e6fa2844d30668;p=ndwebbie.git diff --git a/ND/IRC/Access.pm b/ND/IRC/Access.pm index c3f9ef1..03851bb 100644 --- a/ND/IRC/Access.pm +++ b/ND/IRC/Access.pm @@ -23,8 +23,11 @@ require Exporter; our @ISA = qw/Exporter/; -our @EXPORT = qw/officer dc bc hc scanner intel masterop masterinvite/; +our @EXPORT = qw/member officer dc bc hc scanner intel masterop masterinvite/; +sub member { + return groupmember("HM"); +}; sub officer { return groupmember("HO"); }; @@ -54,9 +57,10 @@ sub masterinvite { sub groupmember { my ($groups) = @_; $groups = join ",", map {"'$_'"} split //, $groups; - 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); - return $f->fetchrow_hashref; + my $f = $ND::DBH->prepare("SELECT uid,username FROM users NATURAL JOIN groupmembers NATURAL JOIN groups WHERE flag IN ('T',$groups) AND lower(hostmask) = ?") or print $ND::DBH->errstr; + $f->execute(lc($ND::address)); + my $user = $f->fetchrow_hashref; + return $user; }; 1;