L2ClanMember.java 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646
  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. Connection con = null;
  208. try
  209. {
  210. con = L2DatabaseFactory.getInstance().getConnection();
  211. PreparedStatement statement = con.prepareStatement("UPDATE characters SET subpledge=? WHERE charId=?");
  212. statement.setLong(1, _pledgeType);
  213. statement.setInt(2, getObjectId());
  214. statement.execute();
  215. statement.close();
  216. }
  217. catch (Exception e)
  218. {
  219. _log.log(Level.WARNING, "Could not update pledge type: " + e.getMessage(), e);
  220. }
  221. finally
  222. {
  223. L2DatabaseFactory.close(con);
  224. }
  225. }
  226. public int getPowerGrade()
  227. {
  228. if(_player != null)
  229. return _player.getPowerGrade();
  230. return _powerGrade;
  231. }
  232. /**
  233. * @param powerGrade
  234. */
  235. public void setPowerGrade(int powerGrade)
  236. {
  237. _powerGrade = powerGrade;
  238. if(_player != null)
  239. {
  240. _player.setPowerGrade(powerGrade);
  241. }
  242. else
  243. {
  244. // db save if char not logged in
  245. updatePowerGrade();
  246. }
  247. }
  248. /**
  249. * Update the characters table of the database with power grade.<BR><BR>
  250. */
  251. public void updatePowerGrade()
  252. {
  253. Connection con = null;
  254. try
  255. {
  256. con = L2DatabaseFactory.getInstance().getConnection();
  257. PreparedStatement statement = con.prepareStatement("UPDATE characters SET power_grade=? WHERE charId=?");
  258. statement.setLong(1, _powerGrade);
  259. statement.setInt(2, getObjectId());
  260. statement.execute();
  261. statement.close();
  262. }
  263. catch (Exception e)
  264. {
  265. _log.log(Level.WARNING, "Could not update power _grade: " + e.getMessage(), e);
  266. }
  267. finally
  268. {
  269. L2DatabaseFactory.close(con);
  270. }
  271. }
  272. public void initApprenticeAndSponsor(int apprenticeID, int sponsorID)
  273. {
  274. _apprentice = apprenticeID;
  275. _sponsor = sponsorID;
  276. }
  277. public int getRaceOrdinal()
  278. {
  279. if (_player != null)
  280. return _player.getRace().ordinal();
  281. return _raceOrdinal;
  282. }
  283. public boolean getSex()
  284. {
  285. if (_player != null)
  286. return _player.getAppearance().getSex();
  287. return _sex;
  288. }
  289. public int getSponsor()
  290. {
  291. if (_player != null)
  292. return _player.getSponsor();
  293. return _sponsor;
  294. }
  295. public int getApprentice()
  296. {
  297. if (_player != null)
  298. return _player.getApprentice();
  299. return _apprentice;
  300. }
  301. public String getApprenticeOrSponsorName()
  302. {
  303. if(_player != null)
  304. {
  305. _apprentice = _player.getApprentice();
  306. _sponsor = _player.getSponsor();
  307. }
  308. if(_apprentice != 0)
  309. {
  310. L2ClanMember apprentice = _clan.getClanMember(_apprentice);
  311. if(apprentice != null)
  312. return apprentice.getName();
  313. return "Error";
  314. }
  315. if(_sponsor != 0)
  316. {
  317. L2ClanMember sponsor = _clan.getClanMember(_sponsor);
  318. if(sponsor != null)
  319. return sponsor.getName();
  320. return "Error";
  321. }
  322. return "";
  323. }
  324. public L2Clan getClan()
  325. {
  326. return _clan;
  327. }
  328. public int calculatePledgeClass(L2PcInstance player)
  329. {
  330. int pledgeClass = 0;
  331. if (player == null)
  332. return pledgeClass;
  333. L2Clan clan = player.getClan();
  334. if (clan != null)
  335. {
  336. switch (clan.getLevel())
  337. {
  338. case 4:
  339. if (player.isClanLeader())
  340. pledgeClass = 3;
  341. break;
  342. case 5:
  343. if (player.isClanLeader())
  344. pledgeClass = 4;
  345. else
  346. pledgeClass = 2;
  347. break;
  348. case 6:
  349. switch (player.getPledgeType())
  350. {
  351. case -1:
  352. pledgeClass = 1;
  353. break;
  354. case 100:
  355. case 200:
  356. pledgeClass = 2;
  357. break;
  358. case 0:
  359. if (player.isClanLeader())
  360. pledgeClass = 5;
  361. else
  362. switch (clan.getLeaderSubPledge(player.getObjectId()))
  363. {
  364. case 100:
  365. case 200:
  366. pledgeClass = 4;
  367. break;
  368. case -1:
  369. default:
  370. pledgeClass = 3;
  371. break;
  372. }
  373. break;
  374. }
  375. break;
  376. case 7:
  377. switch (player.getPledgeType())
  378. {
  379. case -1:
  380. pledgeClass = 1;
  381. break;
  382. case 100:
  383. case 200:
  384. pledgeClass = 3;
  385. break;
  386. case 1001:
  387. case 1002:
  388. case 2001:
  389. case 2002:
  390. pledgeClass = 2;
  391. break;
  392. case 0:
  393. if (player.isClanLeader())
  394. pledgeClass = 7;
  395. else
  396. switch (clan.getLeaderSubPledge(player.getObjectId()))
  397. {
  398. case 100:
  399. case 200:
  400. pledgeClass = 6;
  401. break;
  402. case 1001:
  403. case 1002:
  404. case 2001:
  405. case 2002:
  406. pledgeClass = 5;
  407. break;
  408. case -1:
  409. default:
  410. pledgeClass = 4;
  411. break;
  412. }
  413. break;
  414. }
  415. break;
  416. case 8:
  417. switch (player.getPledgeType())
  418. {
  419. case -1:
  420. pledgeClass = 1;
  421. break;
  422. case 100:
  423. case 200:
  424. pledgeClass = 4;
  425. break;
  426. case 1001:
  427. case 1002:
  428. case 2001:
  429. case 2002:
  430. pledgeClass = 3;
  431. break;
  432. case 0:
  433. if (player.isClanLeader())
  434. pledgeClass = 8;
  435. else
  436. switch (clan.getLeaderSubPledge(player.getObjectId()))
  437. {
  438. case 100:
  439. case 200:
  440. pledgeClass = 7;
  441. break;
  442. case 1001:
  443. case 1002:
  444. case 2001:
  445. case 2002:
  446. pledgeClass = 6;
  447. break;
  448. case -1:
  449. default:
  450. pledgeClass = 5;
  451. break;
  452. }
  453. break;
  454. }
  455. break;
  456. case 9:
  457. switch (player.getPledgeType())
  458. {
  459. case -1:
  460. pledgeClass = 1;
  461. break;
  462. case 100:
  463. case 200:
  464. pledgeClass = 5;
  465. break;
  466. case 1001:
  467. case 1002:
  468. case 2001:
  469. case 2002:
  470. pledgeClass = 4;
  471. break;
  472. case 0:
  473. if (player.isClanLeader())
  474. pledgeClass = 9;
  475. else
  476. switch (clan.getLeaderSubPledge(player.getObjectId()))
  477. {
  478. case 100:
  479. case 200:
  480. pledgeClass = 8;
  481. break;
  482. case 1001:
  483. case 1002:
  484. case 2001:
  485. case 2002:
  486. pledgeClass = 7;
  487. break;
  488. case -1:
  489. default:
  490. pledgeClass = 6;
  491. break;
  492. }
  493. break;
  494. }
  495. break;
  496. case 10:
  497. switch (player.getPledgeType())
  498. {
  499. case -1:
  500. pledgeClass = 1;
  501. break;
  502. case 100:
  503. case 200:
  504. pledgeClass = 6;
  505. break;
  506. case 1001:
  507. case 1002:
  508. case 2001:
  509. case 2002:
  510. pledgeClass = 5;
  511. break;
  512. case 0:
  513. if (player.isClanLeader())
  514. pledgeClass = 10;
  515. else
  516. switch (clan.getLeaderSubPledge(player.getObjectId()))
  517. {
  518. case 100:
  519. case 200:
  520. pledgeClass = 9;
  521. break;
  522. case 1001:
  523. case 1002:
  524. case 2001:
  525. case 2002:
  526. pledgeClass = 8;
  527. break;
  528. case -1:
  529. default:
  530. pledgeClass = 7;
  531. break;
  532. }
  533. break;
  534. }
  535. break;
  536. case 11:
  537. switch (player.getPledgeType())
  538. {
  539. case -1:
  540. pledgeClass = 1;
  541. break;
  542. case 100:
  543. case 200:
  544. pledgeClass = 7;
  545. break;
  546. case 1001:
  547. case 1002:
  548. case 2001:
  549. case 2002:
  550. pledgeClass = 6;
  551. break;
  552. case 0:
  553. if (player.isClanLeader())
  554. pledgeClass = 11;
  555. else
  556. switch (clan.getLeaderSubPledge(player.getObjectId()))
  557. {
  558. case 100:
  559. case 200:
  560. pledgeClass = 10;
  561. break;
  562. case 1001:
  563. case 1002:
  564. case 2001:
  565. case 2002:
  566. pledgeClass = 9;
  567. break;
  568. case -1:
  569. default:
  570. pledgeClass = 8;
  571. break;
  572. }
  573. break;
  574. }
  575. break;
  576. default:
  577. pledgeClass = 1;
  578. break;
  579. }
  580. }
  581. return pledgeClass;
  582. }
  583. public void saveApprenticeAndSponsor(int apprentice, int sponsor)
  584. {
  585. Connection con = null;
  586. try
  587. {
  588. con = L2DatabaseFactory.getInstance().getConnection();
  589. PreparedStatement statement = con.prepareStatement("UPDATE characters SET apprentice=?,sponsor=? WHERE charId=?");
  590. statement.setInt(1, apprentice);
  591. statement.setInt(2, sponsor);
  592. statement.setInt(3, getObjectId());
  593. statement.execute();
  594. statement.close();
  595. }
  596. catch (SQLException e)
  597. {
  598. _log.log(Level.WARNING, "Could not save apprentice/sponsor: " + e.getMessage(), e);
  599. }
  600. finally
  601. {
  602. L2DatabaseFactory.close(con);
  603. }
  604. }
  605. }