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.
 

Easy way to adjust for missing Blueprints tables

First post
Author
Previous Topic Next Topic
Badmoons
Industrial Nightmare Inc
#1 - 2014-08-09 15:43:08 UTC
My queries heavily used invBlueprintTypes and ramTypeRequirements. I've also noticed that invMetaTypes and invTypeMaterials aren't working the same. Has anyone created a view to create these tables back from the data in the new tables or is everyone changing their queries? I really don't want to rethink all of these queries and make them work again. Thanks for any insight.
Desmont McCallock
#2 - 2014-08-09 17:31:26 UTC
Badmoons
Industrial Nightmare Inc
#3 - 2014-08-09 20:25:45 UTC
Sorry, guess I should have added that I'm using MySQL.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2014-08-09 21:57:37 UTC
Badmoons wrote:
Sorry, guess I should have added that I'm using MySQL.



If you're using my conversion, you want to look at the industryActivityMaterials table, and the industryActivityProducts table.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Dragonaire
Here there be Dragons
#5 - 2014-08-09 22:00:52 UTC
There are people that already do MySQL conversions as well just need to look a round at the https://forums.eveonline.com/default.aspx?g=posts&t=360102&p=2 thread for them.

Finds camping stations from the inside much easier. Designer of Yapeal for the Eve API. Check out the Yapeal PHP API Library thread.
Badmoons
Industrial Nightmare Inc
#6 - 2014-08-09 23:26:08 UTC
Thank you Dragonaire. The recreateLegacyTables at the bottom of yaml_blueprints.php should do nicely.