//public void GeneratePackage(object sender, DoWorkEventArgs e) public string GeneratePackage(string ID) { string dlcSavePath = ""; var cmd = "SELECT * FROM Main "; //if (rbtn_Population_Selected.Checked == true) cmd += "WHERE ID = " + ID + ""; //else if (rbtn_Population_All.Checked) ; //else if (rbtn_Population_Groups.Checked) cmd += "WHERE Groups = " + cbx_Groups.SelectedText; //cmd += " ORDER BY Artist"; //Read from DB var norows = 0; norows = SQLAccess(cmd); //bcapirtxt_StatisticsOnReadDLCs.Text = "Processing &Repackaging for " + norows + " " + cmd + "\n \n" + rtxt_StatisticsOnReadDLCs.Text; var i = 0; var artist = ""; //var cmd = ""; //rtxt_StatisticsOnReadDLCs.Text = "Repack backgroundworker.."+ norows + rtxt_StatisticsOnReadDLCs.Text; foreach (var file in files) { if (i > 0) //ONLY 1 FILE WILL BE READ break; i++; //bcapirtxt_StatisticsOnReadDLCs.Text = "...Pack" + i + " " + file.Artist + " " + file.Song_Title + "\n" + rtxt_StatisticsOnReadDLCs.Text;// UNPACK //if (file.Is_Broken != "Yes" || (file.Is_Broken == "Yes" && !chbx_Broken.Checked)) //"8. Don't repack Broken songs") //{ //var unpackedDir = Packer.Unpack(FullPath, Temp_Path_Import, true, true, false); //MessageBox.Show(file.Artist+file.Song_Title); var packagePlatform = file.Folder_Name.GetPlatform(); // REORGANIZE //rtxt_StatisticsOnReadDLCs.Text = "...0.1.." + file.Folder_Name + "\n" + rtxt_StatisticsOnReadDLCs.Text; var structured = ConfigRepository.Instance().GetBoolean("creator_structured"); //if (structured) //file.Folder_Name = DLCPackageData.DoLikeProject(file.Folder_Name); // LOAD DATA //rtxt_StatisticsOnReadDLCs.Text = "...0.5.." + file.Folder_Name + "\n" + rtxt_StatisticsOnReadDLCs.Text; var info = DLCPackageData.LoadFromFolder(file.Folder_Name, packagePlatform); //rtxt_StatisticsOnReadDLCs.Text = "...1.."+ file.Folder_Name + "\n" + rtxt_StatisticsOnReadDLCs.Text; var bassRemoved = "No"; var DDAdded = "No"; var xmlFiles = Directory.GetFiles(file.Folder_Name, "*.xml", SearchOption.AllDirectories); var platform = file.Folder_Name.GetPlatform(); //if (chbx_Additional_Manipualtions.GetItemChecked(3) || chbx_Additional_Manipualtions.GetItemChecked(5) || chbx_Additional_Manipualtions.GetItemChecked(12) || chbx_Additional_Manipualtions.GetItemChecked(26)) //{ // foreach (var xml in xmlFiles) // { // if (chbx_Additional_Manipualtions.GetItemChecked(12) || chbx_Additional_Manipualtions.GetItemChecked(26)) // //ADD DD // if ( // (//chbx_Additional_Manipualtions.GetItemChecked(12) // false && !Path.GetFileNameWithoutExtension(xml).ToLower().Contains(".old") // && ((Path.GetFileNameWithoutExtension(xml).ToLower().Contains("lead") || Path.GetFileNameWithoutExtension(xml).ToLower().Contains("combo") || Path.GetFileNameWithoutExtension(xml).ToLower().Contains("rthythm")) && file.Has_DD == "No") || (Path.GetFileNameWithoutExtension(xml).ToLower().Contains("bass") && file.Has_BassDD == "No") // ) // || //chbx_Additional_Manipualtions.GetItemChecked(26) // (false && (Path.GetFileNameWithoutExtension(xml).ToLower().Contains("lead") || Path.GetFileNameWithoutExtension(xml).ToLower().Contains("combo") || Path.GetFileNameWithoutExtension(xml).ToLower().Contains("rthythm")) // && file.Has_DD == "No" && file.Has_Guitar == "Yes" && !Path.GetFileNameWithoutExtension(xml).ToLower().Contains(".old") // ) // ) // { // File.Copy(xml, xml + ".old", true); // string json = ""; // if (chbx_Additional_Manipualtions.GetItemChecked(36)) //37. Keep the Uncompressed Songs superorganized // json = xml.Replace("EOF", "Toolkit").Replace(".xml", ".json"); // else // json = (xml.Replace(".xml", ".json").Replace("\\songs\\arr\\", calc_path(Directory.GetFiles(file.Folder_Name, "*.json", SearchOption.AllDirectories)[0]))); // File.Copy(json, json + ".old", true); // //bcapirtxt_StatisticsOnReadDLCs.Text = chbx_Additional_Manipualtions.GetItemChecked(12).ToString()+ chbx_Additional_Manipualtions.GetItemChecked(26).ToString()+"...." + Path.GetFileNameWithoutExtension(xml) + "...Adding DD using DDC tool" + "\n" + rtxt_StatisticsOnReadDLCs.Text; // var startInfo = new ProcessStartInfo(); // var r = String.Format(" -m \"{0}\"", Path.GetFullPath("ddc\\ddc_5_max_levels.xml")); // var c = String.Format(" -c \"{0}\"", Path.GetFullPath("ddc\\ddc_keep_all_levels.xml")); // startInfo.FileName = Path.Combine(AppWD, "ddc", "ddc.exe"); // if (chbx_Additional_Manipualtions.GetItemChecked(36)) //37. Keep the Uncompressed Songs superorganized // startInfo.WorkingDirectory = file.Folder_Name + "\\EOF\\";// Path.GetDirectoryName(); // else // startInfo.WorkingDirectory = file.Folder_Name + "\\songs\\arr\\";// Path.GetDirectoryName(); // startInfo.Arguments = String.Format("\"{0}\" -l {1} -s {2}{3}{4}{5}", // Path.GetFileName(xml), // 2, "N", r, c, // " -p Y", " -t N"); // //rtxt_StatisticsOnReadDLCs.Text = "working dir: "+ startInfo.WorkingDirectory + "...\n--"+startInfo.FileName+"..." +startInfo.Arguments + "\n\n" + rtxt_StatisticsOnReadDLCs.Text; // startInfo.UseShellExecute = false; // startInfo.CreateNoWindow = true; // startInfo.RedirectStandardOutput = true; // startInfo.RedirectStandardError = true; // using (var DDC = new Process()) // { // // rtxt_StatisticsOnReadDLCs.Text = "...1" + "\n" + rtxt_StatisticsOnReadDLCs.Text; // DDC.StartInfo = startInfo; // DDC.Start(); // //consoleOutput = DDC.StandardOutput.ReadToEnd(); // //consoleOutput += DDC.StandardError.ReadToEnd(); // DDC.WaitForExit(1000 * 60 * 5); //wait 15 minutes // // if (DDC.ExitCode > 0 ) rtxt_StatisticsOnReadDLCs.Text = "Issues when adding DD !" + "\n" + rtxt_StatisticsOnReadDLCs.Text; // DDAdded = "Yes"; rtxt_StatisticsOnReadDLCs.Text = "DDAdded: " + DDAdded + "\n" + rtxt_StatisticsOnReadDLCs.Text; // file.Has_BassDD = "Yes"; // } //} //REMOVE DD //rtxt_StatisticsOnReadDLCs.Text = "...=.." + xml + "\n\n" + rtxt_StatisticsOnReadDLCs.Text; // if ((Path.GetFileNameWithoutExtension(xml).ToLower().Contains("bass") && file.Has_BassDD == "Yes" && !Path.GetFileNameWithoutExtension(xml).ToLower().Contains(".old") && chbx_Additional_Manipualtions.GetItemChecked(5)) // || ((Path.GetFileNameWithoutExtension(xml).ToLower().Contains("lead") || Path.GetFileNameWithoutExtension(xml).ToLower().Contains("combo") || Path.GetFileNameWithoutExtension(xml).ToLower().Contains("rthythm")) // && file.Has_Guitar == "Yes" && !Path.GetFileNameWithoutExtension(xml).ToLower().Contains(".old") && chbx_Additional_Manipualtions.GetItemChecked(3))) // // continue; // { // if (chbx_Additional_Manipualtions.GetItemChecked(5) && !chbx_Additional_Manipualtions.GetItemChecked(3) && !Path.GetFileNameWithoutExtension(xml).ToLower().Contains("bass")) continue; // bassRemoved = (RemoveDD(file.Folder_Name, file.Is_Original, xml, platform) == "Yes") ? "No" : "Yes"; // file.Has_BassDD = (bassRemoved == "Yes") ? "No" : "Yes"; // } // //rtxt_StatisticsOnReadDLCs.Text = "...°.." + xmlFiles.Length + "\n" + rtxt_StatisticsOnReadDLCs.Text; // } //} ////rtxt_StatisticsOnReadDLCs.Text = "ooooo" + "\n" + rtxt_StatisticsOnReadDLCs.Text; //if (chbx_Additional_Manipualtions.GetItemChecked(17)) //18.Repack with Artist/ Title same as Artist / Title Sort //{ // file.Artist_Sort = file.Artist; // file.Song_Title_Sort = file.Song_Title; //} ////rtxt_StatisticsOnReadDLCs.Text = "ggggoo" + "\n" + rtxt_StatisticsOnReadDLCs.Text; //if (chbx_Additional_Manipualtions.GetItemChecked(23) && file.Artist_Sort.Length > 4) //24.Pack with The/ Die only at the end of Title Sort //{ // //rtxt_StatisticsOnReadDLCs.Text = "1eeeeeeoo" + "\n" + rtxt_StatisticsOnReadDLCs.Text; // if (chbx_Additional_Manipualtions.GetItemChecked(21) && file.Song_Title_Sort.Length > 4) // { // //rtxt_StatisticsOnReadDLCs.Text = "2eeeeeeoo" + "\n" + rtxt_StatisticsOnReadDLCs.Text; // file.Song_Title_Sort = (file.Song_Title_Sort.Substring(0, 4) == "The " ? file.Song_Title_Sort.Substring(4, file.Song_Title_Sort.Length - 4) + ",The" : file.Song_Title_Sort); // file.Song_Title_Sort = (file.Song_Title_Sort.Substring(0, 4) == "Die " ? file.Song_Title_Sort.Substring(4, file.Song_Title_Sort.Length - 4) + ",Die" : file.Song_Title_Sort); // file.Song_Title_Sort = (file.Song_Title_Sort.Substring(0, 4) == "the " ? file.Song_Title_Sort.Substring(4, file.Song_Title_Sort.Length - 4) + ",The" : file.Song_Title_Sort); // file.Song_Title_Sort = (file.Song_Title_Sort.Substring(0, 4) == "die " ? file.Song_Title_Sort.Substring(4, file.Song_Title_Sort.Length - 4) + ",Die" : file.Song_Title_Sort); // file.Song_Title_Sort = (file.Song_Title_Sort.Substring(0, 4) == "THE " ? file.Song_Title_Sort.Substring(4, file.Song_Title_Sort.Length - 4) + ",The" : file.Song_Title_Sort); // file.Song_Title_Sort = (file.Song_Title_Sort.Substring(0, 4) == "DIE " ? file.Song_Title_Sort.Substring(4, file.Song_Title_Sort.Length - 4) + ",Die" : file.Song_Title_Sort); // } // //rtxt_StatisticsOnReadDLCs.Text = file.Artist_Sort + "\n" + rtxt_StatisticsOnReadDLCs.Text; // file.Artist_Sort = (file.Artist_Sort.Substring(0, 4) == "The " ? file.Artist_Sort.Substring(4, file.Artist_Sort.Length - 4) + ",The" : file.Artist_Sort); // file.Artist_Sort = (file.Artist_Sort.Substring(0, 4) == "Die " ? file.Artist_Sort.Substring(4, file.Artist_Sort.Length - 4) + ",Die" : file.Artist_Sort); // file.Artist_Sort = (file.Artist_Sort.Substring(0, 4) == "the " ? file.Artist_Sort.Substring(4, file.Artist_Sort.Length - 4) + ",The" : file.Artist_Sort); // file.Artist_Sort = (file.Artist_Sort.Substring(0, 4) == "die " ? file.Artist_Sort.Substring(4, file.Artist_Sort.Length - 4) + ",Die" : file.Artist_Sort); // file.Artist_Sort = (file.Artist_Sort.Substring(0, 4) == "THE " ? file.Artist_Sort.Substring(4, file.Artist_Sort.Length - 4) + ",The" : file.Artist_Sort); // file.Artist_Sort = (file.Artist_Sort.Substring(0, 4) == "DIE " ? file.Artist_Sort.Substring(4, file.Artist_Sort.Length - 4) + ",Die" : file.Artist_Sort); //} //rtxt_StatisticsOnReadDLCs.Text = "4eeeeeeoo" + "\n" + rtxt_StatisticsOnReadDLCs.Text; //data = new DLCPackageData //{ // GameVersion = RocksmithToolkitLib.GameVersion.RS2014, // Pc = cbx_Format.Text == "PC" ? true : false, // Mac = cbx_Format.Text == "Mac" ? true : false, // XBox360 = cbx_Format.Text == "XBOX360" ? true : false, // PS3 = cbx_Format.Text == "PS3" ? true : false, // Name = txt_DLC_ID.Text, // AppId = txt_APP_ID.Text, // //USEFUL CMDs String.IsNullOrEmpty( // SongInfo = new RocksmithToolkitLib.DLCPackage.SongInfo // { // SongDisplayName = txt_Title.Text, // SongDisplayNameSort = txt_Title_Sort.Text, // Album = txt_Album.Text, // SongYear = txt_Album_Year.Text.ToInt32(), // Artist = txt_Artist.Text, // ArtistSort = txt_Artist_Sort.Text, // AverageTempo = txt_AverageTempo.Text.ToInt32() // }, // AlbumArtPath = txt_AlbumArtPath.Text, // OggPath = txt_AudioPath.Text, // OggPreviewPath = ((txt_AudioPath.Text != "") ? txt_AudioPath.Text : txt_AudioPath.Text), // Arrangements = info.Arrangements, //Not yet done // Tones = info.Tones,//Not yet done // TonesRS2014 = info.TonesRS2014,//Not yet done // Volume = txt_Volume.Text.ToInt32(), // PreviewVolume = txt_Preview_Volume.Text.ToInt32(), // SignatureType = txt_SignatureType.Text, // PackageVersion = txt_Version.Text //}; data = new DLCPackageData { GameVersion = GameVersion.RS2014, Pc = chbx_Format.Text == "PC" ? true : false, //txt_Platform.Text Mac = chbx_Format.Text == "Mac" ? true : false, XBox360 = chbx_Format.Text == "XBOX360" ? true : false, PS3 = chbx_Format.Text == "PS3" ? true : false, Name = file.DLC_Name, AppId = file.DLC_AppID, ArtFiles = info.ArtFiles, //USEFUL CMDs String.IsNullOrEmpty( SongInfo = new RocksmithToolkitLib.DLCPackage.SongInfo { SongDisplayName = file.Song_Title, SongDisplayNameSort = file.Song_Title_Sort, Album = file.Album, SongYear = file.Album_Year.ToInt32(), Artist = file.Artist, ArtistSort = file.Artist_Sort, AverageTempo = file.AverageTempo.ToInt32() }, AlbumArtPath = file.AlbumArtPath, OggPath = file.AudioPath, OggPreviewPath = ((file.audioPreviewPath != "") ? file.audioPreviewPath : file.AudioPath), Arrangements = info.Arrangements, //Not yet done Tones = info.Tones,//Not yet done TonesRS2014 = info.TonesRS2014,//Not yet done Volume = file.Volume.ToInt32(), PreviewVolume = file.Preview_Volume.ToInt32(), SignatureType = info.SignatureType, PackageVersion = file.Version }; //get track no if (ConfigRepository.Instance()["dlcm_AdditionalManipul48"] == "Yes") { var CleanTitle = ""; if (txt_Title.Text.IndexOf("[") > 0) CleanTitle = txt_Title.Text.Substring(0, txt_Title.Text.IndexOf("[")); if (txt_Title.Text.IndexOf("]") > 0) CleanTitle += txt_Title.Text.Substring(txt_Title.Text.IndexOf("]"), txt_Title.Text.Length - txt_Title.Text.IndexOf("]")); else if (txt_Title.Text.IndexOf("[") == 0 || txt_Title.Text.Substring(0, 1) != "[") CleanTitle = txt_Title.Text; string z = (GetTrackNo(txt_Artist.Text, txt_Album.Text, CleanTitle)).ToString(); txt_Track_No.Text = z == "0" && txt_Track_No.Text != "" ? txt_Track_No.Text : z; } if (file.Author == "Custom Song Creator" || file.Author == "" && ConfigRepository.Instance()["dlcm_AdditionalManipul47"] == "Yes") file.Author = "RepackedBy" + ConfigRepository.Instance()["general_defaultauthor"].ToUpper(); DirectoryInfo di; var repacked_Path = TempPath + "\\0_repacked"; if (!Directory.Exists(repacked_Path) && (repacked_Path != null)) di = Directory.CreateDirectory(repacked_Path); //bcapirtxt_StatisticsOnReadDLCs.Text = file.Song_Title+" test"+i+ data.SongInfo.Artist + "\n" + rtxt_StatisticsOnReadDLCs.Text; var norm_path = repacked_Path + "\\" + Manipulate_strings(ConfigRepository.Instance()["dlcm_File_Name"], 0, false, false); ;//((file.ToolkitVersion == "") ? "ORIG" : "CDLC") + "_" + data.SongInfo.Artist + "_" + data.SongInfo.SongYear + "_" + data.SongInfo.Album + "_" + data.SongInfo.SongDisplayName; //rtxt_StatisticsOnReadDLCs.Text = "8"+data.PackageVersion+"...manipul" + norm_path + "\n" + rtxt_StatisticsOnReadDLCs.Text; //manipulating the info //ConfigRepository.Instance()["dlcm_Title"] = txt_Title.Text; //ConfigRepository.Instance()["dlcm_Title_sort"] = txt_Title_Sort.Text; //ConfigRepository.Instance()["dlcm_Artist"] = txt_Artist.Text; //ConfigRepository.Instance()["dlcm_Artist_Sort"] = txt_Artist_Sort.Text; //ConfigRepository.Instance()["dlcm_Album"] = txt_Album.Text; //ConfigRepository.Instance()["dlcm_File_Name"] = txt_File_Name.Text; data.SongInfo.SongDisplayName = Manipulate_strings(ConfigRepository.Instance()["dlcm_Title"], 0, false, false); // rtxt_StatisticsOnReadDLCs.Text = "...manipul: "+ file.Song_Title + "\n" + rtxt_StatisticsOnReadDLCs.Text; //if (cbx_Activ_Title_Sort.Checked) data.SongInfo.SongDisplayNameSort = Manipulate_strings(ConfigRepository.Instance()["dlcm_Title_sort"], 0, false, false); //rtxt_StatisticsOnReadDLCs.Text = "...manipul" + "\n" + rtxt_StatisticsOnReadDLCs.Text; //if (cbx_Activ_Artist.Checked) data.SongInfo.Artist = Manipulate_strings(ConfigRepository.Instance()["dlcm_Artist"], 0, false, false); //rtxt_StatisticsOnReadDLCs.Text = "...manipul" + "\n" + rtxt_StatisticsOnReadDLCs.Text; //if (cbx_Activ_Artist_Sort.Checked) data.SongInfo.ArtistSort = Manipulate_strings(ConfigRepository.Instance()["dlcm_Artist_Sort"], 0, false, false); //rtxt_StatisticsOnReadDLCs.Text = "...manipul" + "\n" + rtxt_StatisticsOnReadDLCs.Text; //if (cbx_Activ_Album.Checked) data.SongInfo.Album = Manipulate_strings(ConfigRepository.Instance()["dlcm_Album"], 0, false, false); //rtxt_StatisticsOnReadDLCs.Text = "...3" + "\n" + rtxt_StatisticsOnReadDLCs.Text; //rtxt_StatisticsOnReadDLCs.Text = "...nipul" + "\n" + rtxt_StatisticsOnReadDLCs.Text; //if (chbx_Additional_Manipualtions.GetItemChecked(0)) //"1. Add Increment to all Titles" //data.Name = i + data.Name; //rtxt_StatisticsOnReadDLCs.Text = "...mpl" + "\n" + rtxt_StatisticsOnReadDLCs.Text; artist = ""; //if (chbx_Additional_Manipualtions.GetItemChecked(1)) //"2. Add Increment to all songs(&Separately per artist)" //{ // if (i > 0) // if (data.SongInfo.Artist == files[i - 1].Artist) no_ord += 1; // else no_ord = 1; // else no_ord += 1; // artist = no_ord + " "; // data.SongInfo.SongDisplayName = i + artist + data.SongInfo.SongDisplayName; //} //if (chbx_Additional_Manipualtions.GetItemChecked(7)) //"8. Don't repack Broken songs" // if (file.Is_Broken == "Yes") break; //rtxt_StatisticsOnReadDLCs.Text = "...4" + "\n" + rtxt_StatisticsOnReadDLCs.Text; //rtxt_StatisticsOnReadDLCs.Text = "...manipl" + "\n" + rtxt_StatisticsOnReadDLCs.Text; //if (chbx_Additional_Manipualtions.GetItemChecked(2)) //"3. Make all DLC IDs unique (&save)" if (chbx_UniqueID.Checked) if (file.UniqueDLCName != "") data.Name = file.UniqueDLCName; else { Random random = new Random(); data.Name = random.Next(0, 100000) + data.Name; var k = DataViewGrid.SelectedCells[0].RowIndex; DataViewGrid.Rows[k].Cells[79].Value = data.Name; //var DB_Path = DBFolder + "\\Files.accdb;"; using (OleDbConnection cnn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + DB_Path)) { DataSet dis = new DataSet(); cmd = "UPDATE Main SET UniqueDLCName=\"" + data.Name + "\" WHERE ID=" + file.ID; OleDbDataAdapter das = new OleDbDataAdapter(cmd, cnn); das.Fill(dis, "Main"); das.Dispose(); } } //Fix the _preview_preview issue var ms = data.OggPath; //var audiopath = ""; var audioprevpath = ""; var tst = ""; //MessageBox.Show("One or more"); //rtxt_StatisticsOnReadDLCs.Text = "maybe fixing .."+ file.Folder_Name+"\n"+ norm_path + "\n"+ rtxt_StatisticsOnReadDLCs.Text; try { var sourceAudioFiles = Directory.GetFiles(file.Folder_Name, "*.wem", SearchOption.AllDirectories); //if (sourceAudioFiles.Length>0) //var targetAudioFiles = new List<string>(); foreach (var fil in sourceAudioFiles) { tst = fil; //MessageBox.Show("test2.02 " + fil); //rtxt_StatisticsOnReadDLCs.Text = "thinking about fixing _preview_preview issue.." + norm_path +"-"+tst+ "\n"+rtxt_StatisticsOnReadDLCs.Text; if (fil.LastIndexOf("_preview_preview.wem") > 0) { ms = fil.Substring(0, fil.LastIndexOf("_preview_preview.wem")); File.Move((ms + "_preview.wem"), (ms + ".wem")); File.Move((ms + "_preview_preview.wem"), (ms + "_preview.wem")); //bcapirtxt_StatisticsOnReadDLCs.Text = "fixing _preview_preview issue..." + rtxt_StatisticsOnReadDLCs.Text; } } } catch (Exception ee) { //bcapirtxt_StatisticsOnReadDLCs.Text = "FAILED6-" + ee.Message + tst + "\n" + rtxt_StatisticsOnReadDLCs.Text; Console.WriteLine(ee.Message); } if (data == null) { MessageBox.Show("One or more fields are missing information.", MESSAGEBOX_CAPTION, MessageBoxButtons.OK, MessageBoxIcon.Error); //return; } //rtxt_StatisticsOnReadDLCs.Text = "...5" + "\n" + rtxt_StatisticsOnReadDLCs.Text; //dlcSavePath = ds.Tables[0].Rows[i].ItemArray[1].ToString() + "\\";// + ((info.PackageVersion == null) ? "Original" : "CDLC") + "-" + info.SongInfo.SongYear +".psarc"; //var dlcSavePath = GeneralExtensions.GetShortName("{0}_{1}_v{2}", (((file.Version == null) ? "Original" : "CDLC") + "_" + info.SongInfo.SongDisplayName), (info.SongInfo.SongDisplayName + "_" + info.SongInfo.Album + "_" + info.SongInfo.SongYear), info.PackageVersion, ConfigRepository.Instance().GetBoolean("creator_useacronyms")); var FN = ""; //bcapirtxt_StatisticsOnReadDLCs.Text = file.Song_Title+ "\n" + rtxt_StatisticsOnReadDLCs.Text; //if (cbx_Activ_File_Name.Checked) FN = Manipulate_strings(txt_File_Name.Text, i, true, false); //else FN = GeneralExtensions.GetShortName("{0}-{1}-v{2}", (((file.Version == null) ? "ORIG" : "CDLC") + "_" + file.Artist), (file.Album_Year.ToInt32() + "_" + file.Album + "_" + file.Song_Title), file.Version, ConfigRepository.Instance().GetBoolean("creator_useacronyms"));//((data.PackageVersion == null) ? "Original" : "CDLC") + "_" + data.SongInfo.Artist + "_" + data.SongInfo.SongYear + "_" + data.SongInfo.Album + "_" + data.SongInfo.SongDisplayName; if (file.Is_Alternate == "Yes") FN += "a." + file.Alternate_Version_No + file.Author; //rtxt_StatisticsOnReadDLCs.Text = "fn: " + FN + "\n" + rtxt_StatisticsOnReadDLCs.Text; if (chbx_Format.Text == "PS3") { FN = FN.Replace(".", "_"); FN = FN.Replace(" ", "_"); } dlcSavePath = TempPath + "\\" + FN; //rtxt_StatisticsOnReadDLCs.Text = "rez : " + dlcSavePath + "\n" + rtxt_StatisticsOnReadDLCs.Text; //if (GameVersion.RS2014 == GameVersion.RS2012) //old code //{ // try // { // OggFile.VerifyHeaders(data.OggPath); // } // catch (InvalidDataException ex) // { // MessageBox.Show(ex.Message, MESSAGEBOX_CAPTION, MessageBoxButtons.OK, MessageBoxIcon.Error); // return; // } //} //rtxt_StatisticsOnReadDLCs.Text = "genf : " + "\n" + rtxt_StatisticsOnReadDLCs.Text; int progress = 0; var errorsFound = new StringBuilder(); var numPlatforms = 0; //if (platformPC.Checked) numPlatforms++; //if (chbx_Format=="Mac") // numPlatforms++; //if (chbx_XBOX360.Checked) // numPlatforms++; //if (chbx_PS3.Checked) // numPlatforms++; var step = (int)Math.Round(1.0 / numPlatforms * 100, 0); // rtxt_StatisticsOnReadDLCs.Text = "...6" + "\n" + rtxt_StatisticsOnReadDLCs.Text; if (chbx_Format.Text == "PC") try { //bwRGenerate.ReportProgress(progress, "Generating PC package"); //bcapirtxt_StatisticsOnReadDLCs.Text = "1pc..." + rtxt_StatisticsOnReadDLCs.Text; RocksmithToolkitLib.DLCPackage.DLCPackageCreator.Generate(dlcSavePath, data, new Platform(GamePlatform.Pc, GameVersion.RS2014)); //bcapirtxt_StatisticsOnReadDLCs.Text = "2pc..." + rtxt_StatisticsOnReadDLCs.Text; progress += step; //bwRGenerate.ReportProgress(progress); //bcapirtxt_StatisticsOnReadDLCs.Text = "3pc..." + rtxt_StatisticsOnReadDLCs.Text; } catch (Exception ex) { errorsFound.AppendLine(String.Format("Error 0 generate PC package: {0}{1}{0}{2}{0}", Environment.NewLine, ex.Message, ex.StackTrace)); //bcapirtxt_StatisticsOnReadDLCs.Text = "...0pc ERROR..." + ex.Message + rtxt_StatisticsOnReadDLCs.Text; } if (chbx_Format.Text == "Mac") try { //bwRGenerate.ReportProgress(progress, "Generating Mac package"); RocksmithToolkitLib.DLCPackage.DLCPackageCreator.Generate(dlcSavePath, data, new Platform(GamePlatform.Mac, GameVersion.RS2014)); progress += step; //bwRGenerate.ReportProgress(progress); } catch (Exception ex) { errorsFound.AppendLine(String.Format("Error 1 generate Mac package: {0}{1}{0}{2}{0}", Environment.NewLine, ex.Message, ex.StackTrace)); //bcapirtxt_StatisticsOnReadDLCs.Text = "...0mac ERROR..." + ex.Message + rtxt_StatisticsOnReadDLCs.Text; } if (chbx_Format.Text == "XBOX360") try { //bwRGenerate.ReportProgress(progress, "Generating XBox 360 package"); RocksmithToolkitLib.DLCPackage.DLCPackageCreator.Generate(dlcSavePath, data, new Platform(GamePlatform.XBox360, GameVersion.RS2014)); progress += step; //bwRGenerate.ReportProgress(progress); } catch (Exception ex) { errorsFound.AppendLine(String.Format("Error generate XBox 360 package: {0}{1}{0}{2}{0}", Environment.NewLine, ex.Message, ex.StackTrace)); //bcapirtxt_StatisticsOnReadDLCs.Text = "...0mac ERROR..." + ex.Message + rtxt_StatisticsOnReadDLCs.Text; } if (chbx_Format.Text == "PS3") try { //rtxt_StatisticsOnReadDLCs.Text = "ps3...start..." + rtxt_StatisticsOnReadDLCs.Text; //bwRGenerate.ReportProgress(progress, "Generating PS3 package"); //rtxt_StatisticsOnReadDLCs.Text = dlcSavePath + rtxt_StatisticsOnReadDLCs.Text; string dds = dlcSavePath;// + ".psarc.edat"; RocksmithToolkitLib.DLCPackage.DLCPackageCreator.Generate(dds, data, new Platform(GamePlatform.PS3, GameVersion.RS2014)); //progress += step; //bwRGenerate.ReportProgress(progress); // rtxt_StatisticsOnReadDLCs.Text = "ps3...off..." + rtxt_StatisticsOnReadDLCs.Text; } catch (Exception ex) { string ss = String.Format("Error 2generate PS3 package: {0}{1}. {0}PS3 package require 'JAVA x86' (32 bits) installed on your machine to generate properly.{0}", Environment.NewLine, ex.StackTrace); MessageBox.Show(ss); errorsFound.AppendLine(ss); //bcapirtxt_StatisticsOnReadDLCs.Text = "...0Ps3 ERROR..."+ dlcSavePath+"---"+ dlcSavePath.Length+ "----" + ex.Message + rtxt_StatisticsOnReadDLCs.Text; } data.CleanCache(); //rtxt_StatisticsOnReadDLCs.Text = "gen2 : " + "\n" + rtxt_StatisticsOnReadDLCs.Text; i++; //rtxt_StatisticsOnReadDLCs.Text = "gen r: " + "\n" + rtxt_StatisticsOnReadDLCs.Text; //TO DO DELETE the ORIGINAL IMPORTED FILES or not //bcapirtxt_StatisticsOnReadDLCs.Text = "\nRepack bkworkerdone.." + i + rtxt_StatisticsOnReadDLCs.Text; //} //MessageBox.Show("tst"); } //bcapirtxt_StatisticsOnReadDLCs.Text = "\n...Repack done.." + rtxt_StatisticsOnReadDLCs.Text; return dlcSavePath; MessageBox.Show("Repack done"); }
public void GeneratePackage(object sender, DoWorkEventArgs e) { var cmd = "SELECT * FROM Main "; if (rbtn_Population_Selected.Checked == true) cmd += "WHERE Selected = \"Yes\""; //else if (rbtn_Population_All.Checked) ; else if (rbtn_Population_Groups.Checked) cmd += "WHERE Groups = \"" + Groupss + "\""; cmd += " ORDER BY Artist"; //Read from DB var norows = 0; norows = SQLAccess(cmd); //bcapirtxt_StatisticsOnReadDLCs.Text = "Processing &Repackaging for " + norows + " " + cmd + "\n \n" + rtxt_StatisticsOnReadDLCs.Text; var i = 0; var artist = ""; //var cmd = ""; //rtxt_StatisticsOnReadDLCs.Text = "Repack backgroundworker.."+ norows + rtxt_StatisticsOnReadDLCs.Text; foreach (var file in files) { if (i == norows) break; //bcapirtxt_StatisticsOnReadDLCs.Text = "...Pack" + i + " " + file.Artist + " " + file.Song_Title + "\n" + rtxt_StatisticsOnReadDLCs.Text;// UNPACK if (file.Is_Broken != "Yes" || (file.Is_Broken == "Yes" && !chbx_Additional_Manipulations.GetItemChecked(7))) //"8. Don't repack Broken songs") { //var unpackedDir = Packer.Unpack(FullPath, Temp_Path_Import, true, true, false); //MessageBox.Show(file.Artist+file.Song_Title); var packagePlatform = file.Folder_Name.GetPlatform(); // REORGANIZE //rtxt_StatisticsOnReadDLCs.Text = "...0.1.." + file.Folder_Name + "\n" + rtxt_StatisticsOnReadDLCs.Text; var structured = ConfigRepository.Instance().GetBoolean("creator_structured"); //if (structured) //file.Folder_Name = DLCPackageData.DoLikeProject(file.Folder_Name); // LOAD DATA //rtxt_StatisticsOnReadDLCs.Text = "...0.5.." + file.Folder_Name + "\n" + rtxt_StatisticsOnReadDLCs.Text; info = DLCPackageData.LoadFromFolder(file.Folder_Name, packagePlatform); //rtxt_StatisticsOnReadDLCs.Text = "...1.."+ file.Folder_Name + "\n" + rtxt_StatisticsOnReadDLCs.Text; var bassRemoved = "No"; var DDAdded = "No"; var xmlFiles = Directory.GetFiles(file.Folder_Name, "*.xml", SearchOption.AllDirectories); var platform = file.Folder_Name.GetPlatform(); if (chbx_Additional_Manipulations.GetItemChecked(3) || chbx_Additional_Manipulations.GetItemChecked(5) || chbx_Additional_Manipulations.GetItemChecked(12) || chbx_Additional_Manipulations.GetItemChecked(26)) { foreach (var xml in xmlFiles) { if (chbx_Additional_Manipulations.GetItemChecked(12) || chbx_Additional_Manipulations.GetItemChecked(26)) //ADD DD if ( (//chbx_Additional_Manipualtions.GetItemChecked(12) false && !Path.GetFileNameWithoutExtension(xml).ToLower().Contains(".old") && ((Path.GetFileNameWithoutExtension(xml).ToLower().Contains("lead") || Path.GetFileNameWithoutExtension(xml).ToLower().Contains("combo") || Path.GetFileNameWithoutExtension(xml).ToLower().Contains("rthythm")) && file.Has_DD == "No") || (Path.GetFileNameWithoutExtension(xml).ToLower().Contains("bass") && file.Has_BassDD == "No") ) || //chbx_Additional_Manipualtions.GetItemChecked(26) (false && (Path.GetFileNameWithoutExtension(xml).ToLower().Contains("lead") || Path.GetFileNameWithoutExtension(xml).ToLower().Contains("combo") || Path.GetFileNameWithoutExtension(xml).ToLower().Contains("rthythm")) && file.Has_DD == "No" && file.Has_Guitar == "Yes" && !Path.GetFileNameWithoutExtension(xml).ToLower().Contains(".old") ) ) { DDAdded = (AddDD(file.Folder_Name, file.Is_Original, xml, platform, chbx_Additional_Manipulations.GetItemChecked(36), chbx_Additional_Manipulations.GetItemChecked(31), "5") == "Yes") ? "No" : "Yes"; file.Has_BassDD = (DDAdded == "Yes") ? "Yes" : "No"; } //REMOVE DD //rtxt_StatisticsOnReadDLCs.Text = "...=.." + xml + "\n\n" + rtxt_StatisticsOnReadDLCs.Text; if ((Path.GetFileNameWithoutExtension(xml).ToLower().Contains("bass") && file.Has_BassDD == "Yes" && !Path.GetFileNameWithoutExtension(xml).ToLower().Contains(".old") && chbx_Additional_Manipulations.GetItemChecked(5)) || ((Path.GetFileNameWithoutExtension(xml).ToLower().Contains("lead") || Path.GetFileNameWithoutExtension(xml).ToLower().Contains("combo") || Path.GetFileNameWithoutExtension(xml).ToLower().Contains("rthythm")) && file.Has_Guitar == "Yes" && !Path.GetFileNameWithoutExtension(xml).ToLower().Contains(".old") && chbx_Additional_Manipulations.GetItemChecked(3))) // continue; { if (chbx_Additional_Manipulations.GetItemChecked(5) && !chbx_Additional_Manipulations.GetItemChecked(3) && !Path.GetFileNameWithoutExtension(xml).ToLower().Contains("bass")) continue; bassRemoved = (RemoveDD(file.Folder_Name, file.Is_Original, xml, platform, chbx_Additional_Manipulations.GetItemChecked(36), chbx_Additional_Manipulations.GetItemChecked(31)) == "Yes") ? "No" : "Yes"; file.Has_BassDD = (bassRemoved == "Yes") ? "No" : "Yes"; } //rtxt_StatisticsOnReadDLCs.Text = "...°.." + xmlFiles.Length + "\n" + rtxt_StatisticsOnReadDLCs.Text; } } //Default APP ID if (chbx_Additional_Manipulations.GetItemChecked(43)) file.DLC_AppID = ConfigRepository.Instance()["general_defaultappid_RS2014"]; //get track no if (ConfigRepository.Instance()["dlcm_AdditionalManipul48"] == "Yes") { var CleanTitle = ""; if (txt_Title.Text.IndexOf("[") > 0) CleanTitle = txt_Title.Text.Substring(0, txt_Title.Text.IndexOf("[")); if (txt_Title.Text.IndexOf("]") > 0) CleanTitle += txt_Title.Text.Substring(txt_Title.Text.IndexOf("]"), txt_Title.Text.Length - txt_Title.Text.IndexOf("]")); else if (txt_Title.Text.IndexOf("[") == 0 || txt_Title.Text.Substring(0, 1) != "[") CleanTitle = txt_Title.Text; string z = (MainDB.GetTrackNo(txt_Artist.Text, txt_Album.Text, CleanTitle)).ToString(); file.Track_No = z == "0" && file.Track_No != "" ? file.Track_No : z; } //Set Preview if (chbx_Additional_Manipulations.GetItemChecked(9) && (info.OggPreviewPath == null)) { rtxt_StatisticsOnReadDLCs.Text = "Trying to add preview as missing.\n" + rtxt_StatisticsOnReadDLCs.Text; var startInfo = new ProcessStartInfo(); startInfo.FileName = Path.Combine(AppWD, "oggcut.exe"); startInfo.WorkingDirectory = AppWD;// Path.GetDirectoryName(); var t = info.OggPath.Replace(".wem", "_fixed.ogg"); ;//"C:\\GitHub\\tmp\\0\\0_dlcpacks\\rs1compatibilitydisc_PS3\\audio\\ps3\\149627248.ogg";//txt_TempPath.Text + "\\0_dlcpacks\\rs1compatibilitydlc.psarc"; var tt = t.Replace(".ogg", "_preview.ogg"); var times = "00:30"; string[] timepieces = times.Split(':'); TimeSpan r = new TimeSpan(0, timepieces[0].ToInt32(), timepieces[1].ToInt32()); startInfo.Arguments = String.Format(" -i \"{0}\" -o \"{1}\" -s \"{2}\" -e \"{3}\"", t, tt, r.TotalMilliseconds, (r.TotalMilliseconds + (30 * 1000))); startInfo.UseShellExecute = true; startInfo.CreateNoWindow = true; //startInfo.RedirectStandardOutput = true; startInfo.RedirectStandardError = true; if (File.Exists(t)) using (var DDC = new Process()) { DDC.StartInfo = startInfo; DDC.Start(); DDC.WaitForExit(1000 * 60 * 1); //wait 1min if (DDC.ExitCode == 0) { file.oggPreviewPath = tt; MainDB.Converters(tt, MainDB.ConverterTypes.Ogg2Wem, false); file.audioPreviewPath = tt.Replace(".ogg", ".wem"); ; } } } //rtxt_StatisticsOnReadDLCs.Text = "ooooo" + "\n" + rtxt_StatisticsOnReadDLCs.Text; if (chbx_Additional_Manipulations.GetItemChecked(17)) //18.Repack with Artist/ Title same as Artist / Title Sort { file.Artist_Sort = file.Artist; file.Song_Title_Sort = file.Song_Title; } if (chbx_Additional_Manipulations.GetItemChecked(10)) { Random random = new Random(); string apppid = random.Next(0, 100000) + file.DLC_Name; file.DLC_Name = apppid; } //rtxt_StatisticsOnReadDLCs.Text = "ggggoo" + "\n" + rtxt_StatisticsOnReadDLCs.Text; if (chbx_Additional_Manipulations.GetItemChecked(23) && file.Artist_Sort.Length > 4) //24.Pack with The/ Die only at the end of Title Sort { //rtxt_StatisticsOnReadDLCs.Text = "1eeeeeeoo" + "\n" + rtxt_StatisticsOnReadDLCs.Text; if (chbx_Additional_Manipulations.GetItemChecked(21) && file.Song_Title_Sort.Length > 4) { //rtxt_StatisticsOnReadDLCs.Text = "2eeeeeeoo" + "\n" + rtxt_StatisticsOnReadDLCs.Text; file.Song_Title_Sort = (file.Song_Title_Sort.Substring(0, 4) == "The " ? file.Song_Title_Sort.Substring(4, file.Song_Title_Sort.Length - 4) + ",The" : file.Song_Title_Sort); file.Song_Title_Sort = (file.Song_Title_Sort.Substring(0, 4) == "Die " ? file.Song_Title_Sort.Substring(4, file.Song_Title_Sort.Length - 4) + ",Die" : file.Song_Title_Sort); file.Song_Title_Sort = (file.Song_Title_Sort.Substring(0, 4) == "the " ? file.Song_Title_Sort.Substring(4, file.Song_Title_Sort.Length - 4) + ",The" : file.Song_Title_Sort); file.Song_Title_Sort = (file.Song_Title_Sort.Substring(0, 4) == "die " ? file.Song_Title_Sort.Substring(4, file.Song_Title_Sort.Length - 4) + ",Die" : file.Song_Title_Sort); file.Song_Title_Sort = (file.Song_Title_Sort.Substring(0, 4) == "THE " ? file.Song_Title_Sort.Substring(4, file.Song_Title_Sort.Length - 4) + ",The" : file.Song_Title_Sort); file.Song_Title_Sort = (file.Song_Title_Sort.Substring(0, 4) == "DIE " ? file.Song_Title_Sort.Substring(4, file.Song_Title_Sort.Length - 4) + ",Die" : file.Song_Title_Sort); } //rtxt_StatisticsOnReadDLCs.Text = file.Artist_Sort + "\n" + rtxt_StatisticsOnReadDLCs.Text; file.Artist_Sort = (file.Artist_Sort.Substring(0, 4) == "The " ? file.Artist_Sort.Substring(4, file.Artist_Sort.Length - 4) + ",The" : file.Artist_Sort); file.Artist_Sort = (file.Artist_Sort.Substring(0, 4) == "Die " ? file.Artist_Sort.Substring(4, file.Artist_Sort.Length - 4) + ",Die" : file.Artist_Sort); file.Artist_Sort = (file.Artist_Sort.Substring(0, 4) == "the " ? file.Artist_Sort.Substring(4, file.Artist_Sort.Length - 4) + ",The" : file.Artist_Sort); file.Artist_Sort = (file.Artist_Sort.Substring(0, 4) == "die " ? file.Artist_Sort.Substring(4, file.Artist_Sort.Length - 4) + ",Die" : file.Artist_Sort); file.Artist_Sort = (file.Artist_Sort.Substring(0, 4) == "THE " ? file.Artist_Sort.Substring(4, file.Artist_Sort.Length - 4) + ",The" : file.Artist_Sort); file.Artist_Sort = (file.Artist_Sort.Substring(0, 4) == "DIE " ? file.Artist_Sort.Substring(4, file.Artist_Sort.Length - 4) + ",Die" : file.Artist_Sort); } //rtxt_StatisticsOnReadDLCs.Text = "4eeeeeeoo" + "\n" + rtxt_StatisticsOnReadDLCs.Text; var toolkitv = ""; if (chbx_Additional_Manipulations.GetItemChecked(47)) toolkitv = ToolkitVersion.version.ToString(); else toolkitv = file.Version; data = new DLCPackageData { GameVersion = GameVersion.RS2014, Pc = true, Mac = chbx_Mac.Checked, XBox360 = chbx_XBOX360.Checked, PS3 = chbx_PS3.Checked, Name = file.DLC_Name, AppId = file.DLC_AppID, ArtFiles = info.ArtFiles, //USEFUL CMDs String.IsNullOrEmpty( SongInfo = new RocksmithToolkitLib.DLCPackage.SongInfo { SongDisplayName = file.Song_Title, SongDisplayNameSort = file.Song_Title_Sort, Album = file.Album, SongYear = file.Album_Year.ToInt32(), Artist = file.Artist, ArtistSort = file.Artist_Sort, AverageTempo = file.AverageTempo.ToInt32() }, AlbumArtPath = file.AlbumArtPath, OggPath = file.AudioPath, OggPreviewPath = ((file.audioPreviewPath != "") ? file.audioPreviewPath : file.AudioPath), Arrangements = info.Arrangements, //Not yet done Tones = info.Tones,//Not yet done TonesRS2014 = info.TonesRS2014,//Not yet done Volume = file.Volume.ToInt32(), PreviewVolume = file.Preview_Volume.ToInt32(), SignatureType = info.SignatureType, PackageVersion = toolkitv//file.Version }; //bcapirtxt_StatisticsOnReadDLCs.Text = file.Song_Title+" test"+i+ data.SongInfo.Artist + "\n" + rtxt_StatisticsOnReadDLCs.Text; if (file.Author == "Custom Song Creator" || file.Author == "" && chbx_Additional_Manipulations.GetItemChecked(47)) file.Author = "RepackedBy" + ConfigRepository.Instance()["general_defaultauthor"].ToUpper(); var norm_path = txt_TempPath.Text + "\\0_repacked\\" + ((file.ToolkitVersion == "") ? "ORIG" : "CDLC") + "_" + data.SongInfo.Artist + "_" + data.SongInfo.SongYear + "_" + data.SongInfo.Album + "_" + data.SongInfo.SongDisplayName; //rtxt_StatisticsOnReadDLCs.Text = "8"+data.PackageVersion+"...manipul" + norm_path + "\n" + rtxt_StatisticsOnReadDLCs.Text; //manipulating the info if (cbx_Activ_Title.Checked) data.SongInfo.SongDisplayName = Manipulate_strings(txt_Title.Text, i, false, chbx_Additional_Manipulations.GetItemChecked(25)); // rtxt_StatisticsOnReadDLCs.Text = "...manipul: "+ file.Song_Title + "\n" + rtxt_StatisticsOnReadDLCs.Text; if (cbx_Activ_Title_Sort.Checked) data.SongInfo.SongDisplayNameSort = Manipulate_strings(txt_Title_Sort.Text, i, false, chbx_Additional_Manipulations.GetItemChecked(25)); //rtxt_StatisticsOnReadDLCs.Text = "...manipul" + "\n" + rtxt_StatisticsOnReadDLCs.Text; if (cbx_Activ_Artist.Checked) data.SongInfo.Artist = Manipulate_strings(txt_Artist.Text, i, false, chbx_Additional_Manipulations.GetItemChecked(25)); //rtxt_StatisticsOnReadDLCs.Text = "...manipul" + "\n" + rtxt_StatisticsOnReadDLCs.Text; if (cbx_Activ_Artist_Sort.Checked) data.SongInfo.ArtistSort = Manipulate_strings(txt_Artist_Sort.Text, i, false, chbx_Additional_Manipulations.GetItemChecked(25)); //rtxt_StatisticsOnReadDLCs.Text = "...manipul" + "\n" + rtxt_StatisticsOnReadDLCs.Text; if (cbx_Activ_Album.Checked) data.SongInfo.Album = Manipulate_strings(txt_Album.Text, i, false, chbx_Additional_Manipulations.GetItemChecked(25)); //rtxt_StatisticsOnReadDLCs.Text = "...3" + "\n" + rtxt_StatisticsOnReadDLCs.Text; //rtxt_StatisticsOnReadDLCs.Text = "...nipul" + "\n" + rtxt_StatisticsOnReadDLCs.Text; if (chbx_Additional_Manipulations.GetItemChecked(0)) //"1. Add Increment to all Titles" data.Name = i + data.Name; //rtxt_StatisticsOnReadDLCs.Text = "...mpl" + "\n" + rtxt_StatisticsOnReadDLCs.Text; artist = ""; if (chbx_Additional_Manipulations.GetItemChecked(1)) //"2. Add Increment to all songs(&Separately per artist)" { if (i > 0) if (data.SongInfo.Artist == files[i - 1].Artist) no_ord += 1; else no_ord = 1; else no_ord += 1; artist = no_ord + " "; data.SongInfo.SongDisplayName = i + artist + data.SongInfo.SongDisplayName; } //if (chbx_Additional_Manipualtions.GetItemChecked(7)) //"8. Don't repack Broken songs" // if (file.Is_Broken == "Yes") break; //rtxt_StatisticsOnReadDLCs.Text = "...4" + "\n" + rtxt_StatisticsOnReadDLCs.Text; //rtxt_StatisticsOnReadDLCs.Text = "...manipl" + "\n" + rtxt_StatisticsOnReadDLCs.Text; if (chbx_Additional_Manipulations.GetItemChecked(2)) //"3. Make all DLC IDs unique (&save)" if (file.UniqueDLCName != null) data.Name = file.UniqueDLCName; else { Random random = new Random(); data.Name = random.Next(0, 100000) + data.Name; var DB_Path = (chbx_DefaultDB.Checked == true ? MyAppWD : txt_DBFolder.Text) + "\\Files.accdb;"; using (OleDbConnection cnn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + DB_Path)) { DataSet dis = new DataSet(); cmd += "UPDATE Main SET UniqueDLCName=" + data.Name + " WHERE ID=" + file.ID; OleDbDataAdapter das = new OleDbDataAdapter(cmd, cnn); das.Fill(dis, "Main"); das.Dispose(); } } //Fix the _preview_preview issue var ms = data.OggPath; //var audiopath = ""; var audioprevpath = ""; var tst = ""; //MessageBox.Show("One or more"); //rtxt_StatisticsOnReadDLCs.Text = "maybe fixing .."+ file.Folder_Name+"\n"+ norm_path + "\n"+ rtxt_StatisticsOnReadDLCs.Text; try { var sourceAudioFiles = Directory.GetFiles(file.Folder_Name, "*.wem", SearchOption.AllDirectories); //if (sourceAudioFiles.Length>0) //var targetAudioFiles = new List<string>(); foreach (var fil in sourceAudioFiles) { tst = fil; //MessageBox.Show("test2.02 " + fil); //rtxt_StatisticsOnReadDLCs.Text = "thinking about fixing _preview_preview issue.." + norm_path +"-"+tst+ "\n"+rtxt_StatisticsOnReadDLCs.Text; if (fil.LastIndexOf("_preview_preview.wem") > 0) { ms = fil.Substring(0, fil.LastIndexOf("_preview_preview.wem")); File.Move((ms + "_preview.wem"), (ms + ".wem")); File.Move((ms + "_preview_preview.wem"), (ms + "_preview.wem")); //bcapirtxt_StatisticsOnReadDLCs.Text = "fixing _preview_preview issue..." + rtxt_StatisticsOnReadDLCs.Text; } } } catch (Exception ee) { //bcapirtxt_StatisticsOnReadDLCs.Text = "FAILED6-" + ee.Message + tst + "\n" + rtxt_StatisticsOnReadDLCs.Text; Console.WriteLine(ee.Message); } if (data == null) { MessageBox.Show("One or more fields are missing information.", MESSAGEBOX_CAPTION, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //rtxt_StatisticsOnReadDLCs.Text = "...5" + "\n" + rtxt_StatisticsOnReadDLCs.Text; //dlcSavePath = ds.Tables[0].Rows[i].ItemArray[1].ToString() + "\\";// + ((info.PackageVersion == null) ? "Original" : "CDLC") + "-" + info.SongInfo.SongYear +".psarc"; //var dlcSavePath = GeneralExtensions.GetShortName("{0}_{1}_v{2}", (((file.Version == null) ? "Original" : "CDLC") + "_" + info.SongInfo.SongDisplayName), (info.SongInfo.SongDisplayName + "_" + info.SongInfo.Album + "_" + info.SongInfo.SongYear), info.PackageVersion, ConfigRepository.Instance().GetBoolean("creator_useacronyms")); var FN = ""; //bcapirtxt_StatisticsOnReadDLCs.Text = file.Song_Title+ "\n" + rtxt_StatisticsOnReadDLCs.Text; if (cbx_Activ_File_Name.Checked) FN = Manipulate_strings(txt_File_Name.Text, i, true, chbx_Additional_Manipulations.GetItemChecked(25)); else FN = GeneralExtensions.GetShortName("{0}-{1}-v{2}", ("def" + ((file.Version == null) ? "ORIG" : "CDLC") + "_" + file.Artist), (file.Album_Year.ToInt32() + "_" + file.Album + "_" + file.Song_Title), file.Version, ConfigRepository.Instance().GetBoolean("creator_useacronyms"));//((data.PackageVersion == null) ? "Original" : "CDLC") + "_" + data.SongInfo.Artist + "_" + data.SongInfo.SongYear + "_" + data.SongInfo.Album + "_" + data.SongInfo.SongDisplayName; if (file.Is_Alternate == "Yes") FN += "a." + file.Alternate_Version_No + file.Author; //rtxt_StatisticsOnReadDLCs.Text = "fn: " + FN + "\n" + rtxt_StatisticsOnReadDLCs.Text; if (chbx_Additional_Manipulations.GetItemChecked(8) || chbx_PS3.Checked) { FN = FN.Replace(".", "_"); FN = FN.Replace(" ", "_"); } dlcSavePath = txt_TempPath.Text + "\\" + FN; //rtxt_StatisticsOnReadDLCs.Text = "rez : " + dlcSavePath + "\n" + rtxt_StatisticsOnReadDLCs.Text; //if (GameVersion.RS2014 == GameVersion.RS2012) //old code //{ // try // { // OggFile.VerifyHeaders(data.OggPath); // } // catch (InvalidDataException ex) // { // MessageBox.Show(ex.Message, MESSAGEBOX_CAPTION, MessageBoxButtons.OK, MessageBoxIcon.Error); // return; // } //} //rtxt_StatisticsOnReadDLCs.Text = "genf : " + "\n" + rtxt_StatisticsOnReadDLCs.Text; int progress = 0; errorsFound = new StringBuilder(); var numPlatforms = 0; //if (platformPC.Checked) numPlatforms++; if (chbx_Mac.Checked) numPlatforms++; if (chbx_XBOX360.Checked) numPlatforms++; if (chbx_PS3.Checked) numPlatforms++; var step = (int)Math.Round(1.0 / numPlatforms * 100, 0); // rtxt_StatisticsOnReadDLCs.Text = "...6" + "\n" + rtxt_StatisticsOnReadDLCs.Text; if (chbx_PC.Checked) try { bwRGenerate.ReportProgress(progress, "Generating PC package"); //bcapirtxt_StatisticsOnReadDLCs.Text = "1pc..." + rtxt_StatisticsOnReadDLCs.Text; RocksmithToolkitLib.DLCPackage.DLCPackageCreator.Generate(dlcSavePath, data, new Platform(GamePlatform.Pc, CurrentGameVersion)); //bcapirtxt_StatisticsOnReadDLCs.Text = "2pc..." + rtxt_StatisticsOnReadDLCs.Text; progress += step; bwRGenerate.ReportProgress(progress); //bcapirtxt_StatisticsOnReadDLCs.Text = "3pc..." + rtxt_StatisticsOnReadDLCs.Text; } catch (Exception ex) { errorsFound.AppendLine(String.Format("Error 0 generate PC package: {0}{1}{0}{2}{0}", Environment.NewLine, ex.Message, ex.StackTrace)); //bcapirtxt_StatisticsOnReadDLCs.Text = "...0pc ERROR..." + ex.Message + rtxt_StatisticsOnReadDLCs.Text; } if (chbx_Mac.Checked) try { bwRGenerate.ReportProgress(progress, "Generating Mac package"); RocksmithToolkitLib.DLCPackage.DLCPackageCreator.Generate(dlcSavePath, data, new Platform(GamePlatform.Mac, CurrentGameVersion)); progress += step; bwRGenerate.ReportProgress(progress); } catch (Exception ex) { errorsFound.AppendLine(String.Format("Error 1 generate Mac package: {0}{1}{0}{2}{0}", Environment.NewLine, ex.Message, ex.StackTrace)); //bcapirtxt_StatisticsOnReadDLCs.Text = "...0mac ERROR..." + ex.Message + rtxt_StatisticsOnReadDLCs.Text; } if (chbx_XBOX360.Checked) try { bwRGenerate.ReportProgress(progress, "Generating XBox 360 package"); RocksmithToolkitLib.DLCPackage.DLCPackageCreator.Generate(dlcSavePath, data, new Platform(GamePlatform.XBox360, CurrentGameVersion)); progress += step; bwRGenerate.ReportProgress(progress); } catch (Exception ex) { errorsFound.AppendLine(String.Format("Error generate XBox 360 package: {0}{1}{0}{2}{0}", Environment.NewLine, ex.Message, ex.StackTrace)); //bcapirtxt_StatisticsOnReadDLCs.Text = "...0mac ERROR..." + ex.Message + rtxt_StatisticsOnReadDLCs.Text; } if (chbx_PS3.Checked) try { //rtxt_StatisticsOnReadDLCs.Text = "ps3...start..." + rtxt_StatisticsOnReadDLCs.Text; bwRGenerate.ReportProgress(progress, "Generating PS3 package"); //rtxt_StatisticsOnReadDLCs.Text = dlcSavePath + rtxt_StatisticsOnReadDLCs.Text; RocksmithToolkitLib.DLCPackage.DLCPackageCreator.Generate(dlcSavePath, data, new Platform(GamePlatform.PS3, CurrentGameVersion)); //progress += step; //bwRGenerate.ReportProgress(progress); // rtxt_StatisticsOnReadDLCs.Text = "ps3...off..." + rtxt_StatisticsOnReadDLCs.Text; } catch (Exception ex) { errorsFound.AppendLine(String.Format("Error 2generate PS3 package: {0}{1}. {0}PS3 package require 'JAVA x86' (32 bits) installed on your machine to generate properly.{0}", Environment.NewLine, ex.StackTrace)); ErrorWindow frm1 = new ErrorWindow("Error 2generate PS3 package: {0}" + ex.StackTrace + ". {0}PS3 package require 'JAVA x86' (32 bits) installed on your machine to generate properly. " + Environment.NewLine, "http://www.java.com/"); //bcapirtxt_StatisticsOnReadDLCs.Text = "...0Ps3 ERROR..."+ dlcSavePath+"---"+ dlcSavePath.Length+ "----" + ex.Message + rtxt_StatisticsOnReadDLCs.Text; } data.CleanCache(); //rtxt_StatisticsOnReadDLCs.Text = "gen2 : " + "\n" + rtxt_StatisticsOnReadDLCs.Text; i++; //rtxt_StatisticsOnReadDLCs.Text = "gen r: " + "\n" + rtxt_StatisticsOnReadDLCs.Text; //TO DO DELETE the ORIGINAL IMPORTED FILES or not //bcapirtxt_StatisticsOnReadDLCs.Text = "\nRepack bkworkerdone.." + i + rtxt_StatisticsOnReadDLCs.Text; //copyftp string txt_FTPPat = ""; if (chbx_PS3.Checked && chbx_Additional_Manipulations.GetItemChecked(49)) { if (ConfigRepository.Instance()["dlcm_FTP"] == "EU") txt_FTPPat = ConfigRepository.Instance()["dlcm_FTP1"]; else txt_FTPPat = ConfigRepository.Instance()["dlcm_FTP2"]; MainDB.FTPFile(txt_FTPPat, txt_TempPath.Text + "\\" + FN + "_ps3.psarc.edat", txt_TempPath.Text, ""); //rtxt_StatisticsOnReadDLCs.Text = " and FTPed" + "\n" + rtxt_StatisticsOnReadDLCs.Text; } else if ((chbx_PC.Checked || chbx_Mac.Checked) && chbx_Additional_Manipulations.GetItemChecked(49)) { var platfrm = (chbx_PC.Checked ? "_p" : (chbx_Mac.Checked ? "_m" : "")); var dest = ""; if (txt_RocksmithDLCPath.Text.IndexOf("Rocksmith\\DLC") > 0) { dest = txt_RocksmithDLCPath.Text; //File.Copy(RocksmithDLCPath + "\\rs1compatibilitydlc" + platfrm + ".psarc", dest + "\\rs1compatibilitydlc" + platfrm + ".psarc.orig", false); File.Copy(FN + platfrm + ".psarc", dest, true); } else if (txt_RocksmithDLCPath.Text != txt_FTPPat) { dest = txt_FTPPat;//!File.Exists( //File.Copy(dest + "\\rs1compatibilitydlc" + platfrm + ".psarc", dest + "\\rs1compatibilitydlc" + platfrm + ".psarc.orig", false); File.Copy(FN + platfrm + ".psarc", dest, true); } else MessageBox.Show("Chose a different path to save"); //rtxt_StatisticsOnReadDLCs.Text = " and Copied" + "\n" + rtxt_StatisticsOnReadDLCs.Text; } //Restore the DDremoved copies xmlFiles = Directory.GetFiles(file.Folder_Name, "*.xml.old", SearchOption.AllDirectories); platform = file.Folder_Name.GetPlatform(); if (chbx_Additional_Manipulations.GetItemChecked(5) || chbx_Additional_Manipulations.GetItemChecked(3)) { if (bassRemoved == "Yes") file.Has_BassDD = "Yes"; foreach (var xml in xmlFiles) { //rtxt_StatisticsOnReadDLCs.Text = "...=.." + xml + "\n\n" + rtxt_StatisticsOnReadDLCs.Text; if ((Path.GetFileNameWithoutExtension(xml).ToLower().Contains("bass") && file.Has_BassDD == "Yes" && xml.ToLower().Contains(".old") && chbx_Additional_Manipulations.GetItemChecked(5)) || ((Path.GetFileNameWithoutExtension(xml).ToLower().Contains("lead") || Path.GetFileNameWithoutExtension(xml).ToLower().Contains("rhythm") || Path.GetFileNameWithoutExtension(xml).ToLower().Contains("combo")) && file.Has_Guitar == "Yes" && xml.ToLower().Contains(".old") && chbx_Additional_Manipulations.GetItemChecked(3))) // continue; { if (chbx_Additional_Manipulations.GetItemChecked(5) && !chbx_Additional_Manipulations.GetItemChecked(3) && !Path.GetFileNameWithoutExtension(xml).ToLower().Contains("bass")) continue; //Save a copy File.Copy(xml.Replace(".old", ""), xml.Replace(".old", ".woDD"), true); File.Copy(xml, xml.Replace(".old", ""), true); var json = ""; if (chbx_Additional_Manipulations.GetItemChecked(36)) //37. Keep the Uncompressed Songs superorganized json = xml.Replace("EOF", "Toolkit").Replace(".xml", ".json"); else json = xml.Replace("songs\\arr", calc_path(Directory.GetFiles(file.Folder_Name, "*.json", SearchOption.AllDirectories)[0])).Replace(".xml", ".json"); File.Copy(json.Replace(".old", ""), json.Replace(".old", ".woDD"), true); File.Copy(json, json.Replace(".old", ""), true); } } } } //MessageBox.Show("tst"); } //bcapirtxt_StatisticsOnReadDLCs.Text = "\n...Repack done.." + rtxt_StatisticsOnReadDLCs.Text; MessageBox.Show("Repack done"); }