Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Aura Snickers
Whisky Tango Foxtrot
0
|
Posted - 2013.01.19 15:47:00 -
[1] - Quote
How would I go about limiting my query vs the data dump to only return tech1 blueprints? I don't want any named, faction, techII, ect... Just the basic tech one versions.
Thanks :) |
Steve Ronuken
Fuzzwork Enterprises
1082
|
Posted - 2013.01.19 17:12:00 -
[2] - Quote
join the blueprints table against dgmTypeAttributes, on the producttypeid=typeid, with attributetypeid 633, and valueint or valuefloat being equal to 1. FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities.As well as mysql and CSV/XLS conversions of the Static Data Extract. |
Aura Snickers
Whisky Tango Foxtrot
0
|
Posted - 2013.01.19 18:11:00 -
[3] - Quote
This gives me;
mysql> SELECT -> it.typeName as productName -> FROM invBlueprintTypes ibt -> JOIN dgmTypeAttributes dta ON dta.typeID = ibt.productTypeID AND dta.attributeID = 633 AND (dta.valueInt = 1 OR dta.valueFloat = 1) -> JOIN invTypes it ON ibt.productTypeID = it.typeID; +-----------------------------------------------------+ | productName | +-----------------------------------------------------+ | Large Micro Jump Drive | | Large Ancillary Shield Booster | | Reactive Armor Hardener | | Target Spectrum Breaker | | Partial Weapon Navigation | | 'Daemon' Codebreaker I | | 'Codex' Codebreaker I | | 'Alpha' Codebreaker I | | 'Libram' Codebreaker I | | 'Crop' Gas Cloud Harvester | | 'Plow' Gas Cloud Harvester | | Legion Electronics - Energy Parasitic Complex | | Legion Electronics - Tactical Targeting Network | | Legion Electronics - Dissolution Sequencer | | Legion Electronics - Emergent Locus Analyzer | | Tengu Electronics - Obfuscation Manifold | | Tengu Electronics - CPU Efficiency Gate | | Tengu Electronics - Dissolution Sequencer | | Tengu Electronics - Emergent Locus Analyzer | | Proteus Electronics - Friction Extension Processor | | Proteus Electronics - CPU Efficiency Gate |
(more records I removed)
+-----------------------------------------------------+ 94 rows in set (0.01 sec)
Did I do something wrong? None of these are basic tech1 items.
Thank you |
NickyYo
StarHug
302
|
Posted - 2013.01.19 18:43:00 -
[4] - Quote
Aura Snickers wrote:This gives me;
mysql> SELECT -> it.typeName as productName -> FROM invBlueprintTypes ibt -> JOIN dgmTypeAttributes dta ON dta.typeID = ibt.productTypeID AND dta.attributeID = 633 AND (dta.valueInt = 1 OR dta.valueFloat = 1) -> JOIN invTypes it ON ibt.productTypeID = it.typeID; +-----------------------------------------------------+ | productName | +-----------------------------------------------------+
What program did you use to query the database and get that format as a return? Command line? .. |
Steve Ronuken
Fuzzwork Enterprises
1083
|
Posted - 2013.01.19 19:14:00 -
[5] - Quote
I'm an idiot.
Those are all Meta 1 items. It should have been 0, rather than 1.
SELECT it.typeName as productName FROM invBlueprintTypes ibt JOIN dgmTypeAttributes dta ON dta.typeID = ibt.productTypeID AND dta.attributeID = 633 AND (dta.valueInt = 0 OR dta.valueFloat = 0) JOIN invTypes it ON ibt.productTypeID = it.typeID; FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities.As well as mysql and CSV/XLS conversions of the Static Data Extract. |
Aura Snickers
Whisky Tango Foxtrot
0
|
Posted - 2013.01.20 02:20:00 -
[6] - Quote
Thank you very much, I ended up with;
SELECT it.typeName as productName FROM invBlueprintTypes ibt JOIN dgmTypeAttributes dta ON dta.typeID = ibt.productTypeID AND dta.attributeID = 633 AND (dta.valueInt = 0 OR dta.valueFloat = 0) JOIN invTypes it ON ibt.productTypeID = it.typeID ORDER BY it.typeName DESC;
It returned 858 items and quick passover seemed to all be basic tech1 stuff. I really appreciate the help.
@NickyYo -- Yes that is command line mysql. There are some great GUI for mysql but I just prefer command line.
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |