+ $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 DISTINCT * 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);
+