private void load() { Connection con = null; try { PreparedStatement statement; ResultSet rs; con = L2DatabaseFactory.getInstance().getConnection(con); statement = con.prepareStatement("SELECT * FROM fort WHERE id = ?"); statement.setInt(1, getFortId()); rs = statement.executeQuery(); while (rs.next()) { _name = rs.getString("name"); _siegeDate = Calendar.getInstance(); _siegeDate.setTimeInMillis(rs.getLong("siegeDate")); _lastOwnedTime = rs.getLong("lastOwnedTime"); _ownerId = rs.getInt("owner"); _fortType = rs.getInt("fortType"); _state = rs.getInt("state"); _castleId = rs.getInt("castleId"); } rs.close(); statement.close(); if (_ownerId > 0) { L2Clan clan = ClanTable.getInstance().getClan(_ownerId); // Try to find clan instance if (clan != null) { setOwnerClan(clan); clan.setHasFort(getFortId()); ThreadPoolManager.getInstance() .scheduleGeneral( new FortUpdater(clan, 1), 3600000); // Schedule owner tasks to start running } else setOwnerClan(null); } else setOwnerClan(null); if (_state == 2 && _castleId != 0) { Castle castle = CastleManager.getInstance().getCastleById(_castleId); if (castle != null) castle.addContractFort(getFortId()); } } catch (Exception e) { _log.warn("Exception: loadFortData(): " + e.getMessage(), e); } finally { try { if (con != null) con.close(); } catch (SQLException e) { e.printStackTrace(); } } }
public void removeOwner(boolean updateDB) { setFortState(0, 0); L2Clan clan = getOwnerClan(); if (clan != null) { for (L2PcInstance member : clan.getOnlineMembers(0)) { removeResidentialSkills(member); member.sendSkillList(); } clan.setHasFort(0); clan.broadcastToOnlineMembers(new PledgeShowInfoUpdate(clan)); setOwnerClan(null); if (updateDB) updateOwnerInDB(); } }
/** * This method will set owner for Fort * * @param clan * @param updateClanPoints */ public boolean setOwner(L2Clan clan, boolean updateClansReputation) { ClanHall hall = ClanHallManager.getInstance().getClanHallByOwner(clan); if (hall != null) { clan.broadcastToOnlineMembers( new SystemMessage(SystemMessageId.S1) .addString("Вы потеряли ваш кланхолл " + hall.getName())); ClanHallManager.getInstance().setFree(hall.getId()); AuctionManager.getInstance().initNPC(hall.getId()); } if (clan.getAuctionBiddedAt() > 0) { Auction a = AuctionManager.getInstance().getAuction(clan.getAuctionBiddedAt()); if (a != null) { a.cancelAuction(); clan.broadcastToOnlineMembers( new SystemMessage(SystemMessageId.S1).addString("Ваше участие в аукционе отменено")); } } if (updateClansReputation) updateClansReputation(clan, false); // update reputation first for (L2PcInstance member : clan.getOnlineMembers(0)) { giveResidentialSkills(member); member.sendSkillList(); } // Remove old owner if (getOwnerClan() != null && (clan != null && clan != getOwnerClan())) { updateClansReputation(clan, true); L2PcInstance oldLord = getOwnerClan().getLeader().getPlayerInstance(); if (oldLord != null && oldLord.getMountType() == 2) oldLord.dismount(); removeOwner(true); } setFortState(0, 0); // initialize fort state // if clan already have castle, don't store him in fortress if (clan.getHasCastle() > 0) { getSiege() .announceToPlayer( new SystemMessage(SystemMessageId.S1).addString("Форт снова пренадлежит NPC"), 0, false); return false; } else { getSpawnManager().spawnSpecialEnvoys(); ThreadPoolManager.getInstance() .scheduleGeneral( new ScheduleSpecialEnvoysDeSpawn(this), 1 * 60 * 60 * 1000); // Prepare 1hr task for special envoys despawn // if clan have already fortress, remove it if (clan.getHasFort() > 0) FortManager.getInstance().getFortByOwner(clan).removeOwner(true); setOwnerClan(clan); _ownerId = clan.getClanId(); updateOwnerInDB(); // Update in database if (getSiege().getIsInProgress()) { // If siege in progress if (Config.FORTSIEGE_REWARD_ID > 0) { clan.getWarehouse() .addItem( "Siege", Config.FORTSIEGE_REWARD_ID, Config.FORTSIEGE_REWARD_COUNT, null, null); if (clan.getLeader().getPlayerInstance() != null) clan.getLeader() .getPlayerInstance() .sendMessage( "Your clan obtain " + Config.FORTSIEGE_REWARD_COUNT + " " + ItemTable.getInstance().getItemName(Config.FORTSIEGE_REWARD_ID)); } getSiege().endSiege(); } return true; } }