public void addAllyMember(L2Clan newClan)
    {
        _members.put(newClan.getName(), newClan);
        // store in db
        storeNewMembersInDatabase(newClan);
    }
    
    private void storeNewMembersInDatabase(L2Clan member)
    {
        java.sql.Connection con = null;
        L2ClanMember[] members = member.getMembers();
        
        for (int i = 0; i < members.length; i++)
        {    
            try
            {
                con = L2DatabaseFactory.getInstance().getConnection();
                PreparedStatement statement = con.prepareStatement("UPDATE characters SET allyid=? WHERE obj_Id=?");
                statement.setInt(1, getAllianceId());
                statement.setInt(2, members[i].getObjectId());
                statement.execute();
                statement.close();                  
                if (Config.DEBUG) _log.fine("New clan member saved in db: "+members[i].getObjectId());
            }
            catch (Exception e)
            {
                _log.warning("error while saving new clan member to db "+e);
            }
            finally
            {
                try { con.close(); } catch (Exception e) {}
            }
        }
    }
}