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);
};
if ($c->check_user_roles(qw/irc_masterop/)){
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);
};
if ($c->check_user_roles(qw/irc_masterop/)){