[Release] Completely Delete An Item

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

Quote:

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

#Approved

Thanks.

Sorry for my bad English. :)

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

KRALLLAR RELEASE^^

Quote:

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 ?

Quote:

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 :)

Thank you

Quote:

Originally Posted by MaDenGo* Thank you

NP Bro. I hope help you. :)

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.

Quote:

Originally Posted by Phoenix 1337 [Only registered and activated users can see links. Click Here To Register...] 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

Quote:

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.

Quote:

Originally Posted by -HiwatariKai* Yes lol. I write "DELETE FROM ALL CHARECTERS". Im not noop.

You didn't..

Quote:

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..

Quote:

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.