JOIN groupmembers g USING (uid)
JOIN channel_group_flags gf USING (gid)
JOIN channel_flags f USING (flag)
-WHERE u.hostmask ILIKE $1 AND channel = $2 AND f.name = ANY($3);
+WHERE uid = $1 AND channel = $2 AND f.name = ANY($3);
};
if ($c->check_user_roles(qw/irc_masterop/)){
$mode = substr $access[0], 0,1;
}else{
- ($mode) = $c->model->selectrow_array($mode,undef,$c->host,$c->channel,\@access);
+ ($mode) = $c->model->selectrow_array($mode,undef,$c->uid,$c->channel,\@access);
}
if ($mode){
$c->command(mode => $c->channel, "$mod$mode", $msg);
if ($channel && $c->check_user_roles('irc_masterinvite')){
push @channels,$channel;
}else{
- my @access = ('auto_invite');
- push @access, 'invite' if $channel;
+ my @access = ('i');
+ push @access, 'I' if $channel;
my $channels = $c->model->prepare(q{
SELECT DISTINCT channel FROM users u
JOIN groupmembers g USING (uid)
JOIN channel_group_flags gf USING (gid)
- JOIN channel_flags f USING (flag)
-WHERE u.hostmask ILIKE $1 AND COALESCE(channel = $2,TRUE)
- AND (f.name = ANY($3) )
+WHERE uid = $1 AND COALESCE(channel = $2,TRUE)
+ AND (flag = ANY($3) )
});
- $channels->execute($c->host,$channel,\@access);
+ $channels->execute($c->uid,$channel,\@access);
while (my ($channel) = $channels->fetchrow()){
push @channels,$channel;
}
my $password = generate_random_string 10;
my $update = $dbh->do(q{
UPDATE users SET password = MD5( ? )
-WHERE hostmask ILIKE ? AND password =''
- },undef,$password,$c->host);
+WHERE uid ? AND password =''
+ },undef,$password,$c->uid);
if ($update > 0){
$c->reply("Password set to: $password (you can change it on webbie)");
}else{