L2ClanMember.java 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626
  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.model;
  16. import java.sql.Connection;
  17. import java.sql.PreparedStatement;
  18. import java.sql.SQLException;
  19. import java.util.logging.Level;
  20. import java.util.logging.Logger;
  21. import com.l2jserver.L2DatabaseFactory;
  22. import com.l2jserver.gameserver.instancemanager.SiegeManager;
  23. import com.l2jserver.gameserver.model.actor.instance.L2PcInstance;
  24. /**
  25. * Clan member class.
  26. */
  27. public class L2ClanMember
  28. {
  29. private static final Logger _log = Logger.getLogger(L2ClanMember.class.getName());
  30. private L2Clan _clan;
  31. private int _objectId;
  32. private String _name;
  33. private String _title;
  34. private int _powerGrade;
  35. private int _level;
  36. private int _classId;
  37. private boolean _sex;
  38. private int _raceOrdinal;
  39. private L2PcInstance _player;
  40. private int _pledgeType;
  41. private int _apprentice;
  42. private int _sponsor;
  43. public L2ClanMember(L2Clan clan, String name, int level, int classId, int objectId, int pledgeType, int powerGrade, String title, boolean sex, int raceOrdinal)
  44. {
  45. if(clan == null)
  46. throw new IllegalArgumentException("Can not create a ClanMember with a null clan.");
  47. _clan = clan;
  48. _name = name;
  49. _level = level;
  50. _classId = classId;
  51. _objectId = objectId;
  52. _powerGrade = powerGrade;
  53. _title = title;
  54. _pledgeType = pledgeType;
  55. _apprentice = 0;
  56. _sponsor = 0;
  57. _sex = sex;
  58. _raceOrdinal = raceOrdinal;
  59. }
  60. public L2ClanMember(L2Clan clan, L2PcInstance player)
  61. {
  62. _clan = clan;
  63. _name = player.getName();
  64. _level = player.getLevel();
  65. _classId = player.getClassId().getId();
  66. _objectId = player.getObjectId();
  67. _pledgeType = player.getPledgeType();
  68. _powerGrade = player.getPowerGrade();
  69. _title = player.getTitle();
  70. _sponsor = 0;
  71. _apprentice = 0;
  72. _sex = player.getAppearance().getSex();
  73. _raceOrdinal = player.getRace().ordinal();
  74. }
  75. public L2ClanMember(L2PcInstance player)
  76. {
  77. if(player.getClan() == null)
  78. throw new IllegalArgumentException("Can not create a ClanMember if player has a null clan.");
  79. _clan = player.getClan();
  80. _player = player;
  81. _name = _player.getName();
  82. _level = _player.getLevel();
  83. _classId = _player.getClassId().getId();
  84. _objectId = _player.getObjectId();
  85. _powerGrade = _player.getPowerGrade();
  86. _pledgeType = _player.getPledgeType();
  87. _title = _player.getTitle();
  88. _apprentice = 0;
  89. _sponsor = 0;
  90. _sex = _player.getAppearance().getSex();
  91. _raceOrdinal = _player.getRace().ordinal();
  92. }
  93. public void setPlayerInstance(L2PcInstance player)
  94. {
  95. if (player == null && _player != null)
  96. {
  97. // this is here to keep the data when the player logs off
  98. _name = _player.getName();
  99. _level = _player.getLevel();
  100. _classId = _player.getClassId().getId();
  101. _objectId = _player.getObjectId();
  102. _powerGrade = _player.getPowerGrade();
  103. _pledgeType = _player.getPledgeType();
  104. _title = _player.getTitle();
  105. _apprentice = _player.getApprentice();
  106. _sponsor = _player.getSponsor();
  107. _sex = _player.getAppearance().getSex();
  108. _raceOrdinal = _player.getRace().ordinal();
  109. }
  110. if (player != null)
  111. {
  112. _clan.addSkillEffects(player);
  113. if (_clan.getLevel() > 3 && player.isClanLeader())
  114. SiegeManager.getInstance().addSiegeSkills(player);
  115. if (player.isClanLeader())
  116. _clan.setLeader(this);
  117. }
  118. _player = player;
  119. }
  120. public L2PcInstance getPlayerInstance()
  121. {
  122. return _player;
  123. }
  124. public boolean isOnline()
  125. {
  126. if (_player == null || !_player.isOnline())
  127. return false;
  128. if (_player.getClient() == null)
  129. return false;
  130. if (_player.getClient().isDetached())
  131. return false;
  132. return true;
  133. }
  134. /**
  135. * @return Returns the classId.
  136. */
  137. public int getClassId()
  138. {
  139. if (_player != null)
  140. {
  141. return _player.getClassId().getId();
  142. }
  143. return _classId;
  144. }
  145. /**
  146. * @return Returns the level.
  147. */
  148. public int getLevel()
  149. {
  150. if (_player != null)
  151. {
  152. return _player.getLevel();
  153. }
  154. return _level;
  155. }
  156. /**
  157. * @return Returns the name.
  158. */
  159. public String getName()
  160. {
  161. if (_player != null)
  162. {
  163. return _player.getName();
  164. }
  165. return _name;
  166. }
  167. /**
  168. * @return Returns the objectId.
  169. */
  170. public int getObjectId()
  171. {
  172. if (_player != null)
  173. {
  174. return _player.getObjectId();
  175. }
  176. return _objectId;
  177. }
  178. public String getTitle() {
  179. if (_player != null) {
  180. return _player.getTitle();
  181. }
  182. return _title;
  183. }
  184. public int getPledgeType()
  185. {
  186. if (_player != null)
  187. {
  188. return _player.getPledgeType();
  189. }
  190. return _pledgeType;
  191. }
  192. public void setPledgeType(int pledgeType)
  193. {
  194. _pledgeType = pledgeType;
  195. if(_player != null)
  196. {
  197. _player.setPledgeType(pledgeType);
  198. }
  199. else
  200. {
  201. //db save if char not logged in
  202. updatePledgeType();
  203. }
  204. }
  205. public void updatePledgeType()
  206. {
  207. try (Connection con = L2DatabaseFactory.getInstance().getConnection())
  208. {
  209. PreparedStatement statement = con.prepareStatement("UPDATE characters SET subpledge=? WHERE charId=?");
  210. statement.setLong(1, _pledgeType);
  211. statement.setInt(2, getObjectId());
  212. statement.execute();
  213. statement.close();
  214. }
  215. catch (Exception e)
  216. {
  217. _log.log(Level.WARNING, "Could not update pledge type: " + e.getMessage(), e);
  218. }
  219. }
  220. public int getPowerGrade()
  221. {
  222. if(_player != null)
  223. return _player.getPowerGrade();
  224. return _powerGrade;
  225. }
  226. /**
  227. * @param powerGrade
  228. */
  229. public void setPowerGrade(int powerGrade)
  230. {
  231. _powerGrade = powerGrade;
  232. if(_player != null)
  233. {
  234. _player.setPowerGrade(powerGrade);
  235. }
  236. else
  237. {
  238. // db save if char not logged in
  239. updatePowerGrade();
  240. }
  241. }
  242. /**
  243. * Update the characters table of the database with power grade.<BR><BR>
  244. */
  245. public void updatePowerGrade()
  246. {
  247. try (Connection con = L2DatabaseFactory.getInstance().getConnection())
  248. {
  249. PreparedStatement statement = con.prepareStatement("UPDATE characters SET power_grade=? WHERE charId=?");
  250. statement.setLong(1, _powerGrade);
  251. statement.setInt(2, getObjectId());
  252. statement.execute();
  253. statement.close();
  254. }
  255. catch (Exception e)
  256. {
  257. _log.log(Level.WARNING, "Could not update power _grade: " + e.getMessage(), e);
  258. }
  259. }
  260. public void initApprenticeAndSponsor(int apprenticeID, int sponsorID)
  261. {
  262. _apprentice = apprenticeID;
  263. _sponsor = sponsorID;
  264. }
  265. public int getRaceOrdinal()
  266. {
  267. if (_player != null)
  268. return _player.getRace().ordinal();
  269. return _raceOrdinal;
  270. }
  271. public boolean getSex()
  272. {
  273. if (_player != null)
  274. return _player.getAppearance().getSex();
  275. return _sex;
  276. }
  277. public int getSponsor()
  278. {
  279. if (_player != null)
  280. return _player.getSponsor();
  281. return _sponsor;
  282. }
  283. public int getApprentice()
  284. {
  285. if (_player != null)
  286. return _player.getApprentice();
  287. return _apprentice;
  288. }
  289. public String getApprenticeOrSponsorName()
  290. {
  291. if(_player != null)
  292. {
  293. _apprentice = _player.getApprentice();
  294. _sponsor = _player.getSponsor();
  295. }
  296. if(_apprentice != 0)
  297. {
  298. L2ClanMember apprentice = _clan.getClanMember(_apprentice);
  299. if(apprentice != null)
  300. return apprentice.getName();
  301. return "Error";
  302. }
  303. if(_sponsor != 0)
  304. {
  305. L2ClanMember sponsor = _clan.getClanMember(_sponsor);
  306. if(sponsor != null)
  307. return sponsor.getName();
  308. return "Error";
  309. }
  310. return "";
  311. }
  312. public L2Clan getClan()
  313. {
  314. return _clan;
  315. }
  316. public int calculatePledgeClass(L2PcInstance player)
  317. {
  318. int pledgeClass = 0;
  319. if (player == null)
  320. return pledgeClass;
  321. L2Clan clan = player.getClan();
  322. if (clan != null)
  323. {
  324. switch (clan.getLevel())
  325. {
  326. case 4:
  327. if (player.isClanLeader())
  328. pledgeClass = 3;
  329. break;
  330. case 5:
  331. if (player.isClanLeader())
  332. pledgeClass = 4;
  333. else
  334. pledgeClass = 2;
  335. break;
  336. case 6:
  337. switch (player.getPledgeType())
  338. {
  339. case -1:
  340. pledgeClass = 1;
  341. break;
  342. case 100:
  343. case 200:
  344. pledgeClass = 2;
  345. break;
  346. case 0:
  347. if (player.isClanLeader())
  348. pledgeClass = 5;
  349. else
  350. switch (clan.getLeaderSubPledge(player.getObjectId()))
  351. {
  352. case 100:
  353. case 200:
  354. pledgeClass = 4;
  355. break;
  356. case -1:
  357. default:
  358. pledgeClass = 3;
  359. break;
  360. }
  361. break;
  362. }
  363. break;
  364. case 7:
  365. switch (player.getPledgeType())
  366. {
  367. case -1:
  368. pledgeClass = 1;
  369. break;
  370. case 100:
  371. case 200:
  372. pledgeClass = 3;
  373. break;
  374. case 1001:
  375. case 1002:
  376. case 2001:
  377. case 2002:
  378. pledgeClass = 2;
  379. break;
  380. case 0:
  381. if (player.isClanLeader())
  382. pledgeClass = 7;
  383. else
  384. switch (clan.getLeaderSubPledge(player.getObjectId()))
  385. {
  386. case 100:
  387. case 200:
  388. pledgeClass = 6;
  389. break;
  390. case 1001:
  391. case 1002:
  392. case 2001:
  393. case 2002:
  394. pledgeClass = 5;
  395. break;
  396. case -1:
  397. default:
  398. pledgeClass = 4;
  399. break;
  400. }
  401. break;
  402. }
  403. break;
  404. case 8:
  405. switch (player.getPledgeType())
  406. {
  407. case -1:
  408. pledgeClass = 1;
  409. break;
  410. case 100:
  411. case 200:
  412. pledgeClass = 4;
  413. break;
  414. case 1001:
  415. case 1002:
  416. case 2001:
  417. case 2002:
  418. pledgeClass = 3;
  419. break;
  420. case 0:
  421. if (player.isClanLeader())
  422. pledgeClass = 8;
  423. else
  424. switch (clan.getLeaderSubPledge(player.getObjectId()))
  425. {
  426. case 100:
  427. case 200:
  428. pledgeClass = 7;
  429. break;
  430. case 1001:
  431. case 1002:
  432. case 2001:
  433. case 2002:
  434. pledgeClass = 6;
  435. break;
  436. case -1:
  437. default:
  438. pledgeClass = 5;
  439. break;
  440. }
  441. break;
  442. }
  443. break;
  444. case 9:
  445. switch (player.getPledgeType())
  446. {
  447. case -1:
  448. pledgeClass = 1;
  449. break;
  450. case 100:
  451. case 200:
  452. pledgeClass = 5;
  453. break;
  454. case 1001:
  455. case 1002:
  456. case 2001:
  457. case 2002:
  458. pledgeClass = 4;
  459. break;
  460. case 0:
  461. if (player.isClanLeader())
  462. pledgeClass = 9;
  463. else
  464. switch (clan.getLeaderSubPledge(player.getObjectId()))
  465. {
  466. case 100:
  467. case 200:
  468. pledgeClass = 8;
  469. break;
  470. case 1001:
  471. case 1002:
  472. case 2001:
  473. case 2002:
  474. pledgeClass = 7;
  475. break;
  476. case -1:
  477. default:
  478. pledgeClass = 6;
  479. break;
  480. }
  481. break;
  482. }
  483. break;
  484. case 10:
  485. switch (player.getPledgeType())
  486. {
  487. case -1:
  488. pledgeClass = 1;
  489. break;
  490. case 100:
  491. case 200:
  492. pledgeClass = 6;
  493. break;
  494. case 1001:
  495. case 1002:
  496. case 2001:
  497. case 2002:
  498. pledgeClass = 5;
  499. break;
  500. case 0:
  501. if (player.isClanLeader())
  502. pledgeClass = 10;
  503. else
  504. switch (clan.getLeaderSubPledge(player.getObjectId()))
  505. {
  506. case 100:
  507. case 200:
  508. pledgeClass = 9;
  509. break;
  510. case 1001:
  511. case 1002:
  512. case 2001:
  513. case 2002:
  514. pledgeClass = 8;
  515. break;
  516. case -1:
  517. default:
  518. pledgeClass = 7;
  519. break;
  520. }
  521. break;
  522. }
  523. break;
  524. case 11:
  525. switch (player.getPledgeType())
  526. {
  527. case -1:
  528. pledgeClass = 1;
  529. break;
  530. case 100:
  531. case 200:
  532. pledgeClass = 7;
  533. break;
  534. case 1001:
  535. case 1002:
  536. case 2001:
  537. case 2002:
  538. pledgeClass = 6;
  539. break;
  540. case 0:
  541. if (player.isClanLeader())
  542. pledgeClass = 11;
  543. else
  544. switch (clan.getLeaderSubPledge(player.getObjectId()))
  545. {
  546. case 100:
  547. case 200:
  548. pledgeClass = 10;
  549. break;
  550. case 1001:
  551. case 1002:
  552. case 2001:
  553. case 2002:
  554. pledgeClass = 9;
  555. break;
  556. case -1:
  557. default:
  558. pledgeClass = 8;
  559. break;
  560. }
  561. break;
  562. }
  563. break;
  564. default:
  565. pledgeClass = 1;
  566. break;
  567. }
  568. }
  569. return pledgeClass;
  570. }
  571. public void saveApprenticeAndSponsor(int apprentice, int sponsor)
  572. {
  573. try (Connection con = L2DatabaseFactory.getInstance().getConnection())
  574. {
  575. PreparedStatement statement = con.prepareStatement("UPDATE characters SET apprentice=?,sponsor=? WHERE charId=?");
  576. statement.setInt(1, apprentice);
  577. statement.setInt(2, sponsor);
  578. statement.setInt(3, getObjectId());
  579. statement.execute();
  580. statement.close();
  581. }
  582. catch (SQLException e)
  583. {
  584. _log.log(Level.WARNING, "Could not save apprentice/sponsor: " + e.getMessage(), e);
  585. }
  586. }
  587. }