Hi Everyvone!
I want loading ClanWar clan list in server
the task is that if someone is in a clan war with the other, then they do not get PK points.
but I don't know how to check it.
public class ClanWar
{
private final static Logger LOG = LoggerFactory.getLogger(ClanWar.class);
private static ClanWar _instance;
private Map<Integer, Integer> clanwars = new FastMap<Integer, Integer>().shared();
public static ClanWar getInstance()
{
if (_instance == null)
{
_instance = new ClanWar();
}
return _instance;
}
private ClanWar()
{
clanwars = new FastMap<>();
loadData();
}
private void loadData()
{
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
final PreparedStatement statement = con.prepareStatement("select clan1,clan2 FROM clan_wars");
final ResultSet rset = statement.executeQuery();
while (rset.next())
{
int clan1 = rset.getInt("clan1");
int clan2 = rset.getInt("clan2");
clanwars.put(clan1, clan2);
}
LOG.info("ClanWars: Loaded: " + clanwars.size());
DatabaseUtils.close(rset);
DatabaseUtils.close(statement);
}
catch (final Exception e)
{
LOG.error("Clanwars: error loaded", e);
}
finally
{
CloseUtil.close(con);
}
}
public int getClanWar(final int clan1, final int clan2)
{
return 0;
}
}