RaidBossPointsManager.java 6.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222
  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.sql.SQLException;
  20. import java.util.ArrayList;
  21. import java.util.Collections;
  22. import java.util.Comparator;
  23. import java.util.Map;
  24. import java.util.Map.Entry;
  25. import java.util.logging.Level;
  26. import java.util.logging.Logger;
  27. import javolution.util.FastMap;
  28. import com.l2jserver.L2DatabaseFactory;
  29. import com.l2jserver.gameserver.model.actor.instance.L2PcInstance;
  30. /**
  31. * @author Kerberos
  32. * JIV update 24.8.10
  33. */
  34. public class RaidBossPointsManager
  35. {
  36. private final static Logger _log = Logger.getLogger(RaidBossPointsManager.class.getName());
  37. private FastMap<Integer, Map<Integer, Integer>> _list;
  38. private final Comparator<Map.Entry<Integer, Integer>> _comparator = new Comparator<Map.Entry<Integer, Integer>>(){
  39. @Override
  40. public int compare(Map.Entry<Integer, Integer> entry, Map.Entry<Integer, Integer> entry1)
  41. {
  42. return entry.getValue().equals(entry1.getValue()) ? 0 : entry.getValue() < entry1.getValue() ? 1 : -1;
  43. }
  44. };
  45. public static final RaidBossPointsManager getInstance()
  46. {
  47. return SingletonHolder._instance;
  48. }
  49. public RaidBossPointsManager()
  50. {
  51. init();
  52. }
  53. private final void init()
  54. {
  55. _list = new FastMap<Integer, Map<Integer, Integer>>();
  56. Connection con = null;
  57. try
  58. {
  59. con = L2DatabaseFactory.getInstance().getConnection();
  60. PreparedStatement statement = con.prepareStatement("SELECT `charId`,`boss_id`,`points` FROM `character_raid_points`");
  61. ResultSet rset = statement.executeQuery();
  62. while(rset.next())
  63. {
  64. int charId = rset.getInt("charId");
  65. int bossId = rset.getInt("boss_id");
  66. int points = rset.getInt("points");
  67. Map<Integer, Integer> values = _list.get(charId);
  68. if (values == null)
  69. {
  70. values = new FastMap<Integer, Integer>();
  71. }
  72. values.put(bossId, points);
  73. _list.put(charId, values);
  74. }
  75. rset.close();
  76. statement.close();
  77. _log.info(getClass().getSimpleName()+": Loaded "+_list.size()+" Characters Raid Points.");
  78. }
  79. catch (SQLException e)
  80. {
  81. _log.log(Level.WARNING, "RaidPointsManager: Couldnt load raid points ", e);
  82. }
  83. finally
  84. {
  85. L2DatabaseFactory.close(con);
  86. }
  87. }
  88. public final void updatePointsInDB(L2PcInstance player, int raidId, int points)
  89. {
  90. Connection con = null;
  91. try
  92. {
  93. con = L2DatabaseFactory.getInstance().getConnection();
  94. PreparedStatement statement;
  95. statement = con.prepareStatement("REPLACE INTO character_raid_points (`charId`,`boss_id`,`points`) VALUES (?,?,?)");
  96. statement.setInt(1, player.getObjectId());
  97. statement.setInt(2, raidId);
  98. statement.setInt(3, points);
  99. statement.executeUpdate();
  100. statement.close();
  101. }
  102. catch (Exception e)
  103. {
  104. _log.log(Level.WARNING, "could not update char raid points:", e);
  105. }
  106. finally
  107. {
  108. L2DatabaseFactory.close(con);
  109. }
  110. }
  111. public final void addPoints(L2PcInstance player, int bossId, int points)
  112. {
  113. int ownerId = player.getObjectId();
  114. Map<Integer, Integer> tmpPoint = _list.get(ownerId);
  115. if(tmpPoint == null)
  116. {
  117. tmpPoint = new FastMap<Integer, Integer>();
  118. tmpPoint.put(bossId, points);
  119. updatePointsInDB(player, bossId, points);
  120. }
  121. else
  122. {
  123. int currentPoins = tmpPoint.containsKey(bossId) ? tmpPoint.get(bossId) : 0;
  124. currentPoins += points;
  125. tmpPoint.put(bossId, currentPoins);
  126. updatePointsInDB(player, bossId, currentPoins);
  127. }
  128. _list.put(ownerId, tmpPoint);
  129. }
  130. public final int getPointsByOwnerId(int ownerId)
  131. {
  132. Map<Integer, Integer> tmpPoint;
  133. tmpPoint = _list.get(ownerId);
  134. int totalPoints = 0;
  135. if (tmpPoint == null || tmpPoint.isEmpty())
  136. return 0;
  137. for(int points : tmpPoint.values())
  138. {
  139. totalPoints += points;
  140. }
  141. return totalPoints;
  142. }
  143. public final Map<Integer, Integer> getList(L2PcInstance player)
  144. {
  145. return _list.get(player.getObjectId());
  146. }
  147. public final void cleanUp()
  148. {
  149. Connection con = null;
  150. try
  151. {
  152. con = L2DatabaseFactory.getInstance().getConnection();
  153. PreparedStatement statement;
  154. statement = con.prepareStatement("DELETE from character_raid_points WHERE charId > 0");
  155. statement.executeUpdate();
  156. statement.close();
  157. _list.clear();
  158. }
  159. catch (Exception e)
  160. {
  161. _log.log(Level.WARNING, "could not clean raid points: ", e);
  162. }
  163. finally
  164. {
  165. L2DatabaseFactory.close(con);
  166. }
  167. }
  168. public final int calculateRanking(int playerObjId)
  169. {
  170. Map<Integer, Integer> rank = getRankList();
  171. if (rank.containsKey(playerObjId))
  172. return rank.get(playerObjId);
  173. return 0;
  174. }
  175. public Map<Integer, Integer> getRankList()
  176. {
  177. Map<Integer, Integer> tmpRanking = new FastMap<Integer, Integer>();
  178. Map<Integer, Integer> tmpPoints = new FastMap<Integer, Integer>();
  179. for(int ownerId : _list.keySet())
  180. {
  181. int totalPoints = getPointsByOwnerId(ownerId);
  182. if(totalPoints != 0)
  183. {
  184. tmpPoints.put(ownerId, totalPoints);
  185. }
  186. }
  187. ArrayList<Entry<Integer, Integer>> list = new ArrayList<Map.Entry<Integer, Integer>>(tmpPoints.entrySet());
  188. Collections.sort(list, _comparator);
  189. int ranking = 1;
  190. for(Map.Entry<Integer, Integer> entry : list)
  191. tmpRanking.put(entry.getKey(), ranking++);
  192. return tmpRanking;
  193. }
  194. @SuppressWarnings("synthetic-access")
  195. private static class SingletonHolder
  196. {
  197. protected static final RaidBossPointsManager _instance = new RaidBossPointsManager();
  198. }
  199. }