--- a/app/helpers/application_helper.rb
+++ b/app/helpers/application_helper.rb
@@ -56,7 +56,17 @@ module ApplicationHelper
     URI.parse(full_url).host
   end
   
+  def gravatar_url_for(email, options = {})
+    url_for({ :gravatar_id => Digest::MD5.hexdigest(email), :host => 'www.gravatar.com', :protocol => 'http://', 
+              :only_path => false, :controller => 'avatar.php', :default => "http://gitorious.org/images/default_face.png" # FIXME: hardcoded url =(
+            }.merge(options))
+  end
+  
   def flashes
     flash.map {|type, content| content_tag(:div, content_tag(:p, content), :class => "flash_message #{type}")}
   end
+  
+  def absolute_url(*path)
+    
+  end
 end

--- a/app/views/users/show.html.erb
+++ b/app/views/users/show.html.erb
@@ -5,11 +5,15 @@
   <small><%= @user.fullname.blank? ? "" : "(#{h(@user.fullname)})" -%></small>
 </h1>
 
-<ul class="infobox">
+<div class="infobox">
+<div id="right"><%= link_to(image_tag(gravatar_url_for(@user.email, { :size => 80 }), :alt => "avatar"), :action => "show") %></div>
+<ul>
   <li><strong>Email:</strong> <%= encoded_mail_to(@user.email) -%></li>
   <li><strong>Url:</strong> <a href="<%=h @user.url -%>"><%=h @user.url -%></a></li>
   <li><strong>Member for</strong> <%= time_ago_in_words(@user.created_at) -%></li>
 </ul>
+</div>
+
 
 <div id="left">
 <% unless @projects.blank? -%>

--- a/db/schema.rb
+++ b/db/schema.rb
@@ -12,19 +12,19 @@
 ActiveRecord::Schema.define(:version => 21) do
 
   create_table "comments", :force => true do |t|
-    t.integer  "user_id",                       :null => false
-    t.integer  "repository_id",                 :null => false
-    t.string   "sha1",          :default => "", :null => false
+    t.integer  "user_id",       :null => false
+    t.integer  "repository_id", :null => false
+    t.string   "sha1"
     t.text     "body"
     t.datetime "created_at"
     t.datetime "updated_at"
     t.integer  "project_id"
   end
 
-  add_index "comments", ["user_id"], :name => "index_comments_on_user_id"
+  add_index "comments", ["project_id"], :name => "index_comments_on_project_id"
   add_index "comments", ["repository_id"], :name => "index_comments_on_repository_id"
   add_index "comments", ["sha1"], :name => "index_comments_on_sha1"
-  add_index "comments", ["project_id"], :name => "index_comments_on_project_id"
+  add_index "comments", ["user_id"], :name => "index_comments_on_user_id"
 
   create_table "committerships", :force => true do |t|
     t.integer  "user_id"
@@ -34,8 +34,8 @@ ActiveRecord::Schema.define(:version => 21) do
     t.datetime "updated_at"
   end
 
-  add_index "committerships", ["user_id"], :name => "index_permissions_on_user_id"
   add_index "committerships", ["repository_id"], :name => "index_permissions_on_repository_id"
+  add_index "committerships", ["user_id"], :name => "index_permissions_on_user_id"
 
   create_table "merge_requests", :force => true do |t|
     t.integer  "user_id"
@@ -48,10 +48,10 @@ ActiveRecord::Schema.define(:version => 21) do
     t.datetime "updated_at"
   end
 
-  add_index "merge_requests", ["user_id"], :name => "index_merge_requests_on_user_id"
   add_index "merge_requests", ["source_repository_id"], :name => "index_merge_requests_on_source_repository_id"
-  add_index "merge_requests", ["target_repository_id"], :name => "index_merge_requests_on_target_repository_id"
   add_index "merge_requests", ["status"], :name => "index_merge_requests_on_status"
+  add_index "merge_requests", ["target_repository_id"], :name => "index_merge_requests_on_target_repository_id"
+  add_index "merge_requests", ["user_id"], :name => "index_merge_requests_on_user_id"
 
   create_table "projects", :force => true do |t|
     t.string   "title"
@@ -66,8 +66,8 @@ ActiveRecord::Schema.define(:version => 21) do
     t.string   "bugtracker_url"
   end
 
-  add_index "projects", ["slug"], :name => "index_projects_on_slug", :unique => true
   add_index "projects", ["title"], :name => "index_projects_on_name"
+  add_index "projects", ["slug"], :name => "index_projects_on_slug", :unique => true
   add_index "projects", ["user_id"], :name => "index_projects_on_user_id"
 
   create_table "repositories", :force => true do |t|
@@ -82,10 +82,10 @@ ActiveRecord::Schema.define(:version => 21) do
   end
 
   add_index "repositories", ["name"], :name => "index_repositories_on_name"
-  add_index "repositories", ["project_id"], :name => "index_repositories_on_project_id"
-  add_index "repositories", ["user_id"], :name => "index_repositories_on_user_id"
   add_index "repositories", ["parent_id"], :name => "index_repositories_on_parent_id"
+  add_index "repositories", ["project_id"], :name => "index_repositories_on_project_id"
   add_index "repositories", ["ready"], :name => "index_repositories_on_ready"
+  add_index "repositories", ["user_id"], :name => "index_repositories_on_user_id"
 
   create_table "ssh_keys", :force => true do |t|
     t.integer  "user_id"
@@ -142,8 +142,8 @@ ActiveRecord::Schema.define(:version => 21) do
     t.text     "url"
   end
 
-  add_index "users", ["login"], :name => "index_users_on_login"
   add_index "users", ["email"], :name => "index_users_on_email"
+  add_index "users", ["login"], :name => "index_users_on_login"
   add_index "users", ["ssh_key_id"], :name => "index_users_on_ssh_key_id"
 
 end

Binary files /dev/null and b/public/images/default_face.png differ

--- a/spec/helpers/application_helper_spec.rb
+++ b/spec/helpers/application_helper_spec.rb
@@ -34,4 +34,12 @@ describe ApplicationHelper do
     base_url("http://foo.com/bar/baz").should == "foo.com"
   end
   
+  it "generates a valid gravatar url" do
+    email = "someone@myemail.com";
+    url = gravatar_url_for(email)
+    
+    base_url(url).should == "www.gravatar.com"
+    url.include?(Digest::MD5.hexdigest(email)).should == true
+  end
+  
 end