Error data that is a durability or maxstack of a item

10/02/2021 03:13 -[Anxi]-#1
Hello everyone am try change items from npc

From Moon to sun i get this error i get this query and no thing happend

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
[Only registered and activated users can see links. Click Here To Register...]

how solve it.
10/02/2021 03:58 Muhab*#2
Since accessories doesn't have durability, you have to set Data value to "1" in _RefScrapOfPackageItem.
10/02/2021 09:41 -[Anxi]-#3
Quote:
Originally Posted by Muhab* View Post
Since accessories doesn't have durability, you have to set Data value to "1" in _RefScrapOfPackageItem.
Thanks alot solved ...