private void Write_Click(object sender, EventArgs e)
{
uint[] SpellFamilyFlags = _tvFamilyTree.GetMask();
// spell comment
var comment = String.Format("-- ({0}) {1}", ProcInfo.SpellProc.ID, ProcInfo.SpellProc.SpellNameRank);
// drop query
var drop = String.Format("DELETE FROM `spell_proc_event` WHERE `entry` IN ({0});", ProcInfo.SpellProc.ID);
// insert query
var insert = String.Format("INSERT INTO `spell_proc_event` VALUES ({0}, 0x{1:X2}, 0x{2:X2}, 0x{3:X8}, 0x{4:X8}, 0x{5:X8}, 0x{6:X8}, 0x{7:X8}, 0x{8:X8}, 0x{9:X8}, 0x{10:X8}, 0x{11:X8}, 0x{12:X8}, 0x{13:X8}, {14}, {15}, {16});",
ProcInfo.SpellProc.ID,
_clbSchools.GetFlagsValue(),
_cbProcFitstSpellFamily.SelectedValue.ToUInt32(),
SpellFamilyFlags[0],
0, 0,
SpellFamilyFlags[1],
0, 0,
SpellFamilyFlags[2],
0, 0,// пока что так, пока не пойму как...
_clbProcFlags.GetFlagsValue(),
_clbProcFlagEx.GetFlagsValue(),
_tbPPM.Text.Replace(',', '.'),
_tbChance.Text.Replace(',', '.'),
_tbCooldown.Text.Replace(',', '.'));
_rtbSqlLog.AppendText(comment + "\r\n" + drop + "\r\n" + insert + "\r\n\r\n");
_rtbSqlLog.ColorizeCode();
if (MySQLConnect.Connected)
{
MySQLConnect.Insert(drop + insert);
}
((Button)sender).Enabled = false;
}
private void SqlToBase_Click(object sender, EventArgs e)
{
if (MySQLConnect.Connected)
{
MySQLConnect.Insert(_rtbSqlLog.Text);
}
else
{
MessageBox.Show("Can't connect to database!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
