our @ISA = qw/Exporter/;
-our @EXPORT = qw/parseMilScan doMilScan/;
+our @EXPORT = qw/parseMilScan doMilScan doPlanetScan/;
my %classes = (Fighter => 'Fi', Corvette => 'Co', Frigate => 'Fr', Destroyer => 'De', Cruiser => 'Cr', Battleship => 'Bs', Structure => 'St', Roids => 'Ro', Resources => 'Re', '-' => '-');
}
}
+my $addplanetscan_sql = 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 doPlanetScan ($$$) {
+ my ($dbh, $scan,$file) = @_;
+
+ my $addplanetscan = $dbh->prepare_cached($addplanetscan_sql);
+
+ 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);
+}