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.
 

Ship tech level from DB dump
Author
Previous Topic Next Topic
Ideki
Wolf Brothers INC
United Neopian Federation
#1 - 2012-04-02 16:41:46 UTC
Is it possible to get a ship tech level from the database?

Example:

Tengu = tech3
Bantam = tech1

I have been looking in the database and so far no luck.

Creator of The EVE Planetary Planner
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2012-04-02 17:04:34 UTC
There's always

select techLevel from invTypes,invBlueprintTypes where typename='Tengu' and productTypeID=typeID;

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Ideki
Wolf Brothers INC
United Neopian Federation
#3 - 2012-04-02 18:41:02 UTC
Works perfectly.
Thanks a lot Big smile

Creator of The EVE Planetary Planner