@Override public void loadPlayerPunishments(final Player player) { DB.select( SELECT_QUERY, new ParamReadStH() { @Override public void setParams(PreparedStatement ps) throws SQLException { ps.setInt(1, player.getObjectId()); } @Override public void handleRead(ResultSet rs) throws SQLException { while (rs.next()) { player.setPrisonTimer(rs.getLong("punishment_timer")); if (player.isInPrison()) player.setPrisonTimer(rs.getLong("punishment_timer")); else player.setPrisonTimer(0); } } }); }
@Override public TitleList loadTitleList(final int playerId) { final TitleList tl = new TitleList(); DB.select( LOAD_QUERY, new ParamReadStH() { @Override public void setParams(PreparedStatement stmt) throws SQLException { stmt.setInt(1, playerId); } @Override public void handleRead(ResultSet rset) throws SQLException { while (rset.next()) { int id = rset.getInt("title_id"); int remaining = rset.getInt("remaining"); tl.addEntry(id, remaining); } } }); return tl; }