package l2p.gameserver.model.entity.residence;
import java.sql.ResultSet;
import java.util.StringTokenizer;
import java.util.logging.Logger;
import l2p.database.DatabaseUtils;
import l2p.database.FiltredPreparedStatement;
import l2p.database.L2DatabaseFactory;
import l2p.database.ThreadConnection;
import l2p.extensions.Stat;
import l2p.extensions.multilang.CustomMessage;
import l2p.gameserver.instancemanager.CastleManager;
import l2p.gameserver.instancemanager.CastleManorManager;
import l2p.gameserver.instancemanager.CastleManorManager.CropProcure;
import l2p.gameserver.instancemanager.CastleManorManager.SeedProduction;
import l2p.gameserver.instancemanager.FortressManager;
import l2p.gameserver.instancemanager.SiegeGuardManager;
import l2p.gameserver.instancemanager.ZoneManager;
import l2p.gameserver.model.L2Clan;
import l2p.gameserver.model.L2Manor;
import l2p.gameserver.model.L2Player;
import l2p.gameserver.model.L2Skill;
import l2p.gameserver.model.L2Zone.ZoneType;
import l2p.gameserver.model.entity.SevenSigns;
import l2p.gameserver.model.entity.siege.SiegeClanType;
import l2p.gameserver.model.entity.siege.castle.CastleSiege;
import l2p.gameserver.model.entity.siege.territory.TerritorySiege;
import l2p.gameserver.model.items.Warehouse;
import l2p.gameserver.serverpackets.PlaySound;
import l2p.gameserver.tables.SkillTable;
import l2p.util.GArray;
import l2p.util.Log;
import l2p.util.SafeMath;
public class Castle extends Residence
{
protected static Logger _log = Logger.getLogger(Castle.class.getName());
private static final String CASTLE_MANOR_DELETE_PRODUCTION = "DELETE FROM castle_manor_production WHERE castle_id=?;";
private static final String CASTLE_MANOR_DELETE_PRODUCTION_PERIOD = "DELETE FROM castle_manor_production WHERE castle_id=? AND period=?;";
private static final String CASTLE_MANOR_DELETE_PROCURE = "DELETE FROM castle_manor_procure WHERE castle_id=?;";
private static final String CASTLE_MANOR_DELETE_PROCURE_PERIOD = "DELETE FROM castle_manor_procure WHERE castle_id=? AND period=?;";
private static final String CASTLE_UPDATE_CROP = "UPDATE castle_manor_procure SET can_buy=? WHERE crop_id=? AND castle_id=? AND period=?";
private static final String CASTLE_UPDATE_SEED = "UPDATE castle_manor_production SET can_produce=? WHERE seed_id=? AND castle_id=? AND period=?";
private GArray<CropProcure> _procure;
private GArray<SeedProduction> _production;
private GArray<CropProcure> _procureNext;
private GArray<SeedProduction> _productionNext;
private boolean _isNextPeriodApproved;
private CastleSiege _Siege;
private int _SiegeDayOfWeek;
private int _SiegeHourOfDay;
private int _TaxPercent;
private double _TaxRate;
private long _treasury;
private int _townId;
private long _collectedShops;
private long _collectedSeed;
private int[] _flags;
public Castle(int castleId)
{
super(castleId);
}
public int[] getFlags()
{
return _flags;
}
public void setFlags(int[] flags)
{
_flags = flags;
}
public synchronized void removeFlag(int toRemove)
{
GArray<Integer> flags = new GArray<Integer>();
for(int flag : _flags)
{
if(flag != toRemove)
{
flags.add(flag);
}
}
int[] newFlags = new int[flags.size()];
for(int i = 0; i < flags.size(); i++)
{
newFlags[i] = flags.get(i);
}
_flags = newFlags;
}
public synchronized void addFlag(int toAdd)
{
GArray<Integer> flags = new GArray<Integer>();
for(int flag : _flags)
{
if(flag != toAdd)
{
flags.add(flag);
}
}
flags.add(toAdd);
int[] newFlags = new int[flags.size()];
for(int i = 0; i < flags.size(); i++)
{
newFlags[i] = flags.get(i);
}
_flags = newFlags;
}
/**
* Вовзращает скилы территорий для этого замка
*/
public GArray<L2Skill> getTerritorySkills()
{
boolean territotyBenefit = false;
GArray<L2Skill> skills = new GArray<L2Skill>();
for(int i = 0; i < _flags.length; i++)
{
L2Skill skill = SkillTable.getInstance().getInfo(TerritorySiege.TERRITORY_SKILLS[_flags[i]], 1);
if(skill != null)
{
skills.add(skill);
}
// Бонусы выдаются только если имеется флаг своего замка
if(_flags[i] == getId())
{
territotyBenefit = true;
}
}
return territotyBenefit ? skills : new GArray<L2Skill>();
}
@Override
public CastleSiege getSiege()
{
if(_Siege == null)
{
_Siege = new CastleSiege(this);
}
return _Siege;
}
@Override
public int getSiegeDayOfWeek()
{
return _SiegeDayOfWeek;
}
@Override
public int getSiegeHourOfDay()
{
return _SiegeHourOfDay;
}
// This method sets the castle owner; null here means give it back to NPC
@Override
public void changeOwner(L2Clan clan)
{
// Если клан уже владел каким-либо замком/крепостью, отбираем его.
if(clan != null)
{
if(clan.getHasFortress() != 0)
{
Fortress oldFortress = FortressManager.getInstance().getFortressByIndex(clan.getHasFortress());
if(oldFortress != null)
{
oldFortress.changeOwner(null);
}
}
if(clan.getHasCastle() != 0)
{
Castle oldCastle = CastleManager.getInstance().getCastleByIndex(clan.getHasCastle());
if(oldCastle != null)
{
oldCastle.changeOwner(null);
}
}
}
// Если этим замком уже кто-то владел, отбираем у него замок
if(getOwnerId() > 0 && (clan == null || clan.getClanId() != getOwnerId()))
{
// Удаляем замковые скилы у старого владельца
removeSkills();
// Убираем налог
setTaxPercent(null, 0);
L2Clan oldOwner = getOwner();
if(oldOwner != null)
{
// Переносим сокровищницу в вархауз старого владельца
long amount = getTreasury();
if(amount > 0)
{
Warehouse warehouse = oldOwner.getWarehouse();
if(warehouse != null)
{
warehouse.addItem(57, amount, null);
addToTreasuryNoTax(-amount, false, false);
Log.add(getName() + "|" + -amount + "|Castle:changeOwner", "treasury");
}
}
// Проверяем членов старого клана владельца, снимаем короны замков и корону лорда с лидера
for(L2Player clanMember : oldOwner.getOnlineMembers(0))
{
if(clanMember != null && clanMember.getInventory() != null)
{
clanMember.getInventory().checkAllConditions();
}
}
// Отнимаем замок у старого владельца
oldOwner.setHasCastle(0);
}
}
// Выдаем замок новому владельцу
if(clan != null)
{
clan.setHasCastle(getId());
}
// Удаляем регистрации на осаду
if(clan == null) // Только в этом случае, иначе при Engrave удалятся тоже
{
getSiege().getDatabase().clearSiegeClan(SiegeClanType.DEFENDER);
getSiege().getDatabase().clearSiegeClan(SiegeClanType.DEFENDER_WAITING);
getSiege().getDatabase().clearSiegeClan(SiegeClanType.DEFENDER_REFUSED);
}
// Сохраняем в базу
updateOwnerInDB(clan);
// Выдаем замковые скилы новому владельцу
rewardSkills();
// Удаляем наемных гвардов
SiegeGuardManager.removeMercsFromDb(_id);
// Удаляем все апгрейды замка
removeUpgrade();
// Полупобеда, если идет осада
if(clan != null && getSiege().isInProgress())
{
getSiege().midVictory();
}
}
// This method loads castle
@Override
protected void loadData()
{
_SiegeDayOfWeek = 7; // Default to saturday
_SiegeHourOfDay = 20; // Default to 8 pm server time
_TaxPercent = 0;
_TaxRate = 0;
_treasury = 0;
_townId = 0;
_Siege = null;
_procure = new GArray<CropProcure>();
_production = new GArray<SeedProduction>();
_procureNext = new GArray<CropProcure>();
_productionNext = new GArray<SeedProduction>();
_isNextPeriodApproved = false;
_type = ResidenceType.Castle;
ThreadConnection con = null;
FiltredPreparedStatement statement = null;
ResultSet rset = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement("SELECT clan_id FROM clan_data WHERE hasCastle = ? LIMIT 1");
statement.setInt(1, getId());
rset = statement.executeQuery();
if(rset.next())
{
_ownerId = rset.getInt("clan_id");
}
statement = con.prepareStatement("SELECT * FROM castle WHERE id=? LIMIT 1");
statement.setInt(1, getId());
rset = statement.executeQuery();
while(rset.next())
{
_name = rset.getString("name");
_SiegeDayOfWeek = rset.getInt("siegeDayOfWeek");
if(_SiegeDayOfWeek < 1 || _SiegeDayOfWeek > 7)
{
_SiegeDayOfWeek = 7;
}
_SiegeHourOfDay = rset.getInt("siegeHourOfDay");
if(_SiegeHourOfDay < 0 || _SiegeHourOfDay > 23)
{
_SiegeHourOfDay = 20;
}
_TaxPercent = rset.getInt("taxPercent");
_treasury = rset.getLong("treasury");
_townId = rset.getInt("townId");
getSiege().setSiegeDateTime(rset.getLong("siegeDate") * 1000L);
StringTokenizer st = new StringTokenizer(rset.getString("skills"), ";");
while(st.hasMoreTokens())
{
L2Skill skill = SkillTable.getInstance().getInfo(Integer.valueOf(st.nextToken()), Integer.valueOf(st.nextToken()));
if(skill != null)
{
_skills.add(skill);
}
}
String flags = rset.getString("flags");
if(flags.isEmpty())
{
_flags = new int[0];
}
else
{
String[] values = rset.getString("flags").split(";");
_flags = new int[values.length];
for(int i = 0; i < values.length; i++)
{
_flags[i] = Integer.parseInt(values[i]);
}
}
setOwnDate(rset.getInt("ownDate"));
}
DatabaseUtils.closeDatabaseSR(statement, rset);
_TaxRate = _TaxPercent / 100.0;
_zone = ZoneManager.getInstance().getZoneByIndex(ZoneType.Castle, getId(), true);
}
catch(Exception e)
{
_log.warning("Exception: loadData(): " + e.getMessage());
e.printStackTrace();
}
finally
{
DatabaseUtils.closeDatabaseCSR(con, statement, rset);
}
}
private void updateOwnerInDB(L2Clan clan)
{
_ownerId = clan == null ? 0 : clan.getClanId(); // Update owner id property
ThreadConnection con = null;
FiltredPreparedStatement statement = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement("UPDATE clan_data SET hasCastle=0 WHERE hasCastle=? LIMIT 1");
statement.setInt(1, getId());
statement.execute();
DatabaseUtils.closeStatement(statement);
statement = null;
if(clan != null)
{
statement = con.prepareStatement("UPDATE clan_data SET hasCastle=? WHERE clan_id=? LIMIT 1");
statement.setInt(1, getId());
statement.setInt(2, getOwnerId());
statement.execute();
clan.broadcastClanStatus(false, true, true);
clan.broadcastToOnlineMembers(new PlaySound("Siege_Victory"));
}
}
catch(Exception e)
{
_log.warning("Exception: updateOwnerInDB(L2Clan clan): " + e.getMessage());
e.printStackTrace();
}
finally
{
DatabaseUtils.closeDatabaseCS(con, statement);
}
}
public int getTaxPercent()
{
// Если печатью SEAL_STRIFE владеют DUSK то налог можно выставлять не более 5%
if(_TaxPercent > 5 && SevenSigns.getInstance().getSealOwner(SevenSigns.SEAL_STRIFE) == SevenSigns.CABAL_DUSK)
{
_TaxPercent = 5;
}
return _TaxPercent;
}
public long getCollectedShops()
{
return _collectedShops;
}
public long getCollectedSeed()
{
return _collectedSeed;
}
public void setCollectedShops(long value)
{
_collectedShops = value;
}
public void setCollectedSeed(int value)
{
_collectedSeed = value;
}
// This method add to the treasury
/**
* Add amount to castle instance's treasury (warehouse).
*/
public void addToTreasury(long amount, boolean shop, boolean seed)
{
if(getOwnerId() <= 0)
{
return;
}
if(amount == 0)
{
return;
}
if(amount > 1 && _id != 5 && _id != 8) // If current castle instance is not Aden or Rune
{
Castle royal = CastleManager.getInstance().getCastleByIndex(_id >= 7 ? 8 : 5);
if(royal != null)
{
long royalTax = (long) (amount * royal.getTaxRate()); // Find out what royal castle gets from the current castle instance's income
if(royal.getOwnerId() > 0)
{
royal.addToTreasury(royalTax, shop, seed); // Only bother to really add the tax to the treasury if not npc owned
if(_id == 5)
{
Log.add("Aden|" + royalTax + "|Castle:adenTax", "treasury");
}
else if(_id == 8)
{
Log.add("Rune|" + royalTax + "|Castle:runeTax", "treasury");
}
}
amount -= royalTax; // Subtract royal castle income from current castle instance's income
}
}
addToTreasuryNoTax(amount, shop, seed);
}
/**
* Add amount to castle instance's treasury (warehouse), no tax paying.
*/
public void addToTreasuryNoTax(long amount, boolean shop, boolean seed)
{
if(getOwnerId() <= 0)
{
return;
}
if(amount == 0)
{
return;
}
Stat.addAdena(amount);
// Add to the current treasury total. Use "-" to substract from treasury
_treasury = SafeMath.safeAddLongOrMax(_treasury, amount);
if(shop)
{
_collectedShops += amount;
}
if(seed)
{
_collectedSeed += amount;
}
ThreadConnection con = null;
FiltredPreparedStatement statement = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement("Update castle set treasury = ? where id = ?");
statement.setLong(1, getTreasury());
statement.setInt(2, getId());
statement.execute();
statement.close();
DatabaseUtils.closeDatabaseCS(con, statement);
}
catch(Exception e)
{
_log.warning("Exception: addToTreasuryNoTax(): " + e.getMessage());
e.printStackTrace();
}
finally
{
DatabaseUtils.closeDatabaseCS(con, statement);
}
}
public int getCropRewardType(int crop)
{
int rw = 0;
for(CropProcure cp : _procure)
{
if(cp.getId() == crop)
{
rw = cp.getReward();
}
}
return rw;
}
// This method updates the castle tax rate
public void setTaxPercent(L2Player activeChar, int taxPercent)
{
_TaxPercent = taxPercent;
_TaxRate = _TaxPercent / 100.0;
ThreadConnection con = null;
FiltredPreparedStatement statement = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement("UPDATE castle SET taxPercent = ? WHERE id = ? LIMIT 1");
statement.setInt(1, taxPercent);
statement.setInt(2, getId());
statement.execute();
}
catch(Exception e)
{
}
finally
{
DatabaseUtils.closeDatabaseCS(con, statement);
}
if(activeChar != null)
{
activeChar.sendMessage(new CustomMessage("l2p.gameserver.model.entity.Castle.OutOfControl.CastleTaxChangetTo", activeChar).addString(getName()).addNumber(taxPercent));
}
}
public double getTaxRate()
{
// Если печатью SEAL_STRIFE владеют DUSK то налог можно выставлять не более 5%
if(_TaxRate > 0.05 && SevenSigns.getInstance().getSealOwner(SevenSigns.SEAL_STRIFE) == SevenSigns.CABAL_DUSK)
{
_TaxRate = 0.05;
}
return _TaxRate;
}
public long getTreasury()
{
return _treasury;
}
/**
* Возвращает ID города, за которым закреплен замок
*
* @return идентификатор города
*/
public int getTown()
{
return _townId;
}
public GArray<SeedProduction> getSeedProduction(int period)
{
return period == CastleManorManager.PERIOD_CURRENT ? _production : _productionNext;
}
public GArray<CropProcure> getCropProcure(int period)
{
return period == CastleManorManager.PERIOD_CURRENT ? _procure : _procureNext;
}
public void setSeedProduction(GArray<SeedProduction> seed, int period)
{
if(period == CastleManorManager.PERIOD_CURRENT)
{
_production = seed;
}
else
{
_productionNext = seed;
}
}
public void setCropProcure(GArray<CropProcure> crop, int period)
{
if(period == CastleManorManager.PERIOD_CURRENT)
{
_procure = crop;
}
else
{
_procureNext = crop;
}
}
public synchronized SeedProduction getSeed(int seedId, int period)
{
for(SeedProduction seed : getSeedProduction(period))
{
if(seed.getId() == seedId)
{
return seed;
}
}
return null;
}
public synchronized CropProcure getCrop(int cropId, int period)
{
for(CropProcure crop : getCropProcure(period))
{
if(crop.getId() == cropId)
{
return crop;
}
}
return null;
}
public long getManorCost(int period)
{
GArray<CropProcure> procure;
GArray<SeedProduction> production;
if(period == CastleManorManager.PERIOD_CURRENT)
{
procure = _procure;
production = _production;
}
else
{
procure = _procureNext;
production = _productionNext;
}
long total = 0;
if(production != null)
{
for(SeedProduction seed : production)
{
total += L2Manor.getInstance().getSeedBuyPrice(seed.getId()) * seed.getStartProduce();
}
}
if(procure != null)
{
for(CropProcure crop : procure)
{
total += crop.getPrice() * crop.getStartAmount();
}
}
return total;
}
// Save manor production data
public void saveSeedData()
{
ThreadConnection con = null;
FiltredPreparedStatement statement = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement(CASTLE_MANOR_DELETE_PRODUCTION);
statement.setInt(1, getId());
statement.execute();
statement.close();
if(_production != null)
{
int count = 0;
String query = "INSERT INTO castle_manor_production VALUES ";
String values[] = new String[_production.size()];
for(SeedProduction s : _production)
{
values[count] = "(" + getId() + "," + s.getId() + "," + s.getCanProduce() + "," + s.getStartProduce() + "," + s.getPrice() + "," + CastleManorManager.PERIOD_CURRENT + ")";
count++;
}
if(values.length > 0)
{
query += values[0];
for(int i = 1; i < values.length; i++)
{
query += "," + values[i];
}
statement = con.prepareStatement(query);
statement.execute();
statement.close();
}
}
if(_productionNext != null)
{
int count = 0;
String query = "INSERT INTO castle_manor_production VALUES ";
String values[] = new String[_productionNext.size()];
for(SeedProduction s : _productionNext)
{
values[count] = "(" + getId() + "," + s.getId() + "," + s.getCanProduce() + "," + s.getStartProduce() + "," + s.getPrice() + "," + CastleManorManager.PERIOD_NEXT + ")";
count++;
}
if(values.length > 0)
{
query += values[0];
for(int i = 1; i < values.length; i++)
{
query += "," + values[i];
}
statement = con.prepareStatement(query);
statement.execute();
statement.close();
}
}
DatabaseUtils.closeDatabaseCS(con, statement);
}
catch(Exception e)
{
_log.info("Error adding seed production data for castle " + getName() + ": " + e.getMessage());
}
finally
{
DatabaseUtils.closeDatabaseCS(con, statement);
}
}
// Save manor production data for specified period
public void saveSeedData(int period)
{
ThreadConnection con = null;
FiltredPreparedStatement statement = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement(CASTLE_MANOR_DELETE_PRODUCTION_PERIOD);
statement.setInt(1, getId());
statement.setInt(2, period);
statement.execute();
statement.close();
GArray<SeedProduction> prod = null;
prod = getSeedProduction(period);
if(prod != null)
{
int count = 0;
String query = "INSERT INTO castle_manor_production VALUES ";
String values[] = new String[prod.size()];
for(SeedProduction s : prod)
{
values[count] = "(" + getId() + "," + s.getId() + "," + s.getCanProduce() + "," + s.getStartProduce() + "," + s.getPrice() + "," + period + ")";
count++;
}
if(values.length > 0)
{
query += values[0];
for(int i = 1; i < values.length; i++)
{
query += "," + values[i];
}
statement = con.prepareStatement(query);
statement.execute();
statement.close();
}
}
DatabaseUtils.closeDatabaseCS(con, statement);
}
catch(Exception e)
{
_log.info("Error adding seed production data for castle " + getName() + ": " + e.getMessage());
}
finally
{
DatabaseUtils.closeDatabaseCS(con, statement);
}
}
// Save crop procure data
public void saveCropData()
{
ThreadConnection con = null;
FiltredPreparedStatement statement = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement(CASTLE_MANOR_DELETE_PROCURE);
statement.setInt(1, getId());
statement.execute();
statement.close();
if(_procure != null)
{
int count = 0;
String query = "INSERT INTO castle_manor_procure VALUES ";
String values[] = new String[_procure.size()];
for(CropProcure cp : _procure)
{
values[count] = "(" + getId() + "," + cp.getId() + "," + cp.getAmount() + "," + cp.getStartAmount() + "," + cp.getPrice() + "," + cp.getReward() + "," + CastleManorManager.PERIOD_CURRENT + ")";
count++;
}
if(values.length > 0)
{
query += values[0];
for(int i = 1; i < values.length; i++)
{
query += "," + values[i];
}
statement = con.prepareStatement(query);
statement.execute();
statement.close();
}
}
if(_procureNext != null)
{
int count = 0;
String query = "INSERT INTO castle_manor_procure VALUES ";
String values[] = new String[_procureNext.size()];
for(CropProcure cp : _procureNext)
{
values[count] = "(" + getId() + "," + cp.getId() + "," + cp.getAmount() + "," + cp.getStartAmount() + "," + cp.getPrice() + "," + cp.getReward() + "," + CastleManorManager.PERIOD_NEXT + ")";
count++;
}
if(values.length > 0)
{
query += values[0];
for(int i = 1; i < values.length; i++)
{
query += "," + values[i];
}
statement = con.prepareStatement(query);
statement.execute();
statement.close();
}
}
DatabaseUtils.closeDatabaseCS(con, statement);
}
catch(Exception e)
{
_log.info("Error adding crop data for castle " + getName() + ": " + e.getMessage());
}
finally
{
DatabaseUtils.closeDatabaseCS(con, statement);
}
}
// Save crop procure data for specified period
public void saveCropData(int period)
{
ThreadConnection con = null;
FiltredPreparedStatement statement = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement(CASTLE_MANOR_DELETE_PROCURE_PERIOD);
statement.setInt(1, getId());
statement.setInt(2, period);
statement.execute();
statement.close();
GArray<CropProcure> proc = null;
proc = getCropProcure(period);
if(proc != null)
{
int count = 0;
String query = "INSERT INTO castle_manor_procure VALUES ";
String values[] = new String[proc.size()];
for(CropProcure cp : proc)
{
values[count] = "(" + getId() + "," + cp.getId() + "," + cp.getAmount() + "," + cp.getStartAmount() + "," + cp.getPrice() + "," + cp.getReward() + "," + period + ")";
count++;
}
if(values.length > 0)
{
query += values[0];
for(int i = 1; i < values.length; i++)
{
query += "," + values[i];
}
statement = con.prepareStatement(query);
statement.execute();
statement.close();
}
}
DatabaseUtils.closeDatabaseCS(con, statement);
}
catch(Exception e)
{
_log.info("Error adding crop data for castle " + getName() + ": " + e.getMessage());
}
finally
{
DatabaseUtils.closeDatabaseCS(con, statement);
}
}
public void updateCrop(int cropId, long amount, int period)
{
ThreadConnection con = null;
FiltredPreparedStatement statement = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement(CASTLE_UPDATE_CROP);
statement.setLong(1, amount);
statement.setInt(2, cropId);
statement.setInt(3, getId());
statement.setInt(4, period);
statement.execute();
statement.close();
}
catch(Exception e)
{
_log.info("Error adding crop data for castle " + getName() + ": " + e.getMessage());
}
finally
{
DatabaseUtils.closeDatabaseCS(con, statement);
}
}
public void updateSeed(int seedId, long amount, int period)
{
ThreadConnection con = null;
FiltredPreparedStatement statement = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement(CASTLE_UPDATE_SEED);
statement.setLong(1, amount);
statement.setInt(2, seedId);
statement.setInt(3, getId());
statement.setInt(4, period);
statement.execute();
statement.close();
}
catch(Exception e)
{
_log.info("Error adding seed production data for castle " + getName() + ": " + e.getMessage());
}
finally
{
DatabaseUtils.closeDatabaseCS(con, statement);
}
}
public boolean isNextPeriodApproved()
{
return _isNextPeriodApproved;
}
public void setNextPeriodApproved(boolean val)
{
_isNextPeriodApproved = val;
}
@Override
public void saveOwnDate()
{
ThreadConnection con = null;
FiltredPreparedStatement statement = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement("UPDATE castle SET ownDate = ? WHERE id = ?");
statement.setInt(1, getOwnerId() != 0 ? getOwnDate() : 0);
statement.setInt(2, getId());
statement.execute();
}
catch(Exception e)
{
System.out.println("Exception: saveOwnDate(): " + e.getMessage());
e.printStackTrace();
}
finally
{
DatabaseUtils.closeDatabaseCS(con, statement);
}
}
public synchronized void saveFlags()
{
String flags = "";
if(_flags.length > 0)
{
if(_flags.length > 1)
{
for(int i = 0; i < _flags.length - 1; i++)
{
flags = flags + _flags[i] + ";";
}
}
flags = flags + _flags[_flags.length - 1];
}
ThreadConnection con = null;
FiltredPreparedStatement statement = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement("UPDATE castle SET flags = ? WHERE id = ?");
statement.setString(1, flags);
statement.setInt(2, getId());
statement.execute();
}
catch(Exception e)
{
System.out.println("Exception: saveFlags(): " + e.getMessage());
e.printStackTrace();
}
finally
{
DatabaseUtils.closeDatabaseCS(con, statement);
}
}
}