/* * This program is free software: you can redistribute it and/or modify it under * the terms of the GNU General Public License as published by the Free Software * Foundation, either version 3 of the License, or (at your option) any later * version. * * This program is distributed in the hope that it will be useful, but WITHOUT * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS * FOR A PARTICULAR PURPOSE. See the GNU General Public License for more * details. * * You should have received a copy of the GNU General Public License along with * this program. If not, see . */ package net.sf.l2j.gameserver.model; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.Map; import java.util.logging.Logger; import javolution.util.FastMap; import net.sf.l2j.L2DatabaseFactory; import net.sf.l2j.gameserver.model.actor.instance.L2PetInstance; public class L2PetDataTable { private static Logger _log = Logger.getLogger(L2PetInstance.class.getName()); private static L2PetDataTable _instance; //private static final int[] PET_LIST = { 12077, 12312, 12313, 12311, 12527, 12528, 12526 }; private static Map> _petTable; public static L2PetDataTable getInstance() { if (_instance == null) _instance = new L2PetDataTable(); return _instance; } private L2PetDataTable() { _petTable = new FastMap>(); } public void loadPetsData() { java.sql.Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(); 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 FROM pets_stats"); ResultSet rset = statement.executeQuery(); int petId, petLevel; while (rset.next()) { petId = rset.getInt("typeID"); petLevel = rset.getInt("level"); //build the petdata for this level L2PetData petData = new L2PetData(); petData.setPetID(petId); petData.setPetLevel(petLevel); petData.setPetMaxExp(rset.getInt("expMax")); petData.setPetMaxHP(rset.getInt("hpMax")); petData.setPetMaxMP(rset.getInt("mpMax")); petData.setPetPAtk( rset.getInt("patk") ); petData.setPetPDef( rset.getInt("pdef") ); petData.setPetMAtk( rset.getInt("matk") ); petData.setPetMDef( rset.getInt("mdef") ); petData.setPetAccuracy( rset.getInt("acc") ); petData.setPetEvasion( rset.getInt("evasion") ); petData.setPetCritical( rset.getInt("crit") ); petData.setPetSpeed( rset.getInt("speed") ); petData.setPetAtkSpeed( rset.getInt("atk_speed") ); petData.setPetCastSpeed( rset.getInt("cast_speed") ); petData.setPetMaxFeed( rset.getInt("feedMax") ); petData.setPetFeedNormal( rset.getInt("feednormal") ); petData.setPetFeedBattle( rset.getInt("feedbattle") ); petData.setPetMaxLoad( rset.getInt("loadMax") ); petData.setPetRegenHP( rset.getInt("hpregen") ); petData.setPetRegenMP( rset.getInt("mpregen") ); petData.setPetRegenMP( rset.getInt("mpregen") ); petData.setOwnerExpTaken( rset.getFloat("owner_exp_taken") ); // if its the first data for this petid, we initialize its level FastMap if (!_petTable.containsKey(petId)) _petTable.put(petId, new FastMap()); _petTable.get(petId).put(petLevel,petData); } rset.close(); statement.close(); } catch (Exception e) { _log.warning("Could not load pets stats: "+ e); } finally { try { con.close(); } catch (Exception e) {} } } public void addPetData(L2PetData petData) { Map h = _petTable.get(petData.getPetID()); if (h == null) { Map statTable = new FastMap(); statTable.put(petData.getPetLevel(), petData); _petTable.put(petData.getPetID(), statTable); return; } h.put(petData.getPetLevel(), petData); } public void addPetData(L2PetData[] petLevelsList) { for (int i = 0; i < petLevelsList.length; i++) addPetData(petLevelsList[i]); } public L2PetData getPetData(int petID, int petLevel) { //_log.info("Getting id "+petID+" level "+ petLevel); return _petTable.get(petID).get(petLevel); } /** * Pets stuffs */ public static boolean isWolf(int npcId) { return npcId == 12077; } public static boolean isGreatWolf(int npcId) { return npcId == 16030; } public static boolean isWGreatWolf(int npcId) { return npcId == 16037; } public static boolean isBlackWolf(int npcId) { return npcId == 16025; } public static boolean isFenrirWolf(int npcId) { return npcId == 16041; } public static boolean isWFenrirWolf(int npcId) { return npcId == 16042; } public static boolean isSinEater(int npcId) { return npcId == 12564; } public static boolean isHatchling(int npcId) { return npcId > 12310 && npcId < 12314; } public static boolean isStrider(int npcId) { return npcId > 12525 && npcId < 12529; } public static boolean isWyvern(int npcId) { return npcId == 12621; } public static boolean isBaby(int npcId) { return npcId > 12779 && npcId < 12783; } public static boolean isImprovedBaby(int npcId) { return npcId > 16033 && npcId < 16037; } public static boolean isPetFood(int itemId) { return (itemId == 2515) || (itemId == 4038) || (itemId == 5168) || (itemId == 6316) || (itemId == 7582) || (itemId == 9668) || (itemId == 10425); } public static boolean isWolfFood(int itemId) { return itemId == 2515; } public static boolean isGreatWolfFood(int itemId) { return itemId == 9668; } public static boolean isWGreatWolfFood(int itemId) { return itemId == 9668; } public static boolean isBlackWolfFood(int itemId) { return itemId == 9668; } public static boolean isFenrirWolfFood(int itemId) { return itemId == 9668; } public static boolean isWFenrirWolfFood(int itemId) { return itemId == 9668; } public static boolean isSinEaterFood(int itemId) { return itemId == 2515; } public static boolean isHatchlingFood(int itemId) { return itemId == 4038; } public static boolean isStriderFood(int itemId) { return itemId == 5168; } public static boolean isWyvernFood(int itemId) { return itemId == 6316; } public static boolean isBabyFood(int itemId) { return itemId == 7582; } public static boolean isImprovedBabyFood(int itemId) { return itemId == 10425; } public static int getFoodItemId(int npcId) { switch (npcId) { case 12077:// Wolf return 2515; case 16030:// Great Wolf case 16025:// Black Wolf case 16037:// White Great Wolf case 16041:// Fenrir case 16042:// White Fenrir return 9668; case 12564://Sin Eater return 2515; case 12311:// hatchling of wind case 12312:// hatchling of star case 12313:// hatchling of twilight return 4038; case 12526:// wind strider case 12527:// Star strider case 12528:// Twilight strider return 5168; case 12780:// Baby Buffalo case 12782:// Baby Cougar case 12781:// Baby Kookaburra return 7582; case 16034:// Improved Baby Buffalo case 16036:// Improved Baby Cougar case 16035:// Improved Baby Kookaburra return 10425; default: return 0; } } public static boolean isPetItem(int itemId) { return (itemId == 2375 // Wolf || itemId == 10163// Great Wolf || itemId == 10307 // White Great Wolf || itemId == 9882 // Black Wolf || itemId == 10426 // Fenrir || itemId == 10611 // White Fenrir || itemId == 4425 //Sin Eater || itemId == 3500 || itemId == 3501 || itemId == 3502 // hatchlings || itemId == 4422 || itemId == 4423 || itemId == 4424 // striders || itemId == 8663 // Wyvern || itemId == 6648 || itemId == 6649 || itemId == 6650 || itemId == 10311 || itemId == 10312 || itemId == 10313); // Babies } public static int[] getPetItemsByNpc(int npcId) { switch (npcId) { case 12077:// Wolf return new int[]{2375}; case 16025:// Black Wolf return new int[]{9882}; case 16030:// Great Wolf return new int[]{10163}; case 16037:// White Great Wolf return new int[]{10307}; case 16041:// Fenrir return new int[]{10426}; case 16042:// White Fenrir return new int[]{10611}; case 12564://Sin Eater return new int[]{4425}; case 12311:// hatchling of wind case 12312:// hatchling of star case 12313:// hatchling of twilight return new int[]{3500, 3501, 3502}; case 12526:// wind strider case 12527:// Star strider case 12528:// Twilight strider return new int[]{4422, 4423, 4424}; case 12621:// Wyvern return new int[]{8663}; case 12780:// Baby Buffalo case 12782:// Baby Cougar case 12781:// Baby Kookaburra return new int[]{6648, 6649, 6650}; case 16034:// Improved Baby Buffalo case 16036:// Improved Baby Cougar case 16035:// Improved Baby Kookaburra return new int[]{10311, 10312, 10313}; // unknown item id.. should never happen default: return new int[]{0}; } } public static boolean isMountable(int npcId) { return npcId == 12526 // wind strider || npcId == 12527 // star strider || npcId == 12528 // twilight strider || npcId == 12621 // wyvern || npcId == 16037 // Great Snow Wolf || npcId == 16041 // Fenrir Wolf || npcId == 16042; // White Fenrir Wolf } }