public async Task <string> GetSpellNameById(int id)
{
DataTable dt = await ExecuteQuery("SELECT spellName FROM " + SAI_Editor_Manager.GetSpellTableName() + " WHERE id = '" + id + "'");
if (dt.Rows.Count == 0)
{
return("Spell");
}
return((string)dt.Rows[0]["spellName"]); //! Always take first index; should not be possible to have multiple instances per id, but still
}
public SearchFromDatabaseForm(TextBox textBoxToChange, DatabaseSearchFormType databaseSearchFormType)
{
InitializeComponent();
this.databaseSearchFormType = databaseSearchFormType;
MinimumSize = new Size(Width, Height);
MaximumSize = new Size(Width, Height + 800);
//! If the textboxtochange is null, the search form is called from a place where it's just searching and not using
//! the search results anywhere.
if (textBoxToChange != null)
{
this.textBoxToChange = textBoxToChange;
textBoxCriteria.Text = textBoxToChange.Text;
}
string lootTemplateKey = databaseSearchFormType.ToString().Replace("DatabaseSearchFormType", "").Replace("LootTemplateEntry", "").Replace("LootTemplateItem", "");
switch (databaseSearchFormType)
{
case DatabaseSearchFormType.DatabaseSearchFormTypeSpell:
Text = "Search for a spell";
listViewEntryResults.Columns.Add("Id", 45);
listViewEntryResults.Columns.Add("Name", 284);
comboBoxSearchType.Items.Add("Spell id");
comboBoxSearchType.Items.Add("Spell name");
baseQuery = "SELECT id, spellName FROM " + SAI_Editor_Manager.GetSpellTableName();
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeFaction:
Text = "Search for a faction";
listViewEntryResults.Columns.Add("Id", 45);
listViewEntryResults.Columns.Add("Name", 284);
comboBoxSearchType.Items.Add("Faction id");
comboBoxSearchType.Items.Add("Faction name");
baseQuery = "SELECT m_ID, m_name_lang_1 FROM " + SAI_Editor_Manager.GetFactionsTableName();
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeEmote:
Text = "Search for an emote";
listViewEntryResults.Columns.Add("Id", 45);
listViewEntryResults.Columns.Add("Name", 284);
comboBoxSearchType.Items.Add("Emote id");
comboBoxSearchType.Items.Add("Emote name");
baseQuery = "SELECT field0, field1 FROM " + SAI_Editor_Manager.GetEmotesTableName();
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeQuest:
Text = "Search for a quest";
listViewEntryResults.Columns.Add("Id", 45);
listViewEntryResults.Columns.Add("Name", 284);
comboBoxSearchType.Items.Add("Quest id");
comboBoxSearchType.Items.Add("Quest name");
baseQuery = "SELECT id, title FROM quest_template";
useWorldDatabase = true;
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeMap:
Text = "Search for a map id";
listViewEntryResults.Columns.Add("Id", 45);
listViewEntryResults.Columns.Add("Name", 284);
comboBoxSearchType.Items.Add("Map id");
comboBoxSearchType.Items.Add("Map name");
baseQuery = "SELECT m_ID, m_MapName_lang1 FROM " + SAI_Editor_Manager.GetMapsTableName();
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeAreaOrZone:
Text = "Search for a zone id";
listViewEntryResults.Columns.Add("Id", 45);
listViewEntryResults.Columns.Add("Name", 284);
comboBoxSearchType.Items.Add("Zone id");
comboBoxSearchType.Items.Add("Zone name");
baseQuery = "SELECT m_ID, m_AreaName_lang FROM " + SAI_Editor_Manager.GetAreasAndZonesTableName();
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeCreatureEntry:
Text = "Search for a creature";
listViewEntryResults.Columns.Add("Id", 45);
listViewEntryResults.Columns.Add("Name", 284);
comboBoxSearchType.Items.Add("Creature entry");
comboBoxSearchType.Items.Add("Creature name");
baseQuery = "SELECT entry, name FROM creature_template";
useWorldDatabase = true;
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeGameobjectEntry:
Text = "Search for a gameobject";
listViewEntryResults.Columns.Add("Id", 45);
listViewEntryResults.Columns.Add("Name", 284);
comboBoxSearchType.Items.Add("Gameobject entry");
comboBoxSearchType.Items.Add("Gameobject name");
baseQuery = "SELECT entry, name FROM gameobject_template";
useWorldDatabase = true;
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeSound:
Text = "Search for a sound id";
listViewEntryResults.Columns.Add("Id", 45);
listViewEntryResults.Columns.Add("Name", 284);
comboBoxSearchType.Items.Add("Sound id");
comboBoxSearchType.Items.Add("Sound name");
baseQuery = "SELECT id, name FROM " + SAI_Editor_Manager.GetSoundEntriesTableName();
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeAreaTrigger:
Text = "Search for a sound id";
listViewEntryResults.Columns.Add("Id", 52);
listViewEntryResults.Columns.Add("Mapid", 52);
listViewEntryResults.Columns.Add("X", 75);
listViewEntryResults.Columns.Add("Y", 75);
listViewEntryResults.Columns.Add("Z", 75);
comboBoxSearchType.Items.Add("Areatrigger id");
comboBoxSearchType.Items.Add("Areatrigger map id");
baseQuery = "SELECT m_id, m_mapId, m_posX, m_posY, m_posZ FROM " + SAI_Editor_Manager.GetAreatriggerTableName();
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeCreatureGuid:
Text = "Search for a creature";
listViewEntryResults.Columns.Add("Guid", 45);
listViewEntryResults.Columns.Add("Name", 284);
comboBoxSearchType.Items.Add("Creature guid");
comboBoxSearchType.Items.Add("Creature name");
baseQuery = "SELECT c.guid, ct.name FROM creature c JOIN creature_template ct ON ct.entry = c.id";
useWorldDatabase = true;
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeGameobjectGuid:
Text = "Search for a gameobject";
listViewEntryResults.Columns.Add("Guid", 45);
listViewEntryResults.Columns.Add("Name", 284);
comboBoxSearchType.Items.Add("Gameobject guid");
comboBoxSearchType.Items.Add("Gameobject name");
baseQuery = "SELECT g.guid, gt.name FROM gameobject g JOIN gameobject_template gt ON gt.entry = g.id";
useWorldDatabase = true;
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeGameEvent:
Text = "Search for a game event";
listViewEntryResults.Columns.Add("Entry", 45);
listViewEntryResults.Columns.Add("Description", 284);
comboBoxSearchType.Items.Add("Game event entry");
comboBoxSearchType.Items.Add("Game event description");
baseQuery = "SELECT eventEntry, description FROM game_event";
useWorldDatabase = true;
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeItemEntry:
Text = "Search for an item";
listViewEntryResults.Columns.Add("Id", 45);
listViewEntryResults.Columns.Add("Name", 284);
comboBoxSearchType.Items.Add("Item id");
comboBoxSearchType.Items.Add("Item name");
baseQuery = "SELECT entry, name FROM item_template";
useWorldDatabase = true;
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeSummonsId:
Text = "Search for a summons id";
listViewEntryResults.Columns.Add("Owner", 63);
listViewEntryResults.Columns.Add("Entry", 63);
listViewEntryResults.Columns.Add("Group", 66);
listViewEntryResults.Columns.Add("Type", 66);
listViewEntryResults.Columns.Add("Time", 66);
comboBoxSearchType.Items.Add("Owner entry");
comboBoxSearchType.Items.Add("Target entry");
baseQuery = "SELECT summonerId, entry, groupId, summonType, summonTime FROM creature_summon_groups";
useWorldDatabase = true;
listViewItemIndexToCopy = 2;
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeTaxiPath:
Text = "Search for a taxi path";
listViewEntryResults.Columns.Add("Id", 45);
listViewEntryResults.Columns.Add("Name", 284);
comboBoxSearchType.Items.Add("Taxi id");
comboBoxSearchType.Items.Add("Taxi name");
baseQuery = "SELECT id, taxiName FROM taxi_nodes";
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeEquipTemplate:
Text = "Search for creature equipment";
listViewEntryResults.Columns.Add("Entry", 63);
listViewEntryResults.Columns.Add("Id", 63);
listViewEntryResults.Columns.Add("Item 1", 66);
listViewEntryResults.Columns.Add("Item 2", 66);
listViewEntryResults.Columns.Add("Item 3", 66);
comboBoxSearchType.Items.Add("Entry");
comboBoxSearchType.Items.Add("Item entries");
baseQuery = "SELECT entry, id, itemEntry1, itemEntry2, itemEntry3 FROM creature_equip_template";
useWorldDatabase = true;
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeWaypoint:
Text = "Search for a waypoints path";
listViewEntryResults.Columns.Add("Entry", 52);
listViewEntryResults.Columns.Add("Point", 52);
listViewEntryResults.Columns.Add("X", 75);
listViewEntryResults.Columns.Add("Y", 75);
listViewEntryResults.Columns.Add("Z", 75);
comboBoxSearchType.Items.Add("Creature entry");
baseQuery = "SELECT entry, pointid, position_x, position_y, position_z FROM waypoints";
useWorldDatabase = true;
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeNpcText:
Text = "Search for an npc_text entry";
listViewEntryResults.Columns.Add("Id", 45);
listViewEntryResults.Columns.Add("Text", 284);
comboBoxSearchType.Items.Add("Id");
comboBoxSearchType.Items.Add("Text");
baseQuery = "SELECT id, text0_0 FROM npc_text";
useWorldDatabase = true;
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeGossipMenuOptionId:
listViewItemIndexToCopy = 1;
goto case DatabaseSearchFormType.DatabaseSearchFormTypeGossipMenuOptionMenuId;
case DatabaseSearchFormType.DatabaseSearchFormTypeGossipMenuOptionMenuId:
Text = "Search for a gossip item";
listViewEntryResults.Columns.Add("Menu id", 55);
listViewEntryResults.Columns.Add("Id", 35);
listViewEntryResults.Columns.Add("Text", 239);
comboBoxSearchType.Items.Add("Menu");
comboBoxSearchType.Items.Add("Id");
comboBoxSearchType.Items.Add("Text");
baseQuery = "SELECT menu_id, id, option_text FROM gossip_menu_option";
useWorldDatabase = true;
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeSkill:
Text = "Search for a skill";
listViewEntryResults.Columns.Add("Id", 45);
listViewEntryResults.Columns.Add("Name", 284);
comboBoxSearchType.Items.Add("Skill id");
comboBoxSearchType.Items.Add("Skill name");
baseQuery = "SELECT id, name FROM " + SAI_Editor_Manager.GetSkillsTableName();
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeAchievement:
Text = "Search for an achievement";
listViewEntryResults.Columns.Add("Id", 45);
listViewEntryResults.Columns.Add("Name", 284);
comboBoxSearchType.Items.Add("Achievement id");
comboBoxSearchType.Items.Add("Achievement name");
baseQuery = "SELECT id, name FROM " + SAI_Editor_Manager.GetAchievementsTableName();
break;
case DatabaseSearchFormType.DatabaseSearchFormTypePlayerTitles:
Text = "Search for a title";
listViewEntryResults.Columns.Add("Id", 45);
listViewEntryResults.Columns.Add("Name", 284);
comboBoxSearchType.Items.Add("Title id");
comboBoxSearchType.Items.Add("Title");
baseQuery = "SELECT id, title FROM " + SAI_Editor_Manager.GetPlayerTitlesTableName();
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeSmartScriptId:
listViewItemIndexToCopy = 1;
goto case DatabaseSearchFormType.DatabaseSearchFormTypeSmartScriptEntryOrGuid;
case DatabaseSearchFormType.DatabaseSearchFormTypeSmartScriptSourceType:
listViewItemIndexToCopy = 2;
goto case DatabaseSearchFormType.DatabaseSearchFormTypeSmartScriptEntryOrGuid;
case DatabaseSearchFormType.DatabaseSearchFormTypeSmartScriptEntryOrGuid:
useWorldDatabase = true;
Text = "Search for a smart script";
listViewEntryResults.Columns.Add("Entryorguid", 75);
listViewEntryResults.Columns.Add("Id", 75);
listViewEntryResults.Columns.Add("Sourcetype", 75);
listViewEntryResults.Columns.Add("Event", 52);
listViewEntryResults.Columns.Add("Action", 52);
comboBoxSearchType.Items.Add("Smart script id");
comboBoxSearchType.Items.Add("Smart script entryorguid");
baseQuery = "SELECT entryorguid, id, source_type, event_type, action_type FROM smart_scripts";
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeVendorItemEntry:
listViewItemIndexToCopy = 1;
goto case DatabaseSearchFormType.DatabaseSearchFormTypeVendorEntry;
case DatabaseSearchFormType.DatabaseSearchFormTypeVendorEntry:
useWorldDatabase = true;
Text = "Search for a vendor (item) entry";
listViewEntryResults.Columns.Add("Vendor entry", 164);
listViewEntryResults.Columns.Add("Item entry", 164);
comboBoxSearchType.Items.Add("Vendor entry");
comboBoxSearchType.Items.Add("Vendor item entry");
baseQuery = "SELECT entry, item FROM npc_vendor";
break;
case DatabaseSearchFormType.DatabaseSearchFormTypeCreatureLootTemplateItem:
case DatabaseSearchFormType.DatabaseSearchFormTypeDisenchantLootTemplateItem:
case DatabaseSearchFormType.DatabaseSearchFormTypeFishingLootTemplateItem:
case DatabaseSearchFormType.DatabaseSearchFormTypeGameobjectLootTemplateItem:
case DatabaseSearchFormType.DatabaseSearchFormTypeItemLootTemplateItem:
case DatabaseSearchFormType.DatabaseSearchFormTypeMailLootTemplateItem:
case DatabaseSearchFormType.DatabaseSearchFormTypeMillingLootTemplateItem:
case DatabaseSearchFormType.DatabaseSearchFormTypePickpocketingLootTemplateItem:
case DatabaseSearchFormType.DatabaseSearchFormTypeProspectingLootTemplateItem:
case DatabaseSearchFormType.DatabaseSearchFormTypeReferenceLootTemplateItem:
case DatabaseSearchFormType.DatabaseSearchFormTypeSkinningLootTemplateItem:
case DatabaseSearchFormType.DatabaseSearchFormTypeSpellLootTemplateItem:
listViewItemIndexToCopy = 1;
goto case DatabaseSearchFormType.DatabaseSearchFormTypeLootTemplateBase;
case DatabaseSearchFormType.DatabaseSearchFormTypeDisenchantLootTemplateEntry:
case DatabaseSearchFormType.DatabaseSearchFormTypeCreatureLootTemplateEntry:
case DatabaseSearchFormType.DatabaseSearchFormTypeFishingLootTemplateEntry:
case DatabaseSearchFormType.DatabaseSearchFormTypeGameobjectLootTemplateEntry:
case DatabaseSearchFormType.DatabaseSearchFormTypeItemLootTemplateEntry:
case DatabaseSearchFormType.DatabaseSearchFormTypeMailLootTemplateEntry:
case DatabaseSearchFormType.DatabaseSearchFormTypeMillingLootTemplateEntry:
case DatabaseSearchFormType.DatabaseSearchFormTypePickpocketingLootTemplateEntry:
case DatabaseSearchFormType.DatabaseSearchFormTypeProspectingLootTemplateEntry:
case DatabaseSearchFormType.DatabaseSearchFormTypeReferenceLootTemplateEntry:
case DatabaseSearchFormType.DatabaseSearchFormTypeSkinningLootTemplateEntry:
case DatabaseSearchFormType.DatabaseSearchFormTypeSpellLootTemplateEntry:
case DatabaseSearchFormType.DatabaseSearchFormTypeLootTemplateBase:
Text = "Search for a loot template";
listViewEntryResults.Columns.Add("Loot entry", 164);
listViewEntryResults.Columns.Add("Item entry", 164);
comboBoxSearchType.Items.Add("Loot entry");
comboBoxSearchType.Items.Add("Item entry");
baseQuery = "SELECT entry, item FROM " + lootTemplateKey + "_loot_template";
useWorldDatabase = true;
break;
default:
MessageBox.Show("Unknown database search type!", "Something went wrong...", MessageBoxButtons.OK, MessageBoxIcon.Error);
break;
}
string[] columnsSplit = baseQuery.Replace("SELECT ", "").Replace(" FROM " + baseQuery.Split(' ').LastOrDefault(), "").Split(',');
columns = new string[columnsSplit.Length + 1];
for (int i = 0; i < columnsSplit.Length; ++i)
{
columns[i] = columnsSplit[i];
}
amountOfListviewColumns = columns.Length - 1;
comboBoxSearchType.SelectedIndex = 0;
FillListView(true);
}
private async void FillListViewWithAreaTriggers(string idFilter, string mapIdFilter, bool limit)
{
if (_cts != null)
{
_cts.Dispose();
}
_cts = new CancellationTokenSource();
try
{
string queryToExecute = "SELECT * FROM " + SAI_Editor_Manager.GetAreatriggerTableName();
if (idFilter.Length > 0 || mapIdFilter.Length > 0)
{
if (checkBoxFieldContainsCriteria.Checked)
{
if (idFilter.Length > 0)
{
queryToExecute += " WHERE id LIKE '%" + idFilter + "%'";
if (mapIdFilter.Length > 0)
{
queryToExecute += " AND mapId LIKE '%" + mapIdFilter + "%'";
}
}
else if (mapIdFilter.Length > 0)
{
queryToExecute += " WHERE mapId LIKE '%" + mapIdFilter + "%'";
if (idFilter.Length > 0)
{
queryToExecute += " AND id LIKE '%" + idFilter + "%'";
}
}
}
else
{
if (idFilter.Length > 0)
{
queryToExecute += " WHERE id = " + idFilter;
if (mapIdFilter.Length > 0)
{
queryToExecute += " AND mapId = " + mapIdFilter;
}
}
else if (mapIdFilter.Length > 0)
{
queryToExecute += " WHERE mapId = " + mapIdFilter;
if (idFilter.Length > 0)
{
queryToExecute += " AND id = " + idFilter;
}
}
}
}
if (limit)
{
queryToExecute += " LIMIT 1000";
}
DataTable dt = await SAI_Editor_Manager.Instance.sqliteDatabase.ExecuteQueryWithCancellation(_cts.Token, queryToExecute);
if (dt.Rows.Count > 0)
{
List <Item> items = new List <Item>();
foreach (DataRow row in dt.Rows)
{
if (_cts.IsCancellationRequested)
{
break;
}
AreaTrigger areaTrigger = SAI_Editor_Manager.Instance.sqliteDatabase.BuildAreaTrigger(row);
if (!checkBoxHasAiName.Checked || await SAI_Editor_Manager.Instance.worldDatabase.AreaTriggerHasSmartAI(areaTrigger.id))
{
items.Add(new Item {
ItemName = areaTrigger.id.ToString(), SubItems = new List <string> {
areaTrigger.map_id.ToString(), areaTrigger.posX.ToString(), areaTrigger.posY.ToString(), areaTrigger.posZ.ToString()
}
});
}
}
AddItemToListView(listViewEntryResults, items);
}
}
catch (MySqlException)
{
MessageBox.Show("Something went wrong retrieving the results from your database.", "Something went wrong!", MessageBoxButtons.OK, MessageBoxIcon.Error);
StopRunningThread();
}
}