+vessels
+#| Ship Name |Gun Size|Volume | Mass |
+ |Sloop |small |20,250 |13,500 |
+ |----------------+--------+-------+-------|
+ |Cutter |small |60,750 |40,500 |
+ |----------------+--------+-------+-------|
+ |Dhow |medium |20,250 |13,500 |
+ |----------------+--------+-------+-------|
+ |Longship |small |20,250 |13,500 |
+ |----------------+--------+-------+-------|
+ |Baghlah |medium |27,000 |18,000 |
+ |----------------+--------+-------+-------|
+ |Merchant brig |medium |135,000|90,000 |
+ |----------------+--------+-------+-------|
+ |War brig |medium |81,000 |54,000 |
+ |----------------+--------+-------+-------|
+ |Merchant galleon|large |405,000|270,000|
+ |----------------+--------+-------+-------|
+ |Xebec |medium |182,250|121,500|
+ |----------------+--------+-------+-------|
+ |War frigate |large |324,000|216,000|
+ |----------------+--------+-------+-------|
+ |Grand frigate |large |810,000|540,000|
+# From http://yppedia.puzzlepirates.com/Ship; when updating,
+# delete unused columns and check heading is the same as above.
+# If fields reordered must change parser in Commods.pm.
+
+shot
+ small 2
+ medium 3
+ large 4
+
commods
kraken's blood 1kg
%c dye 1kg
ocean Hunter
Eagle
Ix Chel
+ Manu Island
ocean Malachite
Draco
# ./update-master-info -a
# and check that nothing unexpected changes.
#
+ # To just make backups of the databases into the rsync directory:
+ # ./update-master-info -b -d ~ftp/users/ijackson/yarrg/ -a
+ # ./update-master-info -b -d ~ftp/users/ijackson/yarrg/ -O ...
# This is part of ypp-sc-tools, a set of third-party tools for assisting
# players of Yohoho Puzzle Pirates.
use strict (qw(vars));
use DBI;
use Commods;
+ use CommodsDatabase;
+ use File::Copy;
$ENV{'LC_CTYPE'}= 'en_GB.UTF-8';
next if $h =~ m/^nocommods/;
}
next if $sfn =~ m/source-info/ && $h =~ m/^ocean\b/;
- next if $h =~ m/^client\b/;
+ next if $h =~ m/^client|^vessels|^shot\b/;
print $df $_, "\n" or die $!;
}
my @specoceans;
my $alloceans;
+ my $backup;
sub optarg () {
return $_ if length;
$rsyncdir= optarg();
} elsif (s/^-O//) {
push @specoceans, optarg();
- } elsif (s/^-a//) {
+ } elsif (s/^-b/-/) {
+ die if $backup;
+ $backup=1;
+ } elsif (s/^-a/-/) {
die if $alloceans;
$alloceans=1;
} else {
die if @ARGV;
die if @specoceans && $alloceans;
+ die if $backup && !$alloceans && !@specoceans;
parse_info_serverside();
- if (@specoceans) {
+ if ($backup) {
+ my @oceans= $alloceans ? (sort keys %oceans) : @specoceans;
+ foreach my $ocean (@oceans) {
+ print "## database backup for $ocean\n";
+ db_setocean($ocean);
+ db_writer();
+ db_connect();
+ $dbh->selectall_arrayref("SELECT * FROM commods WHERE commodid=1");
+ my $src= db_filename();
+ my $dst= $src; $dst =~ s,.*/,,; $dst= "$rsyncdir/$dst";
+ copy($src,"$dst.tmp") or die "$src -> $dst.tmp $!";
+ rename("$dst.tmp",$dst) or die "$dst.tmp -> $dst $!";
+ $dbh->rollback();
+ }
+ } elsif (@specoceans) {
print "### full update of specified oceans ...\n";
foreach my $ocean (@specoceans) {
die "$ocean ?" unless defined $oceans{$ocean};
}
}
- if (defined $rsyncdir) {
+ if (defined $rsyncdir and !$backup) {
print "### master-info update ...\n";
update_master_info();
}