Sql query/script that will delete item to everyone.

[Meister]

Hi i'm certain that there was a requested topic that deletes one particular item in the server.

 

example I want to delete 16774 to every player including on their storage.. how will I do it on my sql?

or any script? 

 

Thank you!

[Emistry]

shutdown server...and

try run these in your SQL Machine..

 

DELETE FROM `auction` WHERE `nameid` = '16774'
DELETE FROM `cart_inventory` WHERE `nameid` = '16774'
DELETE FROM `guild_storage` WHERE `nameid` = '16774'
DELETE FROM `inventory` WHERE `nameid` = '16774'
DELETE FROM `mail` WHERE `nameid` = '16774'
DELETE FROM `storage` WHERE `nameid` = '16774'

 

 

do a backup before try it.

[Emistry]

shutdown server...and

try run these in your SQL Machine..

 

DELETE FROM `auction` WHERE `nameid` = '16774'
DELETE FROM `cart_inventory` WHERE `nameid` = '16774'
DELETE FROM `guild_storage` WHERE `nameid` = '16774'
DELETE FROM `inventory` WHERE `nameid` = '16774'
DELETE FROM `mail` WHERE `nameid` = '16774'
DELETE FROM `storage` WHERE `nameid` = '16774'

 

 

do a backup before try it.

[burwinkelito]

On 9/7/2013 at 4:40 PM, Capuche said:

Make an update instead of delete to change the id

Could you make an example, please? SQL is messy and dont want to fuck it up...

[burwinkelito]

On 9/7/2013 at 4:40 PM, Capuche said:

Make an update instead of delete to change the id

Could you post an example? Im sorry but trying isnt my thing, im afraid of fucking things up

 

[Lugia]

I guess he's looking for a script?

Try to insert this one :

 

Try this in your test server first :

 

 

 

Mes "Input Item ID";
input .@delitem$;
if(.@delitem$ == " ") goto failed;
next;
Mes "Deleting Items!";
query_sql(DELETE FROM `auction` WHERE `nameid` = "+.@delitem$+");
query_sql(DELETE FROM `cart_inventory` WHERE `nameid` = "+.@delitem$+");
query_sql(DELETE FROM `guild_storage` WHERE `nameid` = "+.@delitem$+");
query_sql(DELETE FROM `inventory` WHERE `nameid` = "+.@delitem$+");
query_sql(DELETE FROM `mail` WHERE `nameid` = "+.@delitem$+");
query_sql(DELETE FROM `storage` WHERE `nameid` = "+.@delitem$+");
next;
Mes "Successful!";
close;

failed:
Mes "Invalid Item ID!";
close;
}
 

 

 

 

I dunno if this code will work but try this first, and tell me the errors, or post some screenshots.

Edited April 1, 2013 by Lugia

[Emistry]

it's better to do this during the server is offline or the SQL will temporary stop update the database.

it will be a problems if the deleted item still exist in the player account since sometime the database will re-update the database with the items info .

[Lugia]

yes of course, and try this one :

 

 

 

x,x,x,x script sample 915,{
mes "Hello";
mes "Want to delete items?";
next;
mes "Please input item id";
input .@delitem$;
if(.@delitem$ == "") goto fail;
next;
query_sql(DELETE FROM `auction` WHERE `nameid` = '"+.@delitem$+"');
query_sql(DELETE FROM `cart_inventory` WHERE `nameid` = '"+.@delitem$+"');
query_sql(DELETE FROM `guild_storage` WHERE `nameid` =   '"+.@delitem$+"');
query_sql(DELETE FROM `inventory` WHERE `nameid` =  '"+.@delitem$+"');
query_sql(DELETE FROM `mail` WHERE `nameid` =  '"+.@delitem$+"');
query_sql(DELETE FROM `storage` WHERE `nameid` =   '"+.@delitem$+"');
next;
Mes "Successful!";
close;

fail:
mes "Invalid Item ID!";
close;
}
 

 

 

try this script if still not working just message me or comment here asap.

[Brian]

yes of course, and try this one :

Your re-post of the script does not address what Emistry said in post #4.

[zhaosin]

Script of Lugia not active, please fix

[Darkpurple]

shutdown server...and

try run these in your SQL Machine..

 

DELETE FROM `auction` WHERE `nameid` = '16774'
DELETE FROM `cart_inventory` WHERE `nameid` = '16774'
DELETE FROM `guild_storage` WHERE `nameid` = '16774'
DELETE FROM `inventory` WHERE `nameid` = '16774'
DELETE FROM `mail` WHERE `nameid` = '16774'
DELETE FROM `storage` WHERE `nameid` = '16774'

 

 

do a backup before try it.

Thanks!

but how about delete multi items?

[Emistry]

DELETE FROM `table` WHERE `nameid` IN ( 607,608,512 );

[ajaytrix]

shutdown server...and

try run these in your SQL Machine..

 

DELETE FROM `auction` WHERE `nameid` = '16774'
DELETE FROM `cart_inventory` WHERE `nameid` = '16774'
DELETE FROM `guild_storage` WHERE `nameid` = '16774'
DELETE FROM `inventory` WHERE `nameid` = '16774'
DELETE FROM `mail` WHERE `nameid` = '16774'
DELETE FROM `storage` WHERE `nameid` = '16774'

 

 

do a backup before try it.

 do you just save this as .sql file and click on database and import this? 

[Brian]

do you just save this as .sql file and click on database and import this?

Yes, that's one way to do it.

Or you can copy-paste those queries directly in the "SQL Query" window, then click Execute.

[archilles89]

is there a way to remove an armor[2] from inventory and storage, while simultaneously giving back an armor[1] plus whatever 2 cards that were socketed in the previous armor? need help with this

[Capuche]

Make an update instead of delete to change the id