DB/SAI: Pit Of Saron pathing

2 files changed, 140 insertions, 0 deletions

diff --git a/sql/updates/world/2011_05_24_03_creature.sql b/sql/updates/world/2011_05_24_03_world_creature.sql
index 76a7978f847..76a7978f847 100644
--- a/sql/updates/world/2011_05_24_03_creature.sql
+++ b/sql/updates/world/2011_05_24_03_world_creature.sql
diff --git a/sql/updates/world/2011_05_24_06_world_sai.sql b/sql/updates/world/2011_05_24_06_world_sai.sql
new file mode 100644
index 00000000000..551d64bb388
--- /dev/null
+++ b/sql/updates/world/2011_05_24_06_world_sai.sql
@@ -0,0 +1,140 @@
+-- Pathing for Stonespine Gargoyle Entry: 36896
+SET @NPC := 201822;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=674.3073,`position_y`=-26.43229,`position_z`=512.5833 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,871.2952,252.9757,561.8807,0,0,0,100,0),
+(@PATH,2,908.3472,250.5347,561.8807,0,0,0,100,0),
+(@PATH,3,914.9774,291.7049,561.8807,0,0,0,100,0),
+(@PATH,4,862.7778,292.8316,561.8807,0,0,0,100,0),
+(@PATH,5,840.6111,278.9184,561.8807,0,0,0,100,0),
+(@PATH,6,826.5712,228.2292,561.8807,0,0,0,100,0),
+(@PATH,7,833.5452,174.3576,561.8807,0,0,0,100,0),
+(@PATH,8,840.9531,116.6059,561.8807,0,0,0,100,0),
+(@PATH,9,816.033,96.46702,561.8807,0,0,0,100,0),
+(@PATH,10,773.6111,120.1024,561.8807,0,0,0,100,0),
+(@PATH,11,700.3021,175.5278,561.8807,0,0,0,100,0),
+(@PATH,12,672.0243,223.6806,561.8807,0,0,0,100,0),
+(@PATH,13,710.2379,266.3021,561.8807,0,0,0,100,0),
+(@PATH,14,806.8594,287.4445,561.8807,0,0,0,100,0);
+
+-- Pathing for Stonespine Gargoyle Entry: 36896
+SET @NPC := 201834;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=674.3073,`position_y`=-26.43229,`position_z`=512.5833 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,410.967,187.1424,581.4994,0,0,0,100,0),
+(@PATH,2,413.2448,207.5677,581.4994,0,0,0,100,0),
+(@PATH,3,410.6823,230.7569,581.4994,0,0,0,100,0),
+(@PATH,4,365.309,278.4445,581.4994,0,0,0,100,0),
+(@PATH,5,378.1736,302.0868,581.4994,0,0,0,100,0),
+(@PATH,6,410.0504,294.9097,581.4994,0,0,0,100,0),
+(@PATH,7,439.2795,289.7951,581.4994,0,0,0,100,0),
+(@PATH,8,477.2188,240.033,581.4994,0,0,0,100,0),
+(@PATH,9,473.9323,183.2101,581.4994,0,0,0,100,0),
+(@PATH,10,469.3889,140.6754,581.4994,0,0,0,100,0),
+(@PATH,11,429.6354,121.7135,581.4994,0,0,0,100,0),
+(@PATH,12,407.4063,143.0243,581.4994,0,0,0,100,0);
+
+-- Pathing for Stonespine Gargoyle Entry: 36896
+SET @NPC := 201838;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=674.3073,`position_y`=-26.43229,`position_z`=512.5833 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,873.783,136.9774,623.6115,0,0,0,100,0),
+(@PATH,2,872.9045,139.2743,622.4446,0,0,0,100,0),
+(@PATH,3,888.7917,171.3403,591.3615,0,0,0,100,0),
+(@PATH,4,861.3073,209.8455,591.3615,0,0,0,100,0),
+(@PATH,5,830.4913,254.5556,591.3615,0,0,0,100,0),
+(@PATH,6,780.4844,277.6406,591.3615,0,0,0,100,0),
+(@PATH,7,732.6771,272.4635,591.3615,0,0,0,100,0),
+(@PATH,8,683.9028,265.276,591.3615,0,0,0,100,0),
+(@PATH,9,612.3368,284.7934,553.4998,0,0,0,100,0),
+(@PATH,10,554.816,303.1858,553.4998,0,0,0,100,0),
+(@PATH,11,498.1024,309.0625,553.4998,0,0,0,100,0),
+(@PATH,12,470.4167,230.0174,553.4998,0,0,0,100,0),
+(@PATH,13,454.0087,175.2135,553.4998,0,0,0,100,0),
+(@PATH,14,492.4288,127.1806,583.1108,0,0,0,100,0),
+(@PATH,15,551.2604,121.6354,583.1108,0,0,0,100,0),
+(@PATH,16,647.5573,126.3542,583.1108,0,0,0,100,0),
+(@PATH,17,766.2222,130.9254,583.1108,0,0,0,100,0),
+(@PATH,18,829.408,42.33854,583.1108,0,0,0,100,0),
+(@PATH,19,746.7101,-53.03299,583.1108,0,0,0,100,0),
+(@PATH,20,663.2379,-77.32291,583.1108,0,0,0,100,0),
+(@PATH,21,618.6389,3.369792,583.1108,0,0,0,100,0),
+(@PATH,22,641.8559,89.27604,583.1108,0,0,0,100,0),
+(@PATH,23,794.1667,115.6858,583.1108,0,0,0,100,0);
+
+-- Pathing for Stonespine Gargoyle Entry: 36896
+SET @NPC := 201846;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=674.3073,`position_y`=-26.43229,`position_z`=512.5833 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,750.842,23.30903,568.327,0,0,0,100,0),
+(@PATH,2,755.467,-50.2257,568.327,0,0,0,100,0),
+(@PATH,3,734.6927,-93.41319,568.327,0,0,0,100,0),
+(@PATH,4,662.4028,-41.9757,568.327,0,0,0,100,0),
+(@PATH,5,634.9601,19.78472,568.327,0,0,0,100,0),
+(@PATH,6,619.0972,58.13368,568.327,0,0,0,100,0),
+(@PATH,7,569.6493,80.08681,568.327,0,0,0,100,0),
+(@PATH,8,474.8889,136.7135,568.327,0,0,0,100,0),
+(@PATH,9,427.566,173.5174,568.327,0,0,0,100,0),
+(@PATH,10,399.5938,237.6424,568.327,0,0,0,100,0),
+(@PATH,11,416.8108,271.5695,568.327,0,0,0,100,0),
+(@PATH,12,442.8767,281.1493,568.327,0,0,0,100,0),
+(@PATH,13,472.9375,286.9531,568.327,0,0,0,100,0),
+(@PATH,14,515.0677,321.1632,568.327,0,0,0,100,0),
+(@PATH,15,547.0538,332.9358,568.327,0,0,0,100,0),
+(@PATH,16,605.0295,286.3281,568.327,0,0,0,100,0),
+(@PATH,17,673.9167,184.0747,568.327,0,0,0,100,0);
+
+-- Remove dupe Stonespine Gargoyle Spawns
+DELETE FROM `creature` WHERE `MovementType`=0 AND `id`=36896;
+
+-- Pathing for Iceborn Proto-Drake Entry: 36891
+SET @NPC := 202197;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=619.3055,`position_y`=18.79167,`position_z`=513.5994 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,626.5364,0.711806,513.8494,0,0,0,100,0),
+(@PATH,2,619.3055,18.79167,513.5994,0,0,0,100,0),
+(@PATH,3,615.1875,32.38021,512.5994,0,0,0,100,0),
+(@PATH,4,615.4705,47.52778,512.4364,0,0,0,100,0),
+(@PATH,5,617.6285,62.52083,512.5614,0,0,0,100,0),
+(@PATH,6,621.3264,77.02604,512.4487,0,0,0,100,0),
+(@PATH,7,617.6285,62.52083,512.5614,0,0,0,100,0),
+(@PATH,8,615.4705,47.52778,512.4364,0,0,0,100,0),
+(@PATH,9,615.1875,32.38021,512.5994,0,0,0,100,0),
+(@PATH,10,619.3055,18.79167,513.5994,0,0,0,100,0);
+
+-- Pathing for Iceborn Proto-Drake Entry: 36891
+SET @NPC := 201991;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=679.2205,`position_y`=-100.6076,`position_z`=513.8377 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,661.1771,-79.90452,513.8378,0,0,0,100,0),
+(@PATH,2,651.3489,-62.0191,513.7985,0,0,0,100,0),
+(@PATH,3,645.1337,-45.49132,513.7985,0,0,0,100,0),
+(@PATH,4,634.1077,-20.19618,513.8635,0,0,0,100,0),
+(@PATH,5,645.1337,-45.49132,513.7985,0,0,0,100,0),
+(@PATH,6,651.3489,-62.0191,513.7985,0,0,0,100,0),
+(@PATH,7,661.1771,-79.90452,513.8378,0,0,0,100,0),
+(@PATH,8,679.2205,-100.6076,513.8377,0,0,0,100,0);