Auction Tracker - remove bad entries

[Frug]

"temporarily disabled" for.... months at least? Is this ever going to be re-instituted?

Tons of bad prices (3 for 3k) and ridiculous Kyndal-esque overpricing in a few items.

[Bummey]

To which auction tracker are you referring?

[Kavious]

Probably means the Wiki. https://wiki.project1999.com/Special:AuctionTracker

You can see removing bad entries function is disabled here (http://wiki.project1999.com/Special:AuctionTracker/TRIMOUTLIERS)

And theres pages that look like this Wurm Scale Coat (https://wiki.project1999.com/Wurm_Scale_Coat) as an example

[Frug]

Yes, thanks Kav.

Looking back at some of my logs, it seems the "3 meaning 3k" is because the auctioneer actually used "3K" in his message.

Seems the auction tracker could fix that. It's not too hard a regex.

[loramin]

Seems the auction tracker could fix that. It's not too hard a regex.

Sadly, while the code for the auction tracker is available, it was: written in PHP (/rude), by someone who no longer plays here, and to fully understand it you also need to see the database tables (or at least the DB migration that created them), which no one but the staff has access to.

In other words, fixing anything in it is an incredibly difficult task, and I say this after having wasting hours trying to fix it to include Velious items :( ...

... unless the staff decides to give a benevolent programmer like myself access to the wiki's DB ;) ;) ;)

[Frug]

I'd be happy to fix it also. Programmer of many years, SQL fluent. No PHP though.

[Baler]

The wiki auction is wild wild west. abuse it.

[gredoo]

Should just fork or use use http://ahungry.com/eqauctions then use that data to populate the wiki.


... unless the staff decides to give a benevolent programmer like myself access to the wiki's DB ;) ;) ;)

I can't see why (other than lack of time) it would be a big deal to provide a db dump or just the schema.

[Meulaar]

http://wiki.project1999.com/Special:AuctionTracker/TRIMOUTLIERS

There are getting to be some ridiculous prices messing up the graphs. Can we get some programmers on this task? I volunteer. I'm a web and DB programmer.

If it has simply been deactivated, maybe there is commented out code that explains why that can be uncommented? In a perfect world...

One simply needs to look no further than the main landing page on the most active items to see that it's not functioning as intended.

[loramin]

Unfortunately there are just two options here: the wiki or the "make your own auction site" route.

As has been mentioned, the "make your own auction site" path is easier than it has ever been. Before no one even knew if such sites could sustain enough interest to be worthwhile. Now, with AHungry and (formerly) P99 Tunnel we know they can succeed, and on top of that (as was mentioned) there's even OSS code you can copy to get started. And whether you use that code or not, you can use any language you want.

But as far as the wiki goes, to change the auction tracker (even to just re-enable the price-fixing piece) you need the ability to install custom (PHP) extensions on the wiki. I know of only two people with that power: Rogean and Ravhin.

The source code for the existing extension is freely available: http://wiki.project1999.com/utils/wikiUtils.php. That's not the problem; the problem is ... well it's three-part:


someone needs to determine what the correct "fix" is (eg. re-enable price fixing, re-enable only for admins, implement some sort of voting scheme, etc.)
someone needs to write the PHP code to implement that fix
someone has to convince a wiki server admin (Rogean or Ravhin) to install that extension


I'd love to help with this, but I sort of despise PHP, plus I've begged both Rogean and Ravhin for enough wiki improvements already. But I'd love to see someone else (who can tolerate PHP) take up the torch :)

[Argh]

I can make this in PHP if theres an idea as to how exactly the pruning should work.

[Frug]

I can make this in PHP if theres an idea as to how exactly the pruning should work.

It appears the original intent was to allow people to "flag" a price as being outside of normal ranges for an item.

I have a person auction thingie I use that does this in an automated way by doing a standard deviation from mean calc, and throwing out things that are beyond 2 (or 2 1/2 maybe?) standard deviations. it's not perfect, espcially for illiquid items (eg: without a lot of history), but works ok

[loramin]

I can make this in PHP if theres an idea as to how exactly the pruning should work.

Woot, we have a volunteer for #2 (thanks Argh)!

Now we just need a consensus on #1 (how the pruning should work), and then once Argh is done someone will have to beg Rogean/Ravhin to add his code to the wiki (#3).

[Argh]

I have a person auction thingie I use that does this in an automated way by doing a standard deviation from mean calc, and throwing out things that are beyond 2 (or 2 1/2 maybe?) standard deviations. it's not perfect, espcially for illiquid items (eg: without a lot of history), but works ok

This would probably be the easiest way to do it, with a minimum number of entries required before it starts filtering out the outliers,