1 files changed, 14 insertions, 24 deletions

diff --git a/app/controllers/admin_controller.rb b/app/controllers/admin_controller.rb
index f3cc221..18c4104 100644
--- a/app/controllers/admin_controller.rb
+++ b/app/controllers/admin_controller.rb
@@ -5,21 +5,15 @@ class AdminController < ApplicationController
   before_filter :login_required
 
   def index
-    @drafts = Node.all(
-      :limit => 50,
-      :order => "updated_at desc",
-      :conditions => ["draft_id IS NOT NULL"]
-    )
-    @drafts_count = Node.count(
-      :conditions => ["draft_id IS NOT NULL"]
-    )
-    @recent_changes = Node.all(
-      :limit => 50,
-      :order => "updated_at desc",
-      :conditions => [ 
-        "updated_at < ? AND updated_at > ? AND parent_id IS NOT NULL", Time.now, Time.now-14.days
-      ]
-    )
+    @drafts = Node.where("draft_id IS NOT NULL")
+      .limit(50).order("updated_at desc")
+
+    @drafts_count = Node.where("draft_id IS NOT NULL").count
+
+    @recent_changes = Node.where(
+      "updated_at < ? AND updated_at > ? AND parent_id IS NOT NULL",
+      Time.now, Time.now - 14.days
+    ).limit(50).order("updated_at desc")
 
     all_nodes = Node.root.self_and_descendants
     @sitemap_depth = {}
@@ -28,16 +22,12 @@ class AdminController < ApplicationController
     end
     @sitemap = all_nodes.to_a.sort! { |node1,node2| node1.lft <=> node2.lft }.delete_if { |node| node.update? }
 
-    @mypages = Page.all(
-      :conditions => [ "user_id = ? or editor_id = ?", @current_user, @current_user]
-    )
-
-    @mynodes = Node.all(
-      :order => "updated_at desc",
-      :joins => :pages,
-      :conditions => [ "pages.user_id = ? or pages.editor_id = ?", @current_user, @current_user ]
-    ).uniq.first(50)
+    @mypages = Page.where("user_id = ? or editor_id = ?", @current_user, @current_user)
 
+    @mynodes = Node.joins(:pages)
+              .where("pages.user_id = ? or pages.editor_id = ?", @current_user, @current_user)
+              .order("updated_at desc")
+              .uniq.first(50)
   end
   
   def search