What I'd suggest is, sadly, another table in the database for pending deliveries. When a request comes in to check the delivery box, it should be a simple selection if the primary key is the (unique) character ID. You only need to remove up to a set # of entries, which keeps the query result small and you could even process more if you accumulate all the gil receipts to deliver in 1 'slot'.Quote:
I was wondering, since the Delivery Box doesn't work... you have gil sent back to the character, if the item is bid on. Well, what happens if the item is NOT bid on? Does the item go back to the character's inventory? Does it expire? No expiration would be sweet, since there's a low number of ppl going to be playing at any given time, anyway.
I'd suggest no expiration, but I've seen no evidence in the client that the 'auction status' window will scroll like the other browsable windows.