Update for changes to groups and irc channels

[NDIRC.git] / Commands / Def.pm

diff --git a/Commands/Def.pm b/Commands/Def.pm
index 1731689e12689e673d06cec3e0d1543e9acbb80c..80b02fdf454d560b161857085461c3defe577062 100644 (file)
--- a/Commands/Def.pm
+++ b/Commands/Def.pm
@@ -55,7 +55,7 @@ sub defcall
                my $st = $dbh->prepare(q{
 SELECT status
        ,c.landing_tick - (SELECT value::integer FROM misc WHERE id = 'TICK') AS eta
-       ,concat(i.shiptype||'/') AS shiptype
+       ,array_to_string(array_agg(i.shiptype),'/') AS shiptype
 FROM calls c
        JOIN incomings i USING (call)
        LEFT OUTER JOIN users dc ON dc.uid = c.dc
@@ -68,7 +68,6 @@ ORDER BY c.landing_tick;
                        $c->reply("No call with id: $callnr");
                        return;
                }
-               chop($call->{shiptype});
                $callinfo = "(Anti $call->{shiptype} ETA: $call->{eta})";
                if($call->{status} eq 'Covered'){
                        $c->reply("Call <b>$callnr</b> $callinfo is covered.");