[FIXED][Quest][13214]Battle at Valhalas: Fallen Heroes

[Feat]

http://www.wowhead.com/quest=13214/battle-at-valhalas-fallen-heroes

След взимането на куеста просто несе случва нищо, а би трябвало да ти призове  опонент !

[untaught]

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

[untaught]

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

UPDATE `creature_template` SET `faction_a`=14,`faction_h`=14,`ainame`='SmartAI' WHERE `entry` IN (31191,31192,31196,31194);
insert into `smart_scripts` values
('31191','0','0','0','6','0','100','1','0','0','0','0','12','31192','1','120000','0','0','0','1','0','0','0','0','0','0','0','Summon Masud '),
('31192','0','0','0','6','0','100','1','0','0','0','0','12','31196','1','120000','0','0','0','1','0','0','0','0','0','0','0','Summon Rith'),
('31196','0','0','0','6','0','100','1','0','0','0','0','12','31194','1','120000','0','0','0','1','0','0','0','0','0','0','0','Summon Talla'),
('31194','0','0','0','6','0','100','1','0','0','0','0','15','13214','0','0','0','0','0','7','0','0','0','0','0','0','0','Give quest credit on Talla's death ');
+

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

UPDATE `quest_template` SET `StartScript`=13214 WHERE `id`=13214;
insert into `quest_start_scripts` values
('13214','0','10','31191','120000','0','8192.2','3498.8','625','0');

[admin]

Когато имаш ' една кавичка в стринг който ще вкарваш в Mysql задължително се слага \ преди нея.

Тествайте.

[untaught]

Уопс, вярно. Просто export и ...

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

UPDATE `creature_template` SET `faction_a`=14,`faction_h`=14,`ainame`='SmartAI' WHERE `entry` IN (31191,31192,31196,31194);Т'ва нещо не се е изпълнило.

[admin]

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

UPDATE `creature_template` SET `faction_a` = 14, `faction_h` = 14, `ainame` = 'SmartAI' WHERE `entry` IN (31191,31192,31196,31194);
Query OK, 0 rows affected (0.00 sec)
Rows matched: 4  Changed: 0  Warnings: 0
Има го, виж няма промени след добавянето.
Явно трябва да рестартна.

[Woll]

Вече работи quest-a.

[untaught]

За пренаписване.

[untaught]

Всичко старо трябва да изчезне от файла.

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

UPDATE `creature_template` SET `ainame`='SmartAI' WHERE `entry`=31135;
DELETE FROM `smart_scripts` WHERE `entryorguid`=31135;
INSERT INTO `smart_scripts` VALUES
('31135','0','0','1','19','0','100','0','13214','0','0','0','12','31191','1','120000','0','0','0','8','0','0','0','8184.3','3506.3','625.63','0.3','On Quest Accepted 13214 - Summon Father Jhadras'),
('31135','0','1','2','61','0','100','0','0','0','0','0','12','31192','1','120000','0','0','0','8','0','0','0','8187.1','3501.9','625.11','0.5','Link With Event 0 - Summon Masud'),
('31135','0','2','3','61','0','100','0','0','0','0','0','12','31194','1','120000','0','0','0','8','0','0','0','8189.3','3498.84','624.97','0.4','Link With Event 1 - Summon Talla'),
('31135','0','3','0','61','0','100','0','0','0','0','0','12','31196','1','120000','0','0','0','8','0','0','0','8191.93','3495.1','625.1','0.6','Link With Event 2 - Summon Rith');

UPDATE `creature_template` SET `faction_a`=14,`faction_h`=14,`ainame`='SmartAI' WHERE `entry` IN (31191,31192,31194,31196);
UPDATE `creature_template` SET `mindmg`=346,`maxdmg`=499,`attackpower`=287 WHERE `entry`=31192;
UPDATE `creature_template` SET `mindmg`=300,`maxdmg`=350,`attackpower`=250 WHERE `entry`=31194;
UPDATE `creature_template` SET `mindmg`=226,`maxdmg`=270,`attackpower`=221 WHERE `entry`=31196;

DELETE FROM `smart_scripts` WHERE `entryorguid` IN (31191,31192,31194,31196);
INSERT INTO `smart_scripts`  VALUES
('31191','0','0','0','0','0','100','0','1000','1500','5000','5500','11','25054','0','0','0','0','0','2','0','0','0','0','0','0','0','In Combat - Cast Holy Smite'),
('31191','0','1','0','14','0','100','0','3000','4000','6000','7000','11','15586','1','0','0','0','0','1','0','0','0','0','0','0','0','In Combat - Cast Heal'),
('31192','0','0','0','0','0','100','0','1000','1500','3000','3500','11','15496','0','0','0','0','0','2','0','0','0','0','0','0','0','In Combat - Use Cleave'),
('31192','0','1','0','0','0','100','0','2000','2500','5000','5500','11','41057','0','0','0','0','0','2','0','0','0','0','0','0','0','In Combat - Use Whirlwind'),
('31194','0','0','0','0','0','100','0','1000','1500','4000','4500','11','14873','0','0','0','0','0','2','0','0','0','0','0','0','0','In Combat - Use Sinister Strike'),
('31196','0','0','0','6','0','100','0','0','0','0','0','15','13214','0','0','0','0','0','16','0','0','0','0','0','0','0','On Death - Give Quest Credit'),
('31196','0','1','0','0','0','100','0','2000','2500','14000','14500','11','61044','1','0','0','0','0','1','0','0','0','0','0','0','0','In Combat - Use Demoralizing Shout'),
('31196','0','2','0','0','0','100','0','3000','3500','7000','7500','11','58461','0','0','0','0','0','2','0','0','0','0','0','0','0','In Combat - Use Sunder Armor');

[admin]

Добавено.