X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FMembers.pm;h=fb0e6e41d309b425c15ba0004919341e26e27f43;hb=202d442fc929b5e4cea904406dc546098516fde1;hp=6afbb6511d058b02ad5511d087b890515388ea9e;hpb=3b0d1d881162c5bcc1a18e8a43c807cc1fe52bc3;p=ndwebbie.git diff --git a/lib/NDWeb/Controller/Members.pm b/lib/NDWeb/Controller/Members.pm index 6afbb65..fb0e6e4 100644 --- a/lib/NDWeb/Controller/Members.pm +++ b/lib/NDWeb/Controller/Members.pm @@ -34,7 +34,7 @@ sub index : Path : Args(0) { $c->stash(u => $dbh->selectrow_hashref(q{SELECT pid AS planet,defense_points ,attack_points,scan_points,humor_points , (attack_points+defense_points+scan_points/20)::NUMERIC(5,1) as total_points - , sms,rank,hostmask,call_if_needed,sms_note,defprio + , rank,defprio FROM users_defprio WHERE uid = ? },undef,$c->user->id) ); @@ -59,14 +59,6 @@ sub index : Path : Args(0) { },undef,$c->user->planet) ); - my $calls = $dbh->prepare(q{ -SELECT * FROM defcalls -WHERE uid = $1 AND landing_tick >= tick() -ORDER BY landing_tick DESC - }); - $calls->execute($c->user->id); - $c->stash(calls => $calls->fetchall_arrayref({}) ); - $c->stash(fleets => member_fleets($dbh, $c->user->id,$c->user->planet)); my $announcements = $dbh->prepare(q{SELECT ft.ftid, u.username,ft.subject, @@ -91,17 +83,6 @@ SELECT array_agg(gid) FROM groupmembers WHERE gid IN ('x','y','z') AND uid = $1 } -sub posthostupdate : Local { - my ( $self, $c ) = @_; - my $dbh = $c->model; - - my $hostname = html_escape $c->req->param('hostname'); - $dbh->do(q{UPDATE users SET hostmask = ? WHERE uid = ? - },undef, $hostname, $c->user->id); - - $c->res->redirect($c->uri_for('')); -} - sub postattackgroups : Local { my ( $self, $c ) = @_; my $dbh = $c->model; @@ -119,20 +100,6 @@ sub postattackgroups : Local { $c->res->redirect($c->uri_for('')); } -sub postsmsupdate : Local { - my ( $self, $c ) = @_; - my $dbh = $c->model; - - my $callme = $c->req->param('callme') || 0; - my $sms = html_escape $c->req->param('sms'); - my $smsnote = $c->req->param('smsnote'); - $dbh->do(q{ -UPDATE users SET sms = $1, call_if_needed = $2, sms_note = $3 WHERE uid = $4 - },undef, $sms, $callme, $smsnote, $c->user->id); - - $c->res->redirect($c->uri_for('')); -} - sub postowncoords : Local { my ( $self, $c ) = @_; my $dbh = $c->model; @@ -386,7 +353,7 @@ sub insertintel : Private { }); my @intel; while ($intel =~ m/(\d+):(\d+):(\d+)\*?\s+(\d+):(\d+):(\d+) - \*?\s+(A|D)\s+(.+?)\s+(?:(?:Ter|Cat|Xan|Zik|Etd)\s+)?(\d+)\s+(\d+)/gx){ + \*?\s+(A|D)\s+(.+?)\s+(?:(?:\w+)\s+)?(\d+)\s+(\d+)/gx){ my $ingal = ($1 == $4 && $2 == $5) || 0; my $lt = $tick + $10; my $back = ($ingal ? $lt + 4 : undef); @@ -405,77 +372,6 @@ sub insertintel : Private { $c->flash(scans => \@scans); } -sub addincs : Local { - my ( $self, $c ) = @_; - $c->stash(incs => $c->flash->{incs}); - -} - -sub postincs : Local { - my ( $self, $c ) = @_; - my $dbh = $c->model; - - my @incs; - - my $user = $dbh->prepare(q{ -SELECT uid FROM users u -WHERE pid = planetid($1,$2,$3,tick()) - AND uid IN (SELECT uid FROM groupmembers WHERE gid = 'M') - }); - my $call = $dbh->prepare(q{ -SELECT call -FROM calls WHERE uid = $1 AND landing_tick = tick() + $2 - }); - my $fleet = $dbh->prepare(q{ -SELECT pid -FROM incomings i -WHERE pid = planetid($1,$2,$3,tick()) AND amount = $4 and fleet = $5 AND call = $6 - }); - my $irc = $dbh->prepare(q{ -INSERT INTO irc_requests (uid,channel,message) VALUES($1,'def',$2) - }); - - my $msg = $c->req->param('message'); - while ($msg =~ m/(\d+):(\d+):(\d+)\*?\s+(\d+):(\d+):(\d+)\*?\s+A\s+(.+?)\s+(Ter|Cat|Xan|Zik|Etd)\s+(\d+)\s+(\d+)/gc - ||$msg =~ /expand\s+(\d+):(\d+):(\d+)\*?\s+(\d+):(\d+):(\d+)\s+([^:]*\S+)\s+(Ter|Cat|Xan|Zik|Etd)\s+([\d,]+)\s+(\d+)/gc - || $msg =~ /(\d+):(\d+):(\d+)\s+(\d+):(\d+):(\d+)\s+\((Ter|Cat|Xan|Zik|Etd)\)\s+([^,]*\S+)\s+([\d,]+)\s+(\d+)\s+\(\d+\)/gc){ - - my $inc = {message => $&}; - my $amount = $9; - { - $amount =~ s/,//g; - } - try { - my $uid = $dbh->selectrow_array($user,undef,$1,$2,$3); - die 'No user with these coords' unless $uid; - - my $call = $dbh->selectrow_array($call,undef,$uid,$10); - if ($call){ - my $pid = $dbh->selectrow_hashref($fleet,undef,$4,$5,$6,$amount,$7,$call); - die 'Duplicate' if $pid; - - } - - my $message = "$1:$2:$3 $4:$5:$6 $7 $8 $amount $10"; - $irc->execute($c->user->id, $message); - $inc->{status} = 'Added'; - - } catch { - when (m(^(.*) at )){ - $inc->{status} = $1; - } - default { - $inc->{status} = $_; - } - }; - push @incs, $inc; - } - - $c->signal_bots if @incs; - $c->flash(incs => \@incs); - $c->res->redirect($c->uri_for('addincs')); -} - sub launchConfirmation : Local { my ( $self, $c ) = @_;