diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2021_05_07_02_world.sql | 229 |
1 files changed, 229 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_05_07_02_world.sql b/sql/updates/world/3.3.5/2021_05_07_02_world.sql new file mode 100644 index 00000000000..8c9a90b45a5 --- /dev/null +++ b/sql/updates/world/3.3.5/2021_05_07_02_world.sql @@ -0,0 +1,229 @@ +-- +SET @CGUID := 147218; -- 72 +SET @POOL := 1559; -- 36 + +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = `unit_flags` &~ 536870912, `dynamicflags` = 0 WHERE `entry` = 21846; +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = `unit_flags` &~ 536870912, `dynamicflags` = 0 WHERE `entry` = 21859; +UPDATE `creature_template_addon` SET `bytes1` = 0, `bytes2` = 1, `auras` = "31261" WHERE `entry` = 21846; +UPDATE `creature_template_addon` SET `bytes1` = 0, `bytes2` = 1, `auras` = "31261" WHERE `entry` = 21859; + +DELETE FROM `spawn_group` WHERE `spawnId` IN (SELECT `guid` FROM `creature` WHERE `id` IN (21846,21859)) AND `spawnType` = 0; +DELETE FROM `creature` WHERE `id` IN (21846,21859); +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+00 AND @CGUID+71 AND `id` IN (21846,21859); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES +(@CGUID+00,21846,530,0,0,1,1,0,1,-3783.05,5215.14,-23.515,1.76278,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+01,21846,530,0,0,1,1,0,1,-3780.56,5215.07,-23.1934,0.0349066,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+02,21846,530,0,0,1,1,0,1,-3777.38,5184.86,-24.4552,3.9968,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+03,21846,530,0,0,1,1,0,1,-3772.17,5211.63,-22.8059,5.49779,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+04,21846,530,0,0,1,1,0,1,-3770.83,5121.01,-21.4213,0.959931,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+05,21846,530,0,0,1,1,0,1,-3766.29,5062.47,-18.9817,3.57792,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+06,21846,530,0,0,1,1,0,1,-3764.99,5095.88,-19.0595,0.122173,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+07,21846,530,0,0,1,1,0,1,-3762.46,5171.85,-22.9264,1.0821,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+08,21846,530,0,0,1,1,0,1,-3759.02,5140.41,-22.8351,4.81711,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+09,21846,530,0,0,1,1,0,1,-3758.07,5261.12,-15.3995,2.77507,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+10,21846,530,0,0,1,1,0,1,-3753.9,5294.92,-16.9184,1.43117,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+11,21846,530,0,0,1,1,0,1,-3753.17,5078.65,-18.2274,0.872665,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+12,21846,530,0,0,1,1,0,1,-3750.03,5125.17,-21.9827,5.35816,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+13,21846,530,0,0,1,1,0,1,-3749.58,5195.27,-22.6601,3.68264,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+14,21846,530,0,0,1,1,0,1,-3741.7,5160.73,-22.2081,4.50295,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+15,21846,530,0,0,1,1,0,1,-3741.05,5171.27,-21.8304,2.14675,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+16,21846,530,0,0,1,1,0,1,-3739.48,5271.71,-16.0977,0.523599,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+17,21846,530,0,0,1,1,0,1,-3734.78,5327.33,-13.0874,3.9619,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+18,21846,530,0,0,1,1,0,1,-3733.21,5061.52,-17.6918,0.628319,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+19,21846,530,0,0,1,1,0,1,-3731.54,5160.66,-22.2169,3.4383,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+20,21846,530,0,0,1,1,0,1,-3726.95,5263.67,-17.9404,3.66519,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+21,21846,530,0,0,1,1,0,1,-3721.04,5275.86,-18.5205,1.25664,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+22,21846,530,0,0,1,1,0,1,-3720.57,5205.87,-20.2053,2.53073,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+23,21846,530,0,0,1,1,0,1,-3718.09,5217.56,-21.3539,2.75762,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+24,21846,530,0,0,1,1,0,1,-3713.32,5257.14,-20.3728,3.82227,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+25,21846,530,0,0,1,1,0,1,-3711.44,5290.39,-18.9303,0.0698132,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+26,21846,530,0,0,1,1,0,1,-3691.57,5220.81,-21.1431,2.54818,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+27,21846,530,0,0,1,1,0,1,-3689.51,5295.31,-20.0296,3.33358,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+28,21846,530,0,0,1,1,0,1,-3688.32,5336.11,-15.1771,3.735,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+29,21846,530,0,0,1,1,0,1,-3687.49,5351.75,-13.172,3.1765,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+30,21846,530,0,0,1,1,0,1,-3679.08,5287.66,-20.6681,0.0698132,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+31,21846,530,0,0,1,1,0,1,-3678.04,5293.5,-20.3924,1.78024,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+32,21846,530,0,0,1,1,0,1,-3676.77,5334.48,-16.1081,0.575959,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+33,21846,530,0,0,1,1,0,1,-3643.76,5323.48,-18.2017,4.08407,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+34,21846,530,0,0,1,1,0,1,-3640.03,5318.27,-19.0845,3.38594,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+35,21846,530,0,0,1,1,0,1,-3634.82,5283.14,-21.9279,4.5204,7,0,0,6986,0,0,0,0,0,"",15595), + +(@CGUID+36,21859,530,0,0,1,1,0,1,-3783.05,5215.14,-23.515,1.76278,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+37,21859,530,0,0,1,1,0,1,-3780.56,5215.07,-23.1934,0.0349066,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+38,21859,530,0,0,1,1,0,1,-3777.38,5184.86,-24.4552,3.9968,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+39,21859,530,0,0,1,1,0,1,-3772.17,5211.63,-22.8059,5.49779,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+40,21859,530,0,0,1,1,0,1,-3770.83,5121.01,-21.4213,0.959931,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+41,21859,530,0,0,1,1,0,1,-3766.29,5062.47,-18.9817,3.57792,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+42,21859,530,0,0,1,1,0,1,-3764.99,5095.88,-19.0595,0.122173,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+43,21859,530,0,0,1,1,0,1,-3762.46,5171.85,-22.9264,1.0821,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+44,21859,530,0,0,1,1,0,1,-3759.02,5140.41,-22.8351,4.81711,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+45,21859,530,0,0,1,1,0,1,-3758.07,5261.12,-15.3995,2.77507,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+46,21859,530,0,0,1,1,0,1,-3753.9,5294.92,-16.9184,1.43117,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+47,21859,530,0,0,1,1,0,1,-3753.17,5078.65,-18.2274,0.872665,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+48,21859,530,0,0,1,1,0,1,-3750.03,5125.17,-21.9827,5.35816,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+49,21859,530,0,0,1,1,0,1,-3749.58,5195.27,-22.6601,3.68264,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+50,21859,530,0,0,1,1,0,1,-3741.7,5160.73,-22.2081,4.50295,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+51,21859,530,0,0,1,1,0,1,-3741.05,5171.27,-21.8304,2.14675,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+52,21859,530,0,0,1,1,0,1,-3739.48,5271.71,-16.0977,0.523599,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+53,21859,530,0,0,1,1,0,1,-3734.78,5327.33,-13.0874,3.9619,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+54,21859,530,0,0,1,1,0,1,-3733.21,5061.52,-17.6918,0.628319,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+55,21859,530,0,0,1,1,0,1,-3731.54,5160.66,-22.2169,3.4383,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+56,21859,530,0,0,1,1,0,1,-3726.95,5263.67,-17.9404,3.66519,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+57,21859,530,0,0,1,1,0,1,-3721.04,5275.86,-18.5205,1.25664,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+58,21859,530,0,0,1,1,0,1,-3720.57,5205.87,-20.2053,2.53073,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+59,21859,530,0,0,1,1,0,1,-3718.09,5217.56,-21.3539,2.75762,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+60,21859,530,0,0,1,1,0,1,-3713.32,5257.14,-20.3728,3.82227,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+61,21859,530,0,0,1,1,0,1,-3711.44,5290.39,-18.9303,0.0698132,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+62,21859,530,0,0,1,1,0,1,-3691.57,5220.81,-21.1431,2.54818,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+63,21859,530,0,0,1,1,0,1,-3689.51,5295.31,-20.0296,3.33358,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+64,21859,530,0,0,1,1,0,1,-3688.32,5336.11,-15.1771,3.735,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+65,21859,530,0,0,1,1,0,1,-3687.49,5351.75,-13.172,3.1765,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+66,21859,530,0,0,1,1,0,1,-3679.08,5287.66,-20.6681,0.0698132,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+67,21859,530,0,0,1,1,0,1,-3678.04,5293.5,-20.3924,1.78024,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+68,21859,530,0,0,1,1,0,1,-3676.77,5334.48,-16.1081,0.575959,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+69,21859,530,0,0,1,1,0,1,-3643.76,5323.48,-18.2017,4.08407,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+70,21859,530,0,0,1,1,0,1,-3640.03,5318.27,-19.0845,3.38594,7,0,0,6986,0,0,0,0,0,"",15595), +(@CGUID+71,21859,530,0,0,1,1,0,1,-3634.82,5283.14,-21.9279,4.5204,7,0,0,6986,0,0,0,0,0,"",15595); + +DELETE FROM `pool_template` WHERE `entry` BETWEEN @POOL+00 AND @POOL+35; +INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES +(@POOL+00, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+01, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+02, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+03, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+04, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+05, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+06, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+07, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+08, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+09, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+10, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+11, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+12, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+13, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+14, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+15, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+16, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+17, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+18, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+19, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+20, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+21, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+22, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+23, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+24, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+25, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+26, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+27, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+28, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+29, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+30, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+31, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+32, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+33, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+34, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"), +(@POOL+35, 1, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator"); + +DELETE FROM `pool_members` WHERE `type` = 0 AND `poolSpawnId` BETWEEN @POOL+00 AND @POOL+35; +INSERT INTO `pool_members` (`type`, `spawnId`, `poolSpawnId`, `chance`, `description`) VALUES +(0, @CGUID+00, @POOL+00, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+01, @POOL+01, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+02, @POOL+02, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+03, @POOL+03, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+04, @POOL+04, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+05, @POOL+05, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+06, @POOL+06, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+07, @POOL+07, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+08, @POOL+08, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+09, @POOL+09, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+10, @POOL+10, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+11, @POOL+11, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+12, @POOL+12, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+13, @POOL+13, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+14, @POOL+14, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+15, @POOL+15, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+16, @POOL+16, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+17, @POOL+17, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+18, @POOL+18, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+19, @POOL+19, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+20, @POOL+20, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+21, @POOL+21, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+22, @POOL+22, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+23, @POOL+23, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+24, @POOL+24, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+25, @POOL+25, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+26, @POOL+26, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+27, @POOL+27, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+28, @POOL+28, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+29, @POOL+29, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+30, @POOL+30, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+31, @POOL+31, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+32, @POOL+32, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+33, @POOL+33, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+34, @POOL+34, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+35, @POOL+35, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Auchenai Warrior"), +(0, @CGUID+36, @POOL+00, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+37, @POOL+01, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+38, @POOL+02, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+39, @POOL+03, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+40, @POOL+04, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+41, @POOL+05, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+42, @POOL+06, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+43, @POOL+07, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+44, @POOL+08, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+45, @POOL+09, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+46, @POOL+10, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+47, @POOL+11, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+48, @POOL+12, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+49, @POOL+13, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+50, @POOL+14, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+51, @POOL+15, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+52, @POOL+16, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+53, @POOL+17, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+54, @POOL+18, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+55, @POOL+19, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+56, @POOL+20, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+57, @POOL+21, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+58, @POOL+22, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+59, @POOL+23, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+60, @POOL+24, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+61, @POOL+25, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+62, @POOL+26, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+63, @POOL+27, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+64, @POOL+28, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+65, @POOL+29, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+66, @POOL+30, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+67, @POOL+31, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+68, @POOL+32, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+69, @POOL+33, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+70, @POOL+34, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"), +(0, @CGUID+71, @POOL+35, 0, "Terokkar Forest - Slain Auchenai Warrior / Slain Sha'tar Vindicator - Slain Sha'tar Vindicator"); + +UPDATE `creature_template` SET `speed_walk` = 1, `unit_flags` = 33555200, `AIName` = "SmartAI" WHERE `entry` = 22449; +DELETE FROM `smart_scripts` WHERE `entryorguid` = 22449 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(22449,0,0,0,37,0,100,0,0,0,0,0,0,3,0,11686,0,0,0,0,1,0,0,0,0,0,0,0,0,"Sha'tari Fire - On AI Initialize - Morph To Model 11686"), +(22449,0,1,0,37,0,100,0,0,0,0,0,0,11,39199,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Sha'tari Fire - On AI Initialize - Cast 'Flames'"); + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (21846,21859) 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(21846,0,0,1,8,0,100,1,39189,0,0,0,0,33,21846,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Slain Auchenai Warrior - On Spellhit 'Sha'tari Torch' - Quest Credit 'An Improper Burial' (No Repeat)"), +(21846,0,1,2,61,0,100,0,0,0,0,0,0,11,39191,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Slain Auchenai Warrior - On Spellhit 'Sha'tari Torch' - Cast 'Sha'tari Flames'"), +(21846,0,2,0,61,0,100,0,0,0,0,0,0,41,61000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Slain Auchenai Warrior - On Spellhit 'Sha'tari Torch' - Delayed Despawn"), + +(21846,0,3,4,8,0,100,1,37755,0,0,0,0,11,37758,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Slain Auchenai Warrior - On Spellhit 'Bone Wastes - Cinematic Resurrection' - Cast 'Bone Wastes - Summon Auchenai Spirit' (No Repeat)"), +(21846,0,4,5,61,0,100,0,0,0,0,0,0,11,35740,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Slain Auchenai Warrior - On Spellhit 'Bone Wastes - Cinematic Resurrection' - Cast 'Holy Nova'"), +(21846,0,5,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Slain Auchenai Warrior - On Spellhit 'Bone Wastes - Cinematic Resurrection' - Despawn Instant"), + +(21859,0,0,1,8,0,100,1,39189,0,0,0,0,33,21859,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Slain Sha'tar Vindicator - On Spellhit 'Sha'tari Torch' - Quest Credit 'An Improper Burial' (No Repeat)"), +(21859,0,1,2,61,0,100,0,0,0,0,0,0,11,39191,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Slain Sha'tar Vindicator - On Spellhit 'Sha'tari Torch' - Cast 'Sha'tari Flames'"), +(21859,0,2,0,61,0,100,0,0,0,0,0,0,41,61000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Slain Sha'tar Vindicator - On Spellhit 'Sha'tari Torch' - Delayed Despawn"), + +(21859,0,3,4,8,0,100,1,37755,0,0,0,0,11,37759,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Slain Sha'tar Vindicator - On Spellhit 'Bone Wastes - Cinematic Resurrection' - Cast 'Bone Wastes - Summon Draenei Guardian Spirit' (No Repeat)"), +(21859,0,4,5,61,0,100,0,0,0,0,0,0,11,35740,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Slain Sha'tar Vindicator - On Spellhit 'Bone Wastes - Cinematic Resurrection' - Cast 'Holy Nova'"), +(21859,0,5,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Slain Sha'tar Vindicator - On Spellhit 'Bone Wastes - Cinematic Resurrection' - Despawn Instant"); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 13 AND `SourceEntry` = 37755; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,1,37755,0,0,31,0,3,21846,0,0,0,0,"","Group 0: Spell 'Bone Wastes - Cinematic Resurrection' (Effect 0) targets creature 'Slain Auchenai Warrior'"), +(13,1,37755,0,1,31,0,3,21859,0,0,0,0,"","Group 1: Spell 'Bone Wastes - Cinematic Resurrection' (Effect 0) targets creature 'Slain Sha'tar Vindicator'"); |