Mass Edit SQL DB Item removal from all inventory.
Ok so i know what item ID i need to have removed. I read a post reffering how to remove just from 1 person's inventory. However i do know there is a way to remove from all accounts all at 1 time. Could i possibly get a step by step or a example query code in order to input to have all removed. Doing 1 by 1 will be purely HELL! I'll also need to know where to input for guild storages too.
Probably by doing a Query of some sort.
Yeah it is a query but i want to make sure i have the right input. Don't wanna screw up my whole SQL DB now lol
DELETE FROM w00_Character.dbo.tItem WHERE nItemID = '999999'
Replace 999999 with whatever the ID is in your shn for your item.
That dun even look like a query code command lol
Okay...... then. I tried to help you, but I guess you don't need it.
:x Dark what LolOmgNoob just sent you is what the Query is. If you ever have doubt about it just make a back up before you execute anything.
I'm a noob.
I do need it and it did now work D= but i will try again =D not only that i am deleting a LOT of items :) not just one at a time
- - - Updated - - -
It looks like it worked. Meanwhile i got one last question. My launcher has a maintenance would you know where i need to go possibly in the SQL in order to turn it on?
I'm just taking a wild guess on changing the querry to work for you but:
DELETE FROM w00_Character.dbo.tItem WHERE nItemID >= '0'
What's different in this one besides the >= '0'?Originally Posted by darielgames312
Someone wants to ruin the DB.
The ">= 0" means, delete every item which item ID is greater and equal than 0.
As for the query, remove the single quotes, as they aren't needed.
Lul damn, knew it had something to do with that given the >.
And yeah, I know, it's just a bad habit of doing them like that. ;c
Isn't that what you wanted?
Its ok i got it. For the multiple items i just copied the rows and on each i just put the ID i needed removed. Executed all one time and they all went poof :)
Reply With Quote