Greetings Everyone,
A member pointed out an anomaly that was happening in our marketplace and I managed to fix it. This issue however most likely affected everyone and I'm looking for a way to code a script to fix the problem without blowing up the whole thing. I have found what caused it and plugged that hole. Additionally it's become painfully apparent that the Auto Hide work orders based on players going AFK is broke in a way that I didn't even think about. If a user goes afk his work order historically still sits there. They are not in the main work order list so it sits there for months on end. When that user comes back it reads it to the list assuming the work order hasn't been filled since they added the work order. This often times is grounding 5x or more the value even though it's only been there that long because it was hidden.
So to fix this problem in the future:
All work orders placed by members who have not checked in for more than 60 days will automatically be removed.
This should serve both needs and when a user returns they can request the items again. I've seen some really strange things like a 100 contribution item be worth over 1000. That shouldn't be the case in the situation a player goes afk.