DB/Creature: Spawn Chromehound

Closes #15703 by malcrom

1 files changed, 50 insertions, 0 deletions

diff --git a/sql/updates/world/6.x/2016_06_15_01_world.sql b/sql/updates/world/6.x/2016_06_15_01_world.sql
new file mode 100644
index 00000000000..a24ec70a972
--- /dev/null
+++ b/sql/updates/world/6.x/2016_06_15_01_world.sql
@@ -0,0 +1,50 @@
+--
+SET @NPC := 452424;
+DELETE FROM `creature` WHERE `guid`=@NPC;
+INSERT INTO `creature` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`) VALUES (@NPC, 50839,0, -7507.344, -1167.55, 261.0904);
+-- Pathing for Chromehound Entry: 50839 'TDB FORMAT' 
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-7507.344,`position_y`=-1167.55,`position_z`=261.0904 WHERE `guid`=@NPC;
+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, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,-7507.344,-1167.55,261.0904,0,0,0,0,100,0),
+(@PATH,2,-7492.085,-1164.431,262.7305,0,0,0,0,100,0),
+(@PATH,3,-7489.484,-1149.292,264.4326,0,0,0,0,100,0),
+(@PATH,4,-7490.816,-1130.962,265.503,0,0,0,0,100,0),
+(@PATH,5,-7494.488,-1121.899,265.6144,0,0,0,0,100,0),
+(@PATH,6,-7492.366,-1110.879,266.0537,0,0,0,0,100,0),
+(@PATH,7,-7493.984,-1094.67,265.577,0,0,0,0,100,0),
+(@PATH,8,-7495.3,-1083.632,265.1164,0,0,0,0,100,0),
+(@PATH,9,-7503.222,-1072.288,264.4205,0,0,0,0,100,0),
+(@PATH,10,-7507.295,-1060.439,263.3694,0,0,0,0,100,0),
+(@PATH,11,-7521.344,-1044.481,260.9198,0,0,0,0,100,0),
+(@PATH,12,-7531.807,-1033.694,258.3916,0,0,0,0,100,0),
+(@PATH,13,-7550.604,-1024.927,254.4957,0,0,0,0,100,0),
+(@PATH,14,-7566.979,-1019.031,250.771,0,0,0,0,100,0),
+(@PATH,15,-7587.071,-1014.3,246.2627,0,0,0,0,100,0),
+(@PATH,16,-7609.59,-1013.542,240.6937,0,0,0,0,100,0),
+(@PATH,17,-7628.318,-1020.125,235.8074,0,0,0,0,100,0),
+(@PATH,18,-7643.806,-1026.658,231.2818,0,0,0,0,100,0),
+(@PATH,19,-7662.762,-1041.675,225.5605,0,0,0,0,100,0),
+(@PATH,20,-7679.563,-1057.769,220.2642,0,0,0,0,100,0),
+(@PATH,21,-7687.872,-1075.955,218.3654,0,0,0,0,100,0),
+(@PATH,22,-7692.823,-1094.333,217.3829,0,0,0,0,100,0),
+(@PATH,23,-7699.91,-1104.755,216.755,0,0,0,0,100,0),
+(@PATH,24,-7698.327,-1124.78,215.6021,0,0,0,0,100,0),
+(@PATH,25,-7693.615,-1147.448,215.0171,0,0,0,0,100,0),
+(@PATH,26,-7688.542,-1162.736,215.4126,0,0,0,0,100,0),
+(@PATH,27,-7678.569,-1177.247,217.1286,0,0,0,0,100,0),
+(@PATH,28,-7665.182,-1194.701,220.6102,0,0,0,0,100,0),
+(@PATH,29,-7649.865,-1205.075,224.4757,0,0,0,0,100,0),
+(@PATH,30,-7635.476,-1212.811,228.4464,0,0,0,0,100,0),
+(@PATH,31,-7622.031,-1217.165,231.4845,0,0,0,0,100,0),
+(@PATH,32,-7605.257,-1222.564,234.1023,0,0,0,0,100,0),
+(@PATH,33,-7593.495,-1223.609,237.124,0,0,0,0,100,0),
+(@PATH,34,-7579.444,-1221.302,241.1097,0,0,0,0,100,0),
+(@PATH,35,-7564.16,-1218.061,245.7083,0,0,0,0,100,0),
+(@PATH,36,-7547.385,-1211.174,249.913,0,0,0,0,100,0),
+(@PATH,37,-7532.037,-1200.672,253.8217,0,0,0,0,100,0),
+(@PATH,38,-7522.413,-1193.398,256.1735,0,0,0,0,100,0),
+(@PATH,39,-7515.12,-1179.415,258.7101,0,0,0,0,100,0);