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) |
Chruker
|
Posted - 2007.02.21 08:35:00 -
[241]
Originally by: ieniemienie 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.
Let X, Y, Z be the location of one of the stargates and O, P, Q the location of the 2nd stargate. Now insert the coordinates in this function:
Distance = SQRT(POW((O - X), 2) + POW((P - Y), 2) + POW((Q - Z), 2))
That will return the distance in meters. To convert that to AU simply divide the number with 149,597,870,691 which is the number of meters in an AU. ----- CCP: Please make ship loot to drop in a can next to the wrecks. |
Vessper
Black Thorne Corporation
|
Posted - 2007.02.21 17:50:00 -
[242]
Originally by: Raoden Tanstaafl I'd like to thank everyone who's responded, and given advice and answers...
Two last question... in the dgmAttributeTypes table, what does the attributeCategory relate/correspond to?
And in the dgmTypeAttributes table, what do the valueInt and valueFloat columns relate/correspond too?
Sorry, can't help you on the first one - been wandering that myself
As for the second question, valueInt and valueFloat both relate to the value of the attribute you are looking up. There is a value in either one column or the other, but never in both at the same time. If a value in the valueInt column is NULL, use the valueFloat column and vice versa.
While on the subject of these values, you should also be using the eveUnits table. This will indicate what type of value it is, whether it is a %, a typeID, or whether it is measured in seconds, kg, km etc. The unitID column of the attributeTypes table links to the same column in the eveUnits table.
|
Raoden Tanstaafl
|
Posted - 2007.02.21 18:36:00 -
[243]
Originally by: Vessper
Sorry, can't help you on the first one - been wandering that myself
Hope somebody has an answer...
Originally by: Vessper As for the second question, valueInt and valueFloat both relate to the value of the attribute you are looking up. There is a value in either one column or the other, but never in both at the same time. If a value in the valueInt column is NULL, use the valueFloat column and vice versa.
While on the subject of these values, you should also be using the eveUnits table. This will indicate what type of value it is, whether it is a %, a typeID, or whether it is measured in seconds, kg, km etc. The unitID column of the attributeTypes table links to the same column in the eveUnits table.
Thanx... that's useful...
|
Raquel Smith
Caldari Freedom-Technologies
|
Posted - 2007.02.21 23:00:00 -
[244]
Originally by: Raoden Tanstaafl Two last question... in the dgmAttributeTypes table, what does the attributeCategory relate/correspond to?
That column isn't documented. From what I can tell it doesn't correspond to the categories that appear ingame.
|
Feral Khan
Absolut Solutions
|
Posted - 2007.02.22 05:38:00 -
[245]
Perhaps I missed it, but is this available is CSV? If so, where?
|
Raquel Smith
Caldari Freedom-Technologies
|
Posted - 2007.02.22 07:41:00 -
[246]
Originally by: Feral Khan Perhaps I missed it, but is this available is CSV? If so, where?
No it isn't.
|
Vessper
Black Thorne Corporation
|
Posted - 2007.02.22 12:19:00 -
[247]
Originally by: Feral Khan Perhaps I missed it, but is this available is CSV? If so, where?
CCP only released the MS SQL version. However, I do have a copy of all the data files in CSV version on my home PC. If you're interested in a copy, let me know and I'll upload them for you later.
|
Feral Khan
Absolut Solutions
|
Posted - 2007.02.22 12:39:00 -
[248]
Originally by: Vessper CCP only released the MS SQL version. However, I do have a copy of all the data files in CSV version on my home PC. If you're interested in a copy, let me know and I'll upload them for you later.
Yes, I would be. Thank you.
|
ieniemienie
|
Posted - 2007.02.23 11:39:00 -
[249]
Originally by: Chruker
Originally by: ieniemienie 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.
Let X, Y, Z be the location of one of the stargates and O, P, Q the location of the 2nd stargate. Now insert the coordinates in this function:
Distance = SQRT(POW((O - X), 2) + POW((P - Y), 2) + POW((Q - Z), 2))
That will return the distance in meters. To convert that to AU simply divide the number with 149,597,870,691 which is the number of meters in an AU.
This is working like a charm :-) Thank you very much and i am very impressed!
|
Chi Prime
Eternity INC. Mercenary Coalition
|
Posted - 2007.02.26 08:00:00 -
[250]
I am looking for a way to automatically display a character's image on a forum, and would thus like to map names (e.g. "kieron") to their ID (e.g. "146409153") to form the URL to the image server (e.g. "http://img.eve.is/serv.asp?s=64&c=146409153").
As far as I can tell, no such info is found in the export, and I have been unable to find info regarding any webservice etc providing this translation (from char name to ID). Help would be much appreciated -
Ares, Raptor and Malediction needs fixing |
|
Chruker
|
Posted - 2007.02.26 08:47:00 -
[251]
Originally by: Chi Prime I am looking for a way to automatically display a character's image on a forum, and would thus like to map names (e.g. "kieron") to their ID (e.g. "146409153") to form the URL to the image server (e.g. "http://img.eve.is/serv.asp?s=64&c=146409153").
As far as I can tell, no such info is found in the export, and I have been unable to find info regarding any webservice etc providing this translation (from char name to ID). Help would be much appreciated
If they are visiting the forum using the IGB then you could just grab the character id there, just as you would do with the character name. ----- CCP: Please make ship loot to drop in a can next to the wrecks. |
Chi Prime
Eternity INC. Mercenary Coalition
|
Posted - 2007.02.26 22:18:00 -
[252]
Originally by: Chruker
Originally by: Chi Prime I am looking for a way to automatically display a character's image on a forum, and would thus like to map names (e.g. "kieron") to their ID (e.g. "146409153") to form the URL to the image server (e.g. "http://img.eve.is/serv.asp?s=64&c=146409153").
As far as I can tell, no such info is found in the export, and I have been unable to find info regarding any webservice etc providing this translation (from char name to ID). Help would be much appreciated
If they are visiting the forum using the IGB then you could just grab the character id there, just as you would do with the character name.
Thanks. Preferably they would not be though. If anyone else have some suggestions please feel free to vent them. -
Ares, Raptor and Malediction needs fixing |
Elisa Day
ISS Navy Task Force Interstellar Starbase Syndicate
|
Posted - 2007.02.27 12:29:00 -
[253]
Edited by: Elisa Day on 27/02/2007 12:25:27 http://www.theintelproject.net/people/person=Chi+Prime
The character ID is in the link to the portrait.
Now, if someone could tell me a way to get a corp ticker and corp ID from a corp name, that would be wonderful.
|
Sammiel
Ars ex Discordia Curse Alliance
|
Posted - 2007.02.28 15:16:00 -
[254]
Anyone have a web interface that just allows for SQL queries against the entire database? A lot of times it seems like the common portals prune information for you, which is probably helpful for the average player, but it is also limiting.
I could possibly do the import myself, but I am a pretty big newbie at maintaining databases, and my machine was getting crushed trying to import the larger SQL files into SQL Server Express 2003. I don't relish having to try and splice those files up into more manageable chunks. DEATHLEY > why dont u remain silent like prominent alliances like our band of brothers do |
Raquel Smith
Caldari Freedom-Technologies
|
Posted - 2007.03.01 04:57:00 -
[255]
Originally by: Sammiel Anyone have a web interface that just allows for SQL queries against the entire database? A lot of times it seems like the common portals prune information for you, which is probably helpful for the average player, but it is also limiting.
You can use this interface. It doesn't permit SQL queries but it contains all of the data from the DB Dump (NOT updated for any patch such as build 28296 to 29208). Pagination is a little weird but it gets the job done.
|
Erfnam
Time Cube Syndicate Daikoku Trade Syndicate
|
Posted - 2007.03.02 15:05:00 -
[256]
Originally by: Chi Prime
Originally by: Chruker
Originally by: Chi Prime I am looking for a way to automatically display a character's image on a forum, and would thus like to map names (e.g. "kieron") to their ID (e.g. "146409153") to form the URL to the image server (e.g. "http://img.eve.is/serv.asp?s=64&c=146409153").
As far as I can tell, no such info is found in the export, and I have been unable to find info regarding any webservice etc providing this translation (from char name to ID). Help would be much appreciated
If they are visiting the forum using the IGB then you could just grab the character id there, just as you would do with the character name.
Thanks. Preferably they would not be though. If anyone else have some suggestions please feel free to vent them.
Require account validation or registration from IGB. I did this for http://www.eve-trade.com/forum/ and it guarantees that I have the charid of everyone on the forum.
TCSyn is recruiting |
Dal Rath
|
Posted - 2007.03.11 14:39:00 -
[257]
Are the ship/module/skill bonusus data driven also? I can see entries in dgmTypeAttributes and dgmAttributeTypes for them, but it's not enough to actually apply them.
For example, shipBonusMF has different meaning according to the invType it's applied to, not just a different value. Is there another table that would tell us it means 'small projectile turret damage' when applied to a Slasher but 'cargo capacity' when applied to a Probe?
For that matter, where is the data that defines what a 'small projectile turret' is in relation to the bonus? The market group is not enough, as it excludes some meta types. You could perhaps define it in terms of which modules require the 'small project turret' skill, but you run into problems with pre-reqs e.g. both t2 small turrets and medium turrets depend on the skill, but one qualifies and the other does not.
Any dev clarification on these points would be appreciated.
Thanks
Dal.
|
Dacen Chilar
Caldari Federation of Synthetic Persons YouWhat
|
Posted - 2007.03.12 23:57:00 -
[258]
after klicking through all the pages, i get the impression that there aren't any new icons available. What i noticed too, is that the item database on the website is still out of date. When can we expect that the actualisation may take place. some eta? Thanks in advance. I fancy the bloody icons, even if there only 92 new images.
|
Sazumaan Johnza
Raven Enterprises Confederation of Independent Corporations
|
Posted - 2007.03.13 07:43:00 -
[259]
I am trying to figure out which modules have the highest nocxium content...but dbo_invBlueprintTypes.sql says nothing about mineral requirements?
Any idea how I can get a top 10 list of those modules with the highest nocx content?
AFAIK this data export cannot give me the information I am after - anyone got any other ideas?
|
Dal Rath
|
Posted - 2007.03.13 08:37:00 -
[260]
Originally by: Sazumaan Johnza Any idea how I can get a top 10 list of those modules with the highest nocx content?
AFAIK this data export cannot give me the information I am after - anyone got any other ideas?
TL2MaterialsForTypeWithActivity has the build requirements. Recycling is harder, especially for t2, but you can get some hints by looking back through this thread.
Dal
|
|
Sazumaan Johnza
Raven Enterprises Confederation of Independent Corporations
|
Posted - 2007.03.13 23:31:00 -
[261]
Originally by: Dal Rath
TL2MaterialsForTypeWithActivity has the build requirements. Recycling is harder, especially for t2, but you can get some hints by looking back through this thread.
Dal
Ok thanks but how do I convert something like this:
INSERT INTO dbo.TL2MaterialsForTypeWithActivity (typeID,activity,requiredTypeID,quantity,damagePerJob) VALUES(12821,3,11459,1,0.65);
into:
X Noxcium required for Y Module...
dbo__TABLES.sql doesn't seem to contain TL2MaterialsForTypeWithActivity so I can't figure out which other tables the typeID is pulled from (then I could get a Description referencing typeID and see what module it is) and neither for requiredTypeID, then I could figure out what material this is (eg. Nocx)
You know what I mean?
|
Chruker
|
Posted - 2007.03.14 13:32:00 -
[262]
Edited by: Chruker on 14/03/2007 13:35:24
Originally by: Sazumaan Johnza
Originally by: Dal Rath Ok thanks but how do I convert something like this:
INSERT INTO dbo.TL2MaterialsForTypeWithActivity (typeID,activity,requiredTypeID,quantity,damagePerJob) VALUES(12821,3,11459,1,0.65);
into:
X Noxcium required for Y Module...
dbo__TABLES.sql doesn't seem to contain TL2MaterialsForTypeWithActivity so I can't figure out which other tables the typeID is pulled from (then I could get a Description referencing typeID and see what module it is) and neither for requiredTypeID, then I could figure out what material this is (eg. Nocx)
You know what I mean?
For an overview of how the table fields relate together you can look at this page: http://games.chruker.dk/eve_online/datadump.php
But anyway typeID and requiredTypeID are both related to the table invTypes.
Also the entry you are listing in the above post, is for 'Time Efficiency Research' (activity = 3). You'll want to query for entries regarding 'Manufacturing', which has activity = 1.
And finally to get the amount of nocxium you would actually need, you need to run the quantity number from the table through this formula: [excel]=ROUND(quantity*((1+(bpo_ml0_waste_factor/(1+bpo_ml)))+(0,25-(0,05*your_production_efficiency_skill))); 0)[/excel] ----- CCP: Please make ship loot to drop in a can next to the wrecks. Edit: On the test server you can now salvage wrecks with loot. After a succesfull salvage the loot is left in a jetcan. |
Dacen Chilar
Caldari Federation of Synthetic Persons YouWhat
|
Posted - 2007.03.14 22:30:00 -
[263]
I worked myself through the data and some questiona rise.
first: how are the related ships(Ferox->Nighthawk,Vulture; Raven->RavenNavyIssue,Corvus) connected in the database?
second: can i seperate the attributes as shown on eve-online.com (seperate in Shield, Armor, Sensor and so on)
Thanks
Dacen
|
Chruker
|
Posted - 2007.03.14 23:37:00 -
[264]
Originally by: Dacen Chilar I worked myself through the data and some questiona rise.
first: how are the related ships(Ferox->Nighthawk,Vulture; Raven->RavenNavyIssue,Corvus) connected in the database?
That is in the invMetaTypes table. It contains 3 fields, typeID which is the related ships, parentTypeID which is the - ehh - parent ship (like the Raven), and finally metaGroupID which you can look up in invMetaGroups.
Originally by: Dacen Chilar
second: can i seperate the attributes as shown on eve-online.com (seperate in Shield, Armor, Sensor and so on)
Are you talking about the attributes them selves, or the grouping of them like shield hp, shield recharge time, shield em ristancies etc, in one group? Anyway, if its the last one, then I don't know. In my item database I just have the different groups and then check if xxx attribute has a value, and if so, display it.
----- CCP: Please make ship loot to drop in a can next to the wrecks. Edit: On the test server you can now salvage wrecks with loot. After a succesfull salvage the loot is left in a jetcan. |
CptDelta
Seraphin Technologies S.E.R.A
|
Posted - 2007.03.16 08:11:00 -
[265]
Edited by: CptDelta on 16/03/2007 08:09:31 Hiho,
i wanna convert the X Y Z coordinates from the database to Lightyears..
to calculate the distance between two system im useing
$row[1] = otsasai $row[2] = nalvula
Quote: $x= $row[1][x] - $row[2][x]; $y= $row[1][y] - $row[2][y]; $z= $row[1][z] - $row[2][z];
sqrt($x^2 + $y^2 + $z^2)
or
Quote: SQRT(POW(($row[1][x] - $row[2][x]), 2) + POW(($row[1][y] - $row[2][y]), 2) + POW(($row[1][z] - $row[2][z]), 2))
the result of both calculations is 2.46027741287E+17 an lightyear is 9.460.536.000.000.000m
if i divide:
2.46027741287E+17 / 9460536000000000 = 26.0057093311
26ly ??? ingame its yust about 1 ly.
Where is my mistake?
|
Vessper
Black Thorne Corporation
|
Posted - 2007.03.16 09:31:00 -
[266]
Originally by: CptDelta Edited by: CptDelta on 16/03/2007 08:09:31
Quote: $x= $row[1][x] - $row[2][x]; $y= $row[1][y] - $row[2][y]; $z= $row[1][z] - $row[2][z]; sqrt($x^2 + $y^2 + $z^2)
the result of both calculations is 2.46027741287E+17 an lightyear is 9.460.536.000.000.000m
if i divide:
2.46027741287E+17 / 9460536000000000 = 26.0057093311
26ly ??? ingame its yust about 1 ly. Where is my mistake?
I believe your mistake is in one of the x, y or z figures. The coordinates for both systems on the x and z axis are negative and it does look like you've just missed a minus sign somewhere. I have done the calculation and I get 0.946ly (just about 1 ly as you say).
|
CptDelta
Seraphin Technologies S.E.R.A
|
Posted - 2007.03.16 13:39:00 -
[267]
hehe thx, its was very late yesterday, i forgot the a array index starts at 0 not at 1.. blame me ...
|
Chruker
|
Posted - 2007.03.16 14:28:00 -
[268]
Originally by: CptDelta hehe thx, its was very late yesterday, i forgot the a array index starts at 0 not at 1.. blame me ...
oh we will
j/k ----- CCP: Please make ship loot to drop in a can next to the wrecks. Edit: On the test server you can now salvage wrecks with loot. After a succesfull salvage the loot is left in a jetcan. |
Dacen Chilar
Caldari Federation of Synthetic Persons YouWhat
|
Posted - 2007.03.16 15:10:00 -
[269]
Originally by: Chruker
Originally by: Dacen Chilar
second: can i seperate the attributes as shown on eve-online.com (seperate in Shield, Armor, Sensor and so on)
Are you talking about the attributes them selves, or the grouping of them like shield hp, shield recharge time, shield em ristancies etc, in one group? Anyway, if its the last one, then I don't know. In my item database I just have the different groups and then check if xxx attribute has a value, and if so, display it.
I want to seperate the attributes like shown on eve-online.com. There you have the shield relevant stuff as a group together and the armor stuff together and the propulsion stuff. is there any ID which specifies these groups?
|
Chruker
|
Posted - 2007.03.17 13:41:00 -
[270]
Originally by: Dacen Chilar I want to seperate the attributes like shown on eve-online.com. There you have the shield relevant stuff as a group together and the armor stuff together and the propulsion stuff. is there any ID which specifies these groups?
Not really like the groups in the item database. The only thing that comes close is either the groupID (which is looked up in invGroups) or the marketGroupID (which is looked up in invMarketGroups). ----- CCP: Please make ship loot to drop in a can next to the wrecks. Edit: On the test server you can now salvage wrecks with loot. After a succesfull salvage the loot is left in a jetcan. |
|
|
|
|
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 |