123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186 |
- /*
- * 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 <http://www.gnu.org/licenses/>.
- */
- package com.l2jserver.gameserver.model.announce;
- import java.sql.Connection;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.util.concurrent.ScheduledFuture;
- import java.util.logging.Level;
- import com.l2jserver.Config;
- import com.l2jserver.commons.database.pool.impl.ConnectionFactory;
- import com.l2jserver.gameserver.ThreadPoolManager;
- import com.l2jserver.gameserver.util.Broadcast;
- /**
- * @author UnAfraid
- */
- public final class AutoAnnouncement extends Announcement implements Runnable
- {
- private static final String INSERT_QUERY = "INSERT INTO announcements (`type`, `content`, `author`, `initial`, `delay`, `repeat`) VALUES (?, ?, ?, ?, ?, ?)";
- private static final String UPDATE_QUERY = "UPDATE announcements SET `type` = ?, `content` = ?, `author` = ?, `initial` = ?, `delay` = ?, `repeat` = ? WHERE id = ?";
-
- private long _initial;
- private long _delay;
- private int _repeat = -1;
- private int _currentState;
- private ScheduledFuture<?> _task;
-
- public AutoAnnouncement(AnnouncementType type, String content, String author, long initial, long delay, int repeat)
- {
- super(type, content, author);
- _initial = initial;
- _delay = delay;
- _repeat = repeat;
- restartMe();
- }
-
- public AutoAnnouncement(ResultSet rset) throws SQLException
- {
- super(rset);
- _initial = rset.getLong("initial");
- _delay = rset.getLong("delay");
- _repeat = rset.getInt("repeat");
- restartMe();
- }
-
- public long getInitial()
- {
- return _initial;
- }
-
- public void setInitial(long initial)
- {
- _initial = initial;
- }
-
- public long getDelay()
- {
- return _delay;
- }
-
- public void setDelay(long delay)
- {
- _delay = delay;
- }
-
- public int getRepeat()
- {
- return _repeat;
- }
-
- public void setRepeat(int repeat)
- {
- _repeat = repeat;
- }
-
- @Override
- public boolean storeMe()
- {
- try (Connection con = ConnectionFactory.getInstance().getConnection();
- PreparedStatement ps = con.prepareStatement(INSERT_QUERY, Statement.RETURN_GENERATED_KEYS))
- {
- ps.setInt(1, getType().ordinal());
- ps.setString(2, getContent());
- ps.setString(3, getAuthor());
- ps.setLong(4, getInitial());
- ps.setLong(5, getDelay());
- ps.setInt(6, getRepeat());
- ps.execute();
- try (ResultSet rset = ps.getGeneratedKeys())
- {
- if (rset.next())
- {
- _id = rset.getInt(1);
- }
- }
- }
- catch (Exception e)
- {
- _log.log(Level.WARNING, getClass().getSimpleName() + ": Couldn't store announcement: ", e);
- return false;
- }
- return true;
- }
-
- @Override
- public boolean updateMe()
- {
- try (Connection con = ConnectionFactory.getInstance().getConnection();
- PreparedStatement ps = con.prepareStatement(UPDATE_QUERY))
- {
- ps.setInt(1, getType().ordinal());
- ps.setString(2, getContent());
- ps.setString(3, getAuthor());
- ps.setLong(4, getInitial());
- ps.setLong(5, getDelay());
- ps.setLong(6, getRepeat());
- ps.setLong(7, getId());
- ps.execute();
- }
- catch (Exception e)
- {
- _log.log(Level.WARNING, getClass().getSimpleName() + ": Couldn't update announcement: ", e);
- return false;
- }
- return true;
- }
-
- @Override
- public boolean deleteMe()
- {
- if ((_task != null) && !_task.isCancelled())
- {
- _task.cancel(false);
- }
- return super.deleteMe();
- }
-
- public void restartMe()
- {
- if ((_task != null) && !_task.isCancelled())
- {
- _task.cancel(false);
- }
- _currentState = _repeat;
- _task = ThreadPoolManager.getInstance().scheduleGeneral(this, _initial);
- }
-
- @Override
- public void run()
- {
- if ((_currentState == -1) || (_currentState > 0))
- {
- for (String content : getContent().split(Config.EOL))
- {
- Broadcast.toAllOnlinePlayers(content, (getType() == AnnouncementType.AUTO_CRITICAL));
- }
-
- if (_currentState != -1)
- {
- _currentState--;
- }
-
- _task = ThreadPoolManager.getInstance().scheduleGeneral(this, _delay);
- }
- }
- }
|