Need a Query to Delete specific item from specific char inventory ?!!

[devdash]

I tried to make it but i found the item linked in several tables

_Items
_Inventory

And i am afraid there's more tables!

I will really appreciate if you share with me a query to do the job

Thanks in advance.

[mudik]

You Can delete them from smc

[Mr.Awesome1337]

Items are not completely deleted from the DB, when you set an item free, the ID will remain but it'll be available to use again.
You can use this query:

Update _ItemPool set InUse = 0 where ItemID = (Select ItemID from _Inventory where Slot = 13 and CharID = (Select CharID from _Char where CharName16 = 'CharName'))
Update _Inventory Set ItemID = 0 where Slot = 13 and CharID = (Select CharID from _Char where CharName16 = 'CharName')

[devdash]

Originally Posted by mudik

You Can delete them from smc

Right, but i need a query

Originally Posted by Mr.Awesome1337

Items are not completely deleted from the DB, when you set an item free, the ID will remain but it'll be available to use again.
You can use this query:

Update _ItemPool set InUse = 0 where ItemID = (Select ItemID from _Inventory where Slot = 13 and CharID = (Select CharID from _Char where CharName16 = 'CharName'))
Update _Inventory Set ItemID = 0 where Slot = 13 and CharID = (Select CharID from _Char where CharName16 = 'CharName')

with that query, i am disabling the item in slot 13

i need a query that delete the item from a specific char inventory with two options

-- CharName
-- ItemCode

execute = item deleted from that specific char inventory

[Mr.Awesome1337]

--Use this then

UPDATE _ItemPool set InUse = 0 where ItemID in (Select ItemID from _Inventory where CharID =
(SELECT CharID FROM dbo._Char WHERE CharName16 = 'CharName')) AND ItemID IN (SELECT ID64 FROM dbo._Items WHERE RefItemID =
(SELECT ID FROM dbo._RefObjCommon WHERE CodeName128 = 'CodeName'))
Update _Inventory SET ItemID = 0 where (CharID =
(SELECT CharID FROM dbo._Char WHERE CharName16 = 'CharName')) AND ItemID IN (SELECT ID64 FROM dbo._Items WHERE RefItemID =
(SELECT ID FROM dbo._RefObjCommon WHERE CodeName128 = 'CodeName'))

[PortalDark]

#moved

[JoleChow*]

This query will remove it from all server tables (all players)

USE SRO_VT_SHARD EXEC _SEEK_N_DESTROY_ITEM [ITEM CODE NAME]

and you can check the procedure and copy it and little work to make it delete to specific character

[devdash]

Originally Posted by JoleChow*

This query will remove it from all server tables (all players)


and you can check the procedure and copy it and little work to make it delete to specific character

I will try to take this hint, and make the query with it, i hope i success

[JoleChow*]

Originally Posted by alydandy

I will try to take this hint, and make the query with it, i hope i success

keep me updated maybe i can help if doesn't work
Good luck

[devdash]

Originally Posted by JoleChow*

keep me updated maybe i can help if doesn't work
Good luck

I am trying still
i will try everything i knew, then i will feedback here

Originally Posted by JoleChow*

This query will remove it from all server tables (all players)


and you can check the procedure and copy it and little work to make it delete to specific character

Fail, i can not do it, always works for all the characters, i need it to work for a specific charname

[Mr.Awesome1337]

Originally Posted by alydandy

I am trying still
i will try everything i knew, then i will feedback here



Fail, i can not do it, always works for all the characters, i need it to work for a specific charname

I already gave it to you upthere, it deletes the item from a specific player's inventory.

[JoleChow*]

Originally Posted by Mr.Awesome1337

I already gave it to you upthere, it deletes the item from a specific player's inventory.

He don't deserve the effort to help him :/

[devdash]

Originally Posted by JoleChow*

He don't deserve the effort to help him :/

Don't click me

 Spoiler

Haters will hate potatoes will potate

Originally Posted by Mr.Awesome1337

I already gave it to you upthere, it deletes the item from a specific player's inventory.

Gotcha, thanks man

#Request Topic Close please.

[JoleChow*]

[devdash]

Originally Posted by JoleChow*

Stop making fake discord accounts, because of 3 reasons

1. i knew the guy discord ID already
2. discord tells if it's a new account
3. it's shame and stupid to act someone else


Did i troll you hard there?!