Quest: Corrosion Prevention

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


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

– 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;

– Set SAI to Zeppelin Power Core
UPDATE creature_template SET AIName = ‘SmartAI’ WHERE entry=23832;

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’);

Really strange case. I love how the Zeppelin Power Core works with SmartAI really nicely, but this SQL makes no sense. I tested the quest, the credits are given. The problem is that hovering over the oozes does not show you need them…

As for spell Energized! (42490) it should and IS given by the Zepelin Power Core every 1.5-2.0 minutes.

This topic can be moved to trash, not sure if it was implemented or not but everything works as this quest says it should. Test for yourself.

I’ve already scripted this in core a while ago, any bug reports goes to tracker.