Untitled

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<Integer, String> 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;
     }