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=" + mainmenu.textbox_mysql_hostname.Text + ";port=" + mainmenu.textbox_mysql_port.Text + ";username="******";password="******"REPLACE INTO " + mainmenu.textbox_mysql_worldDB.Text + ".creature_text " +
"(entry, text, type, probability, language) " +
"VALUES (" +
textBox61.Text + ", '" + // entry
textBox2.Text + "', " + // text
textBox4.Text + ", " + // type
textBox10.Text + ", " + // probability
textBox1.Text + ");" + // language
"REPLACE INTO " + mainmenu.textbox_mysql_worldDB.Text + ".smart_scripts " +
"(entryorguid, event_type, action_type, event_chance, event_param1, event_param2, event_param3, event_param4) " +
"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 + ");" // event_param4
;
connection.Open();
MySqlCommand command = new MySqlCommand(insertQuery, connection);
// Test
try
{
if (command.ExecuteNonQuery() == 1)
{
label9.Visible = true;
}
else
{
label9.Visible = true;
//MessageBox.Show("Data Not Inserted");
//label2.ForeColor = Color.Red;
//label2.Text = "Eroare!";
//MessageBox.Show("Unable to connect to any of the specified MySQL hosts.");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
connection.Close();
}
private void timer1_Tick(object sender, EventArgs e)
{
Form_MainMenu mainmenu = new Form_MainMenu();
try
{
string myConnection = "datasource=" + mainmenu.textbox_mysql_hostname.Text + ";port=" + mainmenu.textbox_mysql_port.Text + ";username="******";password="******"select * from auth.account;");
MySqlCommandBuilder cb = new MySqlCommandBuilder(myDataAdapter);
myConn.Open();
DataSet ds = new DataSet();
label_mysql_status2.Text = "Connected!";
label_mysql_status2.ForeColor = Color.LawnGreen;
myConn.Close();
}
catch (Exception /*ex*/)
{
//MessageBox.Show(ex.Message);
label_mysql_status2.Text = "Connection Lost - MySQL is not running";
label_mysql_status2.ForeColor = Color.Red;
}
}
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=" + mainmenu.textbox_mysql_hostname.Text + ";port=" + mainmenu.textbox_mysql_port.Text + ";username="******";password="******"INSERT INTO " + mainmenu.textbox_mysql_worldDB.Text + ".creature_loot_template " +
"(Entry, Item, Reference, Chance, QuestRequired, LootMode, GroupId, MinCount, MaxCount, Comment) " +
"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
"');";
connection.Open();
MySqlCommand command = new MySqlCommand(insertQuery, connection);
// Test
try
{
if (command.ExecuteNonQuery() == 1)
{
label9.Visible = true;
}
else
{
label9.Visible = true;
//MessageBox.Show("Data Not Inserted");
//label2.ForeColor = Color.Red;
//label2.Text = "Eroare!";
//MessageBox.Show("Unable to connect to any of the specified MySQL hosts.");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
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=" + mainmenu.textbox_mysql_hostname.Text + ";port=" + mainmenu.textbox_mysql_port.Text + ";username="******";password="******"INSERT INTO " + mainmenu.textbox_mysql_worldDB.Text + ".npc_vendor " +
"(entry, slot, item, maxcount, incrtime, ExtendedCost, VerifiedBuild) " +
"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);
// Test
try
{
if (command.ExecuteNonQuery() == 1)
{
label9.Visible = true;
}
else
{
label9.Visible = true;
//MessageBox.Show("Data Not Inserted");
//label2.ForeColor = Color.Red;
//label2.Text = "Eroare!";
//MessageBox.Show("Unable to connect to any of the specified MySQL hosts.");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
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 button1_Click(object sender, EventArgs e)
{
Form_MainMenu mainmenu = new Form_MainMenu();
if (textBox5.Text == "")
{
MessageBox.Show("Option Text should not be empty", "Error");
return;
}
MySqlConnection connection = new MySqlConnection("datasource=" + mainmenu.textbox_mysql_hostname.Text + ";port=" + mainmenu.textbox_mysql_port.Text + ";username="******";password="******"INSERT INTO " + mainmenu.textbox_mysql_worldDB.Text + ".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) " +
"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
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 button_execute_query_Click(object sender, EventArgs e)
{
Form_ItemCreator frm = new Form_ItemCreator();
if (frm.textBox1.Text == "")
{
MessageBox.Show("Entry column should not be empty", "Error");
return;
}
//Clipboard.SetText(Form_ItemCreator.stringSQLShare);
Form_MainMenu mainmenu = new Form_MainMenu();
MySqlConnection connection = new MySqlConnection("datasource=" + mainmenu.textbox_mysql_hostname.Text + ";port=" + mainmenu.textbox_mysql_port.Text + ";username="******";password="******"Data Not Inserted");
//label2.ForeColor = Color.Red;
//label2.Text = "Eroare!";
//MessageBox.Show("Unable to connect to any of the specified MySQL hosts.");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
connection.Close();
}
private void button_execute_query_Click(object sender, EventArgs e)
{
Form_ItemCreator frm = new Form_ItemCreator();
if (frm.NUD_item_Entry.Text == "")
{
MessageBox.Show("Entry column should not be empty", "Error");
return;
}
//Clipboard.SetText(Form_ItemCreator.stringSQLShare);
Form_MainMenu mainmenu = new Form_MainMenu();
MySqlConnection connection = new MySqlConnection(
"datasource=" + form_MM.GetHost() + ";" +
"port=" + form_MM.GetPort() + ";" +
"username="******";" +
"password="******";"
);
string insertQuery = Form_ItemCreator.stringSQLShare;
connection.Open();
MySqlCommand command = new MySqlCommand(insertQuery, connection);
// Test
try
{
//frm.label_query_executed_successfully.Visible = true;
if (command.ExecuteNonQuery() == 1)
{
// this.Close();
//frm.label83.ForeColor = Color.GreenYellow;
label_query_executed_successfully.Visible = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
connection.Close();
}
public ControlPanel(Form_MainMenu form_MainMenu)
{
InitializeComponent();
form_MM = form_MainMenu;
}
public GenerateLoot(Form_MainMenu form_MainMenu)
{
InitializeComponent();
form_MM = form_MainMenu;
}
public Spawn_NPC(Form_MainMenu form_MainMenu)
{
InitializeComponent();
form_MM = form_MainMenu;
}
public AddGossipMenus(Form_MainMenu _form_MainMenu)
{
InitializeComponent();
form_MM = _form_MainMenu;
}
public BackToMainMenu(Form_MainMenu form_MainMenu)
{
InitializeComponent();
form_MM = form_MainMenu;
}
private void BackToMainMenu_Load(object sender, EventArgs e)
{
Form_MainMenu mainmenu = new Form_MainMenu();
label_version.Text = mainmenu.version;
//try
//{
// string myConnection = "datasource=" + mainmenu.textbox_mysql_hostname.Text + ";port=" + mainmenu.textbox_mysql_port.Text + ";username="******";password="******"Connected!";
// form_itemCreator.label_mysql_status2.ForeColor = Color.LawnGreen;
// label_mysql_status.Text = "Connected!";
// label_mysql_status.ForeColor = Color.LawnGreen;
// mainmenu.textbox_mysql_username.Visible = true;
// mainmenu.textbox_mysql_pass.Visible = true;
//mainmenu.tabControl1.Visible = false;
if (form_MM.CB_NoMySQL.Checked)
{
//Start without mysql con
label_mysql_status.Visible = false;
label85.Visible = false;
timer1.Start();
timer2.Stop();
}
else
{
label_mysql_status.Visible = true;
label85.Visible = true;
timer1.Stop();
timer2.Start();
}
// myConn.Close();
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message);
//}
}
private void button1_Click(object sender, EventArgs e)
{
Form_MainMenu mainmenu = new Form_MainMenu();
if (textBox1.Text == "")
{
MessageBox.Show("Mount Model ID should not be empty", "Error");
return;
}
if (textBox65.Text == "")
{
MessageBox.Show("Path ID should not be empty", "Error");
return;
}
if (textBox2.Text == "")
{
MessageBox.Show("Bytes1 should not be empty", "Error");
return;
}
if (textBox4.Text == "")
{
MessageBox.Show("Bytes2 should not be empty", "Error");
return;
}
MySqlConnection connection = new MySqlConnection("datasource=" + mainmenu.textbox_mysql_hostname.Text + ";port=" + mainmenu.textbox_mysql_port.Text + ";username="******";password="******"REPLACE INTO " + mainmenu.textbox_mysql_worldDB.Text + ".creature_template_addon " +
"(entry, path_id, mount, bytes1, bytes2, emote, auras) " +
"VALUES (" +
textBox61.Text + ", " + // entry
textBox65.Text + ", " + // path_id
textBox1.Text + ", " + // mount
textBox2.Text + ", " + // bytes1
textBox4.Text + ", " + // bytes2
textBox3.Text + ", '" + // emote
textBox5.Text + // auras
"');";
connection.Open();
MySqlCommand command = new MySqlCommand(insertQuery, connection);
// Test
try
{
if (command.ExecuteNonQuery() == 1)
{
label9.Visible = true;
}
else
{
label9.Visible = true;
//MessageBox.Show("Data Not Inserted");
//label2.ForeColor = Color.Red;
//label2.Text = "Eroare!";
//MessageBox.Show("Unable to connect to any of the specified MySQL hosts.");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
connection.Close();
}
public MakeNpcSay(Form_MainMenu _form_MainMenu)
{
InitializeComponent();
form_MM = _form_MainMenu;
}
public AccountCreator(Form_MainMenu form_MainMenu)
{
InitializeComponent();
form_MM = form_MainMenu;
}
public Disable_Form(Form_MainMenu form_MainMenu)
{
InitializeComponent();
form_MM = form_MainMenu;
}
public MountNPC(Form_MainMenu _form_MainMenu)
{
InitializeComponent();
form_MM = _form_MainMenu;
}
public QuestTemplate(Form_MainMenu form_MainMenu)
{
InitializeComponent();
form_MM = form_MainMenu;
}
private void label83_Click(object sender, EventArgs e)
{
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 " + mainmenu.textbox_mysql_worldDB.Text + ".disables ";
BuildSQLFile += "(sourceType, entry, flags, params_0, params_1, comment)";
//Values
BuildSQLFile += "VALUES\n ";
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;
if (textBox_entry.Text == "0")
{
MessageBox.Show("Entry should not be 0", "Error");
return;
}
else if (textBox_entry.Text == "")
{
MessageBox.Show("Entry should not be empty", "Error");
return;
}
using (var sfd = new SaveFileDialog())
{
sfd.Filter = "sql files (*.sql)|*.sql";
sfd.FilterIndex = 2;
sfd.FileName = "Disable_" + stringEntryShare;
if (sfd.ShowDialog() == DialogResult.OK)
{
File.WriteAllText(sfd.FileName, stringSQLShare);
label88.Visible = true;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
Form_MainMenu mainmenu = new Form_MainMenu();
if (textBox1.Text == "")
{
MessageBox.Show("Mount Model ID should not be empty", "Error");
return;
}
if (textBox65.Text == "")
{
MessageBox.Show("Path ID should not be empty", "Error");
return;
}
if (textBox2.Text == "")
{
MessageBox.Show("Bytes1 should not be empty", "Error");
return;
}
if (textBox4.Text == "")
{
MessageBox.Show("Bytes2 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_template_addon " +
"(entry, path_id, mount, bytes1, bytes2, emote, auras) " +
"VALUES (" +
textBox61.Text + ", " + // entry
textBox65.Text + ", " + // path_id
textBox1.Text + ", " + // mount
textBox2.Text + ", " + // bytes1
textBox4.Text + ", " + // bytes2
textBox3.Text + ", '" + // emote
textBox5.Text + // auras
"');";
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();
}
}
public AddVendorItems(Form_MainMenu form_MainMenu)
{
InitializeComponent();
form_MM = form_MainMenu;
}
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 SaveOptionsDialog(Form_MainMenu form_MainMenu)
{
InitializeComponent();
form_MM = form_MainMenu;
}
