// ######################################################################################################################################## public void deleteKiosk(MOCKioskKiosk kiosk) { // Remove block this.plugin .getServer() .getWorld(kiosk.getLocation().getWorld().getName()) .getBlockAt(kiosk.getLocation()) .setType(Material.AIR); // Remove in memory records MOCKioskKioskDeck deck = getDeck(kiosk.getPopup_deck_id()); MOCKioskKioskSlide slide = getSlide(kiosk.getPopup_deck_id()); this.kiosks.remove(kiosk); this.slides.remove(slide); this.decks.remove(deck); // Remove database records this.databaseConnection.deleteSafeQuery("DELETE FROM `kiosks` WHERE `id`=" + kiosk.getId()); this.databaseConnection.deleteSafeQuery( "DELETE FROM `kiosk_decks` WHERE `id`=" + kiosk.getPopup_deck_id()); this.databaseConnection.deleteSafeQuery( "DELETE FROM `kiosk_slides` WHERE `indeck_id`=" + kiosk.getPopup_deck_id()); }