Switching reputation between Frenzyheart Tribe and The Oracles #997

Closed
click opened this Issue May 16, 2011 · 7 comments

Projects

None yet

7 participants

@click
TrinityCore member

Core rev: aaf377d
DB: TDB 335.11.38 (2011-03-05) + all sql patches to core rev.
Patches:

Switching from [http://www.wowhead.com/faction=1105 The Oracles] to the [http://www.wowhead.com/faction=1104 Frenzyheart Tribe] requires that you engage [http://www.wowhead.com/npc=28659 Artruis the Heartless]. While you are in combat, Artruis will freeze at 30% health and two counterparts will emerge from their frozen state. Killing [http://www.wowhead.com/npc=28667 Jaloot] first will ensure your allegiance to the Frenzyheart Tribe, while killing [http://www.wowhead.com/npc=28668 Zepik] deters you away from the Tribe. Make sure to pick up the quest from the surviving Tribe member!

The same way is to change from Frenzyheart Tribe to The Oracles but you need to kill Zepik.
Some spells needed for this switching doesn't work, like: [http://www.wowhead.com/spell=54016 Forcecast Set Oracle Honored] I try it to cast it on myself with gm user but nothing happens.

I'm not sure in what section should be exacly so I put it into Core/Quests

@click
TrinityCore member

Author: zxbiohazardzx
recently been sniffed should be possible after we worked on this quest

@luisalvarado

Thank you zxbio.

@Jildor

Confirm.

And:
#2698
#1957

@ultimatexemnas

any news?

@nelegalno
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceGroup`=0 AND `SourceEntry`=52185;
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=52185;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(17,0,52185,0,0,36,0,0,    0,0,0,0,"","Target must be alive"), -- might not be necessary
(13,1,52185,0,0,31,0,3,28659,0,0,0,"","Implicit target Artruis the Heartless"),
(13,1,52185,0,1,31,0,3,28667,0,0,0,"","Implicit target Jaloot"),
(13,1,52185,0,2,31,0,3,28668,0,0,0,"","Implicit target Zepik the Gorloc Hunter");

Conditions for the spell. Doesn't fix the quest but it's a start.

Videos:
https://www.youtube.com/watch?v=2uRcmFtfB0s
https://www.youtube.com/watch?v=QM-ooLnoERs
https://www.youtube.com/watch?v=hJz2QIcTPKY
https://www.youtube.com/watch?v=dPTaaHGYQS4
https://www.youtube.com/watch?v=Trr7S25MjkM

@nelegalno
DELETE FROM `creature_involvedrelation` WHERE `id` IN (28667,28668);
INSERT INTO `creature_involvedrelation` (`id`,`quest`) VALUES
(28667,12689),
(28668,12582);

UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (28667,28668);
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (28667,28668) AND `source_type`=0;
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 
(28667, 0, 0, 0, 23, 0, 100, 0, 52185, 1, 0, 0, 2, 14, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Jaloot - On Bindings of Submission spellhit - Turn hostile'),
(28667, 0, 1, 0, 25, 0, 100, 0, 0, 0, 0, 0, 11, 52182, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Jaloot - On reset - Cast Tomb of the Heartless'),
(28668, 0, 0, 0, 23, 0, 100, 0, 52185, 1, 0, 0, 2, 14, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Zepik the Gorloc Hunter - On Bindings of Submission spellhit - Turn hostile'),
(28668, 0, 1, 0, 25, 0, 100, 0, 0, 0, 0, 0, 11, 52182, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Zepik the Gorloc Hunter - On reset - Cast Tomb of the Heartless');

Still not working.

@malcrom malcrom was assigned Nov 23, 2012
@Aokromes
TrinityCore member

better fix at #8710

@Aokromes Aokromes closed this Dec 25, 2012
@ike3 ike3 pushed a commit to ike3/mangosbot that referenced this issue Aug 25, 2014
@rsa rsa [mr1984] fix some behaviors in PetAdvancedAI - cast and combat moveme…
…nt. related to #997, #1000
cc7bb1f
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment