CastleManorManager.java 17 KB

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