diff options
| -rw-r--r-- | sql/updates/world/master/2022_08_29_00_world.sql | 110 |
1 files changed, 110 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_08_29_00_world.sql b/sql/updates/world/master/2022_08_29_00_world.sql new file mode 100644 index 00000000000..f0d83893ff4 --- /dev/null +++ b/sql/updates/world/master/2022_08_29_00_world.sql @@ -0,0 +1,110 @@ +SET @CGUID := 1051321; +SET @OGUID := 600229; + +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+63; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 161006, 2175, 10424, 11011, '0', 0, 0, 0, 0, 248.15972900390625, -2011.6163330078125, 79.40108489990234375, 1.519477725028991699, 7200, 0, 0, 149, 0, 0, 0, 0, 0, 45114), -- Ogre Shadowcaster (Area: -Unknown- - Difficulty: 0) (Auras: 145363 - Permanent Feign Death (Stun, Untrackable, Immune)) +(@CGUID+1, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 288.19781494140625, -1992.7802734375, 77.91809844970703125, 3.541005373001098632, 7200, 4, 0, 5, 0, 2, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+2, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 295.2821044921875, -1992.187744140625, 77.87058258056640625, 1.164662003517150878, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+3, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 274.635986328125, -1996.230712890625, 78.062652587890625, 4.651137828826904296, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+4, 161006, 2175, 10424, 11011, '0', 0, 0, 0, 0, 239.1354217529296875, -2027.876708984375, 79.94861602783203125, 1.998577237129211425, 7200, 0, 0, 149, 0, 0, 0, 0, 0, 45114), -- Ogre Shadowcaster (Area: -Unknown- - Difficulty: 0) (Auras: 145363 - Permanent Feign Death (Stun, Untrackable, Immune)) +(@CGUID+5, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 270.150421142578125, -1998.6605224609375, 77.807098388671875, 5.127995967864990234, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+6, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 269.310333251953125, -1993.9666748046875, 77.83879852294921875, 2.889052629470825195, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+7, 172027, 2175, 10424, 11011, '0', 0, 0, 0, 0, 311.005218505859375, -1975.232666015625, 77.44677734375, 1.249116301536560058, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Nibbling Scavenger (Area: -Unknown- - Difficulty: 0) +(@CGUID+8, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 279.6104736328125, -1998.158203125, 78.1585693359375, 5.684083461761474609, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+9, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 286.692840576171875, -1998.408935546875, 78.055999755859375, 5.289997100830078125, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+10, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 294.103973388671875, -1987.12890625, 77.55968475341796875, 0.594617247581481933, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+11, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 276.203399658203125, -1998.2034912109375, 78.1262054443359375, 2.65345931053161621, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+12, 172027, 2175, 10424, 11011, '0', 0, 0, 0, 0, 310.01910400390625, -1981.0972900390625, 77.927154541015625, 0.109653525054454803, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Nibbling Scavenger (Area: -Unknown- - Difficulty: 0) +(@CGUID+13, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 301.752288818359375, -1983.2999267578125, 77.96352386474609375, 2.839550495147705078, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+14, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 284.022857666015625, -1987.0972900390625, 77.83969879150390625, 5.160910606384277343, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+15, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 299.850738525390625, -1990.1983642578125, 78.0007171630859375, 1.234702587127685546, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+16, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 297.892852783203125, -1989.4344482421875, 77.7454071044921875, 2.735143899917602539, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+17, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 292.26495361328125, -1997.93896484375, 77.827423095703125, 0.947819709777832031, 7200, 4, 0, 5, 0, 0, 1, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+18, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 269.71197509765625, -1992.8385009765625, 77.83599090576171875, 6.127718925476074218, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+19, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 281.730133056640625, -1992.7728271484375, 78.377716064453125, 2.958071708679199218, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+20, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 280.58221435546875, -2000.6510009765625, 78.05225372314453125, 3.804633617401123046, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+21, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 270.30792236328125, -1997.654052734375, 77.80768585205078125, 4.148012161254882812, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+22, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 297.848907470703125, -1984.603515625, 77.38451385498046875, 0.43133711814880371, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+23, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 273.777587890625, -1988.8291015625, 77.81970977783203125, 5.193759441375732421, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+24, 172027, 2175, 10424, 11011, '0', 0, 0, 0, 0, 298.623260498046875, -1977.1927490234375, 77.73435211181640625, 1.250232696533203125, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Nibbling Scavenger (Area: -Unknown- - Difficulty: 0) +(@CGUID+25, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 289.356109619140625, -1983.24609375, 77.770355224609375, 5.603207588195800781, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+26, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 269.793182373046875, -1992.7335205078125, 77.8348236083984375, 0.517088353633880615, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+27, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 300.877685546875, -1989.7099609375, 78.08319854736328125, 1.468073010444641113, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+28, 172027, 2175, 10424, 11011, '0', 0, 0, 0, 0, 299.388885498046875, -1976.8350830078125, 77.73435211181640625, 2.304511070251464843, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Nibbling Scavenger (Area: -Unknown- - Difficulty: 0) +(@CGUID+29, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 289.194793701171875, -1979.338134765625, 77.71779632568359375, 0.016641009598970413, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+30, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 283.11492919921875, -1986.8773193359375, 77.7598114013671875, 3.591572284698486328, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+31, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 269.735107421875, -2002.2535400390625, 77.86246490478515625, 5.228423595428466796, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+32, 161006, 2175, 10424, 11011, '0', 0, 0, 0, 0, 224.798614501953125, -2021.9947509765625, 79.75852203369140625, 4.973180770874023437, 7200, 0, 0, 149, 0, 0, 0, 0, 0, 45114), -- Ogre Shadowcaster (Area: -Unknown- - Difficulty: 0) (Auras: 145363 - Permanent Feign Death (Stun, Untrackable, Immune)) +(@CGUID+33, 172027, 2175, 10424, 11011, '0', 0, 0, 0, 0, 285.251739501953125, -1998.3785400390625, 77.73626708984375, 3.679943084716796875, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Nibbling Scavenger (Area: -Unknown- - Difficulty: 0) +(@CGUID+34, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 283.04351806640625, -1997.1580810546875, 78.05489349365234375, 4.906396865844726562, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+35, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 271.849456787109375, -2004.9453125, 77.8506011962890625, 0.926486432552337646, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+36, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 274.5906982421875, -1999.092529296875, 78.04541778564453125, 0.966549694538116455, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+37, 161006, 2175, 10424, 11011, '0', 0, 0, 0, 0, 223.65972900390625, -2012.5816650390625, 80.46463775634765625, 6.282768726348876953, 7200, 0, 0, 149, 0, 0, 0, 0, 0, 45114), -- Ogre Shadowcaster (Area: -Unknown- - Difficulty: 0) (Auras: 145363 - Permanent Feign Death (Stun, Untrackable, Immune)) +(@CGUID+38, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 299.300506591796875, -1986.4254150390625, 77.61298370361328125, 1.640192627906799316, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+39, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 271.510589599609375, -2000.8414306640625, 77.7993927001953125, 3.993740081787109375, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+40, 172027, 2175, 10424, 11011, '0', 0, 0, 0, 0, 297.53472900390625, -1977.01220703125, 77.70937347412109375, 0.707951843738555908, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Nibbling Scavenger (Area: -Unknown- - Difficulty: 0) +(@CGUID+41, 172026, 2175, 10424, 11011, '0', 0, 0, 0, 0, 295.72540283203125, -1984.094482421875, 77.24219512939453125, 3.971421241760253906, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Cockroach (Area: -Unknown- - Difficulty: 0) +(@CGUID+42, 154268, 2175, 10424, 11011, '0', 0, 0, 0, 0, 212.750762939453125, -2040.2274169921875, 96.8371124267578125, 4.7701416015625, 7200, 0, 0, 136, 0, 0, 0, 0, 0, 45114), -- Hungry Vulture (Area: -Unknown- - Difficulty: 0) +(@CGUID+43, 154268, 2175, 10424, 11011, '0', 0, 0, 0, 0, 172.9589996337890625, -2073.767333984375, 104.377655029296875, 1.304056048393249511, 7200, 0, 0, 136, 0, 0, 0, 0, 0, 45114), -- Hungry Vulture (Area: -Unknown- - Difficulty: 0) +(@CGUID+44, 171997, 2175, 10424, 11011, '0', 0, 0, 0, 0, 248.3645782470703125, -2027.9271240234375, 106.019134521484375, 2.400225639343261718, 7200, 0, 0, 149, 0, 0, 0, 0, 0, 45114), -- Woodlands Watcher (Area: -Unknown- - Difficulty: 0) +(@CGUID+45, 161006, 2175, 10424, 11011, '0', 0, 0, 0, 0, 220.173614501953125, -2039.3038330078125, 78.941680908203125, 4.481699466705322265, 7200, 0, 0, 149, 0, 0, 0, 0, 0, 45114), -- Ogre Shadowcaster (Area: -Unknown- - Difficulty: 0) (Auras: 145363 - Permanent Feign Death (Stun, Untrackable, Immune)) +(@CGUID+46, 154268, 2175, 10424, 11011, '0', 0, 0, 0, 0, 184.22711181640625, -2088.139404296875, 111.8939132690429687, 2.940387487411499023, 7200, 0, 0, 136, 0, 0, 0, 0, 0, 45114), -- Hungry Vulture (Area: -Unknown- - Difficulty: 0) +(@CGUID+47, 172027, 2175, 10424, 11011, '0', 0, 0, 0, 0, 208.2470855712890625, -2048.836669921875, 78.20540618896484375, 2.475290298461914062, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Nibbling Scavenger (Area: -Unknown- - Difficulty: 0) +(@CGUID+48, 161006, 2175, 10424, 11011, '0', 0, 0, 0, 0, 207.3350677490234375, -2061.84716796875, 78.7346954345703125, 0.203099057078361511, 7200, 0, 0, 149, 0, 0, 0, 0, 0, 45114), -- Ogre Shadowcaster (Area: -Unknown- - Difficulty: 0) (Auras: 145363 - Permanent Feign Death (Stun, Untrackable, Immune)) +(@CGUID+49, 172027, 2175, 10424, 11011, '0', 0, 0, 0, 0, 204.4708099365234375, -2054.31396484375, 77.86822509765625, 2.900879383087158203, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Nibbling Scavenger (Area: -Unknown- - Difficulty: 0) +(@CGUID+50, 161006, 2175, 10424, 11011, '0', 0, 0, 0, 0, 214.3559112548828125, -2078.75341796875, 78.9085540771484375, 2.623500823974609375, 7200, 0, 0, 149, 0, 0, 0, 0, 0, 45114), -- Ogre Shadowcaster (Area: -Unknown- - Difficulty: 0) (Auras: 145363 - Permanent Feign Death (Stun, Untrackable, Immune)) +(@CGUID+51, 172027, 2175, 10424, 11011, '0', 0, 0, 0, 0, 197.4309539794921875, -2075.5302734375, 77.41428375244140625, 3.752988100051879882, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Nibbling Scavenger (Area: -Unknown- - Difficulty: 0) +(@CGUID+52, 172027, 2175, 10424, 11011, '0', 0, 0, 0, 0, 171.140625, -2064.54345703125, 77.81885528564453125, 3.144254207611083984, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Nibbling Scavenger (Area: -Unknown- - Difficulty: 0) +(@CGUID+53, 172027, 2175, 10424, 11011, '0', 0, 0, 0, 0, 207.368377685546875, -2098.573974609375, 80.07639312744140625, 3.209979057312011718, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Nibbling Scavenger (Area: -Unknown- - Difficulty: 0) +(@CGUID+54, 172027, 2175, 10424, 11011, '0', 0, 0, 0, 0, 172.6996612548828125, -2062.7119140625, 77.81884002685546875, 0.559787929058074951, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Nibbling Scavenger (Area: -Unknown- - Difficulty: 0) +(@CGUID+55, 172027, 2175, 10424, 11011, '0', 0, 0, 0, 0, 174.31597900390625, -2062.73779296875, 77.81884002685546875, 3.144254207611083984, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Nibbling Scavenger (Area: -Unknown- - Difficulty: 0) +(@CGUID+56, 172027, 2175, 10424, 11011, '0', 0, 0, 0, 0, 183.4342041015625, -2084.3818359375, 77.8585052490234375, 2.288524866104125976, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Nibbling Scavenger (Area: -Unknown- - Difficulty: 0) +(@CGUID+57, 172027, 2175, 10424, 11011, '0', 0, 0, 0, 0, 177.9083404541015625, -2080.123046875, 77.93352508544921875, 2.837572336196899414, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Nibbling Scavenger (Area: -Unknown- - Difficulty: 0) +(@CGUID+58, 172027, 2175, 10424, 11011, '0', 0, 0, 0, 0, 169.2881927490234375, -2065.654541015625, 77.82209014892578125, 1.250232696533203125, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 45114), -- Nibbling Scavenger (Area: -Unknown- - Difficulty: 0) +(@CGUID+59, 171997, 2175, 10424, 11011, '0', 0, 0, 0, 0, 215.361114501953125, -2120.447998046875, 99.539337158203125, 1.818612456321716308, 7200, 0, 0, 149, 0, 0, 0, 0, 0, 45114), -- Woodlands Watcher (Area: -Unknown- - Difficulty: 0) +(@CGUID+60, 172027, 2175, 10424, 11011, '0', 0, 0, 0, 0, 171.9936676025390625, -2092.832763671875, 78.53928375244140625, 5.04897165298461914, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Nibbling Scavenger (Area: -Unknown- - Difficulty: 0) +(@CGUID+61, 171997, 2175, 10424, 11011, '0', 0, 0, 0, 0, 162.642364501953125, -2077.013916015625, 93.541839599609375, 5.877742290496826171, 7200, 0, 0, 149, 0, 0, 0, 0, 0, 45114), -- Woodlands Watcher (Area: -Unknown- - Difficulty: 0) +(@CGUID+62, 172027, 2175, 10424, 11011, '0', 0, 0, 0, 0, 198.1689605712890625, -2119.4765625, 84.428253173828125, 4.079430580139160156, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114), -- Nibbling Scavenger (Area: -Unknown- - Difficulty: 0) +(@CGUID+63, 172027, 2175, 10424, 11011, '0', 0, 0, 0, 0, 212.9317169189453125, -2120.7041015625, 83.8814697265625, 4.057169914245605468, 7200, 4, 0, 5, 0, 1, 0, 0, 0, 45114); -- Nibbling Scavenger (Area: -Unknown- - Difficulty: 0) + +-- Creature Addon +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+63; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+44, 0, 0, 50331649, 1, 0, 0, 0, 0, 0, ''), -- Woodlands Watcher +(@CGUID+61, 0, 0, 50331649, 1, 0, 0, 0, 0, 0, ''), -- Woodlands Watcher +(@CGUID+59, 0, 0, 50331649, 1, 0, 0, 0, 0, 0, ''); -- Woodlands Watcher + +-- Creature Template Addon Data +DELETE FROM `creature_template_addon` WHERE `entry` IN (154268, 153266, 161006); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(154268, 0, 0, 50331648, 1, 0, 0, 0, 0, 3, ''), -- 154268 (Hungry Vulture) +(153266, 0, 0, 0, 1, 0, 0, 0, 0, 4, '313373'), -- 153266 (Killclaw the Terrible) - -Unknown- +(161006, 0, 0, 262144, 1, 0, 0, 0, 0, 0, '145363'); -- 161006 (Ogre Shadowcaster) - Permanent Feign Death (Stun, Untrackable; Immune) + +-- Creature Template Data +UPDATE `creature_template` SET `faction`=188, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=172027; -- Nibbling Scavenger +UPDATE `creature_template` SET `faction`=188, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=172026; -- Cockroach +UPDATE `creature_template` SET `minlevel`=10, `maxlevel`=10, `faction`=2057, `BaseAttackTime`=2000, `unit_flags`=537166592, `unit_flags2`=2049, `unit_flags3`=8192 WHERE `entry`=161006; -- Ogre Shadowcaster +UPDATE `creature_template` SET `minlevel`=10, `maxlevel`=10, `faction`=31, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=171997; -- Woodlands Watcher + +-- Creature MovementType +DELETE FROM `creature_template_movement` WHERE `CreatureId` = 154268; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`, `InteractionPauseTimer`) VALUES +(154268, 0, 0, 1, 0, 0, 0, NULL); + +-- GameObject +DELETE FROM `gameobject` WHERE `guid` = @OGUID+0; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 330627, 2175, 10424, 11011, '0', 0, 0, 210.638885498046875, -2167.5, 92.2349853515625, 3.927583217620849609, 0, 0, -0.92376613616943359, 0.382957041263580322, 7200, 255, 1, 45114); -- Danger Sign (Area: -Unknown- - Difficulty: 0) + +-- Scaling +DELETE FROM `creature_template_scaling` WHERE (`Entry`=167582 AND `DifficultyID`=0); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(167582, 0, 0, 0, 741, 45114); + +UPDATE `creature_template_scaling` SET `VerifiedBuild`=45114 WHERE (`DifficultyID`=0 AND `Entry` IN (161265,164827,171997,154268,164927,165730,165757,153266,165711,172027,165727,172026,161006)); + +DELETE FROM `creature_model_info` WHERE `DisplayID`=96513; +INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES +(96513, 0.305999994277954101, 1.5, 0, 45114); |