SQL 企业管理器 库:rxjhgame 表:TBL_Char 上右键->打开表->查询
输入:
Update [TBL_Char] set [TBL_Char].FLD_ITEM=这里加上代码 Where
[TBL_Char].FLD_NAME='这里加上人物名'
人物名要保留单引号 如 [TBL_Char].FLD_NAME='蜗牛慢慢'
本人SQL菜鸟,网站菜鸟,ASP菜鸟,失误之处敬请指正。
代码(完整代码在最后):
代码:
0xF13C1300000000002ED7EE0B010000008796980000000000000000000000000000000000001C43130000000000
2ED7EE0B010000000000000000000000000000000000000000000000000000
红字部分:2ED7EE0B 为物品ID
查看方法:每二个一组从后向前翻过来,再转换成十进制,就是ITEM表里面的物品ID
例:2E D7 EE 0B
颠倒 = 0B EE D7 2E
转换 = 200202030
SQL数据库内 TBL_ITEM表内PID=200202030 数据是这样的:
200202030 惟尊剑
代码:
0xF13C1300000000002ED7EE0B010000008796980000000000000000000000000000000000001C43130000000000
2ED7EE0B010000000000000000000000000000000000000000000000000000
蓝字部分:0100 为物品数量,对于武器、衣服、手镯等物品,都是0100
查看方法:同上
例:01 00
颠倒 = 00 01
转换 = 1
对于弓箭、回城符等可叠加的物品,此属性生效,如:弓箭有10支,这里将会是:10 转16进制= A 颠倒
=0A 00
代码:
0xF13C1300000000002ED7EE0B010000008796980000000000000000000000000000000000001C43130000000000
2ED7EE0B010000000000000000000000000000000000000000000000000000
绿字部分:879698 为物品附加属性(代码请参考网上很多人发布的属性代码,太多,懒得写)
查看方法:同上
例:87 96 98
颠倒 = 98 96 87
转换 = 10000007
10000007 代表强化 + 7 如果你想将强化加至 99 来换算下:
10000099 转16进制= 98 96 E3 颠倒 = E3 96 98
完整代码:
Update [TBL_Char] set
[TBL_Char].FLD_ITEM=0xF13C1300000000002ED7EE0B0100000087969800000000000000000000000000000000
00001C431300000000002ED7EE0B0100000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000
Where [TBL_Char].FLD_NAME='热血江湖私服'