Tady posílám už updatnutý na nejnovější revizi.
Hordacka verze:
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 20000;
INSERT INTO `creature_questrelation` VALUES (14392, 20000);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 14392;
INSERT INTO `creature_involvedrelation` VALUES (14392, 20000);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=14392;
INSERT INTO `quest_template` VALUES (20000, 0, 0, 70, 70, 0, 690, 0, '0', '0', 0, 0, 0, 0, 2, 0, 8, 0, '0', 0, 0, 0, 0, 0, 0, 0, 'Kill general Marcus Jonathan!', ' For horde! Kill General Jonathan Marcus. Remuneration will be responsible Your offence.', 'On the evidence of his death prines me his helmet.', 'Bring me a helmet generala Marcuse Jonathan', 'No finally.', 'Here it yet.', 'Still on you wait ...', 'Do you there helmet?!', '', '', '', '', '', 50000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', '0', '29434', '0', '0', '0', '10', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', '0', '0', '500000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0');
INSERT INTO `creature_loot_template` VALUES (466, 50000, -66, 0, 1, 1, 0, 0, 0);
INSERT INTO `item_template` VALUES (50000, 12, 0, 0, 'Helma Marcuse Jonathana', 48057, 6, 0, 1, 0, 0, 0, -1, -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 4, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0);
Alicka verze:
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 20001;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (466, 20001);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 466;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (466, 20001);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=466;
INSERT INTO `quest_template` VALUES (20001, 0, 0, 70, 70, 0, 1101, 0, 0, 0, 0, 0, 0, 0, 2, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Kill Overlord Runthak!!!', 'Honour and glory of the Alliance! Kill Overlord Runthak. I have the impression that against me something stamped.', 'On the evidence of his death bring me his gloves.', 'Bring me gloves Overlord Runthak.', 'Finally ...', 'Here to you.', 'Still wait to you...', 'You are no longer those gloves?', '', '', 0, 0, 0, 50001, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 29434, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 500001, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (14392, 50001, -66, 0, 1, 1, 0, 0, 0);
INSERT INTO `item_template` VALUES (50001, 12, 0, 0, 'Hands of Overlord Runthak', 48032, 6, 0, 1, 0, 0, 0, -1, -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, -1, 4, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0);