EVE Search - EVE Data Export, REVELATIONS Edition and Dev Blog

All Channels

EVE Information Portal

EVE Data Export, REVELATIONS Edition and Dev Blog

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

Monitor this thread via RSS [?]

Pages: 1 2 3 4 5 6 7 [8] 9 10 11 12 13 14 .. 14 :: one page
Author	Thread Statistics \| Show CCP posts - 3 post(s)
WredStorm Gallente Garoun Investment Bank	Posted - 2007.02.01 22:11:00 - [211] I know some people are lost on how to import this data into MSSQL Express (the free version of MSSQL). I'm about 2/3 of the way through completing this process now, and here is what I ended doing (this won't be a full step-by-step, but should give you enough to figure it out, I think). The key thing I found to importing the information was the sqlcmd program that is installed with SQL Express. The first thing I did was startup sqlcmd in interactive mode by opening a command prompt and typing: sqlcmd -S .\SQLEXPRESS This connected me to the copy of SQL EXPRESS running on my local computer. You'll get a prompt like this: 1> I told it to create a new database for me by typing (I'll show the lines numbers too): 1> CREATE DATABASE EVE; 2> GO You could change "EVE" to whatever you want to call your database. The "GO" command tells it to execute whatever SQL commands you've entered so far. Next I exited out of the interactive editor by typing "exit". Now I started using sqlcmd in its "batch" mode, where you can feed it files. I had already downloaded and unrar'd the tables. I changed directories in the command prompt I had open so that I was in the same directory as all the files. I opened up the file called dbo__tables using Textpad (a great text editor) and added the following line to the top of it: USE EVE; At the bottom of the file I added the SQL commands posted earlier in this thread (I think on page 1 or 2) for the 7 missing tables. I then saved the file. Next I entered the following command at the command prompt (again, in the same directory as all the database files I downloaded and unzipped): sqlcmd -S .\SQLEXPRESS -i dbo__tables.sql This tells the sqlcmd program to execute all of the SQL commands it finds in the specified file, which in this case creates all the tables you need. Now it is just a matter of going through and making minor changes to each of the remaining files and running the sqlcmd on them with the appropriate file name. The most important change to each of the files is to add "USE EVE;" at the beginning of each one (or change EVE to whatever you called your database). I also found that I had to change the command "COMMIT;" at the end of the files to "GO". If a file is very large (as in greater than about 2MB in size I found I had to add the word GO in between the INSERT statements every 40,000 lines or so). Now, sometimes you'll run the sqlcmd on a file and get errors. The two error types I ran into were: 1) It would tell me that I was using the wrong column name or something like that and would indicate that "false" and "true" were not allowed. To fix this, just open the file and do a search/replace, changing "false" to "0" (that is a zero) and "true" to "1". Save the file with the changes and try again. 2) The second error would be related to not being able to INSERT when IDENTITY_INSERT is set to OFF. This has to do with trying to insert data into a field that is an auto-incrementing field. The fix for this is to open up the file and in the line after "USE EVE;" type in: SET IDENTITY_INSERT dbo.chrBloodlines ON; and then change the very last line of the file to: SET IDENTITY_INSERT dbo.chrBloodlines OFF; The key here is, change dbo.chrBloodlines to be the name of the table that is having the problem (chrBloodlines is one of the first you'll run into a problem with if you're doing the files in alphabetical order). Don't be surprised if some of the bigger files take a long while to process. You'll see the words (1 rows affected) scrolling past your screen as sqlcmd executes each INSERT command. There may well be a better way to do all of this, but I haven't found it, and this is getting the job done. Expect it to take you about 1/2 day at least to do all of the tables (I'm guestimating, since I'm not done yet myself and have worked on other stuff too). Hope this helps you out, Wred
WredStorm Gallente Garoun Investment Bank	Posted - 2007.02.01 22:12:00 - [212] Oh, as previously mentioned by someone. You may find some tables where the SQL commands reference dbo_tablename as opposed to dbo.tablename. You have to do a search/replace on those, otherwise you'll get an error kicking back saying it can't find the table specified. Wred
Chruker	Posted - 2007.02.02 12:55:00 - [213] Edited by: Chruker on 02/02/2007 12:52:53 For anyone still needing a MySQL one, here is my dump from the MySQL database (3.x) I use on my site: http://games.chruker.dk/eve_online/files/dbo_20070116.zip ----- CCP: Please make ship loot to drop in a can next to the wrecks.
mvil	Posted - 2007.02.04 15:24:00 - [214] Originally by: Chruker Edited by: Chruker on 02/02/2007 12:52:53 For anyone still needing a MySQL one, here is my dump from the MySQL database (3.x) I use on my site: http://games.chruker.dk/eve_online/files/dbo_20070116.zip Thanks. Btw, have you imported the jump changes introduced in the latest patch?
Luigi Thirty Caldari FIRMA	Posted - 2007.02.04 17:20:00 - [215] Originally by: Chruker Edited by: Chruker on 02/02/2007 12:52:53 For anyone still needing a MySQL one, here is my dump from the MySQL database (3.x) I use on my site: http://games.chruker.dk/eve_online/files/dbo_20070116.zip Yay, something I can actually use ---- DOMINIX IS INVINCIBLE:((((
Raquel Smith Caldari Freedom-Technologies	Posted - 2007.02.04 20:11:00 - [216] Edit: Here's a few lines of sql to update the mapSolarsystemJumps table with the changed jumps There's no data for stargates. This sql fragment is very handy for what it is but any decent A* algorithm needs the coordinates of the new stargates.
Dejitte Amarr Cassandra's Light	Posted - 2007.02.06 04:53:00 - [217] Ok, so I was playing around with the DB dump... when I came across groupid=381, or "Elite Battleship"s. T2 battleships? These ships seem to be entirely fleshed out with descriptions, the whole works, there are 2 for each race, one for each of the tier 1 and 2 BS of each race, so my question to you is, do these ships actually exist in EVE, or are these merely test data or the like? And if not, my question to CCP is, are they slated for release ever? I always considered capital ships as T2 battleships, but having actual T2 battleships would be kind of cool too... SELECT FROM `invTypes` WHERE `groupID`=381*
Amstor	Posted - 2007.02.06 12:55:00 - [218] Tnx for mysql dump. very usefull. Do anybode know, where can we get new images\|icons of ship, modules, rigs and etc?
WredStorm Gallente Garoun Investment Bank	Posted - 2007.02.06 19:29:00 - [219] Originally by: mvil Here's[/url] a few lines of sql to update the mapSolarsystemJumps table with the changed jumps (as listed in the patch notes). Thanks very much for posting that. :) Wred
BarmaLINI Caldari PsiCorp	Posted - 2007.02.09 14:59:00 - [220] .. and we long time waiting for icons and images .. --------------------------------------- Welcome: HTTP://EVEINFO.COM Missions (1,2,3,4 level), Offers, Agents, Cosmos, Eve Universe Map, Refine and more
Raquel Smith Caldari Freedom-Technologies	Posted - 2007.02.09 21:28:00 - [221] With the most recent t20 stuff I hope we can still have someone in CCP to provide for us database dumps!
mvil	Posted - 2007.02.10 01:19:00 - [222] Originally by: Raquel Smith With the most recent t20 stuff I hope we can still have someone in CCP to provide for us database dumps! Well, perhaps now that he has more time he'll be able to release a new database dump including images and icons. I do hope he won't have to leave us because of the controversy...
EmmettBrown BTTF Enterprises	Posted - 2007.02.12 17:33:00 - [223] Edited by: EmmettBrown on 12/02/2007 17:31:08 I've finally got around to getting this data into Oracle (thanks to a dumpfile from a previous poster) I've starting to replace my aging spreadsheet of mineral requirements with the data dump version but I've come across a conundrum How do you get the waste factor? it doesn't seem to correspond to the WASTEFACTOR column on INVBLUEPRINTTYPES. for example I know a thorax has a waste factor of .1 unresearched as most things do. there are some items such as ammo and drones that have a waste of .05. This is not reflected in the WASTEFACTOR column I've selected everything that doesn't have it set to 10 and I get 126 items but not every item that I was expected - it lists some but not all drones and no torpedoes or other missiles. this is the join I currently have (in Oracle syntax) SQL> r 1 select items.typename "Item",GROUPNAME "Group",wastefactor "Waste Factor",productiontime "Build Time", 2 RESEARCHPRODUCTIVITYTIME "PE Time", RESEARCHMATERIALTIME "ME Time",RESEARCHCOPYTIME "Copy Time", 3 MAXPRODUCTIONLIMIT "Max Runs",items.portionsize "Batch Size", 4 minerals.typename "Mineral",quantity 5 from invtypes items,invgroups,INVBLUEPRINTTYPES,TL2MATFORTYPEWITHACTIVITY,invtypes minerals 6 where items.groupid=invgroups.Groupid 7 and items.typeid=INVBLUEPRINTTYPES.producttypeid 8 and items.typeid=TL2MATFORTYPEWITHACTIVITY.typeid 9 and TL2MATFORTYPEWITHACTIVITY.requiredtypeid=minerals.typeid and activity=6 10 and items.typename='Thor Torpedo I' 11* order by items.typename,minerals.typeid Item Group Waste Factor Build Time PE Time ME Time Copy Time Max Runs Batch Size Mineral QUANTITY -------------------- ---------- ------------ ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- Thor Torpedo I Citadel To 10 320 48000 48000 48000 150 100 Tritanium 35320 rpedo Thor Torpedo I Citadel To 10 320 48000 48000 48000 150 100 Pyerite 3200 rpedo Thor Torpedo I Citadel To 10 320 48000 48000 48000 150 100 Mexallon 250 rpedo Thor Torpedo I Citadel To 10 320 48000 48000 48000 150 100 Megacyte 30 rpedo Item Group Waste Factor Build Time PE Time ME Time Copy Time Max Runs Batch Size Mineral QUANTITY -------------------- ---------- ------------ ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- and this is how I listed the not 10 wastefactors 1 SELECT "TYPEID", "GROUPID", "TYPENAME", "PORTIONSIZE" 2 FROM "EVE"."INVTYPES" 3* where typeid in (select producttypeid from eve.INVBLUEPRINTTYPES where wastefactor<>10) ------------------------------------------ Research Details
Chruker	Posted - 2007.02.13 22:41:00 - [224] Originally by: EmmettBrown for example I know a thorax has a waste factor of .1 unresearched as most things do. there are some items such as ammo and drones that have a waste of .05. This is not reflected in the WASTEFACTOR column Most of the drones lost their 0.05 waste factor a few patches ago. However from what I can tell the wasterfactor column is the values that are reported by the game when you view an unresearched blueprint. ----- CCP: Please make ship loot to drop in a can next to the wrecks.
Chruker	Posted - 2007.02.16 20:56:00 - [225] Edited by: Chruker on 16/02/2007 20:54:02 Originally by: Raquel Smith Quote: Here's a few lines of sql to update the mapSolarsystemJumps table with the changed jumps There's no data for stargates. This sql fragment is very handy for what it is but any decent A* algorithm needs the coordinates of the new stargates. well, the coordinates that the A* algorithm would use would be the location of the systems. And AFAIK the systems hasn't moved anywhere. ----- CCP: Please make ship loot to drop in a can next to the wrecks.
Raquel Smith Caldari Freedom-Technologies	Posted - 2007.02.16 21:48:00 - [226] Edited by: Raquel Smith on 16/02/2007 21:49:36 Originally by: Chruker well, the coordinates that the A* algorithm would use would be the location of the systems. And AFAIK the systems hasn't moved anywhere. One needs to know the distance between each gate in each system. edit: I should elaborate... In the graph of the universe each system is a vertex and each journey between stargates inside each system is actually the edge. That is where there is cost. Jumping between systems incurs no real cost (unless it's into Jita) aside from, perhaps, weighting based on the security system of the next vertex.
Chruker	Posted - 2007.02.18 03:05:00 - [227] Originally by: Raquel Smith Edited by: Raquel Smith on 16/02/2007 21:49:36 Originally by: Chruker well, the coordinates that the A* algorithm would use would be the location of the systems. And AFAIK the systems hasn't moved anywhere. One needs to know the distance between each gate in each system. edit: I should elaborate... In the graph of the universe each system is a vertex and each journey between stargates inside each system is actually the edge. That is where there is cost. Jumping between systems incurs no real cost (unless it's into Jita) aside from, perhaps, weighting based on the security system of the next vertex. My jump calculator just uses the coordinates of the stars, and none of the stargates relative locations. I guess that the travel time inside a system could be somewhat of a factor. But it just seems to me that the number of jumps is the most important one. Granted that I only started looking at the algorithm when I made my jump calculator, so I could be wrong. However the output from the jump calculator, matches the routes that the ingame autopilot plans. ----- CCP: Please make ship loot to drop in a can next to the wrecks.
Tonto Auri Gallente	Posted - 2007.02.18 05:12:00 - [228] We all are still waiting for correct updated dump... Better MySQL but any correct dump may helps.
Raquel Smith Caldari Freedom-Technologies	Posted - 2007.02.18 08:55:00 - [229] Originally by: Chruker My jump calculator just uses the coordinates of the stars, and none of the stargates relative locations. I guess that the travel time inside a system could be somewhat of a factor. But it just seems to me that the number of jumps is the most important one. Granted that I only started looking at the algorithm when I made my jump calculator, so I could be wrong. However the output from the jump calculator, matches the routes that the ingame autopilot plans. The problem with using the coordinates of the systems is that this is a 3d world. Some systems may have a coordinate A(10,10,10) and B(15,15,15) which would mean they're really close, right? No, that isn't accurate because they may have 30 jumps between them. In this case the hueristic for A* could be better optimised by using the intersystem stargate distance as the measure.
ieniemienie	Posted - 2007.02.18 14:19:00 - [230] Would it be possible to calculte the AU distance between jumpgates in a solar system using the data files? Somehow eve is able to calculate them but im not been able to figure it out yet.
Vargo Hoat Caldari	Posted - 2007.02.18 21:09:00 - [231] Being a web developer and just starting with a new EVE Online page (Croatian portal, TBA in a few days) I will try to workout stuff with the ORIGINAL data dump. Since most of the replies here are very hard to read and follow my question is should we start a new thread on this? It would be about usage of this in MySQL.. P.S. When can we see that damned new image data pump? Grrrr @ t20 All angels lose their wings.
Raoden Tanstaafl	Posted - 2007.02.19 21:30:00 - [232] If I wanted to build a query to build a skill tree, which tables should I be looking at?
Chruker	Posted - 2007.02.20 09:46:00 - [233] Edited by: Chruker on 20/02/2007 09:43:29 Originally by: ieniemienie Would it be possible to calculte the AU distance between jumpgates in a solar system using the data files? Somehow eve is able to calculate them but im not been able to figure it out yet. You want to query the table mapDenormalize with solarSystemID = the system of your choice and groupID = 10 (10 is the stargates group from invGroups). Ex: SELECT * FROM mapDenormalize WHERE itemName LIKE '%Stargate%' LIMIT 10 The x, y, z columns in the table are the stargates position relative to the star. Now with the locations you can calculate the distancies. ----- CCP: Please make ship loot to drop in a can next to the wrecks.
Chruker	Posted - 2007.02.20 10:03:00 - [234] Originally by: Raoden Tanstaafl If I wanted to build a query to build a skill tree, which tables should I be looking at? By skill tree do you mean like what the game displays on the Reg. Skill tab in the Show Info window? If that is the case, you want to query the dgmTypeAttributes for the typeID and attributeID set to (182, 183 or 184 for the primary, secondary and tertiary skill requirements). The value in the valueInt field in the typeID of the skill. Now repeat the process for each of the skills found, until all required skills have been found. ----- CCP: Please make ship loot to drop in a can next to the wrecks.
Raquel Smith Caldari Freedom-Technologies	Posted - 2007.02.20 10:35:00 - [235] Edited by: Raquel Smith on 20/02/2007 10:32:12 Originally by: Raoden Tanstaafl If I wanted to build a query to build a skill tree, which tables should I be looking at? dgmEffectsTypes dgmTypeEffects invTypes
Vessper Black Thorne Corporation	Posted - 2007.02.20 18:32:00 - [236] Originally by: Raquel Smith Edited by: Raquel Smith on 20/02/2007 10:32:12 Originally by: Raoden Tanstaafl If I wanted to build a query to build a skill tree, which tables should I be looking at? dgmEffectsTypes dgmTypeEffects invTypes Those tables are incorrect - you will not be able to build a skill tree using them. The actual tables you will need are dgmAttributeTypes, dgmTypeAttributes and invTypes. As Chruker mentioned above, use attributeID 182, 183 and 184 to get the pre-requisite skill IDs, but also use attributeID 277, 278 and 279 to get the required skill level for each of those skills.
Raquel Smith Caldari Freedom-Technologies	Posted - 2007.02.20 19:49:00 - [237] Originally by: Vessper Originally by: Raquel Smith Edited by: Raquel Smith on 20/02/2007 10:32:12 Originally by: Raoden Tanstaafl If I wanted to build a query to build a skill tree, which tables should I be looking at? dgmEffectsTypes dgmTypeEffects invTypes Those tables are incorrect - you will not be able to build a skill tree using them. The actual tables you will need are dgmAttributeTypes, dgmTypeAttributes and invTypes. As Chruker mentioned above, use attributeID 182, 183 and 184 to get the pre-requisite skill IDs, but also use attributeID 277, 278 and 279 to get the required skill level for each of those skills. Oh you're right. The funny thing is that I have mangled the skill tree.
Raoden Tanstaafl	Posted - 2007.02.20 22:39:00 - [238] What about other modifiers? For example, the Electronics skill offers a 5% bonues to CPU Output... how would I look up those types of things for a skill tree?
Raquel Smith Caldari Freedom-Technologies	Posted - 2007.02.21 00:08:00 - [239] Originally by: Raoden Tanstaafl What about other modifiers? For example, the Electronics skill offers a 5% bonues to CPU Output... how would I look up those types of things for a skill tree? dgmTypeAttributes dgmAttributeTypes Everything is in there
ieniemienie	Posted - 2007.02.21 07:52:00 - [240] Edited by: ieniemienie on 21/02/2007 07:50:06 Originally by: Chruker Edited by: Chruker on 20/02/2007 09:43:29 Originally by: ieniemienie Would it be possible to calculte the AU distance between jumpgates in a solar system using the data files? Somehow eve is able to calculate them but im not been able to figure it out yet. You want to query the table mapDenormalize with solarSystemID = the system of your choice and groupID = 10 (10 is the stargates group from invGroups). Ex: SELECT * FROM mapDenormalize WHERE itemName LIKE '%Stargate%' LIMIT 10 The x, y, z columns in the table are the stargates position relative to the star. Now with the locations you can calculate the distancies. done that, thanks Now i have the xyz locations of the stargates The sun allways is at 0.0.0 But but how do I translate the x y z to distances in KM or AU? And if i can find the distance between the sun and the gates from that... how could i calculate the distance between the gates? Only if the angle between the lines is 90degrees i could use Phytagoras. In all other cases i need to know the ange between the lines from the sun to the gates. aka.. Im still a little lost, but LOVE to learn from you gurus if theres a way.

Pages: 1 2 3 4 5 6 7 [8] 9 10 11 12 13 14 .. 14 :: 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.