[Release] Completely Delete An Item

[-HiwatariKai*]

Hello epvp. I prepared a small query. With this query you can delete all the characters item. I hope help you.

USE [SRO_VT_SHARD]

/* ***** -HiwatariKai* ***** */


DECLARE @Codename128 VARCHAR(128)SET @Codename128 = 'ITEM_MALL_GLOBAL_CHATTING' -- Write code to delete item
UPDATE _Inventory SET ItemID = 0 FROM _Inventory JOIN _Items ON _Items.ID64 = _Inventory.ItemID JOIN _RefObjCommon ON _Items.RefItemID = _RefObjCommon.ID WHERE _RefObjCommon.CodeName128 = @Codename128
UPDATE _Chest SET ItemID = 0 FROM _Chest JOIN _Items ON _Items.ID64 = _Chest.ItemID JOIN _RefObjCommon ON _Items.RefItemID = _RefObjCommon.ID WHERE _RefObjCommon.CodeName128 = @Codename128
UPDATE _GuildChest SET ItemID = 0 FROM _GuildChest JOIN _Items ON _Items.ID64 = _GuildChest.ItemID JOIN _RefObjCommon ON _Items.RefItemID = _RefObjCommon.ID WHERE _RefObjCommon.CodeName128 = @Codename128
UPDATE _InvCOS SET ItemID = 0 FROM _InvCOS JOIN _Items ON _Items.ID64 = _InvCOS.ItemID JOIN _RefObjCommon ON _Items.RefItemID = _RefObjCommon.ID WHERE _RefObjCommon.CodeName128 = @Codename128

[Haxor]

#Approved

[-HiwatariKai*]

Thanks.

Sorry for my bad English.

[magicanoo]

You know you can use seek and destroy procedure,right?

PHP Code:

exec _SEEK_N_DESTROY_ITEM 'ITEM_MALL_GLOBAL_CHATTING' 


[Almouhissen]

KRALLLAR RELEASE^^

[mohamedlove1]

Originally Posted by magicanoo

You know you can use seek and destroy procedure,right?

PHP Code:

exec _SEEK_N_DESTROY_ITEM 'ITEM_MALL_GLOBAL_CHATTING' 


o.O I Wasn't Know it :@ kidding us ?

[-HiwatariKai*]

Originally Posted by magicanoo

You know you can use seek and destroy procedure,right?

PHP Code:

exec _SEEK_N_DESTROY_ITEM 'ITEM_MALL_GLOBAL_CHATTING' 


I know this query. It is Alternative B

[MaDenGo*]

Thank you

[-HiwatariKai*]

Originally Posted by MaDenGo*

Thank you

NP Bro. I hope help you.

[IceAmStiel]

You aren't deleting the items, you're just removing them from players. You should add a query that sets _ItemPool.InUse to 0 for affected ID64's, By setting the _ItemPool.InUse column to 0 it frees the record from _Items for further use in the database. Otherwise the record will stay unused and waste crucial space depending on the times you run your query.

[IceAmStiel]

Originally Posted by Phoenix 1337

Nuff said.
And yeah, If you dont know it, I'm begodofwar

How is this messy thread supposed to be related to my post? ;D

[-HiwatariKai*]

Originally Posted by IceAmStiel

You aren't deleting the items, you're just removing them from players. You should add a query that sets _ItemPool.InUse to 0 for affected ID64's, By setting the _ItemPool.InUse column to 0 it frees the record from _Items for further use in the database. Otherwise the record will stay unused and waste crucial space depending on the times you run your query.

Yes lol. I write "DELETE FROM ALL CHARECTERS". Im not noop.

[IceAmStiel]

Originally Posted by -HiwatariKai*

Yes lol. I write "DELETE FROM ALL CHARECTERS". Im not noop.

You didn't..

Originally Posted by -HiwatariKai*

Hello epvp. I prepared a small query. With this query you can delete all the characters item. I hope help you.

= delete the items of characters. And it's "noop" to not free the records afterwards as they're not going to be used anymore. It simply consumes unnecessarily space at your db and might slower queries that are ran on _Items.

My latter post was supposed to be constructive criticism, yet you took it as an offense..

[鳳凰城]

Originally Posted by IceAmStiel

How is this messy thread supposed to be related to my post? ;D

Sorry meant another post. I was opening both threads together.