X-Git-Url: https://ruin.nu/git/?p=NDIRC.git;a=blobdiff_plain;f=Commands%2FUsermgm.pm;h=eb7560c7a626a9d7c1813a991d947886f2de6ebc;hp=00ebeb0d77ff4064b871a9b13d52e56489c32b18;hb=effc5281e94e0fa16f1fd08bf848f607a306d0c0;hpb=cbe172da35e963a0e3205af1337e7b5efee24c13

diff --git a/Commands/Usermgm.pm b/Commands/Usermgm.pm
index 00ebeb0..eb7560c 100644
--- 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)