Java tutorial
/* * 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.datatables; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.Map; import javolution.util.FastMap; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import com.l2jfree.Config; import com.l2jfree.L2DatabaseFactory; import com.l2jfree.gameserver.ThreadPoolManager; import com.l2jfree.gameserver.gameobjects.L2Player; import com.l2jfree.gameserver.idfactory.IdFactory; import com.l2jfree.gameserver.instancemanager.CastleManager; import com.l2jfree.gameserver.instancemanager.FortManager; import com.l2jfree.gameserver.instancemanager.FortSiegeManager; import com.l2jfree.gameserver.model.clan.L2Clan; import com.l2jfree.gameserver.model.clan.L2ClanMember; import com.l2jfree.gameserver.model.entity.Castle; import com.l2jfree.gameserver.model.entity.Fort; import com.l2jfree.gameserver.model.entity.FortSiege; import com.l2jfree.gameserver.network.SystemMessageId; import com.l2jfree.gameserver.network.packets.server.PledgeShowInfoUpdate; import com.l2jfree.gameserver.network.packets.server.PledgeShowMemberListAll; import com.l2jfree.gameserver.network.packets.server.PledgeShowMemberListUpdate; import com.l2jfree.gameserver.network.packets.server.SystemMessage; import com.l2jfree.gameserver.network.packets.server.UserInfo; public class ClanTable { private static final Log _log = LogFactory.getLog(ClanTable.class); private final Map<Integer, L2Clan> _clans; public static ClanTable getInstance() { return SingletonHolder._instance; } public L2Clan[] getClans() { return _clans.values().toArray(new L2Clan[_clans.size()]); } private ClanTable() { _clans = new FastMap<Integer, L2Clan>(); L2Clan clan; Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(con); PreparedStatement statement = con.prepareStatement("SELECT clan_id FROM clan_data"); ResultSet result = statement.executeQuery(); // Count the clans int clanCount = 0; while (result.next()) { final int clanId = result.getInt("clan_id"); _clans.put(clanId, new L2Clan(clanId)); clan = getClan(clanId); if (clan.getDissolvingExpiryTime() != 0) { scheduleRemoveClan(clan.getClanId()); } clanCount++; } result.close(); statement.close(); _log.info("ClanTable: restored " + clanCount + " clans from the database."); } catch (Exception e) { _log.error("data error on ClanTable:", e); } finally { L2DatabaseFactory.close(con); } restorewars(); } /** * @param clanId * @return */ public L2Clan getClan(int clanId) { L2Clan clan = _clans.get(clanId); return clan; } public L2Clan getClanByName(String clanName) { for (L2Clan clan : getClans()) { if (clan.getName().equalsIgnoreCase(clanName)) { return clan; } } return null; } /** * Creates a new clan and store clan info to database * * @param player * @return NULL if clan with same name already exists */ public L2Clan createClan(L2Player player, String clanName) { if (null == player) return null; if (_log.isDebugEnabled()) _log.info(player.getObjectId() + "(" + player.getName() + ") requested a clan creation."); if (10 > player.getLevel()) { player.sendPacket(SystemMessageId.YOU_DO_NOT_MEET_CRITERIA_IN_ORDER_TO_CREATE_A_CLAN); return null; } if (0 != player.getClanId()) { player.sendPacket(SystemMessageId.FAILED_TO_CREATE_CLAN); return null; } if (System.currentTimeMillis() < player.getClanCreateExpiryTime()) { player.sendPacket(SystemMessageId.YOU_MUST_WAIT_XX_DAYS_BEFORE_CREATING_A_NEW_CLAN); return null; } if (clanName.length() < 3 || clanName.length() > 16) { player.sendPacket(SystemMessageId.CLAN_NAME_TOO_LONG); return null; } if (!Config.CLAN_ALLY_NAME_PATTERN.matcher(clanName).matches()) { player.sendPacket(SystemMessageId.CLAN_NAME_INCORRECT); return null; } if (null != getClanByName(clanName)) { // clan name is already taken SystemMessage sm = new SystemMessage(SystemMessageId.S1_ALREADY_EXISTS); sm.addString(clanName); player.sendPacket(sm); return null; } L2Clan clan = new L2Clan(IdFactory.getInstance().getNextId(), clanName); L2ClanMember leader = new L2ClanMember(clan, player.getName(), player.getLevel(), player.getClassId().getId(), player.getObjectId(), player.getSubPledgeType(), player.getPledgeRank(), player.getTitle(), player.getAppearance().getSex() ? 1 : 0, player.getRace().ordinal()); clan.setLeader(leader); leader.setPlayerInstance(player); clan.store(); player.setClan(clan); player.setPledgeClass(L2ClanMember.getCurrentPledgeClass(player)); player.setClanPrivileges(L2Clan.CP_ALL); if (_log.isDebugEnabled()) _log.info("New clan created: " + clan.getClanId() + " " + clan.getName()); _clans.put(clan.getClanId(), clan); //should be update packet only player.sendPacket(new PledgeShowInfoUpdate(clan)); player.sendPacket(new PledgeShowMemberListAll(clan)); player.sendPacket(new UserInfo(player)); player.sendPacket(new PledgeShowMemberListUpdate(player)); player.sendPacket(SystemMessageId.CLAN_CREATED); return clan; } public synchronized void destroyClan(int clanId) { _log.info("destroy clan with id:" + clanId); L2Clan clan = getClan(clanId); if (clan == null) { return; } clan.broadcastToOnlineMembers(SystemMessageId.CLAN_HAS_DISPERSED.getSystemMessage()); int castleId = clan.getHasCastle(); if (castleId == 0) { for (Castle castle : CastleManager.getInstance().getCastles().values()) { castle.getSiege().removeSiegeClan(clanId); } } int fortId = clan.getHasFort(); if (fortId == 0) { for (FortSiege siege : FortSiegeManager.getInstance().getSieges()) { siege.removeSiegeClan(clanId); } } L2ClanMember leaderMember = clan.getLeader(); if (leaderMember == null) clan.getWarehouse().destroyAllItems("ClanRemove", null, null); else clan.getWarehouse().destroyAllItems("ClanRemove", clan.getLeader().getPlayerInstance(), null); for (L2ClanMember member : clan.getMembers()) { clan.removeClanMember(member.getObjectId(), 0); } _clans.remove(clanId); IdFactory.getInstance().releaseId(clanId); Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(con); PreparedStatement statement = con.prepareStatement("DELETE FROM clan_data WHERE clan_id=?"); statement.setInt(1, clanId); statement.execute(); statement.close(); statement = con.prepareStatement("DELETE FROM clan_privs WHERE clan_id=?"); statement.setInt(1, clanId); statement.execute(); statement.close(); statement = con.prepareStatement("DELETE FROM clan_skills WHERE clan_id=?"); statement.setInt(1, clanId); statement.execute(); statement.close(); statement = con.prepareStatement("DELETE FROM clan_subpledges WHERE clan_id=?"); statement.setInt(1, clanId); statement.execute(); statement.close(); statement = con.prepareStatement("DELETE FROM clan_wars WHERE clan1=? OR clan2=?"); statement.setInt(1, clanId); statement.setInt(2, clanId); statement.execute(); statement.close(); statement = con.prepareStatement("DELETE FROM clan_notices WHERE clanID=?"); statement.setInt(1, clanId); statement.execute(); statement.close(); if (castleId != 0) { statement = con.prepareStatement("UPDATE castle SET taxPercent = 0 WHERE id = ?"); statement.setInt(1, castleId); statement.execute(); statement.close(); } if (fortId != 0) { Fort fort = FortManager.getInstance().getFortById(fortId); if (fort != null) { L2Clan owner = fort.getOwnerClan(); if (clan == owner) fort.removeOwner(true); } } if (_log.isDebugEnabled()) _log.info("clan removed in db: " + clanId); } catch (Exception e) { _log.error("error while removing clan in db ", e); } finally { L2DatabaseFactory.close(con); } } public void scheduleRemoveClan(final int clanId) { ThreadPoolManager.getInstance().scheduleGeneral(new Runnable() { @Override public void run() { if (getClan(clanId) == null) { return; } if (getClan(clanId).getDissolvingExpiryTime() != 0) { destroyClan(clanId); } } }, Math.max(getClan(clanId).getDissolvingExpiryTime() - System.currentTimeMillis(), 300000)); } public boolean isAllyExists(String allyName) { for (L2Clan clan : getClans()) { if (clan.getAllyName() != null && clan.getAllyName().equalsIgnoreCase(allyName)) { return true; } } return false; } public void storeclanswars(int clanId1, int clanId2) { L2Clan clan1 = ClanTable.getInstance().getClan(clanId1); L2Clan clan2 = ClanTable.getInstance().getClan(clanId2); clan1.setEnemyClan(clan2); clan2.setAttackerClan(clan1); clan1.broadcastClanStatus(); clan2.broadcastClanStatus(); Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(con); PreparedStatement statement; statement = con.prepareStatement( "REPLACE INTO clan_wars (clan1, clan2, wantspeace1, wantspeace2) VALUES(?,?,?,?)"); statement.setInt(1, clanId1); statement.setInt(2, clanId2); statement.setInt(3, 0); statement.setInt(4, 0); statement.execute(); statement.close(); } catch (Exception e) { _log.error("could not store clans wars data:", e); } finally { L2DatabaseFactory.close(con); } SystemMessage msg = new SystemMessage(SystemMessageId.CLAN_WAR_DECLARED_AGAINST_S1_IF_KILLED_LOSE_LOW_EXP); msg.addString(clan2.getName()); clan1.broadcastToOnlineMembers(msg); msg = new SystemMessage(SystemMessageId.CLAN_S1_DECLARED_WAR); msg.addString(clan1.getName()); clan2.broadcastToOnlineMembers(msg); } public void deleteclanswars(int clanId1, int clanId2) { L2Clan clan1 = ClanTable.getInstance().getClan(clanId1); L2Clan clan2 = ClanTable.getInstance().getClan(clanId2); clan1.deleteEnemyClan(clan2); clan2.deleteEnemyClan(clan1); clan1.broadcastClanStatus(); clan2.broadcastClanStatus(); Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(con); PreparedStatement statement; statement = con.prepareStatement("DELETE FROM clan_wars WHERE clan1=? AND clan2=?"); statement.setInt(1, clanId1); statement.setInt(2, clanId2); statement.execute(); statement.close(); } catch (Exception e) { _log.error("could not restore clans wars data:", e); } finally { L2DatabaseFactory.close(con); } SystemMessage msg = new SystemMessage(SystemMessageId.WAR_AGAINST_S1_HAS_STOPPED); msg.addString(clan2.getName()); clan1.broadcastToOnlineMembers(msg); msg = new SystemMessage(SystemMessageId.CLAN_S1_HAS_DECIDED_TO_STOP); msg.addString(clan1.getName()); clan2.broadcastToOnlineMembers(msg); } public void checkSurrender(L2Clan clan1, L2Clan clan2) { int count = 0; for (L2ClanMember player : clan1.getMembers()) { if (player != null && player.getPlayerInstance().getWantsPeace() == 1) count++; } if (count == clan1.getMembers().length - 1) { clan1.deleteEnemyClan(clan2); clan2.deleteEnemyClan(clan1); deleteclanswars(clan1.getClanId(), clan2.getClanId()); } } private void restorewars() { Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(con); PreparedStatement statement; statement = con.prepareStatement("SELECT clan1, clan2, wantspeace1, wantspeace2 FROM clan_wars"); ResultSet rset = statement.executeQuery(); while (rset.next()) { getClan(rset.getInt("clan1")).setEnemyClan(rset.getInt("clan2")); getClan(rset.getInt("clan2")).setAttackerClan(rset.getInt("clan1")); } statement.close(); } catch (Exception e) { _log.error("could not restore clan wars data:", e); } finally { L2DatabaseFactory.close(con); } } @SuppressWarnings("synthetic-access") private static class SingletonHolder { protected static final ClanTable _instance = new ClanTable(); } }