Dear, People of the interwebs using the auction tracker auction.goonquest.com

[oldhead]

very nice =)

[Darklake]

Great tool - thanks for your efforts :-)

Anything you can do to combat muppets using a lower case o instead of zero, i.e. "3oo" instead of "300"? Take a look at the Stein of Moggok as an example and you can see the numpties have created entries that get counted as a price of 3 which screws the data.

[jetviper21]

Originally Posted by Darklake [You must be logged in to view images. Log in or Register.]

Great tool - thanks for your efforts :-)

Anything you can do to combat muppets using a lower case o instead of zero, i.e. "3oo" instead of "300"? Take a look at the Stein of Moggok as an example and you can see the numpties have created entries that get counted as a price of 3 which screws the data.

easy 1 liner fix let me patch that

[jetviper21]

Originally Posted by jetviper21 [You must be logged in to view images. Log in or Register.]

easy 1 liner fix let me patch that

hash[:price].gsub(/[oO]/, '0')

that should do it

[jetviper21]

Fixed it was mostly some guy named pipe and troop

[oldhead]

Executioner's Axe isnt being listed for some reason.

I know there were auctions for it in the file I just uploaded also.


edit... blue two handed hammer isnt listed anymore.

[oldhead]

That remove/refresh change made it 400% easier to skim through the list and remove bad prices.

[Wizerud]

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...

[jetviper21]

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

[oldhead]

A Mithril Two-Handed Sword

even tho zams says its Mithril Two-Handed Sword in game its A Mithril Two-Handed Sword

http://everquest.allakhazam.com/db/item.html?item=428