MOD: Update all values from eve-central

[Blake]

http://eve-id.net/forum/viewtopic.php?p=35054#p35054 post with a mirror in

[pdidoc]

http://prices.c0rporation.com/faction.xml <-- I'm using that to get faction prices on the value fetch, but ships are a no go at the moment. I can't find a link either for that, apart from manually updating via the eve central sync.

[ArcAiN6]

Is this feature / mod still being developed / maintainted?

The reason i ask, is for the past several days, the value fetch URL has been 404

http://eve.no-ip.de/prices/30d/prices-all.xml <-- goes no where...

does anyone have an updated / functional URL for value-fetching?

[mastergamer]

No idea about the no-ip link not working. If it fed from eve-metrics it needs rewriting anyway.

I'll see if I can set up an alternate URL on prices.c0rporation.com at some point tommorow.

[brettski]

Is there anyone who knows what the layout of this file is like? What the basic XML schema used is? I have not been able to find an old version of the file, which would be great as it would give us something to go off of to build a new file. If nobody has an old file, I guess the next step is to figure it out through code, ick.

[mastergamer]

I guess the next step is to figure it out through code, ick.

Yeah, I don't know what the schema is so that's pretty much my plan.

We should really get some developer docs up on the wiki somewhere so that all the files used by the EDK have their formats documented and stuff.

[drizzcat]

Ok, Does anyone have a link that works to Update Prices - Doing it manually is Killing my Mouse.

[Demitrios]

Right, heres a VERY nasty hack, and what ever you do, when you have done the updates, FOR ****'S SAKE UNDO THE CHANGE!

You will need curl for this. http://www.paehl.com/open_source/?downl ... _721_3.zip

Open admin_value_editor.php and comment out "$page->setAdmin();" on line 22.

This will remove the need to log into update the values, which is why i said UNDO THE CHANGE when you are done .

Now, get this spreadsheet from http://www.pieh0.co.uk/updatevalues.zip , and do a find and replace for http://killboard.url.com/ and replace it to the url to your killboard in the "Update the url in this one" workbook, so for me, http://killboard.dthi.org/ . This contains all the update url's from the value editor page on all the catagory's.

Once you have done that, save the result in the "Export this as a text file" workbook as a Formatted Text (Space delimited) file.

Make it a batch file by changing the extension to .bat (chmod +x file for linux).

Now, the fun part, run the batch file, this will run curl on each line, and as it doesnt need to log in for the value editor page ONLY, it will run the update on each price.

Like i said, a very nasty hack, but it will save you from getting rsi/breaking your mouse/going on a violent psychotic rampage screaming something about updating prices.

I dont condone that you use this, after all, you are giving the world the ability to change the price of an ibis to 20 trillion isk, but if you need the prices updated and you dont want to spend hours doing it, this is the easy/nasty way of doing it.

Demi

EDIT: If you dont want to do this, i can export my kb3_eve_central table which you can import into your DB. Let me know if this is the case.

[Sh0d4n]

No idea about the no-ip link not working. If it fed from eve-metrics it needs rewriting anyway.

I'll see if I can set up an alternate URL on prices.c0rporation.com at some point tommorow.

is there an update ?

[mastergamer]

EVE Central doesn't have an API call that gets all item prices, rather you have to query each one individually. That's something I'd rather not, since it'll be a fair bit of work for the not very powerful server my site is on. EVE Marketdata doesn't have an API like that either, so we're out of luck at the moment.