diff options
| author | Kittnz <frederik156@hotmail.com> | 2016-01-30 15:31:31 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2016-04-02 16:27:46 +0200 |
| commit | d66449fd66228d24387276d4d11ef943f38c2805 (patch) | |
| tree | 2115396966607877c6349c3f71563e2932c475c8 | |
| parent | aae5a7725c0a019f444bc9560dca5abc71f46066 (diff) | |
DB/Creature: fix Mine Car visible state
- Still need some SAI fixing when it resets so it continues the path
(cherry picked from commit 771dfe243df1cec097ae7f1497bdbd7ece8a3afc)
| -rw-r--r-- | sql/updates/world/2016_04_02_15_world_2016_01_30_04_world.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/2016_04_02_15_world_2016_01_30_04_world.sql b/sql/updates/world/2016_04_02_15_world_2016_01_30_04_world.sql new file mode 100644 index 00000000000..b90e7b95810 --- /dev/null +++ b/sql/updates/world/2016_04_02_15_world_2016_01_30_04_world.sql @@ -0,0 +1,11 @@ +-- Pathing for Mine Car Entry: 23289 'TDB FORMAT' +SET @NPC := 143599; +SET @PATH := @NPC * 10; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '40684'); + +-- Pathing for Mine Car Entry: 23289 'TDB FORMAT' +SET @NPC := 143600; +SET @PATH := @NPC * 10; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '40684'); |