EVE Search - Trinity 1.0 Static Data Export

Check My IP Information

All Channels

EVE Technology Lab

Trinity 1.0 Static Data Export

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

Pages: 1 [2] 3 4 :: one page

Author	Thread Statistics \| Show CCP posts - 3 post(s)
Simmith Royal Geographic Society Safe And Fun Environment	Posted - 2007.12.18 11:18:00 - [31] Originally by: DaOpa Question for a couple of the provided tables .. I see there is one for Agt Offer Details.. This shows all the different types of LP offers.. My question is .. would I be missing a table that shows what LP Offers go with the corps? Or is that information just not provided .. ! K thnx I have the same issue, no info seems to be provided about which corps offer what candy, as such its unusable in any LP database. /Sim LP Store Database \| ME Evaluator
Jedzias Miezekatze	Posted - 2007.12.18 20:37:00 - [32] Hmmmmmm INSERT INTO TL2MaterialsForTypeWithActivity (typeID,activity,requiredTypeID,quantity,damagePerJob) VALUES(784,1,34,-660,1); ... and so on. gives things like: blueprintTypeIDgroupIDmarketGroupIDproductTypeIDtypeNameactivityactivityNamequantitydamagePerJobrequiredTypeIDrequiredTypeName 10644411986Basilisk Blueprint1Manufacturing-189848134Tritanium (another wrong? line) you see the minus in the quantity value ?. May i ask if its possible you export correct data ?
Wardo21 The Arcanum	Posted - 2007.12.18 21:09:00 - [33] Originally by: Jedzias Miezekatze you see the minus in the quantity value ?. May i ask if its possible you export correct data ? I seem to recall that the negative numbers are the quantities required for lesser items. In the example you gave, that would be the trit that goes into the Osprey required for the Basilisk. Something to do with the costs of an item I think. The interface looks at the negatives when figuring the base cost of a Basilisk (as positive numbers of course). And the interface doesn't display the negative numbers in the BP show info screen. I may be wrong on this, so take it with a grain of salt... Wardo21
Jedzias Miezekatze	Posted - 2007.12.18 23:22:00 - [34] Thx Wardo21. i will take a look into this and invent the wheel new.
Jedzias Miezekatze	Posted - 2007.12.18 23:51:00 - [35] blueprintTypeIDgroupIDmarketGroupIDproductTypeIDtypeNameactivityactivityNamequantitydamagePerJobrequiredTypeIDrequiredTypeName 10644411986Basilisk Blueprint1Manufacturing-189848134Tritanium 106275686Osprey Blueprint1Manufacturing204436134Tritanium difference = +14588 .... but there is no tritanium required to build a Basilisk.... shows me the market and info on Basilisk BPO. I think its more complex or at all a crappy export, hehehe. CCP Garthagk: Please wash away my tears :)
Cata Clysms Caldari SteelVipers YouWhat	Posted - 2007.12.19 08:07:00 - [36] I have a little Problem to find some Attributes for my Shiplist from the Database. I cant find: - Structure of a Ship - Turret Hardpoints - Launcher Hardpoints All other Attributes are defined in invtypes or dgmtypeattributes table. Someone knows the location of that data?
Vessper The Graduates Brutally Clever Empire	Posted - 2007.12.19 08:53:00 - [37] Originally by: Cata Clysms I have a little Problem to find some Attributes for my Shiplist from the Database. I cant find: - Structure of a Ship - Turret Hardpoints - Launcher Hardpoints All other Attributes are defined in invtypes or dgmtypeattributes table. Someone knows the location of that data? You must have missed them - they are all in the dgmTypeAttributes table: Structure: attributeID = 9 (hp) Launchers: attributeID = 101 (Launcher hardpoints) Turrets: attributeID = 102 (Turret hardpoints) -------------- EveHQ Character App \| Item Database
Cata Clysms Caldari SteelVipers YouWhat	Posted - 2007.12.19 14:02:00 - [38] Edited by: Cata Clysms on 19/12/2007 14:02:24 Thx, found it :)
Nuran DeSiad Gallente Trivolution Insanity	Posted - 2007.12.21 10:41:00 - [39] Hi, I'm trying to create a list of implants. So far I am able to extract a list which covers the name, the description and the value and type of modifier. Now I want to add the slot in which the implant is placed to the list. But I am not able to find this. Can anyone help me out on this ?
Vessper The Graduates Brutally Clever Empire	Posted - 2007.12.21 12:39:00 - [40] Edited by: Vessper on 21/12/2007 12:45:03 Originally by: Nuran DeSiad Hi, I'm trying to create a list of implants. So far I am able to extract a list which covers the name, the description and the value and type of modifier. Now I want to add the slot in which the implant is placed to the list. But I am not able to find this. Can anyone help me out on this ? If you're looking at the dgmTypeAttributes table, check out attributeID=331 - I believe that is the implant slot number. BTW, if anyone else needs to find a particular attribute for an item, check out my online database. It contains attributes (which the ID number) and materials for all ingame items built from the CCP data export -------------- EveHQ Character App \| Item Database

Talo Momoe Caldari TOHA Heavy Industries Brutally Clever Empire	Posted - 2007.12.22 22:09:00 - [41] There seems to be an error in the data for Nanite Operation. dgmTypeAttributes contains a record for requiredSkill1, but it does not contain a corresponding record for requiredSkill1Level. In-game, the skill requires Mechanic 5. EVEMon shows no required skills at all for Nanite Operation. Has anyone found any other missing data?
Andrahkon UNITED STARS ORGANISATION	Posted - 2007.12.25 17:50:00 - [42] Edited by: Andrahkon on 25/12/2007 17:51:04 I uploaded an access-version of the dump if any1 needs http://dl.eve-files.com/media/0712/trinitydump_100_a2003.rar (40mb) ------------------------------------------------------------- Selling Carrier with fuel and Mods - preorders accepted
MegabitOne Caldari The Black Ops Black Core Alliance	Posted - 2008.01.01 12:00:00 - [43] Does anyone know where I can find the Entity Relationship Diagram for the data export? I know it's in the fora somewhere, but I can't find it back. It's a diagram listing all tables and relationships between 'm. Makes it a whole lot easier to make query the database ;-) --- I'm not as bad-ass as some of my corp mates, but I'll pwn you anyway! -= In God we trust, all the others pay cash =-
Nuran DeSiad Gallente Trivolution Insanity	Posted - 2008.01.01 16:22:00 - [44] You mean this one ?
PhamNuwen Caldari Abyss Rangers	Posted - 2008.01.03 14:23:00 - [45] Looking for a Python-Data-Dump of the static data. Would be usefull to test some small scripts :) Is it existing somewhere? Thx PS: Background: I'm "playing" a little bit with the EvE-API (Assets)... ;-) ---
Jedzias Miezekatze	Posted - 2008.01.03 14:25:00 - [46] Oh, where are the Marketgroups for E-Attack Ship Blueprints, Heavy Interdictors, MaMeMuMarauders and so on ? For them who need an unofficial fix till they spit out a new update and are to lazy to do the typing i'll share mine with you. Keep on coding friends, Jedzia.
PhamNuwen Caldari Abyss Rangers	Posted - 2008.01.03 17:46:00 - [47] Edited by: PhamNuwen on 03/01/2008 17:48:28 Originally by: Jedzias Miezekatze PhamNuwen: what kind of data-dump is that exactly ? :) there is a mysql-binding interface or do you mean something listed on the Python Database Topic Guide ? I thought the whole static database as Python objects could be usefull for some 'quick and dirty' scripts. Currently I'm not really interested to install a real database server on my PC ---
Jack Toad Federal Space Academy Red Army Alliance	Posted - 2008.01.07 08:50:00 - [48] Originally by: PhamNuwen Edited by: PhamNuwen on 03/01/2008 17:48:28 Originally by: Jedzias Miezekatze PhamNuwen: what kind of data-dump is that exactly ? :) there is a mysql-binding interface or do you mean something listed on the Python Database Topic Guide ? I thought the whole static database as Python objects could be usefull for some 'quick and dirty' scripts. Currently I'm not really interested to install a real database server on my PC Since python version 2.5, you can use sqlite3 DB module. You don't need any database server to use SQL requests to SQLite db. Check here: http://www.sqlite.org/ and here: http://www.pysqlite.org/
Amida Ta	Posted - 2008.01.08 11:08:00 - [49] Originally by: PhamNuwen I thought the whole static database as Python objects could be usefull for some 'quick and dirty' scripts. Currently I'm not really interested to install a real database server on my PC EveAI.Live does not need any SQL/Database. But it's not Python, so I don't know if you can use it.
Jedzias Miezekatze	Posted - 2008.01.11 01:17:00 - [50] Edited by: Jedzias Miezekatze on 11/01/2008 01:21:36 Since python version 2.5, you can use sqlite3 DB module. You don't need any database server to use SQL requests to SQLite db. Check here: http://www.sqlite.org/ and here: http://www.pysqlite.org/ Yes i thought it that way. For the joke: exporting from mysql to sqlite3 isn't fun. did it the night from the last post, hehe. ( with something like "./mysql2sqlite.pl \| sqlite3 evedatabase.db" ). I think PhamNuwen means native sexy text files exports ;) just working on it: venom:~/projekte/Perl # ./dbcodegen -g oveur dbo chrRaces Usage: ./dbcodegen [options] <db> [table] Database Codegenerator v0.0.0 -------------------------------------------------------------- Available generator modules: c c++ c# perl python -------------------------------------------------------------- -g <generator> use <generator> instead of <c++> as codegen engine -d turn debugging mode on -n don't print content-type -w turns warnings on we dont have any 'oveur'-generator you noob ! at ./dbcodegen line 64.

Jack Toad Federal Space Academy Red Army Alliance	Posted - 2008.01.11 11:39:00 - [51] Originally by: Jedzias Miezekatze Edited by: Jedzias Miezekatze on 11/01/2008 01:21:36 Since python version 2.5, you can use sqlite3 DB module. You don't need any database server to use SQL requests to SQLite db. Check here: http://www.sqlite.org/ and here: http://www.pysqlite.org/ Yes i thought it that way. For the joke: exporting from mysql to sqlite3 isn't fun. did it the night from the last post, hehe. ( with something like "./mysql2sqlite.pl \| sqlite3 evedatabase.db" ). I think PhamNuwen means native sexy text files exports ;) ........... I've already done the conversion to sqlite3. Check the last post on the 1st page
Clogs'R'us Caldari Caldari Navy Special Operations	Posted - 2008.01.11 17:27:00 - [52] Any word on the Official Missing icons? ------------------------------- EVE Profit Calculator
Rynlam Gallente	Posted - 2008.01.11 22:36:00 - [53] Is there a version of this somewhere that will import properly to a MySQL 4 database?
BoozyBoo	Posted - 2008.01.15 23:10:00 - [54] Where people can find corp logo and ally logo. p.s. many ally logo was upload, there is no many logo %) p.p.s. ingame method for download ally logo did't work %)
Sinister Duck	Posted - 2008.01.18 18:07:00 - [55] Just making sure I get this. Were the original SQL data and icon packs provided by the EVE Dev team or a third party?
Gismork Caldari Destructive Influence Band of Brothers	Posted - 2008.01.18 21:17:00 - [56] Originally by: Sinister Duck Just making sure I get this. Were the original SQL data and icon packs provided by the EVE Dev team or a third party? What are you talking about ? Did you read the first post of this topic, everything you asked is here. Do I misunderstood your question ? ++
Bambi	Posted - 2008.01.25 07:47:00 - [57] Originally by: Schwigg I have the MySQL version of the data dump and I'm trying to import it into a hosted database, but I'm running into a couple of issues... I'm hoping someone here can help. 1. My interface to the database is PHPMyAdmin, which has a 2MB limit on imported SQL files. I'm assuming that breaking up the SQL files will do the trick, but this will be pretty tedious when I get to some of the larger files. 2. Even for files < 2MB in size, I'm still getting errors on the lines with the /* */ text. Is there anyone here that has been able to import these files into MySQL using PHPMyAdmin? Any tips & tricks to make the process a little easier? Unfortunately, my hosting provider does not allow for shell access, so I'm not sure I can use MySQL directly. Google for bigdump.php its a file that automates importing large sql files, all you need to do is edit the db login info at the begining of the file.
woddel warrior	Posted - 2008.01.25 19:02:00 - [58] hello all thanks for all the data. for a freshman in this game, i would like to ask if there is some sort of documentation of which table relates to which other one (sql joins). that would help a lot to sort things out... :)
Lifigaana Becar ICE is Coming to EVE	Posted - 2008.02.08 01:59:00 - [59] I'm looking for a database of materials needed for the construction of a ship like on the item database... any idea ?
Saxx0n Pukkasa Caldari Intergalactic Privateers	Posted - 2008.02.10 11:20:00 - [60] Edited by: Saxx0n Pukkasa on 10/02/2008 11:23:17 This mysql code can using my forum mod? I want create a something info of Corp, Profile of players, etc on forum. There have tutorial about howto? Sorry me for bad english.



Pages: 1 [2] 3 4 :: one page
First page \| Previous page \| Next page \| Last page

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.