Винсент
08.04.2010, 20:53
Фикс для квеста:
#сияние рассвета (подходя к Могрейну, штурм не начинается)
UPDATE quest_template SET Method='0', ReqCreatureOrGoid1='0', ReqCreatureOrGoCount1='0' WHERE entry='12801';
Квест с выбором предметов:
DELETE FROM `creature_questrelation` WHERE `quest` = 12801;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 12801;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 12801;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28444, 12801);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 28444;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (29173, 12801);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 29173;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (31082, 12801);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 31082;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 12801;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 12801;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28444, 12801);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=28444;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (29173, 12801);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=29173;
REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorableKills`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`) VALUES (12801, 0, -372, 0, 55, 55, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 192, 0, 0, 0, 6, 12800, 13165, 0, 13165, 0, 0, 0, 'The Light of Dawn', 'The Argent Dawn stands defiantly against us at Light\'s Hope Chapel. They dare oppose the Scourge and for that reason alone they must be destroyed!$B$BThe mighty armies of the Lich King stand at the ready as the final battle for the Plaguelands approaches. Today we ascend into the immortal realm of Scourge heroes!$B$BWhen you are ready for battle, report to Highlord Darion Mograine. It is the highlord who will issue the final march orders and command our armies at Light\'s Hope Chapel.', 'Defeat the forces of the Argent Dawn and uncover the Light of Dawn.$B$BReport to Highlord Darion Mograine should you survive.', 'There will be no atonement for us, $N. We are forever damned to walk the earth as monsters. While the Lich King may have loosed his grip upon us, the specters of our past will forever haunt our memories.$B$BWe must make amends in the only way we know how: Death...$B$BI ask you now to join me in Acherus as a Knight of the Ebon Blade. Together we will destroy the Lich King and end the Scourge.', '<Highlord Mograine nods.>', '', 'The Light of Dawn Uncovered', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 29245, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 38633, 38632, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1098, 0, 0, 0, 0, 3000, 0, 0, 0, 0, 0, 0, 98100, 50977, 53821, 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);
#сияние рассвета (подходя к Могрейну, штурм не начинается)
UPDATE quest_template SET Method='0', ReqCreatureOrGoid1='0', ReqCreatureOrGoCount1='0' WHERE entry='12801';
Квест с выбором предметов:
DELETE FROM `creature_questrelation` WHERE `quest` = 12801;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 12801;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 12801;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28444, 12801);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 28444;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (29173, 12801);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 29173;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (31082, 12801);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 31082;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 12801;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 12801;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28444, 12801);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=28444;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (29173, 12801);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=29173;
REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorableKills`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`) VALUES (12801, 0, -372, 0, 55, 55, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 192, 0, 0, 0, 6, 12800, 13165, 0, 13165, 0, 0, 0, 'The Light of Dawn', 'The Argent Dawn stands defiantly against us at Light\'s Hope Chapel. They dare oppose the Scourge and for that reason alone they must be destroyed!$B$BThe mighty armies of the Lich King stand at the ready as the final battle for the Plaguelands approaches. Today we ascend into the immortal realm of Scourge heroes!$B$BWhen you are ready for battle, report to Highlord Darion Mograine. It is the highlord who will issue the final march orders and command our armies at Light\'s Hope Chapel.', 'Defeat the forces of the Argent Dawn and uncover the Light of Dawn.$B$BReport to Highlord Darion Mograine should you survive.', 'There will be no atonement for us, $N. We are forever damned to walk the earth as monsters. While the Lich King may have loosed his grip upon us, the specters of our past will forever haunt our memories.$B$BWe must make amends in the only way we know how: Death...$B$BI ask you now to join me in Acherus as a Knight of the Ebon Blade. Together we will destroy the Lich King and end the Scourge.', '<Highlord Mograine nods.>', '', 'The Light of Dawn Uncovered', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 29245, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 38633, 38632, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1098, 0, 0, 0, 0, 3000, 0, 0, 0, 0, 0, 0, 98100, 50977, 53821, 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);