/** * License * THE WORK (AS DEFINED BELOW) IS PROVIDED UNDER THE TERMS OF THIS * CREATIVE COMMONS PUBLIC LICENSE ("CCPL" OR "LICENSE"). * THE WORK IS PROTECTED BY COPYRIGHT AND/OR OTHER APPLICABLE LAW. * ANY USE OF THE WORK OTHER THAN AS AUTHORIZED UNDER THIS LICENSE OR * COPYRIGHT LAW IS PROHIBITED. * * BY EXERCISING ANY RIGHTS TO THE WORK PROVIDED HERE, YOU ACCEPT AND * AGREE TO BE BOUND BY THE TERMS OF THIS LICENSE. TO THE EXTENT THIS LICENSE * MAY BE CONSIDERED TO BE A CONTRACT, THE LICENSOR GRANTS YOU THE RIGHTS CONTAINED * HERE IN CONSIDERATION OF YOUR ACCEPTANCE OF SUCH TERMS AND CONDITIONS. * */ package l1j.server.server.serverpackets; import java.util.logging.Logger; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.logging.Level; import l1j.server.L1DatabaseFactory; import l1j.server.server.Opcodes; import l1j.server.server.utils.SQLUtil; // Referenced classes of package l1j.server.server.serverpackets: // ServerBasePacket public class S_CharacterConfig extends ServerBasePacket { private static Logger _log = Logger.getLogger(S_CharacterConfig.class.getName()); private static final String S_CHARACTER_CONFIG = "[S] S_CharacterConfig"; private byte[] _byte = null; public S_CharacterConfig(int objectId) { buildPacket(objectId); } private void buildPacket(int objectId) { int length = 0; byte data[] = null; Connection con = null; PreparedStatement pstm = null; ResultSet rs = null; try { con = L1DatabaseFactory.getInstance().getConnection(); pstm = con.prepareStatement("SELECT * FROM character_config WHERE object_id=?"); pstm.setInt(1, objectId); rs = pstm.executeQuery(); while (rs.next()) { length = rs.getInt(2); data = rs.getBytes(3); } } catch (SQLException e) { _log.log(Level.SEVERE, e.getLocalizedMessage(), e); } finally { SQLUtil.close(rs); SQLUtil.close(pstm); SQLUtil.close(con); } if (length != 0) { writeC(Opcodes.S_OPCODE_SKILLICONGFX); writeC(S_PacketBox.CHARACTER_CONFIG); writeD(length); writeByte(data); } } @Override public byte[] getContent() { if (_byte == null) { _byte = getBytes(); } return _byte; } @Override public String getType() { return S_CHARACTER_CONFIG; } }