PDA

View Full Version : SQL Challenge !


KingMort
10-20-2011, 03:37 PM
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
10-20-2011, 05:02 PM
they can take nodrop items using #bot giveitem

KingMort
10-20-2011, 08:46 PM
Oh....

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