Question: Item GUID and Database Usage

[Kyroth88]

Hello,

Thanks a ton for this addon, great work on it.

I am trying to understand what happens to the item_instance table when unused/unsold auctions from the bot are removed from the AH.

Do these items retain a GUID under item_instance or are they eventually dropped from the table if they are not moved to a new owner_guid from the BOT?

I am worried about overloading my table with tons of unused items as I would like to have upwards of 10,000 on the AH at a time.

Thank you for taking the time to help me understand this.

[kewinrausch]

I may not be the most competent person to answer this, but if the auction expires the item is given back to the auction owner, but the bot is scripted to drop the mail and destroy the item from the database.

if (receiver.GetPlayerGUIDLow() == auctionbot->GetAHBplayerGUID())
{
    if (sender.GetMailMessageType() == MAIL_AUCTION)
    {
        deleteMailItemsFromDB = true;
    }

    sendMail = false;
}