SQL Challenge !

[KingMort]

Need a Query that will do the following

It will go into "botinventory" and take the BotID , and find the account ID of that BotID (The Owner of the Bot) and then place the ItemID from that Bot (from "botinventory") into the appropriate account ID in "account_rewards"..

Basically what I want to do is Return everyones Items to them and reset the Bot Inventory completely because some of the stuff I have on the Bots was no drop and now they just take only tradeable items so I want to reset them without everyone getting pissed about losing all the items on their bots..

Mort

[Congdar]

they can take nodrop items using #bot giveitem

[KingMort]

Oh....

Still would be cool to be able to do that what I mentioned though hehe