public static int Execute( List<string> args )
{
if ( args.Count != 3 ) {
Console.WriteLine( "Usage: TO8CHTX_GraceNote ChatFilename NewDBFilename GracesJapanese" );
return -1;
}
String Filename = args[0];
String NewDB = args[1];
String GracesDB = args[2];
ChatFile c = new ChatFile( System.IO.File.ReadAllBytes( Filename ) );
System.IO.File.WriteAllBytes( NewDB, Properties.Resources.gndb_template );
List<GraceNoteDatabaseEntry> Entries = new List<GraceNoteDatabaseEntry>( c.Lines.Length * 2 );
foreach ( ChatFileLine Line in c.Lines ) {
String EnglishText;
int EnglishStatus;
if ( Line.SENG == "Dummy" || Line.SENG == "" ) {
EnglishText = Line.SJPN;
EnglishStatus = 0;
} else {
EnglishText = Line.SENG;
EnglishStatus = 1;
}
Entries.Add( new GraceNoteDatabaseEntry( Line.SName, Line.SName, "", 1, Line.Location, "", 0 ) );
Entries.Add( new GraceNoteDatabaseEntry( Line.SJPN, EnglishText, "", EnglishStatus, Line.Location + 4, "", 0 ) );
}
GraceNoteDatabaseEntry.InsertSQL( Entries.ToArray(), "Data Source=" + NewDB, "Data Source=" + GracesDB );
return 0;
}
public static int Execute( List<string> args )
{
String Filename;
String Database;
String NewFilename;
if ( args.Count != 3 ) {
Console.WriteLine( "Usage: GraceNote_TO8CHTX ChatFilename DBFilename NewChatFilename" );
return -1;
} else {
Filename = args[0];
Database = args[1];
NewFilename = args[2];
}
/*
Filename = @"c:\#gracenote_chat_repack\oldchat\VC002J";
Database = @"c:\#gracenote_chat_repack\db\VC002J";
NewFilename = @"c:\#gracenote_chat_repack\newchat\VC002J";
//*/
ChatFile c = new ChatFile( System.IO.File.ReadAllBytes( Filename ) );
c.GetSQL( "Data Source=" + Database );
c.RecalculatePointers();
System.IO.File.WriteAllBytes( NewFilename, c.Serialize() );
return 0;
}
