TFS 1.X+ How do i delete an equipped item off a character? unequippable glitched wand

[nugo]

A player on my server that has a wand he used fine for days glitch on him after he logged out, all thats left in his left hand slow is a picture of a monster and a glitched item. He cant interact with the item, cant move it and cant move anything into its place, its essentiall stuck. I know player_items table stores items in peoples inventory and depos but how do i delete that wand slot?

using TFS 1.2

Thanks

Bonus points if you can tell me why the wand glitch, it was an energized limb.

Gyazo

gyazo.com

 

[Infernum]

[TFS 1.2] Luascript channel

direct lua script execution via chatchannel default values: player - your userdata cid - your uid Updated! New features brought to you by @LaloHao @Summ and @Non Sequitur - added sandbox - multiple lines support - tested on 1.2 chatchannels.xml: execute.lua local CHAT_ID = 9 function...

otland.net

player:getSlotItem(CONST_SLOT_LEFT):remove()
If it's another player, use Player('player name here'):getSlotItem(CONST_SLOT_LEFT):remove() instead.

 

[nugo]

Cheers, ill give that a go. Out of curiosity for future stuff can you do it with a mysql queery, are player items in their slots stored in the database?

EDIT: Cheers that script did the job, appreciate it.

 

[Infernum]

Yes it's stored in the database, but I don't have any test server for myself so I couldn't tell you the exact way. I believe you cross reference the inventory slot with the pid or sid to get the location of the item and just match for the item id you want to remove in that slot. But like I said, I can't be definitive since I'm working from memory here and haven't had a test server in about a month.

 

[Sarah Wesker]

Use this function and talkaction:

Delete item offline or online - Pastebin.com

Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.

pastebin.com

only work with items on inventory

 

[Nukefish]

Bonus points if you can tell me why the wand glitch, it was an energized limb.

I haven't quite gotten to the bottom of this, but I'm experiencing the same issue with items in backpacks/equip slots, that have an id of greater than 32767, which happens to be the max value for a 16 bit int (signed short), and this also happens to be the id of the item that appears instead. Still looking for the culprit, but I assume it's connected to the extended items dat/spr or how (in my case) otc handles those.

Edit:
Actually, the answer can be found here.