Spirit Item and Flag Items about silkroad-laravel

[Devsome]

SELECT IFA.*,RO.CodeName128,RO.TypeID1,RO.TypeID2,RO.TypeID3,RO.TypeID4 FROM dbo._InventoryForAvatar IFA INNER JOIN dbo._Items IT ON IT.ID64 = IFA.ItemID INNER JOIN dbo._RefObjCommon RO ON IT.RefItemID = RO.ID
WHERE IFA.CharID = 1

TypeID3 = 13 and TypeID4 = 1 then 'Hat'
TypeID3 = 13 and TypeID4 = 2 then 'Dress'
TypeID3 = 13 and TypeID4 = 3 then 'Attach'
TypeID3 = 13 and TypeID4 = 4 then 'Flag'
TypeID3 = 14 and TypeID4 = 1 then 'Spirit Item'

• 13 - 1 (hat)

• 13 - 2 (dress)

• 13 - 3 (attach)

• 13 - 4 (flag)

• 14 - 1 (spirit)

• typeid3 - typeid4

Thanks to Deadly