X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FMembers.pm;h=8c7f6cbb4c981fee2cf2edd40ab41aa20181b22b;hp=0751b4040979fc992e90bc0ed6bc2650589a9307;hb=5f201b31d1ed259f7eec068794b477f886a77bcb;hpb=30262dafa6c73a1d1cbb493e66b59e267eaa6682 diff --git a/lib/NDWeb/Controller/Members.pm b/lib/NDWeb/Controller/Members.pm index 0751b40..8c7f6cb 100644 --- a/lib/NDWeb/Controller/Members.pm +++ b/lib/NDWeb/Controller/Members.pm @@ -83,12 +83,6 @@ ORDER BY landing_tick DESC }); $announcements->execute($c->user->id); $c->stash(announcements => $announcements->fetchall_arrayref({}) ); - - my ($attackgroups) = $dbh->selectrow_array(q{ -SELECT array_agg(gid) FROM groupmembers WHERE gid IN ('x','y','z') AND uid = $1 - }, undef, $c->user->id); - $c->stash(attackgroups => $attackgroups); - } sub posthostupdate : Local { @@ -101,23 +95,6 @@ sub posthostupdate : Local { $c->res->redirect($c->uri_for('')); } -sub postattackgroups : Local { - my ( $self, $c ) = @_; - my $dbh = $c->model; - - my @groups = $c->req->param('class'); - $dbh->do(q{DELETE FROM groupmembers WHERE gid IN ('x','y','z') AND gid <> ALL($1) AND uid = $2 - },undef, \@groups, $c->user->id); - - $dbh->do(q{INSERT INTO groupmembers (uid,gid) ( - SELECT $2, gid FROM unnest($1::text[]) AS gid WHERE gid IN ('x','y','z') - EXCEPT - SELECT uid,gid FROM groupmembers WHERE uid = $2 - )},undef, \@groups, $c->user->id); - - $c->res->redirect($c->uri_for('')); -} - sub postsmsupdate : Local { my ( $self, $c ) = @_; my $dbh = $c->model;