private void saveToDBButtonX_Click(object sender, EventArgs e) { if (mysql == null) { return; } for (int i = 0; i < vendorListViewEx.Items.Count; i++) { string[] columns = new string[] { "entry", "item" }; string[] values = new string[] { vendorListViewEx.Items[i].SubItems[0].Text, vendorListViewEx.Items[i].SubItems[1].Text }; mysql.ReplaceIntoDatabase(Settings.Default.WorldDB, "npc_vendor", values, columns); } TaskDialog.Show(new TaskDialogInfo("Finished", eTaskDialogIcon.Information2, "Done", String.Empty, eTaskDialogButton.Ok)); }
private void saveToDBButtonX_Click(object sender, EventArgs e) { if (mysql == null) { return; } for (int i = 0; i < lootListViewEx.Items.Count; i++) { string[] columns = new string[] { "entry", "item", "ChanceOrQuestChance", "mincountOrRef", "maxcount" }; string[] values = new string[] { lootListViewEx.Items[i].SubItems[0].Text, lootListViewEx.Items[i].SubItems[1].Text, lootListViewEx.Items[i].SubItems[2].Text, lootListViewEx.Items[i].SubItems[3].Text, lootListViewEx.Items[i].SubItems[4].Text }; mysql.ReplaceIntoDatabase(Settings.Default.WorldDB, "creature_loot_template", values, columns); string[] updateColumns = new string[] { "lootid", "entry" }; string[] updateValues = new string[] { lootListViewEx.Items[i].SubItems[0].Text, lootListViewEx.Items[i].SubItems[0].Text }; mysql.UpdateDatabase(Settings.Default.WorldDB, "creature_template", "entry", lootListViewEx.Items[i].SubItems[0].Text, updateValues, updateColumns); } TaskDialog.Show(new TaskDialogInfo("Finished", eTaskDialogIcon.Information2, "Done", String.Empty, eTaskDialogButton.Ok)); }
private void wizard_FinishButtonClick(object sender, CancelEventArgs e) { try { int unit_class = 0; switch (classComboBoxEx.SelectedIndex) { case 0: unit_class = 1; break; case 1: unit_class = 2; break; case 2: unit_class = 4; break; case 3: unit_class = 8; break; } Dictionary <string, List <string> > classLevelStats = mysql.ReadAll(Settings.Default.WorldDB, "creature_classlevelstats", new string[] { "level", "class" }, new string[] { minLevelIntegerInput.Value.ToString(), unit_class.ToString() }); if (!classLevelStats.ContainsKey("basehp2") || !classLevelStats.ContainsKey("basearmor")) { TaskDialog.Show(new TaskDialogInfo("Error!", eTaskDialogIcon.Stop, "An error has occured!", String.Empty, eTaskDialogButton.Ok)); finished = true; this.Close(); return; } int health = int.Parse(classLevelStats["basehp2"][0]); int armor = int.Parse(classLevelStats["basearmor"][0]); float health_mod = 0; if (healthIntegerInput.Value != 0 && health != 0) { health_mod = float.Parse(healthIntegerInput.Value.ToString()) / health; } else if (health == 0) { health_mod = float.Parse(healthIntegerInput.Value.ToString()); } float armor_mod = 0; if (armorIntegerInput.Value != 0 && armor != 0) { armor_mod = float.Parse(armorIntegerInput.Value.ToString()) / armor; } else if (armor == 0) { armor_mod = float.Parse(armorIntegerInput.Value.ToString()); } int faction = 0; switch (factionComboBoxEx.SelectedIndex) { case 0: faction = 7; break; case 1: faction = 14; break; case 2: faction = 35; break; } int flags = 0; if (gossipYesRadioButton.Checked) { flags += 1; } if (vendorYesRadioButton.Checked) { flags += 128; } if (armorerYesRadioButton.Checked) { flags += 4096; } if (innkeeperYesRadioButton.Checked) { flags += 65536; } if (bankerYesRadioButton.Checked) { flags += 131072; } if (auctioneerYesRadioButton.Checked) { flags += 2097152; } if (stableYesRadioButton.Checked) { flags += 4194304; } if (guildBankYesRadioButton.Checked) { flags += 8388608; } if (questGiverYesRadioButton.Checked) { flags += 2; } if (guardYesRadioButton.Checked) { flags += 268435456; } int money = (lootCopperIntegerInput.Value % 100) + (lootSilverIntegerInput.Value * 100) + (lootGoldIntegerInput.Value * 10000); int regen = 0; if (regenHealthYesRadioButton.Checked) { regen = 1; } string AIName = String.Empty; switch (aiNameComboBoxEx.SelectedIndex) { case 1: AIName = "NullAI"; break; case 2: AIName = "AggressorAI"; break; case 3: AIName = "ReactorAI"; break; } double attackTime = TimeSpan.FromSeconds(Convert.ToDouble(speedNumericUpDown.Value)).TotalMilliseconds; string npcName = NameTextBoxX.Text.Replace("'", "\\'"); string npcSubname = subnameTextBoxX.Text.Replace("'", "\\'"); string[] columns = new string[] { "entry", "modelid1", "name", "subname", "minlevel", "maxlevel", "exp", "faction_A", "faction_H", "npcflag", "scale", "rank", "mindmg", "maxdmg", "attackpower", "baseattacktime", "rangeattacktime", "unit_class", "family", "minrangedmg", "maxrangedmg", "rangedattackpower", "type", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "VehicleId", "mingold", "maxgold", "AIName", "MovementType", "InhabitType", "Health_mod", "Mana_mod", "Armor_mod", "RegenHealth", "ScriptName" }; string[] values = new string[] { entryIDIntegerInput.Value.ToString(), displayIDIntegerInput.Value.ToString(), npcName, npcSubname, minLevelIntegerInput.Value.ToString(), maxLevelIntegerInput.Value.ToString(), "2", faction.ToString(), faction.ToString(), flags.ToString(), modelSizeNumericUpDown.Value.ToString(), rankComboBoxEx.SelectedIndex.ToString(), minDamageIntegerInput.Value.ToString(), maxDamageIntegerInput.Value.ToString(), attackPowerIntegerInput.Value.ToString(), attackTime.ToString(), attackTime.ToString(), unit_class.ToString(), familyComboItemEx.SelectedIndex.ToString(), minDamageIntegerInput.Value.ToString(), maxDamageIntegerInput.Value.ToString(), attackPowerIntegerInput.Value.ToString(), typeComboBoxEx.SelectedIndex.ToString(), holyIntegerInput.Value.ToString(), fireIntegerInput.Value.ToString(), natureIntegerInput.Value.ToString(), frostIntegerInput.Value.ToString(), shadowIntegerInput.Value.ToString(), arcaneIntegerInput.Value.ToString(), vehicleIDIntegerInput.Value.ToString(), money.ToString(), money.ToString(), AIName, movementTypeComboBoxEx.SelectedIndex.ToString(), (inhabitComboBoxEx.SelectedIndex + 1).ToString(), health_mod.ToString(), manaIntegerInput.Value.ToString(), armor_mod.ToString(), regen.ToString(), scriptNameTextBoxX.Text }; finished = true; if (saveToDBRadioButton.Checked) { mysql.ReplaceIntoDatabase(Settings.Default.WorldDB, "creature_template", values, columns); TaskDialog.Show(new TaskDialogInfo("Done", eTaskDialogIcon.Information2, "NPC imported into database", String.Empty, eTaskDialogButton.Ok)); this.Close(); } else { if (saveSQLFileDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK) { string qry = mysql.CreateMySQLQuery(Settings.Default.WorldDB, "creature_template", values, columns); try { StreamWriter writer = new StreamWriter(saveSQLFileDialog.FileName); writer.WriteLine(qry); writer.Flush(); writer.Close(); TaskDialog.Show(new TaskDialogInfo("Done", eTaskDialogIcon.Information2, "SQL File Saved", String.Empty, eTaskDialogButton.Ok)); this.Close(); } catch (Exception ex) { TaskDialog.Show(new TaskDialogInfo("Error", eTaskDialogIcon.Stop, "Error!", ex.Message, eTaskDialogButton.Ok)); } } } } catch (Exception ex) { TaskDialog.Show(new TaskDialogInfo("Error", eTaskDialogIcon.Stop, "Error!", ex.Message, eTaskDialogButton.Ok)); } }
private void wizard_FinishButtonClick(object sender, CancelEventArgs e) { int type = itemTypeComboBoxEX.SelectedIndex; int bind = 0; int buymoney = 0; int sellmoney = 0; switch (itemBindsComboBoxEX.SelectedIndex) { case 1: bind = 1; break; case 2: bind = 3; break; default: bind = 0; break; } buymoney = (Convert.ToInt32(buyCopperIntegerInput.Value) % 100) + (Convert.ToInt32(buySilverIntegerInput.Value) * 100) + (Convert.ToInt32(buyGoldIntegerInput.Value) * 10000); sellmoney = (Convert.ToInt32(sellCopperIntegerInput.Value) % 100) + (Convert.ToInt32(sellSilverIntegerInput.Value) * 100) + (Convert.ToInt32(sellGoldIntegerInput.Value) * 10000); List <int> AllowableClasses = new List <int>(); int allowableclass = 0; //Allowable Classes if (warriorCheckBoxX.Checked) { AllowableClasses.Add(1); } if (paladinCheckBoxX.Checked) { AllowableClasses.Add(2); } if (hunterCheckBoxX.Checked) { AllowableClasses.Add(4); } if (rogueCheckBoxX.Checked) { AllowableClasses.Add(8); } if (priestCheckBoxX.Checked) { AllowableClasses.Add(16); } if (druidCheckBoxX.Checked) { AllowableClasses.Add(1024); } if (shamanCheckBoxX.Checked) { AllowableClasses.Add(64); } if (mageCheckBoxX.Checked) { AllowableClasses.Add(128); } if (warlockCheckBoxX.Checked) { AllowableClasses.Add(256); } if (deathKnightCheckBoxX.Checked) { AllowableClasses.Add(32); } foreach (int p in AllowableClasses) { allowableclass += p; } if (allowableclass == 0) { allowableclass = -1; } List <int> AllowableRaces = new List <int>(); int allowablerace = 0; if (humanCheckBoxX.Checked) { AllowableRaces.Add(1); } if (orcCheckBoxX.Checked) { AllowableRaces.Add(2); } if (dwarfCheckBoxX.Checked) { AllowableRaces.Add(4); } if (nightElfCheckBoxX.Checked) { AllowableRaces.Add(8); } if (undeadCheckBoxX.Checked) { AllowableRaces.Add(16); } if (taurenCheckBoxX.Checked) { AllowableRaces.Add(32); } if (gnomeCheckBoxX.Checked) { AllowableRaces.Add(64); } if (trollCheckBoxX.Checked) { AllowableRaces.Add(128); } if (bloodelfCheckBoxX.Checked) { AllowableRaces.Add(512); } if (draeneiCheckBoxX.Checked) { AllowableRaces.Add(1024); } foreach (int p in AllowableRaces) { allowablerace += p; } if (allowablerace == 0) { allowablerace = -1; } int requiredskill = 0; switch (skillProfressionComboBoxEX.SelectedIndex) { case 1: requiredskill = 129; break; case 2: requiredskill = 164; break; case 3: requiredskill = 165; break; case 4: requiredskill = 171; break; case 5: requiredskill = 182; break; case 6: requiredskill = 185; break; case 7: requiredskill = 186; break; case 8: requiredskill = 197; break; case 9: requiredskill = 202; break; case 10: requiredskill = 333; break; case 11: requiredskill = 356; break; case 12: requiredskill = 393; break; case 13: requiredskill = 755; break; case 14: requiredskill = 0; break; case 15: requiredskill = 43; break; case 16: requiredskill = 44; break; case 17: requiredskill = 46; break; case 18: requiredskill = 54; break; case 19: requiredskill = 55; break; case 20: requiredskill = 95; break; case 21: requiredskill = 136; break; case 22: requiredskill = 160; break; case 23: requiredskill = 162; break; case 24: requiredskill = 172; break; case 25: requiredskill = 173; break; case 26: requiredskill = 176; break; case 27: requiredskill = 226; break; case 28: requiredskill = 228; break; case 29: requiredskill = 229; break; case 30: requiredskill = 473; break; case 31: requiredskill = 762; break; default: requiredskill = 0; break; } if (mysql != null) { try { string itemName = itemNameTextBoxX.Text.Replace("'", "\\'"); string itemQuote = itemQuoteTextBoxX.Text.Replace("'", "\\'"); string[] columns = new string[] { "entry", "class", "subclass", "name", "displayid", "Quality", "BuyPrice", "SellPrice", "AllowableClass", "AllowableRace", "ItemLevel", "RequiredLevel", "RequiredSkill", "RequiredSkillRank", "maxcount", "bonding", "description" }; string[] values = new string[] { entryIDIntegerInput.Value.ToString(), "0", itemTypeComboBoxEX.SelectedIndex.ToString(), itemName, displayIDIntegerInput.Value.ToString(), qualityComboBoxEX.SelectedIndex.ToString(), buymoney.ToString(), sellmoney.ToString(), allowableclass.ToString(), allowablerace.ToString(), itemLevelIntegerInput.Value.ToString(), requiredLevelIntegerInput.Value.ToString(), requiredskill.ToString(), skillLevelIntegerInput.Value.ToString(), maxNumAllowedIntegerInput.Value.ToString(), bind.ToString(), itemQuote }; finished = true; if (saveToDBRadioButton.Checked) { mysql.ReplaceIntoDatabase(Settings.Default.WorldDB, "item_template", values, columns); TaskDialog.Show(new TaskDialogInfo("Done", eTaskDialogIcon.Information2, "Item imported into database", String.Empty, eTaskDialogButton.Ok)); this.Close(); } else { if (saveSQLFileDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK) { string qry = mysql.CreateMySQLQuery(Settings.Default.WorldDB, "item_template", values, columns); try { StreamWriter writer = new StreamWriter(saveSQLFileDialog.FileName); writer.WriteLine(qry); writer.Flush(); writer.Close(); TaskDialog.Show(new TaskDialogInfo("Done", eTaskDialogIcon.Information2, "SQL File Saved", String.Empty, eTaskDialogButton.Ok)); this.Close(); } catch (Exception ex) { TaskDialog.Show(new TaskDialogInfo("Error", eTaskDialogIcon.Stop, "Error!", ex.Message, eTaskDialogButton.Ok)); } } } } catch (Exception ex) { TaskDialog.Show(new TaskDialogInfo("Error", eTaskDialogIcon.Stop, "Error!", ex.Message, eTaskDialogButton.Ok)); } } }