/* * Copyright (C) 2004-2015 L2J Server * * This file is part of L2J Server. * * L2J Server is free software: you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * L2J Server is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see . */ package com.l2jserver.gameserver.taskmanager.tasks; import java.sql.Connection; import java.sql.PreparedStatement; import com.l2jserver.commons.database.pool.impl.ConnectionFactory; import com.l2jserver.gameserver.taskmanager.Task; import com.l2jserver.gameserver.taskmanager.TaskManager; import com.l2jserver.gameserver.taskmanager.TaskManager.ExecutedTask; import com.l2jserver.gameserver.taskmanager.TaskTypes; public class TaskDailySkillReuseClean extends Task { private static final String NAME = "daily_skill_clean"; private static final int[] _daily_skills = { 2510, 22180 }; @Override public String getName() { return NAME; } @Override public void onTimeElapsed(ExecutedTask task) { try (Connection con = ConnectionFactory.getInstance().getConnection()) { for (int skill_id : _daily_skills) { try (PreparedStatement ps = con.prepareStatement("DELETE FROM character_skills_save WHERE skill_id=?;")) { ps.setInt(1, skill_id); ps.execute(); } } } catch (Exception e) { _log.severe(getClass().getSimpleName() + ": Could not reset daily skill reuse: " + e); } _log.info("Daily skill reuse cleaned."); } @Override public void initializate() { super.initializate(); TaskManager.addUniqueTask(NAME, TaskTypes.TYPE_GLOBAL_TASK, "1", "06:30:00", ""); } }