private void ShowForm(object sender, EventArgs e) { switch (_bType) { case BType.SPELL: { FormSearchSpell _form = new FormSearchSpell(ComboboxValue); _form.ShowDialog(); if (_form.DialogResult == DialogResult.OK) { _combobox.SetValue(_form.Spell.ID); } _form.Dispose(); } break; case BType.FLAG: { FormCalculateFlags _form = new FormCalculateFlags(_type, ComboboxValue, String.Empty); _form.ShowDialog(); if (_form.DialogResult == DialogResult.OK) { _combobox.SetValue(_form.Flags); } _form.Dispose(); } break; case BType.TEXT: { MySQLConnenct.SelectAIText(); ParentForm._tPanel.SelectedIndex = 1; } break; case BType.SUMMON: { MySQLConnenct.SelectAIText(); ParentForm._tPanel.SelectedIndex = 2; } break; default: { FormDbSearch _form = new FormDbSearch(_bType, ComboboxValue); _form.ShowDialog(); if (_form.DialogResult == DialogResult.OK) { _combobox.SetValue(_form.Value); } _form.Dispose(); } break; } if (_comboboxAdditional != null) { _comboboxAdditional.SetValue(_additionalValue); } }
private void _lvGossip_menu_SelectedIndexChanged(object sender, EventArgs e) { _tbCreatureGossip.Clear(); if (_lvGossip_menu.SelectedIndices.Count > 0) { GossipMenu GossipCreature = MySQLConnenct.GossipMenu[_lvGossip_menu.SelectedIndices[0]]; MySQLConnenct.SelectGossipCrearture(GossipCreature.Entry, 0); if (MySQLConnenct.GossipMenuCreature.Count > 0) { _lvGossip_Creature.Visible = true; _lblnpctext.Visible = false; _lvGossip_Creature.VirtualListSize = MySQLConnenct.GossipMenuCreature.Count; _lvGossip_Creature.Refresh(); StringBuilder sb = new StringBuilder(); for (int i = 0; i < _lvGossip_Creature.VirtualListSize; i++) { if (i > -1) { if (i != (_lvGossip_Creature.VirtualListSize)) { sb.Append(","); sb.Append(_lvGossip_Creature.Items[i].Text); } else { sb.Append(_lvGossip_Creature.Items[i].Text); } } } sb.Remove(0, 1); _tbCreatureGossip.Text = sb.ToString(); } else { _lvGossip_Creature.Visible = false; _lblnpctext.Visible = true; } _tbGossipEntry.Text = GossipCreature.Entry.ToString(); _GossipTextID.Text = GossipCreature.TextID.ToString(); _cbGossipCondtion_1.SelectedValue = GossipCreature.cond_1; _cbCondtion1Value_1.SetValue(GossipCreature.cond_1_val_1); _cbCondtion1Value_2.SetValue(GossipCreature.cond_1_val_2); _cbGossipCondtion_2.SelectedValue = GossipCreature.cond_2; _cbCondtion2Value_1.SetValue(GossipCreature.cond_2_val_1); _cbCondtion2Value_2.SetValue(GossipCreature.cond_2_val_2); MySQLConnenct.SelectNpcText(GossipCreature.TextID); _lvNpc_text.VirtualListSize = MySQLConnenct.npc_text.Count; _lvNpc_text.Refresh(); } }
private void _bFilterMenuOption_Click(object sender, EventArgs e) { if (_rbGossipMenuOption.Checked) { if (_tbfilterGossipMenu.Text.Length > 0) { MySQLConnenct.SelectGossipOption(_tbfilterGossipMenu.Text.ToInt32()); } else { MySQLConnenct.SelectGossipOption(0); } _lvGossip_Option.VirtualListSize = MySQLConnenct.GossipMenuOption.Count; _lvGossip_Option.Refresh(); } }
private void _bGossipSearch_Click(object sender, EventArgs e) { if (_rbTextID.Checked) { if (_tbFilterGossip.Text.Length > 0) { MySQLConnenct.SelectNpcText(_tbFilterGossip.Text.ToInt32()); } else { MySQLConnenct.SelectNpcText(0); } _lvNpc_text.VirtualListSize = MySQLConnenct.npc_text.Count; _lvNpc_text.Refresh(); } else if (_rbGossip.Checked) { if (_tbFilterGossip.Text.Length > 0) { MySQLConnenct.SelectGossip(_tbFilterGossip.Text.ToInt32()); } else { MySQLConnenct.SelectGossip(0); } _lvGossip_menu.VirtualListSize = MySQLConnenct.GossipMenu.Count; _lvGossip_menu.Refresh(); } else { if (_tbFilterGossip.Text.Length > 0) { MySQLConnenct.SelectGossipCrearture(0, _tbFilterGossip.Text.ToInt32()); } else { MySQLConnenct.SelectGossipCrearture(0, 0); } _lvGossip_Creature.VirtualListSize = MySQLConnenct.GossipMenuCreature.Count; _lvGossip_Creature.Refresh(); } }
private void CreateQuery() { int id = _tbFilterNum.GetIntValue(); int creature = _tbFilterCreat.GetIntValue(); int etype = _cbFilteEventType.GetIntValue(); int atype = _cbFilteActionType.GetIntValue(); string fquery = "SELECT * FROM `creature_ai_scripts` WHERE "; string squery = ""; squery += (id > 0) ? String.Format("id = {0} || ", id) : ""; squery += (creature > 0) ? String.Format("creature_id = {0} || ", creature) : ""; squery += (etype > -1) ? String.Format("event_type = {0} || ", etype) : ""; squery += (atype > -1) ? String.Format("action1_type = {0} || action2_type = {0} || action3_type = {0} || ", atype) : ""; string q = (squery.Length == 0) ? fquery.Remove(fquery.Length - 6) : fquery + squery.Remove(squery.Length - 3); MySQLConnenct.SelectAIScript(q); _lvScripts.VirtualListSize = MySQLConnenct.AIScript.Count; }
public static void FillColumnsFromDatabase(this ListView lv, string sTable) { lv.Columns.Clear(); lv.View = View.Details; StringCollection fldCol = new StringCollection(); fldCol = MySQLConnenct.GetColumns(sTable); if (fldCol == null) { return; } foreach (string Column in fldCol) { ColumnHeader ch = new ColumnHeader(); ch.Text = Column; lv.Columns.Add(ch); } }
private void button5_Click(object sender, EventArgs e) { using (StreamWriter sw = new StreamWriter("log.sql", true, Encoding.UTF8)) sw.WriteLine(rtbTextOut.Text); MySQLConnenct.Insert(rtbTextOut.Text); }
private void _bSummonSearch_Click(object sender, EventArgs e) { MySQLConnenct.SelectAISummon(); _lvSummon.VirtualListSize = MySQLConnenct.AISummon.Count; }
private void _bTextSearch_Click(object sender, EventArgs e) { MySQLConnenct.SelectAIText(); _lvText.VirtualListSize = MySQLConnenct.AIText.Count; }
private void bNpcTextRecord_Click(object sender, EventArgs e) { using (StreamWriter sw = new StreamWriter("NEW_NPC_TEXT_SQL.sql", true, Encoding.UTF8)) sw.WriteLine(_gpText.Text); MySQLConnenct.Insert(_gpText.Text); }
private void _bFilterNpcText_Click(object sender, EventArgs e) { MySQLConnenct.SelectNpcText(_tbFilterNpcText.Text.ToInt32()); _lvNpcText.VirtualListSize = MySQLConnenct.npc_text.Count; _lvNpcText.Refresh(); }
private void _bGossipOptionRecord_Click(object sender, EventArgs e) { using (StreamWriter sw = new StreamWriter("NEW_GOSSIP_SQL.sql", true, Encoding.UTF8)) sw.WriteLine(rtbGossipOptionMenuOut.Text); MySQLConnenct.Insert(rtbGossipOptionMenuOut.Text); }
private void _bWriteSummon_Click(object sender, EventArgs e) { using (StreamWriter sw = new StreamWriter("NEW_EVENTAI_SQL.sql", true, Encoding.UTF8)) sw.WriteLine(_rtbSummon.Text); MySQLConnenct.Insert(_rtbSummon.Text); }
private void WriteFiles_Click(object sender, EventArgs e) { using (StreamWriter sw = new StreamWriter("NEW_EVENTAI_SQL.sql", true, Encoding.UTF8)) sw.WriteLine(rtbScriptOut.Text); MySQLConnenct.Insert(rtbScriptOut.Text); }