jinwenjian 发表于 2009-6-20 08:47:23

装备信息加密，解密代码-1

--Electro Shock Private Server Gaming--
--Procedure Create Time 10.05.2008--
--Please Do Not Change Procedures--
--Lütfen Procedure Üstünde De?i?iklik Yapmay?n?z--

CREATE PROCEDURE item_decode
@strUserId varchar(30)
AS
DECLARE
@length int, -- stritem uzunlu?u
@i int, -- item'in stritem deki yeri
@dwid int,
@dur int,
@duar int,
@StackSize1 int,
@Slot int,
@Row int,
@name varchar(100),
@extname varchar(100),
@ext int


    SET @i = 14*0+1
    SET @length = 337

SELECT @row=count(*) FROM USERDATA WHERE strUserId=@strUserId

DELETE FROM INVENTORY_EDIT WHERE strUserId=@strUserId

IF @row>0
BEGIN

WHILE @i < @length
BEGIN

SELECT @dwid=cast(cast(substring(cast(substring(strItem, @i,4) as varbinary(4)), 4, 1)+substring(cast(substring(strItem, @i,4) as varbinary(4)), 3, 1)+substring(cast(substring(strItem, @i,4) as varbinary(4)), 2, 1)+substring(cast(substring(strItem, @i,4) as varbinary(4)), 1, 1) as varbinary(4)) as int(4)),
@dur = cast(cast(cast( substring(strItem, @i+5, 1) as varbinary(1))+cast(substring(strItem, @i+4, 1) as varbinary(1)) as varbinary(2)) as smallint),
@StackSize1 = cast(cast(cast( substring(strItem, @i+7, 1) as varbinary(1))+cast(substring(strItem, @i+6, 1) as varbinary(1)) as varbinary(2)) as smallint),
      @strUserId = strUserId
      FROM USERDATA
      WHERE strUserId = @strUserId

IF @dwid=0
BEGIN

    SET @extname='Item Not Have'
    SET @name='Item Not Have'

END

明杨旎 发表于 2009-11-7 19:44:28

我保持沉默，我只是路过！















http://www.discuz.net/images/default/sigline.gif
卡徒 http://www.morui.com/book/6/6085/

明杨旎 发表于 2009-11-7 19:47:02

我保持沉默，我只是路过！















http://www.discuz.net/images/default/sigline.gif
卡徒 http://www.morui.com/book/6/6085/

fudada612 发表于 2009-11-24 17:02:23

怎么用啊！

v123 发表于 2009-11-24 17:56:31

试下。。。就知道了
页: [1]
查看完整版本: 装备信息加密，解密代码-1