diff options
| -rw-r--r-- | sql/updates/world/2016_04_09_13_world_2016_03_26_00_world.sql | 516 |
1 files changed, 516 insertions, 0 deletions
diff --git a/sql/updates/world/2016_04_09_13_world_2016_03_26_00_world.sql b/sql/updates/world/2016_04_09_13_world_2016_03_26_00_world.sql new file mode 100644 index 00000000000..58a42dc214d --- /dev/null +++ b/sql/updates/world/2016_04_09_13_world_2016_03_26_00_world.sql @@ -0,0 +1,516 @@ +-- Fix moving phantom guest who should be sitting. +UPDATE `creature` SET `MovementType`=0 AND `spawndist`=0, `position_x`=-10997.400391, `position_y`=-1893.040039, `orientation`=3.572645 WHERE `guid`=135230; +UPDATE `creature_addon` SET `bytes1`=1, `bytes2`=5 WHERE `guid`=135230; + +SET @NPC := 135151; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-10988.13,`position_y`=-2019.135,`position_z`=80.22357 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,-10988.13,-2019.135,80.22357,0,0,0,0,100,0), +(@PATH,2,-10987.89,-2011.348,80.22346,0,0,0,0,100,0), +(@PATH,3,-10984.39,-2008.848,80.22346,0,0,0,0,100,0), +(@PATH,4,-10981.26,-2006.71,80.22307,0,0,0,0,100,0), +(@PATH,5,-10972.16,-2002.439,80.22302,0,0,0,0,100,0), +(@PATH,6,-10979.17,-1997.218,80.22329,0,0,0,0,100,0), +(@PATH,7,-10980.42,-1997.218,80.22329,0,0,0,0,100,0), +(@PATH,8,-10981.42,-1997.218,80.22329,0,0,0,0,100,0), +(@PATH,9,-10985.26,-1997.161,80.22356,0,0,0,0,100,0), +(@PATH,10,-10984.12,-1987.489,80.22325,0,0,0,0,100,0), +(@PATH,11,-10979.12,-1986.239,80.22325,0,0,0,0,100,0), +(@PATH,12,-10973.73,-1984.487,80.22291,0,0,0,0,100,0), +(@PATH,13,-10967.48,-1974.487,80.22291,0,0,0,0,100,0), +(@PATH,14,-10966.55,-1973.238,80.22318,0,0,0,0,100,0), +(@PATH,15,-10962.55,-1970.488,80.22318,0,0,0,0,100,0), +(@PATH,16,-10957.55,-1966.988,80.22318,0,0,0,0,100,0), +(@PATH,17,-10955.99,-1967.212,80.2233,0,0,0,0,100,0), +(@PATH,18,-10952.45,-1968.359,80.22365,0,0,0,0,100,0), +(@PATH,19,-10951.29,-1984.542,80.22362,0,0,0,0,100,0), +(@PATH,20,-10953.64,-1990.575,80.22345,0,0,0,0,100,0), +(@PATH,21,-10954.39,-1991.575,80.22345,0,0,0,0,100,0), +(@PATH,22,-10956.89,-1995.075,80.22345,0,0,0,0,100,0), +(@PATH,23,-10961.48,-2000.67,80.2235,0,0,0,0,100,0), +(@PATH,24,-10961.23,-2004.42,80.2235,0,0,0,0,100,0), +(@PATH,25,-10961.32,-2013.403,80.22313,0,0,0,0,100,0), +(@PATH,26,-10964.57,-2015.653,80.22313,0,0,0,0,100,0), +(@PATH,27,-10972.57,-2021.653,80.22313,0,0,0,0,100,0), +(@PATH,28,-10974.32,-2022.653,80.22313,0,0,0,0,100,0), +(@PATH,29,-10976.85,-2024.267,80.22278,0,0,0,0,100,0), +(@PATH,30,-10984.28,-2022.546,80.22318,0,0,0,0,100,0), +(@PATH,31,-10986.03,-2021.296,80.22318,0,0,0,0,100,0); +-- 0x1C310842801005C00053CE00021939B3 .go -10988.13 -2019.135 80.22357 + +SET @NPC := 135153; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-11067.45,`position_y`=-1954.224,`position_z`=77.52905 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,-11067.45,-1954.224,77.52905,0,0,0,0,100,0), +(@PATH,2,-11066.2,-1960.974,77.52905,0,0,0,0,100,0), +(@PATH,3,-11065.75,-1963.135,77.51662,0,0,0,0,100,0), +(@PATH,4,-11065.75,-1967.135,77.51662,0,0,0,0,100,0), +(@PATH,5,-11065.79,-1972.166,77.51814,0,0,0,0,100,0), +(@PATH,6,-11066.38,-1980.533,77.51814,0,0,0,0,100,0), +(@PATH,7,-11066.62,-1984.77,77.51814,0,0,0,0,100,0), +(@PATH,8,-11069.65,-1987.687,77.51814,0,0,0,0,100,0), +(@PATH,9,-11070.65,-1989.187,77.51814,0,0,0,0,100,0), +(@PATH,10,-11071.15,-1989.937,77.51814,0,0,0,0,100,0), +(@PATH,11,-11070.94,-1998.072,77.51814,0,0,0,0,100,0), +(@PATH,12,-11070.44,-1998.822,77.51814,0,0,0,0,100,0), +(@PATH,13,-11068.2,-2002.879,77.51814,0,0,0,0,100,0), +(@PATH,14,-11065.7,-2003.629,77.51814,0,0,0,0,100,0), +(@PATH,15,-11063.57,-2004.327,77.51814,0,0,0,0,100,0), +(@PATH,16,-11061.32,-2005.077,77.51814,0,0,0,0,100,0), +(@PATH,17,-11055.32,-2003.327,77.51814,0,0,0,0,100,0), +(@PATH,18,-11054.66,-2002.821,77.55538,0,0,0,0,100,0), +(@PATH,19,-11054.31,-1995.887,77.51814,0,0,0,0,100,0), +(@PATH,20,-11055.06,-1993.137,77.51814,0,0,0,0,100,0), +(@PATH,21,-11055.91,-1986.87,77.51814,0,0,0,0,100,0), +(@PATH,22,-11054.91,-1981.87,77.51814,0,0,0,0,100,0), +(@PATH,23,-11054.66,-1978.87,77.51814,0,0,0,0,100,0), +(@PATH,24,-11054.28,-1978.515,77.51814,0,0,0,0,100,0), +(@PATH,25,-11054.03,-1977.265,77.51814,0,0,0,0,100,0), +(@PATH,26,-11053.78,-1974.765,77.51814,0,0,0,0,100,0), +(@PATH,27,-11051.89,-1965.272,77.51814,0,0,0,0,100,0), +(@PATH,28,-11048.71,-1950.098,77.51814,0,0,0,0,100,0), +(@PATH,29,-11048.46,-1946.348,77.51814,0,0,0,0,100,0), +(@PATH,30,-11047.88,-1941.905,77.51763,0,0,0,0,100,0), +(@PATH,31,-11047.38,-1933.655,77.51763,0,0,0,0,100,0), +(@PATH,32,-11047.21,-1931.985,77.51714,0,0,0,0,100,0), +(@PATH,33,-11047.59,-1921.692,77.51558,0,0,0,0,100,0), +(@PATH,34,-11057.2,-1924.383,77.51465,0,0,0,0,100,0), +(@PATH,35,-11058.45,-1924.383,77.51465,0,0,0,0,100,0), +(@PATH,36,-11063.45,-1924.133,77.51465,0,0,0,0,100,0), +(@PATH,37,-11068.15,-1924.406,77.51405,0,0,0,0,100,0), +(@PATH,38,-11067.4,-1927.406,77.51405,0,0,0,0,100,0), +(@PATH,39,-11067.21,-1928.737,77.51527,0,0,0,0,100,0), +(@PATH,40,-11066.71,-1930.737,77.51527,0,0,0,0,100,0), +(@PATH,41,-11067.95,-1936.832,77.515,0,0,0,0,100,0), +(@PATH,42,-11068.2,-1939.332,77.515,0,0,0,0,100,0), +(@PATH,43,-11068.68,-1942.693,77.51746,0,0,0,0,100,0), +(@PATH,44,-11068.93,-1945.193,77.51746,0,0,0,0,100,0), +(@PATH,45,-11068.48,-1949.942,77.51735,0,0,0,0,100,0); +-- 0x1C310842801005C00053CE00029939B3 .go -11067.45 -1954.224 77.52905 + +SET @NPC := 135160; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-10901.4,`position_y`=-1937.891,`position_z`=92.465 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,-10901.4,-1937.891,92.465,0,0,0,0,100,0), +(@PATH,2,-10900.29,-1929.272,92.4336,0,0,0,0,100,0), +(@PATH,3,-10901.91,-1923.966,92.44674,0,0,0,0,100,0), +(@PATH,4,-10929.68,-1920.51,94.00494,0,0,0,0,100,0), +(@PATH,5,-10931.06,-1919.155,94.07338,0,0,0,0,100,0), +(@PATH,6,-10943.3,-1903.568,94.07179,0,0,0,0,100,0), +(@PATH,7,-10944.89,-1920.322,94.07281,0,0,0,0,100,0), +(@PATH,8,-10942.7,-1925.781,94.07328,0,0,0,0,100,0), +(@PATH,9,-10938.01,-1929.625,94.00285,0,0,0,0,100,0), +(@PATH,10,-10916.58,-1931.924,92.45416,0,0,0,0,100,0), +(@PATH,11,-10913.29,-1936.26,92.45316,0,0,0,0,100,0), +(@PATH,12,-10914.17,-1940.8,92.45174,0,0,0,0,100,0), +(@PATH,13,-10916.33,-1945.966,92.44943,0,0,0,0,100,0), +(@PATH,14,-10918.42,-1951.383,92.44786,0,0,0,0,100,0), +(@PATH,15,-10915.9,-1954.492,92.43726,0,0,0,0,100,0), +(@PATH,16,-10918.41,-1959.593,92.43956,0,0,0,0,100,0), +(@PATH,17,-10925.46,-1968.512,92.43243,0,0,0,0,100,0), +(@PATH,18,-10929.36,-1971.48,92.43213,0,0,0,0,100,0), +(@PATH,19,-10930.33,-1974.389,92.43208,0,0,0,0,100,0), +(@PATH,20,-10921.77,-1991.525,92.43311,0,0,0,0,100,0), +(@PATH,21,-10917.44,-1995.525,92.43374,0,0,0,0,100,0), +(@PATH,22,-10909.94,-1997.982,92.43427,0,0,0,0,100,0); +-- 0x1C310842801005C00053CE00031939B3 .go -10901.4 -1937.891 92.465 + +SET @NPC := 135165; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-10939.02,`position_y`=-1978.883,`position_z`=93.82455 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,-10939.02,-1978.883,93.82455,0,0,0,0,100,0), +(@PATH,2,-10937.05,-1980.987,94.02183,0,0,0,0,100,0), +(@PATH,3,-10936.1,-1981.984,93.75357,0,0,0,0,100,0), +(@PATH,4,-10935.1,-1982.984,93.00357,0,0,0,0,100,0), +(@PATH,5,-10933.3,-1984.661,92.40492,0,0,0,0,100,0), +(@PATH,6,-10931.4,-1988.728,92.43253,0,0,0,0,100,0), +(@PATH,7,-10929.84,-1993.005,92.43249,0,0,0,0,100,0), +(@PATH,8,-10929.33,-1998.021,92.43246,0,0,0,0,100,0), +(@PATH,9,-10927.59,-1998.024,92.4326,0,0,0,0,100,0), +(@PATH,10,-10926.84,-1997.024,92.4326,0,0,0,0,100,0), +(@PATH,11,-10923.82,-1993.655,92.43284,0,0,0,0,100,0), +(@PATH,12,-10920.28,-1992.615,92.43314,0,0,0,0,100,0), +(@PATH,13,-10916.69,-1991.384,92.43354,0,0,0,0,100,0), +(@PATH,14,-10912.31,-1989.809,92.43417,0,0,0,0,100,0), +(@PATH,15,-10907.22,-1987.487,92.43446,0,0,0,0,100,0), +(@PATH,16,-10907.61,-1983.417,92.43436,0,0,0,0,100,0), +(@PATH,17,-10911.33,-1980.017,92.43408,0,0,0,0,100,0), +(@PATH,18,-10913.89,-1977.515,92.43388,0,0,0,0,100,0), +(@PATH,19,-10915.35,-1974.443,92.43365,0,0,0,0,100,0), +(@PATH,20,-10917.08,-1969.858,92.43343,0,0,0,0,100,0), +(@PATH,21,-10918.56,-1962.168,92.43033,0,0,0,0,100,0), +(@PATH,22,-10917.81,-1960.168,92.43033,0,0,0,0,100,0), +(@PATH,23,-10917.31,-1957.168,92.43033,0,0,0,0,100,0), +(@PATH,24,-10916.8,-1956.043,92.44185,0,0,0,0,100,0), +(@PATH,25,-10913.85,-1945.233,92.44743,0,0,0,0,100,0), +(@PATH,26,-10913.63,-1940.582,92.45272,0,0,0,0,100,0), +(@PATH,27,-10913.35,-1935.01,92.45383,0,0,0,0,100,0), +(@PATH,28,-10917.51,-1933.436,92.45338,0,0,0,0,100,0), +(@PATH,29,-10922.4,-1936.293,92.4428,0,0,0,0,100,0), +(@PATH,30,-10925.65,-1937.793,92.4428,0,0,0,0,100,0), +(@PATH,31,-10926.53,-1938.423,92.52744,0,0,0,0,100,0), +(@PATH,32,-10929.78,-1939.673,92.52744,0,0,0,0,100,0), +(@PATH,33,-10930.73,-1940.091,93.50311,0,0,0,0,100,0), +(@PATH,34,-10930.98,-1938.091,93.75311,0,0,0,0,100,0), +(@PATH,35,-10930.98,-1935.091,94.00311,0,0,0,0,100,0), +(@PATH,36,-10932.33,-1925.829,94.07312,0,0,0,0,100,0), +(@PATH,37,-10934.22,-1919.477,94.07236,0,0,0,0,100,0), +(@PATH,38,-10936.83,-1914.139,94.07259,0,0,0,0,100,0), +(@PATH,39,-10940.94,-1913.56,94.07243,0,0,0,0,100,0), +(@PATH,40,-10943.83,-1916.909,94.07263,0,0,0,0,100,0), +(@PATH,41,-10945.09,-1924.069,94.07304,0,0,0,0,100,0), +(@PATH,42,-10945.81,-1929.354,94.07185,0,0,0,0,100,0), +(@PATH,43,-10946.08,-1934.29,94.07332,0,0,0,0,100,0), +(@PATH,44,-10945.36,-1938.052,94.06967,0,0,0,0,100,0), +(@PATH,45,-10944.86,-1940.302,94.06967,0,0,0,0,100,0), +(@PATH,46,-10943.61,-1941.302,94.06967,0,0,0,0,100,0), +(@PATH,47,-10942.36,-1942.552,94.06967,0,0,0,0,100,0), +(@PATH,48,-10941.18,-1943.745,94.07132,0,0,0,0,100,0), +(@PATH,49,-10938.37,-1950.035,94.06915,0,0,0,0,100,0), +(@PATH,50,-10938.62,-1951.785,94.06915,0,0,0,0,100,0), +(@PATH,51,-10938.97,-1960.17,94.07024,0,0,0,0,100,0), +(@PATH,52,-10939.53,-1967.704,94.07249,0,0,0,0,100,0), +(@PATH,53,-10939.97,-1974.155,94.07382,0,0,0,0,100,0); +-- 0x1C310842801005C00053CE00039939B3 .go -10939.02 -1978.883 93.82455 + +SET @NPC := 135162; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-10946.03,`position_y`=-2018.407,`position_z`=80.01561 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,-10946.03,-2018.407,80.01561,0,0,0,0,100,0), +(@PATH,2,-10938.18,-2019.209,80.42243,0,0,0,0,100,0), +(@PATH,3,-10936.18,-2020.459,80.42243,0,0,0,0,100,0), +(@PATH,4,-10937.69,-2035.067,86.25978,0,0,0,0,100,0), +(@PATH,5,-10937,-2040.216,86.32371,0,0,0,0,100,0), +(@PATH,6,-10933.3,-2043.247,86.32394,0,0,0,0,100,0), +(@PATH,7,-10928.26,-2043.84,86.32447,0,0,0,0,100,0), +(@PATH,8,-10923.09,-2042.638,86.32227,0,0,0,0,100,0), +(@PATH,9,-10920.8,-2037.279,86.56629,0,0,0,0,100,0), +(@PATH,10,-10916.75,-2002.508,92.43436,0,0,0,0,100,0), +(@PATH,11,-10911.1,-2000.068,92.43423,0,0,0,0,100,0), +(@PATH,12,-10907.79,-1994.801,92.43451,0,0,0,0,100,0), +(@PATH,13,-10903.67,-1963.204,92.42834,0,0,0,0,100,0), +(@PATH,14,-10888.27,-1964.728,92.42189,0,0,0,0,100,0), +(@PATH,15,-10903.75,-1963.212,92.4287,0,0,0,0,100,0), +(@PATH,16,-10907.83,-1994.959,92.43437,0,0,0,0,100,0), +(@PATH,17,-10911.13,-1999.935,92.43394,0,0,0,0,100,0), +(@PATH,18,-10916.75,-2002.692,92.43467,0,0,0,0,100,0), +(@PATH,19,-10920.86,-2037.652,86.46838,0,0,0,0,100,0), +(@PATH,20,-10923.34,-2042.72,86.32289,0,0,0,0,100,0), +(@PATH,21,-10927.59,-2043.72,86.32289,0,0,0,0,100,0), +(@PATH,22,-10933.56,-2043.322,86.32355,0,0,0,0,100,0), +(@PATH,23,-10937.03,-2040.081,86.32348,0,0,0,0,100,0), +(@PATH,24,-10937.61,-2035.351,86.17421,0,0,0,0,100,0), +(@PATH,25,-10935.98,-2020.486,80.32269,0,0,0,0,100,0), +(@PATH,26,-10938.22,-2019.048,80.224,0,0,0,0,100,0); +-- 0x1C310842801005C00053CE00041939B3 .go -10946.03 -2018.407 80.01561 + +SET @NPC := 135163; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-10955.42,`position_y`=-1963.914,`position_z`=80.2235 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,-10955.42,-1963.914,80.2235,0,0,0,0,100,0), +(@PATH,2,-10954.92,-1963.914,80.2235,0,0,0,0,100,0), +(@PATH,3,-10953.17,-1964.164,80.2235,0,0,0,0,100,0), +(@PATH,4,-10951.67,-1964.164,80.2235,0,0,0,0,100,0), +(@PATH,5,-10948.86,-1964.864,80.22345,0,0,0,0,100,0), +(@PATH,6,-10950.26,-1979.561,80.22365,0,0,0,0,100,0), +(@PATH,7,-10951.19,-1990.361,80.22372,0,0,0,0,100,0), +(@PATH,8,-10951.69,-1996.111,80.22372,0,0,0,0,100,0), +(@PATH,9,-10952.35,-2001.243,80.22384,0,0,0,0,100,0), +(@PATH,10,-10952.85,-2007.493,80.22384,0,0,0,0,100,0), +(@PATH,11,-10953.4,-2011.886,80.22395,0,0,0,0,100,0), +(@PATH,12,-10954.68,-2022.679,80.224,0,0,0,0,100,0), +(@PATH,13,-10954.93,-2024.179,80.224,0,0,0,0,100,0), +(@PATH,14,-10955.48,-2028.294,80.22382,0,0,0,0,100,0), +(@PATH,15,-10957.73,-2030.747,80.22321,0,0,0,0,100,0), +(@PATH,16,-10962.98,-2030.497,80.22321,0,0,0,0,100,0), +(@PATH,17,-10972.18,-2030.008,80.22282,0,0,0,0,100,0), +(@PATH,18,-10983.17,-2027.766,80.22281,0,0,0,0,100,0), +(@PATH,19,-10988.94,-2024.042,80.22321,0,0,0,0,100,0), +(@PATH,20,-10988.37,-2013.056,80.22353,0,0,0,0,100,0), +(@PATH,21,-10988.54,-2013.409,79.97359,0,0,0,0,100,0), +(@PATH,22,-10988.46,-2013.481,80.22325,0,0,0,0,100,0), +(@PATH,23,-10988.71,-2023.731,80.22325,0,0,0,0,100,0), +(@PATH,24,-10988.75,-2023.836,80.22316,0,0,0,0,100,0), +(@PATH,25,-10988.75,-2024.336,80.22316,0,0,0,0,100,0), +(@PATH,26,-10982.8,-2028.037,80.22272,0,0,0,0,100,0), +(@PATH,27,-10971.73,-2030.244,80.22316,0,0,0,0,100,0), +(@PATH,28,-10962.98,-2030.494,80.22316,0,0,0,0,100,0), +(@PATH,29,-10957.72,-2030.729,80.22354,0,0,0,0,100,0), +(@PATH,30,-10955.97,-2028.979,80.22354,0,0,0,0,100,0), +(@PATH,31,-10955.48,-2028.02,80.22393,0,0,0,0,100,0), +(@PATH,32,-10954.98,-2024.27,80.22393,0,0,0,0,100,0), +(@PATH,33,-10954.72,-2023.956,80.22394,0,0,0,0,100,0), +(@PATH,34,-10954.47,-2022.456,80.22394,0,0,0,0,100,0), +(@PATH,35,-10953.16,-2011.596,80.22389,0,0,0,0,100,0), +(@PATH,36,-10953.16,-2007.846,80.22389,0,0,0,0,100,0), +(@PATH,37,-10952.21,-2001.05,80.22374,0,0,0,0,100,0), +(@PATH,38,-10951.96,-1996.3,80.22374,0,0,0,0,100,0), +(@PATH,39,-10951.04,-1990.129,80.22367,0,0,0,0,100,0), +(@PATH,40,-10949.86,-1979.275,80.22361,0,0,0,0,100,0), +(@PATH,41,-10948.86,-1965.775,80.22361,0,0,0,0,100,0), +(@PATH,42,-10948.85,-1965.412,80.22345,0,0,0,0,100,0), +(@PATH,43,-10951.85,-1964.412,80.22345,0,0,0,0,100,0), +(@PATH,44,-10953.1,-1964.162,80.22345,0,0,0,0,100,0), +(@PATH,45,-10955.14,-1963.792,80.22339,0,0,0,0,100,0), +(@PATH,46,-10960.14,-1963.292,80.22339,0,0,0,0,100,0), +(@PATH,47,-10965.23,-1962.463,80.2235,0,0,0,0,100,0), +(@PATH,48,-10965.14,-1962.785,79.97355,0,0,0,0,100,0), +(@PATH,49,-10960.49,-1963.204,80.22346,0,0,0,0,100,0), +(@PATH,50,-10955.74,-1963.704,80.22346,0,0,0,0,100,0); +-- 0x1C310842801005C00053CE00049939B3 .go -10955.42 -1963.914 80.2235 + +SET @NPC := 135164; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-10966.42,`position_y`=-1982.83,`position_z`=80.22289 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,-10966.42,-1982.83,80.22289,0,0,0,0,100,0), +(@PATH,2,-10966.24,-1994.689,80.22308,0,0,0,0,100,0), +(@PATH,3,-10964.49,-1996.189,80.22308,0,0,0,0,100,0), +(@PATH,4,-10960.91,-2000.212,80.22343,0,0,0,0,100,0), +(@PATH,5,-10960.91,-2004.462,80.22343,0,0,0,0,100,0), +(@PATH,6,-10960.92,-2011.736,80.22325,0,0,0,0,100,0), +(@PATH,7,-10964.42,-2015.986,80.22325,0,0,0,0,100,0), +(@PATH,8,-10970.53,-2022.625,80.22308,0,0,0,0,100,0), +(@PATH,9,-10972.53,-2020.375,80.22308,0,0,0,0,100,0), +(@PATH,10,-10972.61,-2018.252,80.22304,0,0,0,0,100,0), +(@PATH,11,-10977.02,-2015.768,80.22273,0,0,0,0,100,0), +(@PATH,12,-10973.18,-2002.99,80.22287,0,0,0,0,100,0), +(@PATH,13,-10975.69,-1994.738,80.22289,0,0,0,0,100,0), +(@PATH,14,-10973.55,-1987.507,80.22292,0,0,0,0,100,0), +(@PATH,15,-10973.07,-1975.399,80.22276,0,0,0,0,100,0), +(@PATH,16,-10967.98,-1974.459,80.22279,0,0,0,0,100,0), +(@PATH,17,-10967.48,-1973.709,80.22279,0,0,0,0,100,0), +(@PATH,18,-10964.03,-1970.752,80.22292,0,0,0,0,100,0), +(@PATH,19,-10959.04,-1970.99,80.22316,0,0,0,0,100,0), +(@PATH,20,-10957.93,-1975.517,80.22319,0,0,0,0,100,0), +(@PATH,21,-10959.64,-1979.725,80.22298,0,0,0,0,100,0); +-- 0x1C310842801005C00053CE00051939B3 .go -10966.42 -1982.83 80.22289 + +SET @NPC := 135152; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-10993.07,`position_y`=-2027.777,`position_z`=79.97364 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,-10993.07,-2027.777,79.97364,0,0,0,0,100,0), +(@PATH,2,-10954.54,-2031.941,80.22369,0,0,0,0,100,0), +(@PATH,3,-10945.95,-1963.57,80.2234,0,0,0,0,100,0), +(@PATH,4,-10964.31,-1961.222,80.22327,0,0,0,0,100,0), +(@PATH,5,-10945.95,-1963.57,80.2234,0,0,0,0,100,0), +(@PATH,6,-10954.54,-2031.941,80.22369,0,0,0,0,100,0), +(@PATH,7,-10993.07,-2027.777,79.97364,0,0,0,0,100,0), +(@PATH,8,-10990.63,-2007.031,80.22373,0,0,0,0,100,0); +-- 0x1C310842801005C00053CE00059939B3 .go -10993.07 -2027.777 79.97364 + +SET @NPC := 135161; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-10940.92,`position_y`=-1998.817,`position_z`=93.95387 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,-10936.96,-1999.992,92.54521,0,0,0,0,100,0), +(@PATH,2,-10940.92,-1998.817,93.95387,0,0,0,0,100,0), +(@PATH,3,-10946.22,-2042.642,94.07538,0,0,0,0,100,0), +(@PATH,4,-11002.46,-2037.389,94.07399,0,0,0,0,100,0), +(@PATH,5,-10997.76,-1988.969,94.08043,0,0,0,0,100,0), +(@PATH,6,-11001.04,-1986.668,94.07949,0,0,0,0,100,0), +(@PATH,7,-11019.84,-1984.078,94.08058,0,0,0,0,100,0), +(@PATH,8,-11021.94,-1979.799,94.07922,0,0,0,0,100,0), +(@PATH,9,-11021.18,-1971.51,94.07477,0,0,0,0,100,0), +(@PATH,10,-11021.94,-1979.799,94.07922,0,0,0,0,100,0), +(@PATH,11,-11019.84,-1984.078,94.08058,0,0,0,0,100,0), +(@PATH,12,-11001.04,-1986.668,94.07949,0,0,0,0,100,0), +(@PATH,13,-10997.76,-1988.969,94.08043,0,0,0,0,100,0), +(@PATH,14,-11002.46,-2037.389,94.07399,0,0,0,0,100,0), +(@PATH,15,-10946.22,-2042.642,94.07538,0,0,0,0,100,0), +(@PATH,16,-10940.92,-1998.817,93.95387,0,0,0,0,100,0); +-- 0x1C310842801005C00053CE00061939B3 .go -10936.96 -1999.992 92.54521 + +SET @NPC := 135166; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-11018.67,`position_y`=-1948.95,`position_z`=94.11409 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,-11018.67,-1948.95,94.11409,0,0,0,0,100,0), +(@PATH,2,-11019.33,-1955.598,94.06949,0,0,0,0,100,0), +(@PATH,3,-11017.58,-1958.348,94.06949,0,0,0,0,100,0), +(@PATH,4,-11015.82,-1960.591,94.07437,0,0,0,0,100,0), +(@PATH,5,-11010.95,-1961.954,94.07813,0,0,0,0,100,0), +(@PATH,6,-11005.31,-1962.993,94.07982,0,0,0,0,100,0), +(@PATH,7,-11000.51,-1962.511,94.08182,0,0,0,0,100,0), +(@PATH,8,-10997.26,-1960.511,94.08182,0,0,0,0,100,0), +(@PATH,9,-10997.06,-1960.231,94.07545,0,0,0,0,100,0), +(@PATH,10,-10993.45,-1956.026,94.0743,0,0,0,0,100,0), +(@PATH,11,-10992.71,-1952.289,94.06744,0,0,0,0,100,0), +(@PATH,12,-10992.46,-1951.039,94.06744,0,0,0,0,100,0), +(@PATH,13,-10989.33,-1951.245,94.06941,0,0,0,0,100,0), +(@PATH,14,-10989.58,-1952.745,94.06941,0,0,0,0,100,0), +(@PATH,15,-10990.44,-1956.788,94.07174,0,0,0,0,100,0), +(@PATH,16,-10992.64,-1960.311,94.07793,0,0,0,0,100,0), +(@PATH,17,-10999.8,-1964.796,94.08316,0,0,0,0,100,0), +(@PATH,18,-11003.42,-1967.318,94.08348,0,0,0,0,100,0), +(@PATH,19,-11005.92,-1969.318,94.08348,0,0,0,0,100,0), +(@PATH,20,-11009.72,-1972.45,94.08435,0,0,0,0,100,0), +(@PATH,21,-11006.94,-1976.569,94.08415,0,0,0,0,100,0), +(@PATH,22,-11005.19,-1978.569,94.08415,0,0,0,0,100,0), +(@PATH,23,-11002.7,-1981.706,94.08524,0,0,0,0,100,0), +(@PATH,24,-10996.71,-1985.477,94.08297,0,0,0,0,100,0), +(@PATH,25,-10993.34,-1986.766,94.08041,0,0,0,0,100,0), +(@PATH,26,-10998.21,-2033.577,94.07561,0,0,0,0,100,0), +(@PATH,27,-10949.22,-2039.019,94.07603,0,0,0,0,100,0), +(@PATH,28,-10941.91,-1976.454,94.07447,0,0,0,0,100,0), +(@PATH,29,-10941.03,-1973.073,94.07249,0,0,0,0,100,0), +(@PATH,30,-10941.03,-1970.573,94.07249,0,0,0,0,100,0), +(@PATH,31,-10938.04,-1944.34,94.0692,0,0,0,0,100,0), +(@PATH,32,-10944.45,-1938.374,94.06937,0,0,0,0,100,0), +(@PATH,33,-10945.51,-1937.203,94.07327,0,0,0,0,100,0), +(@PATH,34,-10942.28,-1905.302,93.82167,0,0,0,0,100,0), +(@PATH,35,-10945.63,-1937.244,94.0717,0,0,0,0,100,0), +(@PATH,36,-10944.63,-1938.244,94.0717,0,0,0,0,100,0), +(@PATH,37,-10938.18,-1944.174,94.06793,0,0,0,0,100,0), +(@PATH,38,-10940.76,-1970.675,94.07205,0,0,0,0,100,0), +(@PATH,39,-10941.05,-1973.169,94.07341,0,0,0,0,100,0), +(@PATH,40,-10942.1,-1976.591,94.07454,0,0,0,0,100,0), +(@PATH,41,-10949.38,-2038.871,94.07526,0,0,0,0,100,0), +(@PATH,42,-10998.12,-2033.78,94.07454,0,0,0,0,100,0), +(@PATH,43,-10993.17,-1986.922,94.08283,0,0,0,0,100,0), +(@PATH,44,-10996.42,-1985.672,94.08283,0,0,0,0,100,0), +(@PATH,45,-11002.46,-1981.708,94.08536,0,0,0,0,100,0), +(@PATH,46,-11005.32,-1978.522,94.08371,0,0,0,0,100,0), +(@PATH,47,-11007.07,-1976.272,94.08371,0,0,0,0,100,0), +(@PATH,48,-11009.86,-1972.258,94.08409,0,0,0,0,100,0), +(@PATH,49,-11006.01,-1968.957,94.08367,0,0,0,0,100,0), +(@PATH,50,-11003.51,-1967.457,94.08367,0,0,0,0,100,0), +(@PATH,51,-10999.68,-1964.603,94.08018,0,0,0,0,100,0), +(@PATH,52,-10992.57,-1960.071,94.07755,0,0,0,0,100,0), +(@PATH,53,-10990.57,-1957.071,94.07755,0,0,0,0,100,0), +(@PATH,54,-10989.64,-1952.785,94.06929,0,0,0,0,100,0), +(@PATH,55,-10989.41,-1951.198,94.06895,0,0,0,0,100,0), +(@PATH,56,-10992.41,-1950.948,94.06895,0,0,0,0,100,0), +(@PATH,57,-10992.66,-1952.448,94.06895,0,0,0,0,100,0), +(@PATH,58,-10993.41,-1956.079,94.07048,0,0,0,0,100,0), +(@PATH,59,-10997.04,-1960.266,94.07538,0,0,0,0,100,0), +(@PATH,60,-11000.84,-1962.545,94.08139,0,0,0,0,100,0), +(@PATH,61,-11005.54,-1962.94,94.07911,0,0,0,0,100,0), +(@PATH,62,-11011.18,-1961.785,94.07573,0,0,0,0,100,0), +(@PATH,63,-11015.9,-1960.729,94.07407,0,0,0,0,100,0), +(@PATH,64,-11017.4,-1958.479,94.07407,0,0,0,0,100,0), +(@PATH,65,-11019.35,-1955.508,94.06929,0,0,0,0,100,0); +-- 0x1C310842801005C00053CE00069939B3 .go -11018.67 -1948.95 94.11409 + +SET @NPC := 135308; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-10979.41,`position_y`=-1917.581,`position_z`=79.1259 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,-10979.41,-1917.581,79.1259,0,0,0,0,100,0), +(@PATH,2,-10998.85,-1915.525,79.12059,0,0,0,0,100,0), +(@PATH,3,-11004.85,-1917.525,79.12059,0,0,0,0,100,0), +(@PATH,4,-11006.42,-1919.255,79.13147,0,0,0,0,100,0), +(@PATH,5,-11009.31,-1923.276,79.13788,0,0,0,0,100,0), +(@PATH,6,-11014.77,-1924.695,79.11803,0,0,0,0,100,0), +(@PATH,7,-11025.74,-1923.575,79.06779,0,0,0,0,100,0), +(@PATH,8,-11039.73,-1922.107,77.51696,0,0,0,0,100,0), +(@PATH,9,-11050.26,-1923.549,77.51479,0,0,0,0,100,0), +(@PATH,10,-11062.01,-1926.049,77.51479,0,0,0,0,100,0), +(@PATH,11,-11068.23,-1927.658,77.51482,0,0,0,0,100,0), +(@PATH,12,-11050.19,-1925.471,77.51665,0,0,0,0,100,0), +(@PATH,13,-11039.85,-1924.404,77.56751,0,0,0,0,100,0), +(@PATH,14,-11025.49,-1925.841,79.11525,0,0,0,0,100,0), +(@PATH,15,-11014.73,-1927.159,79.11803,0,0,0,0,100,0), +(@PATH,16,-11010.48,-1927.909,79.11803,0,0,0,0,100,0), +(@PATH,17,-11008.93,-1928.397,79.11803,0,0,0,0,100,0), +(@PATH,18,-11007.43,-1929.897,79.11803,0,0,0,0,100,0), +(@PATH,19,-11004.79,-1932.291,79.11801,0,0,0,0,100,0), +(@PATH,20,-10995.54,-1934.041,79.11801,0,0,0,0,100,0), +(@PATH,21,-10970.88,-1936.847,79.11803,0,0,0,0,100,0), +(@PATH,22,-10965.63,-1935.597,79.11803,0,0,0,0,100,0), +(@PATH,23,-10963.02,-1932.276,79.11803,0,0,0,0,100,0), +(@PATH,24,-10960.78,-1928.736,79.11803,0,0,0,0,100,0), +(@PATH,25,-10962.28,-1925.236,79.11803,0,0,0,0,100,0), +(@PATH,26,-10963.28,-1922.127,79.1109,0,0,0,0,100,0), +(@PATH,27,-10968.51,-1919.033,79.11447,0,0,0,0,100,0); +-- 0x1C310842801007C00053CE00001939B3 .go -10979.41 -1917.581 79.1259 + +SET @NPC := 135311; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-10967.35,`position_y`=-1910.074,`position_z`=79.13056 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,-10967.35,-1910.074,79.13056,0,0,0,0,100,0), +(@PATH,2,-10973.81,-1909.259,79.13441,0,0,0,0,100,0), +(@PATH,3,-10978.96,-1902.012,79.11913,0,0,0,0,100,0), +(@PATH,4,-10993.51,-1900.544,79.10841,0,0,0,0,100,0), +(@PATH,5,-10998.31,-1904.632,79.0873,0,0,0,0,100,0), +(@PATH,6,-11008.63,-1904.277,79.12164,0,0,0,0,100,0), +(@PATH,7,-11016.06,-1902.035,79.11803,0,0,0,0,100,0), +(@PATH,8,-11018.93,-1894.202,79.11803,0,0,0,0,100,0), +(@PATH,9,-11013.55,-1888.369,79.11407,0,0,0,0,100,0), +(@PATH,10,-11005.47,-1887.72,79.09593,0,0,0,0,100,0), +(@PATH,11,-10997.97,-1889.47,79.09593,0,0,0,0,100,0), +(@PATH,12,-10993.66,-1894.292,79.0679,0,0,0,0,100,0), +(@PATH,13,-10993.11,-1896.752,79.08858,0,0,0,0,100,0), +(@PATH,14,-10978.52,-1899.429,79.14062,0,0,0,0,100,0), +(@PATH,15,-10971.52,-1891.436,79.14864,0,0,0,0,100,0), +(@PATH,16,-10968.58,-1890.591,79.14295,0,0,0,0,100,0), +(@PATH,17,-10964.36,-1890.848,79.12196,0,0,0,0,100,0), +(@PATH,18,-10958.21,-1891.544,78.85779,0,0,0,0,100,0), +(@PATH,19,-10953.68,-1895.616,79.11803,0,0,0,0,100,0), +(@PATH,20,-10951.67,-1902.097,79.12449,0,0,0,0,100,0), +(@PATH,21,-10954.11,-1907.472,79.1279,0,0,0,0,100,0), +(@PATH,22,-10957.36,-1910.472,79.1279,0,0,0,0,100,0); +-- 0x1C310842801007C00053CE00009939B3 .go -10967.35 -1910.074 79.13056 + +SET @NPC := 135307; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-11097.81,`position_y`=-1933.661,`position_z`=50.14211 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,-11097.81,-1933.661,50.14211,0,0,0,0,100,0), +(@PATH,2,-11102.14,-1941.538,50.13525,0,0,0,0,100,0), +(@PATH,3,-11110.07,-1946.739,50.13507,0,0,0,0,100,0), +(@PATH,4,-11116.22,-1949.221,50.13885,0,0,0,0,100,0), +(@PATH,5,-11127.4,-1949.477,50.13752,0,0,0,0,100,0), +(@PATH,6,-11137.96,-1945.1,50.13647,0,0,0,0,100,0), +(@PATH,7,-11127.29,-1949.459,50.13817,0,0,0,0,100,0), +(@PATH,8,-11116.23,-1949.254,50.13683,0,0,0,0,100,0), +(@PATH,9,-11110.07,-1946.739,50.13507,0,0,0,0,100,0), +(@PATH,10,-11102.14,-1941.538,50.13525,0,0,0,0,100,0); +-- 0x1C310842800FC7C00053CE00001939B3 .go -11097.81 -1933.661 50.14211 |