| Pages: 1 2 [3] 4 :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Sable Blitzmann
In Exile.
Imperial Outlaws.
93
   |
Posted - 2013.11.24 03:23:00 -
[61] - Quote
http://eve-files.com/dl/266076
- added json directory. Every corp has it's own json file. Every offer is in the following format:
offerID:
-- typeID
-- qty
-- lpCost
-- iskCost
-- reqItems: (if applicable)
---- typeID : qty
Also, I've update the SQL dump to also include a comment on the lpStore table that represents the version of the data. You can all this via
SELECT table_comment
FROM INFORMATION_SCHEMA.TABLES
WHERE table_schema = :dbName
AND table_name = lpStore |
Drailen
ED-Technics
6
|
Posted - 2013.11.24 18:25:00 -
[62] - Quote
JSON format works like a charm! Thanks for the quick update.
|
Taal Khurin
Happy Asteroid Ltd
94
|
Posted - 2013.11.28 00:07:00 -
[63] - Quote
You completely ripped the http://www.ellatha.com/eve/LP_Stores.asp sites data that someone spent ages putting together and are now touting it as your own?
For shame! |
Mikokoel
Mining Industry Exile Foundation
HYDRA RELOADED
20
|
Posted - 2013.11.28 11:54:00 -
[64] - Quote
You fail to see that those LP websites from ellatha and chruker are outdated and that accessing their information needs complicated HTML scraping?
He offers a well thought out database with up-to-date information, in various formats, and you think it's a rip-off?
For shame!
Mikokoel | CEO of Mining Industry Exile Foundation | EvE API Development:-á
Leokokim | PvP-Character |
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
2092
|
Posted - 2013.11.28 12:25:00 -
[65] - Quote
You failed to see that the source of the information is all mentioned in the first post?
Steve Ronuken for CSM 9!
http://www.fuzzwork.co.uk/
Twitter: @fuzzysteve on Twitter |
TestBox
Center for Advanced Studies
Gallente Federation
0
|
Posted - 2013.11.28 16:34:00 -
[66] - Quote
Mikokoel wrote:You fail to see that those LP websites from ellatha and chruker are outdated and that accessing their information needs complicated HTML scraping?
He offers a well thought out database with up-to-date information, in various formats, and you think it's a rip-off?
For shame!
So lets use this in a different example -
1. Use a Robot to Scrap all of "http://eveboard.com/" characters (Chribba's awesome site).
2. Dump it into a excel spreadsheet and post it here.
3. Someone else converts that spreadsheet into SQL and other forms. find errors in some data and fixes it.
4. Makes a new thread saying Look I have awesome Character data for all you guys to use in various formats ..
5. Make a sight mention the data is from Chribba's site ...
You find this alright for people to do? |
Taal Khurin
Happy Asteroid Ltd
94
|
Posted - 2013.11.28 23:10:00 -
[67] - Quote
Mikokoel wrote:You fail to see that those LP websites from ellatha and chruker are outdated and that accessing their information needs complicated HTML scraping?
He offers a well thought out database with up-to-date information, in various formats, and you think it's a rip-off?
For shame!
I know the person that compiled all the data personally and they were in the process of updating it when they noticed your thread.
They are still very active and were very miffed about it i can tell you. |
Elmore Jones
Nebula II
22
|
Posted - 2013.11.29 09:18:00 -
[68] - Quote
While I can understand that finding you have a rival project might be off putting, this kind of rage posting isn't helping. They're both working on the same information from the same game. It's going to be a very similar end result which in no way implies bot scraping from another persons effort.
+++ Reality Error 404 - Reboot Cosmos +++ |
Leokokim
Mining Industry Exile Foundation
HYDRA RELOADED
2
|
Posted - 2013.11.29 14:18:00 -
[69] - Quote
TestBox wrote:
5. Make a sight mention the data is from Chribba's site ...
You find this alright for people to do?
You mean like here where it is in the second paragraph of the first page? (right below the TL:DR)
|
Sable Blitzmann
In Exile.
Imperial Outlaws.
93
|
Posted - 2013.11.29 23:56:00 -
[70] - Quote
Just to clear a few things up...
I've made several mentions, in the original post, to where most of this data came from, and various method I used to obtain it. I never once claimed that I was the one that gathered it all. However, I believe it's a bit unfair to portray me as someone who is profiting off of someone else's work.
- The original data was extremely out of date. I wish I kept a count on the inaccuracies I found when I was preparing for initial release. It was mind boggling, we're talking a few expansions old. Especially the whole module renaming phase; oh god that was horrible trying to investigate old names and finding their correct typeID. I'm glad to hear that the person has since made an effort to update their own database.
But I have spent hours upon hours going through and fixing inaccuracies. I have spent hours flying from station to station to personally, and manually verify most of the corps as everything was outdated. I don't feel as if I simply scraped the data, packaged it up in a neat wrapper and stuck my name on it with credits in fine print. Kudos to those that took the time to gather all the initial data and put it up. Unfortunately, stuff like that rots, and I needed up to date information.
- It was proprietary. IE: absolutely useless for anything. I needed a format that I could manipulate. So I created one. I could have kept it to myself, as the other LP stores out there have done, but I decided to release it to the greater EVE community. Sue me.
Again, kudos to those that took the time to gather initial data. But it was way out of date and proprietary. Anyone is welcome to contribute to this project if they wish so that the whole eve community can benefit. |
Taal Khurin
Happy Asteroid Ltd
94
|
Posted - 2013.11.30 01:09:00 -
[71] - Quote
I guess my only real gripe that there was no real appreciation for the original developers of the data.
I'm sure if a certain person whoses name began with "D" would get a mention he would be ok :) |
Sable Blitzmann
In Exile.
Imperial Outlaws.
93
|
Posted - 2013.11.30 01:32:00 -
[72] - Quote
Then DaOpa should speak up for himself. He's already commented in this thread and gave basically the same response you and TestBox did. I will not have my thread derailed by people who think I slighted someone's work when they themselves don't bring up the issue.
That being said, I will revise the original post to better reflect that this is a derivative work, as looking over it for the first time since I posted it it mentions it somewhat in passing, under a history heading. |
Sable Blitzmann
In Exile.
Imperial Outlaws.
93
|
Posted - 2013.11.30 01:56:00 -
[73] - Quote
And now, back to the discussion at hand...
I'm currently looking into using the LogServer to perhaps validate data and keep this thing up to date. If you open the LP Store with the log server running, it starts to print out pretty much everything you need. However, it seems to truncate after a specific size of information has printed to the LogServer.
Here's a sample of the data that pops up while accessing the LP Store of University of Caille:
http://pastebin.com/MZxQ4m9D
I'm not familiar with the LogServer at all, and I'm not sure if all information is sent to the logserver which then truncates the info before printing, or if the info is first truncated by the client then sent to the LogServer. I do know, tho, that there are ways, or used to be ways, to hook into the log server and read info as it's printed (see: the now defunct BACON software for local monitoring). And, as far as I remember, that software was not against the EULA (this may or may have not changed, I have no idea).
If anyone has any experience with this or with the LogServer, please let me know. If some software is developed that can achieve this, I can then make it a quick trek to visit the stations that need visiting and just dump the data.
Cheers! |
Sable Blitzmann
In Exile.
Imperial Outlaws.
115
|
Posted - 2014.01.21 15:39:00 -
[74] - Quote
No update, just giving this topic a little activity so it doesn't auto-lock.
Using the LogServer was a dead end, unfortunately. Oh well. |
Sable Blitzmann
In Exile.
Imperial Outlaws.
115
|
Posted - 2014.01.27 22:16:00 -
[75] - Quote
v0.9 - Rubicon 1.1
Added:
- Nestor: 1,000,000LP/100,000,000ISK for SoE corp, and 800,000LP/80,000,000ISK for The Sanctuary
- Nestor BPC: 600,000LP/150,000,000ISK for SoE corp, and 400,000LP/100,000,000ISK for The Sanctuary
Can't upload to eve-files currently, so this is being hosted on my server. |
Taleden
North Wind Local no. 612
72
|
Posted - 2014.02.19 21:38:00 -
[76] - Quote
Thanks for making this data so much easier to use. I've just started pulling it into my own projects, and in case anyone is curious (or feels inclined to spot check it), here's the current clustering of corporations who share exactly the same set of offers:
Quote:
Royal Khanid Navy
Freedom Extension
Krusual Tribe
Pator Tech School
Republic Parliament
The Leisure Group
Urban Management
Vherokior Tribe
Intaki Bank
Intaki Commerce
CBD Corporation
CBD Sell Division
Caldari Business Tribunal
Caldari Funds Unlimited
Chief Executive Panel
Echelon Entertainment
Expert Distribution
Expert Housing
House of Records
Mercantile Club
Modern Finances
Nugoeihuvi Corporation
Prompt Delivery
Science and Trade Institute
State and Region Bank
Ytiri
True Creations
CONCORD
Ardishapur Family
Carthum Conglomerate
Ducia Foundry
Further Foodstuffs
HZO Refinery
Imperial Armaments
Inherent Implants
Joint Harvesting
Noble Appliances
Nurtura
Royal Amarr Institute
Viziam
Zoar and Sons
Pend Insurance
Federal Defense Union
Ammatar Fleet
Caldari Navy
Corporate Police Force
Home Guard
Internal Security
Ishukone Watch
Peace and Order Unit
Spacelane Patrol
State War Academy
Wiyrkomi Peace Corps
Nefantar Miner Association
Imperial Shipment
Khanid Transport
The Sanctuary
Ammatar Consulate
True Power
Thukker Mix
Aliastra
Bank of Luminaire
Egonics Inc.
FedMart
Federal Administration
Federal Freight
Garoun Investment Bank
Impetus
Inner Zone Shipping
President
Quafe Company
Senate
Supreme Court
The Scope
TransStellar Shipping
University of Caille
Food Relief
Guristas
Archangels
Dominations
Guardian Angels
Brutor Tribe
Republic Fleet
Republic Justice Department
Republic Military School
Republic Security Services
Intaki Space Police
Intaki Syndicate
Sisters of EVE
Serpentis Corporation
Lai Dai Corporation
Khanid Innovation
Khanid Works
24th Imperial Crusade
Federal Intelligence Office
Federal Navy Academy
Federation Customs
Federation Navy
Tash-Murkon Family
Allotek Industries
Astral Mining Inc.
Center for Advanced Studies
Chemal Tech
Combined Harvest
CreoDron
Material Acquisition
Poteque Pharmaceuticals
Roden Shipyards
Amarr Constructions
Boundless Creation
Core Complexion Inc.
Eifyr and Co.
Minmatar Mining Corporation
Native Freshfood
Republic University
Sebiestor Tribe
Six Kin Development
State Protectorate
Outer Ring Excavations
Amarr Certified News
Amarr Civil Service
Amarr Trade Registry
Civic Court
Court Chamberlain
Emperor Family
Hedion University
Imperial Chancellor
Kador Family
Kor-Azor Family
Ministry of Assessment
Theology Council
Tribal Liberation Force
Lai Dai Protection Service
Caldari Constructions
Caldari Provisions
Caldari Steel
Deep Core Mining Inc.
Hyasyoda Corporation
Ishukone Corporation
Kaalakiota Corporation
Minedrill
Perkone
Poksu Mineral Group
Propel Dynamics
Rapid Assembly
School of Applied Knowledge
Sukuuvestaa Corporation
Top Down
Wiyrkomi Corporation
Zainou
Zero-G Research Firm
Duvolle Laboratories
Blood Raiders
Mordu's Legion
Salvation Angels
Guristas Production
Amarr Navy
Imperial Academy
Ministry of Internal Order
Ministry of War
Sarum Family
Serpentis Inquest
Trust Partners
|
Sable Blitzmann
In Exile.
Imperial Outlaws.
116
|
Posted - 2014.03.09 22:35:00 -
[77] - Quote
No new activity, just a simple bump to keep thread alive.
Apparently there will be a new ship skinning thing, with one of them available in CONCORD LP store. I will be monitoring this and will release a new version if needed. =) |
Sable Blitzmann
In Exile.
Imperial Outlaws.
118
|
Posted - 2014.03.26 05:55:00 -
[78] - Quote
Took a little while due to other things, but v0.10 is out with the addition of the Police Pursuit Navy Comet in the CONCORD LP Store, woop woop
Download here:
http://eve-files.com/dl/267604 |
Vapuk Kripit
Straight Luck No Skill
0
|
Posted - 2014.04.11 01:08:00 -
[79] - Quote
This looks to be an amazingly useful tool to a noob like me.
However, at the risk of not looking like a stats major, how would one access this data please.
Without ever having used sql - I have no idea how to access this (probable) cornucopia.
Thank you - and even if no reply eventuates. Awesome work anyway.
thanks
|
Sable Blitzmann
In Exile.
Imperial Outlaws.
119
|
Posted - 2014.04.11 03:32:00 -
[80] - Quote
You can load the SQL file into a MySQL database, where you can manipulate it from there. I'm not sure about other DB programs. I also supply a version in JSON format which should be easy to parse.
It really depends what you want to use this data for. You will need to research into both these options for this data to be useful. There's not a whole lot you can do with it out of the box - you must devise a way to store it / access it and use it for your own project. On top of that, you probably want access to the names of the items which is provided by CCP through their static database dump
I might be able to create CSV files based on the tables, so that those with spreadsheet experience can use the info... |
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
3183
|
Posted - 2014.04.11 10:21:00 -
[81] - Quote
There are, on the other hand, a few tools which use the database 
They're at the bottom of Sable's first post, allowing you to see which things worth getting with your LP
Woo! CSM 9!
http://fuzzwork.enterprises/
Twitter: @fuzzysteve on Twitter |
Berluth Luthian
Onslaught Inc
RISE of LEGION
187
|
Posted - 2014.05.07 22:21:00 -
[82] - Quote
Thanks for all your work on this guys! How is that .csv file coming Sable? I don't know how to access JSON (my problem, I know) but I can do spreadsheets.
I figure a lot of this work could be helpful insight into the upcoming module rebalancing and hope you guys can be helpful parties to that. I'd like to see NPC corps be really stron guiding forces that help to push new players' progression.
I had a really ambitious project in mind of outlining each NPC corp, their clusters of LP store offerings, the best place to stage yourself and then ideal 'next step' corps.
I'd like PvE progression to look something more like:
Start with a basic NPC corp then have to choose between corps with unique mixes of:
-Unique high value LP store items
-lower risk lower reward missions that can be done at higher volume
-some corps with a large variety of LP store items but traded for higher isk:LP exchange rates
-distance from main trade hubs
-likelihood of missions spawning outside highsec
-more corps that involve a kind of PVP aspect like FW corps (perhaps you could be a chartered employee of NPC corps occasionally being involved in periodic inter-corp trade wars that also involve the risk of being attacked by enemy chartered members, but also with the reward of MUCH higher LP returns) |
Sable Blitzmann
Aperture Harmonics
No Holes Barred
126
|
Posted - 2014.06.03 15:44:00 -
[83] - Quote
I will be adding the new Mordu LP items when I get some time in the coming days. |
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
3384
|
Posted - 2014.06.05 20:05:00 -
[84] - Quote
There are a few new other modules out there now. The drone ones.
(fed navy store) Federation Navy Drone Damage Amplifier- 30,000 lp, 12,000,000 isk, 1 DDA, 2 CN Commodore II tags, 10 CN Vice Admiral I tags, 17 CN Admiral I tags.
Federation Navy Drone Navigation Computer - 10,000 LP, 7,2000,000 isk, 1 DNA I, 89 CN Captain I tags, 112 CN captain II tags, 135 CN Captain III tags
Woo! CSM 9!
http://fuzzwork.enterprises/
Twitter: @fuzzysteve on Twitter |
Sable Blitzmann
Aperture Harmonics
No Holes Barred
127
|
Posted - 2014.06.05 21:33:00 -
[85] - Quote
Steve Ronuken wrote:There are a few new other modules out there now. The drone ones.
(fed navy store) Federation Navy Drone Damage Amplifier- 30,000 lp, 12,000,000 isk, 1 DDA, 2 CN Commodore II tags, 10 CN Vice Admiral I tags, 17 CN Admiral I tags.
Federation Navy Drone Navigation Computer - 10,000 LP, 7,2000,000 isk, 1 DNA I, 89 CN Captain I tags, 112 CN captain II tags, 135 CN Captain III tags
When were those added? And is it only fed navy? |
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
3384
|
Posted - 2014.06.06 11:31:00 -
[86] - Quote
I'm pretty sure they were added with Kronos (mentioned in the giving drones an assist devblog) And nope. There are imp navy ones. I've only checked the fed navy ones, due to being at Dodi.
33832 | Imperial Navy Omnidirectional Tracking Enhancer
33842 | Federation Navy Drone Damage Amplifier
33844 | Imperial Navy Drone Damage Amplifier
33846 | Dread Guristas Drone Damage Amplifier
33850 | Federation Navy Drone Navigation Computer
(not sure if the DG ones are just drops)
Woo! CSM 9!
http://fuzzwork.enterprises/
Twitter: @fuzzysteve on Twitter |
Sable Blitzmann
Aperture Harmonics
No Holes Barred
131
|
Posted - 2014.07.02 22:15:00 -
[87] - Quote
Well, I'm only about a month late with this...
Sorry about the delay. I help with the code for Pyfa, and with the last release I put a lot of time and energy. Couple that with the fact that these updates are largely manual manipulation of the DB, I just simply got burned out. So I've been in a hidey hole playing Minecraft for the past 3 weeks >_>
v0.11 is out with the Mordus ships: http://eve-files.com/dl/269104
This does NOT include the new drone modules, as I have to do a bit of research and manual flying around to check these (dev blog says Gal and Amarr Navy, including FW, however I don't trust the dev blogs -_-) |
Sable Blitzmann
Aperture Harmonics
No Holes Barred
132
|
Posted - 2014.07.05 15:49:00 -
[88] - Quote
Just remembered about the new mid-grade implants (or are the low-grades the new ones and mid grades are renamed???)... I assume they are in the same corps as their low/high counterparts... |
Xercodo
Xovoni Astronautical Manufacturing and Engineering
3620
|
Posted - 2014.07.19 04:18:00 -
[89] - Quote
Hey I'd like to point out that caldari navy missile aren't sold from the khanid navy LP store
(and if your DB doesn't agree then Steve needs to do an update :P)
The Drake is a Lie |
Sable Blitzmann
Aperture Harmonics
No Holes Barred
134
|
Posted - 2014.07.19 21:46:00 -
[90] - Quote
Xercodo wrote:Hey I'd like to point out that caldari navy missile aren't sold from the khanid navy LP store
(and if your DB doesn't agree then Steve needs to do an update :P)
Thanks, I'll double check soonish. Do they not have any missiles? |
| |
|
| Pages: 1 2 [3] 4 :: one page |
| First page | Previous page | Next page | Last page |