Code:
@Override
public void createPlayer(Player player) {
WorldPosition pos = player.getWorldPosition();
PlayerAppearance app = player.getPlayerAppearance();
PreparedStatement st = DB
.prepareStatement("INSERT INTO players(`id`, `name`, race, gender, class, level, exp, rested_exp, max_rested_exp, hp, mp, creation_time, last_online, description, settings, map_id, x, y, z, h, channel," +
" account_id, awaken_level, laurel, achievment_points, fatigue, world_map, world_guard, arena_id, delete_time, appearance, appearance2, details, shape, ban, ban_time, new_player, change_name) " +
"VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
try {
st.setInt(1, player.getId());
st.setString(2, player.getName());
st.setString(3, player.getRace().toString());
st.setString(4, player.getGender().toString());
st.setString(5, player.getPlayerClass().toString());
st.setInt(6, player.getLevel());
st.setLong(7, player.getExperience());
st.setLong(8, player.getCurrentRestedExperience());
st.setLong(9, player.getMaxRestedExperience());
st.setLong(10, player.getCurrentStats().getHp());
st.setLong(11, player.getCurrentStats().getMp());
st.setTimestamp(12, player.getCreationTime());
st.setTimestamp(13, player.getLastOnlineTime());
st.setString(14, player.getDescription());
st.setBytes(15, player.getUserSettings());
st.setInt(16, pos.getMapId());
st.setFloat(17, pos.getX());
st.setFloat(18, pos.getY());
st.setFloat(19, pos.getZ());
st.setInt(20, pos.getHeading());
st.setInt(21, pos.getChannelId());
st.setInt(22, player.getAccount().getId());
st.setInt(23, player.getAwakenLevel());
st.setString(24, player.getLaurel().toString());
st.setInt(25, player.getAchievmentPoints());
st.setInt(26, player.getGatherCraftPoints());
st.setInt(27, pos.getWorldMapWorldId());
st.setInt(28, pos.getWorldMapGuardId());
st.setInt(29, pos.getAreaNameId());
st.setTimestamp(30, player.getDeletionTime());
st.setBytes(31, app.getAppearance());
st.setBytes(32, app.getAppearance2());
st.setBytes(33, app.getDetails());
st.setBytes(34, app.getShape());
st.setBoolean(35, player.isBan());
st.setTimestamp(36, player.getBanTime());
st.setBoolean(37, player.isNewPlayer());
st.setBoolean(38, player.isNamechange());
st.executeUpdate();
} catch (SQLException e) {
log.error("Can't inser player", e);
} finally {
DB.close(st);
}
}
for xml data :