热血江湖数据库MYSQL修改_求更多热血江湖私服 修改数据库语句

--将所有防具的防御力增加F99*4updatetbl_dropsetfld_magic1=20000099,fld_magic2=20000099,fld_magic3=20000099,fld_magic4=20000099wherefld_pp=8000--将所有的极品武器(X7X4X9X10...

--将所有防具的防御力 增加F99*4

update tbl_drop set fld_magic1=20000099,fld_magic2=20000099,fld_magic3=20000099,fld_magic4=20000099 where fld_pp=8000

--将所有的极品武器(X7 X4 X9 X10)增加WG99*4

update tbl_drop set fld_magic1=70000099,fld_magic2=70000099,fld_magic3=70000099,fld_magic4=70000099 where fld_magic4=70000025

--使神匠宝盒能随机开三件披风 并且披风合成概率 25%*4=100%

update tbl_open set fld_pidx=16900030,fld_namex='海蓝星雨装(男)',fld_pp=900 where fld_index=67

update tbl_open set fld_pidx=16900012,fld_namex='迷雾黑风战袍(男)',fld_pp=900 where fld_index=68

update tbl_open set fld_pidx=16900044,fld_namex='江湖英雄铠(男)',fld_pp=900 where fld_index=69

update tbl_item set fld_magic2=90000025,fld_magic3=90000025,fld_magic4=90000025,fld_magic5=90000025 where fld_pid=16900030

update tbl_item set fld_magic2=90000025,fld_magic3=90000025,fld_magic4=90000025,fld_magic5=90000025 where fld_pid=16900012

update tbl_item set fld_magic2=90000025,fld_magic3=90000025,fld_magic4=90000025,fld_magic5=90000025 where fld_pid=16900044

--增加金钱 个人包 4.9E

update tbl_char set fld_money=490000000 where fld_index=0

--增加金钱 公共仓库 4.9E

update tbl_publicwarehouse set fld_money=490000000 where fld_id='wangtao'

--增加 血吟刀的攻击力的 攻击力上限 983-999

update tbl_item set fld_at1=983,fld_at2=999 where fld_pid=100202024

展开