DB/Totems: Updated displayids of totems

closes #26984 by mdX7

1 files changed, 145 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_10_02_00_world.sql b/sql/updates/world/master/2021_10_02_00_world.sql
new file mode 100644
index 00000000000..0460bb59588
--- /dev/null
+++ b/sql/updates/world/master/2021_10_02_00_world.sql
@@ -0,0 +1,145 @@
+-- 
+DELETE FROM `spell_totem_model` WHERE (`RaceID`=35 AND `SpellID` IN (207399,98008,16191,51485,157153,198838,108280,8512,204336,204331,204330,355580,192077,192222,324386,8143,5394,2484,192058)) OR (`RaceID`=31 AND `SpellID` IN (207399,8143,98008,108280,157153,16191,198838,51485,8512,204331,204336,204330,355580,192077,192222,324386,5394,2484,192058)) OR (`RaceID`=36 AND `SpellID` IN (207399,98008,157153,108280,16191,51485,198838,8512,204336,204331,204330,355580,192077,192222,324386,8143,5394,2484,192058)) OR (`RaceID`=28 AND `SpellID` IN (16191,8512,355580,324386,8143)) OR (`RaceID`=9 AND `SpellID` IN (16191,8512,355580,324386,8143)) OR (`RaceID`=6 AND `SpellID` IN (16191,8512,355580,324386,8143)) OR (`RaceID`=8 AND `SpellID` IN (16191,8512,355580,324386,8143)) OR (`RaceID`=2 AND `SpellID` IN (16191,8512,355580,188592,324386,8143)) OR (`RaceID`=32 AND `SpellID` IN (207399,98008,108280,16191,157153,198838,51485,8512,5394,2484,192058,204336,204331,204330,355580,192222,192077,324386,8143)) OR (`RaceID`=25 AND `SpellID` IN (16191,8512,8143,355580,324386)) OR (`RaceID`=34 AND `SpellID` IN (355580,204336,204331,204330,207399,198838,157153,51485,108280,98008,16191,8512,192077,192222,324386,8143,5394,192058,2484)) OR (`RaceID`=11 AND `SpellID` IN (16191,8512,324386,8143,188616,355580)) OR (`RaceID`=3 AND `SpellID` IN (16191,8512,324386,8143,355580)) OR (`RaceID`=26 AND `SpellID` IN (16191,8512,355580,324386,8143));
+INSERT INTO `spell_totem_model` (`SpellID`, `RaceID`, `DisplayID`) VALUES
+(207399, 35, 94542), -- Vulpera - 207399 (Ancestral Protection Totem)
+(98008, 35, 94541), -- Vulpera - 98008 (Spirit Link Totem)
+(16191, 35, 94544), -- Vulpera - 16191 (Mana Tide Totem)
+(51485, 35, 94542), -- Vulpera - 51485 (Earthgrab Totem)
+(157153, 35, 94544), -- Vulpera - 157153 (Cloudburst Totem)
+(198838, 35, 94542), -- Vulpera - 198838 (Earthen Wall Totem)
+(108280, 35, 94544), -- Vulpera - 108280 (Healing Tide Totem)
+(8512, 35, 94541), -- Vulpera - 8512 (Windfury Totem)
+(204336, 35, 94541), -- Vulpera - 204336 (Grounding Totem)
+(204331, 35, 94541), -- Vulpera - 204331 (Counterstrike Totem)
+(204330, 35, 94543), -- Vulpera - 204330 (Skyfury Totem)
+(355580, 35, 94541), -- Vulpera - 355580 (Static Field Totem)
+(192077, 35, 94541), -- Vulpera - 192077 (Wind Rush Totem)
+(192222, 35, 94543), -- Vulpera - 192222 (Liquid Magma Totem)
+(324386, 35, 94541), -- Vulpera - 324386 (Vesper Totem)
+(8143, 35, 94542), -- Vulpera - 8143 (Tremor Totem)
+(5394, 35, 94544), -- Vulpera - 5394 (Healing Stream Totem)
+(2484, 35, 94542), -- Vulpera - 2484 (Earthbind Totem)
+(192058, 35, 94541), -- Vulpera - 192058 (Capacitor Totem)
+(207399, 31, 84987), -- ZandalariTroll - 207399 (Ancestral Protection Totem)
+(8143, 31, 84987), -- ZandalariTroll - 8143 (Tremor Totem)
+(98008, 31, 84680), -- ZandalariTroll - 98008 (Spirit Link Totem)
+(108280, 31, 84934), -- ZandalariTroll - 108280 (Healing Tide Totem)
+(157153, 31, 84934), -- ZandalariTroll - 157153 (Cloudburst Totem)
+(16191, 31, 84934), -- ZandalariTroll - 16191 (Mana Tide Totem)
+(198838, 31, 84987), -- ZandalariTroll - 198838 (Earthen Wall Totem)
+(51485, 31, 84987), -- ZandalariTroll - 51485 (Earthgrab Totem)
+(8512, 31, 84680), -- ZandalariTroll - 8512 (Windfury Totem)
+(204331, 31, 84680), -- ZandalariTroll - 204331 (Counterstrike Totem)
+(204336, 31, 84680), -- ZandalariTroll - 204336 (Grounding Totem)
+(204330, 31, 84933), -- ZandalariTroll - 204330 (Skyfury Totem)
+(355580, 31, 84680), -- ZandalariTroll - 355580 (Static Field Totem)
+(192077, 31, 84680), -- ZandalariTroll - 192077 (Wind Rush Totem)
+(192222, 31, 84933), -- ZandalariTroll - 192222 (Liquid Magma Totem)
+(324386, 31, 84680), -- ZandalariTroll - 324386 (Vesper Totem)
+(5394, 31, 84934), -- ZandalariTroll - 5394 (Healing Stream Totem)
+(2484, 31, 84987), -- ZandalariTroll - 2484 (Earthbind Totem)
+(192058, 31, 84680), -- ZandalariTroll - 192058 (Capacitor Totem)
+(207399, 36, 86440), -- MagharOrc - 207399 (Ancestral Protection Totem)
+(98008, 36, 86437), -- MagharOrc - 98008 (Spirit Link Totem)
+(157153, 36, 86439), -- MagharOrc - 157153 (Cloudburst Totem)
+(108280, 36, 86439), -- MagharOrc - 108280 (Healing Tide Totem)
+(16191, 36, 86439), -- MagharOrc - 16191 (Mana Tide Totem)
+(51485, 36, 86440), -- MagharOrc - 51485 (Earthgrab Totem)
+(198838, 36, 86440), -- MagharOrc - 198838 (Earthen Wall Totem)
+(8512, 36, 86437), -- MagharOrc - 8512 (Windfury Totem)
+(204336, 36, 86437), -- MagharOrc - 204336 (Grounding Totem)
+(204331, 36, 86437), -- MagharOrc - 204331 (Counterstrike Totem)
+(204330, 36, 86438), -- MagharOrc - 204330 (Skyfury Totem)
+(355580, 36, 86437), -- MagharOrc - 355580 (Static Field Totem)
+(192077, 36, 86437), -- MagharOrc - 192077 (Wind Rush Totem)
+(192222, 36, 86438), -- MagharOrc - 192222 (Liquid Magma Totem)
+(324386, 36, 86437), -- MagharOrc - 324386 (Vesper Totem)
+(8143, 36, 86440), -- MagharOrc - 8143 (Tremor Totem)
+(5394, 36, 86439), -- MagharOrc - 5394 (Healing Stream Totem)
+(2484, 36, 86440), -- MagharOrc - 2484 (Earthbind Totem)
+(192058, 36, 86437), -- MagharOrc - 192058 (Capacitor Totem)
+(16191, 28, 81442), -- HighmountainTauren - 16191 (Mana Tide Totem)
+(8512, 28, 81441), -- HighmountainTauren - 8512 (Windfury Totem)
+(355580, 28, 81441), -- HighmountainTauren - 355580 (Static Field Totem)
+(324386, 28, 81441), -- HighmountainTauren - 324386 (Vesper Totem)
+(8143, 28, 81443), -- HighmountainTauren - 8143 (Tremor Totem)
+(16191, 9, 30784), -- Goblin - 16191 (Mana Tide Totem)
+(8512, 9, 30781), -- Goblin - 8512 (Windfury Totem)
+(355580, 9, 30781), -- Goblin - 355580 (Static Field Totem)
+(324386, 9, 30781), -- Goblin - 324386 (Vesper Totem)
+(8143, 9, 30782), -- Goblin - 8143 (Tremor Totem)
+(16191, 6, 4587), -- Tauren - 16191 (Mana Tide Totem)
+(8512, 6, 4590), -- Tauren - 8512 (Windfury Totem)
+(355580, 6, 4590), -- Tauren - 355580 (Static Field Totem)
+(324386, 6, 4590), -- Tauren - 324386 (Vesper Totem)
+(8143, 6, 4588), -- Tauren - 8143 (Tremor Totem)
+(16191, 8, 30763), -- Troll - 16191 (Mana Tide Totem)
+(8512, 8, 30760), -- Troll - 8512 (Windfury Totem)
+(355580, 8, 30760), -- Troll - 355580 (Static Field Totem)
+(324386, 8, 30760), -- Troll - 324386 (Vesper Totem)
+(8143, 8, 30761), -- Troll - 8143 (Tremor Totem)
+(16191, 2, 30759), -- Orc - 16191 (Mana Tide Totem)
+(8512, 2, 30756), -- Orc - 8512 (Windfury Totem)
+(355580, 2, 30756), -- Orc - 355580 (Static Field Totem)
+(188592, 2, 59800), -- Orc - 188592 (Fire Elemental)
+(324386, 2, 30756), -- Orc - 324386 (Vesper Totem)
+(8143, 2, 30757), -- Orc - 8143 (Tremor Totem)
+(207399, 32, 90691), -- KulTiran - 207399 (Ancestral Protection Totem)
+(98008, 32, 90693), -- KulTiran - 98008 (Spirit Link Totem)
+(108280, 32, 90694), -- KulTiran - 108280 (Healing Tide Totem)
+(16191, 32, 90694), -- KulTiran - 16191 (Mana Tide Totem)
+(157153, 32, 90694), -- KulTiran - 157153 (Cloudburst Totem)
+(198838, 32, 90691), -- KulTiran - 198838 (Earthen Wall Totem)
+(51485, 32, 90691), -- KulTiran - 51485 (Earthgrab Totem)
+(8512, 32, 90693), -- KulTiran - 8512 (Windfury Totem)
+(5394, 32, 90694), -- KulTiran - 5394 (Healing Stream Totem)
+(2484, 32, 90691), -- KulTiran - 2484 (Earthbind Totem)
+(192058, 32, 90693), -- KulTiran - 192058 (Capacitor Totem)
+(204336, 32, 90693), -- KulTiran - 204336 (Grounding Totem)
+(204331, 32, 90693), -- KulTiran - 204331 (Counterstrike Totem)
+(204330, 32, 90695), -- KulTiran - 204330 (Skyfury Totem)
+(355580, 32, 90693), -- KulTiran - 355580 (Static Field Totem)
+(192222, 32, 90695), -- KulTiran - 192222 (Liquid Magma Totem)
+(192077, 32, 90693), -- KulTiran - 192077 (Wind Rush Totem)
+(324386, 32, 90693), -- KulTiran - 324386 (Vesper Totem)
+(8143, 32, 90691), -- KulTiran - 8143 (Tremor Totem)
+(16191, 25, 41671), -- PandarenAlliance - 16191 (Mana Tide Totem)
+(8512, 25, 41668), -- PandarenAlliance - 8512 (Windfury Totem)
+(8143, 25, 41669), -- PandarenAlliance - 8143 (Tremor Totem)
+(355580, 25, 41668), -- PandarenAlliance - 355580 (Static Field Totem)
+(324386, 25, 41668), -- PandarenAlliance - 324386 (Vesper Totem)
+(355580, 34, 86432), -- DarkIronDwarf - 355580 (Static Field Totem)
+(204336, 34, 86432), -- DarkIronDwarf - 204336 (Grounding Totem)
+(204331, 34, 86432), -- DarkIronDwarf - 204331 (Counterstrike Totem)
+(204330, 34, 86433), -- DarkIronDwarf - 204330 (Skyfury Totem)
+(207399, 34, 86435), -- DarkIronDwarf - 207399 (Ancestral Protection Totem)
+(198838, 34, 86435), -- DarkIronDwarf - 198838 (Earthen Wall Totem)
+(157153, 34, 86434), -- DarkIronDwarf - 157153 (Cloudburst Totem)
+(51485, 34, 86435), -- DarkIronDwarf - 51485 (Earthgrab Totem)
+(108280, 34, 86434), -- DarkIronDwarf - 108280 (Healing Tide Totem)
+(98008, 34, 86432), -- DarkIronDwarf - 98008 (Spirit Link Totem)
+(16191, 34, 86434), -- DarkIronDwarf - 16191 (Mana Tide Totem)
+(8512, 34, 86432), -- DarkIronDwarf - 8512 (Windfury Totem)
+(192077, 34, 86432), -- DarkIronDwarf - 192077 (Wind Rush Totem)
+(192222, 34, 86433), -- DarkIronDwarf - 192222 (Liquid Magma Totem)
+(324386, 34, 86432), -- DarkIronDwarf - 324386 (Vesper Totem)
+(8143, 34, 86435), -- DarkIronDwarf - 8143 (Tremor Totem)
+(5394, 34, 86434), -- DarkIronDwarf - 5394 (Healing Stream Totem)
+(192058, 34, 86432), -- DarkIronDwarf - 192058 (Capacitor Totem)
+(2484, 34, 86435), -- DarkIronDwarf - 2484 (Earthbind Totem)
+(16191, 11, 19075), -- Draenei - 16191 (Mana Tide Totem)
+(8512, 11, 19071), -- Draenei - 8512 (Windfury Totem)
+(324386, 11, 19071), -- Draenei - 324386 (Vesper Totem)
+(8143, 11, 19073), -- Draenei - 8143 (Tremor Totem)
+(188616, 11, 14511), -- Draenei - 188616 (Earth Elemental)
+(355580, 11, 19071), -- Draenei - 355580 (Static Field Totem)
+(16191, 3, 30755), -- Dwarf - 16191 (Mana Tide Totem)
+(8512, 3, 30736), -- Dwarf - 8512 (Windfury Totem)
+(324386, 3, 30736), -- Dwarf - 324386 (Vesper Totem)
+(8143, 3, 30753), -- Dwarf - 8143 (Tremor Totem)
+(355580, 3, 30736), -- Dwarf - 355580 (Static Field Totem)
+(16191, 26, 41671), -- PandarenHorde - 16191 (Mana Tide Totem)
+(8512, 26, 41668), -- PandarenHorde - 8512 (Windfury Totem)
+(355580, 26, 41668), -- PandarenHorde - 355580 (Static Field Totem)
+(324386, 26, 41668), -- PandarenHorde - 324386 (Vesper Totem)
+(8143, 26, 41669); -- PandarenHorde - 8143 (Tremor Totem)