diff options
| -rw-r--r-- | sql/updates/world/master/2021_03_14_01_world_2017_12_16_01_world.sql | 212 |
1 files changed, 212 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_03_14_01_world_2017_12_16_01_world.sql b/sql/updates/world/master/2021_03_14_01_world_2017_12_16_01_world.sql new file mode 100644 index 00000000000..22ce91a7fd2 --- /dev/null +++ b/sql/updates/world/master/2021_03_14_01_world_2017_12_16_01_world.sql @@ -0,0 +1,212 @@ +-- missing creatures -- +DELETE FROM creature WHERE guid IN (16668,16669,82879,82899,82915,84418,84423,84432,84436,84437,84439); +INSERT INTO creature (guid, id, modelid, map, spawnDifficulties, PhaseId, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, curhealth, curmana, MovementType) VALUES +-- Acherus Necromancer +(16668,28889,0,609,'0',171,2105.21,-6131.12,6.17389,0.168441,360,0,8982,0,2), +(16669,28889,0,609,'0',171,2117.44,-5762.23,98.3189,1.36616,360,0,8982,0,2), +(82879,28889,0,609,'0',171,2153.62,-5878.11,101.263,4.94146,360,0,8982,0,2), +-- Scarlet Ghoul -- fast respawntime needed for event +(82899,28897,0,609,'0',171,2077.1,-5744.47,99.3915,3.69346,30,0,925,0,2), +(82915,28897,0,609,'0',171,2090.98,-5772.49,99.1364,3.00624,30,0,891,0,2), +(84418,28897,0,609,'0',171,2130.24,-5786.56,98.8595,3.53639,30,0,925,0,2), +(84423,28897,0,609,'0',171,2132.06,-5680.27,101.872,3.74295,30,0,925,0,2), +(84432,28897,0,609,'0',171,2146.72,-5850.4,101.348,2.97874,30,0,960,0,2), +(84436,28897,0,609,'0',171,2146.68,-5891.05,101.386,2.83344,30,0,891,0,2), +(84437,28897,0,609,'0',171,2170.08,-5862.69,101.377,3.13975,30,0,960,0,2), +(84439,28897,0,609,'0',171,2163.73,-5819.37,101.347,3.34395,30,0,960,0,2); +-- Gluttonous Geist +UPDATE creature SET spawndist = 10, MovementType = 1, spawntimesecs = 25 WHERE guid BETWEEN 130297 AND 130331; +UPDATE creature SET position_x = 2179.580078, position_y = -5735.517578, position_z = 102.051216, orientation = 0.28 WHERE guid = 130321; +UPDATE creature SET position_x = 2285.824463, position_y = -5825.710938, position_z = 100.934158, orientation = 6.24 WHERE guid = 130316; +UPDATE creature SET position_x = 2424.753418, position_y = -5879.221191, position_z = 104.670280, orientation = 2.05 WHERE guid = 130323; +UPDATE creature SET position_x = 2352.291992, position_y = -5857.714844, position_z = 102.684357, orientation = 1.54 WHERE guid = 130315; +UPDATE creature SET position_x = 2237.403320, position_y = -5911.937988, position_z = 100.284546, orientation = 5.57 WHERE guid = 130311; +UPDATE creature SET position_x = 2207.168457, position_y = -5783.182617, position_z = 101.517105, orientation = 4.78 WHERE guid = 130320; +UPDATE creature SET position_x = 2108.11, position_y = -5844.99, position_z = 102.581, orientation = 3.31 WHERE guid = 130301; +-- Acherus Necromancer +UPDATE creature SET position_x = 2239.78, position_y = -6059.1, position_z = 5.76, orientation = 4.1 WHERE guid = 130118; +UPDATE creature SET position_x = 2193.64, position_y = -6099.1, position_z = 1.52, orientation = 1.84 WHERE guid = 130120; +UPDATE creature SET position_x = 2251.14, position_y = -6139.8, position_z = 1.86, orientation = 1.98 WHERE guid = 130119; +UPDATE creature SET spawndist = 0, MovementType = 2 WHERE guid IN (130118,130119,130120,16668,16669,82879); +DELETE FROM waypoint_data WHERE id IN (1301180,1301190,1301200,166680,166690,828790); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `action`, `orientation`, `action_chance`, `move_type`) VALUES +-- 1st +(1301180,1,2234.99,-6065.31,5.73,31000,0,4.29,100,0), +(1301180,2,2240.05,-6060.546,5.688,40000,0,0,100,0), +(1301180,3,2248.52,-6078.31,6.09,31000,0,4.90,100,0), +(1301180,4,2240.05,-6060.546,5.688,40000,0,0,100,0), +-- 2nd +(1301200,1,2199.24,-6095.62,1.83137,31000,0,0.639755,100,0), +(1301200,2,2193.64,-6099.1,1.52,40000,0,0,100,0), +(1301200,3,2188.74,-6091.56,1.91467,31000,0,1.92388,100,0), +(1301200,4,2193.64,-6099.1,1.52,40000,0,0,100,0), +-- 3rd +(1301190,1,2258.88,-6144.58,2.50571,31000,0,5.62306,100,0), +(1301190,2,2251.14,-6139.8,1.86,40000,0,0,100,0), +(1301190,3,2247.4,-6147.9,2.02971,31000,0,4.47245,100,0), +(1301190,4,2251.14,-6139.8,1.86,40000,0,0,100,0), +-- 4th +(166680,1,2115.99,-6144.1,3.84152,40000,0,5.46595,100,0), +(166680,2,2105.21,-6131.12,6.17389,31000,0,0,100,0), +(166680,3,2112.93,-6120.35,7.26217,40000,0,1.12662,100,0), +(166680,4,2105.21,-6131.12,6.17389,31000,0,0,100,0), +-- 5th +(166690,1,2124.6,-5749.84,98.8654,31000,0,1.02847,100,0), +(166690,2,2117.44,-5762.23,98.3189,40000,0,0,100,0), +(166690,3,2109.09,-5755.77,98.9729,31000,0,2.48049,100,0), +(166690,4,2117.44,-5762.23,98.3189,40000,0,0,100,0), +-- 6th +(828790,1,2149.98,-5888.45,101.283,40000,0,3.84142,100,0), +(828790,2,2153.62,-5878.11,101.263,31000,0,0,100,0), +(828790,3,2162.13,-5881.28,101.332,40000,0,6.04446,100,0), +(828790,4,2153.62,-5878.11,101.263,31000,0,0,100,0); + +DELETE FROM `creature_addon` WHERE `guid` IN (130118,130119,130120,16668,16669,82879); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(130118,1301180,0,1,0,""), +(130119,1301190,0,1,0,""), +(130120,1301200,0,1,0,""), +(16668,166680,0,1,0,""), +(16669,166690,0,1,0,""), +(82879,828790,0,1,0,""); + +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=28889; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (28889,28897) AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(28889,0,0,0,34,0,100,0,2,0,0,0,11,52683,0,0,0,0,0,1,0,0,0,0,0,0,0,"Acherus Necromancer - On movement informer - Cast Scarlet Ghoul"), +(28889,0,1,0,34,0,100,0,2,3,0,0,11,52683,0,0,0,0,0,1,0,0,0,0,0,0,0,"Acherus Necromancer - On movement informer - Cast Scarlet Ghoul"), +(28897, 0, 0, 0, 25, 0, 100, 0, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Scarlet Ghoul - On reset - Set Active On"), +(28897, 0, 1, 0, 54, 0, 100, 0, 0, 0, 0, 0, 53, 1, 28897, 0, 0, 0, 2, 1, 0, 0, 0, 0, 0, 0, 0, "Scarlet Ghoul - On Just summoned - Start Waypoint"), +(28897, 0, 2, 3, 54, 0, 100, 0, 0, 0, 0, 0, 41, 300000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Scarlet Ghoul - On Just summoned - Despawn In 300000 ms"), +(28897, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 5000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Scarlet Ghoul - On Just summoned - Say Line 0"), +(28897, 0, 5, 0, 54, 0, 100, 0, 0, 0, 0, 0, 53, 1, 288970, 0, 0, 0, 2, 1, 0, 0, 0, 0, 0, 0, 0, "Scarlet Ghoul - On Just summoned - Start Waypoint"); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry` IN (28897); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(22, 2, 28897, 0, 0, 23, 1, 4354, 0, 0, 1, 0, 0, '', 'Scarlet Ghoul SAI'), +(22, 6, 28897, 0, 0, 23, 1, 4354, 0, 0, 0, 0, 0, '', 'Scarlet Ghoul SAI'); + +-- Scralet Ghoul +UPDATE creature_template SET MovementType = 0, InhabitType = 3 WHERE entry = 28897; +DELETE FROM `creature_template_addon` WHERE `entry` IN (28897); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(28897,0,0,1,0,""); + +DELETE FROM `waypoints` WHERE `entry`=288970; +INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`) VALUES +(288970,1,2109.46,-6060.24,5.68025), +(288970,2,2070.14,-6009.97,14.1785), +(288970,3,2026.73,-5988.91,34.4922), +(288970,4,2012.75,-5986.29,41.7496), +(288970,5,1968.02,-5981.75,78.1271), +(288970,6,1940.42,-5973.18,100.583), +(288970,7,1889.64,-5929.67,103.984), +(288970,8,1853.33,-5918.92,105.118), +(288970,9,1805.12,-5934.13,115.66), +(288970,10,1724.81,-5922.4,117.299); + +-- Waypoints +UPDATE creature SET spawndist = 0, MovementType = 2 WHERE guid IN (82899,82915,84418,84423,84432,84436,84437,84439); +DELETE FROM `creature_addon` WHERE `guid` IN (82899,82915,84418,84423,84432,84436,84437,84439); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(82899,828990,0,1,0,""), +(82915,829150,0,1,0,""), +(84418,844180,0,1,0,""), +(84423,844230,0,1,0,""), +(84432,844320,0,1,0,""), +(84436,844360,0,1,0,""), +(84437,844370,0,1,0,""), +(84439,844390,0,1,0,""); + +DELETE FROM waypoint_data WHERE id IN (828990,829150,844180,844230,844320,844360,844370,844390); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `action`, `orientation`, `action_chance`, `move_type`) VALUES +-- Scarlet Ghoul +-- #1 +(828990,1,2077.1,-5744.47,99.3915,2000,0,3.69346,100,1), +(828990,2,2037.4,-5753.16,98.4207,0,0,3.62744,100,1), +(828990,3,2016.68,-5768.47,102.027,0,0,3.85128,100,1), +(828990,4,1988.66,-5790.4,100.921,0,0,3.76096,100,1), +(828990,5,1955.34,-5805.9,101.012,0,0,3.41931,100,1), +(828990,6,1923.02,-5809.99,100.145,0,0,3.17191,100,1), +(828990,7,1883.31,-5811.93,102.057,0,0,3.26223,100,1), +(828990,8,1845.49,-5811.9,100.457,0,0,3.13657,100,1), +(828990,9,1818.34,-5814.16,104.528,0,0,3.23081,100,1), +(828990,10,1790.43,-5813.92,112.024,0,0,3.11301,100,1), +(828990,11,1771.37,-5801.06,116.041,0,0,2.57501,100,1), +(828990,12,1744.92,-5785.9,116.122,0,0,2.81063,100,1), +(828990,13,1699.92,-5778.87,113.453,30000,1188,0,100,1), +-- #2 +(829150,1,2090.98,-5772.49,99.1364,2000,0,3.00624,100,1), +(829150,2,2074.1,-5788.09,101.267,0,0,3.81592,100,1), +(829150,3,2057.83,-5799.68,101.801,0,0,3.66277,100,1), +(829150,4,2034.62,-5803.96,100.546,0,0,3.23473,100,1), +(829150,5,1989.39,-5810.89,100.804,0,0,3.23866,100,1), +(829150,6,1940.36,-5843.1,100.335,0,0,3.54496,100,1), +(829150,7,1893.36,-5846.78,101.331,0,0,3.14441,100,1), +(829150,8,1852.1,-5836.64,101.806,0,0,2.89308,100,1), +(829150,9,1836.54,-5830.45,100.72,0,0,2.71244,100,1), +(829150,10,1812.11,-5822.54,105.733,0,0,2.90643,100,1), +(829150,11,1792.25,-5822.46,111.503,0,0,3.18918,100,1), +(829150,12,1749.64,-5832.9,116.486,30000,1188,0,100,1), +-- #3 +(844180,1,2130.24,-5786.56,98.8595,2000,0,3.53639,100,1), +(844180,2,2108.39,-5791.13,99.6639,0,0,3.31091,100,1), +(844180,3,2083.15,-5805.23,102.845,0,0,3.7743,100,1), +(844180,4,2068.88,-5827.84,102.066,0,0,4.01385,100,1), +(844180,5,2036.77,-5848.15,100.365,0,0,3.61329,100,1), +(844180,6,1978.2,-5853.32,100.708,0,0,3.08314,100,1), +(844180,7,1939.37,-5848.67,100.858,0,0,3.1499,100,1), +(844180,8,1889.51,-5831.7,101.353,0,0,2.8593,100,1), +(844180,9,1842.17,-5818.86,100.294,0,0,3.13262,100,1), +(844180,10,1806.12,-5818.45,107.736,0,0,3.0423,100,1), +(844180,11,1775.45,-5818.74,115.4,30000,1188,0,100,1), +-- #4 +(844230,1,2132.06,-5680.27,101.872,2000,0,3.74295,100,1), +(844230,2,2095.29,-5701.47,100.297,0,0,3.67382,100,1), +(844230,3,2044.51,-5738.45,98.9834,0,0,3.47747,100,1), +(844230,4,1991.4,-5752.36,101.254,0,0,3.38715,100,1), +(844230,5,1934.35,-5757.02,105.033,0,0,3.75079,100,1), +(844230,6,1881.51,-5781.34,103.301,0,0,3.527,100,1), +(844230,7,1841.71,-5798.38,101.761,0,0,3.40919,100,1), +(844230,8,1807.28,-5817.31,107.472,0,0,3.25996,100,1), +(844230,9,1775.64,-5821.64,115.384,0,0,3.12252,100,1), +(844230,10,1735.1,-5821.55,116.123,0,0,2.98115,100,1), +(844230,11,1699.1,-5781.46,113.715,30000,1188,0,100,1), +-- #5 +(844320,1,2146.72,-5850.4,101.348,2000,0,2.97874,100,1), +(844320,2,2113.71,-5845.58,103.176,0,0,2.69361,100,1), +(844320,3,2062.49,-5812.86,103.405,0,0,2.8664,100,1), +(844320,4,2033.06,-5803.11,100.477,0,0,3.12165,100,1), +(844320,5,1981.41,-5808.84,100.994,0,0,3.41617,100,1), +(844320,6,1938.5,-5809.06,100.369,0,0,3.01719,100,1), +(844320,7,1887.08,-5806.34,101.47,0,0,3.10359,100,1), +(844320,8,1837.55,-5812.48,101.002,0,0,3.24103,100,1), +(844320,9,1762.94,-5838.98,116.452,30000,1188,0,100,1), +-- #6 +(844360,1,2146.68,-5891.05,101.386,2000,0,2.83344,100,1), +(844360,2,2118.53,-5903.55,104.329,0,0,3.53163,100,1), +(844360,3,2076.95,-5910.58,106.063,0,0,3.31957,100,1), +(844360,4,2024.11,-5921.23,105.048,0,0,3.42167,100,1), +(844360,5,1974.84,-5932.61,103.075,0,0,2.95463,100,1), +(844360,6,1901.55,-5926.27,102.896,0,0,3.04888,100,1), +(844360,7,1838.23,-5925.68,108.629,0,0,3.19418,100,1), +(844360,8,1805.08,-5924.84,115.492,0,0,2.96641,100,1), +(844360,9,1754.33,-5910.94,116.066,30000,1188,0,100,1), +-- #7 +(844370,1,2170.08,-5862.69,101.377,2000,0,3.13975,100,1), +(844370,2,2142.05,-5859.07,101.352,0,0,2.97007,100,1), +(844370,3,2082.66,-5886.58,104.147,0,0,3.64944,100,1), +(844370,4,2028.09,-5908.18,104.992,0,0,3.31957,100,1), +(844370,5,1961.21,-5907.68,102.35,0,0,3.13107,100,1), +(844370,6,1895.26,-5906.86,101.947,0,0,3.17034,100,1), +(844370,7,1850.95,-5908.88,104.766,0,0,3.36277,100,1), +(844370,8,1813.52,-5931.68,114.631,30000,1188,0,100,1), +-- #8 +(844390,1,2163.73,-5819.37,101.347,2000,0,3.34395,100,1), +(844390,2,2113.22,-5847.34,103.411,0,0,3.45855,100,1), +(844390,3,2052.44,-5861.79,102.836,0,0,3.33682,100,1), +(844390,4,2001.1,-5892.32,101.117,0,0,3.77271,100,1), +(844390,5,1981.55,-5900.67,102.871,0,0,3.33053,100,1), +(844390,6,1911.11,-5907.35,101.617,0,0,3.25985,100,1), +(844390,7,1858.52,-5910.56,104.28,0,0,3.17738,100,1), +(844390,8,1804.56,-5934.23,115.703,30000,1188,3.59757,100,1); |