CastleManorManager.java 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610
  1. /*
  2. * This program is free software: you can redistribute it and/or modify it under
  3. * the terms of the GNU General Public License as published by the Free Software
  4. * Foundation, either version 3 of the License, or (at your option) any later
  5. * version.
  6. *
  7. * This program is distributed in the hope that it will be useful, but WITHOUT
  8. * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
  9. * FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
  10. * details.
  11. *
  12. * You should have received a copy of the GNU General Public License along with
  13. * this program. If not, see <http://www.gnu.org/licenses/>.
  14. */
  15. package com.l2jserver.gameserver.instancemanager;
  16. import java.sql.Connection;
  17. import java.sql.PreparedStatement;
  18. import java.sql.ResultSet;
  19. import java.util.Calendar;
  20. import java.util.concurrent.ScheduledFuture;
  21. import java.util.logging.Level;
  22. import java.util.logging.Logger;
  23. import com.l2jserver.Config;
  24. import com.l2jserver.L2DatabaseFactory;
  25. import com.l2jserver.gameserver.ThreadPoolManager;
  26. import com.l2jserver.gameserver.datatables.ClanTable;
  27. import com.l2jserver.gameserver.model.ClanWarehouse;
  28. import com.l2jserver.gameserver.model.L2Clan;
  29. import com.l2jserver.gameserver.model.L2Manor;
  30. import com.l2jserver.gameserver.model.L2World;
  31. import com.l2jserver.gameserver.model.actor.instance.L2PcInstance;
  32. import com.l2jserver.gameserver.model.entity.Castle;
  33. import com.l2jserver.gameserver.model.itemcontainer.ItemContainer;
  34. import com.l2jserver.gameserver.network.SystemMessageId;
  35. import com.l2jserver.gameserver.network.serverpackets.SystemMessage;
  36. import com.l2jserver.util.Rnd;
  37. import javolution.util.FastList;
  38. /**
  39. * Class For Castle Manor Manager Load manor data from DB Update/Reload/Delete
  40. * Handles all schedule for manor
  41. * @author l3x
  42. */
  43. public class CastleManorManager
  44. {
  45. protected static final Logger _log = Logger.getLogger(CastleManorManager.class.getName());
  46. public static final int PERIOD_CURRENT = 0;
  47. public static final int PERIOD_NEXT = 1;
  48. private static final String CASTLE_MANOR_LOAD_PROCURE = "SELECT * FROM castle_manor_procure WHERE castle_id=?";
  49. private static final String CASTLE_MANOR_LOAD_PRODUCTION = "SELECT * FROM castle_manor_production WHERE castle_id=?";
  50. private static final int NEXT_PERIOD_APPROVE = Config.ALT_MANOR_APPROVE_TIME; // 6:00
  51. private static final int NEXT_PERIOD_APPROVE_MIN = Config.ALT_MANOR_APPROVE_MIN; //
  52. private static final int MANOR_REFRESH = Config.ALT_MANOR_REFRESH_TIME; // 20:00
  53. private static final int MANOR_REFRESH_MIN = Config.ALT_MANOR_REFRESH_MIN; //
  54. protected static final long MAINTENANCE_PERIOD = Config.ALT_MANOR_MAINTENANCE_PERIOD; // 6 mins
  55. private Calendar _manorRefresh;
  56. private Calendar _periodApprove;
  57. private boolean _underMaintenance;
  58. private boolean _disabled;
  59. protected ScheduledFuture<?> _scheduledManorRefresh;
  60. protected ScheduledFuture<?> _scheduledMaintenanceEnd;
  61. protected ScheduledFuture<?> _scheduledNextPeriodapprove;
  62. public static final CastleManorManager getInstance()
  63. {
  64. return SingletonHolder._instance;
  65. }
  66. public class CropProcure
  67. {
  68. final int _cropId;
  69. long _buyResidual;
  70. final int _rewardType;
  71. final long _buy;
  72. final long _price;
  73. public CropProcure(int id)
  74. {
  75. _cropId = id;
  76. _buyResidual = 0;
  77. _rewardType = 0;
  78. _buy = 0;
  79. _price = 0;
  80. }
  81. public CropProcure(int id, long amount, int type, long buy, long price)
  82. {
  83. _cropId = id;
  84. _buyResidual = amount;
  85. _rewardType = type;
  86. _buy = buy;
  87. _price = price;
  88. }
  89. public int getReward()
  90. {
  91. return _rewardType;
  92. }
  93. public int getId()
  94. {
  95. return _cropId;
  96. }
  97. public long getAmount()
  98. {
  99. return _buyResidual;
  100. }
  101. public long getStartAmount()
  102. {
  103. return _buy;
  104. }
  105. public long getPrice()
  106. {
  107. return _price;
  108. }
  109. public void setAmount(long amount)
  110. {
  111. _buyResidual = amount;
  112. }
  113. }
  114. public class SeedProduction
  115. {
  116. final int _seedId;
  117. long _residual;
  118. final long _price;
  119. final long _sales;
  120. public SeedProduction(int id)
  121. {
  122. _seedId = id;
  123. _residual = 0;
  124. _price = 0;
  125. _sales = 0;
  126. }
  127. public SeedProduction(int id, long amount, long price, long sales)
  128. {
  129. _seedId = id;
  130. _residual = amount;
  131. _price = price;
  132. _sales = sales;
  133. }
  134. public int getId()
  135. {
  136. return _seedId;
  137. }
  138. public long getCanProduce()
  139. {
  140. return _residual;
  141. }
  142. public long getPrice()
  143. {
  144. return _price;
  145. }
  146. public long getStartProduce()
  147. {
  148. return _sales;
  149. }
  150. public void setCanProduce(long amount)
  151. {
  152. _residual = amount;
  153. }
  154. }
  155. private CastleManorManager()
  156. {
  157. _log.info("Initializing CastleManorManager");
  158. load(); // load data from database
  159. init(); // schedule all manor related events
  160. _underMaintenance = false;
  161. _disabled = !Config.ALLOW_MANOR;
  162. boolean isApproved;
  163. if (_periodApprove.getTimeInMillis() > _manorRefresh.getTimeInMillis())
  164. // Next approve period already scheduled
  165. isApproved = (_manorRefresh.getTimeInMillis() > Calendar.getInstance().getTimeInMillis());
  166. else
  167. isApproved = (_periodApprove.getTimeInMillis() < Calendar.getInstance().getTimeInMillis() && _manorRefresh.getTimeInMillis() > Calendar.getInstance().getTimeInMillis());
  168. for (Castle c : CastleManager.getInstance().getCastles())
  169. {
  170. c.setNextPeriodApproved(isApproved);
  171. }
  172. }
  173. private void load()
  174. {
  175. Connection con = null;
  176. ResultSet rs;
  177. try
  178. {
  179. // Get Connection
  180. con = L2DatabaseFactory.getInstance().getConnection();
  181. PreparedStatement statementProduction = con.prepareStatement(CASTLE_MANOR_LOAD_PRODUCTION);
  182. PreparedStatement statementProcure = con.prepareStatement(CASTLE_MANOR_LOAD_PROCURE);
  183. for (Castle castle : CastleManager.getInstance().getCastles())
  184. {
  185. FastList<SeedProduction> production = new FastList<SeedProduction>();
  186. FastList<SeedProduction> productionNext = new FastList<SeedProduction>();
  187. FastList<CropProcure> procure = new FastList<CropProcure>();
  188. FastList<CropProcure> procureNext = new FastList<CropProcure>();
  189. // restore seed production info
  190. statementProduction.setInt(1, castle.getCastleId());
  191. rs = statementProduction.executeQuery();
  192. statementProduction.clearParameters();
  193. while (rs.next())
  194. {
  195. int seedId = rs.getInt("seed_id");
  196. int canProduce = rs.getInt("can_produce");
  197. int startProduce = rs.getInt("start_produce");
  198. int price = rs.getInt("seed_price");
  199. int period = rs.getInt("period");
  200. if (period == PERIOD_CURRENT)
  201. production.add(new SeedProduction(seedId, canProduce, price, startProduce));
  202. else
  203. productionNext.add(new SeedProduction(seedId, canProduce, price, startProduce));
  204. }
  205. rs.close();
  206. castle.setSeedProduction(production, PERIOD_CURRENT);
  207. castle.setSeedProduction(productionNext, PERIOD_NEXT);
  208. // restore procure info
  209. statementProcure.setInt(1, castle.getCastleId());
  210. rs = statementProcure.executeQuery();
  211. statementProcure.clearParameters();
  212. while (rs.next())
  213. {
  214. int cropId = rs.getInt("crop_id");
  215. int canBuy = rs.getInt("can_buy");
  216. int startBuy = rs.getInt("start_buy");
  217. int rewardType = rs.getInt("reward_type");
  218. int price = rs.getInt("price");
  219. int period = rs.getInt("period");
  220. if (period == PERIOD_CURRENT)
  221. procure.add(new CropProcure(cropId, canBuy, rewardType, startBuy, price));
  222. else
  223. procureNext.add(new CropProcure(cropId, canBuy, rewardType, startBuy, price));
  224. }
  225. rs.close();
  226. castle.setCropProcure(procure, PERIOD_CURRENT);
  227. castle.setCropProcure(procureNext, PERIOD_NEXT);
  228. if (!procure.isEmpty() || !procureNext.isEmpty() || !production.isEmpty() || !productionNext.isEmpty())
  229. _log.info(castle.getName() + ": Data loaded");
  230. }
  231. statementProduction.close();
  232. statementProcure.close();
  233. }
  234. catch (Exception e)
  235. {
  236. _log.info("Error restoring manor data: " + e.getMessage());
  237. }
  238. finally
  239. {
  240. try
  241. {
  242. con.close();
  243. }
  244. catch (Exception e)
  245. {
  246. }
  247. }
  248. }
  249. private void init()
  250. {
  251. _manorRefresh = Calendar.getInstance();
  252. _manorRefresh.set(Calendar.HOUR_OF_DAY, MANOR_REFRESH);
  253. _manorRefresh.set(Calendar.MINUTE, MANOR_REFRESH_MIN);
  254. _periodApprove = Calendar.getInstance();
  255. _periodApprove.set(Calendar.HOUR_OF_DAY, NEXT_PERIOD_APPROVE);
  256. _periodApprove.set(Calendar.MINUTE, NEXT_PERIOD_APPROVE_MIN);
  257. updateManorRefresh();
  258. updatePeriodApprove();
  259. }
  260. public void updateManorRefresh()
  261. {
  262. _log.info("Manor System: Manor refresh updated");
  263. _scheduledManorRefresh = ThreadPoolManager.getInstance().scheduleGeneral(new Runnable()
  264. {
  265. public void run()
  266. {
  267. if (!isDisabled())
  268. {
  269. setUnderMaintenance(true);
  270. _log.info("Manor System: Under maintenance mode started");
  271. _scheduledMaintenanceEnd = ThreadPoolManager.getInstance().scheduleGeneral(new Runnable() {
  272. public void run()
  273. {
  274. _log.info("Manor System: Next period started");
  275. setNextPeriod();
  276. try
  277. {
  278. save();
  279. }
  280. catch (Exception e)
  281. {
  282. _log.log(Level.WARNING, "Manor System: Failed to save manor data: " + e.getMessage(), e);
  283. }
  284. setUnderMaintenance(false);
  285. }
  286. }, MAINTENANCE_PERIOD);
  287. }
  288. updateManorRefresh();
  289. }
  290. }, getMillisToManorRefresh());
  291. }
  292. public void updatePeriodApprove()
  293. {
  294. _log.info("Manor System: Manor period approve updated");
  295. _scheduledNextPeriodapprove = ThreadPoolManager.getInstance().scheduleGeneral(new Runnable()
  296. {
  297. public void run()
  298. {
  299. if (!isDisabled())
  300. {
  301. approveNextPeriod();
  302. _log.info("Manor System: Next period approved");
  303. }
  304. updatePeriodApprove();
  305. }
  306. }, getMillisToNextPeriodApprove());
  307. }
  308. public long getMillisToManorRefresh()
  309. {
  310. // use safe interval 120s to prevent double run
  311. if (_manorRefresh.getTimeInMillis() - Calendar.getInstance().getTimeInMillis() < 120000)
  312. setNewManorRefresh();
  313. _log.info("Manor System: New Schedule for manor refresh @ " + _manorRefresh.getTime());
  314. return (_manorRefresh.getTimeInMillis() - Calendar.getInstance().getTimeInMillis());
  315. }
  316. public void setNewManorRefresh()
  317. {
  318. _manorRefresh = Calendar.getInstance();
  319. _manorRefresh.set(Calendar.HOUR_OF_DAY, MANOR_REFRESH);
  320. _manorRefresh.set(Calendar.MINUTE, MANOR_REFRESH_MIN);
  321. _manorRefresh.set(Calendar.SECOND, 0);
  322. _manorRefresh.add(Calendar.HOUR_OF_DAY, 24);
  323. }
  324. public long getMillisToNextPeriodApprove()
  325. {
  326. // use safe interval 120s to prevent double run
  327. if (_periodApprove.getTimeInMillis() - Calendar.getInstance().getTimeInMillis() < 120000)
  328. setNewPeriodApprove();
  329. _log.info("Manor System: New Schedule for period approve @ " + _periodApprove.getTime());
  330. return (_periodApprove.getTimeInMillis() - Calendar.getInstance().getTimeInMillis());
  331. }
  332. public void setNewPeriodApprove()
  333. {
  334. _periodApprove = Calendar.getInstance();
  335. _periodApprove.set(Calendar.HOUR_OF_DAY, NEXT_PERIOD_APPROVE);
  336. _periodApprove.set(Calendar.MINUTE, NEXT_PERIOD_APPROVE_MIN);
  337. _periodApprove.set(Calendar.SECOND, 0);
  338. _periodApprove.add(Calendar.HOUR_OF_DAY, 24);
  339. }
  340. public void setNextPeriod()
  341. {
  342. for (Castle c : CastleManager.getInstance().getCastles())
  343. {
  344. if (c.getOwnerId() <= 0)
  345. continue;
  346. L2Clan clan = ClanTable.getInstance().getClan(c.getOwnerId());
  347. if (clan == null)
  348. continue;
  349. ItemContainer cwh = clan.getWarehouse();
  350. if (!(cwh instanceof ClanWarehouse))
  351. {
  352. _log.info("Can't get clan warehouse for clan " + ClanTable.getInstance().getClan(c.getOwnerId()));
  353. continue;
  354. }
  355. for (CropProcure crop : c.getCropProcure(PERIOD_CURRENT))
  356. {
  357. if (crop.getStartAmount() == 0)
  358. continue;
  359. // adding bought crops to clan warehouse
  360. if (crop.getStartAmount() - crop.getAmount() > 0)
  361. {
  362. long count = crop.getStartAmount() - crop.getAmount();
  363. count = count * 90 / 100;
  364. if (count < 1)
  365. {
  366. if (Rnd.nextInt(99) < 90)
  367. count = 1;
  368. }
  369. if (count > 0)
  370. {
  371. cwh.addItem("Manor", L2Manor.getInstance().getMatureCrop(crop.getId()), count, null, null);
  372. }
  373. }
  374. // reserved and not used money giving back to treasury
  375. if (crop.getAmount() > 0)
  376. {
  377. c.addToTreasuryNoTax(crop.getAmount() * crop.getPrice());
  378. }
  379. }
  380. c.setSeedProduction(c.getSeedProduction(PERIOD_NEXT), PERIOD_CURRENT);
  381. c.setCropProcure(c.getCropProcure(PERIOD_NEXT), PERIOD_CURRENT);
  382. if (c.getTreasury() < c.getManorCost(PERIOD_CURRENT))
  383. {
  384. c.setSeedProduction(getNewSeedsList(c.getCastleId()), PERIOD_NEXT);
  385. c.setCropProcure(getNewCropsList(c.getCastleId()), PERIOD_NEXT);
  386. }
  387. else
  388. {
  389. FastList<SeedProduction> production = new FastList<SeedProduction>();
  390. for (SeedProduction s : c.getSeedProduction(PERIOD_CURRENT))
  391. {
  392. s.setCanProduce(s.getStartProduce());
  393. production.add(s);
  394. }
  395. c.setSeedProduction(production, PERIOD_NEXT);
  396. FastList<CropProcure> procure = new FastList<CropProcure>();
  397. for (CropProcure cr : c.getCropProcure(PERIOD_CURRENT))
  398. {
  399. cr.setAmount(cr.getStartAmount());
  400. procure.add(cr);
  401. }
  402. c.setCropProcure(procure, PERIOD_NEXT);
  403. }
  404. if (Config.ALT_MANOR_SAVE_ALL_ACTIONS)
  405. {
  406. c.saveCropData();
  407. c.saveSeedData();
  408. }
  409. // Sending notification to a clan leader
  410. L2PcInstance clanLeader = null;
  411. clanLeader = L2World.getInstance().getPlayer(clan.getLeader().getName());
  412. if (clanLeader != null)
  413. clanLeader.sendPacket(new SystemMessage(SystemMessageId.THE_MANOR_INFORMATION_HAS_BEEN_UPDATED));
  414. c.setNextPeriodApproved(false);
  415. }
  416. }
  417. public void approveNextPeriod()
  418. {
  419. for (Castle c : CastleManager.getInstance().getCastles())
  420. {
  421. boolean notFunc = false;
  422. if (c.getOwnerId() <= 0)
  423. { // Castle has no owner
  424. c.setCropProcure(new FastList<CropProcure>(), PERIOD_NEXT);
  425. c.setSeedProduction(new FastList<SeedProduction>(), PERIOD_NEXT);
  426. }
  427. else if (c.getTreasury() < c.getManorCost(PERIOD_NEXT))
  428. {
  429. notFunc = true;
  430. _log.info("Manor for castle " + c.getName()
  431. + " disabled, not enough adena in treasury: "
  432. + c.getTreasury() + ", " + c.getManorCost(PERIOD_NEXT)
  433. + " required.");
  434. c.setSeedProduction(getNewSeedsList(c.getCastleId()), PERIOD_NEXT);
  435. c.setCropProcure(getNewCropsList(c.getCastleId()), PERIOD_NEXT);
  436. }
  437. else
  438. {
  439. ItemContainer cwh = ClanTable.getInstance().getClan(c.getOwnerId()).getWarehouse();
  440. if (!(cwh instanceof ClanWarehouse))
  441. {
  442. _log.info("Can't get clan warehouse for clan " + ClanTable.getInstance().getClan(c.getOwnerId()));
  443. continue;
  444. }
  445. int slots = 0;
  446. for (CropProcure crop : c.getCropProcure(PERIOD_NEXT))
  447. {
  448. if (crop.getStartAmount() > 0)
  449. {
  450. if (cwh.getItemByItemId(L2Manor.getInstance().getMatureCrop(crop.getId())) == null)
  451. slots++;
  452. }
  453. }
  454. if (!cwh.validateCapacity(slots))
  455. {
  456. notFunc = true;
  457. _log.info("Manor for castle " + c.getName()
  458. + " disabled, not enough free slots in clan warehouse: "
  459. + (Config.WAREHOUSE_SLOTS_CLAN - cwh.getSize())
  460. + ", but " + slots + " required.");
  461. c.setSeedProduction(getNewSeedsList(c.getCastleId()), PERIOD_NEXT);
  462. c.setCropProcure(getNewCropsList(c.getCastleId()), PERIOD_NEXT);
  463. }
  464. }
  465. c.setNextPeriodApproved(true);
  466. c.addToTreasuryNoTax((-1) * c.getManorCost(PERIOD_NEXT));
  467. if (notFunc)
  468. {
  469. L2Clan clan = ClanTable.getInstance().getClan(c.getOwnerId());
  470. L2PcInstance clanLeader = null;
  471. if (clan != null)
  472. clanLeader = L2World.getInstance().getPlayer(clan.getLeaderId());
  473. if (clanLeader != null)
  474. clanLeader.sendPacket(new SystemMessage(SystemMessageId.THE_AMOUNT_IS_NOT_SUFFICIENT_AND_SO_THE_MANOR_IS_NOT_IN_OPERATION));
  475. }
  476. }
  477. }
  478. private FastList<SeedProduction> getNewSeedsList(int castleId)
  479. {
  480. FastList<SeedProduction> seeds = new FastList<SeedProduction>();
  481. FastList<Integer> seedsIds = L2Manor.getInstance().getSeedsForCastle(castleId);
  482. for (int sd : seedsIds)
  483. {
  484. seeds.add(new SeedProduction(sd));
  485. }
  486. return seeds;
  487. }
  488. private FastList<CropProcure> getNewCropsList(int castleId)
  489. {
  490. FastList<CropProcure> crops = new FastList<CropProcure>();
  491. FastList<Integer> cropsIds = L2Manor.getInstance().getCropsForCastle(castleId);
  492. for (int cr : cropsIds)
  493. crops.add(new CropProcure(cr));
  494. return crops;
  495. }
  496. public boolean isUnderMaintenance()
  497. {
  498. return _underMaintenance;
  499. }
  500. public void setUnderMaintenance(boolean mode)
  501. {
  502. _underMaintenance = mode;
  503. }
  504. public boolean isDisabled()
  505. {
  506. return _disabled;
  507. }
  508. public void setDisabled(boolean mode)
  509. {
  510. _disabled = mode;
  511. }
  512. public SeedProduction getNewSeedProduction(int id, long amount, long price, long sales)
  513. {
  514. return new SeedProduction(id, amount, price, sales);
  515. }
  516. public CropProcure getNewCropProcure(int id, long amount, int type, long price, long buy)
  517. {
  518. return new CropProcure(id, amount, type, buy, price);
  519. }
  520. public void save()
  521. {
  522. for (Castle c : CastleManager.getInstance().getCastles())
  523. {
  524. c.saveSeedData();
  525. c.saveCropData();
  526. }
  527. }
  528. @SuppressWarnings("synthetic-access")
  529. private static class SingletonHolder
  530. {
  531. protected static final CastleManorManager _instance = new CastleManorManager();
  532. }
  533. }