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]