there are specific item 'types' upon creation, these types are defined AFTER the item is created.
Items given by NPCs are Quest type items = "Q" -
CANNOT BE REROLLED
Items dropped by mobs are Drop type items = "D" -
CAN BE REROLLED
Items generated by GMs or boxes are Spawned type items ="S"-
CAN BE REROLLED
There are three(3) solutions to make this work:
1 - Run this query, to make all existing "Q" items "S" which can be rerolled.
USE PS_GameData
UPDATE CharItems
SET Maketype='S'
WHERE Maketype='Q'
Note: This will affect ALL existing items ONLY and you need to relog to make this work.
(not quite recommended)
2- Instead of directly REWARDING the item to players which results to giving an item "Q" type, make a box/bag.
- box/bags gives "S" type items, thus, you can reroll them.
(i only recommended this if you are only working on few items, else, it will be a bunch of box/bag and quest)
3 - Modify the Stored Procedure: PS_GameData.dbo.usp_Save_Char_Item_Add_E
IF @

ype = 'Q')
BEGIN
SET @

ype = 'D'
END
**Add this under quality query
(i personally recommend doing this)
I hope this helps!