From 915f8a9d2c2244a0f32e3dd4983ccb47e90ee8fa Mon Sep 17 00:00:00 2001
From: ForesterDev <11771800+ForesterDev@users.noreply.github.com>
Date: Thu, 25 Jul 2019 01:53:31 +0400
Subject: Core/Totems: update select display for shaman totems (#23583)

(cherry picked from commit 8ca6a20e7303e942adfb6d97b9aa94fab7c6b895)

# Conflicts:
#	src/server/game/Entities/Totem/Totem.cpp
#	src/server/game/Entities/Unit/Unit.cpp
#	src/server/game/Entities/Unit/Unit.h
#	src/server/game/Spells/SpellMgr.cpp
#	src/server/game/Spells/SpellMgr.h
#	src/server/game/World/World.cpp
---
 sql/updates/world/3.3.5/2019_XX_XX_00_world.sql | 34 +++++++++++++++++++++++++
 1 file changed, 34 insertions(+)
 create mode 100644 sql/updates/world/3.3.5/2019_XX_XX_00_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/3.3.5/2019_XX_XX_00_world.sql b/sql/updates/world/3.3.5/2019_XX_XX_00_world.sql
new file mode 100644
index 00000000000..fc2055606a5
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_XX_XX_00_world.sql
@@ -0,0 +1,34 @@
+DROP TABLE IF EXISTS `player_totem_model`;
+CREATE TABLE `player_totem_model` (
+  `TotemSlot` TINYINT(3) UNSIGNED NOT NULL,
+  `RaceId` TINYINT(3) UNSIGNED NOT NULL,
+  `DisplayId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  PRIMARY KEY (`TotemSlot`,`RaceID`)
+) ENGINE=MYISAM DEFAULT CHARSET=utf8;
+
+INSERT INTO `player_totem_model` (`TotemSlot`, `RaceId`, `DisplayId`) VALUES
+-- Orc
+(1, 2, 30758),
+(2, 2, 30757),
+(3, 2, 30759),
+(4, 2, 30756),
+-- Dwarf
+(1, 3, 30754),
+(2, 3, 30753),
+(3, 3, 30755),
+(4, 3, 30736),
+-- Tauren
+(1, 6, 4589),
+(2, 6, 4588),
+(3, 6, 4587),
+(4, 6, 4590),
+-- Troll
+(1, 8, 30762),
+(2, 8, 30761),
+(3, 8, 30763),
+(4, 8, 30760),
+-- Draenei
+(1, 11, 19074),
+(2, 11, 19073),
+(3, 11, 19075),
+(4, 11, 19071);
-- 
cgit v1.2.3