/* * This program 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. This program 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 silentium.gameserver.board.Manager; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.List; import javolution.util.FastList; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import silentium.commons.database.DatabaseFactory; import silentium.gameserver.board.BB.Forum; import silentium.gameserver.model.actor.instance.L2PcInstance; public class ForumsBBSManager extends BaseBBSManager { private static Logger _log = LoggerFactory.getLogger(ForumsBBSManager.class.getName()); private final List<Forum> _table; private int _lastid = 1; public static ForumsBBSManager getInstance() { return SingletonHolder._instance; } protected ForumsBBSManager() { _table = new FastList<>(); try (Connection con = DatabaseFactory.getConnection()) { PreparedStatement statement = con.prepareStatement("SELECT forum_id FROM forums WHERE forum_type=0"); ResultSet result = statement.executeQuery(); while (result.next()) { addForum(new Forum(result.getInt("forum_id"), null)); } result.close(); statement.close(); } catch (Exception e) { _log.warn("Data error on Forum (root): " + e.getMessage(), e); } } public void initRoot() { for (Forum f : _table) f.vload(); _log.info("Loaded " + _table.size() + " forums. Last forum id used: " + _lastid); } public void addForum(Forum ff) { if (ff == null) return; _table.add(ff); if (ff.getID() > _lastid) _lastid = ff.getID(); } @Override public void parseCmd(String command, L2PcInstance activeChar) { } public Forum getForumByName(String Name) { for (Forum f : _table) { if (f.getName().equals(Name)) return f; } return null; } public Forum createNewForum(String name, Forum parent, int type, int perm, int oid) { Forum forum = new Forum(name, parent, type, perm, oid); forum.insertIntoDb(); return forum; } public int getANewID() { return ++_lastid; } public Forum getForumByID(int id) { for (Forum f : _table) { if (f.getID() == id) return f; } return null; } @Override public void parseWrite(String ar1, String ar2, String ar3, String ar4, String ar5, L2PcInstance activeChar) { } private static class SingletonHolder { protected static final ForumsBBSManager _instance = new ForumsBBSManager(); } }