EVE Technology Lab

Update: Trying to figure out which corps are more popular so as to have a more focused verification process. I will be verifying the 4 navies next, and Lai Dai was also suggested for the research agents. In the mean time, I have been working on my own ISK/LP conversion site. \o/

Oh good, so I won't have to feel guilty for using your EMDR script to fuel it either. =P Credit where credit it due tho, thanks for introducing me to EMDR. This thing kicks ass!

On to the topic at hand, I was asking around in the missioning forum which corps are popular so that they can be verified, where one pilot (Carniflex) said that each faction basically has 3 different types of stores: military, industrial, and exploration, and that the corps that use each store should be more or less the same. I tested this out by showing the four main factions and their corps, along with the number of LP Store offers in each corp. I figure if a corp has the same number of LP offers, then it's a good chance they share the same LP Store. This is fairly useful information and does show a lot of similarities, however it's not as cut and dry as "3 variations per faction".

I will, however, be using this as a guide. What this means is that I will use a verified corp to verify another corp without visiting the store ingame. This will cut down the time it takes to verify as I can just tab between two tabs in quick succession to find any discrepancies between two like corps. For example, I've already verified Modern Finances, and I see that Caldari Business Tribunal, Expert Distribution, Prompt Delivery, etc have similar stores (145 items each). I can use Modern Finances as a template for the verification of those corps. However, this of course opens up the possibility of errors as they will not be completely verified, only verified by relation. Such errors include missing items, added items, incorrect isk/lp cost or req items... However, from what I've seen so far with verification, lp/isk cost remains stable between the corps, as does req items, so the chance of an LP store differentiating is slim.

I will also be adding a column in `lpVerified` denoting how the corp was verified: 1 will be manual verification and 2 will be verification by relation to a like corp.

a quick one: some duplicates snuck back in

delete from lpStore where storeID in (6827, 6826, 28784);

consider:

select s.corporationID, s.typeID, s.quantity, s.lpCost, s.iskCost, group_concat(i.typeID), group_concat(distinct s.storeID)
from lpstore.lpStore s
left outer join lpstore.lpRequiredItems i on (s.storeID = i.parentID)
group by s.corporationID, s.typeID, s.quantity, s.lpCost, s.iskCost
having count(distinct s.storeID) > 1

which catches any exact duplicates

Updated OP with new version (v0.4).

Also, here's a nifty image: http://eve-files.com/dl/260764 the 4 main factions and their verification progress. Green is verified, purplish is verified with template. This does not include smaller factions (Mordu's Legion, etc) because I'm lazy.

Verified:
- Brutor Tribe
- Joint Harvesting
- Theology Council
- Six Kin Development
- Lai Dai Protection Service
- School of Applied Knowledge

Verified via Relation:
- CBD Corporation
- Prompt Delivery
- Hyasyoda Corporation
- Deep Core Mining Inc.
- Poksu Mineral Group
- Minedrill
- Caldari Provisions
- Kaalakiota Corporation
- Wiyrkomi Corporation
- Top Down
- Rapid Assembly
- Perkone
- Caldari Steel
- Zainou
- Nugoeihuvi Corporation
- Echelon Entertainment
- Ishukone Corporation
- Zero-G Research Firm
- Propel Dynamics
- Expert Distribution
- CBD Sell Division
- Sukuuvestaa Corporation
- Caldari Constructions
- Expert Housing
- Caldari Funds Unlimited
- State and Region Bank
- Chief Executive Panel
- Mercantile Club
- Caldari Business Tribunal
- House of Records
- Science and Trade Institute
- Sebiestor Tribe
- Republic Fleet
- Republic Justice Department
- Republic Security Services
- Minmatar Mining Corporation
- Core Complexion Inc.
- Boundless Creation
- Eifyr and Co.
- Native Freshfood
- Carthum Conglomerate
- Imperial Armaments
- Viziam
- Zoar and Sons
- Noble Appliances
- Ducia Foundry
- HZO Refinery
- Inherent Implants
- Amarr Certified News
- Nurtura
- Further Foodstuffs
- Royal Amarr Institute
- Imperial Chancellor
- Amarr Civil Service
- Ministry of Assessment
- Amarr Trade Registry
- Court Chamberlain
- Emperor Family
- Kador Family
- Kor-Azor Family
- Ardishapur Family
- Civic Court
- TransStellar Shipping
- Federal Freight
- Inner Zone Shipping
- Material Acquisition
- Astral Mining Inc.
- Combined Harvest
- Quafe Company
- CreoDron
- Roden Shipyards
- Allotek Industries
- Poteque Pharmaceuticals
- Impetus
- Egonics Inc.
- The Scope
- Aliastra
- Bank of Luminaire
- Garoun Investment Bank
- President
- Senate
- Supreme Court
- Federal Administration
- Hedion University
- Center for Advanced Studies
- Republic Military School
- Republic University

Hi, nice job you've done here.
For your next db-dump, would it be possible to limit the 'INSERT INTO ...' statements to insert max. 1000 rows per statement? I work with MsSql and Oracle databases (XE versions) and these can't take more than 1000...if not, well i'll just continue to insert them manually.

Will do. =)

Compared the data on Fuzzworks to actual LP Store for Home Gaurd.

Omissions
=========
[1 x Zainou 'Snapshot' Rockets RD-905],[79,375 LP],[79,375,000 ISK]

[Caldari Navy Dual 150mm Railgun],[24,000 LP],[9,600,000 ISK]
1 x Dual 150mm Railgun I
63 x Federation Navy Fleet Captain Insignia I
106 x Federation Navy Fleet Major Insignia I

[1 x Zainou 'Gypsy' Target Painting TG-905],[79,375 LP],[79,375,000 ISK]

[1 x Zainou 'Gypsy' Target Painting TG-903],[10,875 LP],[10,875,000 ISK]

[1 x Zainou 'Gypsy' Target Painting TG-901],[375 LP],[375,000 ISK]

Taking these into consideration I also checked Spacelane Patrol, LP store is exactly the same as Home Gaurd.

Hope this helps.

Neug

I appreciate the work you put into Ellatha, and it had been a great resource, however I'm not gonna mince words: it is fairly outdated with errors and, the biggest of all, proprietary which makes it useless for anything but simple lookups. I needed something tangible to manipulate, and I assume Zanto Snix did as well. Sorry if you feel slighted. =(

In other news, I took a smalk break from EVE, and thus from this project, which explains lack of posts. But I have verified a few more corps and will be releasing the next version sometime soon. \o/ progress

v0.5 is out, OP updated. This release took much longer than I had hoped, but as previously stated I took about a month long break from EVE. 85% of the corps are now verified, the remaining ones are mostly the small factions.

Achievements:
- Minmatar faction completely verified.
- SOE verified (since a lot of missioners like SOE, figured this was a priority)
- Got a couple nullsec factions verified without my alts dying in their shuttle! \o/

v0.5 - More verifications. Nothing new.
Added:
- MP-805 added to Caldari Navy store
- Caldari Navy Dual 150mm Railgun (typeID = 15815) added to some Caldari corps
- Federation Customs seems to be the same LP store as the fed navy, but was missing a chunk of items (BY-810, SE-605, EG-605, EE-605, PJ-805, SA-705). Added these items after verifying they do indeed exist in LP store (then verified LP store with relation to Fed Navy)
- Ocular Filter - Standard/Improved to Intaki Commerce and Bank
- WD-901 to Amarr Navy
Fixed:
- Mega Navy Issue for non-FW stores (storeID: 151, 153, 157, 156), changed iskCost (20000000 -> 200000000)
- storeID: 9389 & 9390 (iskCost: 16200, lpCost: 10800000) (verified with Trust Partners, not Thukker Mix)
- typeID: 28817 (iskCost 13400000 -> 113400000) for Intaki faction
- typeID: 28819 (iskCost 14200000 -> 214200000) for Intaki faction
- Required typeID: 16183 (set all quantities to 5 instead of mix of 1 & 5)
- Large Blaster/Rail Spec lpCost (3000 -> 9000) for Intaki faction
Verified:
- Caldari Navy
- Federation Navy
- Duvolle Laboratories
- Sisters of EVE
- Pator Tech School
- Trust Partners
- Intaki Bank
- Outer Ring Excavations
- Imperial Academy
- Intaki Syndicate
Verified via Relation:
- Spacelane Patrol
- State War Academy
- Wiyrkomi Peace Corps
- Peace and Order Unit
- Internal Security
- Ishukone Watch
- Home Guard
- Corporate Police Force
- Federal Navy Academy
- Federal Intelligence Office
- Federation Customs
- The Sanctuary
- Food Relief
- Vherokior Tribe
- Urban Management
- The Leisure Group
- Republic Parliament
- Krusual Tribe
- Freedom Extension
- Intaki Commerce
- Sarum Family
- Ministry of Internal Order
- Ministry of War
- Amarr Navy
- Intaki Space Police

That seems nice, but I use PostgreSQL and that scripts aren't possible :P (or I don't know how to do it). I have coded this for VB.NET 2010, as the program that I'm doing (not only LP Store, also T1 / T2 manufacturing) is in that platform. Should also work for older versions:

http://pastebin.com/raw.php?i=3FhJhJZT

Change the field names to whatever you want (are easily understandable) and the result will be 1584 distinct offers, much better that almost 30.000. The process that iterates all the original table have a duration of 45 minutes :S

EDIT: Now only have a duration of 2 minutes \o/