gistfile1.txt

    def self.search(options = {})

      length_criteria = (options[:length] == 'all' or options[:length].blank?) ? '' : 'and LENGTH(name) = ' + options[:length] + ' '
      registered_criteria = options[:order] == 'views DESC' ? "and registered = false " : ''
      viewable_criteria = "and viewable_at < '" + Time.now.utc.to_s(:db) + "' "
      category_criteria = options[:category] != 'all' ? 'and category = "' + options[:category].downcase + '" ' : ''
      public_criteria = options[:public_only] ? 'and public = true ' : '' 

      paginate :per_page => DOM_PER_PAGE, :page => options[:page],
               :conditions => ["name like ? #{viewable_criteria}#{public_criteria}#{category_criteria}#{length_criteria}#{registered_criteria}", "%#{options[:search_term]}%"],
               :order => "#{options[:order]}, id ASC"

    end