




UPDATE creature_template SET minhealth = 420, maxhealth = 420 WHERE entry = 927;
UPDATE creature SET curhealth = 420 WHERE id = 927;
UPDATE quest_template SET ExclusiveGroup = 2998, NextQuestId = 1641, RewXpOrMoney = 1380 WHERE entry = 2998;
UPDATE creature_template SET minhealth = 13000, maxhealth = 13000, minmana = 0, maxmana = 0 WHERE entry = 5149;
UPDATE creature SET curhealth = 13000, curmana = 0 WHERE id = 5149;
UPDATE quest_template SET ExclusiveGroup = 2998, NextQuestId = 1641, RequiredRaces = 1, RewXpOrMoney = 1380 WHERE entry = 3681;
DELETE FROM creature_involvedrelation WHERE quest = 3681;
INSERT INTO creature_involvedrelation VALUES
(6171, 3681);
DELETE FROM creature_questrelation WHERE quest = 1641;
INSERT INTO creature_questrelation VALUES
(6171, 1641);
UPDATE quest_template SET SpecialFlags = 4, ExclusiveGroup = 0, RequiredRaces = 1, RewItemId1 = 6775, RewItemCount1 = 1, RewXpOrMoney = 2760 WHERE entry = 1641;
DELETE FROM creature_involvedrelation WHERE quest = 1641;
INSERT INTO creature_involvedrelation VALUES
(6171, 1641);
DELETE FROM creature_questrelation WHERE quest = 1642;
UPDATE quest_template SET RequiredRaces = 1, ExclusiveGroup = 0, RewXpOrMoney = 540 WHERE entry = 1642;
UPDATE quest_template SET RequiredRaces = 1, RewXpOrMoney = 2760 WHERE entry = 1643;
UPDATE creature_template SET minhealth = 3900, maxhealth = 3900 WHERE entry = 6174;
UPDATE creature SET curhealth = 3900 WHERE id = 6174;
UPDATE quest_template SET SpecialFlags = 1, RewXpOrMoney = 5400 WHERE entry = 1644;
UPDATE quest_template SET RequiredRaces = 1, RewXpOrMoney = 1380 WHERE entry = 1780;
UPDATE quest_template SET RequiredRaces = 1, WHERE entry = 1781;
UPDATE quest_template SET RewXpOrMoney = 4050 WHERE entry = 1786;
UPDATE creature_template SET civilian = 1 WHERE entry = 6172;
DELETE FROM spell_script_target WHERE targetEntry = 6172;
INSERT INTO spell_script_target VALUES
(8593, 1, 6172);
UPDATE quest_template SET RequiredRaces = 1, RewXpOrMoney = 4050 WHERE entry = 1787;
DELETE FROM creature_loot_template WHERE item = 6846;
INSERT INTO creature_loot_template VALUES
(474, 6846, 0, 100, 1, 1, 1),
(6866, 6846, 0, 100, 1, 1, 1);
UPDATE quest_template SET RequiredRaces = 1, ReqSpellCast1 = 0, RewXpOrMoney = 6900 WHERE entry = 1788;








Uživatelé procházející toto fórum: Žádní registrovaní uživatelé a 1 návštěvník