/** {@inheritDoc} */ @Override public ArrayList<Integer> loadLegionMembers(final int legionId) { final ArrayList<Integer> legionMembers = new ArrayList<Integer>(); boolean success = DB.select( SELECT_LEGIONMEMBERS_QUERY, new ParamReadStH() { @Override public void setParams(PreparedStatement stmt) throws SQLException { stmt.setInt(1, legionId); } @Override public void handleRead(ResultSet resultSet) { try { while (resultSet.next()) { int playerObjId = resultSet.getInt("player_id"); legionMembers.add(playerObjId); } } catch (SQLException sqlE) { log.error( "[DAO: MySQL5LegionMemberDAO] No players in Legion. DELETE Legion Id: " + legionId); } } }); if (success && legionMembers.size() > 0) { return legionMembers; } return null; }
@Override public void loadItemCooldowns(final Player player) { DB.select( SELECT_QUERY, new ParamReadStH() { @Override public void setParams(PreparedStatement stmt) throws SQLException { stmt.setInt(1, player.getObjectId()); } @Override public void handleRead(ResultSet rset) throws SQLException { while (rset.next()) { int delayId = rset.getInt("delay_id"); int useDelay = rset.getInt("use_delay"); long reuseTime = rset.getLong("reuse_time"); if (reuseTime > System.currentTimeMillis()) player.addItemCoolDown(delayId, reuseTime, useDelay); } } }); player.getEffectController().broadCastEffects(); }
/** {@inheritDoc} */ @Override public LegionMemberEx loadLegionMemberEx(final int playerObjId) { final LegionMemberEx legionMemberEx = new LegionMemberEx(playerObjId); boolean success = DB.select( SELECT_LEGIONMEMBEREX_QUERY, new ParamReadStH() { @Override public void setParams(PreparedStatement stmt) throws SQLException { stmt.setInt(1, playerObjId); } @Override public void handleRead(ResultSet resultSet) { try { resultSet.next(); legionMemberEx.setName(resultSet.getString("players.name")); legionMemberEx.setExp(resultSet.getLong("players.exp")); legionMemberEx.setPlayerClass( PlayerClass.valueOf(resultSet.getString("players.player_class"))); legionMemberEx.setLastOnline(resultSet.getTimestamp("players.last_online")); legionMemberEx.setWorldId(resultSet.getInt("players.world_id")); int legionId = resultSet.getInt("legion_members.legion_id"); legionMemberEx.setRank( LegionRank.valueOf(resultSet.getString("legion_members.rank"))); legionMemberEx.setNickname(resultSet.getString("legion_members.nickname")); legionMemberEx.setSelfIntro(resultSet.getString("legion_members.selfintro")); legionMemberEx.setLegion(LegionService.getInstance().getLegion(legionId)); } catch (SQLException sqlE) { log.debug("[DAO: MySQL5LegionMemberDAO] Player is not in a Legion"); } } }); if (success && legionMemberEx.getLegion() != null) { return legionMemberEx; } return null; }
/** {@inheritDoc} */ @Override public LegionMember loadLegionMember(final int playerObjId) { if (playerObjId == 0) return null; final LegionMember legionMember = new LegionMember(playerObjId); boolean success = DB.select( SELECT_LEGIONMEMBER_QUERY, new ParamReadStH() { @Override public void setParams(PreparedStatement stmt) throws SQLException { stmt.setInt(1, playerObjId); } @Override public void handleRead(ResultSet resultSet) { try { resultSet.next(); int legionId = resultSet.getInt("legion_id"); legionMember.setRank(LegionRank.valueOf(resultSet.getString("rank"))); legionMember.setNickname(resultSet.getString("nickname")); legionMember.setSelfIntro(resultSet.getString("selfintro")); legionMember.setLegion(LegionService.getInstance().getLegion(legionId)); } catch (SQLException sqlE) { log.debug("[DAO: MySQL5LegionMemberDAO] Player is not in a Legion"); } } }); if (success && legionMember.getLegion() != null) { return legionMember; } return null; }