Finding The durability of a sos item.

05/06/2013 02:35 Guar_dianS#1
Well im adding new items into npcs. and the refscrappackageofitem requires a column named "data" . im guessing thats the durability of the specific item. Ive found online the durability stats of weapon items. But i cant find of armor sos , or light armor sos or robe sos. Any one know some where that i can find the oringinal stats of those sos items ?
05/06/2013 03:00 IceAmStiel#2
Should cover everything up (Data = _RefObjItem.Dur_L) »

Code:
UPDATE dbo._RefScrapOfPackageItem
SET Data = i.Dur_L
FROM dbo._RefScrapOfPackageItem s with(NOLOCK) 
JOIN dbo._RefObjCommon r with(NOLOCK) on s.RefItemCodeName = r.CodeName128 
JOIN dbo._RefObjItem i with(NOLOCK) on r.Link = i.ID 
WHERE TypeID1 = 3 AND TypeID2 = 1 AND TypeID3 in (1,2,3,4,6,9,10,11) AND r.[Service] = 1
05/06/2013 21:10 Guar_dianS#3
Thank you. Worked wonderfully
02/18/2020 17:17 kkyykkk#4
help :(