Completely unread topics with recent replies should show as new

[david (David Taylor)]

I actually implemented this in a plugin, but I think the concern was that making that change in core could potentially cause a lot of confusion for existing users, especially those that have “consider topics as new when I haven’t viewed them yet” as their setting.

@david

after_initialize do
	require_dependency 'topic_query'
	class ::TopicQuery
	  def self.new_filter(list, treat_as_new_topic_start_date)
	    list.where("topics.bumped_at >= :created_at", created_at: treat_as_new_topic_start_date)
	        .where("tu.last_read_post_number IS NULL")
	        .where("COALESCE(tu.notification_level, :tracking) >= :tracking", tracking: TopicUser.notification_levels[:tracking])
	  end
	end
end