A Hero's Burden O La Carga De Un Heroe

Saludos, quería saber si alguien tiene esta misión final para el cambio de facción completa y si la puede pasar por aquí.

Gracias

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

I would love to have this Quest working, too.

At first I think the CAI should be converted to SAI:


INSERT INTO smart_scripts VALUES (28659, 0, 1, 0, 1, 0, 100, 1, 0, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Prevent Combat Movement and Set Phase to 0 on Spawn");

INSERT INTO smart_scripts VALUES (28659, 0, 2, 0, 1, 0, 100, 1, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Prevent Combat Movement and Set Phase to 0 on Spawn");

INSERT INTO smart_scripts VALUES (28659, 0, 3, 0, 4, 0, 100, 1, 0, 0, 0, 0, 11, 15530, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Cast Frostbolt and Set Phase 1 on Aggro");

INSERT INTO smart_scripts VALUES (28659, 0, 4, 0, 4, 0, 100, 1, 0, 0, 0, 0, 23, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Cast Frostbolt and Set Phase 1 on Aggro");

INSERT INTO smart_scripts VALUES (28659, 0, 5, 0, 9, 13, 100, 1, 0, 40, 3400, 4800, 11, 15530, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Cast Frostbolt (Phase 1)");

INSERT INTO smart_scripts VALUES (28659, 0, 6, 0, 9, 13, 100, 1, 0, 35, 7000, 9000, 11, 54261, 1, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Cast Ice Lance (Phase 1)");

INSERT INTO smart_scripts VALUES (28659, 0, 7, 0, 9, 13, 100, 1, 0, 10, 14000, 18000, 11, 11831, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Cast Frost Nova (Phase 1)");

INSERT INTO smart_scripts VALUES (28659, 0, 8, 0, 0, 13, 100, 1, 2000, 3000, 25000, 35000, 11, 54792, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Cast Icy Veins (Phase 1)");

INSERT INTO smart_scripts VALUES (28659, 0, 9, 0, 3, 13, 100, 1, 0, 7, 0, 0, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Start Combat Movement and Set Phase 2 when Mana is at 7% (Phase 1)");

INSERT INTO smart_scripts VALUES (28659, 0, 10, 0, 3, 13, 100, 1, 0, 7, 0, 0, 23, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Start Combat Movement and Set Phase 2 when Mana is at 7% (Phase 1)");

INSERT INTO smart_scripts VALUES (28659, 0, 11, 0, 9, 13, 100, 1, 35, 80, 0, 0, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Start Combat Movement at 35 Yards (Phase 1)");

INSERT INTO smart_scripts VALUES (28659, 0, 12, 0, 9, 13, 100, 1, 5, 15, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Prevent Combat Movement at 15 Yards (Phase 1)");

INSERT INTO smart_scripts VALUES (28659, 0, 13, 0, 9, 13, 100, 1, 0, 5, 0, 0, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Start Combat Movement Below 5 Yards (Phase 1)");

INSERT INTO smart_scripts VALUES (28659, 0, 14, 0, 3, 11, 100, 1, 15, 100, 100, 100, 23, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Set Phase 1 when Mana is above 15% (Phase 2)");

INSERT INTO smart_scripts VALUES (28659, 0, 15, 0, 2, 0, 100, 1, 0, 30, 0, 0, 22, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Set Phase 3 at 30% HP");

INSERT INTO smart_scripts VALUES (28659, 0, 16, 0, 2, 7, 100, 1, 0, 30, 0, 0, 11, 52185, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Cast Bindings of Submission at 30% HP (Phase 3)");

INSERT INTO smart_scripts VALUES (28659, 0, 17, 0, 7, 0, 100, 1, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Set Phase to 0 on Evade");

Problem is, that the php-script is not working correctly atm.

When the SAI is working I would try to add another SAI to the 2 other NPCs (Jaloot and Zlepik).

They should target Artruis on combat and when TARGET_HP = 30%, they should attack the Player…

Then something like ON_CREATURE_DEATH they should change their flag to friendly and start attacking Artruis

When he gets hit by one of the other NPCs his shield should be gone…

But first the SAI should be done…

Do you think it could be possible to do this Quest entirely in DB?