open All Channels
seplocked EVE Technology Lab
blankseplocked [Solved]: Getting blueprint information from database, was not working
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Johnny Nox
Posted - 2011.09.05 14:54:00 - [1]
 

Edited by: Johnny Nox on 06/09/2011 01:55:03
Edited by: Johnny Nox on 05/09/2011 15:02:52
edit: changed topic to reflect im asking the question of why im not getting proper information returned from the database with blueprint information.
------------------
edit2: changed topic to solved found solution on my own posted for others to enjoy/share
--------------------------------------------------------------------------------------------------------------------------------
Im using eve_online_incarna_1.1 database

i found info on this page
http://wiki.eve-id.net/Published_Blueprints

when i go to plug this info into my php script, or via phpmyadmin (off the root db sql)
i get both to return about 549 Records found, when in fact doing a like %blueprint% just on the table of
------ sql query -----
SELECT *
FROM `invtypes`
WHERE `typeName` LIKE '%blueprint%'
----------------------
returns 2,472 total records
the 2k number seams a bit more realistic as there are non published BP's and if i do a listing of
nvblueprinttypes i get 3,232 total records, so the 2k number seams about right give or take.

so my question is how do i return ALL published records and whats going wrong with the code on the
http://wiki.eve-id.net/Published_Blueprints site thats missing blueprints.

thank you in advance for any code or help you may provide.
id really like to get a listing of all the BP's, next is there information sheets
Johnny
my sample php file for clarity (mind you its a work in progress, and im just trying to get information form the database)
http://dragonsworkshop.com/blueprint2.phps

Lutz Major
Posted - 2011.09.05 17:45:00 - [2]
 

Icon fetching works differently now, so that query is out of date.

If you want all published blueprints, then I suggest you query them appropriately by joining the invBlueprintTypes with the invTypes table.

Johnny Nox
Posted - 2011.09.05 22:04:00 - [3]
 

thanks for the reply
so then would
------ sql query -----
SELECT *
FROM `invtypes`
WHERE `typeName` LIKE '%blueprint%'
----------------------
be my query not including all the dodads to add for other join information
or has anyone got an updated code block for this?
i am really bad at join routines.

Johnny Nox
Posted - 2011.09.06 01:37:00 - [4]
 

i tried to do this from scratch and i came up with

------------ sql query -----

select invtypes.graphicID, invtypes.iconID, invtypes.typename, invtypes.groupID, invblueprinttypes.blueprinttypeid, invblueprinttypes.maxProductionLimit
from invblueprinttypes, invtypes
where
invblueprinttypes.blueprinttypeid = invtypes.typeid and invtypes.published = 1
-----------------
and this returns the what i belive are the correct blueprint amounts.
im not understanding yet how the
http://wiki.eve-id.net/Published_Blueprints
is getting return information like
typeID Item ItemGroup ItemCategory
as it joins the tables, and how its referenced.
i still dont get why the wiki example wont work filly, and only returns around 600 records or so. that are correctly listed

still looking for a solution here

Johnny Nox
Posted - 2011.09.06 01:52:00 - [5]
 

i did it!!!! yippeee~~~~~
heres the info so other can do the same if they want too
-------sql query ------
SELECT blueprintType.typeID,
blueprintType.typeName Blueprint,
productType.typeID,
productType.typeName Item,
productGroup.groupName ItemGroup,
productCategory.categoryName ItemCategory,
blueprintType.graphicID,
blueprintType.iconID,
blueprints.productionTime,
blueprints.techLevel,
blueprints.researchProductivityTime,
blueprints.researchMaterialTime,
blueprints.researchCopyTime,
blueprints.researchTechTime,
blueprints.productivityModifier,
blueprints.materialModifier,
blueprints.wasteFactor,
blueprints.maxProductionLimit
FROM invBlueprintTypes AS blueprints
INNER JOIN invTypes AS blueprintType ON blueprints.blueprintTypeID = blueprintType.typeID
INNER JOIN invTypes AS productType ON blueprints.productTypeID = productType.typeID
INNER JOIN invGroups AS productGroup ON productType.groupID = productGroup.groupID
INNER JOIN invCategories AS productCategory ON productGroup.categoryID = productCategory.categoryID
WHERE blueprintType.published = 1
-----------------------

here's some of the output(sorry it does not look pretty outputted here)
2472 Records found
typeID Blueprint typeID Item ItemGroup ItemCategory graphicID iconID productionTime techLevel researchProductivityTime researchMaterialTime researchCopyTime researchTechTime productivityModifier materialModifier wasteFactor maxProductionLimit
683 Bantam Blueprint 582 Bantam Frigate Ship 38 6000 1 120000 120000 120000 90000 1200 5 10 30
684 Condor Blueprint 583 Condor Frigate Ship 39 6000 1 120000 120000 120000 90000 1200 5 10 30
685 Griffin Blueprint 584 Griffin Frigate Ship 40 6000 1 120000 120000 120000 90000 1200 5 10 30
686 Osprey Blueprint 620 Osprey Cruiser Ship 41 12000 1 240000 240000 240000 180000 2400 5 10 15
687 Caracal Blueprint 621 Caracal Cruiser Ship 42 12000 1 240000 240000 240000 180000 2400 5 10 15
688 Raven Blueprint 638 Raven Battleship Ship 43 18000 1 360000 360000 360000 270000 3600 5 10 10
689 Slasher Blueprint 585 Slasher Frigate Ship 44 6000 1 120000 120000 120000 90000 1200 5 10 30


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only