14209 Gunk in the Trunk

[eyerobot]

-- 14209 Gunk in the Trunk

-- 67689 Ghostly Backfire

-- 35526 Clubnik's Dozer
UPDATE `creature_template` SET `MovementType` = 1 WHERE `entry` = 35526;
UPDATE `creature` SET `spawndist`='10', `MovementType`='1' WHERE  `id`= 35526;

UPDATE `creature_template` SET `npcflag` = 16777216 WHERE `entry` = 35526;

DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=35526 AND `spell_id`=67689;
INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES (35526, 67689, 1, 0);

-- 35558 Ectoplasmic Exhaust
UPDATE `creature_template` SET `faction_A` = 14, `faction_H` = 14 WHERE `entry` = 35558;

DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId`=18 AND `SourceGroup`=35526 AND `SourceEntry`=67689);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(18, 35526, 67689, 0, 0, 9, 0, 14209 , 0, 0, 0, 0, "0", "If On Quest 14209  - Spellclick Allowed");

 

[eyerobot]

Updated with conditions for spellclick.

 

[ExO]

Thanks! It has now been executed, and will be taken effect on the newest Emucoach Cataclysm 4.3.4 Repack (VIP) version;