Multiple item checker and nuker on EVENT_TARGET_CHANGE. Need help.

[nosfentora]

Off the top of my head not really. You could run an sql query something like

DELETE FROM botinventory WHERE ItemID IN (itemid1,itemid2,itemid3)

that would delete all items that are in that list from bot inventory.

you could get real complicated and have a scheduled task run on the os every X hours and run that script, or run it by hand whenever you want.

as far as a perl script, you could do something like this pseudo code suggests

var banned_item_id_list = {1000,10002,10003}

EVENT bot_spawn

for each item in bot_inventory
  if banned_item_id_list contains item.itemid
    delete item
  end if
next

end event

[chrsschb]

I assume these class / sub-class charms are pretty powerful. So powerful in fact that a player would never want to get rid of it. So if the charm is used in the quest to upgrade it, I'm assuming that the quest is repeatable? If the quest is repeatable make it NOT repeatable and you've solved your problem. I know if > I < only had ONE badass charm, and couldn't get another, I damn sure wouldn't waste it on a bot.

[Cilraaz]

Originally Posted by chrsschb

I assume these class / sub-class charms are pretty powerful. So powerful in fact that a player would never want to get rid of it. So if the charm is used in the quest to upgrade it, I'm assuming that the quest is repeatable? If the quest is repeatable make it NOT repeatable and you've solved your problem. I know if > I < only had ONE badass charm, and couldn't get another, I damn sure wouldn't waste it on a bot.

I think it's more a matter of dropping the starter charm on a bot, obtaining a second one, questing the second one to the best it can be, taking the first one back from the bot, and questing it up to be next to the best it can be. That assumes that it's somehow possible to get the starter item again, but I think it's the problem that's happening.

Drakiyth, if you're interested in finding out who is cheating (now that you've outlined that storing a charm on a bot is a no-no), you could use something like:

SELECT * FROM account WHERE id=(
SELECT account_id FROM character_ WHERE id=(
SELECT BotOwnerCharacterID FROM bots WHERE BotID=(
SELECT BotID FROM botinventory WHERE ItemID IN('00001','00002'))));

Obviously substitute item numbers 00001 and 00002 for whatever items you're checking for. That should return the account rows for any account where any character owns any bot holding any disallowed item.