#
# Indexes
#
-# index_user_blocks_on_user_id (user_id)
+# index_user_blocks_on_creator_id_and_id (creator_id,id)
+# index_user_blocks_on_user_id (user_id)
#
# Foreign Keys
#
validate :moderator_permissions
validates :reason, :characters => true
- belongs_to :user, :class_name => "User", :foreign_key => :user_id
- belongs_to :creator, :class_name => "User", :foreign_key => :creator_id
- belongs_to :revoker, :class_name => "User", :foreign_key => :revoker_id
+ belongs_to :user, :class_name => "User"
+ belongs_to :creator, :class_name => "User"
+ belongs_to :revoker, :class_name => "User", :optional => true
PERIODS = Settings.user_block_periods
##
# scope to match active blocks
def self.active
- where("needs_view or ends_at > ?", Time.now.getutc)
+ where("needs_view or ends_at > ?", Time.now.utc)
end
##
# returns true if the block is currently active (i.e: the user can't
# use the API).
def active?
- needs_view || ends_at > Time.now.getutc
+ needs_view || ends_at > Time.now.utc
end
##
# is the user object who is revoking the ban.
def revoke!(revoker)
update(
- :ends_at => Time.now.getutc,
+ :ends_at => Time.now.utc,
:revoker_id => revoker.id,
:needs_view => false
)