/*
* 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
}
}