L2ClanMember.java 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642
  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) return _player.getRace().ordinal();
  280. else return _raceOrdinal;
  281. }
  282. public boolean getSex()
  283. {
  284. if (_player != null) return _player.getAppearance().getSex();
  285. else return _sex;
  286. }
  287. public int getSponsor()
  288. {
  289. if (_player != null) return _player.getSponsor();
  290. else return _sponsor;
  291. }
  292. public int getApprentice()
  293. {
  294. if (_player != null) return _player.getApprentice();
  295. else return _apprentice;
  296. }
  297. public String getApprenticeOrSponsorName()
  298. {
  299. if(_player != null)
  300. {
  301. _apprentice = _player.getApprentice();
  302. _sponsor = _player.getSponsor();
  303. }
  304. if(_apprentice != 0)
  305. {
  306. L2ClanMember apprentice = _clan.getClanMember(_apprentice);
  307. if(apprentice != null) return apprentice.getName();
  308. else return "Error";
  309. }
  310. if(_sponsor != 0)
  311. {
  312. L2ClanMember sponsor = _clan.getClanMember(_sponsor);
  313. if(sponsor != null) return sponsor.getName();
  314. else return "Error";
  315. }
  316. return "";
  317. }
  318. public L2Clan getClan()
  319. {
  320. return _clan;
  321. }
  322. public int calculatePledgeClass(L2PcInstance player)
  323. {
  324. int pledgeClass = 0;
  325. if (player == null)
  326. return pledgeClass;
  327. L2Clan clan = player.getClan();
  328. if (clan != null)
  329. {
  330. switch (clan.getLevel())
  331. {
  332. case 4:
  333. if (player.isClanLeader())
  334. pledgeClass = 3;
  335. break;
  336. case 5:
  337. if (player.isClanLeader())
  338. pledgeClass = 4;
  339. else
  340. pledgeClass = 2;
  341. break;
  342. case 6:
  343. switch (player.getPledgeType())
  344. {
  345. case -1:
  346. pledgeClass = 1;
  347. break;
  348. case 100:
  349. case 200:
  350. pledgeClass = 2;
  351. break;
  352. case 0:
  353. if (player.isClanLeader())
  354. pledgeClass = 5;
  355. else
  356. switch (clan.getLeaderSubPledge(player.getObjectId()))
  357. {
  358. case 100:
  359. case 200:
  360. pledgeClass = 4;
  361. break;
  362. case -1:
  363. default:
  364. pledgeClass = 3;
  365. break;
  366. }
  367. break;
  368. }
  369. break;
  370. case 7:
  371. switch (player.getPledgeType())
  372. {
  373. case -1:
  374. pledgeClass = 1;
  375. break;
  376. case 100:
  377. case 200:
  378. pledgeClass = 3;
  379. break;
  380. case 1001:
  381. case 1002:
  382. case 2001:
  383. case 2002:
  384. pledgeClass = 2;
  385. break;
  386. case 0:
  387. if (player.isClanLeader())
  388. pledgeClass = 7;
  389. else
  390. switch (clan.getLeaderSubPledge(player.getObjectId()))
  391. {
  392. case 100:
  393. case 200:
  394. pledgeClass = 6;
  395. break;
  396. case 1001:
  397. case 1002:
  398. case 2001:
  399. case 2002:
  400. pledgeClass = 5;
  401. break;
  402. case -1:
  403. default:
  404. pledgeClass = 4;
  405. break;
  406. }
  407. break;
  408. }
  409. break;
  410. case 8:
  411. switch (player.getPledgeType())
  412. {
  413. case -1:
  414. pledgeClass = 1;
  415. break;
  416. case 100:
  417. case 200:
  418. pledgeClass = 4;
  419. break;
  420. case 1001:
  421. case 1002:
  422. case 2001:
  423. case 2002:
  424. pledgeClass = 3;
  425. break;
  426. case 0:
  427. if (player.isClanLeader())
  428. pledgeClass = 8;
  429. else
  430. switch (clan.getLeaderSubPledge(player.getObjectId()))
  431. {
  432. case 100:
  433. case 200:
  434. pledgeClass = 7;
  435. break;
  436. case 1001:
  437. case 1002:
  438. case 2001:
  439. case 2002:
  440. pledgeClass = 6;
  441. break;
  442. case -1:
  443. default:
  444. pledgeClass = 5;
  445. break;
  446. }
  447. break;
  448. }
  449. break;
  450. case 9:
  451. switch (player.getPledgeType())
  452. {
  453. case -1:
  454. pledgeClass = 1;
  455. break;
  456. case 100:
  457. case 200:
  458. pledgeClass = 5;
  459. break;
  460. case 1001:
  461. case 1002:
  462. case 2001:
  463. case 2002:
  464. pledgeClass = 4;
  465. break;
  466. case 0:
  467. if (player.isClanLeader())
  468. pledgeClass = 9;
  469. else
  470. switch (clan.getLeaderSubPledge(player.getObjectId()))
  471. {
  472. case 100:
  473. case 200:
  474. pledgeClass = 8;
  475. break;
  476. case 1001:
  477. case 1002:
  478. case 2001:
  479. case 2002:
  480. pledgeClass = 7;
  481. break;
  482. case -1:
  483. default:
  484. pledgeClass = 6;
  485. break;
  486. }
  487. break;
  488. }
  489. break;
  490. case 10:
  491. switch (player.getPledgeType())
  492. {
  493. case -1:
  494. pledgeClass = 1;
  495. break;
  496. case 100:
  497. case 200:
  498. pledgeClass = 6;
  499. break;
  500. case 1001:
  501. case 1002:
  502. case 2001:
  503. case 2002:
  504. pledgeClass = 5;
  505. break;
  506. case 0:
  507. if (player.isClanLeader())
  508. pledgeClass = 10;
  509. else
  510. switch (clan.getLeaderSubPledge(player.getObjectId()))
  511. {
  512. case 100:
  513. case 200:
  514. pledgeClass = 9;
  515. break;
  516. case 1001:
  517. case 1002:
  518. case 2001:
  519. case 2002:
  520. pledgeClass = 8;
  521. break;
  522. case -1:
  523. default:
  524. pledgeClass = 7;
  525. break;
  526. }
  527. break;
  528. }
  529. break;
  530. case 11:
  531. switch (player.getPledgeType())
  532. {
  533. case -1:
  534. pledgeClass = 1;
  535. break;
  536. case 100:
  537. case 200:
  538. pledgeClass = 7;
  539. break;
  540. case 1001:
  541. case 1002:
  542. case 2001:
  543. case 2002:
  544. pledgeClass = 6;
  545. break;
  546. case 0:
  547. if (player.isClanLeader())
  548. pledgeClass = 11;
  549. else
  550. switch (clan.getLeaderSubPledge(player.getObjectId()))
  551. {
  552. case 100:
  553. case 200:
  554. pledgeClass = 10;
  555. break;
  556. case 1001:
  557. case 1002:
  558. case 2001:
  559. case 2002:
  560. pledgeClass = 9;
  561. break;
  562. case -1:
  563. default:
  564. pledgeClass = 8;
  565. break;
  566. }
  567. break;
  568. }
  569. break;
  570. default:
  571. pledgeClass = 1;
  572. break;
  573. }
  574. }
  575. return pledgeClass;
  576. }
  577. public void saveApprenticeAndSponsor(int apprentice, int sponsor)
  578. {
  579. Connection con = null;
  580. try
  581. {
  582. con = L2DatabaseFactory.getInstance().getConnection();
  583. PreparedStatement statement = con.prepareStatement("UPDATE characters SET apprentice=?,sponsor=? WHERE charId=?");
  584. statement.setInt(1, apprentice);
  585. statement.setInt(2, sponsor);
  586. statement.setInt(3, getObjectId());
  587. statement.execute();
  588. statement.close();
  589. }
  590. catch (SQLException e)
  591. {
  592. _log.log(Level.WARNING, "Could not save apprentice/sponsor: " + e.getMessage(), e);
  593. }
  594. finally
  595. {
  596. L2DatabaseFactory.close(con);
  597. }
  598. }
  599. }