These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

eve-marketdata.com
Author
Previous Topic Next Topic
Scrapyard Bob
EVE University
Ivy League
#21 - 2011-10-17 04:32:07 UTC
(checks thread title... twice...)

When I run (3) clients overnight on the Market Watch page to update regional data, sometimes the Market Watch page fails with a duplicate key error (some sort of log file insert). It happened two or three times today. I'm guessing that the upload log's primary key only has 1 second resolution or something from a particular IP address.
Scrapyard Bob
EVE University
Ivy League
#22 - 2011-10-20 04:51:00 UTC
On an individual item price check page, you currently list "best price" and "jita price".

I would like to see that expanded a bit with showing the top 5 market hub prices (along with how stale the price is in hours/days).

I'd also prefer to see the 5% sim price there in addition to the cheapest price in those market hubs.
Scrapyard Bob
EVE University
Ivy League
#23 - 2011-10-23 14:08:34 UTC
Scrapyard Bob
EVE University
Ivy League
#24 - 2011-10-28 12:10:32 UTC
Same issue again for The Forge region, the API query returns all zeros for the prices.
Zeta Zhul
Preemptive Paranoia
#25 - 2011-10-29 16:28:42 UTC
Scrapyard Bob wrote:
Same issue again for The Forge region, the API query returns all zeros for the prices.


Yep sorry to say it is still a problem.

Kinda funny that it would be Jita/The Forge that is the issue rather than any of the other regions. Certainly doesn't seem to affect the website itself.

Other than this coming up occasionally the site has been pretty solid.
Scrapyard Bob
EVE University
Ivy League
#26 - 2011-10-29 18:52:10 UTC
Since it tends to impact the larger hubs - my assumption (without knowing the code) would be that the process is dying when calculating the 5% buy sim price due to the number of orders. Either it's running past a time limit and getting killed off or it's running out of a resource (like memory).
Zeta Zhul
Preemptive Paranoia
#27 - 2011-10-30 04:21:55 UTC
No idea. It appears that other systems in The Forge show up OK on the website. But Jita itself doesn't show at all.

In the API I'm doing a regionID call and I'm not getting anything but '0' for The Forge. Even if you eliminate Jita there should be some data available.

So it does look like a buggy script.
Zeta Zhul
Preemptive Paranoia
#28 - 2011-10-31 04:41:39 UTC
Now it appears that all is well, the data is good, the script is fixed.

Honestly I'm starting to get a Cargo Cult response out of this. Big smile

But hey if this works with eve-marketdata.com then a full blown bamboo and leaf internet spaceship should have a positive effect on CCP right?

Right?

Big smile
Scrapyard Bob
EVE University
Ivy League
#29 - 2011-11-05 12:27:04 UTC
http://eve-marketdata.com/price_check.php?step=Show&type_id=34&type=sell&region_id=10000002

Shows tritanium's Jita price as:

Best Price: Selling for 2.26ISK; Buying at 3.37ISK.
Jita Price: Selling for 5,358ISK; Buying at 5,059ISK.

Maybe add a "global price" that either:

- Averages the buy 5% / sell 5% prices across the top 10 market stations
- Averages the buy 5% / sell 5% prices across the top 6 hi-sec regions
- Does the 5% buy/sell across all hi-sec stations in all empire regions

While Jita generally sets the price trend, it's also prone to market manipulation affecting any global price estimate used in 3rd party tools. Pulling a global price across a wider swath of empire space would be harder to manipulate as you would have to corner the market in multiple regions.
Chris Smith
Deep Core Mining Inc.
Caldari State
#30 - 2011-11-07 18:15:53 UTC
This is probably covered already but I can not seem to find it. Try and make this simple for me :) I am delicate!

I want my excel document to auto pull prices for various items. For this example lets use Golem. What do I need to do in my spread sheet for it to pull the Current Lowest Sell Price of a Golem in The Forge.
Kaedaar OLeary
ADK Industries
#31 - 2011-11-12 15:56:25 UTC
In game scanner is still searching for limited and advanced command centers.
Zeta Zhul
Preemptive Paranoia
#32 - 2011-11-13 02:14:16 UTC  |  Edited by: Zeta Zhul
Ok. Now I'm getting a new error.

Quote:

Error: unable to determine if you want production or beta


Production or beta?

This is my api call URL:

Quote:

http://api.eve-marketdata.com/api/item_orders2.xml?buysell=s&char_name=Zeta%20Zhul&marketgroup_ids=18
German Nuts
School of Applied Knowledge
Caldari State
#33 - 2011-11-13 05:21:57 UTC
I am seeing Zeta's issue when running the example queries from the bottom of the "API Methods - Item Prices" page on the eve-market data site.

Quote:
http://eve-marketdata.com/developers/item_prices2.php
http://api.eve-marketdata.com/api/item_prices2.txt?char_name=demo&type_ids=34,12068®ion_ids=10000002&buysell=s
http://api.eve-marketdata.com/api/item_prices2.xml?char_name=demo&type_ids=34,12068®ion_ids=10000002&buysell=s
http://api.eve-marketdata.com/api/item_prices2.json?char_name=demo&type_ids=34,12068®ion_ids=10000002&buysell=s


After playing with previously working addresses, it seems anything stating with "http://api.eve-marketdata.com/api/item_prices2." is having issues.
German Nuts
School of Applied Knowledge
Caldari State
#34 - 2011-11-13 08:46:55 UTC
In regards to the "Error: unable to determine if you want production or beta" that Zeta found. After some mucking around I figured out if you remove the first "api." in export address, it seems to work.

Quote:

Link giving error:
http://api.eve-marketdata.com/api/item_prices2.xml?char_name=demo&type_ids=34,12068&region_ids=10000002&buysell=s
Working link:
http://eve-marketdata.com/api/item_prices2.xml?char_name=demo&type_ids=34,12068&region_ids=10000002&buysell=s


The working link may need to be edited or copy & pasted due to the fact that when you click it, the eve online forum adds "amp;" after each '&' in the address when following the link.
Scrapyard Bob
EVE University
Ivy League
#35 - 2011-11-14 21:07:15 UTC
http://eve-marketdata.com/

Sorry, an error occured. The webmaster has been notified

Warning: mysql_pconnect() [function.mysql-pconnect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111
in /home/kallahar/eve-marketdata.com/f_header.php on line 72
Licinius CrassusFilius
Space Construction and Research
#36 - 2011-11-17 12:47:33 UTC
I am having an error with the site that it continuously refreshes if I go to the 'download' page (I need to get a new download key after an OS reinstall). I have trusted the main website as well as the download page specifically, but the site does not recognise that it is trusted.

Clearing the cache and restarting did not fix the issue.
Scrapyard Bob
EVE University
Ivy League
#37 - 2011-11-17 15:40:42 UTC
Licinius CrassusFilius wrote:
I am having an error with the site that it continuously refreshes if I go to the 'download' page (I need to get a new download key after an OS reinstall). I have trusted the main website as well as the download page specifically, but the site does not recognise that it is trusted.

Clearing the cache and restarting did not fix the issue.


Same issue all day yesterday.

Also, the server is now returning a 404 error for the v2 API XML calls.
Sle Vakorime
Viziam
Amarr Empire
#38 - 2011-11-21 07:45:21 UTC
Hi,

I'm new to the site and trying to add my key after going thru all the screens (it even ask for my character so the key itself is valid) and I save it. Things seem to work but when I go to a specific screen (say the sell my hangar) I get the form asking me for the station and then it sends me back to http://eve-marketdata.com/user.php with the message "You need to enter your API information to use this page."

It seems like somehow the site is forgetting about me between requests.
Scrapyard Bob
EVE University
Ivy League
#39 - 2011-11-26 04:50:45 UTC
http://eve-marketdata.com/price_check.php?step=Show&type_id=9848&region_id=10000002&type=history

Note that 2011-11-08 shows up multiple times in the historical list of prices.

All of the records between 2009-12-01 and 2011-01-14 are repeated.
Seppo Aapo
Science and Trade Institute
Caldari State
#40 - 2011-11-27 13:38:25 UTC
Heads up - it appears due to the recent upgrade to nginx at eve-marketdata, very long request URLs (i.e item_prices.xml?type_ids=[lots of them]) don't work.
I simply split my request up into two and it works again.