X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=calls.pl;h=ce708fc0df83aa37c90a9c33988111e3bb2bd815;hb=354c2fb813a139fb08476b6d0e7f30308091038a;hp=5fa57dff1ae9809ab5055664b5d511812379263f;hpb=4e43c322c67e8426100bb90d46fd43630a0608f2;p=ndwebbie.git diff --git a/calls.pl b/calls.pl index 5fa57df..ce708fc 100644 --- a/calls.pl +++ b/calls.pl @@ -181,7 +181,7 @@ ORDER BY p.x,p.y,p.z}); my ($maxpoints) = $DBH->selectrow_array($pointlimits,undef,'DEFMAX'); my $query = $DBH->prepare(qq{ -SELECT c.id, coords(p.x,p.y,p.z), u.defense_points, c.landing_tick, +SELECT c.id, coords(p.x,p.y,p.z), u.defense_points, c.landing_tick, c.dc, TRIM('/' FROM concat(p2.race||' /')) AS race, TRIM('/' FROM concat(i.amount||' /')) AS amount, TRIM('/' FROM concat(i.eta||' /')) AS eta, TRIM('/' FROM concat(i.shiptype||' /')) AS shiptype, TRIM('/' FROM concat(c.landing_tick - tick() ||' /')) AS curreta, @@ -193,7 +193,7 @@ FROM calls c JOIN current_planet_stats p ON u.planet = p.id JOIN current_planet_stats p2 ON i.sender = p2.id WHERE $where -GROUP BY c.id, p.x,p.y,p.z, u.username, c.landing_tick, c.info,u.defense_points +GROUP BY c.id, p.x,p.y,p.z, u.username, c.landing_tick, c.info,u.defense_points,c.dc ORDER BY c.landing_tick DESC })or $error .= $DBH->errstr; $query->execute or $error .= $DBH->errstr; @@ -213,6 +213,7 @@ ORDER BY c.landing_tick DESC push @calls,{}; $i = 0; } + $call->{dc} = 'Hostile' unless defined $call->{dc}; $i++; $call->{ODD} = $i % 2; $call->{shiptype} = escapeHTML($call->{shiptype});