EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   SQL Challenge ! (https://www.eqemulator.org/forums/showthread.php?t=34376)

KingMort 10-20-2011 03:37 PM

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

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


All times are GMT -4. The time now is 08:55 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.