|
You last visited: Today at 22:34
Advertisement
[Release] Completely Delete An Item
Discussion on [Release] Completely Delete An Item within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
07/03/2013, 23:26
|
#1
|
elite*gold: 0 
Join Date: Jul 2013
Posts: 12
Received Thanks: 9
|
[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
|
|
|
|
|
07/04/2013, 00:01
|
#2
|
elite*gold: 0
Join Date: Feb 2008
Posts: 3,777
Received Thanks: 1,455
|
#Approved
|
|
|
|
|
07/04/2013, 00:18
|
#3
|
elite*gold: 0
Join Date: Jul 2013
Posts: 12
Received Thanks: 9
|
Thanks.
Sorry for my bad English. 
|
|
|
|
|
07/04/2013, 04:15
|
#4
|
elite*gold: 0
Join Date: Feb 2008
Posts: 962
Received Thanks: 650
|
You know you can use seek and destroy procedure,right?
PHP Code:
exec _SEEK_N_DESTROY_ITEM 'ITEM_MALL_GLOBAL_CHATTING'
|
|
|
|
|
07/04/2013, 06:37
|
#5
|
elite*gold: 0
Join Date: Feb 2010
Posts: 1,759
Received Thanks: 401
|
KRALLLAR RELEASE^^
|
|
|
|
|
07/04/2013, 11:57
|
#6
|
elite*gold: 0
Join Date: Mar 2012
Posts: 289
Received Thanks: 23
|
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 ?
|
|
|
|
|
07/04/2013, 11:58
|
#7
|
elite*gold: 0
Join Date: Jul 2013
Posts: 12
Received Thanks: 9
|
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
|
|
|
|
|
07/04/2013, 14:21
|
#8
|
elite*gold: 0
Join Date: Jul 2013
Posts: 72
Received Thanks: 14
|
Thank you
|
|
|
|
|
07/04/2013, 14:23
|
#9
|
elite*gold: 0
Join Date: Jul 2013
Posts: 12
Received Thanks: 9
|
Quote:
Originally Posted by MaDenGo*
Thank you
|
NP Bro. I hope help you.
|
|
|
|
|
07/04/2013, 23:43
|
#10
|
elite*gold: 0
Join Date: Jul 2011
Posts: 1,058
Received Thanks: 1,118
|
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.
|
|
|
|
|
07/05/2013, 00:17
|
#11
|
elite*gold: 0
Join Date: Jul 2011
Posts: 1,058
Received Thanks: 1,118
|
Quote:
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
|
|
|
|
|
07/05/2013, 01:38
|
#12
|
elite*gold: 0
Join Date: Jul 2013
Posts: 12
Received Thanks: 9
|
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.
|
|
|
|
|
07/05/2013, 10:19
|
#13
|
elite*gold: 0
Join Date: Jul 2011
Posts: 1,058
Received Thanks: 1,118
|
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..
|
|
|
|
|
07/05/2013, 10:24
|
#14
|
elite*gold: 273
Join Date: Aug 2012
Posts: 4,451
Received Thanks: 2,429
|
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.
|
|
|
|
 |
Similar Threads
|
[HELP] Delete item
09/04/2020 - SRO Private Server - 4 Replies
hello
my GM char item bug.
ITEM_MALL_M_SANTA
item write and item wear.now char bug have :(
ID - PW enter 1-2 sec. later game error
|
[HOW] How to Delete NPC and Item
11/06/2011 - EO PServer Hosting - 3 Replies
How to delete them? i cant find in cq_NPC and cq_itemtype
all i need just query to remove them someone help me :)
|
[Quest]Item Delete
04/11/2011 - Metin2 PServer Guides & Strategies - 14 Replies
Hallo Elitepvpers
Ich habe diese Quest geschrieben, damit man die Items die man nicht vk
oder runterwerfen kann.
Diese Quest löscht diese Items
quest:
quest itemdelete begin
state start begin
when 20001.take with pc.get_level() > 80 and item.vnum != 11971 and item.vnum != 11972 and item.vnum != 11973 and item.vnum != 11974 and item.count >= 1 begin
local vnum = item.get_vnum()
|
Completely New Release Thread
09/08/2009 - EO PServer Guides & Releases - 0 Replies
Ok guys with alot of people releasing alot of stuff, rather than having everyone having to use the search function or telling new members to use the search function (and trust me seeing that all the time gets annoying) I have decided to make a list of Releases. They are done by the creator of them. I take no credit for any of the work, unless i made the one. This thread is going to be locked right away to keep the spam out of it. If you want something added to it then private message me with...
|
Delete an Item in Mail
02/14/2005 - WoW Exploits, Hacks, Tools & Macros - 0 Replies
1. Find someone annoying ie a person who constantly is spamming an item they own.
2. Tell them you are interested in it and have it sent to you COD
3. Open the mail but dont buy, delete, or return it. Let it stay there for 3 days in limbo.
4. In 3 days the email will be deleted like junk mail.
5. It will not be returned to the sender.
------
gut um paar lamer auf die eier zu gehn :>
|
All times are GMT +1. The time now is 22:37.
|
|
![[Release] Completely Delete An Item](https://www.elitepvpers.com/forum/iconimages/sro-pserver-guides-releases/release-completely-delete-item_ltr.gif){kind=small}
