- --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
|
