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.
 

RETURNED - EVE Marketeer - Market Data Aggregation & Information

Author
Omega Flames
Caldari Provisions
Caldari State
#401 - 2012-02-05 15:38:49 UTC
the item isogen has a buy entry in Uitra for 346,982 isk p/u with a quantity of 0. Even if someone was doing a margin trading scam (which they aren't cause that order does not exist ingame, unless I'm blind which is possible I guess) shouldn't the fact it's a quantity of 0 mean it gets ignored? Cause it's really fubar'ing my prices in evehq :(
Desmont McCallock
#402 - 2012-02-05 17:16:31 UTC  |  Edited by: Desmont McCallock
Looking at the EVE Tools section, here are some missing info regarding the dev behind certain tools.

EVEMon : The EVEMon Dev Team
EFT: Gripen
EVSCO: Karbowiak
jEveAssets: Golden Gnu
Out of EVE: Azazel Mordred aka ShrimpWorks
Griefwatch: BattleClinic

BTW the links are broken (i.e. EVEMon http://www.evemarketeer.com/home/tools/16).
Callean Drevus
Perkone
Caldari State
#403 - 2012-02-05 19:51:03 UTC  |  Edited by: Callean Drevus
Scrapyard Bob wrote:
Lots of stuff...

Fixed it all :P

Edit: Tool pages links fixed as well.

Edit 2: I am without understanding why this happens to Isogen. For some reason the website decides to use the quantity for the price, but I have yet to figure out why (it seems it doesn't do this for everything though, which makes it even weirder).

Developer/Creator of EVE Marketeer

Scrapyard Bob
EVE University
Ivy League
#404 - 2012-02-05 20:38:38 UTC
30-day average price drop-down on the LP page, doesn't seem to actually work. It's still displaying the sell.

1. Change drop down to "Sell Price"
2. Page refreshes, it goes back to saying "Average Price (30d)"

1. Change drop down to "Buy Price"
2. Page refreshes, value change, but drop-list goes back to saying "Average Price (30d)"
Vaerah Vahrokha
Vahrokh Consulting
#405 - 2012-02-05 22:00:11 UTC
There's one feature that I heavily used in the past, on another similar and awesome website: an items basket.

This let me create what is basically the equivalent of the in game market quickbar. I could then switch easily between my most traded items without hopping around pages and typing dozens of item names.

Imagine how cool it'd be if I could just have a clickable list to the left that updates a pane to the right to show the prices and the graphs like the in game market window.

I apologize in advance in case this feature is already implemented and I grandiously missed it.
Omega Flames
Caldari Provisions
Caldari State
#406 - 2012-02-05 22:57:46 UTC  |  Edited by: Omega Flames
Vaerah Vahrokha wrote:
There's one feature that I heavily used in the past, on another similar and awesome website: an items basket.

This let me create what is basically the equivalent of the in game market quickbar. I could then switch easily between my most traded items without hopping around pages and typing dozens of item names.

Imagine how cool it'd be if I could just have a clickable list to the left that updates a pane to the right to show the prices and the graphs like the in game market window.

I apologize in advance in case this feature is already implemented and I grandiously missed it.

go to an item's page>>>click add to EMK quickbar>>>mouse over the "item" link at the top left of the page
Vaerah Vahrokha
Vahrokh Consulting
#407 - 2012-02-06 01:25:09 UTC  |  Edited by: Vaerah Vahrokha
Omega Flames wrote:
Vaerah Vahrokha wrote:
There's one feature that I heavily used in the past, on another similar and awesome website: an items basket.

This let me create what is basically the equivalent of the in game market quickbar. I could then switch easily between my most traded items without hopping around pages and typing dozens of item names.

Imagine how cool it'd be if I could just have a clickable list to the left that updates a pane to the right to show the prices and the graphs like the in game market window.

I apologize in advance in case this feature is already implemented and I grandiously missed it.

go to an item's page>>>click add to EMK quickbar>>>mouse over the "item" link at the top left of the page


Ah, I both noticed the EMK quickbar and the item link but once I have pressed add to EMK quickbar and have seen that nothing happened, I thought the functionality was still not implemented.

I loaded another item and now it shows, thank you.

Edit:

AAAARGHHH!!!!

I added PLEX on quickbar and everything exploded! (Is it because it has apostrophes and PHP did not escape them?)



MYSQL ERROR OCCURRED: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's%' AND it.typeName LIKE '%License%' AND it.typeName LIKE '%Extension%' AND it.t' at line 1
MYSQL ERROR OCCURRED: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's%' AND CONCAT(mgp3.marketGroupName, ' ', mgp2.marketGroupName, ' ', mgp.marketG' at line 1



And at the center of the screen:


Could not find '30 Day Pilot's License Extension (PLEX)'

We could not find any items like the one you were searching for.



But this is the very thing the website proposed me in a list, when I entered PLEX in the search box.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#408 - 2012-02-06 10:43:22 UTC
Bind variables.

They save you from having to escape everything. They're a /little/ more complex to use, and you can't bind an inlist (well, I've never found out how) but they're seriously worth it. And they can speed things up a tiny amount, if you're also using a database that can cache its compiled sql (as you're using the same sql each time, with different parameters being filled in)

PDO makes them available.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Desmont McCallock
#409 - 2012-02-06 11:27:50 UTC
"Add to EMK Quickbar" is pretty nice but once that item is added, when showing this item again, the link should switch to "Remove from EMK Quickbar".
Scrapyard Bob
EVE University
Ivy League
#410 - 2012-02-06 15:33:34 UTC
http://www.evemarketeer.com/item/info/27102
- The LP Stores tab lists all LP items, not just entries for the item being viewed
Callean Drevus
Perkone
Caldari State
#411 - 2012-02-06 21:21:07 UTC  |  Edited by: Callean Drevus
Ok, let me see:

Quote:
30-day average price drop-down on the LP page, doesn't seem to actually work. It's still displaying the sell.

Yes, it was not correctly registering what was selected. Fixed it now.

Quote:
There's one feature that I heavily used in the past, on another similar and awesome website: an items basket.

Would be useful, will see if I can combine the item info page and the quicklist to do something awesome if your screen is wide enough, since quicklist isn't actually quite as fast as the quicklist you propose.

In addition, yes, the quicklist should be updated directly, but I haven't had a chance to do that yet.

Quote:
I added PLEX on quickbar and everything exploded!

Ehm, yes, it seems there was a problem with escaping in my search alghoritm, I apologize for any distress it caused you, but I assure you it didn't have anything to do with the quicklist :P

Quote:
Bind variables.

I use them almost everywhere, except in the really complex queries where my brain absolutely needs to see what I'm referencing.

Quote:
"Add to EMK Quickbar" is pretty nice but once that item is added, when showing this item again, the link should switch to "Remove from EMK Quickbar".

Agreed, done.

QUOTE: The LP Stores tab lists all LP items, not just entries for the item being viewed

It just looks like there are a LOT of locations where you can obtain that item to me, no different items at all (all LP and ISK cost is the same, the only thing that differs is faction, corp and location). Can you screenshot this one if you really think there's something wrong?

Developer/Creator of EVE Marketeer

Scrapyard Bob
EVE University
Ivy League
#412 - 2012-02-07 01:14:54 UTC
Out of curiosity, do we get more credits for uploading history for outdated regions? Or do we always get the same points?
Scrapyard Bob
EVE University
Ivy League
#413 - 2012-02-07 01:27:21 UTC
Callean Drevus wrote:

QUOTE: The LP Stores tab lists all LP items, not just entries for the item being viewed

It just looks like there are a LOT of locations where you can obtain that item to me, no different items at all (all LP and ISK cost is the same, the only thing that differs is faction, corp and location). Can you screenshot this one if you really think there's something wrong?


Ah, okay, I see. The mass of data made me avoid looking at it in detail because it was so repetitive. But since prices never vary at all across different stations for a particular corp it may be better to:

- Drop the Station column.
- Make the corporation name a hyper-link to information about that corporation.
- Add another page somewhere else detailing the corporation information.

Which would shorten up that list a lot. When I was looking at that tab, my interest is more along the lines of "I want this, which NPC corps sell it?", not "exactly which stations sell it". So if I want to earn a specific implant, what corps would I have to go grind for?

On the "NPC corporation information" page, you could then have tabs for:

- Stations (with Region / Constellation / System / Station / Jumps Away)
- Agents (Type / Level / Region / Constellation / System / Station / Jumps Away)
- Locator agents (Region / Constellation / System / Station / Level / Jumps Away)

Some of the above is optional and would basically be groundwork for an "agent finder" type tool. Jumps away would be a useful feature to pull the current location from the IGB.

Now, the natural downside is that you would not be able to have one big list of sortable station names to figure out where a specific implant is found. But I think that if you've earned enough LP with a particular corp by doing missions, then you should already have a fairly good idea of where they are located. And you would probably be looking at your Journal to see which corps you have enough LP earned with, which is also a corporation-central view leading to the next question of "where does this corporation have offices and how far away are they".
Scrapyard Bob
EVE University
Ivy League
#414 - 2012-02-07 01:54:26 UTC
Oops, it broke:

Warning: mysql_select_db() expects parameter 2 to be resource, boolean given in /var/www/www.evemarketeer.com/core/lib/cordb/cordb.php on line 38 Warning: mysql_ping() expects parameter 1 to be resource, boolean given in /var/www/www.evemarketeer.com/core/lib/cordb/cordb.php on line 29 Database connection #0 failed
Dragonaire
Here there be Dragons
#415 - 2012-02-07 05:06:41 UTC
Yeah I'm getting the same error on some pages now too Sad

Finds camping stations from the inside much easier. Designer of Yapeal for the Eve API. Check out the Yapeal PHP API Library thread.

Callean Drevus
Perkone
Caldari State
#416 - 2012-02-07 06:54:28 UTC
Solved now? If not, what are the pages?

Developer/Creator of EVE Marketeer

6ie
The Kiwis
#417 - 2012-02-07 13:12:11 UTC
I am getting it sporadically all over the show. Even inside windows.
Dragonaire
Here there be Dragons
#418 - 2012-02-07 16:35:09 UTC
I'm guessing from the error message you aren't checking you got an actual database connection before trying to use it. You need to check if it is returning FALSE when it can't get the connection and handle it. I also have had it on multiple different pages when I was looking at stuff yesterday but most of them would display correctly without errors if I refreshed them in the browser.

Finds camping stations from the inside much easier. Designer of Yapeal for the Eve API. Check out the Yapeal PHP API Library thread.

Callean Drevus
Perkone
Caldari State
#419 - 2012-02-07 17:36:45 UTC
Correct, I'm not catching this kind of stuff. The most important problem is that it keeps the website from functioning however.

It seems something was eating up mysql connections, thats my first guess anyway.

Developer/Creator of EVE Marketeer

Jacob Lyon Chieve
Sanguis Mortem Industrial
#420 - 2012-02-07 17:44:59 UTC
Seems to be working again for me. Was down all morning, but seems functional now.

I was worried I got black-listed for too many XML calls!

Need to know how much ore to mine in order to yield a certain order of minerals? https://forums.eveonline.com/default.aspx?g=posts&t=67477 It will even calculate how long you can expect for it to take!