TrinityCore/TrinityCore — Issue #5547: [ICC/Lady Deathwhisperer] Move minion spell to db
Author: Amit86
Created: 2012-03-03 13:43:07+00:00
State: open

The following auras currently doesnt work on spawned minions at lady deathwhisperer:
SPELL_FANATIC_S_DETERMINATION / SPELL_ADHERENT_S_DETERMINATION

I am proposing to remove them from script and add to DB since these auras should be on these npcs from the moment they spawn till they die anyway:

```diff

diff --git a/src/server/scripts/Northrend/IcecrownCitadel/boss_lady_deathwhisper.cpp b/src/server/scripts/Northrend/IcecrownCitadel/boss_lady_deathwhisper.cpp
index ea2f73e..79767ad 100755
--- a/src/server/scripts/Northrend/IcecrownCitadel/boss_lady_deathwhisper.cpp
+++ b/src/server/scripts/Northrend/IcecrownCitadel/boss_lady_deathwhisper.cpp
@@ -76,7 +76,6 @@ enum Spells
SPELL_NECROTIC_STRIKE = 70659,
SPELL_SHADOW_CLEAVE = 70670,
SPELL_VAMPIRIC_MIGHT = 70674,
- SPELL_FANATIC_S_DETERMINATION = 71235,
SPELL_DARK_MARTYRDOM_FANATIC = 71236,

// Adherents
@@ -86,7 +85,6 @@ enum Spells
SPELL_DEATHCHILL_BLAST = 70906,
SPELL_CURSE_OF_TORPOR = 71237,
SPELL_SHORUD_OF_THE_OCCULT = 70768,
- SPELL_ADHERENT_S_DETERMINATION = 71234,
SPELL_DARK_MARTYRDOM_ADHERENT = 70903,

// Vengeful Shade
@@ -397,10 +395,6 @@ class boss_lady_deathwhisper : public CreatureScript
target = SelectTarget(SELECT_TARGET_RANDOM); // Wave adds

summon->AI()->AttackStart(target); // CAN be NULL
- if (summon->GetEntry() == NPC_REANIMATED_FANATIC)
- summon->CastSpell(summon, SPELL_FANATIC_S_DETERMINATION, true);
- else if (summon->GetEntry() == NPC_REANIMATED_ADHERENT)
- summon->CastSpell(summon, SPELL_ADHERENT_S_DETERMINATION, true);
}

void UpdateAI(uint32 const diff)
```

```sql
-- Reanimated Fanatic
DELETE FROM creature_template_addon WHERE entry IN(38009,38398,38630,38631);
INSERT INTO creature_template_addon (`entry`,`auras`) VALUES
(38009,71235),
(38398,71235),
(38630,71235),
(38631,71235);

-- Reanimated Adherent
DELETE FROM creature_template_addon WHERE entry IN(38010,38397,39000,39001);
INSERT INTO creature_template_addon (`entry`,`auras`) VALUES
(38010,71234),
(38397,71234),
(39000,71234),
(39001,71234);

-- Deformed Fanatic
DELETE FROM creature_template_addon WHERE entry IN(38135,38395,38634,38635);
INSERT INTO creature_template_addon (`entry`,`auras`) VALUES
(38135,71235),
(38395,71235),
(38634,71235),
(38635,71235);

-- Empowered Adherent
DELETE FROM creature_template_addon WHERE entry IN(38136,38396,38632,38633);
INSERT INTO creature_template_addon (`entry`,`auras`) VALUES
(38136,71234),
(38396,71234),
(38632,71234),
(38633,71234);
```

Currently, even this doesnt fix the problem, I would be glad if you guys help me investigate why these auras doesnt appear on these npc's

right now, using my sql - if i spawn the npc using .npc add i can see the aura, if the script spawns it, its just not there..