Vsro Kod Paylaşım Karakterin İnventoryi Görebilmek

M

mertcan

#1
Karakterin üzerindeki invetoryde ne varsa görebilirsiniz.
karakter adı yazmanız yeterlidir.(CHAR NAME)kısmına.



Kod:
USE [SRO_VT_SHARD]
SELECT
[dbo].[_Inventory].[CharID],
[dbo].[_Char].[CharName16],
[dbo].[_Inventory].[Slot],
[dbo].[_Inventory].[ItemID],
[dbo].[_Items].[RefItemID],
[dbo].[_Items].[OptLevel],
[dbo].[_RefObjCommon].[CodeName128]
FROM [dbo].[_Inventory]
JOIN [dbo].[_Char] ON [dbo].[_Inventory].[CharID] = [dbo].[_Char].[CharID]
JOIN [dbo].[_Items] ON [dbo].[_Inventory].[ItemID] = [dbo].[_Items].[ID64]
JOIN [dbo].[_RefObjCommon] ON [dbo].[_Items].[RefItemID] = [dbo].[_RefObjCommon].[ID]
WHERE [dbo].[_Char].[CharName16] like'Char Name'
ORDER BY[dbo].[_Char].[CharName16]ASC,[dbo].[_Inventory].[Slot]ASC;
 
Get involved!

Here you can only see a limited number of comments. On MSA Network | Bilgi ve Paylaşım Platformu you see all comments and all functions are available to you. To the thread