[Complete] Quest 11314 "The Fallen Sisters"

Quest “The Fallen Sisters” http://www.wowhead.com/quest=11314 is presently not working.

I am working on it but having trouble with conditions. No matter what I do the spell is always castible.

[CODE]-- Fix Spell condition for Spell 43340 to only target Chill Nymph 30% health or less
DELETE FROM conditions WHERE SourceTypeOrReferenceId=13 AND SourceEntry=43340;
INSERT INTO conditions (SourceTypeOrReferenceId,SourceGroup,SourceEntry,ElseGroup,ConditionTypeOrReference,ConditionValue1,ConditionValue2,ConditionValue3,ErrorTextId,ScriptName,Comment) VALUES
(13,0,43340,0,18,1,23678,0,63,‘’,‘Spell 43340 targets only Chill Nymph’),
(13,0,43340,0,20,31,0,0,63,‘’,‘Spell 43340 target needs to be 30% or less health’);[/sql]

Lurielle’s Pendant item 33606 http://www.wowhead.com/item=33606

Lurielle’s Pendant spell 43340 http://www.wowhead.com/spell=49624

Any help would be appreciated.

[/CODE]

even tho it says hp at 35%… it is not required on retail… now that could just be a bug that blizzard missed or they never changed the tool tips. i can cast it as soon as i targeted the nymphs and still got credit. back before wotk, the nymphs had to be at 35% before you could use the item… it isnt that way anymore.

But its more fun that way /emoticons/default_smile.png

Do you know the text that is said by the chill nymphs when hit by the spell?

[CODE]-- Chill Nymph SAI (in progress)
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry=23678;
DELETE FROM smart_scripts WHERE entryorguid IN (23678,2367800);
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
(23678,0,0,0,2,0,100,1,0,30,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Do text emote on health 30%’),
(23678,0,1,0,0,0,75,0,2000,3000,2000,2000,11,9739,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Cast Wrath on victim’),
(23678,0,2,3,8,0,100,0,43340,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,‘On Spell hit 43340 stop combat movement’),
(23678,0,3,4,61,0,100,0,0,0,0,0,20,0,0,0,0,0,0,1,0,0,0,0,0,0,0,‘On Spell hit 43340 stop attack’),
(23678,0,4,5,61,0,100,0,0,0,0,0,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0,‘On Spell hit 43340 set faction 35’),
(23678,0,5,6,61,0,100,0,0,0,0,0,33,24117,0,0,0,0,0,7,0,0,0,0,0,0,0,‘On Spell hit 43340 give quest credit’),
(23678,0,6,0,61,0,100,0,0,0,0,0,80,2367800,0,0,0,0,0,7,0,0,0,0,0,0,0,‘On Spell hit 43340 load script’),
(2367800,9,0,0,0,0,100,0,8000,8000,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,‘despawn’);[/sql]

Script isn’t finished. My big problem here is I can’t get the npc to drop combat /emoticons/default_sad.png

[/CODE]

add this to yours bud.


-- add text to db (offy screen shots)
SET @ENTRY := 23678;
DELETE FROM `creature_text` WHERE `entry`= @ENTRY;
INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
(@ENTRY,0,0, 'I knew Lurielle would send help! Thank you friend, and give Lurielle my thanks as well!',0,7,100,1,0,0, 'Chill Nymph say'),
(@ENTRY,0,1, 'Where am I? What happened to me? You... you freed me?',0,7,100,1,0,0, 'Chill Nymph say'),
(@ENTRY,0,2, 'Thank you. I thought I would die without seeing my sisters again!',0,7,100,1,0,0, 'Chill Nymph say');
[/sql]

this is what i had based from offy actions

[sql]

UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
-- create smartscripts for events to happen
DELETE FROM `smart_scripts` WHERE `entryorguid` in (@ENTRY,@ENTRY*100);
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 (@ENTRY,0,0,0,0,0,100,0,2000,6000,8000,15000,11,9739,0,0,0,0,0,2,0,0,0,0,0,0,0, 'casts spell wrath'),
(@ENTRY,0,1,0,8,0,100,0,@SPELL,0,0,0,80,@ENTRY*100,0,2,0,0,0,1,0,0,0,0,0,0,0, 'spellhit run script'),
(@ENTRY*100,9,0,0,0,0,100,0,0,0,0,0,11,@CREDIT,0,0,0,0,0,7,0,0,0,0,0,0,0, 'credit for q11314'),
(@ENTRY*100,9,1,0,0,0,100,0,0,0,0,0,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0, 'change faction'),
(@ENTRY*100,9,2,0,0,0,100,0,0,0,0,0,24,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'evade'),
(@ENTRY*100,9,3,0,0,0,100,0,2000,2000,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'random text'),
(@ENTRY*100,9,4,0,0,0,100,0,0,0,0,0,46,20,0,0,0,0,0,1,0,0,0,0,0,0,0, 'runs away'),
(@ENTRY*100,9,5,0,0,0,100,0,0,0,0,0,41,5000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'despawns');

i dint need to use conditions.

That worked?

Here is what I have. You were missing emote at 35% and CombatAI spell.

The SAI will allow you to complete the quest but I am concerned about a few things not working properly.

-- Quest 11314 "The Fallen Sisters" -- Chill Nymph SAI (in progress) UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=23678; DELETE FROM `smart_scripts` WHERE `entryorguid` IN (23678,2367800); 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 (23678,0,0,0,2,0,100,1,0,35,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Do text emote on health 35%'), (23678,0,1,0,0,0,75,0,2000,3000,2000,2000,11,9739,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Wrath on victim'), (23678,0,2,3,8,0,100,0,43340,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'On Spell hit 43340 stop combat movement'), (23678,0,3,4,61,0,100,0,0,0,0,0,24,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'evade'), (23678,0,4,5,61,0,100,0,0,0,0,0,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0,'set faction 35'), (23678,0,5,6,61,0,100,0,0,0,0,0,33,24117,0,0,0,0,0,7,0,0,0,0,0,0,0,'quest credit'), (23678,0,6,0,61,0,100,0,0,0,0,0,80,2367800,0,0,0,0,0,1,0,0,0,0,0,0,0,'load script'), (2367800,9,0,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'face player'), -- not working? (2367800,9,1,0,0,0,100,0,2000,2000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Say text 1'), (2367800,9,2,0,0,0,100,0,2000,2000,0,0,69,0,0,0,0,0,0,8,0,0,0,2063,-4666,217,0,'move to location'), (2367800,9,3,0,0,0,100,0,0,0,0,0,59,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'set speed run'), -- not working? (2367800,9,4,0,0,0,100,0,5000,5000,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'despawn'); -- NPC talk text insert DELETE FROM `creature_text` WHERE `entry`=23678; INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES (23678,0,0, 'Chill Nymph appears weak!',2,0,100,0,0,0, 'Chill Nymph'), (23678,1,0, 'I knew Lurielle would send help! Thank you friend, and give Lurielle my thanks as well!',0,7,100,1,0,0, 'Chill Nymph'), (23678,1,1, 'Where am I? What happened to me? You... you freed me?',0,7,100,1,0,0, 'Chill Nymph'), (23678,1,2, 'Thank you. I thought I would die without seeing my sisters again!',0,7,100,1,0,0, 'Chill Nymph');[/sql]

problem i was having is, everything worked, but as with you, the npc does not drop attack… now when i put my flags on, it would do exactly what it was suppose to do.

if you read the link that you provided, it backed up what i said about not needing the 35% event… this started in 3.2.2. so if the fix is going to be blizzlike, then it needs to reflect that… http://www.trinitycore.org/f/public/style_emoticons/default/tongue.gif

http://www.wowhead.com/quest=11314

as for missing spell, hmmmm must have been copy paste error on my behalf, i do have the attack spell, but that doesnt matter… i made booboo. http://www.trinitycore.org/f/public/style_emoticons/default/sad.gif

moving this to SAI development for more testing and research on existing problems.

The 35% is just an emote. Also the item should only work on Chill Nympths.

Its working perfectly except for two minor visuals.

Can someone test this please.

-- Quest 11314 "The Fallen Sisters" -- Chill Nymph SAI (in progress) UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=23678; DELETE FROM `smart_scripts` WHERE `entryorguid` IN (23678,2367800); 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 (23678,0,0,0,2,0,100,1,0,30,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Do text emote on health 30%'), (23678,0,1,0,0,0,75,0,2000,3000,2000,2000,11,9739,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Wrath on victim'), (23678,0,2,3,8,0,100,0,43340,0,0,0,66,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'On Spell hit 43340 face player'), (23678,0,3,4,61,0,100,0,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'stop combat movement'), (23678,0,4,5,61,0,100,0,0,0,0,0,24,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'evade'), (23678,0,5,6,61,0,100,0,0,0,0,0,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0,'set faction 35'), (23678,0,6,7,61,0,100,0,0,0,0,0,33,24117,0,0,0,0,0,7,0,0,0,0,0,0,0,'quest credit'), (23678,0,7,0,61,0,100,0,0,0,0,0,80,2367800,0,0,0,0,0,1,0,0,0,0,0,0,0,'load script'), (23678,0,8,0,40,0,100,0,1,23678,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'On reach waypoint 1 despawn'), (2367800,9,0,0,0,0,100,0,2000,2000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Say text 1'), (2367800,9,1,0,0,0,100,0,1000,1000,0,0,53,1,23678,0,0,0,0,1,0,0,0,0,0,0,0, 'start waypoint movement'); -- NPC talk text insert DELETE FROM `creature_text` WHERE `entry`=23678; INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES (23678,0,0, 'Chill Nymph appears weak!',2,0,100,0,0,0, 'Chill Nymph'), (23678,1,0, 'I knew Lurielle would send help! Thank you friend, and give Lurielle my thanks as well!',0,7,100,1,0,0, 'Chill Nymph'), (23678,1,1, 'Where am I? What happened to me? You... you freed me?',0,7,100,1,0,0, 'Chill Nymph'), (23678,1,2, 'Thank you. I thought I would die without seeing my sisters again!',0,7,100,1,0,0, 'Chill Nymph'); -- Chill Nymph Path DELETE FROM `waypoints` WHERE `entry`=23678; INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES (23678,1,2063,-4666,217,'Chill Nymph point 1'); -- Add condition for Item 33606 "Lurielle''s Pendant" to only target Chill Nymph 23678 DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=18 AND `SourceEntry`=33606; INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES (18,0,33606,0,24,1,23678,0,63,'','Item 33606 Lurielle''s Pendant targets Chill Nymph 23678'); [/sql]

Tested and working. needs to be moved to the tracker.

for me it didnt require the nymph to be under 30% HP, wowhead comments claim you need them to be weak (under 30% hp)

It was changed later on that you didn’t need to be under 30%.

version 3.2.2. blizz changed it so you do not have to attack or get their hp down… i also just did the quest maybe 1 month ago, it is instant cast now… i just stood just in range and targeted the nymphs and got instant credits. quest is now too simple, but hey… who can figure blizz… its part of their way to help people level easier to 80 at the time.

ok misundstood then, great

managed to test out retail… yes you can just use item and get credit, you can also take their hp down (has text emote) and then use item… so this fix is as blizzlike as it can get. good job.