Solved Remove all items query.

[Ceejzor]

Hi, I tried using this.

DELETE FROM player_depotitems, player_items, tile_items WHERE itemtype = 2471;

But I'm getting this problem.
"#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE itemtype = 2471' at line 1"

Any suggestions?

PS should server be totally offline or can it be closed?

 

[Archez]

Ehm, single queries?

DELETE FROM  `player_depotitems` WHERE `itemtype` = '2471';
DELETE FROM  `player_items` WHERE `itemtype` = '2471';
DELETE FROM  `tile_items` WHERE `itemtype` = '2471';

 

[Ceejzor]

Ehm, single queries?

DELETE FROM  `player_depotitems` WHERE `itemtype` = '2471';
DELETE FROM  `player_items` WHERE `itemtype` = '2471';
DELETE FROM  `tile_items` WHERE `itemtype` = '2471';

Should server be totally offline or can I just close it so only I am on and do it?

 

[GOD Heviock]

Should server be totally offline or can I just close it so only I am on and do it?

Try it both ways, but i would perfer offline.

 

[Grehy]

Yes, it should probably be offline

 

[Archez]

Just close it (/closeserver), you don't need to shutdown. (the queries will affect offline players)

 

[anotapreta]

good