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; }