• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Query Mysql

Sort by date Sort by votes
This is what I could come up with, not tested. (X, Y, Z equals to item ID's)
SQL: 
DELETE FROM `player_depotitems`, `player_items`, `tile_items` WHERE `itemtype` IN ("X", "Y", "Z");
 
Upvote 0 Downvote
SQL: 
#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` IN ("7410", "2160", "2466")' at line 1
 
Upvote 0 Downvote
My mistake, try with three statements instead of one. :p

SQL: 
DELETE FROM `player_depotitems` WHERE `itemtype` IN ("X", "Y", "Z");
DELETE FROM `player_items` WHERE `itemtype` IN ("X", "Y", "Z");
DELETE FROM `tile_items` WHERE `itemtype` IN ("X", "Y", "Z");
 
Upvote 0 Downvote
Back
Top