EVE Search - EVE data export, rmr edition

All Channels

EVE General Discussion

EVE data export, rmr edition

» 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 .. 13 :: one page
Author	Thread Statistics \| Show CCP posts - 12 post(s)
jide	Posted - 2006.01.14 05:28:00 - [61] Is it me or in mapSolarSystems, the x,y,z coordinates are not in the right order ? I am under the impression that on a given line, the x y z don't belong to the solar system described on that line, but to another one. So if you display them all, without the jumps, it's going to look ok, but if you start displaying the jumps as well, it won't connect the right points. It's either that or I have a nasty bug in my code that is hidding really well.
Nightblade	Posted - 2006.01.14 22:56:00 - [62] Originally by: jide Is it me or in mapSolarSystems, the x,y,z coordinates are not in the right order ? I am under the impression that on a given line, the x y z don't belong to the solar system described on that line, but to another one. So if you display them all, without the jumps, it's going to look ok, but if you start displaying the jumps as well, it won't connect the right points. It's either that or I have a nasty bug in my code that is hidding really well. You must have a nasty bug, because the jumps don't specify x,y,z coordinates, only which systems they connect. Now, if you plot a map, and it doesn't look like the EVE map, there might be a problem. Note that to get a 2D map that's the same as the flattened map you want to look at the X and Z coordinates, not X and Y. I haven't put the new data in yet because of the other problems, but this is the way it used to be.
jide	Posted - 2006.01.15 00:33:00 - [63] Originally by: Nightblade Originally by: jide Is it me or in mapSolarSystems, the x,y,z coordinates are not in the right order ? I am under the impression that on a given line, the x y z don't belong to the solar system described on that line, but to another one. So if you display them all, without the jumps, it's going to look ok, but if you start displaying the jumps as well, it won't connect the right points. It's either that or I have a nasty bug in my code that is hidding really well. You must have a nasty bug, because the jumps don't specify x,y,z coordinates, only which systems they connect. Now, if you plot a map, and it doesn't look like the EVE map, there might be a problem. Note that to get a 2D map that's the same as the flattened map you want to look at the X and Z coordinates, not X and Y. I haven't put the new data in yet because of the other problems, but this is the way it used to be. You misunderstood what I meant. I know the jump table only has indexes, and when u plot all the systems, they look ok too. But I believe the coordinates of a given system are not actually its coordinates but the ones of another system. As an example, you could have Luminaire with the coordinates of Yulai and vice versa.
Nightblade	Posted - 2006.01.15 14:01:00 - [64] Edited by: Nightblade on 15/01/2006 14:13:34 Originally by: jide I know the jump table only has indexes, and when u plot all the systems, they look ok too. But I believe the coordinates of a given system are not actually its coordinates but the ones of another system. As an example, you could have Luminaire with the coordinates of Yulai and vice versa. I compared the data with the Cold War data dump that was here before, and it seems like they are in the right order. When I was skimming it though I noticed some problems. All of the numbers seemed to have been scaled by 1e16 compared to their previous values. There are also several cells where the values are actually text instead of a floating point number. If you take off the apostrophe at the start of the number, the result is the correct number, but scaled as the original numbers were, or a factor of 1e16 too small. If there's enough systems like this it might make your map look pretty strange, with a cluster of systems along the axes. Edit: Actually this seems to be what's gone wrong with the data in the types table, as well. Any values that are actually in floating point format are 1e16 too big. This also seems to be true for the security statuses in the solar systems table.
Jaabaa Prime	Posted - 2006.01.15 22:23:00 - [65] I've sent an email to [email protected] asking about the "miscData_RMR.xls" file because it is basically unusable at the moment. Hopefully I'll get an answer soon. -- Mini Skill Planner

t20	Posted - 2006.01.24 16:47:00 - [66] updated with the new agents, changed the format a bit, hope this helps resolve all the problems most of you had.

elFarto	Posted - 2006.01.24 17:20:00 - [67] Originally by: t20 updated with the new agents, changed the format a bit, hope this helps resolve all the problems most of you had. <3 Regards elFarto npc.elfarto.com > Ingame NPC database
Rasai	Posted - 2006.01.24 17:34:00 - [68] I am unable to find where I download this. Can someone give me the link?

t20	Posted - 2006.01.24 17:48:00 - [69] Originally by: Rasai I am unable to find where I download this. Can someone give me the link? Forumposts 101, read the first response in a thread to get more info, thus giving you: Originally by: t20 This devblog gives you the updated type info, construction requirements, TL2 construction details, universe-wide info, station details and much more ... happy fiddling Post requests here if you have any (that are related to this subject)

Zoon	Posted - 2006.01.24 18:37:00 - [70] Edited by: Zoon on 24/01/2006 18:46:35 t20, not wishing to alienate the other devs, but I think you're my fave You gimme all this really useful information for me to swish up my website! Thankyou The only problem I now have is that I use MySql gets to work __________________________________ Are you a mission runner? Have you tried Zoon's Agent Tool? You should!
TornSoul	Posted - 2006.01.24 18:47:00 - [71] /me hugs t20 long time Thanks for the new sql files. Havent had time to look at them yet, but if they are what I think/hope they are - YARRRt20BBQ!!!! (and I just spend the entire weekend, extracting the data from the messed up csv set - Impecable timing t20 - lol) BIG Lottery [u
Gigi Barbagrigia	Posted - 2006.01.24 19:32:00 - [72] drolls Thanks so much for csv Originally by: Zoon The only problem I now have is that I use MySql This+This=your friend ----- 42
Zoon	Posted - 2006.01.24 19:37:00 - [73] Originally by: Gigi Barbagrigia drolls Thanks so much for csv Originally by: Zoon The only problem I now have is that I use MySql This+This=your friend Not when the files are in TSQL __________________________________ Are you a mission runner? Have you tried Zoon's Agent Tool? You should!
FireFoxx80	Posted - 2006.01.24 21:35:00 - [74] Edited by: FireFoxx80 on 24/01/2006 21:38:05 TSQL :) t20 I wub j00! It's beautiful, simply beautiful! For all the people talking about the SQL format, it should be fairly easy to do a find/replace to change the SQL syntax. Besides, you should only realy need to change the table definition and the COMMIT commands. Else, import them into MSDE, and use the widely available tools to migrate them into mySQL. 23? # Missile Tool # ex: P-TMC : USAC
Emily Spankratchet	Posted - 2006.01.25 11:58:00 - [75] Can I join the queue of people wanting to have t20's babies? One quick question: I can't see anything about (non T2) item build requirements in the SQL files. Am I being stupid, or is it not included?
FireFoxx80	Posted - 2006.01.25 12:00:00 - [76] Non T2 build requirements are minerals only, I would imagine they are in the blueprint tables? I've never investigated blueprint stuff, so I cannot be certain. 23? # Missile Tool # ex: P-TMC : USAC
Emily Spankratchet	Posted - 2006.01.25 12:09:00 - [77] Originally by: FireFoxx80 Non T2 build requirements are minerals only, I would imagine they are in the blueprint tables? I've never investigated blueprint stuff, so I cannot be certain. dbo_invBlueprintTypes.sql has stuff that I'd expect in the attributes part of a blueprint description, like ResearchCopyTime and so on. It doesn't appear to have bill of materials-style information. dbo_InvTypes has blueprints, but only as items. Mind you, it does have 'Buffy' Vampire Slayer I','Kills Vampires Dead'
Gigi Barbagrigia	Posted - 2006.01.25 12:14:00 - [78] materialsforactivity or however it's now called ----- 42
Iron Wraith	Posted - 2006.01.25 12:45:00 - [79] woop! new agent locations time to find a new empire home thanks t20, you make us nerds very happy Because sometimes you just have to go back to your roots: [2005.02.20 01:08:03] (combat) Your Civilian Light Electron Blaster perfectly strikes Serpentis Smuggler, wrecking for 20.3 damage.
FireFoxx80	Posted - 2006.01.25 13:59:00 - [80] Originally by: Iron Wraith thanks t20, you make us nerds very happy I think we prefer to be called application developers. 23? # Missile Tool # ex: P-TMC : USAC
Emily Spankratchet	Posted - 2006.01.25 14:57:00 - [81] Originally by: Gigi Barbagrigia materialsforactivity or however it's now called I can see TL2MaterialsForTypeWithActivity as a table in the SQL data burp, but as far as I can tell this deals with T2 manufacturing and RAM usage. I'm probably being stupid but I can't see any other material-related fields in the other SQL tables.
Zacha Nioto	Posted - 2006.01.25 15:03:00 - [82] /me <3 t20 looong time. ;)
Vessper	Posted - 2006.01.25 15:41:00 - [83] Originally by: Emily Spankratchet Originally by: Gigi Barbagrigia materialsforactivity or however it's now called I can see TL2MaterialsForTypeWithActivity as a table in the SQL data burp, but as far as I can tell this deals with T2 manufacturing and RAM usage. I'm probably being stupid but I can't see any other material-related fields in the other SQL tables. The dbo_TL2MaterialsForTypeWithActivity table does include all the data for T1 manufacturing as well as T2. Look for the 6 SQL statements in that table with a typeID of 683 and you will find all the necessary minerals for building a bantam The data for manufacturing is actually tied to the blueprint and not the item iteslf, which I believe goes for both T1 and T2 items. In addition to manufacturing, the table also tells you what materials/skills/R.DBs you need for T2 blueprint copying and research.
Emily Spankratchet	Posted - 2006.01.25 15:51:00 - [84] Originally by: Vessper The dbo_TL2MaterialsForTypeWithActivity table does include all the data for T1 manufacturing as well as T2. Look for the 6 SQL statements in that table with a typeID of 683 and you will find all the necessary minerals for building a bantam Thank you, thank you, thank you. As I originally suspected, I am an idiot. My only excuse is that I'm doing this at work and keep having to alt-tab to another window.
DaRuLe	Posted - 2006.01.25 17:57:00 - [85] perhaps this is an incredibly stupid question, but where are the names of the agents in the exports? I can't find them __________________________________________________________________________
Bedrox	Posted - 2006.01.25 18:35:00 - [86] Originally by: DaRuLe perhaps this is an incredibly stupid question, but where are the names of the agents in the exports? I can't find them hehe that and the corporations name, I can't find those two either. Frustrated
Zoon	Posted - 2006.01.25 21:11:00 - [87] Originally by: Bedrox Originally by: DaRuLe perhaps this is an incredibly stupid question, but where are the names of the agents in the exports? I can't find them hehe that and the corporations name, I can't find those two either. Heh ... I noticed that too ... good job I got my previous agent data to work from!! __________________________________ Are you a mission runner? Have you tried Zoon's Agent Tool? You should!
Pouah	Posted - 2006.01.26 12:45:00 - [88] I know I'll look like a total newb but, what are we suppose to do with those files?
Histracko	Posted - 2006.01.26 15:56:00 - [89] any chance we can get a list of BP's and the mins required to build their respective items? --------------------------- !!Bookmarking Master!! If you need a route or system bookmarked just EVE-mail or convo me and we'll work something out
Jack Tau	Posted - 2006.01.26 17:07:00 - [90] The new SQL feed kicks ass, thank you very much T20. Throws out all his import scripts P.S. for peeps asking where data is, and if they can have extra data. Everything you need is in the feed, you just need to read through it and figure out how it all links together. Agents, bps, min requirements, module reqs., etc, etc. Its all in there. Enkidu Production Manager If you dont understand this sig, you need to get out less ;)

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