版本亲测 | 新手教程 | 问题留言 | 站内搜索
本类栏目导航:| 传奇入门 | 传奇架设 | 配置登陆 | 传奇引擎 | 报毒防毒 | 作者补丁 | 从零开始 | 网站知识 | 传奇常用 | 电脑文摘 |
您现在的位置:传奇资源网 > 传奇总汇 > 传奇引擎 >
增加传奇sf天降神技能DB扩展

文章作者:传奇爱好者 文章来源:www.8sf.org 文章点击: 次 更新时间:2011年04月03日

功能:增加传奇sf天降神技能DB扩展

已经扩展好的DB:点击下载

示例:

[!] 扩展Magic.DB,打开HeroDB分别执行以下SQL命令,各需要等级、经验自行设置:
其中 MaxTrainLv 为最高可自然升级的技能级别,
可以使用:ChangeTranPoint 技能名 操作符(+ - =) 数值 //修改技能经验点

-----------------------------------------------------------------
以下一次执行: (NeedL%d-每个技能级别需要人物等级)
Alter Table Magic Add Column NeedL4 Integer;
Alter Table Magic Add Column NeedL5 Integer;
Alter Table Magic Add Column NeedL6 Integer;
Alter Table Magic Add Column NeedL7 Integer;
Alter Table Magic Add Column NeedL8 Integer;
Alter Table Magic Add Column NeedL9 Integer;
Alter Table Magic Add Column NeedL10 Integer;
Alter Table Magic Add Column NeedL11 Integer;
Alter Table Magic Add Column NeedL12 Integer;
Alter Table Magic Add Column NeedL13 Integer;
Alter Table Magic Add Column NeedL14 Integer;
Alter Table Magic Add Column NeedL15 Integer;

以下一次执行:
UpDate Magic.DB Set NeedL4=(NeedL3 + (NeedL3 - NeedL2)) WHERE (MagID <> 0);
UpDate Magic.DB Set NeedL5=(NeedL4 + (NeedL3 - NeedL2)) WHERE (MagID <> 0);
UpDate Magic.DB Set NeedL6=(NeedL5 + (NeedL3 - NeedL2)) WHERE (MagID <> 0);
UpDate Magic.DB Set NeedL7=(NeedL6 + (NeedL3 - NeedL2)) WHERE (MagID <> 0);
UpDate Magic.DB Set NeedL8=(NeedL7 + (NeedL3 - NeedL2)) WHERE (MagID <> 0);
UpDate Magic.DB Set NeedL9=(NeedL8 + (NeedL3 - NeedL2)) WHERE (MagID <> 0);
UpDate Magic.DB Set NeedL10=(NeedL9 + (NeedL3 - NeedL2)) WHERE (MagID <> 0);
UpDate Magic.DB Set NeedL11=(NeedL10 + (NeedL3 - NeedL2)) WHERE (MagID <> 0);
UpDate Magic.DB Set NeedL12=(NeedL11 + (NeedL3 - NeedL2)) WHERE (MagID <> 0);
UpDate Magic.DB Set NeedL13=(NeedL12 + (NeedL3 - NeedL2)) WHERE (MagID <> 0);
UpDate Magic.DB Set NeedL14=(NeedL13 + (NeedL3 - NeedL2)) WHERE (MagID <> 0);
UpDate Magic.DB Set NeedL15=(NeedL14 + (NeedL3 - NeedL2)) WHERE (MagID <> 0);

以下一次执行: (L%dTrain-每个技能级别需要升级经验)
Alter Table Magic Add Column L4Train Integer;
Alter Table Magic Add Column L5Train Integer;
Alter Table Magic Add Column L6Train Integer;
Alter Table Magic Add Column L7Train Integer;
Alter Table Magic Add Column L8Train Integer;
Alter Table Magic Add Column L9Train Integer;
Alter Table Magic Add Column L10Train Integer;
Alter Table Magic Add Column L11Train Integer;
Alter Table Magic Add Column L12Train Integer;
Alter Table Magic Add Column L13Train Integer;
Alter Table Magic Add Column L14Train Integer;
Alter Table Magic Add Column L15Train Integer;

以下一次执行:
UpDate Magic.DB Set L4Train=(L3Train * 2) WHERE (MagID <> 0);
UpDate Magic.DB Set L5Train=(L4Train * 2) WHERE (MagID <> 0);
UpDate Magic.DB Set L6Train=(L5Train * 2) WHERE (MagID <> 0);
UpDate Magic.DB Set L7Train=(L6Train * 2) WHERE (MagID <> 0);
UpDate Magic.DB Set L8Train=(L7Train * 2) WHERE (MagID <> 0);
UpDate Magic.DB Set L9Train=(L8Train * 2) WHERE (MagID <> 0);
UpDate Magic.DB Set L10Train=(L9Train * 2) WHERE (MagID <> 0);
UpDate Magic.DB Set L11Train=(L10Train * 2) WHERE (MagID <> 0);
UpDate Magic.DB Set L12Train=(L11Train * 2) WHERE (MagID <> 0);
UpDate Magic.DB Set L13Train=(L12Train * 2) WHERE (MagID <> 0);
UpDate Magic.DB Set L14Train=(L13Train * 2) WHERE (MagID <> 0);
UpDate Magic.DB Set L15Train=(L14Train * 2) WHERE (MagID <> 0);


以下一次执行: (MaxTrainLv-最高可升级的技能级别)
Alter Table Magic Add Column MaxTrainLv Integer;

以下一次执行:
UpDate Magic.DB Set MaxTrainLv=3 WHERE (MagID <> 0);

评论一下
推荐文章
热门文章
相关文章
在线留言 - 关于我们 - 发布软件 - 网站声明 -