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) |
Xaj Terag
|
Posted - 2006.12.12 00:28:00 -
[91]
I've figured out how to find agents and the corporations they belong to, and I've figured out how to associate certain research skills with certain corporations, but I haven't figured out how to associate research skills with individual agents. Can anyone help me out with finding this information?
|
Zugor Ikatin
Synergy. Imperial Republic Of the North
|
Posted - 2006.12.12 07:19:00 -
[92]
Edited by: Zugor Ikatin on 12/12/2006 07:19:01 Excuse my ignorance, but is this what was needed for EVEMon to be updated to include the Kali content?
Thanks. ------------------------------------------------------------ "We that are strong ought to bear the infirmities of the weak but not to please ourselves." - Romans 15:1 |
Carm
Gallente
|
Posted - 2006.12.12 10:34:00 -
[93]
Edited by: Carm on 12/12/2006 10:34:45 I have some questions and requests ... If some of these are already addressed, please point me to the right file. If they have already been submitted, please excuse me.
1. There are files with wrong table name. For instance dbo_invTypes instead of dbo.invTypes. 2. Could it be possible to add ";" at the end of each CREATE TABLE in the structure script ? 3. Why are there some column name between '[' and ']' in the structure script ? 4. There are still some missing table definitions (I ve already seen that in the topic, but anyway) 5. I noticed three datas that does not seem to fit in a tinyint on my db .. what is the range of values for a tinyint on your db ? 6. What is the "GO" at the end of some of the agent data files ?
Besides, I m as much waiting for the images as the others .. Thx for reading
|
Mecci
|
Posted - 2006.12.12 13:24:00 -
[94]
Originally by: Carm 2. Could it be possible to add ";" at the end of each CREATE TABLE in the structure script ? 4. There are still some missing table definitions (I ve already seen that in the topic, but anyway)
Try this one out: Fixed export
Originally by: Carm 3. Why are there some column name between '[' and ']' in the structure script ?
This is the way MS SQL escapes column names (if they are reserved words).
Sign a Ture |
Chruker
|
Posted - 2006.12.12 14:39:00 -
[95]
SQL = Standard Query Language?
Not much standard about it
|
Dunedon
|
Posted - 2006.12.12 14:45:00 -
[96]
Originally by: Chruker SQL = Standard Query Language?
Not much standard about it
SQL = Structured Query Language ... and it is :)
However, mySQL uses ANSI-SQL (or close enough) and SQL Server uses T-SQL (which is even farther away from "standard") :)
- Dunedon
|
Chruker
|
Posted - 2006.12.12 14:48:00 -
[97]
Damn, my sucking memory strikes again ;-)
|
Xaj Terag
|
Posted - 2006.12.12 20:04:00 -
[98]
I've been poking around the dbo_TL2MaterialsForTypeWithActivity.sql file and I just want to check my understanding of the way it works. Is the damagePerJob variable the chance that the item used is destroyed in the process?
If that's the case, then something may be wrong with Invention. My understanding was that the Data Interfaces weren't supposed to be consumed in the process, but the damagePerJob set in this data dump is 1 on all the data interfaces.
|
Carm
Gallente
|
Posted - 2006.12.13 14:32:00 -
[99]
does someone knows if there are somewhere the pics assicated with this datas ? are the old one compatible ?
|
Dunedon
|
Posted - 2006.12.13 19:36:00 -
[100]
Heya T20 :) Few questions when you have the time to answer them.
1) Anything in today's patch that will require a new dump be created? (Dec. 13th)
2) Timeline on images?
3) Have you determined what your favorite beer is yet? If you make it out to Toronto I'll buy ya a round or 10 :)
Fly Safe - Dunedon
|
|
Ather Ialeas
Amarr Karjala Inc. Freelancer Alliance
|
Posted - 2006.12.14 13:37:00 -
[101]
I'm new to this database poking stuff, would anyone want to tell me how I can check out from the db what are the bonuses for modules? For example how do I dig up what sort of bonuses and such EANMII has?
Thanks in advance You are #27 in queue to see this signature. |
Chruker
|
Posted - 2006.12.14 15:16:00 -
[102]
I'm trying to make a little diagram over how the tables and their fields relates to each other, and I've got a small question.
The table invBlueprintTypes starts with 3 fields: blueprintTypeID parentBlueprintTypeID productTypeID
All of them seems to point at the items in the table invTypes. However some of the entries in invBlueprintTypes has weird type id's in the parentBlueprintTypeID field.
Ex. the 8th record in the invBlueprintTypes has the following: blueprintTypeID = 687 (which is 'Caracal Blueprint' = ok) parentBlueprintTypeID = 682 (which is 'Clone Grade Gamma Blueprint' = strange) productTypeID = 621 (which is 'Caracal' = ok)
It seems strange to me that the parentBlueprintTypeID for the Caracal blueprint is a clone grade blueprint.
|
Derrys
Caldari Caldari Independent Navy Reserve
|
Posted - 2006.12.14 15:17:00 -
[103]
Originally by: Ather Ialeas I'm new to this database poking stuff, would anyone want to tell me how I can check out from the db what are the bonuses for modules? For example how do I dig up what sort of bonuses and such EANMII has?
Those are stored in the dgmTypeAttributes table. First get the typeID for the item you're interested in from invTypes, and then look up which attributes are associated with that typeID in dgmTypeAttributes.
|
Dunedon
|
Posted - 2006.12.14 16:56:00 -
[104]
Originally by: Chruker Edited by: Chruker on 14/12/2006 15:32:28 parentBlueprintTypeID = 682 (which is 'Clone Grade Gamma Blueprint' = strange)
parent almost always means to look within the SAME table for the value. The parentBlueprintTypID is not a link to the invType table, but back to itself (the blueprintTypeID table).
- Dunedon
|
Vessper
Indicium Technologies
|
Posted - 2006.12.14 18:15:00 -
[105]
Originally by: Dunedon
Originally by: Chruker Edited by: Chruker on 14/12/2006 15:32:28 parentBlueprintTypeID = 682 (which is 'Clone Grade Gamma Blueprint' = strange)
parent almost always means to look within the SAME table for the value. The parentBlueprintTypID is not a link to the invType table, but back to itself (the blueprintTypeID table).
- Dunedon
But as the blueprintTypeID links to typeID in the invTypes table, the result is still the same. Whichever table you decide to link it to, the result is strange and tbh, it's probably safe to ignore the parentBlueprintTypeID column completely.
|
Ilor Prophet
|
Posted - 2006.12.14 21:15:00 -
[106]
I just wanna say to the devs that "I love you guys" and "I hate you guys." I love you because the export of the raw data behind the game is without a doubt one of the coolest things a game-maker can do. It provides players with the capability to create all sorts of neat and interesting tools outside the game that further enrapture players' interest (e.g. EVEmon, QuickFit, etc). Very cagey, and ultimately very smart.
But I hate you guys because the system ID numbers have been non-sequential since the Dragon update. :( I used to have some route and haul calculation stuff in which I used an array of system objects indexed to (systemid-30.000.001). It made object lookup blazingly fast because I didn't have to query. The value was the index in the array, so I could just go to that location in memory. Now that there are gaps and non-sequential system ID's I have to have a hashmap. Not a big deal in terms of coding, but no matter how speedy a hashmap might be under the hood still involves a search. Not bad when you're looking up one or two things, but when you're doing 75 million comparisons across 5400 systems, the difference is noticeable. My CPU shakes its tiny fist at you. Yarr!
Still, the good vastly outweighs the bad. I'm looking forward to putting this data dump to good use!
|
Beatle Bones
|
Posted - 2006.12.15 01:11:00 -
[107]
Originally by: Ilor Prophet the system ID numbers have been non-sequential since the Dragon update. :( I used to have some route and haul calculation stuff in which I used an array of system objects indexed to (systemid-30.000.001). It made object lookup blazingly fast because I didn't have to query.
I hit the same problem but....
Why not use your own sequential index for the systemID's in your route / haul algorithm, then a look up array or hashmap for the results (I don't actually know what a hashmap is :/) I decided a look up array of 177kb (using 4 byte integers) was an acceptable overhead for quick code, you could get that down to 89kb if you can use unsigned 2 byte integers.
feel free to flame if I'm missing the point. (I'm not a programmer)
The secret to creativity is knowing how to hide your sources. |
Chruker
|
Posted - 2006.12.15 10:03:00 -
[108]
Originally by: Dev Blog of the nber god Attention: The same criteria apply still and I will say it again for posterity, you can not sell this data or use it in any form of a commercial product. If you want to use it in a commercial product, contact [email protected] for licensing.
Does this also include charging a small amount of ISK for access to a usefull service?
|
Chruker
|
Posted - 2006.12.15 10:05:00 -
[109]
Originally by: Beatle Bones
(I don't actually know what a hashmap is :/)
I think that is something you use to find the good stuff in Amsterdam.
|
Mecci
|
Posted - 2006.12.15 14:19:00 -
[110]
Edited by: Mecci on 15/12/2006 14:20:31 To make it simple, a hashmap is kind of an array (in terms of how you use it). But instead of having a sequential number as key, a hash map takes the hash value of the key and uses that as key. This means that you can use pretty much anything as a key (with a normal array, you would have to have 1,2,3,4,5...). You can even use strings. And since you can use anything, you can use numbers in a non sequential order (like 1,4,6,8...).
The problem though, is that it's faster to get a value from an array since you are kind of aware of the exact location of the value in the memory, as with a hashmap, you need to search through the keys till you get a match, which takes longer time :)
Sign a Ture |
|
Ilor Prophet
|
Posted - 2006.12.15 18:35:00 -
[111]
Edited by: Ilor Prophet on 15/12/2006 18:36:17 Exactly. A look-up array (which is essentially what a hash-map is) means you have the step of actually looking up your value in the array. Even with a sorted look-up array and a good search algorithm, you still need to actually do the search. But if your data is sequentially indexed, you can access the spot in memory directly, which is very fast. No searching required.
It's not an issue of memory usage, it's an issue of execution speed.
|
beldonuin
|
Posted - 2006.12.16 03:05:00 -
[112]
Hi
silly question, but am looking for simple data on ships - CPU (tf) Powergrid (MW) Low Slots Med Slots Hi Slots Launcher Hardpoint Turret Hardpoint
and ship fits slot CPU (tf) Powergrid (MW)
cannot see them in the rmr feed thanks
|
Vessper
Indicium Technologies
|
Posted - 2006.12.16 09:58:00 -
[113]
Originally by: beldonuin Hi
silly question, but am looking for simple data on ships - CPU (tf) Powergrid (MW) Low Slots Med Slots Hi Slots Launcher Hardpoint Turret Hardpoint
and ship fits slot CPU (tf) Powergrid (MW)
cannot see them in the rmr feed thanks
First of all, RMR feed??
Most of the data you seek is in the dgmTypeAttributes table (that goes for ships, modules, weapons etc), with the related attribute information contained in the dgmAttributeTypes table. IIRC, the actual slot type a module/weapon uses is in the dgmTypeEffects table.
|
Lunadi
Minmatar Solar Trade
|
Posted - 2006.12.18 12:37:00 -
[114]
Could anyone help me with regards to importing these data into mySQL?, I've tried to use the fixed export supplied by Mecci. But I quickly get some errors, unfortunately my knowledge of databases is very very basic (just enough to build some simple php tools). Maybe anyone could share a mySQL export or give some advices.
-------- hate my spelling? go play SCRABBLE! |
Mecci
|
Posted - 2006.12.18 17:01:00 -
[115]
Edited by: Mecci on 18/12/2006 17:04:19
Originally by: Lunadi Could anyone help me with regards to importing these data into mySQL?, I've tried to use the fixed export supplied by Mecci. But I quickly get some errors, unfortunately my knowledge of databases is very very basic (just enough to build some simple php tools). Maybe anyone could share a mySQL export or give some advices.
Can you paste the errors here?
Edit: Are you trying to import the evedb-1953-FIXED.zip files or are you running them through the tool as well? Because the sql files in the zip file doesn't work with MySQL (that's what the tool are there for)
Sign a Ture |
Lunadi
Minmatar Solar Trade
|
Posted - 2006.12.18 17:34:00 -
[116]
Originally by: Mecci
Are you trying to import the evedb-1953-FIXED.zip files or are you running them through the tool as well? Because the sql files in the zip file doesn't work with MySQL (that's what the tool are there for)
Thanks a lot Mecci!! This tool was exactly what I've been missing. I'm happy now
-------- hate my spelling? go play SCRABBLE! |
Mecci
|
Posted - 2006.12.18 18:05:00 -
[117]
Any news on the icons yet? And will we get proper alpha channel this time?
Sign a Ture |
ToxicFire
Warlords Corp The Core Collective
|
Posted - 2006.12.18 21:20:00 -
[118]
feels like theres a couple of missing tables in this export is there any possible way of getting an agents name list table added to the list. So alot of agent databases can be updated?
Join the save Stargate SG1 Campaign Today! http://savestargatesg1.com/
|
Chruker
|
Posted - 2006.12.18 21:58:00 -
[119]
Originally by: ToxicFire feels like theres a couple of missing tables in this export is there any possible way of getting an agents name list table added to the list. So alot of agent databases can be updated?
The data is there. For agentnames the related fields are these: dbo.agtAgents.agentID = dbo.eveNames.itemID
|
Grismar
Gallente Vertigo Corp
|
Posted - 2006.12.19 15:05:00 -
[120]
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 two 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
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.
Your EVE IGB home: EVE Wiki, Explorer, Navigator |
|
|
|
|
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 |