[FIXED][quest][13236]Army of the Damned

[*Blood_Prince*]

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

След Accept-ването на куеста, минаваш в друго измерение и се превръщаш в Arthas.Необходимо е да избиеш мобовете около теб и с една от магиите да превърнеш труповете им в зомбита.

http://www.youtube.com/watch?v=Ew2efBLJVjs - видео към куеста.
https://github.com/TrinityCore/TrinityCore/issues/7801 - някакъв фикс, който явно не е много вървежен и общо взето трябва да се upgrade-не, съдейки по коментара.

[untaught]

Updated https://github.com/TrinityCore/TrinityCore/issues/7801:

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

UPDATE `creature_template` SET `minlevel`=80,`maxlevel`=80,`exp`=2 WHERE `entry` IN (31276,31254,31268);
UPDATE `creature_template` SET `faction_a`=2136,`faction_h`=2136,`mindmg`=420,`maxdmg`=630,`attackpower`=157,`dmg_multiplier`='0.9',`rangeattacktime`=2000,
`minrangedmg`=336,`maxrangedmg`=504,`rangedattackpower`=126,`spell1`=6660,`equipment_id`=0 WHERE `entry`=31254;
UPDATE `creature_template` SET `faction_a`=35,`faction_h`=35,`mindmg`=391,`maxdmg`=585,`attackpower`=146,`dmg_multiplier`=2.2,`baseattacktime`=3000,`rangeattacktime`=2000,
`unit_class`=2,`minrangedmg`=313,`maxrangedmg`=468,`rangedattackpower`=117,`spell1`=58912,`spell2`=58913,`spell3`=58916,`spell4`=58917,`vehicleid`=269 WHERE `entry`=31268;
UPDATE `creature_template` SET `faction_a`=14,`faction_h`=14,`mindmg`=420,`maxdmg`=630,`attackpower`=157,`dmg_multiplier`=1.3,`baseattacktime`=2000,`rangeattacktime`=2000,
`minrangedmg`=336,`maxrangedmg`=504,`rangedattackpower`=126 WHERE `entry`=31276;

UPDATE `quest_template` SET `SourceSpellId`=58989 WHERE `id` IN (13395,13236);

UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (31254,31276);
UPDATE `creature_template` SET `npcflag`=`npcflag`|1, `AIName`='SmartAI' WHERE `entry`=32404;

DELETE FROM `smart_scripts` WHERE `entryorguid` IN (31254,31276,32404) AND `source_type`=0;
INSERT INTO `smart_scripts` VALUES
(31254,0,0,0,8,0,100,1,58916,0,0,0,85,58915,3,0,0,0,0,1,0,0,0,0,0,0,0,'Lordaeron Footsoldier - on spellhit Gift of the Lich King - invoker cast Gift of the Lich King'),
(31254,0,1,2,8,0,100,1,58915,0,0,0,33,31329,0,0,0,0,0,7,0,0,0,0,0,0,0,'Lordaeron Footsoldier - on spellhit Gift of the Lich King - give killcredit'),
(31254,0,2,0,61,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Lordaeron Footsoldier - on spellhit Gift of the Lich King - force despawn'),
(31276,0,0,0,8,0,100,1,58917,0,0,0,85,58919,3,0,0,0,0,1,0,0,0,0,0,0,0,'Ghoulish Minion - on spellhit Consume Minions - cast Consume Minions'),
(32404,0,0,1,62,0,100,0,10226,0,0,0,11,58989,3,0,0,0,0,7,0,0,0,0,0,0,0,'Matthias Lehner - on gossip select - cast spell Prodigal Leader Force Cast'),
(32404,0,1,0,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Matthias Lehner - on gossip select - close gossip');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (58919,58916,58917);
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=10226;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
('15','10226','0','0','0','9','0','13395','0','0','0','0','0','',''),
('15','10226','0','0','0','28','0','13395','0','0','1','0','0','',''),
('15','10226','0','0','1','9','0','13236','0','0','0','0','0','',''),
('15','10226','0','0','1','28','0','13236','0','0','1','0','0','',''),
('13','1','58916','0','0','31','0','3','31254','0','0','0','0','',''),
('13','1','58916','0','0','36','0','0','0','0','1','0','0','',''),
('13','1','58917','0','0','31','0','3','31276','0','0','0','0','','');

DELETE FROM `creature` WHERE `id`=31254;
INSERT INTO `creature` VALUES
(NULL,31254,571,1,2,24768,0,7607.47,1359.98,336.215,2.07694,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7601.23,1356.92,335.296,1.8675,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7597.87,1354.71,334.685,1.76278,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7598.16,1375.46,334.371,2.04204,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7614.95,1359.27,337.009,2.23402,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7609.59,1356.69,336.257,2.07694,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7603.68,1353.31,335.445,1.90241,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7600.04,1350.75,334.945,1.79769,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7617.08,1355.11,336.881,2.21657,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7611.87,1352.6,336.418,2.07694,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7606.25,1349.91,336.055,1.93731,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7601.94,1347.68,335.545,1.8326,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7618.95,1352.03,337.313,2.19912,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7614.41,1348.76,337.183,2.09439,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7609.11,1346.25,336.764,1.95477,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7604.91,1343.7,336.298,1.8675,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7598.78,1325.95,335.845,1.69297,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7594.16,1325.51,335.156,1.62316,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7598.02,1318.95,336.317,1.67552,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7592.37,1318.07,335.528,1.58825,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7597.55,1310.82,337.134,1.69297,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7592.33,1310,336.354,1.62316,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7586.7,1310.51,335.366,1.5708,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7597.62,1305.04,337.836,1.69297,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7592.61,1305.42,336.907,1.62316,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7587.98,1306,335.96,1.5708,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7581.65,1306.05,334.874,1.51844,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7575.08,1306.44,333.991,1.43117,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7604.29,1378.75,334.867,2.44346,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7608.23,1378.98,334.807,2.56563,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7600.95,1385.34,334.186,2.68781,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7622.68,1358.64,337.641,2.35619,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7624.06,1355.43,337.972,2.32129,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7621.07,1362.55,337.626,2.3911,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7618.37,1366.67,337.358,2.42601,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7593.25,1372.03,333.624,1.71042,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7598.13,1372.08,334.469,1.95477,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7588.84,1367.32,332.888,1.51844,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7597.88,1367.29,334.593,1.8675,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7577.17,1385.13,331.072,0.383972,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7573.42,1379.31,330.573,0.575959,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7589.81,1375.82,333.15,1.53589,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7593.27,1375.51,333.626,1.74533,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7613.16,1363.57,336.909,2.26893,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7572.89,1341.37,331.671,1.23918,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7568.35,1344.57,330.561,1.13446,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7563.99,1349.03,329.878,1.01229,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7558.83,1352.61,329.015,0.890118,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7555.55,1355.55,328.198,0.785398,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7575.36,1345.21,331.734,1.25664,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7571.02,1348.64,330.53,1.15192,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7566.87,1352.06,329.68,1.02974,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7562.09,1356.33,328.945,0.890118,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7558.44,1359.3,328.263,0.785398,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7588.17,1325.12,334.319,1.55334,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7582.48,1325.18,333.568,1.46608,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7577.1,1325.81,332.855,1.37881,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7581.49,1318.21,334.011,1.44862,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7576.25,1318.98,333.319,1.37881,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7587.73,1318.6,334.791,1.53589,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7580.7,1310.45,334.473,1.50098,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7575.55,1310.4,333.824,1.43117,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7584.47,1376.15,332.536,1.18682,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7580.12,1376.35,331.819,0.942478,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7593.32,1367.28,333.729,1.69297,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7589.11,1367.38,332.953,1.51844,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7583.89,1367.6,331.913,1.309,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7579.37,1368.24,331.306,1.11701,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7589.3,1371.93,333.009,1.51844,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7584.05,1372.18,332.269,1.23918,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7579.46,1372.12,331.681,1.0472,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7562.34,1362.78,329.004,0.785398,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7566.39,1359.59,329.762,0.925025,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7570.57,1356.49,330.507,1.0472,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7574.74,1352.34,330.964,1.18682,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7578.45,1348.97,331.624,1.29154,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7566.08,1366.8,329.689,0.785398,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7570.33,1363.06,330.55,0.942478,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7574.28,1359.97,331.297,1.09956,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7578.25,1356.31,331.319,1.23918,30,0,0,12600,0,0,0,0,0),
(NULL,31254,571,1,2,24768,0,7581.29,1353.31,331.509,1.3439,300,0,0,12600,0,0,0,0,0);Стойте далеч от адовете като пускате първата магия, за да не ви удря.

Edit: Fix startup errors.

[admin]

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

[untaught]

Редакция в conditions.

[admin]

Done.