diff options
| -rw-r--r-- | sql/updates/world/2015_07_16_00_world.sql | 161 |
1 files changed, 161 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_16_00_world.sql b/sql/updates/world/2015_07_16_00_world.sql new file mode 100644 index 00000000000..9dac1b852ce --- /dev/null +++ b/sql/updates/world/2015_07_16_00_world.sql @@ -0,0 +1,161 @@ +-- Dragonblight - Stars' Rest + +-- 1. Stars' Rest Sentinel +SET @NPC := 103062; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3537.26,`position_y`=2033.588,`position_z`=68.79152 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=3537.26,`position_y`=2033.588,`position_z`=68.79152 WHERE `guid`=103029; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,14331,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,3537.26,2033.588,68.79152,0,0,0,0,100,0), +(@PATH,2,3537.51,2033.088,68.29152,0,0,0,0,100,0), +(@PATH,3,3537.51,2032.338,68.54152,0,0,0,0,100,0), +(@PATH,4,3537.51,2031.838,68.54152,0,0,0,0,100,0), +(@PATH,5,3537.752,2020.429,67.9873,0,0,0,0,100,0), +(@PATH,6,3536.252,2019.179,67.9873,0,0,0,0,100,0), +(@PATH,7,3535.502,2018.429,68.2373,0,0,0,0,100,0), +(@PATH,8,3533.502,2016.929,67.7373,0,0,0,0,100,0), +(@PATH,9,3526.502,2010.929,65.4873,0,0,0,0,100,0), +(@PATH,10,3525.752,2010.179,65.4873,0,0,0,0,100,0), +(@PATH,11,3522.992,2011.445,65.12076,0,0,0,0,100,0), +(@PATH,12,3507.724,2005.726,65.301,0,0,0,0,100,0), +(@PATH,13,3493.657,2006.541,65.06053,0,0,0,0,100,0), +(@PATH,14,3480.812,1998.615,65.35239,0,0,0,0,100,0), +(@PATH,15,3465.465,2002.278,65.05173,0,0,0,0,100,0), +(@PATH,16,3463.965,2002.528,64.55173,0,0,0,0,100,0), +(@PATH,17,3456.965,2006.528,66.30173,0,0,0,0,100,0), +(@PATH,18,3449.715,2010.528,66.05173,0,0,0,0,100,0), +(@PATH,19,3447.215,2011.528,66.30173,0,0,0,0,100,0), +(@PATH,20,3447.215,2012.528,66.30173,0,0,0,0,100,0), +(@PATH,21,3447.708,2013.052,65.9034,0,0,0,0,100,0), +(@PATH,22,3450.208,2011.552,66.4034,0,0,0,0,100,0), +(@PATH,23,3456.958,2007.302,66.4034,0,0,0,0,100,0), +(@PATH,24,3462.958,2001.802,64.6534,0,0,0,0,100,0), +(@PATH,25,3463.233,2001.63,64.86917,0,0,0,0,100,0), +(@PATH,26,3464.733,2001.63,64.86917,0,0,0,0,100,0), +(@PATH,27,3475.483,1999.63,65.11917,0,0,0,0,100,0), +(@PATH,28,3481.162,1998.582,65.21896,0,0,0,0,100,0), +(@PATH,29,3494.053,2006.467,65.11182,0,0,0,0,100,0), +(@PATH,30,3507.876,2005.583,65.35843,0,0,0,0,100,0), +(@PATH,31,3523.111,2011.911,65.43626,0,0,0,0,100,0), +(@PATH,32,3525.861,2013.411,65.43626,0,0,0,0,100,0), +(@PATH,33,3526.111,2013.661,65.68626,0,0,0,0,100,0), +(@PATH,34,3526.611,2013.911,65.93626,0,0,0,0,100,0), +(@PATH,35,3532.861,2017.661,67.68626,0,0,0,0,100,0), +(@PATH,36,3535.361,2018.911,68.18626,0,0,0,0,100,0), +(@PATH,37,3536.111,2019.411,68.43626,0,0,0,0,100,0), +(@PATH,38,3535.296,2019.135,68.51205,0,0,0,0,100,0), +(@PATH,39,3536.296,2019.635,68.51205,0,0,0,0,100,0), +(@PATH,40,3537.796,2020.635,68.26205,0,0,0,0,100,0), +(@PATH,41,3539.046,2027.885,68.26205,0,0,0,0,100,0), +(@PATH,42,3539.046,2029.385,68.51205,0,0,0,0,100,0), +(@PATH,43,3538.046,2034.135,69.01205,0,0,0,0,100,0), +(@PATH,44,3536.796,2039.885,69.51205,0,0,0,0,100,0), +(@PATH,45,3536.163,2044.276,69.38925,0,0,0,0,100,0), +(@PATH,46,3538.25,2066.276,69.69058,0,0,0,0,100,0), +(@PATH,47,3540.75,2073.026,70.44058,0,0,0,0,100,0), +(@PATH,48,3542.5,2078.276,70.94058,0,0,0,0,100,0), +(@PATH,49,3544.75,2085.026,71.44058,0,0,0,0,100,0), +(@PATH,50,3544.939,2085.211,71.81058,0,0,0,0,100,0), +(@PATH,51,3545.439,2086.211,71.81058,0,0,0,0,100,0), +(@PATH,52,3546.939,2089.961,72.56058,0,0,0,0,100,0), +(@PATH,53,3549.189,2095.211,73.06058,0,0,0,0,100,0), +(@PATH,54,3551.439,2099.711,73.81058,0,0,0,0,100,0), +(@PATH,55,3551.72,2099.823,74.03008,0,0,0,0,100,0), +(@PATH,56,3552.22,2101.073,74.03008,0,0,0,0,100,0), +(@PATH,57,3554.97,2103.323,74.53008,0,0,0,0,100,0), +(@PATH,58,3554.447,2102.891,74.27884,0,0,0,0,100,0), +(@PATH,59,3554.316,2102.673,74.36517,0,0,0,0,100,0), +(@PATH,60,3552.066,2100.923,74.11517,0,0,0,0,100,0), +(@PATH,61,3550.066,2096.423,73.36517,0,0,0,0,100,0), +(@PATH,62,3548.566,2092.923,72.86517,0,0,0,0,100,0), +(@PATH,63,3546.316,2088.423,72.36517,0,0,0,0,100,0), +(@PATH,64,3545.062,2086.046,71.61682,0,0,0,0,100,0), +(@PATH,65,3543.062,2080.296,71.11682,0,0,0,0,100,0), +(@PATH,66,3541.062,2074.046,70.61682,0,0,0,0,100,0), +(@PATH,67,3538.812,2067.546,70.11682,0,0,0,0,100,0), +(@PATH,68,3538.356,2067.076,69.72728,0,0,0,0,100,0), +(@PATH,69,3538.106,2066.076,69.47728,0,0,0,0,100,0); + +-- enable mosving on SAI +UPDATE `smart_scripts` SET `action_param1`=1 WHERE `entryorguid`=26448 AND `source_type`=0 AND `id`=0 AND `link`=1; + +DELETE FROM `creature_formations` WHERE `leaderGUID`=103062; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(103062, 103062, 0, 0, 2, 0, 0), +(103062, 103029, 3, 90, 2, 0, 0); + +-- 2. Stars' Rest Sentinel +SET @NPC := 103032; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3537.26,`position_y`=2033.588,`position_z`=68.79152 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=3537.26,`position_y`=2033.588,`position_z`=68.79152 WHERE `guid`=103031; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,14331,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, 3548.59, 1966.1, 68.0466, 0, 0, 0, 0, 100, 0), +(@PATH, 2, 3548.09, 1966.85, 68.0466, 0, 0, 0, 0, 100, 0), +(@PATH, 3, 3542.59, 1974.85, 67.5466, 0, 0, 0, 0, 100, 0), +(@PATH, 4, 3538.09, 1981.6, 67.0466, 0, 0, 0, 0, 100, 0), +(@PATH, 5, 3538.02, 1981.62, 66.8252, 0, 0, 0, 0, 100, 0), +(@PATH, 6, 3537.02, 1983.12, 66.5752, 0, 0, 0, 0, 100, 0), +(@PATH, 7, 3534.02, 1987.12, 66.0752, 0, 0, 0, 0, 100, 0), +(@PATH, 8, 3530.02, 1992.37, 65.8252, 0, 0, 0, 0, 100, 0), +(@PATH, 9, 3531.87, 1990.04, 65.7378, 0, 0, 0, 0, 100, 0), +(@PATH, 10, 3534.87, 1986.04, 66.2378, 0, 0, 0, 0, 100, 0), +(@PATH, 11, 3537.25, 1982.94, 67.0032, 0, 0, 0, 0, 100, 0), +(@PATH, 12, 3541.25, 1977.19, 67.2532, 0, 0, 0, 0, 100, 0), +(@PATH, 13, 3547.25, 1968.19, 68.0032, 0, 0, 0, 0, 100, 0), +(@PATH, 14, 3547.48, 1968.06, 68.2955, 0, 0, 0, 0, 100, 0), +(@PATH, 15, 3548.48, 1966.81, 68.2955, 0, 0, 0, 0, 100, 0), +(@PATH, 16, 3551.48, 1960.31, 68.7955, 0, 0, 0, 0, 100, 0), +(@PATH, 17, 3553.23, 1956.06, 69.2955, 0, 0, 0, 0, 100, 0), +(@PATH, 18, 3555.73, 1950.56, 69.7955, 0, 0, 0, 0, 100, 0), +(@PATH, 19, 3557.47, 1946.63, 70.6612, 0, 0, 0, 0, 100, 0), +(@PATH, 20, 3556.22, 1937.88, 71.1612, 0, 0, 0, 0, 100, 0), +(@PATH, 21, 3555.47, 1931.13, 71.6612, 0, 0, 0, 0, 100, 0), +(@PATH, 22, 3554.69, 1926.25, 72.4394, 0, 0, 0, 0, 100, 0), +(@PATH, 23, 3553.94, 1920.5, 72.6894, 0, 0, 0, 0, 100, 0), +(@PATH, 24, 3553.44, 1915.75, 73.4394, 0, 0, 0, 0, 100, 0), +(@PATH, 25, 3552.31, 1910.13, 74.1037, 0, 0, 0, 0, 100, 0), +(@PATH, 26, 3550.56, 1902.38, 74.6037, 0, 0, 0, 0, 100, 0), +(@PATH, 27, 3549.81, 1897.63, 75.1037, 0, 0, 0, 0, 100, 0), +(@PATH, 28, 3549.06, 1893.88, 75.6037, 0, 0, 0, 0, 100, 0), +(@PATH, 29, 3547.81, 1888.88, 76.3537, 0, 0, 0, 0, 100, 0), +(@PATH, 30, 3547.65, 1888.72, 76.6016, 0, 0, 0, 0, 100, 0), +(@PATH, 31, 3547.15, 1886.97, 76.8516, 0, 0, 0, 0, 100, 0), +(@PATH, 32, 3546.65, 1882.97, 77.3516, 0, 0, 0, 0, 100, 0), +(@PATH, 33, 3545.9, 1877.22, 77.8516, 0, 0, 0, 0, 100, 0), +(@PATH, 34, 3544.9, 1871.22, 78.6016, 0, 0, 0, 0, 100, 0), +(@PATH, 35, 3545.28, 1872.27, 78.3342, 0, 0, 0, 0, 100, 0), +(@PATH, 36, 3545.78, 1878.02, 77.5842, 0, 0, 0, 0, 100, 0), +(@PATH, 37, 3546.78, 1884.02, 77.0842, 0, 0, 0, 0, 100, 0), +(@PATH, 38, 3547.56, 1887.11, 76.4566, 0, 0, 0, 0, 100, 0), +(@PATH, 39, 3548.56, 1892.11, 75.9566, 0, 0, 0, 0, 100, 0), +(@PATH, 40, 3549.56, 1896.86, 75.2066, 0, 0, 0, 0, 100, 0), +(@PATH, 41, 3550.31, 1900.61, 74.9566, 0, 0, 0, 0, 100, 0), +(@PATH, 42, 3551.56, 1906.36, 74.2066, 0, 0, 0, 0, 100, 0), +(@PATH, 43, 3552.49, 1910.46, 73.884, 0, 0, 0, 0, 100, 0), +(@PATH, 44, 3553.24, 1916.46, 73.134, 0, 0, 0, 0, 100, 0), +(@PATH, 45, 3553.99, 1921.21, 72.884, 0, 0, 0, 0, 100, 0), +(@PATH, 46, 3555.06, 1926.57, 72.0258, 0, 0, 0, 0, 100, 0), +(@PATH, 47, 3555.81, 1933.57, 71.5258, 0, 0, 0, 0, 100, 0), +(@PATH, 48, 3556.81, 1941.32, 71.0258, 0, 0, 0, 0, 100, 0), +(@PATH, 49, 3557.6, 1947.06, 70.448, 0, 0, 0, 0, 100, 0), +(@PATH, 50, 3555.85, 1950.56, 69.948, 0, 0, 0, 0, 100, 0), +(@PATH, 51, 3553.6, 1955.06, 69.198, 0, 0, 0, 0, 100, 0), +(@PATH, 52, 3551.85, 1959.31, 68.948, 0, 0, 0, 0, 100, 0), +(@PATH, 53, 3548.85, 1965.81, 68.198, 0, 0, 0, 0, 100, 0), +(@PATH, 54, 3548.73, 1966.06, 68.0759, 0, 0, 0, 0, 100, 0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=103032; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(103032, 103032, 0, 0, 2, 0, 0), +(103032, 103031, 3, 90, 2, 0, 0); + +-- 3. Moonrest Highborne +UPDATE `creature` SET `spawndist`=10 WHERE `id`=26455 AND `MovementType`=1; + |