- 精华
- 阅读权限
- 110
- 好友
- 相册
- 分享
- 听众
- 收听
- 注册时间
- 2008-11-22
- 在线时间
- 小时
- 最后登录
- 1970-1-1
|

楼主 |
发表于 2009-9-15 20:23:51
|
显示全部楼层
调整经验和暴率
在SQL的查询分析器中执行下边命令:
设置2倍经验
update MAIN_DB_1.dbo.NpcParams set Exp=Exp*2;
update MAIN_DB_1.dbo.NpcParams2 set Exp=Exp*2;
当然。如果经验过高想调低也可以
update MAIN_DB_1.dbo.NpcParams set Exp=Exp*0.5;原来经验的一半
update MAIN_DB_1.dbo.NpcParams2 set Exp=Exp0.5;原来经验的一半
NpcParams+NpcParams2 的和除以2 就是经验
Bill_Users 商城
UserAliasList 角色
UserAliasLog 角色
GuildList 行会表
FriendList 好友表
UserList_Private 帐号
UserList 帐号
在SQL的查询分析器中执行下边命令:
一键端的爆率是5000
爆率修改
1000表示修改后的数据。5000是原数据。
根据自己的数据来修改。
UPDATE NpcDropItemParams2
SET Pro01 = 1000, Pro02 = 1000, Pro03 = 1000, Pro04 = 1000, Pro05 =
1000,
Pro06 = 1000, Pro07 = 1000, Pro08 = 1000, Pro09 = 1000, Pro10 =
1000,
Pro11 = 1000, Pro12 = 1000, Pro13 = 1000, Pro14 = 1000, Pro15 =
1000,
Pro16 = 1000, Pro17 = 1000, Pro18 = 1000, Pro19 = 1000, Pro20 =
1000,
Pro21 = 1000, Pro22 = 1000, Pro23 = 1000, Pro24 = 1000, Pro25 =
1000,
Pro26 = 1000, Pro27 = 1000, Pro28 = 1000, Pro29 = 1000, Pro30 =
1000,
Pro31 = 1000, Pro32 = 1000, Pro33 = 1000, Pro34 = 1000, Pro35 =
1000,
Pro36 = 1000, Pro37 = 1000, Pro38 = 1000, Pro39 = 1000, Pro40 =
1000,
Pro41 = 1000, Pro42 = 1000, Pro43 = 1000, Pro44 = 1000, Pro45 =
1000,
Pro46 = 1000, Pro47 = 1000, Pro48 = 1000
WHERE (Pro01 = 5000) AND (Pro02 = 5000) AND (Pro03 = 5000) AND (Pro04
= 5000) AND
(Pro05 = 5000) AND (Pro06 = 5000) AND (Pro08 = 5000) AND (Pro07
= 5000) AND
(Pro10 = 5000) AND (Pro09 = 5000) AND (Pro11 = 5000) AND (Pro12
= 5000) AND
(Pro13 = 5000) AND (Pro14 = 5000) AND (Pro15 = 5000) AND (Pro16
= 5000) AND
(Pro17 = 5000) AND (Pro18 = 5000) AND (Pro19 = 5000) AND (Pro20
= 5000) AND
(Pro21 = 5000) AND (Pro22 = 5000) AND (Pro23 = 5000) AND (Pro24
= 5000) AND
(Pro25 = 5000) AND (Pro27 = 5000) AND (Pro26 = 5000) AND (Pro28
= 5000) AND
(Pro29 = 5000) AND (Pro30 = 5000) AND (Pro31 = 5000) AND (Pro32
= 5000) AND
(Pro33 = 5000) AND (Pro34 = 5000) AND (Pro35 = 5000) AND (Pro36
= 5000) AND
(Pro37 = 5000) AND (Pro38 = 5000) AND (Pro39 = 5000) AND (Pro40
= 5000) AND
(Pro41 = 5000) AND (Pro42 = 5000) AND (Pro43 = 5000) AND (Pro44
= 5000) AND
(Pro45 = 5000) AND (Pro46 = 5000) AND (Pro47 = 5000) AND (Pro48
= 5000) |
|