Edited by: Johnny Nox on 06/09/2011 01:55:03Edited by: Johnny Nox on 05/09/2011 15:02:52edit: 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_Blueprintswhen 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