araxiaonline/mod-worgoblin
3
0
Fork 0
mirror of https://github.com/araxiaonline/mod-worgoblin.git synced 2026-06-21 15:06:54 -04:00
Code Issues Packages Projects Releases Wiki Activity
Files
master
mod-worgoblin/data/sql/db-world/workflow/itemdisplayinfo_dbc.sql
T

50 lines
9.5 KiB
SQL
Raw Permalink Blame History

DELETE FROM `itemdisplayinfo_dbc` WHERE `ID` IN (62448, 62549, 62557, 62558, 62559, 62561, 62565, 62566, 62568, 62573, 62598, 62614, 62617, 62618, 62621, 62706, 62707, 65743, 65787, 65789, 65798, 65799, 65800, 65801, 65847, 65849, 65850, 65851, 65852, 65853, 65854, 68128, 68129, 68130, 68131, 68132, 69175, 69176, 69181, 69182, 69183, 69185, 69187, 69188, 98023, 132261, 134237, 134238);
INSERT INTO `itemdisplayinfo_dbc` (`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
(62448, '', '', '', '', 'INV_Boots_09', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', '', '', '', 'cloth_gilneasclothes_b_01nobleb_boot_ll', 'cloth_gilneasclothes_b_01nobleb_boot_fo', 0, 0),
(62549, '', '', '', '', 'inv_chest_cloth_18', '', 2, 0, 1, 0, 0, 7, 0, 0, 'robe_worgen_b_01red_sleeve_au', 'robe_worgen_b_01red_Sleeve_AL', '', 'robe_worgen_b_01red_Chest_TU', 'robe_worgen_b_01red_Chest_TL', 'robe_worgen_b_01red_robe_lu', 'robe_worgen_b_01red_robe_ll', '', 0, 0),
(62557, '', '', '', '', 'INV_Chest_Cloth_33', '', 2, 0, 1, 0, 0, 7, 0, 0, 'robe_worgen_b_01brown_Sleeve_AU', 'robe_worgen_b_01brown_Sleeve_AL', '', 'robe_worgen_b_01brown_Chest_TU', 'robe_worgen_b_01brown_Chest_TL', 'robe_worgen_b_01brown_robe_lu', 'robe_worgen_b_01brown_robe_ll', '', 0, 0),
(62558, '', '', '', '', 'INV_Shirt_01', '', 0, 0, 0, 0, 0, 7, 0, 0, 'cloth_gilneasclothes_a_01peasent_sleeve_au ', '', '', 'cloth_gilneasclothes_a_01peasent_Chest_TU', 'cloth_gilneasclothes_a_01peasent_Chest_TL ', '', '', '', 0, 0),
(62559, '', '', '', '', 'INV_Pants_02', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', '', '', 'cloth_gilneasclothes_a_01peasent_pant_lu', 'cloth_gilneasclothes_a_01peasent_Pant_LL', '', 0, 0),
(62561, '', '', '', '', 'INV_Pants_01', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', '', '', 'cloth_gilneasclothes_a_01peasentb_pant_lu', 'cloth_gilneasclothes_a_01peasentb_Pant_LL', '', 0, 0),
(62565, '', '', '', '', 'INV_Chest_Cloth_24', '', 1, 0, 1, 0, 0, 7, 0, 0, 'robe_worgen_b_01black_Sleeve_AU', 'robe_worgen_b_01black_Sleeve_AL', '', 'robe_worgen_b_01black_Chest_TU', 'robe_worgen_b_01black_Chest_TL', 'robe_worgen_b_01black_robe_lu', 'robe_worgen_b_01black_robe_ll', '', 0, 0),
(62566, '', '', '', '', 'INV_Pants_01', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', '', '', 'cloth_gilneasclothes_a_01peasentc_pant_lu', 'cloth_gilneasclothes_a_01peasentc_Pant_LL', '', 0, 0),
(62568, '', '', '', '', 'INV_Boots_04', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', '', '', '', 'cloth_gilneasclothes_b_01nobleb_boot_ll', 'cloth_gilneasclothes_b_01nobleb_boot_fo', 0, 0),
(62573, '', '', '', '', 'INV_Pants_02', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', '', '', 'leather_goblin_b_01_pant_lu', 'leather_goblin_b_01_Pant_LL', '', 0, 0),
(62598, '', '', '', '', 'INV_Pants_02', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', '', '', 'cloth_kezanslave_a_01 _pant_lu', 'cloth_kezanslave_a_01 _Pant_LL', '', 0, 0),
(62614, '', '', '', '', 'INV_Shirt_07', '', 0, 0, 0, 0, 0, 7, 0, 0, 'leather_goblin_b_01red_Sleeve_AU', 'leather_goblin_b_01red_Sleeve_AL', '', 'leather_goblin_b_01red_chest_tu', 'leather_goblin_b_01red_Chest_TL', '', '', '', 0, 0),
(62617, '', '', '', '', 'INV_Boots_06', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', '', '', '', 'leather_goblin_b_01red_boot_ll', 'leather_goblin_b_01red_Boot_FO', 0, 0),
(62618, '', '', '', '', 'INV_Chest_Cloth_22', '', 0, 0, 1, 0, 0, 7, 0, 0, '', '', '', 'robe_goblin_b_01_blue_Chest_TU', 'robe_goblin_b_01_blue_chest_tl', 'robe_goblin_b_01_blue_robe_lu', 'robe_goblin_b_01_blue_robe_ll', '', 0, 0),
(62621, '', '', '', '', 'INV_Pants_01', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', '', '', 'cloth_kezanslave_a_01 _pant_lu', 'cloth_kezanslave_a_01 _Pant_LL', '', 0, 0),
(62706, '', '', '', '', 'INV_Pants_02', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', '', '', 'leather_worgen_b_01red_pant_lu', 'leather_worgen_b_01red_Pant_LL', '', 0, 0),
(62707, '', '', '', '', 'INV_Boots_06', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', '', '', '', 'leather_worgen_b_01red_Boot_LL', 'leather_worgen_b_01red_boot_fo', 0, 0),
(65743, 'axe_2h_war_a_02.mdx', '', 'axe_2h_war_b_02rusty', '', 'inv_throwingaxe_01', '', 0, 0, 0, 0, 0, 9, 0, 0, '', '', '', '', '', '', '', '', 0, 0),
(65787, '', '', '', '', 'INV_Chest_Cloth_16', '', 0, 0, 1, 0, 0, 7, 0, 0, '', '', '', 'robe_goblin_b_01_red_chest_tu', 'robe_goblin_b_01_red_Chest_TL', 'robe_goblin_b_01_red_robe_lu', 'robe_goblin_b_01_red_robe_ll', '', 0, 0),
(65789, '', '', '', '', 'inv_chest_cloth_14', '', 0, 0, 1, 0, 0, 7, 0, 0, '', '', '', 'robe_goblin_b_01_white_chest_tu', 'robe_goblin_b_01_white_Chest_TL', 'robe_goblin_b_01_white_robe_lu', 'robe_goblin_b_01_white_robe_ll', '', 0, 0),
(65798, '', '', '', '', 'INV_Boots_05', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', '', '', '', 'leather_goblin_b_01purple_boot_ll', 'leather_goblin_b_01purple_Boot_FO', 0, 0),
(65799, '', '', '', '', 'INV_Shirt_14', '', 0, 0, 0, 0, 0, 7, 0, 0, 'leather_goblin_b_01purple_sleeve_au', 'leather_goblin_b_01purple_Sleeve_AL', '', 'leather_goblin_b_01purple_Chest_TU', 'leather_goblin_b_01purple_Chest_TL', '', '', '', 0, 0),
(65800, '', '', '', '', 'INV_Boots_06', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', '', '', '', 'leather_goblin_b_01_boot_ll', 'leather_goblin_b_01_Boot_FO', 0, 0),
(65801, '', '', '', '', 'INV_Shirt_07', '', 0, 0, 0, 0, 0, 7, 0, 0, 'leather_goblin_b_01_Sleeve_AU', 'leather_goblin_b_01_Sleeve_AL', '', 'leather_goblin_b_01_chest_tu', 'leather_goblin_b_01_Chest_TL', '', '', '', 0, 0),
(65847, '', '', '', '', 'INV_Boots_06', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', '', '', '', 'leather_worgen_b_01green_boot_ll', 'leather_worgen_b_01green_Boot_FO', 0, 0),
(65849, '', '', '', '', 'INV_Pants_02', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', '', '', 'leather_worgen_b_01green_pant_lu', 'leather_worgen_b_01green_Pant_LL', '', 0, 0),
(65850, '', '', '', '', 'inv_chest_chain_16', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', 'leather_worgen_b_01green_chest_tu', 'leather_worgen_b_01green_Chest_TL', '', '', '', 0, 0),
(65851, '', '', '', '', 'inv_boots_05', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', '', '', '', 'leather_worgen_b_01grey_boot_ll', 'leather_worgen_b_01grey_Boot_FO', 0, 0),
(65852, '', '', '', '', 'inv_misc_desecrated_leatherglove', '', 0, 0, 0, 0, 0, 7, 0, 0, '', 'leather_worgen_b_01grey_glove_al', 'leather_worgen_b_01grey_Glove_HA', '', '', '', '', '', 0, 0),
(65853, '', '', '', '', 'inv_pants_05', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', '', '', 'leather_worgen_b_01grey_pant_lu', 'leather_worgen_b_01grey_Pant_LL', '', 0, 0),
(65854, '', '', '', '', 'INV_Chest_Cloth_13', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', 'leather_worgen_b_01grey_chest_tu', 'leather_worgen_b_01grey_Chest_TL', '', '', '', 0, 0),
(68128, '', '', '', '', 'inv_chest_chain_16', '', 0, 0, 0, 0, 0, 10, 0, 0, 'mail_worgen_b_01black_Sleeve_AU', '', '', 'mail_worgen_b_01black_Chest_TU', 'mail_worgen_b_01black_chest_tl', '', '', '', 0, 0),
(68129, '', '', '', '', 'inv_belt_16', '', 0, 0, 0, 0, 0, 10, 0, 0, '', '', '', '', '', 'mail_worgen_b_01black_belt_lu', '', '', 0, 0),
(68130, '', '', '', '', 'inv_pants_03', '', 0, 0, 0, 0, 0, 10, 0, 0, '', '', '', '', '', 'mail_worgen_b_01black_Pant_LU', 'mail_worgen_b_01black_pant_ll', '', 0, 0),
(68131, '', '', '', '', 'inv_boots_01', '', 0, 0, 0, 0, 0, 10, 0, 0, '', '', '', '', '', '', 'mail_worgen_b_01black_Boot_LL', 'mail_worgen_b_01black_boot_fo', 0, 0),
(68132, '', '', '', '', 'inv_boots_05', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', '', '', '', '', 'cloth_gilneasclothes_b_01nobleb_boot_fo', 0, 0),
(69175, '', '', '', '', 'inv_gauntlets_05', '', 0, 0, 0, 0, 0, 7, 0, 0, '', 'leather_worgen_b_01green_glove_al', 'leather_worgen_b_01green_Glove_HA', '', '', '', '', '', 0, 0),
(69176, '', '', '', '', 'inv_gauntlets_05', '', 0, 0, 0, 0, 0, 7, 0, 0, '', 'leather_worgen_b_01red_Glove_AL', 'leather_worgen_b_01red_glove_ha', '', '', '', '', '', 0, 0),
(69181, '', '', '', '', 'INV_Chest_Leather_04', '', 0, 0, 0, 0, 0, 10, 0, 0, 'mail_goblin_b_01black_Sleeve_AU', '', '', 'mail_goblin_b_01black_chest_tu', 'mail_goblin_b_01black_Chest_TL', '', '', '', 0, 0),
(69182, '', '', '', '', 'inv_misc_desecrated_clothglove', '', 0, 0, 0, 0, 0, 10, 0, 0, '', 'mail_goblin_b_01black_Glove_AL', 'mail_goblin_b_01black_glove_ha', '', '', '', '', '', 0, 0),
(69183, '', '', '', '', 'INV_Misc_Desecrated_MailPants', '', 0, 0, 0, 0, 0, 10, 0, 0, '', '', '', '', '', 'mail_goblin_b_01black_pant_lu', 'mail_goblin_b_01black_Pant_LL', '', 0, 0),
(69185, '', '', '', '', 'INV_Boots_04', '', 0, 0, 0, 0, 0, 10, 0, 0, '', '', '', '', '', '', 'mail_goblin_b_01_Boot_LL', 'mail_goblin_b_01_boot_fo', 0, 0),
(69187, '', '', '', '', 'INV_Pants_02', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', '', '', 'leather_goblin_b_01red_pant_lu', 'leather_goblin_b_01red_pant_ll', '', 0, 0),
(69188, '', '', '', '', 'INV_Pants_02', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', '', '', 'leather_goblin_b_01purple_pant_lu', 'leather_goblin_b_01purple_Pant_LL', '', 0, 0),
(98023, '', '', '', '', 'inv_chest_chain_16', '', 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', 'leather_worgen_b_01red_Chest_TU', 'leather_worgen_b_01red_chest_tl', '', '', '', 0, 0),
(132261, '', '', '', '', 'ability_mount_ridinghorse', '', 0, 0, 0, 0, 0, 16, 0, 0, '', '', '', '', '', '', '', '', 0, 0),
(134237, '', '', '', '', 'inv_misc_key_03', '', 0, 0, 0, 0, 0, 16, 0, 0, '', '', '', '', '', '', '', '', 0, 0),
(134238, '', '', '', '', 'inv_misc_key_04', '', 0, 0, 0, 0, 0, 16, 0, 0, '', '', '', '', '', '', '', '', 0, 0);
Reference in New Issue View Git Blame Copy Permalink