DB/Creature: Scarlet Lord Jesseriah McCree

1 files changed, 43 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_08_05_00_world.sql b/sql/updates/world/3.3.5/2019_08_05_00_world.sql
new file mode 100644
index 00000000000..fe01936dcaf
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_08_05_00_world.sql
@@ -0,0 +1,43 @@
+-- 
+UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 28964;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (28964) 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
+(28964, 0, 0, 0, 0, 0, 100, 0, 3000, 5000, 7000, 10000, 11, 52835, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Scarlet Lord Jesseriah McCree - IC - Cast Cleave'),
+(28964, 0, 1, 0, 0, 0, 100, 0, 5000, 8000, 6000, 9000, 11, 52836, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Scarlet Lord Jesseriah McCree - IC - Cast Holy Wrath');
+
+UPDATE `creature_template_addon` SET `path_id`=1160820, `bytes2`=1 WHERE `entry`=28964;
+DELETE FROM `creature` WHERE `id`=28964 AND `guid` IN (116082);
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(116082, 28964, 609, 0, 0, 1, 4, 0, 1, 1822.5416, -5928.4077, 112.5901, 2.850989, 300, 0, 0, 0, 0, 2, 0, 0, 0, 0);
+
+DELETE FROM `waypoint_data` WHERE `id` IN (1160820);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action_chance`) VALUES
+(1160820, 1, 1822.5416, -5928.4077, 112.5901, 2.850989, 0, 0, 100),
+(1160820, 2, 1805.9674, -5933.6796, 115.5751, 3.440038, 0, 0, 100),
+(1160820, 3, 1783.9140, -5927.8867, 116.1226, 2.815646, 0, 0, 100),
+(1160820, 4, 1764.9814, -5920.5864, 116.1206, 2.780303, 0, 0, 100),
+(1160820, 5, 1733.9671, -5906.8652, 116.1270, 2.654639, 0, 0, 100),
+(1160820, 6, 1711.9996, -5893.1547, 116.1433, 2.599661, 0, 0, 100),
+(1160820, 7, 1697.0548, -5880.2441, 116.1337, 2.104860, 0, 0, 100),
+(1160820, 8, 1696.6993, -5863.2700, 116.1487, 1.480468, 0, 0, 100),
+(1160820, 9, 1699.8616, -5847.3286, 116.1410, 0.926762, 0, 0, 100),
+(1160820, 10, 1712.6965, -5834.3608, 116.1470, 0.777537, 0, 0, 100),
+(1160820, 11, 1722.7740, -5822.8671, 116.1230, 0.463377, 0, 0, 100),
+(1160820, 12, 1742.0671, -5820.7099, 116.1232, 0.094240, 0, 0, 100),
+(1160820, 13, 1760.9528, -5820.0444, 116.1169, 0.051043, 0, 0, 100),
+(1160820, 14, 1777.2397, -5819.0791, 115.1158, 0.039262, 0, 0, 100),
+(1160820, 15, 1796.1309, -5818.5332, 110.3443, 0.035335, 0, 0, 100),
+(1160820, 16, 1777.2397, -5819.0791, 115.1158, 0.039262, 0, 0, 100),
+(1160820, 17, 1760.9528, -5820.0444, 116.1169, 0.051043, 0, 0, 100),
+(1160820, 18, 1742.0671, -5820.7099, 116.1232, 0.094240, 0, 0, 100),
+(1160820, 19, 1722.7740, -5822.8671, 116.1230, 0.463377, 0, 0, 100),
+(1160820, 20, 1712.6965, -5834.3608, 116.1470, 0.777537, 0, 0, 100),
+(1160820, 21, 1699.8616, -5847.3286, 116.1410, 0.926762, 0, 0, 100),
+(1160820, 22, 1696.6993, -5863.2700, 116.1487, 1.480468, 0, 0, 100),
+(1160820, 23, 1697.0548, -5880.2441, 116.1337, 2.104860, 0, 0, 100),
+(1160820, 24, 1711.9996, -5893.1547, 116.1433, 2.599661, 0, 0, 100),
+(1160820, 25, 1733.9671, -5906.8652, 116.1270, 2.654639, 0, 0, 100),
+(1160820, 26, 1764.9814, -5920.5864, 116.1206, 2.780303, 0, 0, 100),
+(1160820, 27, 1783.9140, -5927.8867, 116.1226, 2.815646, 0, 0, 100),
+(1160820, 28, 1805.9674, -5933.6796, 115.5751, 3.440038, 0, 0, 100),
+(1160820, 29, 1822.5416, -5928.4077, 112.5901, 2.850989, 0, 0, 100);