Google
 36 123
发新话题
打印

数据库补丁 ncdb 1205 to 1220

本主题由 艾森尼 于 2008-8-10 22:04 移动

数据库补丁 ncdb 1205 to 1220

适用版本 :  99Game Beta4
补丁描述 : 差异同步 NCDB, 版本从 1205 -> 1220


本次补丁共计 4个文件, 解压后, 分别为:
  1__1205_to_1209.sql   ( 主要修复任务 )
  2__1210_to_1219.sql   ( 修复任务经验, 任务等级, 任务完成时的文字, 任务触发,结束NPC )
  3__ncdb_to_1200.sql   ( 同样修复任务.. )
  4__mmx_fix_npcflags.sql  ( 与 NCDB 1220 版本的 creautre_proto.npcflags 同步 )

使用方法:  按照文件顺序, 使用 navicat 对 as_world_99game 导入( 执行批次任务 )
补丁测试:  已在测试服中执行, 测试无错,  并收录...
     ( 如果执行有错, 请等待下次完整库的发布 ..  )

本次补丁 95% 数据都是根据英文 NCDB 差异获取....99Game 整理发布
如果你愿意, 可以自己进行差异检出, NCDB 地址是: http://mmoforge.org/svn/ncdb  帐号 anonymous 密码留空即可


这里奉劝某些商业化版本.....
不要厚着脸皮实行商业行为, 还号称自己是在学习研究, 说自己免费.......
不要以为自己对程序修改了 10% 都不到, 就可以号称自主开发.....
不要以为将官方SVN修复的内容, 写到自己站上就可以忽悠了全部地球人......

在鼻子上插了2棵葱, 难道就可以冒充大象 ?!
内行看门道, 外行看热闹.....
做一分, 说一分.........人....不是那么好蒙的........


-----------------------------------------------------------------------------------------------------------------------------------------

分流下载:
本地下载 :
附件: 您所在的用户组无法下载或查看附件
身无彩凤双飞翼

TOP

早起的鳥兒有蟲吃
感謝更新

TOP

赶紧去更新,嘿嘿
本人的回答仅供参考!因为我也不确定是否为正确的解决办法!

TOP

在鼻子上插了2棵葱, 难道就可以冒充大象 ?!
内行看门道, 外行看热闹.....
做一分, 说一分.........人....不是那么好蒙的........

顶啊 顶啊 让我们一起BS那些人吧!

TOP

作风务实,态度严谨,十分敬仰。

TOP

MMX,使用第一个SQL文件,7个查询 有6个已处理 一个错误。。。
看看是什么问题。。。

下面是失败内容:
复制内容到剪贴板
代码:
[Err] 1153 - Got a packet bigger than 'max_allowed_packet' bytes
[Err] REPLACE INTO `quests` (`entry`, `ZoneId`, `sort`, `flags`, `MinLevel`, `questlevel`, `Type`, `RequiredRaces`, `RequiredClass`, `RequiredTradeskill`, `RequiredRepFaction`, `RequiredRepValue`, `LimitTime`, `SpecialFlags`, `PrevQuestId`, `NextQuestId`, `srcItem`, `SrcItemCount`, `Title`, `Details`, `Objectives`, `CompletionText`, `IncompleteText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqKillMobOrGOId1`, `ReqKillMobOrGOId2`, `ReqKillMobOrGOId3`, `ReqKillMobOrGOId4`, `ReqKillMobOrGOCount1`, `ReqKillMobOrGOCount2`, `ReqKillMobOrGOCount3`, `ReqKillMobOrGOCount4`, `ReqCastSpellId1`, `ReqCastSpellId2`, `ReqCastSpellId3`, `ReqCastSpellId4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepValue1`, `RewRepValue2`, `RewRepLimit`, `RewMoney`, `RewXP`, `RewSpell`, `CastSpell`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `RequiredMoney`, `ExploreTrigger1`, `ExploreTrigger2`, `ExploreTrigger3`, `ExploreTrigger4`, `RequiredQuest1`, `RequiredQuest2`, `RequiredQuest3`, `RequiredQuest4`, `ReceiveItemId1`, `ReceiveItemId2`, `ReceiveItemId3`, `ReceiveItemId4`, `ReceiveItemCount1`, `ReceiveItemCount2`, `ReceiveItemCount3`, `ReceiveItemCount4`, `IsRepeatable`) VALUES
        ('5741','405','0','8','30','33','0','0','0','0','0','0','0','1','0','6027','0','0','Sceptre of Light','The Burning Blade in Thunder Axe Fortress to the east is rumored to have acquired the Sceptre of Light from the Naga. Legend tells that the sceptre is able to sink entire cities under the great seas. The Burning Blade must not be allowed to possess such power.$B$BTo that end, you must retrieve the sceptre yourself!  It is held by a Burning Blade seer, who studies the sceptre from atop one of the Thunder Axe watchtowers.\r\n','Get the Sceptre of Light and then return it to Azore Aldamort at the tower in Ethel Rethor.\r\n','The elusive Sceptre of Light!  Your acquisition of it has removed a grave threat to the world.  Well done, $C, well done.','Do you have the Sceptre of Light?','','','','','','15750','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','529','0',500,0,0,3500,'2650','0',0,'0','0','0','0',17400,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
        ('5742','139','0','10','52','56','0','0','0','0','0','0','0','4','0','5781','0','0','Redemption','You have worked hard, friend. Rest your weary bones and allow me to properly introduce myself.\r\n','Listen to what Tirion Fordring has to say.','The Fordring redemption will be a difficult task. Are you prepared?','','Tirion\'s Tale','','','','','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,'575','0',0,'0','0','0','0',5100,0,0,0,0,5542,5543,5544,0,0,0,0,0,0,0,0,0,0),
        ('5761','2437','0','8','9','16','81','690','0','0','0','0','0','1','0','0','0','0','Slaying the Beast','The primary task set upon me by our great Warchief is to root out the creatures responsible for infesting our lord\'s great city with demonic influence. The Burning Blade is one threat, but there are others; the Searing Blade for instance, who make their home in Ragefire Chasm, secretly attempting to subvert innocent members of the Horde.$B$BIf they are to be stopped, then their leader must be slain--a Felguard named Taragaman the Hungerer.$B$BKill him, and his heart will appease Thrall, of this I\'m sure.','Enter Ragefire Chasm and slay Taragaman the Hungerer, then bring his heart back to Neeru Fireblade in Orgrimm
[Msg] Finished - Unsuccessfully
--------------------------------------------------
本人的回答仅供参考!因为我也不确定是否为正确的解决办法!

TOP

.......顶啊.....赶快看看

TOP

永远支持99~
一起BS某些人~

TOP

支持啊!!!一直等着呢!

TOP

实在不得已发这贴,各位抱歉了·········
一直不懂navicat 对这些修正问题的补丁怎么导入,百度了下,MS有个教程······但早已打不开···············
特别想玩下魔兽世界的单机!恳请懂的朋友说下详细步骤·············拜谢了!

TOP

我的错,是在是我的错·········终于在论坛里找到教程了···········今晚就可以爽了··············

TOP

我也是第一个SQL文件导入失败

TOP

看了教程受益匪浅啊···········大恩也就不言谢了!
只是我也出现第1个SQL文件导入出错的问题,就像6楼的斑斑情况一样,234都正常!

TOP

我也是第一个出错了一个

TOP

导入不了的可以尝试这样做

先要找到自己mysql.exe文路径。在mysql的bin目录下。。。
进入命令行的bin目录下
输入mysql -u 用户名 -p 数据库名 < sql所在绝对地址
例如:
我的
D:\MySQL\bin>mysql -u root -p as_world_99game < c:/1__1205_to_1209.sql
然后会提示输入mysql密码。然后就回执行,不会有报错的
祝大家导入成功

TOP

 36 123
发新话题