private void FillForm(LootProfile lootProfile)
{
txtBoxDiD.Text = lootProfile.DTdid.ToString();
txtBoxTier.Text = lootProfile.Tier.ToString();
txtBoxLootQualityMod.Text = lootProfile.LootQualityMod.ToString();
txtBoxUnknownChance.Text = lootProfile.UnknownChances.ToString();
txtBoxItemChance.Text = lootProfile.ItemChance.ToString();
txtBoxItemMin.Text = lootProfile.ItemMinAmount.ToString();
txtBoxItemMax.Text = lootProfile.ItemMaxAmount.ToString();
cBoxItemChances.SelectedIndex = lootProfile.ItemTreasureTypeSelectionChances - 1;
lblItemTreasureChances.Text = lootProfile.ItemTreasureTypeSelectionChances.ToString();
txtBoxMagicItemChance.Text = lootProfile.MagicItemChance.ToString();
txtBoxMagicItemMin.Text = lootProfile.MagicItemMinAmount.ToString();
txtBoxMagicItemMax.Text = lootProfile.MagicItemMaxAmount.ToString();
cBoxMagicItemChances.SelectedIndex = lootProfile.MagicItemTreasureTypeSelectionChances - 1;
lblMagicItemTreasureChance.Text = lootProfile.MagicItemTreasureTypeSelectionChances.ToString();
txtBoxMundaneItemChance.Text = lootProfile.MundaneItemChance.ToString();
txtBoxMundaneItemMin.Text = lootProfile.MundaneItemMinAmount.ToString();
txtBoxMundaneItemMax.Text = lootProfile.MundaneItemMaxAmount.ToString();
cBoxMundaneItemChances.SelectedIndex = lootProfile.MundaneItemTreasureTypeSelectionChances - 1;
lblMundaneItemTreasureChance.Text = lootProfile.MundaneItemTreasureTypeSelectionChances.ToString();
lblLastModified.Text = lootProfile.LastModified;
}
private void btnOpen_Click(object sender, EventArgs e)
{
OpenFileDialog ofd = new OpenFileDialog();
ofd.Title = "Open Text File";
ofd.Filter = "SQL files|*.sql";
ofd.InitialDirectory = @"C:\Users\Harli\Source\Repos\ACE-World-16PY\Database\3-Core\3 TreasureTable\SQL\Death";
if (ofd.ShowDialog() == DialogResult.OK)
{
var formData = new LootProfile();
formData = FileOps.OpenFile(ofd.FileName);
FillForm(formData);
}
}
public static void SaveFile(LootProfile filedata, string myfilename)
{
// Saves sql file
string header = $"DELETE FROM `treasure_death` WHERE `treasure_Type` = {filedata.DTdid}; \n\n" +
"INSERT INTO `treasure_death` (`treasure_Type`, `tier`, `loot_Quality_Mod`, `unknown_Chances`, `item_Chance`, `item_Min_Amount`, `item_Max_Amount`, `item_Treasure_Type_Selection_Chances`, `magic_Item_Chance`, `magic_Item_Min_Amount`, `magic_Item_Max_Amount`, `magic_Item_Treasure_Type_Selection_Chances`, `mundane_Item_Chance`, `mundane_Item_Min_Amount`, `mundane_Item_Max_Amount`, `mundane_Item_Type_Selection_Chances`, `last_Modified`)\n";
string dateModified = string.Format("{0:MM-dd-yyyy H:hh-mm-sst}", DateTime.Now);
string dtData = $"VALUES ({filedata.DTdid}, {filedata.Tier}, {filedata.LootQualityMod}, {filedata.UnknownChances}, " +
$"{filedata.ItemChance}, {filedata.ItemMinAmount}, {filedata.ItemMaxAmount}, {filedata.ItemTreasureTypeSelectionChances}, " +
$"{filedata.MagicItemChance}, {filedata.MagicItemMinAmount}, {filedata.MagicItemMaxAmount}, {filedata.MagicItemTreasureTypeSelectionChances}, " +
$"{filedata.MundaneItemChance}, {filedata.MundaneItemMinAmount}, {filedata.MundaneItemMaxAmount}, {filedata.MundaneItemTreasureTypeSelectionChances}, " + dateModified;
File.WriteAllText(myfilename, header + dtData);
}
private void btnSave_Click(object sender, EventArgs e)
{
SaveFileDialog sfd = new SaveFileDialog();
sfd.Title = "Open Text File";
sfd.Filter = "SQL files|*.sql";
sfd.FileName = $"00{txtBoxDiD}.sql";
sfd.InitialDirectory = @"C:\Ace";
if (sfd.ShowDialog() == DialogResult.OK)
{
var profileData = new LootProfile();
//rofileData.DTdid =
}
}
public static LootProfile OpenFile(string filepath)
{
// Opens sql file
var profileData = new LootProfile();
//var lines = File.ReadLines(fileName);
//foreach (var line in lines)
// // Process line
foreach (string line in File.ReadLines(filepath))
{
if (line.Contains("VALUE"))
{
string linedata = "";
linedata = line.Replace("VALUES", "");
linedata = linedata.Replace("(", "");
linedata = linedata.Replace(");", "");
linedata = linedata.Replace("'", "");
string[] lootProfileValues = linedata.Split(',');
profileData.DTdid = ConvertToInt(lootProfileValues[0]);
profileData.Tier = ConvertToInt(lootProfileValues[1]);
profileData.LootQualityMod = float.Parse(lootProfileValues[2]);
profileData.UnknownChances = ConvertToInt(lootProfileValues[3]);
profileData.ItemChance = ConvertToInt(lootProfileValues[4]);
profileData.ItemMinAmount = ConvertToInt(lootProfileValues[5]);
profileData.ItemMaxAmount = ConvertToInt(lootProfileValues[6]);
profileData.ItemTreasureTypeSelectionChances = ConvertToInt(lootProfileValues[7]);
profileData.MagicItemChance = ConvertToInt(lootProfileValues[8]);
profileData.MagicItemMinAmount = ConvertToInt(lootProfileValues[9]);
profileData.MagicItemMaxAmount = ConvertToInt(lootProfileValues[10]);
profileData.MagicItemTreasureTypeSelectionChances = ConvertToInt(lootProfileValues[11]);
profileData.MundaneItemChance = ConvertToInt(lootProfileValues[12]);
profileData.MundaneItemMinAmount = ConvertToInt(lootProfileValues[13]);
profileData.MundaneItemMaxAmount = ConvertToInt(lootProfileValues[14]);
profileData.MundaneItemTreasureTypeSelectionChances = ConvertToInt(lootProfileValues[15]);
profileData.LastModified = lootProfileValues[16];
//string[] tokens = str.Split(',');
}
}
return(profileData);
}