SQL Challenge !
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
|