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.
 

SQLDump and Tier
Author
Previous Topic Next Topic
Project 69
Aurora Coalition
Synergy of Support
#1 - 2012-01-14 14:02:46 UTC
hello,

so I'm modifying my POS-Tool for the fuel blocks.
The devblog http://www.eveonline.com/devblog.asp?a=blog&nbid=3143 stated that
"Faction towers will have a 10% fuel use reduction for "tier 1" towers and a 20% fuel use reduction for "tier 2" towers (compared to their standard tower equivalents), taking them to 36/18/9 and 32/16/8 respectively for large/medium/small towers"

How do I find out the Tier of a Tower.
I see the metagroup and all, but seem to oversee the tier.

any help would be appreciated
Xander Hunt
#2 - 2012-01-14 14:33:53 UTC
You'll obviously be looking at different typeIDs to see what the specific type is, but, I don't see (from invTypes) any specific details to state what type of consumptions are involved, nor would I expect there to be any. Since most items aren't "consumers", I don't think there is anything that would link up to indicate "This tower gets this bonus". I think its a hard-coded value. So this may be a bit of a work, or, another table to references consumption types.

Doing a:

Quote:
select typeID, groupID, typeName, radius,mass,volume,capacity,portionsize,raceid,baseprice from invTypes where groupID=365 and published=1
order by RaceID, typeName


You'll get groupings of what each tower is. From there, with an additional table, you can relate the typeID to consumptionID and run the math against that.

Caldari Control Towers = 0% bonus [typeID=20062/20061/16213]
Guristas Control Towers = 10% bonus [typeID=27598/27595/27533]
Dread Guristas Control Towers = 20% bonus [typeID=27600/27597/27535]

Making a new table with the fields typeID and say bonus you could go

20062 | 0
20061 | 0
16213 | 0
27598 | 10
27595 | 10
27533 | 10
27600 | 20
27597 | 20
27535 | 20

etc.

Best I can offer on 3 hours of sleep.
Project 69
Aurora Coalition
Synergy of Support
#3 - 2012-01-14 14:44:31 UTC
many thanks.

it's all I wanted to know....

hardcoding it is then :)
Desmont McCallock
#4 - 2012-01-14 18:25:59 UTC