This is a perl script that creates a combined file a for all updates between the specified interval (one for each db), so you don't have to apply them one by one:
#!/usr/bin/perl
use strict;
my $desc = "Generates a combined SQL file with all MaNGOS updates between specified revisions.";
my $usage = "Usage: $0 <first_rev> <last_rev>";
die "$desc\\n\\n$usage\\n" if $#ARGV != 1;
my $first_rev = int($ARGV[0]);
my $last_rev = int($ARGV[1]);
die "error: Invalid parameters.\\n\\n$usage\\n" if $first_rev == 0 || $last_rev == 0;
sub generate
{
my ($filename, @file_list) = @_;
print "generating $filename\\n";
open(FOUT, ">$filename");
foreach my $srcfile (@file_list)
{
if ($srcfile =~ m/^(\\d+)/)
{
if ($1 >= $first_rev && $1 <= $last_rev)
{
print "-- adding $srcfile\\n";
open(FIN, "<$srcfile");
print FOUT "-- [ $srcfile ] --\\n";
print FOUT <FIN>;
close(FIN);
print FOUT "\\n";
}
}
}
close(FOUT);
print "\\n";
}
my $rev_interval = "$first_rev-$last_rev";
&generate("mangos_WORLD_$rev_interval.sql", glob "*_mangos_*.sql");
&generate("mangos_CHAR_$rev_interval.sql", glob "*_characters_*.sql");
&generate("mangos_REALM_$rev_interval.sql", glob "*_realmd_*.sql");