- script del_cards -1,{ OnInit: setarray .@table_name$[0], "inventory", "cart_inventory", "storage", "guild_storage", "mail", "auction"; // Card constants or IDs to delete setarray .@card_id[0], Sealed_TurtleG_Card, SLD_Lord_Of_Death_Card; // Loop through all tables to clear for (.@i = 0; .@i < getarraysize(.@table_name$); .@i++) { // Loop through all cards to delete for (.@j = 0; .@j < getarraysize(.@card_id); .@j++) { // Delete card from table query_sql "DELETE FROM `"+ .@table_name$[.@i] +"` WHERE `nameid` = '"+ .@card_id[.@j] +"'"; // Remove compounded cards query_sql "UPDATE `"+ .@table_name$[.@i] +"` SET `card0` = '0' WHERE `card0` = '"+ .@card_id[.@j] +"'"; query_sql "UPDATE `"+ .@table_name$[.@i] +"` SET `card1` = '0' WHERE `card1` = '"+ .@card_id[.@j] +"'"; query_sql "UPDATE `"+ .@table_name$[.@i] +"` SET `card2` = '0' WHERE `card2` = '"+ .@card_id[.@j] +"'"; query_sql "UPDATE `"+ .@table_name$[.@i] +"` SET `card3` = '0' WHERE `card3` = '"+ .@card_id[.@j] +"'"; } } // Confirm completion announce "Restricted cards have been removed from the server.", bc_all; end; }