statement = con.prepareStatement(SELECT_WINNER_INFOS);
statement.setInt(1, categoryType.getClientId());
statement.setInt(2, STATUE_SPAWN_SELECT_LIMIT);
rset = statement.executeQuery();
if (rset.next()) {
StatuesSpawnTemplate template = new StatuesSpawnTemplate(categoryType);
template.setName(rset.getString("char_name"));
template.setClassId(rset.getInt("classId"));
template.setRaceId(rset.getInt("race"));
template.setSex(rset.getInt("sex"));
template.setHairStyle(rset.getInt("hairstyle"));
template.setHairColor(rset.getInt("haircolor"));
template.setFace(rset.getInt("face"));
template.setNecklace(rset.getInt("necklace"));
template.setHead(rset.getInt("head"));
template.setRHand(rset.getInt("rhand"));
template.setLHand(rset.getInt("lhand"));
template.setGloves(rset.getInt("gloves"));
template.setChest(rset.getInt("chest"));
template.setPants(rset.getInt("pants"));
template.setBoots(rset.getInt("boots"));
template.setCloak(rset.getInt("cloak"));
template.setHair1(rset.getInt("hair1"));
template.setHair2(rset.getInt("hair2"));
templates.add(template);
}
}
} catch (Exception e) {