PetDataTable.java 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394
  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.datatables;
  16. import gnu.trove.TIntObjectHashMap;
  17. import java.sql.Connection;
  18. import java.sql.PreparedStatement;
  19. import java.sql.ResultSet;
  20. import java.util.logging.Level;
  21. import java.util.logging.Logger;
  22. import com.l2jserver.L2DatabaseFactory;
  23. import com.l2jserver.gameserver.model.L2PetData;
  24. import com.l2jserver.gameserver.model.actor.instance.L2PetInstance;
  25. public class PetDataTable
  26. {
  27. private static Logger _log = Logger.getLogger(L2PetInstance.class.getName());
  28. private static TIntObjectHashMap<TIntObjectHashMap<L2PetData>> _petTable;
  29. public static PetDataTable getInstance()
  30. {
  31. return SingletonHolder._instance;
  32. }
  33. private PetDataTable()
  34. {
  35. _petTable = new TIntObjectHashMap<TIntObjectHashMap<L2PetData>>();
  36. }
  37. public void loadPetsData()
  38. {
  39. Connection con = null;
  40. try
  41. {
  42. con = L2DatabaseFactory.getInstance().getConnection();
  43. PreparedStatement statement = con.prepareStatement("SELECT typeID, level, expMax, hpMax, mpMax, patk, pdef, matk, mdef, acc, evasion, crit, speed, atk_speed, cast_speed, feedMax, feedbattle, feednormal, loadMax, hpregen, mpregen, owner_exp_taken, soulshot_count, spiritshot_count FROM pets_stats");
  44. ResultSet rset = statement.executeQuery();
  45. int petId, petLevel;
  46. while (rset.next())
  47. {
  48. petId = rset.getInt("typeID");
  49. petLevel = rset.getInt("level");
  50. //build the petdata for this level
  51. L2PetData petData = new L2PetData();
  52. petData.setPetID(petId);
  53. petData.setPetLevel(petLevel);
  54. petData.setPetMaxExp(rset.getLong("expMax"));
  55. petData.setPetMaxHP(rset.getInt("hpMax"));
  56. petData.setPetMaxMP(rset.getInt("mpMax"));
  57. petData.setPetPAtk(rset.getInt("patk"));
  58. petData.setPetPDef(rset.getInt("pdef"));
  59. petData.setPetMAtk(rset.getInt("matk"));
  60. petData.setPetMDef(rset.getInt("mdef"));
  61. petData.setPetAccuracy(rset.getInt("acc"));
  62. petData.setPetEvasion(rset.getInt("evasion"));
  63. petData.setPetCritical(rset.getInt("crit"));
  64. petData.setPetSpeed(rset.getInt("speed"));
  65. petData.setPetAtkSpeed(rset.getInt("atk_speed"));
  66. petData.setPetCastSpeed(rset.getInt("cast_speed"));
  67. petData.setPetMaxFeed(rset.getInt("feedMax"));
  68. petData.setPetFeedNormal(rset.getInt("feednormal"));
  69. petData.setPetFeedBattle(rset.getInt("feedbattle"));
  70. petData.setPetMaxLoad(rset.getInt("loadMax"));
  71. petData.setPetRegenHP(rset.getInt("hpregen"));
  72. petData.setPetRegenMP(rset.getInt("mpregen"));
  73. petData.setOwnerExpTaken(rset.getFloat("owner_exp_taken"));
  74. petData.setPetSoulShot((short) rset.getInt("soulshot_count"));
  75. petData.setPetSpiritShot((short) rset.getInt("spiritshot_count"));
  76. // if its the first data for this petid, we initialize its level FastMap
  77. if (!_petTable.containsKey(petId))
  78. _petTable.put(petId, new TIntObjectHashMap<L2PetData>());
  79. _petTable.get(petId).put(petLevel, petData);
  80. }
  81. rset.close();
  82. statement.close();
  83. }
  84. catch (Exception e)
  85. {
  86. _log.log(Level.WARNING, "Could not load pets stats: " + e.getMessage(), e);
  87. }
  88. finally
  89. {
  90. try
  91. {
  92. con.close();
  93. }
  94. catch (Exception e)
  95. {
  96. }
  97. }
  98. }
  99. public void addPetData(L2PetData petData)
  100. {
  101. TIntObjectHashMap<L2PetData> h = _petTable.get(petData.getPetID());
  102. if (h == null)
  103. {
  104. TIntObjectHashMap<L2PetData> statTable = new TIntObjectHashMap<L2PetData>();
  105. statTable.put(petData.getPetLevel(), petData);
  106. _petTable.put(petData.getPetID(), statTable);
  107. return;
  108. }
  109. h.put(petData.getPetLevel(), petData);
  110. }
  111. public void addPetData(L2PetData[] petLevelsList)
  112. {
  113. for (L2PetData petData : petLevelsList)
  114. addPetData(petData);
  115. }
  116. public L2PetData getPetData(int petID, int petLevel)
  117. {
  118. return _petTable.get(petID).get(petLevel);
  119. }
  120. /**
  121. * Pets stuffs
  122. */
  123. public static boolean isWolf(int npcId)
  124. {
  125. return npcId == 12077;
  126. }
  127. public static boolean isEvolvedWolf(int npcId)
  128. {
  129. return npcId == 16030 || npcId == 16037 || npcId == 16025 || npcId == 16041 || npcId == 16042;
  130. }
  131. public static boolean isSinEater(int npcId)
  132. {
  133. return npcId == 12564;
  134. }
  135. public static boolean isHatchling(int npcId)
  136. {
  137. return npcId > 12310 && npcId < 12314;
  138. }
  139. public static boolean isStrider(int npcId)
  140. {
  141. return (npcId > 12525 && npcId < 12529) || (npcId > 16037 && npcId < 16041) || npcId == 16068;
  142. }
  143. public static boolean isWyvern(int npcId)
  144. {
  145. return npcId == 12621;
  146. }
  147. public static boolean isBaby(int npcId)
  148. {
  149. return npcId > 12779 && npcId < 12783;
  150. }
  151. public static boolean isImprovedBaby(int npcId)
  152. {
  153. return npcId > 16033 && npcId < 16037;
  154. }
  155. public static boolean isPetFood(int itemId)
  156. {
  157. switch (itemId)
  158. {
  159. case 2515:
  160. case 4038:
  161. case 5168:
  162. case 5169:
  163. case 6316:
  164. case 7582:
  165. case 9668:
  166. case 10425:
  167. return true;
  168. default:
  169. return false;
  170. }
  171. }
  172. public static boolean isWolfFood(int itemId)
  173. {
  174. return itemId == 2515;
  175. }
  176. public static boolean isEvolvedWolfFood(int itemId)
  177. {
  178. return itemId == 9668;
  179. }
  180. public static boolean isSinEaterFood(int itemId)
  181. {
  182. return itemId == 2515;
  183. }
  184. public static boolean isHatchlingFood(int itemId)
  185. {
  186. return itemId == 4038;
  187. }
  188. public static boolean isStriderFood(int itemId)
  189. {
  190. return itemId == 5168 || itemId == 5169;
  191. }
  192. public static boolean isWyvernFood(int itemId)
  193. {
  194. return itemId == 6316;
  195. }
  196. public static boolean isBabyFood(int itemId)
  197. {
  198. return itemId == 7582;
  199. }
  200. public static boolean isImprovedBabyFood(int itemId)
  201. {
  202. return itemId == 10425;
  203. }
  204. public static int[] getFoodItemId(int npcId)
  205. {
  206. switch (npcId)
  207. {
  208. case 12077:// Wolf
  209. case 12564://Sin Eater
  210. return new int[] { 2515 };
  211. case 16030:// Great Wolf
  212. case 16025:// Black Wolf
  213. case 16037:// White Great Wolf
  214. case 16041:// Fenrir
  215. case 16042:// White Fenrir
  216. return new int[] { 9668 };
  217. case 12311:// hatchling of wind
  218. case 12312:// hatchling of star
  219. case 12313:// hatchling of twilight
  220. return new int[] { 4038 };
  221. case 12526:// wind strider
  222. case 12527:// Star strider
  223. case 12528:// Twilight strider
  224. case 16038:// red wind strider
  225. case 16039:// red Star strider
  226. case 16040:// red Twilight strider
  227. case 16068:// Guardian Strider
  228. return new int[] { 5168, 5169 };
  229. case 12621: // wyvern
  230. return new int[] { 6316 };
  231. case 12780:// Baby Buffalo
  232. case 12782:// Baby Cougar
  233. case 12781:// Baby Kookaburra
  234. return new int[] { 7582 };
  235. case 16034:// Improved Baby Buffalo
  236. case 16036:// Improved Baby Cougar
  237. case 16035:// Improved Baby Kookaburra
  238. return new int[] { 10425 };
  239. default:
  240. return new int[] { 0 };
  241. }
  242. }
  243. public static boolean isPetItem(int itemId)
  244. {
  245. switch (itemId)
  246. {
  247. case 2375: // Wolf
  248. case 3500: // hatchling of wind
  249. case 3501: // hatchling of star
  250. case 3502: // hatchling of twilight
  251. case 4422: // strider of wind
  252. case 4423: // strider of star
  253. case 4424: // strider of dusk
  254. case 4425: // Sin Eater
  255. case 6648: // baby buffalo
  256. case 6649: // baby cougar
  257. case 6650: // baby kookaburra
  258. case 8663: // Wyvern
  259. case 9882: // Great Wolf
  260. case 10163: // Black Wolf
  261. case 10307: // Great Snow Wolf
  262. case 10308: // red strider of wind
  263. case 10309: // red strider of star
  264. case 10310: // red strider of dusk
  265. case 10311: // improved buffalo
  266. case 10312: // improved cougar
  267. case 10313: // improved kookaburra
  268. case 10426: // Fenrir
  269. case 10611: // White Fenrir
  270. case 14819: // Guardian Strider
  271. return true;
  272. default:
  273. return false;
  274. }
  275. }
  276. public static int[] getPetItemsByNpc(int npcId)
  277. {
  278. switch (npcId)
  279. {
  280. case 12077:// Wolf
  281. return new int[] { 2375 };
  282. case 16025:// Great Wolf
  283. return new int[] { 9882 };
  284. case 16030:// Black Wolf
  285. return new int[] { 10163 };
  286. case 16037:// White Great Wolf
  287. return new int[] { 10307 };
  288. case 16041:// Fenrir
  289. return new int[] { 10426 };
  290. case 16042:// White Fenrir
  291. return new int[] { 10611 };
  292. case 12564://Sin Eater
  293. return new int[] { 4425 };
  294. case 12311:// hatchling of wind
  295. case 12312:// hatchling of star
  296. case 12313:// hatchling of twilight
  297. return new int[] { 3500, 3501, 3502 };
  298. case 12526:// wind strider
  299. case 12527:// Star strider
  300. case 12528:// Twilight strider
  301. case 16038: // red strider of wind
  302. case 16039: // red strider of star
  303. case 16040: // red strider of dusk
  304. case 16068: // Guardian Strider
  305. return new int[] { 4422, 4423, 4424, 10308, 10309, 10310 , 14819};
  306. case 12621:// Wyvern
  307. return new int[] { 8663 };
  308. case 12780:// Baby Buffalo
  309. case 12782:// Baby Cougar
  310. case 12781:// Baby Kookaburra
  311. return new int[] { 6648, 6649, 6650 };
  312. case 16034:// Improved Baby Buffalo
  313. case 16036:// Improved Baby Cougar
  314. case 16035:// Improved Baby Kookaburra
  315. return new int[] { 10311, 10312, 10313 };
  316. // unknown item id.. should never happen
  317. default:
  318. return new int[] { 0 };
  319. }
  320. }
  321. public static boolean isMountable(int npcId)
  322. {
  323. return npcId == 12526 // wind strider
  324. || npcId == 12527 // star strider
  325. || npcId == 12528 // twilight strider
  326. || npcId == 12621 // wyvern
  327. || npcId == 16037 // Great Snow Wolf
  328. || npcId == 16041 // Fenrir Wolf
  329. || npcId == 16042 // White Fenrir Wolf
  330. || npcId == 16038 // Red Wind Strider
  331. || npcId == 16039 // Red Star Strider
  332. || npcId == 16040 // Red Twilight Strider
  333. || npcId == 16068; // Guardian Strider
  334. }
  335. @SuppressWarnings("synthetic-access")
  336. private static class SingletonHolder
  337. {
  338. protected static final PetDataTable _instance = new PetDataTable();
  339. }
  340. }