X-Git-Url: https://ruin.nu/git/?p=NDIRC.git;a=blobdiff_plain;f=Commands%2FScans.pm;h=193e486c46b80b6c094988876338415e689040be;hp=319e38cfef6eded49488b59bd855bff36f3414f9;hb=c9c9e83da024d15fc1245bf456c197c119f23cf4;hpb=4c84eb6e64b730b9b8726d30e70c355a5056b83c diff --git a/Commands/Scans.pm b/Commands/Scans.pm index 319e38c..193e486 100644 --- a/Commands/Scans.pm +++ b/Commands/Scans.pm @@ -201,6 +201,7 @@ SELECT ship,amount FROM fleet_ships WHERE fid = $1 ORDER BY num command addscan => { help => q(syntax: .addscan list of scans), + type => q(universal), }, class extends NDIRC::Command { method execute($c,$msg) { my $dbh = $c->model; @@ -213,7 +214,7 @@ WHERE groupscan = $1 AND scan_id = LOWER($2) AND tick >= tick() - 168 INSERT INTO scans (scan_id,tick,groupscan,uid) VALUES (LOWER($1),tick(),$2,COALESCE($3,-1)) }); my $user = $dbh->selectrow_hashref(q{SELECT uid,username, scan_points, tick() - FROM users WHERE uid = ? },undef,$c->uid); + FROM users WHERE uid = ? AND uid > 0 },undef,$c->uid); my $groupscans = 0; my $scans = 0; eval {