Operating System - Linux
TrinityCore Revision - 11594+
TrinityDatabase Version - TDB 335.11.38 (from version table in DB)
11174 Corrosion Prevention
Location: Dustwallow Marsh
Problem: It’s not fully clear in quest comments and youtube video, though it appears totems should only cast energize when the quest is taken. I have tried setting conditions for this as below, but it doesn’t turn off when the quest is out of the log.
Information obtained from wowhead and youtube.
Quest giver: Moxie Steelgrille = npc 23797
ReqC=23797
Zeppelin Power Core = npc 23832 Should cast to player within distance
Energized = Spell 42490 should cast from totem to player – should cast within distance (double blue)
Item Ooze Buster=33108 → Cast Ooze Zap When energized = Spell 42489 (this come with the item)
Ooze Channel = Spell 42483 (cast blue glow and channel from player to creature.)
Ooze Channel Credit = Spell 42486 – kill credit 23797 (this does give killcredit) then End Ooze Channel spell 42485
[CODE]
– Totem energizes when quest taken – does not turn off cast
DELETE FROM conditions WHERE SourceTypeOrReferenceId=17 AND SourceEntry=42490;
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, ElseGroup, ConditionTypeOrReference, ConditionValue1, ConditionValue2, ConditionValue3, ErrorTextId, ScriptName, Comment) VALUES
(17,0,42490,0,9,11174,0,0,0,‘’,‘Corrosion Prevention’);
– Set SAI to Acidic Swamp Ooze
UPDATE creature_template SET AIName=‘SmartAI’ WHERE entry=4393;
– Set SAI to Bubbling Swamp Ooze
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry=4394;
– set Zepplin Power Core npcs to no movement
UPDATE creature SET MovementType=‘0’ WHERE creature.id=23832;
– Set SAI to Zeppelin Power Core
UPDATE creature_template SET AIName = ‘SmartAI’ WHERE entry=23832;
– SAI
DELETE FROM smart_scripts WHERE entryorguid IN (23832,2383200,4393,439300,4394,439400);
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
– Zepplin Power Core SAI
(23832,0,0,0,1,0,100,0,1000,1000,2000,2000,80,2383200,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Acidic Swamp Ooze - On spellhit run script’),
(2383200,9,0,0,0,0,100,0,1000,1000,0,0,11,42490,1,0,0,0,0,1,0,0,0,0,0,0,0,‘Cast Energized to player’),
– Acidic Swamp Ooze SAI
(4393,0,0,0,8,0,100,0,42489,0,0,0,80,439300,0,2,0,0,0,1,0,0,0,0,0,0,0,‘On spell Acidic Swamp Ooze - hit run script’),
(439300,9,0,0,0,0,100,0,1500,1500,0,0,11,42486,0,0,0,0,0,7,0,0,0,0,0,0,0,‘Acidic Swamp Ooze - cast killcredit’),
(439300,9,1,0,0,0,100,0,1000,1000,0,0,37,0,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Acidic Swamp Ooze - Die’),
– Bubbling Swamp Ooze SAI
(4394,0,0,0,8,0,100,0,42489,0,0,0,80,439400,0,2,0,0,0,1,0,0,0,0,0,0,0,'Bubbling Swamp Ooze - On spellhit run scipt '),
(439400,9,0,0,0,0,100,0,1500,1500,0,0,11,42486,0,0,0,0,0,7,0,0,0,0,0,0,0,‘Bubbling Swamp Ooze - Killcredit’),
(439400,9,1,0,0,0,100,0,1000,1000,0,0,37,0,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Bubbling Swamp Ooze - Die’);
– Spell_linked_spell trigger
DELETE FROM spell_linked_spell WHERE spell_trigger IN (42483,42489);
INSERT INTO spell_linked_spell (spell_trigger, spell_effect, type, comment) VALUES
(42489,42483,0,‘Corrosion Prevention’);
[/SQL][/CODE]