Automated Auction House

Hi all i am trying to make an Automated Auction House
But i need some help with the database fields.
For the life of me i cannot find what feilds i use from the item_template to add the item into item_instance data field
please help somone.
as far as the project goes it takes the highest player then searches for item that they can use, armour and weapons only atm.
Then it uses an admin account and creates the items in the item_instance (this is my problem)
then it will add it to AH (this is another problem i cannot work out the time field and the list of auctioneers id`s)
after 1 day all items that have been mailed to the admin will be deleted from the mail and the item_instance, and new items will be added.
I have set this so you can have it random, over selected periods of time like every 4 hours add 10 new items at random auctioneer.

I hope anyone can help me
Cheers in advance

Interesting idea, But I think you can just use core function calls to create the items in an inventory (much like a quest NPC would) Get ahold of the full MaNGOS source files and start digging around. They would hold your answer.

I remember reading somewhere that someone made a auction house filler. If you find it 50% of your work will be done. I think it was on official SDB forum... not sure though. If your lucky the guy might help you. Good luck.