예제 #1
0
        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
        }
예제 #2
0
        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);
        }