# pass_salt :string
# email_valid :boolean default(FALSE), not null
# new_email :string
-# creation_ip :string
# languages :string
# status :enum default("pending"), not null
# terms_agreed :datetime
# tou_agreed :datetime
# diary_comments_count :integer default(0)
# note_comments_count :integer default(0)
+# creation_address :inet
#
# Indexes
#
+# index_users_on_creation_address (creation_address) USING gist
# users_auth_idx (auth_provider,auth_uid) UNIQUE
# users_display_name_canonical_idx (lower(NORMALIZE(display_name, NFKC)))
# users_display_name_idx (display_name) UNIQUE
has_many :new_messages, -> { where(:to_user_visible => true, :muted => false, :message_read => false).order(:sent_on => :desc) }, :class_name => "Message", :foreign_key => :to_user_id
has_many :sent_messages, -> { where(:from_user_visible => true).order(:sent_on => :desc).preload(:sender, :recipient) }, :class_name => "Message", :foreign_key => :from_user_id
has_many :muted_messages, -> { where(:to_user_visible => true, :muted => true).order(:sent_on => :desc).preload(:sender, :recipient) }, :class_name => "Message", :foreign_key => :to_user_id
- has_many :friendships, -> { joins(:befriendee).where(:users => { :status => %w[active confirmed] }) }
- has_many :friends, :through => :friendships, :source => :befriendee
+ has_many :follows, -> { joins(:following).where(:users => { :status => %w[active confirmed] }) }
+ has_many :followings, :through => :follows, :source => :following
has_many :preferences, :class_name => "UserPreference"
has_many :changesets, -> { order(:created_at => :desc) }, :inverse_of => :user
has_many :changeset_comments, :foreign_key => :author_id, :inverse_of => :author
has_and_belongs_to_many :changeset_subscriptions, :class_name => "Changeset", :join_table => "changesets_subscribers", :foreign_key => "subscriber_id"
has_many :note_comments, :foreign_key => :author_id, :inverse_of => :author
has_many :notes, :through => :note_comments
-
- has_many :client_applications
- has_many :oauth_tokens, -> { order(:authorized_at => :desc).preload(:client_application) }, :class_name => "OauthToken", :inverse_of => :user
+ has_many :note_subscriptions, :class_name => "NoteSubscription"
+ has_many :subscribed_notes, :through => :note_subscriptions, :source => :note
has_many :oauth2_applications, :class_name => Doorkeeper.config.application_model.name, :as => :owner
has_many :access_grants, :class_name => Doorkeeper.config.access_grant_model.name, :foreign_key => :resource_owner_id
OSM::GreatCircle.new(home_lat, home_lon).distance(nearby_user.home_lat, nearby_user.home_lon)
end
- def friends_with?(new_friend)
- friendships.exists?(:befriendee => new_friend)
+ def follows?(user)
+ follows.exists?(:following => user)
end
##
##
# revoke any authentication tokens
def revoke_authentication_tokens
- oauth_tokens.authorized.each(&:invalidate!)
access_tokens.not_expired.each(&:revoke)
end
suspend! if may_suspend? && spam_score > Settings.spam_threshold
end
- ##
- # return an oauth 1 access token for a specified application
- def access_token(application_key)
- ClientApplication.find_by(:key => application_key).access_token_for_user(self)
- end
-
##
# return an oauth 2 access token for a specified application
def oauth_token(application_id)
max_messages.clamp(0, Settings.max_messages_per_hour)
end
- def max_friends_per_hour
+ def max_follows_per_hour
account_age_in_seconds = Time.now.utc - created_at
account_age_in_hours = account_age_in_seconds / 3600
- recent_friends = Friendship.where(:befriendee => self).where(:created_at => Time.now.utc - 3600..).count
- max_friends = account_age_in_hours.ceil + recent_friends - (active_reports * 10)
- max_friends.clamp(0, Settings.max_friends_per_hour)
+ recent_follows = Follow.where(:following => self).where(:created_at => Time.now.utc - 3600..).count
+ max_follows = account_age_in_hours.ceil + recent_follows - (active_reports * 10)
+ max_follows.clamp(0, Settings.max_follows_per_hour)
end
def max_changeset_comments_per_hour
if moderator?
Settings.moderator_changeset_comments_per_hour
else
- previous_comments = changeset_comments.limit(200).count
- max_comments = previous_comments / 200.0 * Settings.max_changeset_comments_per_hour
+ previous_comments = changeset_comments.limit(Settings.comments_to_max_changeset_comments).count
+ max_comments = previous_comments / Settings.comments_to_max_changeset_comments.to_f * Settings.max_changeset_comments_per_hour
max_comments = max_comments.floor.clamp(Settings.initial_changeset_comments_per_hour, Settings.max_changeset_comments_per_hour)
max_comments /= 2**active_reports
max_comments.floor.clamp(Settings.min_changeset_comments_per_hour, Settings.max_changeset_comments_per_hour)