Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Flicky G
Flicky G Corporation
1
|
Posted - 2016.01.29 09:01:31 -
[1] - Quote
Hello,
I'm trying to learn SQL and python via writing some eve online related tools.
So far, so good although the one thing I can't find any reference to is how to determine what sized slot a module fits into.
EG. Armor Repairer I is a low slow module 10MN Afterburner I is a medium slot module
How can I determine this programatically?
I guess I just need to know what column / table the size is and I should be able to work the rest out. (no need for spoon feeding!). I've been through the schema a few times and haven't been able to find anything obviously linked to this.
A second aspect is how to work out the reprocessing output for named modules - this isn't very important as they're usually worth a lot less than the module's market value, but it's nagging at me for completeness.
Cheers F
|
Mr Mac
Dark Goliath
118
|
Posted - 2016.01.29 10:07:07 -
[2] - Quote
attributeID: 12 - Low Slot 13 - Medium Slot 14 - High Slot
You can find in dgmAttributeType table |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
5867
|
Posted - 2016.01.29 12:39:14 -
[3] - Quote
invTypeMaterials contains what you get back when you reprocess something. (used to also be the materials to make it. Not any more)
That's be at 100%, so you'll need to drop it to the 50% + scrap metal reprocessing.
Woo! CSM X!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Desmont McCallock
598
|
Posted - 2016.01.29 14:11:46 -
[4] - Quote
To save you some hassle I'm referring you to this post regarding incorrect data in the SDE about the processing materials of some modules. |
Flicky G
Flicky G Corporation
1
|
Posted - 2016.01.29 18:26:59 -
[5] - Quote
Thanks everyone - much appreciated.
F |
Flicky G
Flicky G Corporation
1
|
Posted - 2016.01.29 23:38:51 -
[6] - Quote
Mr Mac wrote:attributeID: 12 - Low Slot 13 - Medium Slot 14 - High Slot
You can find in dgmAttributeType table
This doesn't work as I expected - these values describe how many slots a ship has. Although that's also useful, these values aren't assigned to any modules.
Reading the schema for dgmAttributeType and dgmTypesAttribute was a good tip, but the only other reference I can find for anything 'like' slot, size, module, medium etc in dgmAttributeTypes is #135, which doesn't seem to be listed for any item in dgmTypeAttributes.
I'm clearly barking up the wrong tree - is anyone able to give me a nudge in the right direction?
Cheers F
Incidently, dgmAttributeType.attributeID = 633 is the meta level (for anyone searching for that)
|
Mr Mac
Dark Goliath
118
|
Posted - 2016.01.30 08:32:20 -
[7] - Quote
Flicky G wrote:Mr Mac wrote:attributeID: 12 - Low Slot 13 - Medium Slot 14 - High Slot
You can find in dgmAttributeType table This doesn't work as I expected - these values describe how many slots a ship has. Although that's also useful, these values aren't assigned to any modules. Reading the schema for dgmAttributeType and dgmTypesAttribute was a good tip, but the only other reference I can find for anything 'like' slot, size, module, medium etc in dgmAttributeTypes is #135, which doesn't seem to be listed for any item in dgmTypeAttributes. I'm clearly barking up the wrong tree - is anyone able to give me a nudge in the right direction? Cheers F Incidently, dgmAttributeType.attributeID = 633 is the meta level (for anyone searching for that)
lol! my bad!
effectID: 11 - Low Slot 13 - Medium Slot 12 - High Slot
You can find in dgmEffect table
SELECT te.effectID FROM dgmTypeEffects as te join invTypes as t on te.typeID=t.typeID join dgmEffects as e on te.effectID=e.effectID where t.typeID=1952
typeID 1952 is Sensor Booster II. Keep in mind the invTypes table is not in original MSSQL database. Use Steve's/Desmont's convertor
|
Flicky G
Flicky G Corporation
1
|
Posted - 2016.01.30 14:27:18 -
[8] - Quote
Fantastic, that's just the job. I hadn't searched for 'power', as I'd forgotten that's the in game reference!
I'm using Steve's SQL version, here's the sqlite3 statement for anyone else interested
SELECT dgmTypeEffects.effectID, dgmEffects.effectName FROM dgmTypeEffects JOIN dgmEffects ON dgmTypeEffects.effectID = dgmEffects.effectID WHERE dgmTypeEffects.typeID = 1952;
Gives:
13|medPower 16|online 2670|sensorBoosterActivePercentage 5757|overloadSelfSensorModuleBonus
Many Thanks F |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |