Use new race infrastructure for members stats

[ndwebbie.git] / scripts / scans.pl

diff --git a/scripts/scans.pl b/scripts/scans.pl
index 525c969c9d42c8876200491b1813909415900438..89dd92c787f18424fc2fe7d7994c0d2aa4aa55aa 100755 (executable)
--- a/scripts/scans.pl
+++ b/scripts/scans.pl
@@ -85,31 +85,11 @@ my $addintel = $dbh->prepare(q{INSERT INTO intel (name,mission,sender,target,tic
        VALUES(?,?,?,?,?,?,?,?,?,-1) RETURNING id});
 my $intelscan = $dbh->prepare(q{INSERT INTO intel_scans (intel,id) VALUES(?,?)});
 my $addships = $dbh->prepare(q{INSERT INTO fleet_ships (fid,ship,amount) VALUES(?,?,?)});
-my $addplanetscan = $dbh->prepare(q{INSERT INTO planet_scans
-       (id,tick,pid,metal_roids,metal,crystal_roids,crystal,eonium_roids,eonium
-               ,agents,guards,light,medium,heavy,hidden)
-       VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)});
 
 sub parse_planet {
        my ($scan,$file) = @_;
 
-       my @values = ($scan->{id},$scan->{tick},$scan->{pid});
-       $file =~ s/(\d),(\d)/$1$2/g;
-
-       while($file =~ m{"center">(Metal|Crystal|Eonium)</td>\D+(\d+)\D+([\d,]+)}g){
-               push @values,$2,$3;
-       }
-       if($file =~ m{Security\ Guards .+? "center">(\d+)</td>
-                       .+? "center">(\d+)</td>}sx){
-               push @values,$1,$2;
-       }
-       if($file =~ m{<td class="center">([A-Z][a-z]+)</td><td class="center">([A-Z][a-z]+)</td><td class="center">([A-Z][a-z]+)</td>}){
-               push @values,$1,$2,$3;
-       }
-       if($file =~ m{<span class="superhighlight">([\d,]+)</span>}){
-               push @values,$1;
-       }
-       $addplanetscan->execute(@values);
+       doPlanetScan($dbh, $scan, $file);
 }
 
 sub parse_incoming {
@@ -133,7 +113,7 @@ sub parse_jumpgate {
        my ($scan,$file) = @_;
 
        $file =~ s/,//g;
-       while ($file =~ m{(\d+):(\d+):(\d+)\D+(Attack|Defend|Return)</td><td class="left">([^<]*)\D+(\d+)\D+(\d+)}g){
+       while ($file =~ m{(\d+):(\d+):(\d+)(?::\d+)?\D+(Attack|Defend|Return)</td><td class="left">([^<]*)\D+(\d+)\D+(\d+)}g){
                my ($sender) = $dbh->selectrow_array($findplanet,undef,$1,$2,$3,$scan->{tick});
                ($sender) = $dbh->selectrow_array($findoldplanet,undef,$1,$2,$3,$scan->{tick})
                        if ((not defined $sender) && $4 eq 'Return');