吾爱尚玩资源基地

标题: mangos-zero修复奎尔塞拉任务的SQL文件 [打印本页]

作者: admin 时间: 2016-4-23 17:31
标题: mangos-zero修复奎尔塞拉任务的SQL文件
说明：
直接记事本打开复制内容用N8 右键点击MANGOS世界数据库点击Console 粘贴内容回车重启服务端
最后一步黑龙喷火取消直接奖励精致上古之刃杀死黑龙公主即可完成！！

第一步弗洛尔的屠龙技术纲要任务用N8导入：
DELETE FROM `creature_questrelation` WHERE `quest` = 7507;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 7507;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 7507;
UPDATE `item_template` SET `startquest`=7507 WHERE `entry` = 18401;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 7507;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 7507;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (14368, 7507);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=14368;
DELETE FROM `quest_template` WHERE `entry` = 7507;
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `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`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (7507, 2557, 60, 60, 81, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7508, 18401, 1, 0, '弗洛尔的屠龙技术纲要', '你找到了一些非常重要的东西。这本书和你看到过的其它的书不太一样。$B$B某些人或者某些东西将图书馆的封印揭掉了，这本书中的文字十分混乱，根本无法辨识。', '将《弗洛尔的屠龙技术纲要》还回图书馆。', '你原本可以在黑市上把这本书卖个好价钱，$N。尤其是保护这本书的封印已经被破坏，这使得任何具备必要知识的研究者都可以了解书中包含的屠龙秘密。$B$B也许我们应该给你一份丰厚的奖励……好吧，你必须付出巨大的努力才可以获得这份奖励。$B$B<莱德罗斯对着你咧嘴笑着。>$B', '啊，我们最伟大的书籍中的一卷。它已经遗失很久很久了。', '', '', '', '', '', 18401, 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, 18513, 0, 0, 0, 1, 0, 0, 0, 809, 0, 0, 0, 0, 200, 0, 0, 0, 0, 0, 6000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0);

第二步铸造奎尔塞拉

DELETE FROM `creature_questrelation` WHERE `quest` = 7508;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 7508;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 7508;
UPDATE `item_template` SET `startquest`=7508 WHERE `entry` = 18513;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 7508;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 7508;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (14368, 7508);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=14368;
DELETE FROM `quest_template` WHERE `entry` = 7508;
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `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`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (7508, 2557, 57, 60, 81, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7507, 0, 0, 7509, 18513, 1, 0, '铸造奎尔塞拉', '如果你想要接手这个任务，那就把这把黯淡的精灵剑交给莱德罗斯吧。', '把黯淡的精灵剑交给博学者莱德罗斯。', '如果你能想办法进入黑龙的巢穴，以她的火焰气息加热这把剑，然後用她的鲜血为它淬火，我就可以为你复原它。$B', '太好了，让我们开始吧……', '', '', '', '', '', 18513, 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, 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);

第三步铸造奎尔塞拉《省略掉黑龙喷火步奏直接奖励精致上古之刃只要杀死黑龙公主即可完成任务》

DELETE FROM `creature_questrelation` WHERE `quest` = 7509;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 7509;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 7509;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (14368, 7509);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 14368;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 7509;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 7509;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (14368, 7509);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=14368;
DELETE FROM `quest_template` WHERE `entry` = 7509;
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `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`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (7509, 2159, 55, 60, 62, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 64, 1, 7508, 0, 0, 0, 18492, 1, 0, '铸造奎尔塞拉', '直接奖励精制上古之刃。只要杀死黑龙公主即可。', '你必须杀死黑龙公主！$B$B完成之后，奎尔塞拉就是你的了。', '<莱德罗斯低声吟唱着一些你无法理解的咒语。>$B$B正如我所承诺的，$C，你的精灵之剑，奎尔塞拉。$B', '也许有一天，会有一位勇士重新挥舞这把棱彩古剑。 ', '', '', '', '', '', 18492, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10184, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18348, 0, 0, 0, 1, 0, 0, 0, 809, 0, 0, 0, 0, 200, 0, 0, 0, 0, 0, 6000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0);

作者: 1314 时间: 2016-11-19 16:35
找了好久终于找到了！吾爱尚玩真棒！

欢迎光临吾爱尚玩资源基地 (http://bbs.523play.com/)