EVE Search - LP Store in SQL format -- v0.1

Check My IP Information

All Channels

EVE Technology Lab

LP Store in SQL format -- v0.1

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

Pages: 1 [2] 3 4 :: one page

Author	Thread Statistics \| Show CCP posts - 0 post(s)
Sable Blitzmann Fweddit I Whip My Slaves Back and Forth 55	Posted - 2013.02.21 19:41:00 - [31] - Quote Skalarik wrote: 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. =)
Neugeniko Insight Securities 12	Posted - 2013.03.04 15:02:00 - [32] - Quote This is excellent! A little while back I was looking for this data to work out isk/lp. It seems like a few people are working on this already, so ill do what I can to help with the core data. Torrinos system is pretty popular for mission runners seeking a caldari 0.5 system with a few lvl 4 agents. Homegaurd and Spacelane patrol LP stores are there, ill compare these to the data up on fuzzworks and see if its accurate. Neug
Neugeniko Insight Securities 12	Posted - 2013.03.05 21:35:00 - [33] - Quote 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
DaOpa Static Corp 9	Posted - 2013.04.05 18:41:00 - [34] - Quote Hundreds of hours of personal work to generate LP Store DB, only to be undone by a scraper and others who are republishing scraped data ..... I'm lost for words.... DaOpa's EVE Fansite \|\|Wormhole Database / Wormhole Systems Lookup Tool \|\|Live Streamer at twitch.tv/daopa
Sable Blitzmann Fweddit I Whip My Slaves Back and Forth 62	Posted - 2013.04.06 00:34:00 - [35] - Quote DaOpa wrote: Hundreds of hours of personal work to generate LP Store DB, only to be undone by a scraper and others who are republishing scraped data ..... I'm lost for words.... 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
Tonto Auri Vhero' Multipurpose Corp 55	Posted - 2013.04.06 12:01:00 - [36] - Quote Sable Blitzmann wrote: DaOpa wrote: Hundreds of hours of personal work to generate LP Store DB, only to be undone by a scraper and others who are republishing scraped data ..... I'm lost for words.... 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. Even for simple lookups, it was hardly useful. My every attempt to narrow search to at least a single page of results failed in the past.
Sable Blitzmann Fweddit I Whip My Slaves Back and Forth 62	Posted - 2013.04.14 23:43:00 - [37] - Quote 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
Uppsy Daisy 24th Imperial Crusade Amarr Empire 243	Posted - 2013.04.15 22:17:00 - [38] - Quote Now that is dedication.. I salute you/
Jess Technite Almost Absolute 0	Posted - 2013.04.25 00:42:00 - [39] - Quote Working with your database have discovered an error with a CONCORD offer (not verified all, only this ID, and only by Ellatha, so no sure if in-game is correct): SELECT * FROM LPStore WHERE typeID = 3963 This is the ID of the Blueprint, and indeed should be the ID of the item: UPDATE LPStore SET typeID = 3962 WHERE typeID = 3963 Ydnari wrote: Sable Blitzmann wrote: I would be interested in that script if you could post it. I may be able to use it. tables: http://pastebin.com/raw.php?i=9BSTQWLQ script (Perl): http://pastebin.com/raw.php?i=hf18kJ6j needs your tables renaming to "oldLpStore" and "oldLpRequiredItems" before running Sable Blitzmann wrote: Also, what do you mean by this: Quote: There's some duplicate offers for same item in same corp in there. I thought I removed all the duplicates. =( Looks like in the end there's only one - EE-605 for Mordu's Legion, the offer looks right but there's two of them (ids 1992, 4039). Seems nice... if you have MySQL XD. I use PostgreSQL and this is not possible (or I don't know how to do it), so when I have some time will do it in VB.NET 2010 for separate it in two tables (It's a personal software in this language), and will paste it here.
Sable Blitzmann Fweddit I Whip My Slaves Back and Forth 63	Posted - 2013.04.27 17:32:00 - [40] - Quote Just a heads up, the database schema will most likely be changing with the next release. I'm gonna base it mostly on Ydnari's approach (https://forums.eveonline.com/default.aspx?g=posts&m=2546104#post2546104). Since a lot of the data in the database is redundant, I aim to slim it up a bit. I'm doing this because my lpStore application (which I've been procrastinating with releasing, ugh) would benefit from it. Let me know if there's any concerns with this new approach Jess Technite wrote: The process that iterates all the original table have a duration of 45 minutes :S Really? Yikes! x_x

Steve Ronuken Fuzzwork Enterprises 1339	Posted - 2013.04.27 20:03:00 - [41] - Quote Let me guess Jess Technite, you added, umm, one index, and it sped it up? Anytime a DB app is slow, indexes will probably help Steve Ronuken for CSM 9!-á I'm starting early :) Handy tools and an SDE conversion Twitter: @fuzzysteve on Twitter
Sable Blitzmann Fweddit I Whip My Slaves Back and Forth 64	Posted - 2013.04.29 05:32:00 - [42] - Quote Put together the release with the database schema changes. Updated schema can be found here: http://pastebin.com/yxiMSeWJ Changelog: - The way that data has been laid out. NO ADDITIONAL VERIFICATION HAS TAKEN PLACE, this release is strictly an update to how the database is organized. - Each offer is now unique and stored in the `lpOffers` table. This reduces redundant information, making the data slighty more compact (which makes is slightly more faster) - Offers are linked to corps via `lpStore` - Required items are much the same (besdies now pointing to unique offers), the table has been relabeled as `lpOfferRequirements` - Included in this release is a table labeled `lpConversion`. This table documents the change from the old ID (storeID) to the new, combined ID (offerID). This table will not be inclded in future releases Updated OP with link to download
Jess Technite Almost Absolute 0	Posted - 2013.05.02 17:35:00 - [43] - Quote Sable Blitzmann wrote: Just a heads up, the database schema will most likely be changing with the next release. I'm gonna base it mostly on Ydnari's approach (https://forums.eveonline.com/default.aspx?g=posts&m=2546104#post2546104). Since a lot of the data in the database is redundant, I aim to slim it up a bit. I'm doing this because my lpStore application (which I've been procrastinating with releasing, ugh) would benefit from it. Let me know if there's any concerns with this new approach Jess Technite wrote: The process that iterates all the original table have a duration of 45 minutes :S Really? Yikes! x_x Nah, it's only Ydnari's approach in VB.NET code :) BTW, I don't know why the university (Software Engineering finished in January) decided to use PostgreSQL -¼-¼ Steve Ronuken wrote: Let me guess Jess Technite, you added, umm, one index, and it sped it up? Anytime a DB app is slow, indexes will probably help In fact, it's the same in three tables. When I iterate for calculating the LP/ISK ratio over all the rows, I only iterate over 1.584 rows (2 minutes) and not over the 29.070 (45 minutes) original ones. When the process is finished, I select the most worth and when I want to see their details, will query to the lpcorps with the offerID and also won't need to iterate over that huge amount of rows. More light :). But well, maybe that index in the lpCorps also plays his paper
Sable Blitzmann Fweddit I Whip My Slaves Back and Forth 65	Posted - 2013.06.04 02:14:00 - [44] - Quote Updated for Odyssey. Changelog: v0.5.2 - Navy Battlecruisers Added Another small point release as it doesn't contain any verifications, this release adds the new navy Battlecruisers introduced in Odyssey (from Odyssey 1.0 Patchnotes) Added: - All 4 Navy Battlecruisers - this process was automated by adding the battlecruisers to corporations already offering Navy cruisers - All 4 Navy Battlecruiser Blueprint copies were also added via the above method (using Built Cruisers ) - FW stores got their own offer with the discounted prices Changed: - Armageddon Navy Issue, Scorpion Navy Issue, Dominix Navy Issue, Typhoon Fleet Issue have had their LP cost increased to 250,000 LPs in the Factional Warfare LP Stores. Confirm: - There are a few corporations that offer mostly blueprints - I am not sure if they offer ship blueprints and if so if they offer the new navy BC blueprints. This needs to be confirmed, and if so, needs to be added
Sable Blitzmann Fweddit I Whip My Slaves Back and Forth 65	Posted - 2013.06.05 17:05:00 - [45] - Quote So, this snuck up in the expansion (thanks to Artemis Anva pointing it out) - Navy Cap Boosters are now available in sizes of 25, 50 and 75, which are available through FW LP Stores. - Navy Cap Booster 100 and 150 are now m-ore expensive when purchased in the LP Store. v0.5.2 does not cover these changes. I will have to look at them throughout the week when I get a chance, unless someone can provide screenshots of the new prices (remember, FW stores can vary in price from regular stores!). CCP didn't think it pertinent to include the new/updated prices in the patch notes
Sable Blitzmann Fweddit I Whip My Slaves Back and Forth 65	Posted - 2013.06.06 14:24:00 - [46] - Quote v0.5.3 is out with Navy Cap Booster changes for Odyssey. OP has been updated Changelog: v0.5.3 - Navy Cap Booster Changes This version includes the navy cap booster changes that shipped with Odyssey Added: - Navy cap booster 25, 50, and 75 added to FW LP Stores, cost: 60, 125, 185 in LP and 60000, 125000, 185000 isk respectively Changed: - Navy cap booster 100 and 150 prices raised to 250 and 375 lp and 250000 and 375000 isk respectively Confirm: - (from before) There are a few corporations that offer mostly blueprints - I am not sure if they offer ship blueprints and if so if they offer the new navy BC blueprints. This needs to be confirmed, and if so, needs to be added
Steve Ronuken Fuzzwork Enterprises 1495	Posted - 2013.06.06 16:20:00 - [47] - Quote bah, changed database structures make me have to rewrite SQL ah well, at least changes were highlighted that I needed to take care of. .= and += can lead to very different answers ;) (in case I've not mentioned it, https://github.com/fuzzysteve/lpstore it depends on a memcache DB for price data, but if you don't have it, it'd be simple enough to replace with, say, database calls. I wouldn't recommend hitting eve central or eve market data individually for each price. ) Steve Ronuken for CSM 9!-á I'm starting early :) Handy tools and an SDE conversion Twitter: @fuzzysteve on Twitter
Sable Blitzmann In Exile. Imperial Outlaws. 66	Posted - 2013.07.04 04:48:00 - [48] - Quote OP Updated Thanks to those who mailed me about the changes to Navy Cruisers in Odyssey (thanks CCP for not including that in the patch notes). Note: these changes only affect the FW stores. v0.6 - FW Navy Cruiser Fixes I decided to bump this release up to a 0.x point release even tho no verification has been done due to significant changes have been done since v0.5. It was brought to my attention that CCP changed the Navy Cruiser requirements and added blueprints for FW stores. Added: - 2x Blueprints for the previous tier1 cruisers have been added to each FW corp, with prices at 45000 LP and either 5000000 isk or a cruiser-class pirate tag Changed: - Previous Tier1 Navy Cruisers have had their LP cost increased to 45000 for FW corps to bring in line with other Navy cruisers
Chic Botany Pator Tech School Minmatar Republic 31	Posted - 2013.07.27 08:45:00 - [49] - Quote Kudos for doing this, and when I get my head round sql I'll have a look. The only gripe is WHY THE HELL DOESN'T CCP GIVE THIS INFORMATION FREELY IN THE DUMPS ETC, it's not like it's confidential info or anything.
Sable Blitzmann In Exile. Imperial Outlaws. 72	Posted - 2013.08.31 17:45:00 - [50] - Quote lpDatabase should be updated very soon after Odyssey 1.1 hits. I have all the changes queued, I just need to know the new typeIDs for the various new store items (gotta wait for the SDE to come out as I'm too lazy to gather it from the test server).

Sable Blitzmann In Exile. Imperial Outlaws. 73	Posted - 2013.09.02 23:00:00 - [51] - Quote Updated for Odyssey 1.1: http://dl.eve-files.com/media/1309/lpDatabase_v0.7.zip v0.7 - Odyssey 1.1 Odyssey 1.1 introduced new mindlinks to stores. This has obviously not been verified as it was all automated based on what CCP has stated in forum posts / patch notes Added: - Navy Mindlinks added to their respective stores for 100,000,000 isk / 100,000 lp. Per CCP, Navy Mindlinks were added to every racial store, including FW stores. I took all corps belonging to each of the four main factions and autmatically added their respective Mindlink (Imperial Navy Warfare Mindlink for all of Amarr faction with LP store). This has obviously not been verified as it was automated - Added T2 mindlinks to CONCORD LP Store for 20,000,000 isk / 20,000 LP
Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM 1858	Posted - 2013.09.03 13:17:00 - [52] - Quote I've been informed that for the Fed Navy Comet, it should be using an Incursus, rather than a Tristan Steve Ronuken for CSM 9!-á I'm starting early :) Handy tools and an SDE conversion Twitter: @fuzzysteve on Twitter
Sable Blitzmann In Exile. Imperial Outlaws. 73	Posted - 2013.09.03 17:27:00 - [53] - Quote Steve Ronuken wrote: I've been informed that for the Fed Navy Comet, it should be using an Incursus, rather than a Tristan Thank you. I've check a couple stations and this is indeed the case. I wonder if this was a recent change, because I remember it being Tristins
Jess Technite Almost Absolute 0	Posted - 2013.09.19 09:55:00 - [54] - Quote For all those that (like me) use PostgreSQL there's a conversion of the file published by Sable Blitzmann in #51: http://dl.eve-files.com/media/1309/lpDatabase.zip
Sable Blitzmann In Exile. Imperial Outlaws. 86	Posted - 2013.10.22 06:12:00 - [55] - Quote v0.7.1 - Cruiser BP Fixes Removed: - With v0.6, new Navy Cruiser BPCs were added to the FW store. Unfortunately, all BPCs were added to all FW stores. This removes the erronous entries. (Thanks Mr Turing!) Changed: - Fed Navy Comet required item changed from Tristan to Incursus (Thanks Steve!)
Sable Blitzmann In Exile. Imperial Outlaws. 86	Posted - 2013.11.16 04:51:00 - [56] - Quote Update for Rubicon 1.0: http://eve-files.com/dl/265883 v0.8 - Rubicon 1.0 Added: - Astero: 100,000LP/10,000,000ISK for SoE corp, and 80,000LP/5,000,000ISK for The Sanctuary - Astero BPC: 30,000LP/15,000,000ISK for SoE corp, and 20,000LP/10,000,000ISK for The Sanctuary - Stratios: 300,000LP/20,000,000ISK for SOE corp, and 240,000LP/15,000,000ISK for The Sanctuary - Stratios BPC: 120,000LP/30,000,000ISK for SoE corp, and 80,000LP/20,000,000ISK for The Sanctuary Also, OP is getting too big. Copying changelog to this post until I figure out what to do with it. I don't want to lose links to previous versions in case someone is interested in them for whatever reason. =) v0.8 - Update for Rubicon 1.0 v0.7.1 -Point release for fixes v0.7 - Updated for Odyssey 1.1 v0.6 - Fixes changes made in Odyssey v0.5.3 - Point release. Includes Navy Cap Booster changes/addition with Odyssey. v0.5.2 - Point release. Navy Battlecruisers added for Odyssey expansion! v0.5.1 - Point release. Database schema has changed to remove redundancy, please see this post for changes. v0.5 - Nothing really new with this release besides the continued fixes. v0.4 - With this release, I took the easy way out. As described here, I've started to use already-verified corps as a template for other verifications. Many corps in the game share the same LP store, and so I set up a script that would compare multiple corps to a template corp. Template corps are always manually verified. v0.3 - Second round of fixes include all 4 FW LP Stores. I tried to focus on them as they are very important in the LP Store business, and making sure that the data was correct was a priority (this also knocks out 4 of the biggest corps to verify \o/). v0.2 - First round of verification's and fixes tot he database. Some items are still out of whack, but I believe that some of the more glaring ones are under control now. I have personally verified 5 corps so far. That's a far cry from the few hundred that there are, but it's a start. v0.1 - initial release. Data might not be up to par. NEED TESTERS
Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM 2063	Posted - 2013.11.16 17:32:00 - [57] - Quote Thanks Steve Ronuken for CSM 9! http://www.fuzzwork.co.uk/ Twitter: @fuzzysteve on Twitter
Drailen ED-Technics 6	Posted - 2013.11.23 22:34:00 - [58] - Quote Been admiring this work for a while and would like to start using it, but...any chance of a version that doesn't require MySQL to be installed? CSV, MSSQL, SQLite would be great if it's available.
Sable Blitzmann In Exile. Imperial Outlaws. 92	Posted - 2013.11.23 23:37:00 - [59] - Quote Drailen wrote: Been admiring this work for a while and would like to start using it, but...any chance of a version that doesn't require MySQL to be installed? CSV, MSSQL, SQLite would be great if it's available. I've been floating the idea of making json version available which should be easy to then convert to any other format. This will give me an excuse to do that. I'll try to get something out by tomorrow. =)
Drailen ED-Technics 6	Posted - 2013.11.23 23:43:00 - [60] - Quote That would be great, thanks!



Pages: 1 [2] 3 4 :: one page
First page \| Previous page \| Next page \| Last page

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.