MOD: Update all values from eve-central

Discuss/Upload mods to the EVE-Dev Killboard.
Blake
Someday Author
Posts: 88
Joined: Sat Jan 24, 2009 20:53

Re: MOD: Update all values from eve-central

Post by Blake » Fri Dec 17, 2010 00:52

Image

User avatar
pdidoc
Apprentice
Posts: 45
Joined: Sat Jun 14, 2008 20:24
Location: Wiltshire, UK
Contact:

Re: MOD: Update all values from eve-central

Post by pdidoc » Fri Dec 17, 2010 02:10

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.
Regards,
PryMary

ArcAiN6
Noob
Posts: 6
Joined: Tue Dec 21, 2010 21:54

Re: MOD: Update all values from eve-central

Post by ArcAiN6 » Tue Dec 21, 2010 21:56

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
Lead Moderator
Posts: 229
Joined: Sat Jun 14, 2008 20:24
Location: England

Re: MOD: Update all values from eve-central

Post by mastergamer » Wed Dec 22, 2010 01:04

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
Noob
Posts: 3
Joined: Sat Jun 14, 2008 20:24

Re: MOD: Update all values from eve-central

Post by brettski » Wed Dec 22, 2010 05:09

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
Lead Moderator
Posts: 229
Joined: Sat Jun 14, 2008 20:24
Location: England

Re: MOD: Update all values from eve-central

Post by mastergamer » Wed Dec 22, 2010 10:15

brettski wrote: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.

User avatar
drizzcat
Noob
Posts: 8
Joined: Sat Jun 14, 2008 20:24
Location: Belleville, Ontario, Canada
Contact:

Re: MOD: Update all values from eve-central

Post by drizzcat » Fri Dec 24, 2010 03:49

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

Demitrios
Greenhorn
Posts: 18
Joined: Thu Sep 23, 2010 22:17

Re: MOD: Update all values from eve-central

Post by Demitrios » Fri Dec 31, 2010 05:54

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.
Last edited by Demitrios on Sun Jan 09, 2011 11:02, edited 1 time in total.

Sh0d4n
Noob
Posts: 7
Joined: Sat Jun 14, 2008 20:24

Re: MOD: Update all values from eve-central

Post by Sh0d4n » Tue Jan 04, 2011 08:38

mastergamer wrote: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
Lead Moderator
Posts: 229
Joined: Sat Jun 14, 2008 20:24
Location: England

Re: MOD: Update all values from eve-central

Post by mastergamer » Tue Jan 04, 2011 14:19

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.

Post Reply

Return to “Modding”

Who is online

Users browsing this forum: No registered users and 5 guests