/*
* 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();
}
}