Index: C:/eclipse/workspace/L2_GameServer/java/net/sf/l2j/gameserver/model/L2PcInstance.java =================================================================== --- C:/eclipse/workspace/L2_GameServer/java/net/sf/l2j/gameserver/model/L2PcInstance.java (revision 938) +++ C:/eclipse/workspace/L2_GameServer/java/net/sf/l2j/gameserver/model/L2PcInstance.java (working copy) @@ -414,6 +414,37 @@ public HashMap getAccountChars() { + java.sql.Connection con = null; + + String loginName = this.getAccountName(); + try + { + con = L2DatabaseFactory.getInstance().getConnection(); + PreparedStatement statement = con.prepareStatement("SELECT characters.obj_Id, characters.char_name FROM accounts, characters WHERE characters.account_name = accounts.login AND accounts.login = ?"); + statement.setString(1, loginName); + ResultSet rset = statement.executeQuery(); + boolean moreData = rset.next(); + if (moreData) + while (moreData) + { + Integer charId = rset.getInt(1); + String charName = rset.getString(2); + _chars.put(charId, charName); + + moreData = rset.next(); + } + rset.close(); + statement.close(); + } + catch (Exception e) + { + _log.log(Level.WARNING, "Couldnt load characters", e); + + } + finally + { + try { con.close(); } catch (Exception e) {} + } return _chars; }