Originally by: RF Gonzo

---

pleeeeease help

---

Originally by: beldonuin

---

anyone point me to the ships, items and skills sql data dump please, seem to be missing from t20 download

thanks

---

SELECT g.groupName, t.typeName, t.description, t.basePrice
FROM
invTypes t,
invGroups g,
invCategories c
WHERE g.groupID = t.groupID
AND c.categoryID = g.categoryID
AND c.categoryID = 16
ORDER BY g.groupName, t.typeName

SELECT e.*
FROM
dgmTypeEffects te,
dgmEffects e,
invTypes t
WHERE te.effectID = e.effectID
AND t.typeID = te.typeID
AND t.typeName = 'Omnipotent';

SELECT a.attributeName, a.description, IFNULL(ta.valueInt,ta.valueFloat) as value 
/* 
IFNULL is a mysql function, 
IFNULL(expr1,expr2) returns expr2 if expr1 is null, returns expr1 otherwise
*/
FROM
dgmTypeAttributes ta,
dgmAttributeTypes a,
invTypes t
WHERE ta.attributeID = a.attributeID
AND t.typeID = ta.typeID
AND t.typeName = 'Omnipotent';

Originally by: RF Gonzo

---

I am looking for the refining/reproccessing values of ore and drone minerals (glossy compund etc.) but cant find it.
Examples: Glossy Compound has itemID 11724 and no entry in activity tab. Plaglioclase has itemID 18 and no entry...pleeeeease help

---

Originally by: beldonuin

---

anyone point me to the ships, items and skills sql data dump please, seem to be missing from t20 download

thanks

---

Originally by: Grismar

---

Originally by: beldonuin

---

anyone point me to the ships, items and skills sql data dump please, seem to be missing from t20 download

thanks

---

I think you need to take a long hard look at the invtypes table. You'll find some of it there. The skill tree (or skill pre-reqs for items) doesn't seem to be part of the export at all at the moment.

---

Originally by: "Original blog for first data dump

---

activityNone = 0
activityManufacturing = 1
activityResearchingTechnology = 2
activityResearchingTimeProductivity = 3
activityResearchingMaterialProductivity = 4
activityCopying = 5
activityDuplicating = 6
activityReverseEngineering = 7

---

Originally by: Eewec Ourbyni

---

Originally by: "Original blog for first data dump

---

activityNone = 0
activityManufacturing = 1
activityResearchingTechnology = 2
activityResearchingTimeProductivity = 3
activityResearchingMaterialProductivity = 4
activityCopying = 5
activityDuplicating = 6
activityReverseEngineering = 7

---

so activity = 8 would be... invention?

---

Quote:

---

--
-- Table structure for table `TL2MaterialsActivity`
--

DROP TABLE IF EXISTS `TL2MaterialsActivity`;
CREATE TABLE `TL2MaterialsActivity` (
`activityID` smallint(6) NOT NULL default '0',
`activity` varchar(40) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TL2MaterialsActivity`
--

/*!40000 ALTER TABLE `TL2MaterialsActivity` DISABLE KEYS */;
LOCK TABLES `TL2MaterialsActivity` WRITE;
INSERT INTO `TL2MaterialsActivity` VALUES (0,'None'),(1,'Manufacturing'),(2,'Research Technology'),(3,'Research Time Production'),(4,'Research Material Production'),(5,'Copying'),(6,'Duplicating - NOT In-game!!'),(7,'Reverse Engineering - NOT In-Game!!'),(8,'Invention?');
UNLOCK TABLES;
/*!40000 ALTER TABLE `TL2MaterialsActivity` ENABLE KEYS */;

---

Originally by: Azrael Bierce

---

anyone happen to have a pretty picture describing all the relationships somewhere?

---

Originally by: Chruker

---

Edited by: Chruker on 27/12/2006 15:57:50

Originally by: Azrael Bierce

---

anyone happen to have a pretty picture describing all the relationships somewhere?

---

I've made a pdf of the relationsships. This is not the final version, so feel free to come with corrections, and more relations. There are also a few grey lines which are IDs I don't know where to find.

EDIT:
And the link is: http://games.chruker.dk/eve_online/datadump.php

---

Originally by: Chruker

---

uhmmmm spaghetti...

Yeah it is a bit messy. Luckily you can switch off some of the layers if you view the PDF in Adobe Illustrator :-) Anyway, I'll take a look at yours and see which relations I'm missing.

BTW, was your diagram autogenerated? If so, which program did that?

---

Originally by: Vessper

---

I think you need to take a long hard look at the dgmTypeAttributes table. Check for attributeID = 182, 183 and 184 for the skill required (the value is the skillID) together with attributeID = 277, 278 and 279 for the skill level (the value is the skill level).

---

Originally by: Grismar

---

Indeed, thanks. I don't know how I managed to miss that, since looking at the old data, that's how I got it the first time ^^. Thanks anyway.

I'm still curious about the T2-table though. It seems woefully incomplete.

---

Originally by: Max Kentarii

---

Any news on the item icons?
Dev blog said that it would be out a long time ago, but as far as i can tell. It's not yet available

---

Originally by: Grismar

---

Edited by: Grismar on 19/12/2006 17:18:14
All you PHP and MySQL users, you can download the structure definitions from my website at:

http://eve.grismar.net/dbo__tables_my.zip

Changes made are noted in the query itself. Also, there are three notable bugs in the definition as released by CCP:
- missing "," after "hasType BIT NOT NULL DEFAULT 0" in invMarketGroups
- missing "," after "reprocessingHangarFlag tinyint NOT NULL DEFAULT 4" in staStations
- missing definition for TL2MaterialsForTypeWithActivity altogether

If you're new to webdevelopment, but want to get this database up and running, try XAMPP. It's free and includes an easy to setup Apache server with MySQL server. You can get a legal and free copy here:

http://www.apachefriends.org/en/xampp.html

That's a lot better than running that illegal copy of IIS with MS-SQL Server CCP forced you to use :p

Greetings,
Grismar.

---