/*
* 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.datatables;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Map;
import javolution.util.FastMap;
import net.sf.l2j.L2DatabaseFactory;
public class NpcBufferTable
{
private class NpcBufferSkills
{
private int _npcId = 0;
private Map _skillId = new FastMap();
private Map _skillLevels = new FastMap();
private Map _skillFeeIds = new FastMap();
private Map _skillFeeAmounts = new FastMap();
public NpcBufferSkills(int npcId)
{
_npcId = npcId;
}
public void addSkill(int skillId, int skillLevel, int skillFeeId, int skillFeeAmount, int buffGroup)
{
_skillId.put(buffGroup, skillId);
_skillLevels.put(buffGroup, skillLevel);
_skillFeeIds.put(buffGroup, skillFeeId);
_skillFeeAmounts.put(buffGroup, skillFeeAmount);
}
public int[] getSkillGroupInfo(int buffGroup)
{
Integer skillId = _skillId.get(buffGroup);
Integer skillLevel = _skillLevels.get(buffGroup);
Integer skillFeeId = _skillFeeIds.get(buffGroup);
Integer skillFeeAmount = _skillFeeAmounts.get(buffGroup);
if (skillId == null || skillLevel == null || skillFeeId == null || skillFeeAmount == null)
return null;
return new int[]
{
skillId, skillLevel, skillFeeId, skillFeeAmount
};
}
public int getNpcId()
{
return _npcId;
}
}
private static NpcBufferTable _instance = null;
private Map _buffers = new FastMap();
private NpcBufferTable()
{
Connection con = null;
int skillCount = 0;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement = con.prepareStatement("SELECT `npc_id`,`skill_id`,`skill_level`,`skill_fee_id`,`skill_fee_amount`,`buff_group` FROM `npc_buffer` ORDER BY `npc_id` ASC");
ResultSet rset = statement.executeQuery();
int lastNpcId = 0;
NpcBufferSkills skills = null;
while (rset.next())
{
int npcId = rset.getInt("npc_id");
int skillId = rset.getInt("skill_id");
int skillLevel = rset.getInt("skill_level");
int skillFeeId = rset.getInt("skill_fee_id");
int skillFeeAmount = rset.getInt("skill_fee_amount");
int buffGroup = rset.getInt("buff_group");
if (npcId != lastNpcId)
{
if (lastNpcId != 0)
_buffers.put(lastNpcId, skills);
skills = new NpcBufferSkills(npcId);
skills.addSkill(skillId, skillLevel, skillFeeId, skillFeeAmount, buffGroup);
}
else
skills.addSkill(skillId, skillLevel, skillFeeId, skillFeeAmount, buffGroup);
lastNpcId = npcId;
skillCount++;
}
_buffers.put(lastNpcId, skills);
rset.close();
statement.close();
}
catch (Exception e)
{
System.out.println("NpcBufferSkillIdsTable: Error reading npc_buffer table: " + e);
}
finally
{
try
{
con.close();
}
catch (Exception e)
{
}
}
System.out.println("NpcBufferSkillIdsTable: Loaded " + _buffers.size() + " buffers and " + skillCount + " skills.");
}
public static NpcBufferTable getInstance()
{
if (_instance == null)
_instance = new NpcBufferTable();
return _instance;
}
public int[] getSkillInfo(int npcId, int buffGroup)
{
NpcBufferSkills skills = _buffers.get(npcId);
if (skills == null)
return null;
return skills.getSkillGroupInfo(buffGroup);
}
}