26102 Grimaxe's Demise

[eyerobot]

This sets the flags on all involved creatures, Sets the vehicle id for the Golem. And makes the general unattackable while he rides the golem. And upon golem death, The general becomes attackable.

The query that adds the riflemen to the combat area is commented out, Because it should only be run once. So you have to uncomment it first, Or add a delete query in front of it, Which I don't recommend. As there are other riflemen that will get deleted.

-- 26102 Grimaxe's Demise

-- 42008 Dark Iron Golem
-- 42010 General Grimaxe
-- 41909 Airfield Guard
-- 41898 Dun Morogh Rifleman

-- Adds Riflemen to combat area - Only Run this once unless you include a delete query first.
/*
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (41898, 0, 1, 5115, 1, 1, 0, 41898, -5052.86, -1690.72, 497.836, 3.57842, 300, 0, 0, 208, 205, 0, 0, 0, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (41898, 0, 1, 5115, 1, 1, 0, 41898, -5050.39, -1711.06, 497.836, 2.69484, 300, 0, 0, 208, 205, 0, 0, 0, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (41898, 0, 1, 5115, 1, 1, 0, 41898, -5050.65, -1696.33, 497.836, 3.42133, 300, 0, 0, 208, 205, 0, 0, 0, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (41898, 0, 1, 5115, 1, 1, 0, 41898, -5049.96, -1703.34, 497.836, 3.10717, 300, 0, 0, 208, 205, 0, 0, 0, 0, 0);
*/

-- 42008 Dark Iron Golem
UPDATE `creature_template` SET `unit_flags` = 512 WHERE `entry` = 42008;
UPDATE `creature_template` SET `AIName` = 'SmartAI', `Health_mod` = '2', `Armor_mod` = '20' WHERE `entry` = 42008;
UPDATE `creature_template` SET `VehicleId` = 851 WHERE `entry` = 42008;

DELETE FROM `creature` WHERE `id`=42008;
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (42008, 0, 1, 5115, 1, 1, 0, 0, -5077.89, -1702.03, 497.825, 6.22128, 300, 0, 0, 372, 191, 0, 0, 0, 0, 0);


DELETE FROM `smart_scripts` WHERE (`entryorguid`=42008 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 
(42008, 0, 1, 0, 4, 0, 100, 0, 0, 0, 0, 0, 19, 512, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Aggro - Remove Unit Flags From Self"),
(42008, 0, 0, 0, 6, 0, 100, 0, 0, 0, 0, 0, 19, 33536, 0, 0, 0, 0, 0, 19, 42010, 100, 0, 0, 0, 0, 0, "On Death - Change Unit Flags On General");

-- 42010 General Grimaxe
UPDATE `creature_template` SET `AIName` = 'SmartAI', `Health_mod` = '2', `Armor_mod` = '20' WHERE `entry` = 42010;
UPDATE `creature_template` SET `unit_flags` = 33536 WHERE `entry` = 42010;

DELETE FROM `creature` WHERE `id`=42010;
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (42010, 0, 1, 5115, 1, 1, 0, 42010, -5077.89, -1702.03, 497.825, 6.22128, 300, 0, 0, 444, 0, 0, 0, 0, 0, 0);


-- Heart Ride
DELETE FROM `smart_scripts` WHERE (`entryorguid`=42010 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 
(42010, 0, 0, 0, 4, 0, 100, 0, 0, 0, 2300, 3900, 11, 53824, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Cast Throw on Aggro"),
(42010, 0, 1, 0, 1, 0, 100, 0, 0, 0, 0, 0, 11, 63852, 2, 0, 0, 0, 0, 19, 42008, 10, 0, 0, 0, 0, 0, "On Ooc - Ride Golem");

 

[ExO]

Applied to the Emucoach repack, Cataclysm.

Thanks!