1 files changed, 105 insertions, 0 deletions
diff --git a/contrib-noinst/make-csv.pl b/contrib-noinst/make-csv.pl
new file mode 100644
index 00000000..5dc265f8
--- /dev/null
+++ b/contrib-noinst/make-csv.pl
@@ -0,0 +1,105 @@
+#!/usr/bin/env perl
+
+use strict;
+use List::Util qw'reduce';
+
+use POSIX qw(locale_h);
+setlocale(LC_ALL, "C");
+
+sub get_games_1
+{
+    my @games;
+
+    open my $fd, "<", $ARGV[1] or die "open: $!";
+    binmode $fd;
+    <$fd>;
+
+    while (defined(my $line = <$fd>))
+    {
+        $line =~ s/[\r\n]+$//s;
+        if ($line !~ /^(\d+)\s+"([^;"]+)"(?:\s+\(([0-9A-F]{16})\))?$/)
+        {
+            warn "Broken line";
+            next;
+        }
+        next if $1 <= 0;
+        push @games, +{ id => $1, name => $2, key => $3 }
+    }
+    [sort { lc($a->{name}) cmp lc($b->{name}) } @games]
+}
+
+sub get_games_2
+{
+    open my $fd, "<", $ARGV[0] or die "open: $!";
+    binmode $fd;
+    <$fd>;
+    my @games;
+    my %ids;
+    while (defined(my $line = <$fd>))
+    {
+        $line =~ s/[\r\n]+$//s;
+        my @line = split/;/, $line;
+        if (@line != 8)
+        {
+            warn "Broken line";
+            next;
+        }
+        my @cols = qw'no name proto since verified by id key';
+        my $h = +{ map { $cols[$_] => $line[$_] } 0..$#cols };
+        next if exists $ids{$h->{id}};
+        $ids{$h->{id}} = undef;
+        next if $h->{id} <= 0;
+        push @games, $h;
+    }
+    [@games];
+}
+
+sub merge
+{
+    my ($new_games, $old_games) = @_;
+    my $no = (reduce { $a->{no} > $b->{no} ? $a : $b } +{id=>0}, @$old_games)->{no} + 1;
+    my %ids = map { $_->{id} => $_ } @$old_games;
+    binmode \*STDOUT;
+    for my $g (@$new_games)
+    {
+        my $id = $g->{id};
+        my $no_ = $ids{$id} ? $ids{$id}->{no} : $no;
+        next if (exists($ids{$id}) && $ids{$id}->{verified} ne '');
+        my $old = $ids{$id} || do { $no++; +{} };
+        $ids{$id} =
+            +{
+                no => $no_,
+                name => $g->{name},
+                proto => 'FreeTrack20',
+                verified => '',
+                by => '',
+                id => $g->{id},
+                %$old,
+                since => $g->{key} ? 'V170' : 'V160',
+                key => $g->{key} ? (sprintf "%04X", $no_) . $g->{key} . '00' : $old->{key}
+            };
+    }
+    print "No;Game Name;Game protocol;Supported since;Verified;By;INTERNATIONAL_ID;FTN_ID\n";
+    for (sort { $a->{no} <=> $b->{no} } values %ids)
+    {
+        my $g = {%$_};
+        if (!defined $g->{key})
+        {
+            $g->{key} = (sprintf "%04X", $g->{no}) . (join"", map { sprintf "%02X", int rand 256 } 0 .. 7) . '00';
+        }
+        my @cols = qw'no name proto since verified by id key';
+        print join";", map { $g->{$_} } @cols;
+        print "\n";
+    }
+}
+
+if (@ARGV != 2)
+{
+    warn "usage: $0 orig.csv dump.txt\n";
+    exit 1;
+}
+else
+{
+    merge(get_games_1(), get_games_2());
+    exit 0;
+}