private void textBox6_TextChanged(object sender, EventArgs e)
{
//if (!System.Text.RegularExpressions.Regex.IsMatch(textBox1.Text, "^[a-zA-Z]"))
//{
// //MessageBox.Show("This textbox accepts only alphabetical characters");
// textBox1.Text.Remove(textBox1.Text.Length - 1);
//}
string constring = "datasource=" + form_MM.GetHost() + ";" +
"port=" + form_MM.GetPort() + ";" +
"username="******";" +
"password="******";";
MySqlConnection conDataBase = new MySqlConnection(constring);
MySqlCommand com = new MySqlCommand("SELECT name, modelid1 FROM " + form_MM.GetWorldDB() + ".creature_template WHERE name LIKE \"%" + textBox6.Text + "%\";", conDataBase);
try
{
MySqlDataAdapter sda = new MySqlDataAdapter();
sda.SelectCommand = com;
DataTable dbdataset = new DataTable();
sda.Fill(dbdataset);
BindingSource bsource = new BindingSource();
bsource.DataSource = dbdataset;
dataGridView1.DataSource = bsource;
sda.Update(dbdataset);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
//MessageBox.Show("If the name contains an apostrophe type like this example:\ncrusader\\'s black warhorse");
}
}
private void button1_Click(object sender, EventArgs e)
{
Form_MainMenu mainmenu = new Form_MainMenu();
if (textBox2.Text == "")
{
MessageBox.Show("Text should not be empty", "Error");
return;
}
MySqlConnection connection = new MySqlConnection(
"datasource=" + form_MM.GetHost() + ";" +
"port=" + form_MM.GetPort() + ";" +
"username="******";" +
"password="******";"
);
string insertQuery = $"INSERT INTO { form_MM.GetWorldDB() }.creature_text " +
"(entry, text, type, probability, language) " + Environment.NewLine +
"VALUES (" +
textBox61.Text + ", '" + // entry
textBox2.Text + "', " + // text
textBox4.Text + ", " + // type
textBox10.Text + ", " + // probability
textBox1.Text + "); " + Environment.NewLine + // language
$"INSERT INTO { form_MM.GetWorldDB() }.smart_scripts " +
"(entryorguid, event_type, action_type, event_chance, event_param1, event_param2, event_param3, event_param4) " + Environment.NewLine +
"VALUES (" +
textBox61.Text + ", " + // entryorguid
textBox20.Text + ", " + // event_type
textBox16.Text + ", " + // action_type
textBox23.Text + ", " + // event_chance
textBox11.Text + ", " + // event_param1
textBox5.Text + ", " + // event_param2
textBox18.Text + ", " + // event_param3
textBox17.Text + "); " + Environment.NewLine; // event_param4
MySqlCommand command = new MySqlCommand(insertQuery, connection);
try
{
connection.Open();
command.ExecuteNonQuery();
label9.Visible = true;
}
catch (MySqlException ex)
{
MessageBox.Show("ERROR: " + ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
connection.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
Form_MainMenu mainmenu = new Form_MainMenu();
if (textBox65.Text == "")
{
MessageBox.Show("Item ID should not be empty", "Error");
return;
}
if (textBox65.Text == "0")
{
MessageBox.Show("Item ID should not be 0", "Error");
return;
}
MySqlConnection connection = new MySqlConnection(
"datasource=" + form_MM.GetHost() +
";port=" + form_MM.GetPort() +
";username="******";password="******"INSERT INTO { form_MM.GetWorldDB() }.creature_loot_template " +
"(Entry, Item, Reference, Chance, QuestRequired, LootMode, GroupId, MinCount, MaxCount, Comment) \n" +
"VALUES (" +
textBox61.Text + ", " + // Entry
textBox65.Text + ", " + // ItemID
textBox1.Text + ", " + // Reference
textBox2.Text + ", " + // Chance
textBox4.Text + ", " + // QuestRequired
textBox3.Text + ", " + // LootMode
textBox8.Text + ", " + // GroupId
textBox7.Text + ", " + // MinCount
textBox6.Text + ", " + // MaxCount
"'" + textBox5.Text + // Comment
"');";
MySqlCommand command = new MySqlCommand(insertQuery, connection);
// Test
try
{
connection.Open();
command.ExecuteNonQuery();
label9.Visible = true;
}
catch (MySqlException ex)
{
MessageBox.Show("ERROR: " + ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
connection.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
Form_MainMenu mainmenu = new Form_MainMenu();
var npc = new NPC_Creator();
if (textBox5.Text == "")
{
MessageBox.Show("Option Text should not be empty", "Error");
return;
}
MySqlConnection connection = new MySqlConnection(
"datasource=" + form_MM.GetHost() + ";" +
"port=" + form_MM.GetPort() + ";" +
"username="******";" +
"password="******"INSERT INTO " + form_MM.GetWorldDB() + ".gossip_menu_option " +
"(menu_id, id, option_icon, option_text, OptionBroadcastTextID, option_id, npc_option_npcflag, " +
"action_menu_id, action_poi_id, box_coded, box_money, box_text, BoxBroadcastTextID, VerifiedBuild) \n" +
"VALUES (" +
textBox61.Text + ", " + // menu_id
numericUpDown1.Text + ", " + // id
textBox_option_icon.Text + ", '" + // option_icon
textBox5.Text + "', " + // option_text
textBox4.Text + ", " + // OptionBroadcastTextID
textBox_option_id.Text + ", " + // option_id
textBox7.Text + ", " + // npc_option_npcflag
textBox6.Text + ", " + // action_menu_id
textBox3.Text + ", " + // action_poi_id
textBox2.Text + ", " + // box_coded
textBox10.Text + ", '" + // box_money
textBox9.Text + "', " + // box_text
textBox11.Text + ", " + // BoxBroadcastTextID
textBox12.Text + ");"; // VerifiedBuild
MySqlCommand command = new MySqlCommand(insertQuery, connection);
try
{
connection.Open();
command.ExecuteNonQuery();
label9.Visible = true;
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
connection.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
Form_MainMenu mainmenu = new Form_MainMenu();
if (textBox1.Text == "")
{
MessageBox.Show("Item ID should not be empty", "Error");
return;
}
if (textBox1.Text == "0")
{
MessageBox.Show("Item ID should not be 0", "Error");
return;
}
MySqlConnection connection = new MySqlConnection(
$"datasource={ form_MM.GetHost() };" +
$"port={ form_MM.GetPort() };" +
$"username={ form_MM.GetUser() };" +
$"password={ form_MM.GetPass() };"
);
string insertQuery = $"INSERT INTO { form_MM.GetWorldDB() }.npc_vendor " +
"(entry, slot, item, maxcount, incrtime, ExtendedCost, VerifiedBuild) " + Environment.NewLine +
"VALUES (" +
textBox61.Text + ", " + // entry
textBox65.Text + ", " + // slot
textBox1.Text + ", " + // item
textBox2.Text + ", " + // maxcount
textBox4.Text + ", " + // incrtime
textBox3.Text + ", " + // ExtendedCost
textBox5.Text + // VerifiedBuild
"); ";
MySqlCommand command = new MySqlCommand(insertQuery, connection);
try
{
connection.Open();
command.ExecuteNonQuery();
label9.Visible = true;
}
catch (MySqlException ex)
{
MessageBox.Show("ERROR: " + ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
connection.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
Form_MainMenu mainmenu = new Form_MainMenu();
if (textBox1.Text == "")
{
MessageBox.Show("Item ID should not be empty", "Error");
return;
}
if (textBox1.Text == "0")
{
MessageBox.Show("Item ID should not be 0", "Error");
return;
}
MySqlConnection connection = new MySqlConnection(
"datasource=" + form_MM.GetHost() + ";" +
"port=" + form_MM.GetPort() + ";" +
"username="******";" +
"password="******";"
);
string insertQuery = "INSERT INTO " + form_MM.GetWorldDB() + ".npc_vendor " +
"(entry, slot, item, maxcount, incrtime, ExtendedCost, VerifiedBuild) \n" +
"VALUES (" +
textBox61.Text + ", " + // entry
textBox65.Text + ", " + // slot
textBox1.Text + ", " + // item
textBox2.Text + ", " + // maxcount
textBox4.Text + ", " + // incrtime
textBox3.Text + ", " + // ExtendedCost
textBox5.Text + // VerifiedBuild
");";
connection.Open();
MySqlCommand command = new MySqlCommand(insertQuery, connection);
try
{
if (command.ExecuteNonQuery() == 1)
{
label9.Visible = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
connection.Close();
}
private void SelectMaxPlus1()
{
GetMySqlConnection();
string query = $"SELECT max(guid) + 1 FROM { form_MM.GetWorldDB() }.creature;";
MySqlCommand _command = new MySqlCommand(query, connection);
try
{
connection.Open();
textBox61.Text = _command.ExecuteScalar().ToString();
_command.Connection.Close();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message, "SpawnCreator" + form_MM.version, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void GenerateSql()
{
uint flags_dis_spell_st = 0;
uint flags_dis_map_st = 0;
uint flags_dis_vmap_st = 0;
string[] checkedIndicies1 = Properties.Settings.Default.FlagsDisableSpell.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int i1 = 0; i1 < checkedIndicies1.Length; i1++)
{
int idx;
if ((int.TryParse(checkedIndicies1[i1], out idx)))
{
switch (idx)
{
case 0: // Spell enabled
flags_dis_spell_st += 0;
break;
case 1: // Spell disabled for players
flags_dis_spell_st += 1;
break;
case 2: // Spell disabled for creatures
flags_dis_spell_st += 2;
break;
case 3: // Spell disabled for pets
flags_dis_spell_st += 4;
break;
case 4: // Spell completely disabled (used for no logner existing spells in DBCs)
flags_dis_spell_st += 8;
break;
case 5: // Spell disabled for MapId
flags_dis_spell_st += 16;
break;
case 6: // Spell disabled for AreaId
flags_dis_spell_st += 32;
break;
case 7: // Line of Sight (LOS) is disabled for this spell (replaces "vmap.ignoreSpellIds" config option)
flags_dis_spell_st += 64;
break;
}
}
}
string[] checkedIndicies2 = Properties.Settings.Default.FlagsDisableMap.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int i1 = 0; i1 < checkedIndicies2.Length; i1++)
{
int idx;
if ((int.TryParse(checkedIndicies2[i1], out idx)))
{
switch (idx)
{
case 0: // DUNGEON_STATUSFLAG_NORMAL OR RAID_STATUSFLAG_10MAN_NORMAL
flags_dis_map_st += 1;
break;
case 1: // DUNGEON_STATUSFLAG_HEROIC OR RAID_STATUSFLAG_25MAN_NORMAL
flags_dis_map_st += 2;
break;
case 2: // RAID_STATUSFLAG_10MAN_HEROIC
flags_dis_map_st += 4;
break;
case 3: // RAID_STATUSFLAG_25MAN_HEROIC
flags_dis_map_st += 8;
break;
}
}
}
string[] checkedIndicies3 = Properties.Settings.Default.FlagsDisableVmap.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int i1 = 0; i1 < checkedIndicies3.Length; i1++)
{
int idx;
if ((int.TryParse(checkedIndicies3[i1], out idx)))
{
switch (idx)
{
case 0: // VMAP_DISABLE_AREAFLAG
flags_dis_vmap_st += 1;
break;
case 1: // VMAP_DISABLE_HEIGHT
flags_dis_vmap_st += 2;
break;
case 2: // VMAP_DISABLE_LOS
flags_dis_vmap_st += 4;
break;
case 3: // VMAP_LIQUIDSTATUS
flags_dis_vmap_st += 8;
break;
}
}
}
Form_MainMenu mainmenu = new Form_MainMenu();
// Prepare SQL
// select insertion columns
string BuildSQLFile;
BuildSQLFile = "INSERT INTO " + form_MM.GetWorldDB() + ".disables ";
BuildSQLFile += "(sourceType, entry, flags, params_0, params_1, comment) ";
//Values
BuildSQLFile += "VALUES " + Environment.NewLine;
BuildSQLFile += "(";
if (textBox_SourceType.Text == "1" /*DISABLE_TYPE_QUEST*/)
{
BuildSQLFile += "1, " + textBox_entry.Text + ", 0" + ", ";
}
else if (textBox_SourceType.Text == "3" /*DISABLE_TYPE_BATTLEGROUND*/)
{
BuildSQLFile += "3, " + textBox_entry.Text + ", 0" + ", ";
}
else if (textBox_SourceType.Text == "4" /*DISABLE_TYPE_ACHIEVEMENT_CRITERIA*/)
{
BuildSQLFile += "4, " + textBox_entry.Text + ", 0" + ", ";
}
else if (textBox_SourceType.Text == "5" /*DISABLE_TYPE_OUTDOORPVP*/)
{
BuildSQLFile += "5, " + textBox_entry.Text + ", 0" + ", ";
}
else if (textBox_SourceType.Text == "7" /*DISABLE_TYPE_MMAP*/)
{
BuildSQLFile += "7, " + textBox_entry.Text + ", 0" + ", ";
}
else if (textBox_SourceType.Text == "8" /*DISABLE_TYPE_LFG_MAP*/)
{
BuildSQLFile += "8, " + textBox_entry.Text + ", 0" + ", ";
}
else
{
BuildSQLFile += textBox_SourceType.Text + ", " + textBox_entry.Text + ", "; // sourceType
}
//BuildSQLFile += textBox_entry.Text + ", "; // entry
if (button_flags_dis_spell.Visible == true)
{
BuildSQLFile += flags_dis_spell_st + ", "; // flags_disable_spell
}
else if (button_flags_dis_map.Visible == true)
{
BuildSQLFile += flags_dis_map_st + ", "; // flags_disable_map
}
else if (button_flags_dis_vmap.Visible == true)
{
BuildSQLFile += flags_dis_vmap_st + ", "; // flags_disable_vmap
}
BuildSQLFile += "'" + textBox_params_0.Text + "', '"; // params_0
BuildSQLFile += textBox_params_1.Text + "', '"; // params_1
BuildSQLFile += textBox_comment.Text + "'); "; // comment
stringSQLShare = BuildSQLFile;
stringEntryShare = textBox_entry.Text;
}
public void SelectMaxPlus1_Quest()
{
GetMySqlConnection();
string query = $"SELECT max(ID) + 1 FROM { form_MM.GetWorldDB() }.quest_template;";
MySqlCommand _command = new MySqlCommand(query, connection);
try
{
connection.Open();
NUD_Entry.Text = _command.ExecuteScalar().ToString();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message, "SpawnCreator", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
connection.Close();
}
}
private void GenerateSqlCode(object sender, EventArgs e)
{
uint quest_flags_st = 0;
string[] checkedIndicies1 = Properties.Settings.Default.QuestFlags.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int i1 = 0; i1 < checkedIndicies1.Length; i1++)
{
int idx;
if ((int.TryParse(checkedIndicies1[i1], out idx)))
{
switch (idx)
{
case 0: quest_flags_st += 0; break; // QUEST_FLAGS_NONE
case 1: quest_flags_st += 1; break; // QUEST_FLAGS_STAY_ALIVE
case 2: quest_flags_st += 2; break; // QUEST_FLAGS_PARTY_ACCEPT
case 3: quest_flags_st += 4; break; // QUEST_FLAGS_EXPLORATION
case 4: quest_flags_st += 8; break; // QUEST_FLAGS_SHARABLE
case 5: quest_flags_st += 16; break; // QUEST_FLAGS_NONE2
case 6: quest_flags_st += 32; break; // QUEST_FLAGS_EPIC
case 7: quest_flags_st += 64; break; // QUEST_FLAGS_RAID
case 8: quest_flags_st += 128; break; // QUEST_FLAGS_TBC
case 9: quest_flags_st += 256; break; // QUEST_FLAGS_DELIVER_MORE
case 10: quest_flags_st += 512; break; // QUEST_FLAGS_HIDDEN_REWARDS
case 11: quest_flags_st += 1024; break; // QUEST_FLAGS__AUTO_REWARDED
case 12: quest_flags_st += 2048; break; // QUEST_FLAGS_TBC_RACES
case 13: quest_flags_st += 4096; break; // QUEST_FLAGS_DAILY
case 14: quest_flags_st += 8192; break; // QUEST_FLAGS_REPEATABLE
case 15: quest_flags_st += 16384; break; // QUEST_FLAGS_UNAVAILABLE
case 16: quest_flags_st += 32768; break; // QUEST_FLAGS_WEEKLY
case 17: quest_flags_st += 65536; break; // QUEST_FLAGS_AUTOCOMPLETE
case 18: quest_flags_st += 131072; break; // QUEST_FLAGS_SPECIAL_ITEM
case 19: quest_flags_st += 262144; break; // QUEST_FLAGS_OBJ_TEXT
case 20: quest_flags_st += 524288; break; // QUEST_FLAGS_AUTO_ACCEPT
case 21: quest_flags_st += 1048576; break; // QUEST_FLAGS_AUTO_SUBMIT
case 22: quest_flags_st += 2097152; break; // QUEST_FLAGS_AUTO_TAKE
}
}
}
// Prepare SQL
// select insertion columns
string BuildSQLFile;
BuildSQLFile = textBox105.Text + " INTO " + form_MM.GetWorldDB() + ".quest_template ";
BuildSQLFile += "(ID, QuestType, QuestLevel, MinLevel, QuestSortID, QuestInfoID, SuggestedGroupNum, RequiredFactionId1, RequiredFactionId2, RequiredFactionValue1, ";
BuildSQLFile += "RequiredFactionValue2, RewardNextQuest, RewardXPDifficulty, RewardMoney, RewardBonusMoney, RewardDisplaySpell, RewardSpell, RewardHonor, ";
BuildSQLFile += "RewardKillHonor, StartItem, Flags, RequiredPlayerKills, RewardItem1, RewardAmount1, RewardItem2, RewardAmount2, RewardItem3, RewardAmount3, RewardItem4, ";
BuildSQLFile += "RewardAmount4, ItemDrop1, ItemDropQuantity1, ItemDrop2, ItemDropQuantity2, ItemDrop3, ItemDropQuantity3, ItemDrop4, ";
BuildSQLFile += "ItemDropQuantity4, RewardChoiceItemID1, RewardChoiceItemQuantity1, RewardChoiceItemID2, RewardChoiceItemQuantity2, RewardChoiceItemID3, ";
BuildSQLFile += "RewardChoiceItemQuantity3, RewardChoiceItemID4, RewardChoiceItemQuantity4, RewardChoiceItemID5, RewardChoiceItemQuantity5, RewardChoiceItemID6, RewardChoiceItemQuantity6, ";
BuildSQLFile += "POIContinent, POIx, POIy, POIPriority, RewardTitle, RewardTalents, RewardArenaPoints, RewardFactionID1, RewardFactionValue1, RewardFactionOverride1, ";
BuildSQLFile += "RewardFactionID2, RewardFactionValue2, RewardFactionOverride2, RewardFactionID3, RewardFactionValue3, RewardFactionOverride3, RewardFactionID4, ";
BuildSQLFile += "RewardFactionValue4, RewardFactionOverride4, RewardFactionID5, RewardFactionValue5, RewardFactionOverride5, TimeAllowed, AllowableRaces, LogTitle, LogDescription, ";
BuildSQLFile += "QuestDescription, AreaDescription, QuestCompletionLog, RequiredNpcOrGo1, RequiredNpcOrGo2, RequiredNpcOrGo3, RequiredNpcOrGo4, RequiredNpcOrGoCount1, ";
BuildSQLFile += "RequiredNpcOrGoCount2, RequiredNpcOrGoCount3, RequiredNpcOrGoCount4, RequiredItemId1, RequiredItemId2, RequiredItemId3, RequiredItemId4, RequiredItemId5, RequiredItemId6, ";
BuildSQLFile += "RequiredItemCount1, RequiredItemCount2, RequiredItemCount3, RequiredItemCount4, RequiredItemCount5, ";
BuildSQLFile += "RequiredItemCount6, Unknown0, ObjectiveText1, ObjectiveText2, ObjectiveText3, ObjectiveText4, VerifiedBuild) ";
// values now
BuildSQLFile += "VALUES \n";
BuildSQLFile += "(";
BuildSQLFile += NUD_Entry.Value + ", "; // ID
BuildSQLFile += textBox2.Text + ", "; // QuestType
BuildSQLFile += textBox3.Text + ", "; // QuestLevel
BuildSQLFile += textBox4.Text + ", "; // MinLevel
BuildSQLFile += textBox8.Text + ", "; // QuestSortID
BuildSQLFile += textBox7.Text + ", "; // QuestInfoID
BuildSQLFile += textBox6.Text + ", "; // SuggestedGroupNum
BuildSQLFile += textBox5.Text + ", "; // RequiredFactionId1
BuildSQLFile += textBox12.Text + ", "; // RequiredFactionId2
BuildSQLFile += textBox11.Text + ", "; // RequiredFactionValue1
BuildSQLFile += textBox10.Text + ", "; // RequiredFactionValue2
BuildSQLFile += textBox9.Text + ", "; // RewardNextQuest
BuildSQLFile += textBox20.Text + ", "; // RewardXPDifficulty
BuildSQLFile += textBox19.Text + ", "; // RewardMoney
BuildSQLFile += textBox18.Text + ", "; // RewardBonusMoney
BuildSQLFile += textBox17.Text + ", "; // RewardDisplaySpell
BuildSQLFile += textBox16.Text + ", "; // RewardSpell
BuildSQLFile += textBox15.Text + ", "; // RewardHonor
BuildSQLFile += textBox14.Text + ", "; // RewardKillHonor
BuildSQLFile += textBox13.Text + ", "; // StartItem
BuildSQLFile += quest_flags_st + ", "; // Flags
BuildSQLFile += textBox40.Text + ", "; // RequiredPlayerKills
BuildSQLFile += textBox39.Text + ", "; // RewardItem1
BuildSQLFile += textBox38.Text + ", "; // RewardAmount1
BuildSQLFile += textBox37.Text + ", "; // RewardItem2
BuildSQLFile += textBox36.Text + ", "; // RewardAmount2
BuildSQLFile += textBox35.Text + ", "; // RewardItem3
BuildSQLFile += textBox34.Text + ", "; // RewardAmount3
BuildSQLFile += textBox33.Text + ", "; // RewardItem4
BuildSQLFile += textBox32.Text + ", "; // RewardAmount4
BuildSQLFile += textBox31.Text + ", "; // ItemDrop1
BuildSQLFile += textBox30.Text + ", "; // ItemDropQuantity1
BuildSQLFile += textBox29.Text + ", "; // ItemDrop2
BuildSQLFile += textBox28.Text + ", "; // ItemDropQuantity2
BuildSQLFile += textBox27.Text + ", "; // ItemDrop3
BuildSQLFile += textBox26.Text + ", "; // ItemDropQuantity3
BuildSQLFile += textBox25.Text + ", "; // ItemDrop4
BuildSQLFile += textBox24.Text + ", "; // ItemDropQuantity4
BuildSQLFile += textBox23.Text + ", "; // RewardChoiceItemID1
BuildSQLFile += textBox22.Text + ", "; // RewardChoiceItemQuantity1
BuildSQLFile += textBox21.Text + ", "; // RewardChoiceItemID2
BuildSQLFile += textBox60.Text + ", "; // RewardChoiceItemQuantity2
BuildSQLFile += textBox59.Text + ", "; // RewardChoiceItemID3
BuildSQLFile += textBox58.Text + ", "; // RewardChoiceItemQuantity3
BuildSQLFile += textBox57.Text + ", "; // RewardChoiceItemID4
BuildSQLFile += textBox56.Text + ", "; // RewardChoiceItemQuantity4
BuildSQLFile += textBox55.Text + ", "; // RewardChoiceItemID5
BuildSQLFile += textBox54.Text + ", "; // RewardChoiceItemQuantity5
BuildSQLFile += textBox53.Text + ", "; // RewardChoiceItemID6
BuildSQLFile += textBox52.Text + ", "; // RewardChoiceItemQuantity6
BuildSQLFile += textBox51.Text + ", "; // POIContinent
BuildSQLFile += textBox50.Text + ", "; // POIx
BuildSQLFile += textBox49.Text + ", "; // POIy
BuildSQLFile += textBox48.Text + ", "; // POIPriority
BuildSQLFile += textBox47.Text + ", "; // RewardTitle
BuildSQLFile += textBox46.Text + ", "; // RewardTalents
BuildSQLFile += textBox45.Text + ", "; // RewardArenaPoints
BuildSQLFile += textBox44.Text + ", "; // RewardFactionID1
BuildSQLFile += textBox43.Text + ", "; // RewardFactionValue1
BuildSQLFile += textBox42.Text + ", "; // RewardFactionOverride1
BuildSQLFile += textBox41.Text + ", "; // RewardFactionID2
BuildSQLFile += textBox80.Text + ", "; // RewardFactionValue2
BuildSQLFile += textBox79.Text + ", "; // RewardFactionOverride2
BuildSQLFile += textBox78.Text + ", "; // RewardFactionID3
BuildSQLFile += textBox77.Text + ", "; // RewardFactionValue3
BuildSQLFile += textBox76.Text + ", "; // RewardFactionOverride3
BuildSQLFile += textBox75.Text + ", "; // RewardFactionID4
BuildSQLFile += textBox74.Text + ", "; // RewardFactionValue4
BuildSQLFile += textBox73.Text + ", "; // RewardFactionOverride4
BuildSQLFile += textBox72.Text + ", "; // RewardFactionID5
BuildSQLFile += textBox71.Text + ", "; // RewardFactionValue5
BuildSQLFile += textBox70.Text + ", "; // RewardFactionOverride5
BuildSQLFile += textBox69.Text + ", "; // TimeAllowed
BuildSQLFile += textBox68.Text + ", "; // AllowableRaces
BuildSQLFile += "'" + textBox67.Text + "', "; // LogTitle
BuildSQLFile += "'" + textBox66.Text + "', "; // LogDescription
BuildSQLFile += "'" + textBox65.Text + "', "; // QuestDescription
BuildSQLFile += "'" + textBox64.Text + "', "; // AreaDescription
BuildSQLFile += "'" + textBox63.Text + "', "; // QuestCompletionLog
BuildSQLFile += textBox62.Text + ", "; // RequiredNpcOrGo1
BuildSQLFile += textBox61.Text + ", "; // RequiredNpcOrGo2
BuildSQLFile += textBox83.Text + ", "; // RequiredNpcOrGo3
BuildSQLFile += textBox81.Text + ", "; // RequiredNpcOrGo4
BuildSQLFile += textBox86.Text + ", "; // RequiredNpcOrGoCount1
BuildSQLFile += textBox85.Text + ", "; // RequiredNpcOrGoCount2
BuildSQLFile += textBox84.Text + ", "; // RequiredNpcOrGoCount3
BuildSQLFile += textBox83.Text + ", "; // RequiredNpcOrGoCount4
BuildSQLFile += textBox90.Text + ", "; // RequiredItemId1
BuildSQLFile += textBox87.Text + ", "; // RequiredItemId2
BuildSQLFile += textBox99.Text + ", "; // RequiredItemId3
BuildSQLFile += textBox96.Text + ", "; // RequiredItemId4
BuildSQLFile += textBox93.Text + ", "; // RequiredItemId5
BuildSQLFile += textBox102.Text + ", "; // RequiredItemId6
BuildSQLFile += textBox89.Text + ", "; // RequiredItemCount1
BuildSQLFile += textBox101.Text + ", "; // RequiredItemCount2
BuildSQLFile += textBox98.Text + ", "; // RequiredItemCount3
BuildSQLFile += textBox95.Text + ", "; // RequiredItemCount4
BuildSQLFile += textBox92.Text + ", "; // RequiredItemCount5
BuildSQLFile += textBox103.Text + ", "; // RequiredItemCount6
BuildSQLFile += textBox88.Text + ", "; // Unknown0
BuildSQLFile += "'" + textBox97.Text + "', "; // ObjectiveText1
BuildSQLFile += "'" + textBox94.Text + "', "; // ObjectiveText2
BuildSQLFile += "'" + textBox91.Text + "', "; // ObjectiveText3
BuildSQLFile += "'" + textBox104.Text + "', "; // ObjectiveText4
BuildSQLFile += textBox100.Text; // VerifiedBuild
BuildSQLFile += "); \n";
//Creature Quest Starter
BuildSQLFile += textBox105.Text + " INTO " + form_MM.GetWorldDB() + ".creature_queststarter ";
BuildSQLFile += "(id, quest) ";
BuildSQLFile += "VALUES \n";
BuildSQLFile += "(";
BuildSQLFile += textBox106.Text + ", "; // Creature Entry
BuildSQLFile += textBox107.Text; // Quest ID
BuildSQLFile += "); \n";
//Creature Quest Ender
BuildSQLFile += textBox105.Text + " INTO " + form_MM.GetWorldDB() + ".creature_questender ";
BuildSQLFile += "(id, quest) ";
BuildSQLFile += "VALUES \n";
BuildSQLFile += "(";
BuildSQLFile += textBox109.Text + ", "; // Creature Entry
BuildSQLFile += textBox108.Text; // Quest ID
BuildSQLFile += "); \n";
stringSQLShare = BuildSQLFile;
stringEntryShare = NUD_Entry.Text;
}