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.
Merge pull request #460 from sunlightlabs/comment-scopes

Clean up scopes in comment.rb