ViewInn[Karakterin Bankasındaki İtemleri Görün]

Prosedürümüzün Amacı : İstediğimiz Karakterin Bankasındaki İtemleri Görmek [Birazdan İnventorysindeki İtemleri Görmek İçin Yazdığım Prosedürüde Paylaşıcam]

Kod:
--ISex4FunI Tarafından,Ko-Game.Net İçin Yapılmıştır.
CREATE PROCEDURE ViewInn
@StrUserID varchar(30)
AS
DECLARE @i int, @dwid int, @pos int, @strName varchar(30)

set @i = 1
WHILE @i < 1601
Begin

Select @dwid=cast(cast(substring(cast(substring(WarehouseData, @i,4) as varbinary(4)), 4, 1)+substring(cast(substring(WarehouseData, @i,4) as varbinary(4)), 3, 1)+substring(cast(substring(WarehouseData, @i,4) as varbinary(4)), 2, 1)+substring(cast(substring(WarehouseData, @i,4) as varbinary(4)), 1, 1) as varbinary(4)) as int(4))
From Warehouse
Where strAccountID = @StrUserID

set @strName = ''

Select @strName = strName
from Item
where substring(cast(Num as varchar(9)), 1, 5) = substring(cast(@dwid as varchar(9)), 1, 9)

If @strName = ''
Begin
select @strName = strName
from Item
where substring(cast(Num as varchar(9)), 1, 6) = substring(cast(@dwid as varchar(9)), 1, 8)

If @strName = ''
Begin
select @strName = strName
from Item
where substring(cast(Num as varchar(9)), 1, 7) = substring(cast(@dwid as varchar(9)), 1, 7)

If @strName = ''
Begin
select @strName = strName
from Item
where substring(cast(Num as varchar(9)), 1, 8) = substring(cast(@dwid as varchar(9)), 1, 6)


If @strName = ''
Begin
select @strName = strName
from Item
where substring(cast(Num as varchar(9)), 1, 9) = substring(cast(@dwid as varchar(9)), 1, 5)

If @strName = ''
if @dwid > 0 select @dwid as Item_Code, @strName as Item_Name, @i as offset
Else
select @dwid as Item_Code, @strName as Item_Name, @i as offset
End
Else
Begin
select @dwid as Item_Code, @strName as Item_Name, @i as offset
End
End
Else
Begin
select @dwid as Item_Code, @strName as Item_Name, @i as offset
End
End
Else
Begin
select @dwid as Item_Code, @strName as Item_Name, @i as offset
End
End
Else
Begin
select @dwid as Item_Code, @strName as Item_Name, @i as offset
End


set @i = @i + 4
End
GO

Kullanımı : Kod:
exec ViewInn 'karakter adı'