/*
* 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 2, 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, write to the Free Software
* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA
* 02111-1307, USA.
*
* http://www.gnu.org/copyleft/gpl.html
*/
package com.l2jfrozen.gameserver.datatables.sql;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Map;
import java.util.logging.Logger;
import javolution.util.FastMap;
import com.l2jfrozen.gameserver.model.L2PetData;
import com.l2jfrozen.gameserver.model.actor.instance.L2PetInstance;
import com.l2jfrozen.util.CloseUtil;
import com.l2jfrozen.util.database.L2DatabaseFactory;
public class L2PetDataTable
{
private final 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<Integer, Map<Integer, L2PetData>> _petTable;
public static L2PetDataTable getInstance()
{
if(_instance == null)
{
_instance = new L2PetDataTable();
}
return _instance;
}
private L2PetDataTable()
{
_petTable = new FastMap<Integer, Map<Integer, L2PetData>>();
}
public void loadPetsData()
{
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection(false);
final 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");
final 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<Integer, L2PetData>());
}
_petTable.get(petId).put(petLevel, petData);
}
rset.close();
statement.close();
}
catch(Exception e)
{
_log.severe("Could not load pets stats"+" "+ e);
}
finally
{
CloseUtil.close(con);
}
}
public void addPetData(L2PetData petData)
{
Map<Integer, L2PetData> h = _petTable.get(petData.getPetID());
if(h == null)
{
Map<Integer, L2PetData> statTable = new FastMap<Integer, L2PetData>();
statTable.put(petData.getPetLevel(), petData);
_petTable.put(petData.getPetID(), statTable);
return;
}
h.put(petData.getPetLevel(), petData);
}
public void addPetData(L2PetData[] petLevelsList)
{
for(L2PetData element : petLevelsList)
{
addPetData(element);
}
}
public L2PetData getPetData(int petID, int petLevel)
{
//System.out.println("Getting id "+petID+" level "+ petLevel);
return _petTable.get(petID).get(petLevel);
}
/**
* Pets stuffs
* @param npcId
* @return
*/
public static boolean isWolf(int npcId)
{
return npcId == 12077;
}
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 isPetFood(int itemId)
{
return itemId == 2515 || itemId == 4038 || itemId == 5168 || itemId == 6316 || itemId == 7582;
}
public static boolean isWolfFood(int itemId)
{
return itemId == 2515;
}
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 int getFoodItemId(int npcId)
{
if(isWolf(npcId))
return 2515;
else if(isSinEater(npcId))
return 2515;
else if(isHatchling(npcId))
return 4038;
else if(isStrider(npcId))
return 5168;
else if(isBaby(npcId))
return 7582;
else
return 0;
}
public static int getPetIdByItemId(int itemId)
{
switch(itemId)
{
// wolf pet a
case 2375:
return 12077;
// Sin Eater
case 4425:
return 12564;
// hatchling of wind
case 3500:
return 12311;
// hatchling of star
case 3501:
return 12312;
// hatchling of twilight
case 3502:
return 12313;
// wind strider
case 4422:
return 12526;
// Star strider
case 4423:
return 12527;
// Twilight strider
case 4424:
return 12528;
// Wyvern
case 8663:
return 12621;
// Baby Buffalo
case 6648:
return 12780;
// Baby Cougar
case 6649:
return 12782;
// Baby Kookaburra
case 6650:
return 12781;
// unknown item id.. should never happen
default:
return 0;
}
}
public static int getHatchlingWindId()
{
return 12311;
}
public static int getHatchlingStarId()
{
return 12312;
}
public static int getHatchlingTwilightId()
{
return 12313;
}
public static int getStriderWindId()
{
return 12526;
}
public static int getStriderStarId()
{
return 12527;
}
public static int getStriderTwilightId()
{
return 12528;
}
public static int getWyvernItemId()
{
return 8663;
}
public static int getStriderWindItemId()
{
return 4422;
}
public static int getStriderStarItemId()
{
return 4423;
}
public static int getStriderTwilightItemId()
{
return 4424;
}
public static int getSinEaterItemId()
{
return 4425;
}
public static boolean isPetItem(int itemId)
{
return itemId == 2375 // wolf
|| 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; // Babies
}
public static int[] getPetItemsAsNpc(int npcId)
{
switch(npcId)
{
case 12077:// wolf pet a
return new int[]
{
2375
};
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
};
// 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
}
}