查询人物身上的装备sql,赚点辛苦费，高手们不要鄙视俺这些穷人啊

--第一个耳环的位置的装备
select cast(cast(substring(cast(strItem as varbinary(400)),4, 1)+substring(cast(strItem as varbinary(400)), 3, 1)+substring(cast(strItem as varbinary(400)), 2, 1)+substring(cast(strItem as varbinary(400)),1, 1) as varbinary(4)) as int(4)) as id,cast(cast(substring(cast(strItem as varbinary(400)),6, 1)+substring(cast(strItem as varbinary(400)), 3, 1) as varbinary(2)) as smallint(2)) as dur,cast(cast(substring(cast(strItem as varbinary(400)),8, 1)+substring(cast(strItem as varbinary(400)), 7, 1) as varbinary(2)) as smallint(2)) as Count from USERDATA where strUserId='人物名称'
--头部的装备
select cast(cast(substring(cast(strItem as varbinary(400)),12, 1)+substring(cast(strItem as varbinary(400)), 11, 1)+substring(cast(strItem as varbinary(400)), 10, 1)+substring(cast(strItem as varbinary(400)),9, 1) as varbinary(4)) as int(4)) as id,cast(cast(substring(cast(strItem as varbinary(400)),14, 1)+substring(cast(strItem as varbinary(400)), 11, 1) as varbinary(2)) as smallint(2)) as dur,cast(cast(substring(cast(strItem as varbinary(400)),16, 1)+substring(cast(strItem as varbinary(400)), 15, 1) as varbinary(2)) as smallint(2)) as Count from USERDATA where strUserId='人物名称'
--第二个耳环的位置的装备
select cast(cast(substring(cast(strItem as varbinary(400)),20, 1)+substring(cast(strItem as varbinary(400)), 19, 1)+substring(cast(strItem as varbinary(400)), 18, 1)+substring(cast(strItem as varbinary(400)),17, 1) as varbinary(4)) as int(4)) as id,cast(cast(substring(cast(strItem as varbinary(400)),22, 1)+substring(cast(strItem as varbinary(400)), 19, 1) as varbinary(2)) as smallint(2)) as dur,cast(cast(substring(cast(strItem as varbinary(400)),24, 1)+substring(cast(strItem as varbinary(400)), 23, 1) as varbinary(2)) as smallint(2)) as Count from USERDATA where strUserId='人物名称'
--身上物品栏第一个位置的装备
select cast(cast(substring(cast(strItem as varbinary(400)),116, 1)+substring(cast(strItem as varbinary(400)), 115, 1)+substring(cast(strItem as varbinary(400)), 114, 1)+substring(cast(strItem as varbinary(400)),113, 1) as varbinary(4)) as int(4)) as id,cast(cast(substring(cast(strItem as varbinary(400)),118, 1)+substring(cast(strItem as varbinary(400)), 125, 1) as varbinary(2)) as smallint(2)) as dur,cast(cast(substring(cast(strItem as varbinary(400)),120, 1)+substring(cast(strItem as varbinary(400)), 119, 1) as varbinary(2)) as smallint(2)) as Count from USERDATA where strUserId='人物名称'
---身上物品栏第二个位置的装备
select cast(cast(substring(cast(strItem as varbinary(400)),124, 1)+substring(cast(strItem as varbinary(400)), 123, 1)+substring(cast(strItem as varbinary(400)), 122, 1)+substring(cast(strItem as varbinary(400)),121, 1) as varbinary(4)) as int(4)) as id,cast(cast(substring(cast(strItem as varbinary(400)),126, 1)+substring(cast(strItem as varbinary(400)), 133, 1) as varbinary(2)) as smallint(2)) as dur,cast(cast(substring(cast(strItem as varbinary(400)),128, 1)+substring(cast(strItem as varbinary(400)), 127, 1) as varbinary(2)) as smallint(2)) as Count from USERDATA where strUserId='人物名称'
--这几条sql就可以看出来怎么查询的了，用了一天的时间才摸索出来，累！

现在装备保存已经不是问题了，现在发的库都已经解决了

骗钱的哈哈!!!!

骗钱的哈哈!!!!
evaydd 发表于 2009-9-10 20:06

晕，这些绝对是原创，怎么会骗钱的，不用查询语句你能看出来人物的装备吗，

记得有人发过找查询装备的问题，我找了好久也没找到，这个是根据28085279发的1310数据库做的sql，

谢谢分享，的确是可以查到ID的

创建一个新库 然后把老外的库的表格跟存储 导到新库里面
接着自己修改下表格排序 全部设置为默认排序。
这样就解决保存物品的问题了 仓库也能保存的。

创建一个新库 然后把老外的库的表格跟存储 导到新库里面
接着自己修改下表格排序 全部设置为默认排序。
这样就解决保存物品的问题了 仓库也能保存的。
熊猫 发表于 2009-9-11 14:20

呵呵，这个不是保存物品的sql，这个是查看人物身上有什么装备的sql，这个和保存没什么关系，晕呼，怎么都理解错了。。。。

不够钱了

8# 机灵小不懂


-   -！主题是这样写的嘛。