X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/088b4ae1e2dbc44ef82f3b965b8f5b8ab2444e78..abb13e4a91db1fa2933f9971130b7a21dfc06634:/script/statistics diff --git a/script/statistics b/script/statistics index f04879359..4ceb92cfc 100755 --- a/script/statistics +++ b/script/statistics @@ -16,7 +16,7 @@ puts "

OpenStreetMap stats report run at #{start_time.to_s}

" begin ActiveRecord::Base.transaction do - user_count = User.count(:conditions => "active = 1") + user_count = User.count(:conditions => { :status => ["active", "confirmed", "suspended"] }) tracepoint_count = Tracepoint.count() node_count = Node.count(:conditions => "visible = true") way_count = Way.count(:conditions => "visible = true") @@ -34,7 +34,7 @@ begin puts "" puts "" - Trace.sum(:size, :group => :user_id, :order => "sum_size DESC", :limit => 50).each do |user, count| + Trace.sum(:size, :conditions => { :inserted => true }, :group => :user_id, :order => "sum_size DESC", :limit => 50).each do |user, count| display_name = User.find(user).display_name.gsub('@', ' at ').gsub('.', ' dot ') puts "" end @@ -102,3 +102,5 @@ end puts "

Report took #{(Time.new - start_time).to_s} seconds to run

" puts "" puts "" + +exit 0
UserNumber of Points
#{display_name}#{count}