-- #################################################
-- ########## Double Icon Creator ##################
-- #################################################
-- ### By Frathir #### ####### # ###
-- ######################################


-- Creates an icon for a spell AND an item

-- INCLUDES DATABASE SELECTORS

-- dbc file update checklist (you need to update these for the icon to show ingame)
    /*
        itemDisplayInfo.dbc
        item.dbc (remember to run the update item.dbc query first)
        spellIcon.dbc
    */

-- INPUT Name here:
    SET
        @omega_blp_file_name := 'spell_deathknight_frostfever'; -- NO path, NO file type suffix
            -- LIKE THIS: 'spell_deathknight_frostfever'


-- max entry/ID selectors

    SET
        @max_db_spellicon_12340_ID := (SELECT MAX(db_spellicon_12340.ID)
                                            FROM dev_dbc_files.db_spellicon_12340);
  SET
        @max_db_itemdisplayinfo_12340_ID := (SELECT MAX(db_itemdisplayinfo_12340.ID)
                                            FROM dev_dbc_files.db_itemdisplayinfo_12340);
    SET
        @max_item_template_entry := (SELECT MAX(item_template.entry)
                                            FROM dev_world.item_template);

-- dev_dbc_files

-- db_spellicon_12340

    INSERT INTO dev_dbc_files.`db_spellicon_12340`
            (`ID`, `TextureFilename`)
        VALUES
            (@max_db_spellicon_12340_ID +1,
              (CONCAT('Interface\\Icons\\', @omega_blp_file_name, '.blp')));


-- db_itemdisplayinfo_12340

    INSERT INTO dev_dbc_files.`db_itemdisplayinfo_12340`
            (`ID`, `ModelName_1`, `ModelName_2`, `ModelTexture_1`, `ModelTexture_2`,
              `InventoryIcon_1`, `InventoryIcon_2`, `GeosetGroup_1`, `GeosetGroup_2`,
              `GeosetGroup_3`, `Flags`, `SpellVisualID`, `GroupSoundIndex`,
              `HelmetGeosetVis_1`, `HelmetGeosetVis_2`, `Texture_1`,
              `Texture_2`, `Texture_3`, `Texture_4`, `Texture_5`,
              `Texture_6`, `Texture_7`, `Texture_8`, `ItemVisual`, `ParticleColorID`)
        VALUES
            (@max_db_itemdisplayinfo_12340_ID +1, '', '', '', '',
              @omega_blp_file_name,
              '', 0, 0, 0, 0, 0,
              0, 0, 0, '', '', '', '', '', '', '', '', 0, 0);


-- dev_world

-- item_template
    INSERT INTO dev_world.`item_template`
            (`entry`, `class`, `subclass`, `name`, `displayid`, `Quality`,
              `InventoryType`, `bonding`, `description`)
        VALUES
            (@max_item_template_entry +1, 12, 0, (CONCAT('Icon Test: ', @omega_blp_file_name)),
              @max_db_itemdisplayinfo_12340_ID +1, 1, 0, 1, 'Icon visual test item. Does nothing.');




-- SELECTORS

SELECT
        ID as SpellIconID, TextureFilename -- all
    FROM
        dev_dbc_files.db_spellicon_12340
    WHERE
        dev_dbc_files.db_spellicon_12340.ID = @max_db_spellicon_12340_ID +1;

SELECT
        entry as itemEntry, displayid as itemDisplayID, name as itemName
    FROM
        dev_world.item_template
    Where
        dev_world.item_template.entry = @max_item_template_entry +1;













--
-- end