com.l2jfree.gameserver.instancemanager.BlockListManager.java Source code

Introduction

Here is the source code for com.l2jfree.gameserver.instancemanager.BlockListManager.java

Source

/*
 * 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 com.l2jfree.gameserver.instancemanager;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;
import java.util.Set;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import com.l2jfree.L2DatabaseFactory;
import com.l2jfree.gameserver.gameobjects.L2Player;
import com.l2jfree.lang.L2Integer;
import com.l2jfree.util.LazyFastSet;

/**
 * @author NB4L1
 */
public final class BlockListManager {
    private static final Log _log = LogFactory.getLog(BlockListManager.class);

    private static final String SELECT_QUERY = "SELECT charId, name FROM character_blocks";
    private static final String INSERT_QUERY = "INSERT INTO character_blocks (charId, name) VALUES (?,?)";
    private static final String DELETE_QUERY = "DELETE FROM character_blocks WHERE charId=? AND name=?";

    public static BlockListManager getInstance() {
        return SingletonHolder._instance;
    }

    private final Map<Integer, Set<String>> _blocks = new HashMap<Integer, Set<String>>();

    private BlockListManager() {
        Connection con = null;
        try {
            con = L2DatabaseFactory.getInstance().getConnection();

            PreparedStatement statement = con.prepareStatement(SELECT_QUERY);
            ResultSet rset = statement.executeQuery();

            while (rset.next()) {
                Integer objectId = L2Integer.valueOf(rset.getInt("charId"));
                String name = rset.getString("name");

                getBlockList(objectId).add(name);
            }

            rset.close();
            statement.close();
        } catch (SQLException e) {
            _log.warn("", e);
        } finally {
            L2DatabaseFactory.close(con);
        }

        int size = 0;

        for (Set<String> set : _blocks.values())
            size += set.size();

        _log.info("BlockListManager: Loaded " + size + " character block(s).");
    }

    public synchronized Set<String> getBlockList(Integer objectId) {
        Set<String> set = _blocks.get(objectId);

        if (set == null)
            _blocks.put(objectId, set = new LazyFastSet<String>());

        return set;
    }

    public synchronized void insert(L2Player listOwner, L2Player blocked) {
        Connection con = null;
        try {
            con = L2DatabaseFactory.getInstance().getConnection();

            PreparedStatement statement = con.prepareStatement(INSERT_QUERY);
            statement.setInt(1, listOwner.getObjectId());
            statement.setString(2, blocked.getName());

            statement.execute();

            statement.close();
        } catch (SQLException e) {
            _log.warn("", e);
        } finally {
            L2DatabaseFactory.close(con);
        }
    }

    public synchronized void remove(L2Player listOwner, String name) {
        Connection con = null;
        try {
            con = L2DatabaseFactory.getInstance().getConnection();

            PreparedStatement statement = con.prepareStatement(DELETE_QUERY);
            statement.setInt(1, listOwner.getObjectId());
            statement.setString(2, name);

            statement.execute();

            statement.close();
        } catch (SQLException e) {
            _log.warn("", e);
        } finally {
            L2DatabaseFactory.close(con);
        }
    }

    @SuppressWarnings("synthetic-access")
    private static class SingletonHolder {
        protected static final BlockListManager _instance = new BlockListManager();
    }
}