How do I delete only Quest Items from Accounts?

[Phoenix]

Hey guys, Since i've fixed my Quest Item Duration (thanks to No Life), I'd like to know how I could delete only the Quest Items like the Shirt,Launcher,etc from people's accounts. I had been on a server where stuff came unlimited and after fixing it, they deleted ONLY quest items from everyone's account so that they won 7 day ones and wouldn't use unlimited ones anymore. How can I do that? Something related to MSSQL?

[MentaL]

[warrenscoots]

in the database expand at dbo.character and put NULL in QuestItemInfo tab

or just sell the items?

[Phoenix]

Sell items from each person's account? Impossible. Thanks, i'll try what you told me, tomorrow.
Posted via Mobile Device

[mikethemak]

Emisands control panel has something like a delete item from all accounts doesnt it?


Otherwise just run an mssql query....

DELETE FROM characteritem WHERE ItemID='1337'

(For example, more to it, but ya o.O)

[Phoenix]

Emisands control panel has something like a delete item from all accounts doesnt it?


Otherwise just run an mssql query....

DELETE FROM characteritem WHERE ItemID='1337'

(For example, more to it, but ya o.O)

Emisand's Panel deletes ALL items either from the Storage or Inventory. I can't give trouble to the players by deleting everything :). Thanks, i'll try that Query out.

Could you please give me the complete Query? I don't know MSSQL.

[Phoenix]

in the database expand at dbo.character and put NULL in QuestItemInfo tab

or just sell the items?

Doesn't work.

[Phoenix]

Emisands control panel has something like a delete item from all accounts doesnt it?


Otherwise just run an mssql query....

DELETE FROM characteritem WHERE ItemID='1337'

(For example, more to it, but ya o.O)

Can I have the complete Query please?

[Linear88]

Can I have the complete Query please?

Add an AND to it, along with the column, etc.

[Phoenix]

Add an AND to it, along with the column, etc.

I'm sorry. I have NO idea at all. I don't know a bit of MSSQL. If you could provide me the whole query, it'd be helpful.

[ManyBlackPpl]

Can I have the complete Query please?

I think the complete query is

USE [GunzDB]

DELETE FROM dbo.CharacterItem WHERE ItemID='(insert itemID here)'

You'll have to do it for all your quest items. For example, if you wanna delete quest items with item id's of 1333, 1334, and 1335, then you would put:

USE [GunzDB]

DELETE FROM dbo.CharacterItem WHERE ItemID='1333'

DELETE FROM dbo.CharacterItem WHERE ItemID='1334'

DELETE FROM dbo.CharacterItem WHERE ItemID='1335'


Then execute that. I'm pretty sure that's how it's done, but just in case, you'd probably wanna try it out on some sort of test server.

Btw, I think everybody would rather you not triple post O_o.

[Phoenix]

Well I bumped again after 24 hours. Really needed it.

[ManyBlackPpl]

erm... did you try the sql query thing? Cuz that should work, I think.

[Phoenix]

No it doesn't.
Posted via Mobile Device

[ManyBlackPpl]

oh wait. Instead of typing:

DELETE FROM dbo.Character WHERE ItemID='1333'

type

DELETE FROM dbo.Character WHERE ItemID = "1333"

if that doesn't work, then idk :o.