[FIXED]Смяна на репутацията между The Oracles и Frenzyheart Tribe

[admin]

Имам голямо желание да фикснем тези 2 куеста или ще ми се наложи да ги направя ауто.

Hand of the Oracles
Frenzyheart Champion

Евента с тези 2 куеста е за смяната на репутацията от едната фракция Frenzyheart Tribe към The Oracles и обратното. Единия куест ти дава към едните другия към другите. Или по-точно трябва да се изразя кеустовете стават активни по време на изпълнение на quest-а по-долу.

Горните 2 куеста могат да бъдат изпълнени след като вземеш този куест A Hero's Burden При него се иска да убиеш Artruis the Heartless.

Как става цялата врътка:
По време на самата битка Artruis the Heartless, от двете му страни, стоят замразени 2 npc-та от лявата му страна стои Jaloot а от дясната му страна стои Zepik the Gorloc Hunter. Artruis the Heartless трябва да достигне 30% от кръвта си след което cast-ва Bindings of Submission с която размразява 2-те npc-та, но и пуска щит върху себе си който го защитава от всички които имат Bindings of Submission (пуска магията само върху 2-те npc-та). В този момент е вече важно, играча, който иска да направи смяна между 2-те фракции (The Оracles или Frenzyheart) да убие npc-то към който иска да стане Heated. 2-те npc-та стават агресивни и нападат само теб или хората от групата ако сте в група.
За да стане Honored към The Оracles трябва да убие Zepik the Gorloc Hunter
За да стане Honored към Frenzyheart трябва да убие Jaloot
Да приемем, че играча има вече Exalted към The Oracles и иска да смени репутацията си и да започне да вдига репутацията си Frenzyheart Tribe. В този случай той трябва да убие Jaloot. След като го убие това веднага би трябвало да махне магията Bindings of Submission от всички наоколо, това ще позволи довършването на Artruis the Heartless и завършването на основния куест A Hero's Burden. След като вече сме убили и един от замразените npc-та в страни (в случая Jaloot) то живото npc Zepik the Gorloc Hunter вече отваря daily куеста Frenzyheart Champion.

Ситуацията е аналогична с другата репутация. Ако по време на боя убиеш Zepik the Gorloc Hunter то след завършването на A Hero's Burden - Jaloot трябва да ти отвори куеста Hand of the Oracles

Самата смяна изглежда малко сложна, но всъщност не е.

Ето и видео. https://www.youtube.com/watch?v=7CEzuqPHnIQ

пс: Може да бъркам на някои места, минавал съм куста в Близард и е точно както на видеото, но не съм сигурен в някои условия, кога може да минеш пак 1-вия куест, дали можеш само веднъж да си смениш фракцията и др. подобни.
Ако има запознати да споделят.

[untaught]

Само искам да знам какво казва вълчето, когато го оставиш живо и ще се помъча да го напиша.

[admin]

Единия казва: Now you not catch us with back turned! Now we hurt you bad undead. BAD!

Другия не знам ще видя някой клип дали има.

[admin]

Не знам не намирам текст-а.

Ето тук даже ти си го репортвал
http://forum.evowow.com/bug-tracker/36/frenzyheart-tribeoracles-start-event/24411/

[untaught]

А магията, която ги държи замразени?

[Roguetype]

При нас мисля, че не може да се достигне до този куест?

Edit - http://old.wowhead.com/quest=12570 - Този куест спира за сега поредицата. По кусно ще пусна отделна тема, че сега нямам време.

[admin]

А магията, която ги държи замразени?

Ха де сега вече ме хвана неподготвен. Не знам дали изобщо я пише някъде. Освен от sniff от близард.

[untaught]

Няма ли някой, който може да посети 2-те мобчета, за да види какъв бъф/дебъф имат?

[Караконджул]

Някой да ми обясни, какво точно се изисква от мен и ще го направя веднага.

Пейчо, кога ще си активираш акаунта и колко време си в статус фроузън за да ти пратя един скрол ъф резърекшън?

[untaught]

Просто отиди и виж коя е магията(бъф/дебъф), която стои на двата моба преди да започне битката с "боса". За снифове не мога да те карам, че не ми се обеснява как стават нещата, а и има проблем с някой OS.

[Караконджул]

Каквото и да трябва, казвайте

[untaught]

Чудесен.

[Караконджул]

Дава ми, че ти е изпратен скрола. Пробвах, както от играта, така и от батълнет.

[untaught]

Сложил съм GO-та, на който се връща куеста, до боса, защото има бъг ако се spawn-ва със SAI.

Код: [Маркирай кода]

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=52185;
INSERT INTO `conditions` VALUES
('13','1','52185','0','0','31','0','3','28668','0','0','0','',NULL),
('13','1','52185','0','1','31','0','3','28667','0','0','0','',NULL),
('13','1','52185','0','2','31','0','3','28659','0','0','0','',NULL);

DELETE FROM `creature_text` WHERE `entry` IN (28667,28668);
INSERT INTO `creature_text` VALUES
('28667','0','0','Now you not catch us with black turned! Now we hurt you bad udead. BAD!','12','0','0','0','0','0',''),
('28668','0','0','Now you not catch us with black turned! Now we hurt you bad udead. BAD!','12','0','0','0','0','0','');

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

DELETE FROM `creature_questrelation` WHERE quest IN(12689,12695,12582,12692);
INSERT INTO `creature_questrelation` VALUES
('28667','12689'),
('28667','12695'),
('28668','12582'),
('28668','12692');

DELETE FROM `creature` WHERE `id` IN(28668,28667,28659);
INSERT INTO `creature` VALUES
('202971','28659','571','1','1','0','0','5611.25','3788.81','-91.4954','5.78125','300','0','0','136548','37250','0','0','0','0'),
('202969','28667','571','1','1','0','0','5620.58','3763.67','-95.5818','5.78832','300','0','0','45516','0','0','0','0','0'),
('202970','28668','571','1','1','0','1826','5632.25','3796.39','-91.7627','5.62722','300','0','0','45516','3725','0','0','0','0');

UPDATE `creature_template` SET `ainame`='SmartAI' WHERE `entry` IN(28659,28667,28668);
UPDATE `creature_template` SET `unit_flags`=512 WHERE `entry` IN(28667,28668);
DELETE FROM `creature_ai_scripts` WHERE `creature_id`=28659;
DELETE FROM `gameobject` WHERE `id`=190777;
INSERT INTO `gameobject` VALUES
(NULL,'190777','571','1','1','5623.39','3789.01','-93.2977','4.47582','0','0','0.785611','-0.618721','300','0','1');

DELETE FROM `smart_scripts` WHERE `entryorguid`=28667 AND `source_type`=0;
INSERT INTO `smart_scripts` VALUES
('28667','0','0','1','11','0','100','0','0','0','0','0','11','52182','2','0','0','0','0','1','0','0','0','0','0','0','0','On Spawn - cast ice block'),
('28667','0','1','0','61','0','100','0','0','0','0','0','18','512','0','0','0','0','0','1','0','0','0','0','0','0','0','Link with event 0 - Restore flags'),
('28667','0','2','3','8','0','100','0','52185','0','0','0','2','21','0','0','0','0','0','1','0','0','0','0','0','0','0','On spell hit - Change faction to 21'),
('28667','0','3','4','61','0','100','0','0','0','0','0','19','512','0','0','0','0','0','1','0','0','0','0','0','0','0','Link with event 2 - Remove flags'),
('28667','0','4','5','61','0','100','0','0','0','0','0','28','52182','0','0','0','0','0','1','0','0','0','0','0','0','0','Link with event 3 - Remove ice block'),
('28667','0','5','0','61','0','100','0','0','0','0','0','49','0','0','0','0','0','0','21','40','0','0','0','0','0','0','Link with event 4 - Attack closest player'),
('28667','0','6','7','6','0','100','0','0','0','0','0','45','0','1','0','0','0','0','19','28668','40','0','0','0','0','0','On death - set data 0 1 to Zepik the Gorloc Hunter'),
('28667','0','7','0','61','0','100','0','0','0','0','0','45','0','1','0','0','0','0','19','28659','40','0','0','0','0','0','Link with event 6 - set data 0 1 to Artruis the Heartless'),
('28667','0','8','9','38','0','100','0','0','1','200','300','2','250','0','0','0','0','0','1','0','0','0','0','0','0','0','On set data 0 1 - change faction to 250'),
('28667','0','9','10','61','0','100','0','0','0','0','0','1','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Link with event 8 - Say line'),
('28667','0','10','11','61','0','100','0','0','0','0','0','49','0','0','0','0','0','0','19','28659','40','0','0','0','0','0','Link with event 9 - Attack Artruis the Heartless'),
('28667','0','11','0','61','0','100','0','0','0','0','0','28','52185','0','0','0','0','0','1','0','0','0','0','0','0','0','Link with event 10 - Remove aura from Bindings of Submission'),
('28667','0','12','0','7','0','100','0','0','0','0','0','18','512','0','0','0','0','0','1','0','0','0','0','0','0','0','On evade - restore unit flags'),
('28667','0','13','14','21','0','100','0','0','0','0','0','11','52182','2','0','0','0','0','1','0','0','0','0','0','0','0','On home reached - cast ice block'),
('28667','0','14','0','61','0','100','0','0','0','0','0','2','250','0','0','0','0','0','1','0','0','0','0','0','0','0','Link with event 13 - Restore faction'),
('28667','0','15','0','38','0','100','0','0','2','200','300','41','60000','0','0','0','0','0','1','0','0','0','0','0','0','0','On data set 0 2 - despawn after 60 sec');

DELETE FROM `smart_scripts` WHERE `entryorguid`=28668 AND `source_type`=0;
INSERT INTO `smart_scripts` VALUES
('28668','0','0','1','11','0','100','0','0','0','0','0','11','52182','2','0','0','0','0','1','0','0','0','0','0','0','0','On Spawn - cast ice block'),
('28668','0','1','0','61','0','100','0','0','0','0','0','18','512','0','0','0','0','0','1','0','0','0','0','0','0','0','Link with event 0 - Restore flags'),
('28668','0','2','3','8','0','100','0','52185','0','0','0','2','21','0','0','0','0','0','1','0','0','0','0','0','0','0','On spell hit - Change faction to 21'),
('28668','0','3','4','61','0','100','0','0','0','0','0','19','512','0','0','0','0','0','1','0','0','0','0','0','0','0','Link with event 2 - Remove flags'),
('28668','0','4','5','61','0','100','0','0','0','0','0','28','52182','0','0','0','0','0','1','0','0','0','0','0','0','0','Link with event 3 - Remove ice block'),
('28668','0','5','0','61','0','100','0','0','0','0','0','49','0','0','0','0','0','0','21','40','0','0','0','0','0','0','Link with event 4 - Attack closest player'),
('28668','0','6','7','6','0','100','0','0','0','0','0','45','0','1','0','0','0','0','19','28667','40','0','0','0','0','0','On death - set data 0 1 to Jaloot'),
('28668','0','7','0','61','0','100','0','0','0','0','0','45','0','1','0','0','0','0','19','28659','40','0','0','0','0','0','Link with event 6 - set data 0 1 to Artruis the Heartless'),
('28668','0','8','9','38','0','100','0','0','1','200','300','2','250','0','0','0','0','0','1','0','0','0','0','0','0','0','On set data 0 1 - change faction to 250'),
('28668','0','9','10','61','0','100','0','0','0','0','0','1','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Link with event 8 - Say line'),
('28668','0','10','11','61','0','100','0','0','0','0','0','49','0','0','0','0','0','0','19','28659','40','0','0','0','0','0','Link with event 9 - Attack Artruis the Heartless'),
('28668','0','11','0','61','0','100','0','0','0','0','0','28','52185','0','0','0','0','0','1','0','0','0','0','0','0','0','Link with event 10 - Remove aura from Bindings of Submission'),
('28668','0','12','0','7','0','100','0','0','0','0','0','18','512','0','0','0','0','0','1','0','0','0','0','0','0','0','On evade - restore unit flags'),
('28668','0','13','14','21','0','100','0','0','0','0','0','11','52182','2','0','0','0','0','1','0','0','0','0','0','0','0','On home reached - cast ice block'),
('28668','0','14','0','61','0','100','0','0','0','0','0','2','250','0','0','0','0','0','1','0','0','0','0','0','0','0','Link with event 13 - Restore faction'),
('28668','0','15','0','38','0','100','0','0','2','200','300','41','60000','0','0','0','0','0','1','0','0','0','0','0','0','0','On data set 0 2 - despawn after 60 sec');

DELETE FROM `smart_scripts` WHERE `entryorguid`=28659 AND `source_type`=0;
INSERT INTO `smart_scripts` VALUES
('28659','0','0','0','1','0','100','0','0','0','0','0','21','0','0','0','0','0','0','1','0','0','0','0','0','0','0','On out of combat - stop combat movement'),
('28659','0','1','2','4','0','100','0','0','0','0','0','11','15530','0','0','0','0','0','2','0','0','0','0','0','0','0','On aggro - cast Frostbolt'),
('28659','0','2','0','61','0','100','0','0','0','0','0','22','1','0','0','0','0','0','1','0','0','0','0','0','0','0','Link with event 1 - Set phase 1'),
('28659','0','3','0','9','1','100','0','0','40','3400','4800','11','15530','0','0','0','0','0','2','0','0','0','0','0','0','0','On player in range - Cast Frostbolt(Phase 1)'),
('28659','0','4','0','9','1','100','0','0','35','7000','9000','11','54261','1','0','0','0','0','5','0','0','0','0','0','0','0','On player in range - cast Ice Lance(phase 1)'),
('28659','0','5','0','9','1','100','0','0','10','14000','18000','11','11831','1','0','0','0','0','1','0','0','0','0','0','0','0','On player in range - cast Frost Nova(phase 1)'),
('28659','0','6','0','0','1','100','0','0','0','20000','25000','11','54792','1','0','0','0','0','1','0','0','0','0','0','0','0','In combat - Cast icy veins'),
('28659','0','7','8','3','1','100','0','0','7','0','0','22','2','0','0','0','0','0','1','0','0','0','0','0','0','0','Mana on 7% - Set phase 2(phase 1)'),
('28659','0','8','0','61','0','100','0','0','0','0','0','21','1','0','0','0','0','0','1','0','0','0','0','0','0','0','Link with event 7 - Allow combat movement'),
('28659','0','9','0','9','1','100','0','35','80','0','0','21','1','0','0','0','0','0','1','0','0','0','0','0','0','0','At 35 yards - Start combat movement(Phase 1)'),
('28659','0','10','0','9','1','100','0','5','15','0','0','21','0','0','0','0','0','0','1','0','0','0','0','0','0','0','At 15 yards - Prevent combat movement(Phase 1)'),
('28659','0','11','0','9','1','100','0','0','5','0','0','21','1','0','0','0','0','0','1','0','0','0','0','0','0','0','Below 5 yards - Start combat movement(Phase 1)'),
('28659','0','12','0','3','2','100','0','15','100','100','100','22','1','0','0','0','0','0','1','0','0','0','0','0','0','0','When mana is above 15% - Set phase 1(Phase 2)'),
('28659','0','13','0','2','0','100','0','0','30','0','0','22','3','0','0','0','0','0','1','0','0','0','0','0','0','0','At 30% HP - Set phase 3'),
('28659','0','14','0','2','0','100','1','0','30','0','0','11','52185','1','0','0','0','0','1','0','0','0','0','0','0','0','Cast Bindings of Submission at 30% HP (Phase 3)'),
('28659','0','15','0','38','0','100','0','0','1','0','0','28','52185','0','0','0','0','0','1','0','0','0','0','0','0','0','On data set 0 1 - Remove aura from Binding Of Submission'),
('28659','0','16','17','6','0','100','0','0','0','0','0','45','0','2','0','0','0','0','19','28667','40','0','0','0','0','0','On death - Set data 0 2 to Zepik the Gorloc Hunter'),
('28659','0','17','0','61','0','100','0','0','0','0','0','45','0','2','0','0','0','0','19','28668','40','0','0','0','0','0','Link with event 16 - Set data 0 2 to Jaloot');
EDIT: Уупс, забравих имунитетите:

Код: [Маркирай кода]

UPDATE `creature_template` SET `mechanic_immune_mask`=617561983 WHERE `entry`=28659;

[admin]

Добавено, за тестване.