Realtime auction logger (hourly refresh, may increase)

[Grozmok]

Need to get more people using this so it's more reliable.

It's strange that when I have logging enabled and the exe running, the page doesn't always seem to refresh with recent /auctions

[tristantio]

I believe the auto-refresh is set to 5 minutes right now (1 minute refreshes were pulling too much bandwidth).

Performing a search in the quick search will grab the most recent results however.

Regarding more contributors, I am probably going to add some nagging/locked out functionality for people using it without having uploaded in the past (or last week or something) to give incentive to contribute.

[Ishirey]

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

I'm using it on OS X, running EQ under WINE like you (saw your post in the Mac/WINE thread). The shell script on tristantio's page works great for us. You'll need to open it in a text editor and change the LOGDIR=... line to point to the log file under your P99 install. For me, it's:

LOGDIR="/Applications/Project\ 1999.app/drive_c/eq/Logs"

Make sure any spaces have a backslash in front of them, like above.

Once you've done that, you can run the script from Terminal (which is how I do it). I don't know if you can make it run just by double-clicking; that opens it in an editor for me, but I think I may have changed the from the default. If you just save it to your home folder (usually /Users/yourname) you can run it by opening Terminal and typing: ./eqAuction.sh

Hope that helps!

Thanks a lot Phobus!

I'll try that right away. [You must be logged in to view images. Log in or Register.]

[Grozmok]

It's strange that sometimes my search results are not consistent.

If I search for one item:

(wts|sell|wtt).*(Gatorscale Sleeves)

it works fine, but if I search for a list of items:

(wts|sell|wtt).*(Clay Guardian Shield|Gatorscale Sleeves|Scaled Mystic Gauntlets|Cloak of the Ice Bear|Platinum Bloodstone Earring|Carved Ivory Mask|Dark Rust Boots|Glowing Bone Collar|Tattered Mantle|Lizardscale Belt|Golden Jaded Bracelet|Gloomwater Harpoon|Platinum Dragon Totem)

It sometimes doesn't show anything.

Any ideas?

[tristantio]

All I can think of is to make sure that you do not have any spaces before or after your search terms, as spaces will be included as part of the search (so if you had a double space before or after your parenthesis terms it would not included the result unless a seller had double spaces).

Searching for the big search you posted above shows me a list of those items, if the problem is consistent then it may be a bug in the programming or a cap on the database query length or something.

[Grozmok]

It seems to be working correctly at the moment, but I swear I saw an issue before.

If I can get you repro steps I'll follow-up.

[tristantio]

Just wanted to give a heads up that I should have hover links implemented soon, so you will be able to hover to see the item stats and click to see the p99 wiki page for pricing history.

With the hover stats I will also be able to add searching/filtering by stats, so you could search for all items being sold with 5 or more INT, or haste on it etc.

[Yanomamo]

I really want to do this, but the last time I tried I realized it needs permissions to my EQ folder. How do you recommend i solve that? Run the program as administrator every time i open it or what?

[tristantio]

It should only need read permission for the new exe, unless you are running it from within your EQ folder.

The exe will make an output file in whatever directory you run the exe in, try downloading the most recent windows exe, filling out your eqAuction.ini file properly and running from inside the folder you unzip it into.

[BarackObooma]

I've been getting odd results when I've been pulling this up time to time. Right now there was one auction 3 hours ago, another 23 hours ago and then everything else is 1 day ago or more.

With it being prime time, I find it hard to believe no one's ran it since then.