关灯
开启左侧

mangos-zero修复奎尔塞拉任务的SQL文件

  [复制链接]
admin实名认证 发表于 2016-4-23 17:31:37 | 显示全部楼层 |阅读模式 打印 上一主题 下一主题
 
说明:
直接记事本打开 复制内容用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);

 

精彩评论1

倒序浏览
1314 发表于 2016-11-19 16:35:17 | 显示全部楼层
 
找了好久终于找到了!吾爱尚玩真棒!
 
VIP介绍
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

  • 最佳新人

    注册账号后积极发帖的会员
  • 活跃会员

    经常参与各类话题的讨论,发帖内容较有主见
  • 热心会员

    经常帮助其他会员答疑
  • 推广达人

    积极宣传本站,为本站带来更多注册会员
  • 宣传达人

    积极宣传本站,为本站带来更多的用户访问量
  • 灌水之王

    经常在论坛发帖,且发帖量较大
  • 突出贡献

    长期对论坛的繁荣而不断努力,或多次提出建设性意见
  • 优秀版主

    活跃且尽责职守的版主
  • 荣誉管理

    曾经为论坛做出突出贡献目前已离职的版主
  • 论坛元老

    为论坛做出突出贡献的会员

0关注

5粉丝

3421帖子

排行榜
作者专栏

QQ交流群&&微信订阅号

QQ交流群

微信订阅号

吾爱尚玩资源基地永久域名:

Www.523Play.Com

在线管理员QQ:1589479632

邮箱:Email@523play.com

QQ交流群:558936238

Copyright   ©2015-2116  吾爱尚玩资源基地|523play.comPowered by©523Pplay.Com技术支持:吾爱尚玩资源基地