aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorForesterDev <11771800+ForesterDev@users.noreply.github.com>2019-07-25 01:53:31 +0400
committerccrs <ccrs@users.noreply.github.com>2019-07-24 23:53:31 +0200
commit915f8a9d2c2244a0f32e3dd4983ccb47e90ee8fa (patch)
treefaa6d8b8a48e280eb583fabd5ab1570d000c4f60 /sql
parente2e37ec839ef3f4368b09b0035db1c6ef721c296 (diff)
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
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/3.3.5/2019_XX_XX_00_world.sql34
1 files changed, 34 insertions, 0 deletions
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);