vSro Paylaşım vSRO Karakterin Çantasını ve Üzerindeki Eşyaları Görüntüleme

USE [SRO_VT_SHARD]
GO

-- ===================================================================
-- İNCELENECEK KARAKTER ADI
-- ===================================================================
DECLARE @CharName VARCHAR(16) = 'KARAKTER_ADI' -- Buraya karakterin adını giriniz

SELECT 
    CH.CharName16 AS [Karakter],
    INV.Slot AS [SlotNo],
    CASE 
        WHEN INV.Slot = 0  THEN 'Kask (Helm)'
        WHEN INV.Slot = 1  THEN 'Üstlük (Chest)'
        WHEN INV.Slot = 2  THEN 'Omuzluk (Shoulder)'
        WHEN INV.Slot = 3  THEN 'Eldiven (Gloves)'
        WHEN INV.Slot = 4  THEN 'Pantolon (Pants)'
        WHEN INV.Slot = 5  THEN 'Ayakkabı (Boots)'
        WHEN INV.Slot = 6  THEN 'Silah (Weapon)'
        WHEN INV.Slot = 7  THEN 'Kalkan (Shield)'
        WHEN INV.Slot = 8  THEN 'Küpe (Earring)'
        WHEN INV.Slot = 9  THEN 'Kolye (Necklace)'
        WHEN INV.Slot = 10 THEN 'Yüzük 1 (Ring 1)'
        WHEN INV.Slot = 11 THEN 'Yüzük 2 (Ring 2)'
        WHEN INV.Slot = 12 THEN 'Avatar / Ekipman'
        ELSE 'Çanta (Inventory)'
    END AS [Konum],
    ROC.CodeName128 AS [ItemKodu],
    IT.OptLevel AS [Plus],
    CASE 
        WHEN IT.Data = 0 THEN 1 
        ELSE IT.Data 
    END AS [Adet],
    IT.ID64 AS [ItemSerialID]
FROM dbo._Inventory INV
INNER JOIN dbo._Char CH ON CH.CharID = INV.CharID
INNER JOIN dbo._Items IT ON IT.ID64 = INV.ItemID
INNER JOIN dbo._RefObjCommon ROC ON ROC.ID = IT.RefItemID
WHERE CH.CharName16 = @CharName
  AND INV.ItemID > 0
ORDER BY INV.Slot ASC