Following what Bob said, and I'm not DBA, but...
Is it not possible to either add a created date for any item in a characters possession, or alternately create a difference log?
I'm certain the developers can run something analogous to "Select * from Characters where Items_in_inventory like (id of AoN or misc items here)" and compare it to the previous day, etc. This could be automated, until true functionality to stop duping could be added in.
Or hell, generate a GUID and assign one to every item every dropped, although maybe this is too resource intensive.
|