open All Channels
seplocked EVE Technology Lab
blankseplocked mysql datadump and npc information
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Milaana
Posted - 2011.05.02 19:35:00 - [1]
 

Edited by: Milaana on 02/05/2011 19:35:32
hi,

I cant achieve finding the npc-pirate information, like shield resist, hp, warfare, etc. I dont see where are the relation between the typeID in invTypes table and the 'dgmtypeattributes' table.

Maybe I had to look in *effects* tables ? someone would already have a query to show me? thanks.


Lutz Major
Posted - 2011.05.03 06:57:00 - [2]
 

They are not available in the official database dump anymore.

They once were, but might be already out-of-date.

Milaana
Posted - 2011.05.03 15:48:00 - [3]
 

Edited by: Milaana on 03/05/2011 16:56:10
thanks you, now its clear.

Maybe you or someone can tell me to which version of the export I can find those information (even if they are deprecated), like a mirror or an old application distributed with the old db. I think I have a Quantum Rise data export somewhere.

thanks again.

---
edit:

I found an 'hybrid' dump provided by jovelabs.com/community/ which is based on the old revelation dump.


If someone had a zip of the original revelation dump, would be very happy Rolling Eyes

Jercy Fravowitz
School of Applied Knowledge
Posted - 2011.05.04 07:35:00 - [4]
 

Originally by: Milaana
If someone had a zip of the original revelation dump, would be very happy

CCP Toolkit Release History

also, my extensive 2 minute research of running "select count(*) from dgmTypeAttributes where typeID=24087" against older SDE versions indicates they were removed starting Apocrypha, so grabbing the QR one might be your best bet.


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only