1 #**************************************************************************
2 # Copyright (C) 2008 by Michael Andreen <harvATruinDOTnu> *
4 # This program is free software; you can redistribute it and/or modify *
5 # it under the terms of the GNU General Public License as published by *
6 # the Free Software Foundation; either version 2 of the License, or *
7 # (at your option) any later version. *
9 # This program is distributed in the hope that it will be useful, *
10 # but WITHOUT ANY WARRANTY; without even the implied warranty of *
11 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
12 # GNU General Public License for more details. *
14 # You should have received a copy of the GNU General Public License *
15 # along with this program; if not, write to the *
16 # Free Software Foundation, Inc., *
17 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. *
18 #**************************************************************************/
20 package NDIRC::Commands::Channel;
27 use MooseX::MethodAttributes;
30 : Alias(qw/deop voice devoice/)
31 : Help(syntax: .op [nicks] | Gives op to the specified nicks, or yourself if no command is given)
34 my ($self,$c,$msg) = @_;
36 my ($access) = $self->name =~ /(op|voice)/;
41 $where = "OR f.name = 'auto_$access'";
45 SELECT DISTINCT c.name FROM users u
46 JOIN groupmembers g ON g.uid = u.uid
47 JOIN channel_group_flags gf ON g.gid = gf.group
48 JOIN channels c ON gf.channel = c.id
49 JOIN channel_flags f ON f.id = gf.flag
50 WHERE u.hostmask ILIKE ? AND c.name = ? AND (f.name = '$access' $where);
52 if ($c->check_user_roles(qw/irc_masterop/)){
55 ($mode) = $c->model->selectrow_array($mode,undef,$c->host,$c->channel);
58 $c->server->command($self->name . " " . $c->channel . " $msg");
60 $c->reply("No access to " . $self->name . " in this channel");
65 :Help(Syntax: invite [channel] | If no channel is specified it invites you to all channel you have auto invite access on)
68 my ($self,$c,$msg) = @_;
70 my ($channel) = $msg =~ /^\s*(\S+)?\s*$/ or die 'ARGS';
73 if ($channel && $c->check_user_roles('irc_masterinvite')){
74 push @channels,$channel;
76 my @access = ('auto_invite');
77 push @access, 'invite' if $channel;
78 my $channels = $c->model->prepare(q{
79 SELECT DISTINCT c.name FROM users u
80 JOIN groupmembers g ON g.uid = u.uid
81 JOIN channel_group_flags gf ON g.gid = gf.group
82 JOIN channels c ON gf.channel = c.id
83 JOIN channel_flags f ON f.id = gf.flag
84 WHERE u.hostmask ILIKE $1 AND COALESCE(c.name = $2,TRUE)
85 AND (f.name = ANY($3) )
87 $channels->execute($c->host,$channel,\@access);
88 while (my ($channel) = $channels->fetchrow()){
89 push @channels,$channel;
93 $c->server->command("invite ". $c->nick ." $_");
98 : Help(Shows your hostname, as seen by the bots.)
100 my ($self,$c,$msg) = @_;
102 $c->reply('Your hostname is: '.$c->host);