DB/Creature: fix Mine Car visible state

- Still need some SAI fixing when it resets so it continues the path

1 files changed, 11 insertions, 0 deletions

diff --git a/sql/updates/world/2016_01_30_04_world.sql b/sql/updates/world/2016_01_30_04_world.sql
new file mode 100644
index 00000000000..b90e7b95810
--- /dev/null
+++ b/sql/updates/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');