Quote:
Originally Posted by fadetree
[You must be logged in to view images. Log in or Register.]
The problem (probably) is that there is no history of items. One thing you could do would be to expand the table that holds the items to have a globally unique key ( if it doesn't already ) and then instrument the rest of the code to lay down log records in a big ass log table everytime something significant happens to an item. Creation and trading events would be logged with the items UUID. That way, you could run a query to pull the creation and trading events for any item at any time.
Not sure how the duping works, but it seems like at some point the system would wind up inserting a (mostly) duplicate row into the item table...if you could figure out a signature you could make that a unique db index and have the system fail the insert. Would need to know more about the item system and the db schema to be sure.
|
Well... I don't know what you mean about a history of items, but hasn't Rogean (or nilbog?) posted from server logs before to show up people who whined about losing items or something? Like, I think it was Alawen actually, posted ages ago complaining that the server botched a drop transfer of his... and then Rogean/Nilbog showed up in the thread and pasted in some server logs showing timestamps and names and the items etc, of the guy who happened across the drop transfer cache and picked it up while Alawen was switching chars.
Found it! Dang Alawen for having an older forum name that I had to search too:
Quote:
Originally Posted by Uthgaard
[You must be logged in to view images. Log in or Register.]
Anything you place into a tradeskill container is returned when you close it.
And like they told you, someone else picked it up. Find a better spot/method.
Daire 2011-02-26 18:50:55 Dropped Item [commons] 17969{,10146,2280}
Amapolo 2011-02-26 18:51:29 Picked Up Item [commons] 17969{,10146,2280}
|