Column for shipname has been renamed

[NDIRC.git] / Commands / Usermgm.pm

diff --git a/Commands/Usermgm.pm b/Commands/Usermgm.pm
index 00ebeb0d77ff4064b871a9b13d52e56489c32b18..eb7560c7a626a9d7c1813a991d947886f2de6ebc 100644 (file)
--- a/Commands/Usermgm.pm
+++ b/Commands/Usermgm.pm
@@ -523,7 +523,7 @@ command getanti => {
                my $f = $dbh->prepare(q{
 SELECT username, ship, amount, CASE WHEN $1 = t1 THEN 't1' ELSE 't2' END AS t
 FROM available_ships a
-       JOIN ship_stats s ON (a.ship = s.name)
+       JOIN ship_stats s USING (ship)
 WHERE uid IN (SELECT uid FROM groupmembers WHERE gid = 'M')
        AND class = ANY($2)
        AND $1 IN (t1,t2)