Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE procedure itemleri_bul
- @StrUserID varchar(30)
- AS
- DECLARE
- @length int, -- stritem uzunlugu
- @i int, -- item'in stritem deki yeri
- @dwid int,
- @dur int,
- @duar int,
- @StackSize1 int,
- @Sira int,
- @Row int,
- @name varchar(100),
- @extname varchar(100),
- @ext int
- set @i = 14*0+1
- set @length = 401
- select @row=count(*) from userdata where struserid=@StrUserID
- delete from itemler 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
- insert into itemler (dwid,stacksize,durability,struserid,sira,itembasicname,extname)
- values(@dwid,@stacksize1,@dur,@StrUserID,(@i-1) / 8,@extname,@name )
- set @i=@i+8
- end
- end
- GO
Add Comment
Please, Sign In to add comment