Clean up scopes in comment.rb

Rails 4 ActiveRecord interface change for one. Removals for others.

The removed scopes are unused, as far as I can tell.