增加传奇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);
|
Copyright © 2009 - 2014 传奇资源网 All rights reserved.
传奇资源网—最专业的传奇服务端下载站
联系QQ:157090393,邮箱:157090393#qq.com(#换成@)
所有传奇版本都经过站长亲自测试,保证可以进入游戏并游戏
每日更新传奇开区版本,免费版本下载