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.
 

Skills sheet

First post
Author
Jt Greet
Tradors'R'us
IChooseYou Alliance
#1 - 2015-03-05 22:49:57 UTC
Where do I get skills list with modifiers for every level increase with training multipliers. requirements for them.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2015-03-06 11:47:22 UTC
That would be in dgmTypeAttributes, from the SDE. (both rank and requirements)

you'd determine which attribute from dgmAttributeTypes.

you'd determine the typeid for the skill from invTypes.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Jt Greet
Tradors'R'us
IChooseYou Alliance
#3 - 2015-03-06 12:22:41 UTC  |  Edited by: Jt Greet
r we sure we're both talking about skills here? I got the sde, no skills.
Hel O'Ween
Men On A Mission
#4 - 2015-03-06 17:13:55 UTC
Jt Greet wrote:
r we sure we're both talking about skills here? I got the sde, no skills.


select TOP 10 typeID, typeName from invTypes where groupID = 257

3184    ORE Industrial                                                                                     
3327    Spaceship Command                                                                                   
3328    Gallente Frigate                                                                                   
3329    Minmatar Frigate                                                                                   
3330    Caldari Frigate                                                                                     
3331    Amarr Frigate                                                                                       
3332    Gallente Cruiser                                                                                   
3333    Minmatar Cruiser                                                                                   
3334    Caldari Cruiser                                                                                     
3335    Amarr Cruiser                                                                                       



Looks pretty "skillish" to me ...

EVEWalletAware - an offline wallet manager.

Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2015-03-06 17:41:19 UTC
Jt Greet wrote:
r we sure we're both talking about skills here? I got the sde, no skills.



I know which SDE I'm talking about...

The one referenced in https://forums.eveonline.com/default.aspx?g=posts&t=405047 both the original, and the converted versions.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Jt Greet
Tradors'R'us
IChooseYou Alliance
#6 - 2015-03-06 18:31:47 UTC
So i got that, i see no skills. whats the ******* file of 170mb size.
Hel O'Ween
Men On A Mission
#7 - 2015-03-07 10:34:05 UTC
Which RDBMS are you using? MySQL, Postgres, MS SQL ...?

And if you're not using the official MS SQL from CCP, where'd ya got your conversion from?

EVEWalletAware - an offline wallet manager.

Jt Greet
Tradors'R'us
IChooseYou Alliance
#8 - 2015-03-07 11:40:56 UTC
I got OpenOffice cuz yahoo answers said that it opens .db format, but ill get the mysql.
Jt Greet
Tradors'R'us
IChooseYou Alliance
#9 - 2015-03-07 20:46:47 UTC
so neither work