package NDWeb::Pages::MemberIntel;
use strict;
-use warnings FATAL => 'all';
+use warnings;
use CGI qw/:standard/;
use NDWeb::Include;
});
$query->execute($user->{uid}) or $error .= $DBH->errstr;
my @nd_attacks;
- my @retals;
- my @other;
+ my @other_attacks;
+ my $ndi = 0;
+ my $oi = 0;
while (my $intel = $query->fetchrow_hashref){
my $attack = {target => $intel->{coords}, tick => $intel->{tick}};
if ($intel->{ndtarget}){
}else{
$attack->{Other} = 'Launched at a tick that was not claimed';
}
+ $attack->{ODD} = ++$ndi % 2;
push @nd_attacks, $attack;
}else{
- push @other, $attack;
+ $attack->{ODD} = ++$oi % 2;
+ push @other_attacks, $attack;
}
}
my @attacks;
- push @attacks, {name => 'ND Attacks', list => \@nd_attacks};
- push @attacks, {name => 'Other', list => \@other};
+ push @attacks, {name => 'ND Attacks', list => \@nd_attacks, class => 'AllyDef'};
+ push @attacks, {name => 'Other', list => \@other_attacks, class => 'Attack'};
$BODY->param(Attacks => \@attacks);
+ $query = $DBH->prepare(q{
+ SELECT coords(t.x,t.y,t.z),t.alliance_id, t.alliance, i.eta, i.tick, i.ingal
+ FROM users u
+ JOIN (SELECT * FROM intel WHERE amount = -1) i ON i.sender = u.planet
+ LEFT OUTER JOIN current_planet_stats t ON i.target = t.id
+ WHERE u.uid = $1 AND (i.mission = 'Defend' OR i.mission = 'AllyDef')
+ ORDER BY (i.tick - i.eta)
+ });
+ $query->execute($user->{uid}) or $error .= $DBH->errstr;
+ my @nd_def;
+ my @ingal_def;
+ my @other_def;
+ $ndi = 0;
+ $oi = 0;
+ my $gi = 0;
+ while (my $intel = $query->fetchrow_hashref){
+ my $def = {target => $intel->{coords}.(defined $intel->{alliance} ? " ($intel->{alliance})" : ''), tick => $intel->{tick}};
+ if (defined $intel->{alliance_id} && $intel->{alliance_id} == 1){
+ $def->{ODD} = ++$ndi % 2;
+ push @nd_def, $def;
+ }elsif($intel->{ingal}){
+ $def->{ODD} = ++$gi % 2;
+ push @ingal_def, $def;
+ }else{
+ $def->{ODD} = ++$oi % 2;
+ push @other_def, $def;
+ }
+ }
+ my @defenses;
+ push @defenses, {name => 'ND Def', list => \@nd_def, class => 'AllyDef'};
+ push @defenses, {name => 'Ingal Def', list => \@ingal_def, class => 'Defend'};
+ push @defenses, {name => 'Other', list => \@other_def, class => 'Attack'};
+ $BODY->param(Defenses => \@defenses);
+
}else{
my $query = $DBH->prepare(q{SELECT u.uid,u.username,u.attack_points, u.defense_points, n.tick
,count(CASE WHEN i.mission = 'Attack' THEN 1 ELSE NULL END) AS attacks