View Single Post
  #9  
Old 10-10-2010, 03:29 PM
jetviper21 jetviper21 is offline
Kobold


Join Date: Apr 2010
Posts: 143
Default

Quote:
Originally Posted by Wizerud [You must be logged in to view images. Log in or Register.]
It appears that every item which begins with "a" or "an" is missing i.e. A Gypsy Medallion. Although if everything got reset that might be why...
>> ItemCache.find(:all, :conditions => "LOWER(name) LIKE 'a %' OR LOWER(name) LIKE 'an %'").map(&:name)
=> ["A Reprimand", "An Insulting Note", "A Darkhollow Spore", "A Rotting Spore", "A Treatise on Tonics", "A Large Chunk of Agranite", "A Worn Note", "A Box of Reagents", "A Cryptic Scroll", "A Marvelous Elixir"]

only ones in database i can add ones you find that are missing