/* * 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 . */ package com.l2jserver.gameserver.model; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.Collection; import java.util.List; import java.util.Map; import java.util.logging.Level; import java.util.logging.Logger; import javolution.util.FastList; import javolution.util.FastMap; import com.l2jserver.Config; import com.l2jserver.L2DatabaseFactory; import com.l2jserver.gameserver.cache.CrestCache; import com.l2jserver.gameserver.communitybbs.BB.Forum; import com.l2jserver.gameserver.communitybbs.Manager.ForumsBBSManager; import com.l2jserver.gameserver.datatables.ClanTable; import com.l2jserver.gameserver.datatables.SkillTable; import com.l2jserver.gameserver.instancemanager.CastleManager; import com.l2jserver.gameserver.instancemanager.FortManager; import com.l2jserver.gameserver.instancemanager.SiegeManager; import com.l2jserver.gameserver.instancemanager.TerritoryWarManager; import com.l2jserver.gameserver.instancemanager.TerritoryWarManager.Territory; import com.l2jserver.gameserver.model.actor.L2Character; import com.l2jserver.gameserver.model.actor.instance.L2PcInstance; import com.l2jserver.gameserver.model.itemcontainer.ItemContainer; import com.l2jserver.gameserver.model.skills.L2Skill; import com.l2jserver.gameserver.network.SystemMessageId; import com.l2jserver.gameserver.network.communityserver.CommunityServerThread; import com.l2jserver.gameserver.network.communityserver.writepackets.WorldInfo; import com.l2jserver.gameserver.network.serverpackets.CreatureSay; import com.l2jserver.gameserver.network.serverpackets.ExBrExtraUserInfo; import com.l2jserver.gameserver.network.serverpackets.ExSubPledgeSkillAdd; import com.l2jserver.gameserver.network.serverpackets.ItemList; import com.l2jserver.gameserver.network.serverpackets.L2GameServerPacket; import com.l2jserver.gameserver.network.serverpackets.PledgeReceiveSubPledgeCreated; import com.l2jserver.gameserver.network.serverpackets.PledgeShowInfoUpdate; import com.l2jserver.gameserver.network.serverpackets.PledgeShowMemberListAll; import com.l2jserver.gameserver.network.serverpackets.PledgeShowMemberListDeleteAll; import com.l2jserver.gameserver.network.serverpackets.PledgeShowMemberListUpdate; import com.l2jserver.gameserver.network.serverpackets.PledgeSkillList; import com.l2jserver.gameserver.network.serverpackets.PledgeSkillList.SubPledgeSkill; import com.l2jserver.gameserver.network.serverpackets.PledgeSkillListAdd; import com.l2jserver.gameserver.network.serverpackets.SkillCoolTime; import com.l2jserver.gameserver.network.serverpackets.StatusUpdate; import com.l2jserver.gameserver.network.serverpackets.SystemMessage; import com.l2jserver.gameserver.network.serverpackets.UserInfo; import com.l2jserver.gameserver.scripting.scriptengine.listeners.clan.ClanCreationListener; import com.l2jserver.gameserver.scripting.scriptengine.listeners.clan.ClanMembershipListener; import com.l2jserver.gameserver.scripting.scriptengine.listeners.clan.ClanWarListener; import com.l2jserver.gameserver.util.Util; /** * This class ... * * @version $Revision: 1.7.2.4.2.7 $ $Date: 2005/04/06 16:13:41 $ */ public class L2Clan { private static final Logger _log = Logger.getLogger(L2Clan.class.getName()); private static FastList clanCreationListeners = new FastList().shared(); private static FastList clanMembershipListeners = new FastList().shared(); private static FastList clanWarListeners = new FastList().shared(); private String _name; private int _clanId; private L2ClanMember _leader; private final Map _members = new FastMap(); private String _allyName; private int _allyId; private int _level; private int _castleId; private int _fortId; private int _hideoutId; private int _hiredGuards; private int _crestId; private int _crestLargeId; private int _allyCrestId; private int _auctionBiddedAt = 0; private long _allyPenaltyExpiryTime; private int _allyPenaltyType; private long _charPenaltyExpiryTime; private long _dissolvingExpiryTime; // Ally Penalty Types /** Clan leaved ally */ public static final int PENALTY_TYPE_CLAN_LEAVED = 1; /** Clan was dismissed from ally */ public static final int PENALTY_TYPE_CLAN_DISMISSED = 2; /** Leader clan dismiss clan from ally */ public static final int PENALTY_TYPE_DISMISS_CLAN = 3; /** Leader clan dissolve ally */ public static final int PENALTY_TYPE_DISSOLVE_ALLY = 4; private final ItemContainer _warehouse = new ClanWarehouse(this); private final List _atWarWith = new FastList(); private final List _atWarAttackers = new FastList(); private Forum _forum; // Clan Privileges /** No privilege to manage any clan activity */ public static final int CP_NOTHING = 0; /** Privilege to join clan */ public static final int CP_CL_JOIN_CLAN = 2; /** Privilege to give a title */ public static final int CP_CL_GIVE_TITLE = 4; /** Privilege to view warehouse content */ public static final int CP_CL_VIEW_WAREHOUSE = 8; /** Privilege to manage clan ranks */ public static final int CP_CL_MANAGE_RANKS = 16; public static final int CP_CL_PLEDGE_WAR = 32; public static final int CP_CL_DISMISS = 64; /** Privilege to register clan crest */ public static final int CP_CL_REGISTER_CREST = 128; public static final int CP_CL_APPRENTICE = 256; public static final int CP_CL_TROOPS_FAME = 512; public static final int CP_CL_SUMMON_AIRSHIP = 1024; /** Privilege to open a door */ public static final int CP_CH_OPEN_DOOR = 2048; public static final int CP_CH_OTHER_RIGHTS = 4096; public static final int CP_CH_AUCTION = 8192; public static final int CP_CH_DISMISS = 16384; public static final int CP_CH_SET_FUNCTIONS = 32768; public static final int CP_CS_OPEN_DOOR = 65536; public static final int CP_CS_MANOR_ADMIN = 131072; public static final int CP_CS_MANAGE_SIEGE = 262144; public static final int CP_CS_USE_FUNCTIONS = 524288; public static final int CP_CS_DISMISS = 1048576; public static final int CP_CS_TAXES = 2097152; public static final int CP_CS_MERCENARIES = 4194304; public static final int CP_CS_SET_FUNCTIONS = 8388608; /** Privilege to manage all clan activity */ public static final int CP_ALL = 16777214; // Sub-unit types /** Clan subunit type of Academy */ public static final int SUBUNIT_ACADEMY = -1; /** Clan subunit type of Royal Guard A */ public static final int SUBUNIT_ROYAL1 = 100; /** Clan subunit type of Royal Guard B */ public static final int SUBUNIT_ROYAL2 = 200; /** Clan subunit type of Order of Knights A-1 */ public static final int SUBUNIT_KNIGHT1 = 1001; /** Clan subunit type of Order of Knights A-2 */ public static final int SUBUNIT_KNIGHT2 = 1002; /** Clan subunit type of Order of Knights B-1 */ public static final int SUBUNIT_KNIGHT3 = 2001; /** Clan subunit type of Order of Knights B-2 */ public static final int SUBUNIT_KNIGHT4 = 2002; /** FastMap(Integer, L2Skill) containing all skills of the L2Clan */ private final Map _skills = new FastMap(); private final Map _privs = new FastMap(); private final Map _subPledges = new FastMap(); private final Map _subPledgeSkills = new FastMap(); private int _reputationScore = 0; private int _rank = 0; private String _notice; private boolean _noticeEnabled = false; private static final int MAX_NOTICE_LENGTH = 8192; /** * Called if a clan is referenced only by id. * In this case all other data needs to be fetched from db * * @param clanId A valid clan Id to create and restore */ public L2Clan(int clanId) { _clanId = clanId; initializePrivs(); restore(); getWarehouse().restore(); } /** * Called only if a new clan is created * * @param clanId A valid clan Id to create * @param clanName A valid clan name */ public L2Clan(int clanId, String clanName) { _clanId = clanId; _name = clanName; initializePrivs(); for (ClanCreationListener listener : clanCreationListeners) { listener.onClanCreate(this); } } /** * @return Returns the clanId. */ public int getClanId() { return _clanId; } /** * @param clanId The clanId to set. */ public void setClanId(int clanId) { _clanId = clanId; } /** * @return Returns the leaderId. */ public int getLeaderId() { return (_leader != null ? _leader.getObjectId() : 0); } /** * @return L2ClanMember of clan leader. */ public L2ClanMember getLeader() { return _leader; } /** * @param leader the leader to set. */ public void setLeader(L2ClanMember leader) { _leader = leader; _members.put(leader.getObjectId(), leader); } public void setNewLeader(L2ClanMember member) { if (!getLeader().isOnline()) { return; } if (member == null) { return; } if (!member.isOnline()) { return; } L2PcInstance exLeader = getLeader().getPlayerInstance(); L2PcInstance newLeader = member.getPlayerInstance(); for (ClanMembershipListener listener : clanMembershipListeners) { if (!listener.onLeaderChange(this, newLeader, exLeader)) { return; } } SiegeManager.getInstance().removeSiegeSkills(exLeader); exLeader.setClan(this); exLeader.setClanPrivileges(L2Clan.CP_NOTHING); exLeader.broadcastUserInfo(); setLeader(member); updateClanInDB(); exLeader.setPledgeClass(exLeader.getClan().getClanMember(exLeader.getObjectId()).calculatePledgeClass(exLeader)); exLeader.broadcastUserInfo(); exLeader.checkItemRestriction(); newLeader.setClan(this); newLeader.setPledgeClass(member.calculatePledgeClass(newLeader)); newLeader.setClanPrivileges(L2Clan.CP_ALL); if (getLevel() >= SiegeManager.getInstance().getSiegeClanMinLevel()) { SiegeManager.getInstance().addSiegeSkills(newLeader); // Transferring siege skills TimeStamps from old leader to new leader to prevent unlimited headquarters if (!exLeader.getSkillReuseTimeStamps().isEmpty()) { TimeStamp t; for (L2Skill sk : SkillTable.getInstance().getSiegeSkills(newLeader.isNoble(), getCastleId() > 0)) { if (exLeader.hasSkillReuse(sk.getReuseHashCode())) { t = exLeader.getSkillReuseTimeStamp(sk.getReuseHashCode()); newLeader.addTimeStamp(sk, t.getReuse(), t.getStamp()); } } newLeader.sendPacket(new SkillCoolTime(newLeader)); } } newLeader.broadcastUserInfo(); broadcastClanStatus(); SystemMessage sm = SystemMessage.getSystemMessage(SystemMessageId.CLAN_LEADER_PRIVILEGES_HAVE_BEEN_TRANSFERRED_TO_C1); sm.addString(newLeader.getName()); broadcastToOnlineMembers(sm); sm = null; CommunityServerThread.getInstance().sendPacket(new WorldInfo(null, this, WorldInfo.TYPE_UPDATE_CLAN_DATA)); } /** * @return the clan leader's name. */ public String getLeaderName() { if (_leader == null) { _log.warning(L2Clan.class.getName() + ": Clan " + getName() + " without clan leader!"); return ""; } return _leader.getName(); } /** * @return the clan name. */ public String getName() { return _name; } /** * @param name The name to set. */ public void setName(String name) { _name = name; } /** * Adds a clan member to the clan. * @param member the clan member. */ private void addClanMember(L2ClanMember member) { _members.put(member.getObjectId(), member); } /** * Adds a clan member to the clan.
* Using a different constructor, to make it easier to read. * @param player the clan member */ public void addClanMember(L2PcInstance player) { for (ClanMembershipListener listener : clanMembershipListeners) { if (!listener.onJoin(player, this)) { return; } } final L2ClanMember member = new L2ClanMember(this, player); // store in memory addClanMember(member); member.setPlayerInstance(player); player.setClan(this); player.setPledgeClass(member.calculatePledgeClass(player)); player.sendPacket(new PledgeShowMemberListUpdate(player)); player.sendPacket(new PledgeSkillList(this)); addSkillEffects(player); // notify CB server about the change CommunityServerThread.getInstance().sendPacket(new WorldInfo(null, this, WorldInfo.TYPE_UPDATE_CLAN_DATA)); } /** * Updates player status in clan. * @param player the player to be updated. */ public void updateClanMember(L2PcInstance player) { final L2ClanMember member = new L2ClanMember(player); if (player.isClanLeader()) setLeader(member); addClanMember(member); // notify CB server about the change CommunityServerThread.getInstance().sendPacket(new WorldInfo(null, this, WorldInfo.TYPE_UPDATE_CLAN_DATA)); } /** * @param name the name of the required clan member. * @return the clan member for a given name. */ public L2ClanMember getClanMember(String name) { for (L2ClanMember temp : _members.values()) { if (temp.getName().equals(name)) return temp; } return null; } /** * @param objectID the required clan member object Id. * @return the clan member for a given {@code objectID}. */ public L2ClanMember getClanMember(int objectID) { return _members.get(objectID); } /** * @param objectId the object Id of the member that will be removed. * @param clanJoinExpiryTime time penalty to join a clan. */ public void removeClanMember(int objectId, long clanJoinExpiryTime) { for (ClanMembershipListener listener : clanMembershipListeners) { if (!listener.onLeave(objectId, this)) { return; } } final L2ClanMember exMember = _members.remove(objectId); if (exMember == null) { _log.warning("Member Object ID: " + objectId + " not found in clan while trying to remove"); return; } final int leadssubpledge = getLeaderSubPledge(objectId); if (leadssubpledge != 0) { // Sub-unit leader withdraws, position becomes vacant and leader // should appoint new via NPC getSubPledge(leadssubpledge).setLeaderId(0); updateSubPledgeInDB(leadssubpledge); } if (exMember.getApprentice() != 0) { final L2ClanMember apprentice = getClanMember(exMember.getApprentice()); if (apprentice != null) { if (apprentice.getPlayerInstance() != null) apprentice.getPlayerInstance().setSponsor(0); else apprentice.initApprenticeAndSponsor(0, 0); apprentice.saveApprenticeAndSponsor(0, 0); } } if (exMember.getSponsor() != 0) { final L2ClanMember sponsor = getClanMember(exMember.getSponsor()); if (sponsor != null) { if (sponsor.getPlayerInstance() != null) sponsor.getPlayerInstance().setApprentice(0); else sponsor.initApprenticeAndSponsor(0, 0); sponsor.saveApprenticeAndSponsor(0, 0); } } exMember.saveApprenticeAndSponsor(0, 0); if (Config.REMOVE_CASTLE_CIRCLETS) { CastleManager.getInstance().removeCirclet(exMember, getCastleId()); } if (exMember.isOnline()) { L2PcInstance player = exMember.getPlayerInstance(); if (!player.isNoble()) { player.setTitle(""); } player.setApprentice(0); player.setSponsor(0); if (player.isClanLeader()) { SiegeManager.getInstance().removeSiegeSkills(player); player.setClanCreateExpiryTime(System.currentTimeMillis() + Config.ALT_CLAN_CREATE_DAYS * 86400000L); //24*60*60*1000 = 86400000 } // remove Clan skills from Player removeSkillEffects(player); // remove Residential skills if (player.getClan().getCastleId() > 0) CastleManager.getInstance().getCastleByOwner(player.getClan()).removeResidentialSkills(player); if (player.getClan().getFortId() > 0) FortManager.getInstance().getFortByOwner(player.getClan()).removeResidentialSkills(player); player.sendSkillList(); player.setClan(null); // players leaving from clan academy have no penalty if (exMember.getPledgeType() != -1) player.setClanJoinExpiryTime(clanJoinExpiryTime); player.setPledgeClass(exMember.calculatePledgeClass(player)); player.broadcastUserInfo(); // disable clan tab player.sendPacket(new PledgeShowMemberListDeleteAll()); } else { removeMemberInDatabase(exMember, clanJoinExpiryTime, getLeaderId() == objectId ? System.currentTimeMillis() + Config.ALT_CLAN_CREATE_DAYS * 86400000L : 0); } // notify CB server about the change CommunityServerThread.getInstance().sendPacket(new WorldInfo(null, this, WorldInfo.TYPE_UPDATE_CLAN_DATA)); } public L2ClanMember[] getMembers() { return _members.values().toArray(new L2ClanMember[_members.size()]); } public int getMembersCount() { return _members.size(); } public int getSubPledgeMembersCount(int subpl) { int result = 0; for (L2ClanMember temp : _members.values()) { if (temp.getPledgeType() == subpl) result++; } return result; } /** * @param pledgeType the Id of the pledge type. * @return the maximum number of members allowed for a given {@code pledgeType}. */ public int getMaxNrOfMembers(int pledgeType) { int limit = 0; switch (pledgeType) { case 0: switch (getLevel()) { case 3: limit = 30; break; case 2: limit = 20; break; case 1: limit = 15; break; case 0: limit = 10; break; default: limit = 40; break; } break; case -1: limit = 20; break; case 100: case 200: switch (getLevel()) { case 11: limit = 30; break; default: limit = 20; break; } break; case 1001: case 1002: case 2001: case 2002: switch (getLevel()) { case 9: case 10: case 11: limit = 25; break; default: limit = 10; break; } break; default: break; } return limit; } /** * @param exclude the object Id to exclude from list. * @return all online members excluding the one with object id {code exclude}. */ public FastList getOnlineMembers(int exclude) { final FastList onlineMembers = new FastList(); for (L2ClanMember temp : _members.values()) { if ((temp != null) && temp.isOnline() && (temp.getObjectId() != exclude)) { onlineMembers.add(temp.getPlayerInstance()); } } return onlineMembers; } /** * @return the online clan member count. */ public int getOnlineMembersCount() { int count = 0; for (L2ClanMember temp : _members.values()) { if ((temp == null) || !temp.isOnline()) { continue; } count++; } return count; } /** * @return the alliance Id. */ public int getAllyId() { return _allyId; } /** * @return the alliance name. */ public String getAllyName() { return _allyName; } /** * @param allyCrestId the alliance crest Id to be set. */ public void setAllyCrestId(int allyCrestId) { _allyCrestId = allyCrestId; } /** * @return the alliance crest Id. */ public int getAllyCrestId() { return _allyCrestId; } /** * @return the clan level. */ public int getLevel() { return _level; } /** * Sets the clan level and updates the clan forum if it's needed. * @param level the clan level to be set. */ public void setLevel(int level) { _level = level; if ((_level >= 2) && (_forum == null) && (Config.COMMUNITY_TYPE > 0)) { final Forum forum = ForumsBBSManager.getInstance().getForumByName("ClanRoot"); if (forum != null) { _forum = forum.getChildByName(_name); if (_forum == null) { _forum = ForumsBBSManager.getInstance().createNewForum(_name, ForumsBBSManager.getInstance().getForumByName("ClanRoot"), Forum.CLAN, Forum.CLANMEMBERONLY, getClanId()); } } } } /** * @return the castle Id for this clan if owns a castle, zero otherwise. */ public int getCastleId() { return _castleId; } /** * @return the fort Id for this clan if owns a fort, zero otherwise. */ public int getFortId() { return _fortId; } /** * @return the hideout Id for this clan if owns a hideout, zero otherwise. */ public int getHideoutId() { return _hideoutId; } /** * @param crestId the Id of the clan crest to be set. */ public void setCrestId(int crestId) { _crestId = crestId; } /** * @return Returns the clanCrestId. */ public int getCrestId() { return _crestId; } /** * @param crestLargeId The id of pledge LargeCrest. */ public void setCrestLargeId(int crestLargeId) { _crestLargeId = crestLargeId; } /** * @return Returns the clan CrestLargeId */ public int getCrestLargeId() { return _crestLargeId; } /** * @param allyId The allyId to set. */ public void setAllyId(int allyId) { _allyId = allyId; } /** * @param allyName The allyName to set. */ public void setAllyName(String allyName) { _allyName = allyName; } /** * @param castleId the castle Id to set. */ public void setCastleId(int castleId) { _castleId = castleId; } /** * @param fortId the fort Id to set. */ public void setFortId(int fortId) { _fortId = fortId; } /** * @param hideoutId the hideout Id to set. */ public void setHideoutId(int hideoutId) { _hideoutId = hideoutId; } /** * @param id the Id of the player to be verified. * @return {code true} if the player belongs to the clan. */ public boolean isMember(int id) { return (id == 0 ? false : _members.containsKey(id)); } /** * Store in database current clan's reputation. */ public void updateClanScoreInDB() { Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(); final PreparedStatement statement = con.prepareStatement("UPDATE clan_data SET reputation_score=? WHERE clan_id=?"); statement.setInt(1, getReputationScore()); statement.setInt(2, getClanId()); statement.execute(); statement.close(); } catch (Exception e) { _log.log(Level.WARNING, "Exception on updateClanScoreInDb(): " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } } /** * Updates in database clan information: *
    *
  • Clan leader Id
    • *
  • Alliance Id
    • *
  • Alliance name
    • *
  • Clan's reputation
    • *
  • Alliance's penalty expiration time
    • *
  • Alliance's penalty type
    • *
  • Character's penalty expiration time
    • *
  • Dissolving expiration time
    • *
  • Clan's id
    • *
*/ public void updateClanInDB() { Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(); final PreparedStatement statement = con.prepareStatement("UPDATE clan_data SET leader_id=?,ally_id=?,ally_name=?,reputation_score=?,ally_penalty_expiry_time=?,ally_penalty_type=?,char_penalty_expiry_time=?,dissolving_expiry_time=? WHERE clan_id=?"); statement.setInt(1, getLeaderId()); statement.setInt(2, getAllyId()); statement.setString(3, getAllyName()); statement.setInt(4, getReputationScore()); statement.setLong(5, getAllyPenaltyExpiryTime()); statement.setInt(6, getAllyPenaltyType()); statement.setLong(7, getCharPenaltyExpiryTime()); statement.setLong(8, getDissolvingExpiryTime()); statement.setInt(9, getClanId()); statement.execute(); statement.close(); if (Config.DEBUG) _log.fine("New clan leader saved in db: " + getClanId()); } catch (Exception e) { _log.log(Level.SEVERE, "Error saving clan: " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } } /** * Stores in database clan information: *
    *
  • Clan Id
    • *
  • Clan name
    • *
  • Clan level
    • *
  • Has castle
    • *
  • Alliance Id
    • *
  • Alliance name
    • *
  • Clan leader Id
    • *
  • Clan crest Id
    • *
  • Clan large crest Id
    • *
  • Allaince crest Id
    • *
*/ public void store() { Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(); final PreparedStatement statement = con.prepareStatement("INSERT INTO clan_data (clan_id,clan_name,clan_level,hasCastle,ally_id,ally_name,leader_id,crest_id,crest_large_id,ally_crest_id) values (?,?,?,?,?,?,?,?,?,?)"); statement.setInt(1, getClanId()); statement.setString(2, getName()); statement.setInt(3, getLevel()); statement.setInt(4, getCastleId()); statement.setInt(5, getAllyId()); statement.setString(6, getAllyName()); statement.setInt(7, getLeaderId()); statement.setInt(8, getCrestId()); statement.setInt(9, getCrestLargeId()); statement.setInt(10, getAllyCrestId()); statement.execute(); statement.close(); if (Config.DEBUG) _log.fine("New clan saved in db: " + getClanId()); } catch (Exception e) { _log.log(Level.SEVERE, "Error saving new clan: " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } } /** * @param member the clan member to be removed. * @param clanJoinExpiryTime * @param clanCreateExpiryTime */ private void removeMemberInDatabase(L2ClanMember member, long clanJoinExpiryTime, long clanCreateExpiryTime) { Connection con = null; PreparedStatement statement = null; try { con = L2DatabaseFactory.getInstance().getConnection(); statement = con.prepareStatement("UPDATE characters SET clanid=0, title=?, clan_join_expiry_time=?, clan_create_expiry_time=?, clan_privs=0, wantspeace=0, subpledge=0, lvl_joined_academy=0, apprentice=0, sponsor=0 WHERE charId=?"); statement.setString(1, ""); statement.setLong(2, clanJoinExpiryTime); statement.setLong(3, clanCreateExpiryTime); statement.setInt(4, member.getObjectId()); statement.execute(); statement.close(); if (Config.DEBUG) _log.fine("clan member removed in db: " + getClanId()); statement = con.prepareStatement("UPDATE characters SET apprentice=0 WHERE apprentice=?"); statement.setInt(1, member.getObjectId()); statement.execute(); statement.close(); statement = con.prepareStatement("UPDATE characters SET sponsor=0 WHERE sponsor=?"); statement.setInt(1, member.getObjectId()); statement.execute(); statement.close(); } catch (Exception e) { _log.log(Level.SEVERE, "Error removing clan member: " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } } @SuppressWarnings("unused") private void updateWarsInDB() { Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(); final PreparedStatement statement = con.prepareStatement("UPDATE clan_wars SET wantspeace1=? WHERE clan1=?"); statement.setInt(1, 0); statement.setInt(2, 0); statement.close(); } catch (Exception e) { _log.log(Level.SEVERE, "Error updating clan wars data: " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } } private void restore() { //restorewars(); Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(); PreparedStatement statement = con.prepareStatement("SELECT clan_name,clan_level,hasCastle,ally_id,ally_name,leader_id,crest_id,crest_large_id,ally_crest_id,reputation_score,auction_bid_at,ally_penalty_expiry_time,ally_penalty_type,char_penalty_expiry_time,dissolving_expiry_time FROM clan_data where clan_id=?"); statement.setInt(1, getClanId()); final ResultSet clanData = statement.executeQuery(); if (clanData.next()) { setName(clanData.getString("clan_name")); setLevel(clanData.getInt("clan_level")); setCastleId(clanData.getInt("hasCastle")); setAllyId(clanData.getInt("ally_id")); setAllyName(clanData.getString("ally_name")); setAllyPenaltyExpiryTime(clanData.getLong("ally_penalty_expiry_time"), clanData.getInt("ally_penalty_type")); if (getAllyPenaltyExpiryTime() < System.currentTimeMillis()) { setAllyPenaltyExpiryTime(0, 0); } setCharPenaltyExpiryTime(clanData.getLong("char_penalty_expiry_time")); if (getCharPenaltyExpiryTime() + Config.ALT_CLAN_JOIN_DAYS * 86400000L < System.currentTimeMillis()) //24*60*60*1000 = 86400000 { setCharPenaltyExpiryTime(0); } setDissolvingExpiryTime(clanData.getLong("dissolving_expiry_time")); setCrestId(clanData.getInt("crest_id")); setCrestLargeId(clanData.getInt("crest_large_id")); setAllyCrestId(clanData.getInt("ally_crest_id")); setReputationScore(clanData.getInt("reputation_score"), false); setAuctionBiddedAt(clanData.getInt("auction_bid_at"), false); final int leaderId = (clanData.getInt("leader_id")); statement.clearParameters(); statement = con.prepareStatement("SELECT char_name,level,classid,charId,title,power_grade,subpledge,apprentice,sponsor,sex,race FROM characters WHERE clanid=?"); statement.setInt(1, getClanId()); final ResultSet clanMembers = statement.executeQuery(); L2ClanMember member = null; while (clanMembers.next()) { member = new L2ClanMember(this, clanMembers.getString("char_name"), clanMembers.getInt("level"), clanMembers.getInt("classid"), clanMembers.getInt("charId"), clanMembers.getInt("subpledge"), clanMembers.getInt("power_grade"), clanMembers.getString("title"), (clanMembers.getInt("sex") != 0), clanMembers.getInt("race")); if (member.getObjectId() == leaderId) setLeader(member); else addClanMember(member); member.initApprenticeAndSponsor(clanMembers.getInt("apprentice"), clanMembers.getInt("sponsor")); } clanMembers.close(); } clanData.close(); statement.close(); if (Config.DEBUG && getName() != null) _log.info("Restored clan data for \"" + getName() + "\" from database."); restoreSubPledges(); restoreRankPrivs(); restoreSkills(); restoreNotice(); } catch (Exception e) { _log.log(Level.SEVERE, "Error restoring clan data: " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } } private void restoreNotice() { Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(); final PreparedStatement statement = con.prepareStatement("SELECT enabled,notice FROM clan_notices WHERE clan_id=?"); statement.setInt(1, getClanId()); final ResultSet noticeData = statement.executeQuery(); while (noticeData.next()) { _noticeEnabled = noticeData.getBoolean("enabled"); _notice = noticeData.getString("notice"); } noticeData.close(); statement.close(); } catch (Exception e) { _log.log(Level.SEVERE, "Error restoring clan notice: " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } } private void storeNotice(String notice, boolean enabled) { if (notice == null) notice = ""; if (notice.length() > MAX_NOTICE_LENGTH) notice = notice.substring(0, MAX_NOTICE_LENGTH - 1); Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(); final PreparedStatement statement = con.prepareStatement("INSERT INTO clan_notices (clan_id,notice,enabled) values (?,?,?) ON DUPLICATE KEY UPDATE notice=?,enabled=?"); statement.setInt(1, getClanId()); statement.setString(2, notice); if (enabled) statement.setString(3, "true"); else statement.setString(3, "false"); statement.setString(4, notice); if (enabled) statement.setString(5, "true"); else statement.setString(5, "false"); statement.execute(); statement.close(); } catch (Exception e) { _log.log(Level.WARNING, "Error could not store clan notice: " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } _notice = notice; _noticeEnabled = enabled; } public void setNoticeEnabled(boolean enabled) { storeNotice(_notice, enabled); } public void setNotice(String notice) { storeNotice(notice, _noticeEnabled); } public boolean isNoticeEnabled() { return _noticeEnabled; } public String getNotice() { if (_notice == null) return ""; return _notice; } private void restoreSkills() { Connection con = null; try { // Retrieve all skills of this L2PcInstance from the database con = L2DatabaseFactory.getInstance().getConnection(); final PreparedStatement statement = con.prepareStatement("SELECT skill_id,skill_level,sub_pledge_id FROM clan_skills WHERE clan_id=?"); statement.setInt(1, getClanId()); final ResultSet rset = statement.executeQuery(); // Go though the recordset of this SQL query while (rset.next()) { int id = rset.getInt("skill_id"); int level = rset.getInt("skill_level"); // Create a L2Skill object for each record L2Skill skill = SkillTable.getInstance().getInfo(id, level); // Add the L2Skill object to the L2Clan _skills int subType = rset.getInt("sub_pledge_id"); if (subType == -2) _skills.put(skill.getId(), skill); else if (subType == 0) _subPledgeSkills.put(skill.getId(), skill); else { SubPledge subunit = _subPledges.get(subType); if (subunit != null) subunit.addNewSkill(skill); else _log.info("Missing subpledge "+subType+" for clan "+this+", skill skipped."); } } rset.close(); statement.close(); } catch (Exception e) { _log.log(Level.SEVERE, "Error restoring clan skills: " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } } /** * @return all the clan skills. */ public final L2Skill[] getAllSkills() { if (_skills == null) return new L2Skill[0]; return _skills.values().toArray(new L2Skill[_skills.values().size()]); } /** * Used to add a skill to skill list of this L2Clan * @param newSkill * @return */ public L2Skill addSkill(L2Skill newSkill) { L2Skill oldSkill = null; if (newSkill != null) { // Replace oldSkill by newSkill or Add the newSkill oldSkill = _skills.put(newSkill.getId(), newSkill); } return oldSkill; } public L2Skill addNewSkill(L2Skill newSkill) { return addNewSkill(newSkill, -2); } /** * Used to add a new skill to the list, send a packet to all online clan members, update their stats and store it in db * @param newSkill * @param subType * @return */ public L2Skill addNewSkill(L2Skill newSkill, int subType) { L2Skill oldSkill = null; Connection con = null; if (newSkill != null) { if (subType == -2) // regular clan skill oldSkill = _skills.put(newSkill.getId(), newSkill); else if (subType == 0) // main clan sub skill oldSkill = _subPledgeSkills.put(newSkill.getId(), newSkill); else { SubPledge subunit = getSubPledge(subType); if (subunit != null) oldSkill = subunit.addNewSkill(newSkill); else { _log.log(Level.WARNING, "Subpledge "+subType +" does not exist for clan "+this); return oldSkill; } } try { con = L2DatabaseFactory.getInstance().getConnection(); PreparedStatement statement; if (oldSkill != null) { statement = con.prepareStatement("UPDATE clan_skills SET skill_level=? WHERE skill_id=? AND clan_id=?"); statement.setInt(1, newSkill.getLevel()); statement.setInt(2, oldSkill.getId()); statement.setInt(3, getClanId()); } else { statement = con.prepareStatement("INSERT INTO clan_skills (clan_id,skill_id,skill_level,skill_name,sub_pledge_id) VALUES (?,?,?,?,?)"); statement.setInt(1, getClanId()); statement.setInt(2, newSkill.getId()); statement.setInt(3, newSkill.getLevel()); statement.setString(4, newSkill.getName()); statement.setInt(5, subType); } statement.execute(); statement.close(); } catch (Exception e) { _log.log(Level.WARNING, "Error could not store clan skills: " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } SystemMessage sm = SystemMessage.getSystemMessage(SystemMessageId.CLAN_SKILL_S1_ADDED); sm.addSkillName(newSkill.getId()); for (L2ClanMember temp : _members.values()) { if (temp != null && temp.getPlayerInstance() != null && temp.isOnline()) { if (subType == -2) { if (newSkill.getMinPledgeClass() <= temp.getPlayerInstance().getPledgeClass()) { temp.getPlayerInstance().addSkill(newSkill, false); // Skill is not saved to player DB temp.getPlayerInstance().sendPacket(new PledgeSkillListAdd(newSkill.getId(), newSkill.getLevel())); temp.getPlayerInstance().sendPacket(sm); temp.getPlayerInstance().sendSkillList(); } } else { if (temp.getPledgeType() == subType) { temp.getPlayerInstance().addSkill(newSkill, false); // Skill is not saved to player DB temp.getPlayerInstance().sendPacket(new ExSubPledgeSkillAdd(subType, newSkill.getId(), newSkill.getLevel())); temp.getPlayerInstance().sendPacket(sm); temp.getPlayerInstance().sendSkillList(); } } } } } return oldSkill; } public void addSkillEffects() { for (L2Skill skill : _skills.values()) { for (L2ClanMember temp : _members.values()) { try { if (temp != null && temp.isOnline()) { if (skill.getMinPledgeClass() <= temp.getPlayerInstance().getPledgeClass()) temp.getPlayerInstance().addSkill(skill, false); // Skill is not saved to player DB } } catch (NullPointerException e) { _log.log(Level.WARNING, e.getMessage(),e); } } } } public void addSkillEffects(L2PcInstance player) { if (player == null || _reputationScore < 0) return; for (L2Skill skill : _skills.values()) { if (skill.getMinPledgeClass() <= player.getPledgeClass()) player.addSkill(skill, false); // Skill is not saved to player DB } if (player.getPledgeType() == 0) { for (L2Skill skill : _subPledgeSkills.values()) player.addSkill(skill, false); // Skill is not saved to player DB } else { SubPledge subunit = getSubPledge(player.getPledgeType()); if (subunit == null) return; for (L2Skill skill : subunit.getSkills()) player.addSkill(skill, false); // Skill is not saved to player DB } } public void removeSkillEffects(L2PcInstance player) { if (player == null) return; for (L2Skill skill : _skills.values()) { player.removeSkill(skill, false); // Skill is not saved to player DB } if (player.getPledgeType() == 0) { for (L2Skill skill : _subPledgeSkills.values()) player.removeSkill(skill, false); // Skill is not saved to player DB } else { SubPledge subunit = getSubPledge(player.getPledgeType()); if (subunit == null) return; for (L2Skill skill : subunit.getSkills()) player.removeSkill(skill, false); // Skill is not saved to player DB } } public void broadcastToOnlineAllyMembers(L2GameServerPacket packet) { for (L2Clan clan : ClanTable.getInstance().getClanAllies(getAllyId())) { clan.broadcastToOnlineMembers(packet); } } public void broadcastToOnlineMembers(L2GameServerPacket packet) { for (L2ClanMember member : _members.values()) { if (member != null && member.isOnline()) member.getPlayerInstance().sendPacket(packet); } } public void broadcastCSToOnlineMembers(CreatureSay packet, L2PcInstance broadcaster) { for (L2ClanMember member : _members.values()) { if (member != null && member.isOnline() && !BlockList.isBlocked(member.getPlayerInstance(), broadcaster)) member.getPlayerInstance().sendPacket(packet); } } public void broadcastToOtherOnlineMembers(L2GameServerPacket packet, L2PcInstance player) { for (L2ClanMember member : _members.values()) { if (member != null && member.isOnline() && member.getPlayerInstance() != player) member.getPlayerInstance().sendPacket(packet); } } @Override public String toString() { return getName()+"["+getClanId()+"]"; } public ItemContainer getWarehouse() { return _warehouse; } public boolean isAtWarWith(Integer id) { if (!_atWarWith.isEmpty()) if (_atWarWith.contains(id)) return true; return false; } public boolean isAtWarWith(L2Clan clan) { if (clan == null) return false; if (!_atWarWith.isEmpty()) if (_atWarWith.contains(clan.getClanId())) return true; return false; } public boolean isAtWarAttacker(Integer id) { if (_atWarAttackers != null && !_atWarAttackers.isEmpty()) if (_atWarAttackers.contains(id)) return true; return false; } public void setEnemyClan(L2Clan clan) { for (ClanWarListener listener : clanWarListeners) { if (!listener.onWarStart(this, clan)) { return; } } Integer id = clan.getClanId(); _atWarWith.add(id); } public void setEnemyClan(Integer clan) { for (ClanWarListener listener : clanWarListeners) { if (!listener.onWarStart(this, ClanTable.getInstance().getClan(clan))) { return; } } _atWarWith.add(clan); } public void setAttackerClan(L2Clan clan) { Integer id = clan.getClanId(); _atWarAttackers.add(id); } public void setAttackerClan(Integer clan) { _atWarAttackers.add(clan); } public void deleteEnemyClan(L2Clan clan) { for (ClanWarListener listener : clanWarListeners) { if (!listener.onWarEnd(this, clan)) { return; } } Integer id = clan.getClanId(); _atWarWith.remove(id); } public void deleteAttackerClan(L2Clan clan) { Integer id = clan.getClanId(); _atWarAttackers.remove(id); } public int getHiredGuards() { return _hiredGuards; } public void incrementHiredGuards() { _hiredGuards++; } public boolean isAtWar() { if (_atWarWith != null && !_atWarWith.isEmpty()) return true; return false; } public List getWarList() { return _atWarWith; } public List getAttackerList() { return _atWarAttackers; } public void broadcastClanStatus() { for (L2PcInstance member : getOnlineMembers(0)) { member.sendPacket(new PledgeShowMemberListDeleteAll()); member.sendPacket(new PledgeShowMemberListAll(this, member)); } } public static class SubPledge { private final int _id; private String _subPledgeName; private int _leaderId; private final Map _subPledgeSkills = new FastMap(); public SubPledge(int id, String name, int leaderId) { _id = id; _subPledgeName = name; _leaderId = leaderId; } public int getId() { return _id; } public String getName() { return _subPledgeName; } public void setName(String name) { _subPledgeName = name; } public int getLeaderId() { return _leaderId; } public void setLeaderId(int leaderId) { _leaderId = leaderId; } public L2Skill addNewSkill(L2Skill skill) { return _subPledgeSkills.put(skill.getId(), skill); } public Collection getSkills() { return _subPledgeSkills.values(); } } public static class RankPrivs { private final int _rankId; private final int _party;// TODO find out what this stuff means and implement it private int _rankPrivs; public RankPrivs(int rank, int party, int privs) { _rankId = rank; _party = party; _rankPrivs = privs; } public int getRank() { return _rankId; } public int getParty() { return _party; } public int getPrivs() { return _rankPrivs; } public void setPrivs(int privs) { _rankPrivs = privs; } } private void restoreSubPledges() { Connection con = null; try { // Retrieve all subpledges of this clan from the database con = L2DatabaseFactory.getInstance().getConnection(); final PreparedStatement statement = con.prepareStatement("SELECT sub_pledge_id,name,leader_id FROM clan_subpledges WHERE clan_id=?"); statement.setInt(1, getClanId()); final ResultSet rset = statement.executeQuery(); while (rset.next()) { int id = rset.getInt("sub_pledge_id"); String name = rset.getString("name"); int leaderId = rset.getInt("leader_id"); // Create a SubPledge object for each record SubPledge pledge = new SubPledge(id, name, leaderId); _subPledges.put(id, pledge); } rset.close(); statement.close(); } catch (Exception e) { _log.log(Level.WARNING, "Could not restore clan sub-units: " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } } /** * used to retrieve subPledge by type * @param pledgeType * @return */ public final SubPledge getSubPledge(int pledgeType) { if (_subPledges == null) return null; return _subPledges.get(pledgeType); } /** * Used to retrieve subPledge by type * @param pledgeName * @return */ public final SubPledge getSubPledge(String pledgeName) { if (_subPledges == null) return null; for (SubPledge sp : _subPledges.values()) { if (sp.getName().equalsIgnoreCase(pledgeName)) { return sp; } } return null; } /** * Used to retrieve all subPledges * @return */ public final SubPledge[] getAllSubPledges() { if (_subPledges == null) return new SubPledge[0]; return _subPledges.values().toArray(new SubPledge[_subPledges.values().size()]); } public SubPledge createSubPledge(L2PcInstance player, int pledgeType, int leaderId, String subPledgeName) { SubPledge subPledge = null; pledgeType = getAvailablePledgeTypes(pledgeType); if (pledgeType == 0) { if (pledgeType == L2Clan.SUBUNIT_ACADEMY) player.sendPacket(SystemMessageId.CLAN_HAS_ALREADY_ESTABLISHED_A_CLAN_ACADEMY); else player.sendMessage("You can't create any more sub-units of this type"); return null; } if (_leader.getObjectId() == leaderId) { player.sendMessage("Leader is not correct"); return null; } // Royal Guard 5000 points per each // Order of Knights 10000 points per each if (pledgeType != -1 && ((getReputationScore() < 5000 && pledgeType < L2Clan.SUBUNIT_KNIGHT1) || (getReputationScore() < 10000 && pledgeType > L2Clan.SUBUNIT_ROYAL2))) { player.sendPacket(SystemMessageId.THE_CLAN_REPUTATION_SCORE_IS_TOO_LOW); return null; } Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(); final PreparedStatement statement = con.prepareStatement("INSERT INTO clan_subpledges (clan_id,sub_pledge_id,name,leader_id) values (?,?,?,?)"); statement.setInt(1, getClanId()); statement.setInt(2, pledgeType); statement.setString(3, subPledgeName); if (pledgeType != -1) statement.setInt(4, leaderId); else statement.setInt(4, 0); statement.execute(); statement.close(); subPledge = new SubPledge(pledgeType, subPledgeName, leaderId); _subPledges.put(pledgeType, subPledge); if (pledgeType != -1) { // Royal Guard 5000 points per each // Order of Knights 10000 points per each if (pledgeType < L2Clan.SUBUNIT_KNIGHT1) setReputationScore(getReputationScore() - Config.ROYAL_GUARD_COST, true); else setReputationScore(getReputationScore() - Config.KNIGHT_UNIT_COST, true); //TODO: clan lvl9 or more can reinforce knights cheaper if first knight unit already created, use Config.KNIGHT_REINFORCE_COST } if (Config.DEBUG) _log.fine("New sub_clan saved in db: " + getClanId() + "; " + pledgeType); } catch (Exception e) { _log.log(Level.SEVERE, "Error saving sub clan data: " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } broadcastToOnlineMembers(new PledgeShowInfoUpdate(_leader.getClan())); broadcastToOnlineMembers(new PledgeReceiveSubPledgeCreated(subPledge, _leader.getClan())); return subPledge; } public int getAvailablePledgeTypes(int pledgeType) { if (_subPledges.get(pledgeType) != null) { //_log.warning("found sub-unit with id: "+pledgeType); switch (pledgeType) { case SUBUNIT_ACADEMY: return 0; case SUBUNIT_ROYAL1: pledgeType = getAvailablePledgeTypes(SUBUNIT_ROYAL2); break; case SUBUNIT_ROYAL2: return 0; case SUBUNIT_KNIGHT1: pledgeType = getAvailablePledgeTypes(SUBUNIT_KNIGHT2); break; case SUBUNIT_KNIGHT2: pledgeType = getAvailablePledgeTypes(SUBUNIT_KNIGHT3); break; case SUBUNIT_KNIGHT3: pledgeType = getAvailablePledgeTypes(SUBUNIT_KNIGHT4); break; case SUBUNIT_KNIGHT4: return 0; } } return pledgeType; } public void updateSubPledgeInDB(int pledgeType) { Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(); final PreparedStatement statement = con.prepareStatement("UPDATE clan_subpledges SET leader_id=?, name=? WHERE clan_id=? AND sub_pledge_id=?"); statement.setInt(1, getSubPledge(pledgeType).getLeaderId()); statement.setString(2, getSubPledge(pledgeType).getName()); statement.setInt(3, getClanId()); statement.setInt(4, pledgeType); statement.execute(); statement.close(); if (Config.DEBUG) _log.fine("Subpledge updated in db: " + getClanId()); } catch (Exception e) { _log.log(Level.SEVERE, "Error updating subpledge: " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } } private void restoreRankPrivs() { Connection con = null; try { // Retrieve all skills of this L2PcInstance from the database con = L2DatabaseFactory.getInstance().getConnection(); final PreparedStatement statement = con.prepareStatement("SELECT privs,rank,party FROM clan_privs WHERE clan_id=?"); statement.setInt(1, getClanId()); //_log.warning("clanPrivs restore for ClanId : "+getClanId()); final ResultSet rset = statement.executeQuery(); // Go though the recordset of this SQL query while (rset.next()) { int rank = rset.getInt("rank"); //int party = rset.getInt("party"); int privileges = rset.getInt("privs"); // Create a SubPledge object for each record if (rank == -1) continue; _privs.get(rank).setPrivs(privileges); } rset.close(); statement.close(); } catch (Exception e) { _log.log(Level.SEVERE, "Error restoring clan privs by rank: " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } } public void initializePrivs() { RankPrivs privs; for (int i = 1; i < 10; i++) { privs = new RankPrivs(i, 0, CP_NOTHING); _privs.put(i, privs); } } public int getRankPrivs(int rank) { if (_privs.get(rank) != null) return _privs.get(rank).getPrivs(); return CP_NOTHING; } public void setRankPrivs(int rank, int privs) { if (_privs.get(rank) != null) { _privs.get(rank).setPrivs(privs); Connection con = null; try { //_log.warning("requested store clan privs in db for rank: "+rank+", privs: "+privs); // Retrieve all skills of this L2PcInstance from the database con = L2DatabaseFactory.getInstance().getConnection(); final PreparedStatement statement = con.prepareStatement("INSERT INTO clan_privs (clan_id,rank,party,privs) VALUES (?,?,?,?) ON DUPLICATE KEY UPDATE privs = ?"); statement.setInt(1, getClanId()); statement.setInt(2, rank); statement.setInt(3, 0); statement.setInt(4, privs); statement.setInt(5, privs); statement.execute(); statement.close(); } catch (Exception e) { _log.log(Level.WARNING, "Could not store clan privs for rank: " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } for (L2ClanMember cm : getMembers()) { if (cm.isOnline()) if (cm.getPowerGrade() == rank) if (cm.getPlayerInstance() != null) { cm.getPlayerInstance().setClanPrivileges(privs); cm.getPlayerInstance().sendPacket(new UserInfo(cm.getPlayerInstance())); cm.getPlayerInstance().sendPacket(new ExBrExtraUserInfo(cm.getPlayerInstance())); } } broadcastClanStatus(); } else { _privs.put(rank, new RankPrivs(rank, 0, privs)); Connection con = null; try { //_log.warning("requested store clan new privs in db for rank: "+rank); // Retrieve all skills of this L2PcInstance from the database con = L2DatabaseFactory.getInstance().getConnection(); final PreparedStatement statement = con.prepareStatement("INSERT INTO clan_privs (clan_id,rank,party,privs) VALUES (?,?,?,?)"); statement.setInt(1, getClanId()); statement.setInt(2, rank); statement.setInt(3, 0); statement.setInt(4, privs); statement.execute(); statement.close(); } catch (Exception e) { _log.log(Level.WARNING, "Could not create new rank and store clan privs for rank: " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } } } /** * @return all RankPrivs. */ public final RankPrivs[] getAllRankPrivs() { if (_privs == null) return new RankPrivs[0]; return _privs.values().toArray(new RankPrivs[_privs.values().size()]); } public int getLeaderSubPledge(int leaderId) { int id = 0; for (SubPledge sp : _subPledges.values()) { if (sp.getLeaderId() == 0) continue; if (sp.getLeaderId() == leaderId) id = sp.getId(); } return id; } public synchronized void addReputationScore(int value, boolean save) { setReputationScore(getReputationScore() + value, save); } public synchronized void takeReputationScore(int value, boolean save) { setReputationScore(getReputationScore() - value, save); } private void setReputationScore(int value, boolean save) { if (_reputationScore >= 0 && value < 0) { broadcastToOnlineMembers(SystemMessage.getSystemMessage(SystemMessageId.REPUTATION_POINTS_0_OR_LOWER_CLAN_SKILLS_DEACTIVATED)); for (L2ClanMember member : _members.values()) { if (member.isOnline() && member.getPlayerInstance() != null) { removeSkillEffects(member.getPlayerInstance()); } } } else if (_reputationScore < 0 && value >= 0) { broadcastToOnlineMembers(SystemMessage.getSystemMessage(SystemMessageId.CLAN_SKILLS_WILL_BE_ACTIVATED_SINCE_REPUTATION_IS_0_OR_HIGHER)); for (L2ClanMember member : _members.values()) { if (member.isOnline() && member.getPlayerInstance() != null) { addSkillEffects(member.getPlayerInstance()); } } } _reputationScore = value; if (_reputationScore > 100000000) _reputationScore = 100000000; if (_reputationScore < -100000000) _reputationScore = -100000000; broadcastToOnlineMembers(new PledgeShowInfoUpdate(this)); if (save) updateClanScoreInDB(); } public int getReputationScore() { return _reputationScore; } public void setRank(int rank) { _rank = rank; } public int getRank() { return _rank; } public int getAuctionBiddedAt() { return _auctionBiddedAt; } public void setAuctionBiddedAt(int id, boolean storeInDb) { _auctionBiddedAt = id; if (storeInDb) { Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(); final PreparedStatement statement = con.prepareStatement("UPDATE clan_data SET auction_bid_at=? WHERE clan_id=?"); statement.setInt(1, id); statement.setInt(2, getClanId()); statement.execute(); statement.close(); } catch (Exception e) { _log.log(Level.WARNING, "Could not store auction for clan: " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } } } /** * @param activeChar the clan inviting player. * @param target the invited player. * @param pledgeType the pledge type to join. * @return {core true} if activeChar and target meet various conditions to join a clan. */ public boolean checkClanJoinCondition(L2PcInstance activeChar, L2PcInstance target, int pledgeType) { if (activeChar == null) { return false; } if ((activeChar.getClanPrivileges() & L2Clan.CP_CL_JOIN_CLAN) != L2Clan.CP_CL_JOIN_CLAN) { activeChar.sendPacket(SystemMessageId.YOU_ARE_NOT_AUTHORIZED_TO_DO_THAT); return false; } if (target == null) { activeChar.sendPacket(SystemMessageId.YOU_HAVE_INVITED_THE_WRONG_TARGET); return false; } if (activeChar.getObjectId() == target.getObjectId()) { activeChar.sendPacket(SystemMessageId.CANNOT_INVITE_YOURSELF); return false; } if (getCharPenaltyExpiryTime() > System.currentTimeMillis()) { activeChar.sendPacket(SystemMessageId.YOU_MUST_WAIT_BEFORE_ACCEPTING_A_NEW_MEMBER); return false; } if (target.getClanId() != 0) { SystemMessage sm = SystemMessage.getSystemMessage(SystemMessageId.S1_WORKING_WITH_ANOTHER_CLAN); sm.addString(target.getName()); activeChar.sendPacket(sm); return false; } if (target.getClanJoinExpiryTime() > System.currentTimeMillis()) { SystemMessage sm = SystemMessage.getSystemMessage(SystemMessageId.C1_MUST_WAIT_BEFORE_JOINING_ANOTHER_CLAN); sm.addString(target.getName()); activeChar.sendPacket(sm); return false; } if ((target.getLevel() > 40 || target.getClassId().level() >= 2) && pledgeType == -1) { SystemMessage sm = SystemMessage.getSystemMessage(SystemMessageId.S1_DOESNOT_MEET_REQUIREMENTS_TO_JOIN_ACADEMY); sm.addString(target.getName()); activeChar.sendPacket(sm); activeChar.sendPacket(SystemMessageId.ACADEMY_REQUIREMENTS); return false; } if (getSubPledgeMembersCount(pledgeType) >= getMaxNrOfMembers(pledgeType)) { if (pledgeType == 0) { SystemMessage sm = SystemMessage.getSystemMessage(SystemMessageId.S1_CLAN_IS_FULL); sm.addString(getName()); activeChar.sendPacket(sm); } else { activeChar.sendPacket(SystemMessageId.SUBCLAN_IS_FULL); } return false; } return true; } /** * @param activeChar the clan inviting player. * @param target the invited player. * @return {core true} if activeChar and target meet various conditions to join a clan. */ public boolean checkAllyJoinCondition(L2PcInstance activeChar, L2PcInstance target) { if (activeChar == null) { return false; } if (activeChar.getAllyId() == 0 || !activeChar.isClanLeader() || activeChar.getClanId() != activeChar.getAllyId()) { activeChar.sendPacket(SystemMessageId.FEATURE_ONLY_FOR_ALLIANCE_LEADER); return false; } L2Clan leaderClan = activeChar.getClan(); if (leaderClan.getAllyPenaltyExpiryTime() > System.currentTimeMillis()) { if (leaderClan.getAllyPenaltyType() == PENALTY_TYPE_DISMISS_CLAN) { activeChar.sendPacket(SystemMessageId.CANT_INVITE_CLAN_WITHIN_1_DAY); return false; } } if (target == null) { activeChar.sendPacket(SystemMessageId.YOU_HAVE_INVITED_THE_WRONG_TARGET); return false; } if (activeChar.getObjectId() == target.getObjectId()) { activeChar.sendPacket(SystemMessageId.CANNOT_INVITE_YOURSELF); return false; } if (target.getClan() == null) { activeChar.sendPacket(SystemMessageId.TARGET_MUST_BE_IN_CLAN); return false; } if (!target.isClanLeader()) { SystemMessage sm = SystemMessage.getSystemMessage(SystemMessageId.S1_IS_NOT_A_CLAN_LEADER); sm.addString(target.getName()); activeChar.sendPacket(sm); sm = null; return false; } L2Clan targetClan = target.getClan(); if (target.getAllyId() != 0) { SystemMessage sm = SystemMessage.getSystemMessage(SystemMessageId.S1_CLAN_ALREADY_MEMBER_OF_S2_ALLIANCE); sm.addString(targetClan.getName()); sm.addString(targetClan.getAllyName()); activeChar.sendPacket(sm); sm = null; return false; } if (targetClan.getAllyPenaltyExpiryTime() > System.currentTimeMillis()) { if (targetClan.getAllyPenaltyType() == PENALTY_TYPE_CLAN_LEAVED) { SystemMessage sm = SystemMessage.getSystemMessage(SystemMessageId.S1_CANT_ENTER_ALLIANCE_WITHIN_1_DAY); sm.addString(target.getClan().getName()); sm.addString(target.getClan().getAllyName()); activeChar.sendPacket(sm); sm = null; return false; } if (targetClan.getAllyPenaltyType() == PENALTY_TYPE_CLAN_DISMISSED) { activeChar.sendPacket(SystemMessageId.CANT_ENTER_ALLIANCE_WITHIN_1_DAY); return false; } } if (activeChar.isInsideZone(L2Character.ZONE_SIEGE) && target.isInsideZone(L2Character.ZONE_SIEGE)) { activeChar.sendPacket(SystemMessageId.OPPOSING_CLAN_IS_PARTICIPATING_IN_SIEGE); return false; } if (leaderClan.isAtWarWith(targetClan.getClanId())) { activeChar.sendPacket(SystemMessageId.MAY_NOT_ALLY_CLAN_BATTLE); return false; } if (ClanTable.getInstance().getClanAllies(activeChar.getAllyId()).size() >= Config.ALT_MAX_NUM_OF_CLANS_IN_ALLY) { activeChar.sendPacket(SystemMessageId.YOU_HAVE_EXCEEDED_THE_LIMIT); return false; } return true; } public long getAllyPenaltyExpiryTime() { return _allyPenaltyExpiryTime; } public int getAllyPenaltyType() { return _allyPenaltyType; } public void setAllyPenaltyExpiryTime(long expiryTime, int penaltyType) { _allyPenaltyExpiryTime = expiryTime; _allyPenaltyType = penaltyType; } public long getCharPenaltyExpiryTime() { return _charPenaltyExpiryTime; } public void setCharPenaltyExpiryTime(long time) { _charPenaltyExpiryTime = time; } public long getDissolvingExpiryTime() { return _dissolvingExpiryTime; } public void setDissolvingExpiryTime(long time) { _dissolvingExpiryTime = time; } public void createAlly(L2PcInstance player, String allyName) { if (null == player) return; if (Config.DEBUG) _log.fine(player.getObjectId() + "(" + player.getName() + ") requested ally creation from "); if (!player.isClanLeader()) { player.sendPacket(SystemMessageId.ONLY_CLAN_LEADER_CREATE_ALLIANCE); return; } if (getAllyId() != 0) { player.sendPacket(SystemMessageId.ALREADY_JOINED_ALLIANCE); return; } if (getLevel() < 5) { player.sendPacket(SystemMessageId.TO_CREATE_AN_ALLY_YOU_CLAN_MUST_BE_LEVEL_5_OR_HIGHER); return; } if (getAllyPenaltyExpiryTime() > System.currentTimeMillis()) { if (getAllyPenaltyType() == L2Clan.PENALTY_TYPE_DISSOLVE_ALLY) { player.sendPacket(SystemMessageId.CANT_CREATE_ALLIANCE_10_DAYS_DISOLUTION); return; } } if (getDissolvingExpiryTime() > System.currentTimeMillis()) { player.sendPacket(SystemMessageId.YOU_MAY_NOT_CREATE_ALLY_WHILE_DISSOLVING); return; } if (!Util.isAlphaNumeric(allyName)) { player.sendPacket(SystemMessageId.INCORRECT_ALLIANCE_NAME); return; } if (allyName.length() > 16 || allyName.length() < 2) { player.sendPacket(SystemMessageId.INCORRECT_ALLIANCE_NAME_LENGTH); return; } if (ClanTable.getInstance().isAllyExists(allyName)) { player.sendPacket(SystemMessageId.ALLIANCE_ALREADY_EXISTS); return; } setAllyId(getClanId()); setAllyName(allyName.trim()); setAllyPenaltyExpiryTime(0, 0); updateClanInDB(); player.sendPacket(new UserInfo(player)); player.sendPacket(new ExBrExtraUserInfo(player)); //TODO: Need correct message id player.sendMessage("Alliance " + allyName + " has been created."); // notify CB server about the change CommunityServerThread.getInstance().sendPacket(new WorldInfo(null, this, WorldInfo.TYPE_UPDATE_CLAN_DATA)); } public void dissolveAlly(L2PcInstance player) { if (getAllyId() == 0) { player.sendPacket(SystemMessageId.NO_CURRENT_ALLIANCES); return; } if (!player.isClanLeader() || getClanId() != getAllyId()) { player.sendPacket(SystemMessageId.FEATURE_ONLY_FOR_ALLIANCE_LEADER); return; } if (player.isInsideZone(L2Character.ZONE_SIEGE)) { player.sendPacket(SystemMessageId.CANNOT_DISSOLVE_ALLY_WHILE_IN_SIEGE); return; } broadcastToOnlineAllyMembers(SystemMessage.getSystemMessage(SystemMessageId.ALLIANCE_DISOLVED)); long currentTime = System.currentTimeMillis(); for (L2Clan clan : ClanTable.getInstance().getClanAllies(getAllyId())) { if (clan.getClanId() != getClanId()) { clan.setAllyId(0); clan.setAllyName(null); clan.setAllyPenaltyExpiryTime(0, 0); clan.updateClanInDB(); // notify CB server about the change CommunityServerThread.getInstance().sendPacket(new WorldInfo(null, clan, WorldInfo.TYPE_UPDATE_CLAN_DATA)); } } setAllyId(0); setAllyName(null); changeAllyCrest(0, false); setAllyPenaltyExpiryTime(currentTime + Config.ALT_CREATE_ALLY_DAYS_WHEN_DISSOLVED * 86400000L, L2Clan.PENALTY_TYPE_DISSOLVE_ALLY); //24*60*60*1000 = 86400000 updateClanInDB(); // The clan leader should take the XP penalty of a full death. player.deathPenalty(false, false, false); // notify CB server about the change CommunityServerThread.getInstance().sendPacket(new WorldInfo(null, this, WorldInfo.TYPE_UPDATE_CLAN_DATA)); } public boolean levelUpClan(L2PcInstance player) { if (!player.isClanLeader()) { player.sendPacket(SystemMessageId.YOU_ARE_NOT_AUTHORIZED_TO_DO_THAT); return false; } if (System.currentTimeMillis() < getDissolvingExpiryTime()) { player.sendPacket(SystemMessageId.CANNOT_RISE_LEVEL_WHILE_DISSOLUTION_IN_PROGRESS); return false; } boolean increaseClanLevel = false; for (ClanCreationListener listener : clanCreationListeners) { if (!listener.onClanLevelUp(this, getLevel())) { return false; } } switch (getLevel()) { case 0: { // Upgrade to 1 if (player.getSp() >= 20000 && player.getAdena() >= 650000) { if (player.reduceAdena("ClanLvl", 650000, player.getTarget(), true)) { player.setSp(player.getSp() - 20000); SystemMessage sp = SystemMessage.getSystemMessage(SystemMessageId.SP_DECREASED_S1); sp.addNumber(20000); player.sendPacket(sp); sp = null; increaseClanLevel = true; } } break; } case 1: { // Upgrade to 2 if (player.getSp() >= 100000 && player.getAdena() >= 2500000) { if (player.reduceAdena("ClanLvl", 2500000, player.getTarget(), true)) { player.setSp(player.getSp() - 100000); SystemMessage sp = SystemMessage.getSystemMessage(SystemMessageId.SP_DECREASED_S1); sp.addNumber(100000); player.sendPacket(sp); sp = null; increaseClanLevel = true; } } break; } case 2: { // Upgrade to 3 if (player.getSp() >= 350000 && player.getInventory().getItemByItemId(1419) != null) { // itemId 1419 == Blood Mark if (player.destroyItemByItemId("ClanLvl", 1419, 1, player.getTarget(), false)) { player.setSp(player.getSp() - 350000); SystemMessage sp = SystemMessage.getSystemMessage(SystemMessageId.SP_DECREASED_S1); sp.addNumber(350000); player.sendPacket(sp); sp = null; SystemMessage sm = SystemMessage.getSystemMessage(SystemMessageId.S1_DISAPPEARED); sm.addItemName(1419); player.sendPacket(sm); sm = null; increaseClanLevel = true; } } break; } case 3: { // Upgrade to 4 if (player.getSp() >= 1000000 && player.getInventory().getItemByItemId(3874) != null) { // itemId 3874 == Alliance Manifesto if (player.destroyItemByItemId("ClanLvl", 3874, 1, player.getTarget(), false)) { player.setSp(player.getSp() - 1000000); SystemMessage sp = SystemMessage.getSystemMessage(SystemMessageId.SP_DECREASED_S1); sp.addNumber(1000000); player.sendPacket(sp); sp = null; SystemMessage sm = SystemMessage.getSystemMessage(SystemMessageId.S1_DISAPPEARED); sm.addItemName(3874); player.sendPacket(sm); sm = null; increaseClanLevel = true; } } break; } case 4: { // Upgrade to 5 if (player.getSp() >= 2500000 && player.getInventory().getItemByItemId(3870) != null) { // itemId 3870 == Seal of Aspiration if (player.destroyItemByItemId("ClanLvl", 3870, 1, player.getTarget(), false)) { player.setSp(player.getSp() - 2500000); SystemMessage sp = SystemMessage.getSystemMessage(SystemMessageId.SP_DECREASED_S1); sp.addNumber(2500000); player.sendPacket(sp); sp = null; SystemMessage sm = SystemMessage.getSystemMessage(SystemMessageId.S1_DISAPPEARED); sm.addItemName(3870); player.sendPacket(sm); sm = null; increaseClanLevel = true; } } break; } case 5: // Upgrade to 6 if (getReputationScore() >= Config.CLAN_LEVEL_6_COST && getMembersCount() >= Config.CLAN_LEVEL_6_REQUIREMENT) { setReputationScore(getReputationScore() - Config.CLAN_LEVEL_6_COST, true); SystemMessage cr = SystemMessage.getSystemMessage(SystemMessageId.S1_DEDUCTED_FROM_CLAN_REP); cr.addNumber(Config.CLAN_LEVEL_6_COST); player.sendPacket(cr); cr = null; increaseClanLevel = true; } break; case 6: // Upgrade to 7 if (getReputationScore() >= Config.CLAN_LEVEL_7_COST && getMembersCount() >= Config.CLAN_LEVEL_7_REQUIREMENT) { setReputationScore(getReputationScore() - Config.CLAN_LEVEL_7_COST, true); SystemMessage cr = SystemMessage.getSystemMessage(SystemMessageId.S1_DEDUCTED_FROM_CLAN_REP); cr.addNumber(Config.CLAN_LEVEL_7_COST); player.sendPacket(cr); cr = null; increaseClanLevel = true; } break; case 7: // Upgrade to 8 if (getReputationScore() >= Config.CLAN_LEVEL_8_COST && getMembersCount() >= Config.CLAN_LEVEL_8_REQUIREMENT) { setReputationScore(getReputationScore() - Config.CLAN_LEVEL_8_COST, true); SystemMessage cr = SystemMessage.getSystemMessage(SystemMessageId.S1_DEDUCTED_FROM_CLAN_REP); cr.addNumber(Config.CLAN_LEVEL_8_COST); player.sendPacket(cr); cr = null; increaseClanLevel = true; } break; case 8: // Upgrade to 9 if (getReputationScore() >= Config.CLAN_LEVEL_9_COST && player.getInventory().getItemByItemId(9910) != null && getMembersCount() >= Config.CLAN_LEVEL_9_REQUIREMENT) { // itemId 9910 == Blood Oath if (player.destroyItemByItemId("ClanLvl", 9910, 150, player.getTarget(), false)) { setReputationScore(getReputationScore() - Config.CLAN_LEVEL_9_COST, true); SystemMessage cr = SystemMessage.getSystemMessage(SystemMessageId.S1_DEDUCTED_FROM_CLAN_REP); cr.addNumber(Config.CLAN_LEVEL_9_COST); player.sendPacket(cr); cr = null; SystemMessage sm = SystemMessage.getSystemMessage(SystemMessageId.S2_S1_DISAPPEARED); sm.addItemName(9910); sm.addItemNumber(150); player.sendPacket(sm); increaseClanLevel = true; } } break; case 9: // Upgrade to 10 if (getReputationScore() >= Config.CLAN_LEVEL_10_COST && player.getInventory().getItemByItemId(9911) != null && getMembersCount() >= Config.CLAN_LEVEL_10_REQUIREMENT) { // itemId 9911 == Blood Alliance if (player.destroyItemByItemId("ClanLvl", 9911, 5, player.getTarget(), false)) { setReputationScore(getReputationScore() - Config.CLAN_LEVEL_10_COST, true); SystemMessage cr = SystemMessage.getSystemMessage(SystemMessageId.S1_DEDUCTED_FROM_CLAN_REP); cr.addNumber(Config.CLAN_LEVEL_10_COST); player.sendPacket(cr); cr = null; SystemMessage sm = SystemMessage.getSystemMessage(SystemMessageId.S2_S1_DISAPPEARED); sm.addItemName(9911); sm.addItemNumber(5); player.sendPacket(sm); increaseClanLevel = true; } } break; case 10: // Upgrade to 11 boolean hasTerritory = false; for (Territory terr : TerritoryWarManager.getInstance().getAllTerritories()) { if (terr.getOwnerClan().getClanId() == getClanId()) { hasTerritory = true; break; } } if (hasTerritory && getReputationScore() >= Config.CLAN_LEVEL_11_COST && getMembersCount() >= Config.CLAN_LEVEL_11_REQUIREMENT) { setReputationScore(getReputationScore() - Config.CLAN_LEVEL_11_COST, true); SystemMessage cr = SystemMessage.getSystemMessage(SystemMessageId.S1_DEDUCTED_FROM_CLAN_REP); cr.addNumber(Config.CLAN_LEVEL_11_COST); player.sendPacket(cr); cr = null; increaseClanLevel = true; } break; default: return false; } if (!increaseClanLevel) { player.sendPacket(SystemMessageId.FAILED_TO_INCREASE_CLAN_LEVEL); return false; } // the player should know that he has less sp now :p StatusUpdate su = new StatusUpdate(player); su.addAttribute(StatusUpdate.SP, player.getSp()); player.sendPacket(su); ItemList il = new ItemList(player, false); player.sendPacket(il); changeLevel(getLevel() + 1); return true; } public void changeLevel(int level) { Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(); final PreparedStatement statement = con.prepareStatement("UPDATE clan_data SET clan_level = ? WHERE clan_id = ?"); statement.setInt(1, level); statement.setInt(2, getClanId()); statement.execute(); statement.close(); } catch (Exception e) { _log.log(Level.WARNING, "could not increase clan level:" + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } setLevel(level); if (getLeader().isOnline()) { L2PcInstance leader = getLeader().getPlayerInstance(); if (4 < level) { SiegeManager.getInstance().addSiegeSkills(leader); leader.sendPacket(SystemMessageId.CLAN_CAN_ACCUMULATE_CLAN_REPUTATION_POINTS); } else if (5 > level) { SiegeManager.getInstance().removeSiegeSkills(leader); } } // notify all the members about it broadcastToOnlineMembers(SystemMessage.getSystemMessage(SystemMessageId.CLAN_LEVEL_INCREASED)); broadcastToOnlineMembers(new PledgeShowInfoUpdate(this)); /* * Micht : * - use PledgeShowInfoUpdate instead of PledgeStatusChanged * to update clan level ingame * - remove broadcastClanStatus() to avoid members duplication */ //clan.broadcastToOnlineMembers(new PledgeStatusChanged(clan)); //clan.broadcastClanStatus(); // notify CB server about the change CommunityServerThread.getInstance().sendPacket(new WorldInfo(null, this, WorldInfo.TYPE_UPDATE_CLAN_DATA)); } /** * Change the clan crest. If crest id is 0, crest is removed. New crest id is saved to database. * @param crestId if 0, crest is removed, else new crest id is set and saved to database */ public void changeClanCrest(int crestId) { if (getCrestId() != 0) CrestCache.getInstance().removePledgeCrest(getCrestId()); setCrestId(crestId); Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(); final PreparedStatement statement = con.prepareStatement("UPDATE clan_data SET crest_id = ? WHERE clan_id = ?"); statement.setInt(1, crestId); statement.setInt(2, getClanId()); statement.executeUpdate(); statement.close(); } catch (SQLException e) { _log.log(Level.WARNING, "Could not update crest for clan " + getName() + " [" + getClanId() + "] : " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } for (L2PcInstance member : getOnlineMembers(0)) member.broadcastUserInfo(); } /** * Change the ally crest. If crest id is 0, crest is removed. New crest id is saved to database. * @param crestId if 0, crest is removed, else new crest id is set and saved to database * @param onlyThisClan */ public void changeAllyCrest(int crestId, boolean onlyThisClan) { String sqlStatement = "UPDATE clan_data SET ally_crest_id = ? WHERE clan_id = ?"; int allyId = getClanId(); if (!onlyThisClan) { if (getAllyCrestId() != 0) CrestCache.getInstance().removeAllyCrest(getAllyCrestId()); sqlStatement = "UPDATE clan_data SET ally_crest_id = ? WHERE ally_id = ?"; allyId = getAllyId(); } Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(); final PreparedStatement statement = con.prepareStatement(sqlStatement); statement.setInt(1, crestId); statement.setInt(2, allyId); statement.executeUpdate(); statement.close(); } catch (SQLException e) { _log.log(Level.WARNING, "Could not update ally crest for ally/clan id " + allyId + " : " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } if (onlyThisClan) { setAllyCrestId(crestId); for (L2PcInstance member : getOnlineMembers(0)) member.broadcastUserInfo(); } else { for (L2Clan clan : ClanTable.getInstance().getClanAllies(getAllyId())) { clan.setAllyCrestId(crestId); for (L2PcInstance member : clan.getOnlineMembers(0)) { member.broadcastUserInfo(); } } } } /** * Change the large crest. If crest id is 0, crest is removed. New crest id is saved to database. * @param crestId if 0, crest is removed, else new crest id is set and saved to database */ public void changeLargeCrest(int crestId) { if (getCrestLargeId() != 0) CrestCache.getInstance().removePledgeCrestLarge(getCrestLargeId()); setCrestLargeId(crestId); Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(); final PreparedStatement statement = con.prepareStatement("UPDATE clan_data SET crest_large_id = ? WHERE clan_id = ?"); statement.setInt(1, crestId); statement.setInt(2, getClanId()); statement.executeUpdate(); statement.close(); } catch (SQLException e) { _log.log(Level.WARNING, "Could not update large crest for clan " + getName() + " [" + getClanId() + "] : " + e.getMessage(), e); } finally { L2DatabaseFactory.close(con); } for (L2PcInstance member : getOnlineMembers(0)) member.broadcastUserInfo(); } /** * Check if this clan can learn the skill for the given skill ID, level. * @param skillId * @param skillLevel * @return {@code true} if skill can be learned. */ public boolean isLearnableSubSkill(int skillId, int skillLevel) { L2Skill current = _subPledgeSkills.get(skillId); // is next level? if ((current != null) && ((current.getLevel() + 1) == skillLevel)) return true; // is first level? if ((current == null) && (skillLevel == 1)) return true; // other subpledges for (SubPledge subunit : _subPledges.values()) { //disable academy if (subunit._id == -1) continue; current = subunit._subPledgeSkills.get(skillId); // is next level? if ((current != null) && ((current.getLevel() + 1) == skillLevel)) return true; // is first level? if ((current == null) && (skillLevel == 1)) return true; } return false; } public boolean isLearnableSubPledgeSkill(L2Skill skill, int subType) { //academy if (subType == -1) return false; int id = skill.getId(); L2Skill current; if (subType == 0) { current = _subPledgeSkills.get(id); } else { current = _subPledges.get(subType)._subPledgeSkills.get(id); } // is next level? if ((current != null) && (current.getLevel() + 1) == skill.getLevel()) return true; // is first level? if ((current == null) && (skill.getLevel() == 1)) return true; return false; } public SubPledgeSkill[] getAllSubSkills() { FastList list = FastList.newInstance(); for (L2Skill skill : _subPledgeSkills.values()) list.add(new SubPledgeSkill(0, skill.getId(), skill.getLevel())); for (SubPledge subunit: _subPledges.values()) for (L2Skill skill : subunit.getSkills()) list.add(new SubPledgeSkill(subunit._id, skill.getId(), skill.getLevel())); SubPledgeSkill[] result = list.toArray(new SubPledgeSkill[list.size()]); FastList.recycle(list); return result; } // Listeners /** * Adds a clan creation listener * @param listener */ public static void addClanCreationListener(ClanCreationListener listener) { if (!clanCreationListeners.contains(listener)) { clanCreationListeners.add(listener); } } /** * Removes a clan creation listener * @param listener */ public static void removeClanCreationListener(ClanCreationListener listener) { clanCreationListeners.remove(listener); } /** * Adds a clan join listener (a player just joined the clan) * @param listener */ public static void addClanMembershipListener(ClanMembershipListener listener) { if (!clanMembershipListeners.contains(listener)) { clanMembershipListeners.add(listener); } } /** * Removes a clan join listener (a player left the clan) * @param listener */ public static void removeClanMembershipListener(ClanMembershipListener listener) { clanMembershipListeners.remove(listener); } /** * Adds a clan war listener * @param listener */ public static void addClanWarListener(ClanWarListener listener) { if (!clanWarListeners.contains(listener)) { clanWarListeners.add(listener); } } /** * Removes a clan war listener * @param listener */ public static void removeClanWarListener(ClanWarListener listener) { clanWarListeners.remove(listener); } }