| 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) |
Robert Dobbs
Evolution
Band of Brothers
   |
Posted - 2007.04.24 05:55:00 -
[301]
Where is the module fitting stored (high, med, low)?
I can't find any type attribute which specifies which slot a module fits into :-/ It's easy enough to calculate from the type group/category, I know, but it would be nice to have the data for ensured accuracy.
-
---------
DukeHeart > We dont like those terms, Phoenix does not agree. |
Laendra
|
Posted - 2007.04.24 11:21:00 -
[302]
 Originally by: Robert Dobbs
Where is the module fitting stored (high, med, low)?
I can't find any type attribute which specifies which slot a module fits into :-/ It's easy enough to calculate from the type group/category, I know, but it would be nice to have the data for ensured accuracy.
dgmEffects table
For instance, for a Warp Disruptor I (typeID 3242)
SELECT t.typeId, t.typeName, te.isDefault, te.effectID, e.effectName, e.description
FROM invTypes t INNER JOIN dgmTypeEffects te ON t.typeID = te.typeID INNER JOIN dgmEffects e ON te.effectID = e.effectID
WHERE t.typeID = 3242
you will see that one of the results is effectID = 13, which indicates that it is a Medium power slot. There are a lot of good attributes on the dgmEffects table, you just need to do some exploring...however, here are a few of the ones you appear to be looking for.
effectID - effectName
11 - loPower
12 - hiPower
13 - medPower
40 - launcherFitted
42 - turretFitted
2663 - rigSlot
------------------- |
Chruker
|
Posted - 2007.04.24 20:36:00 -
[303]
Originally by: Asura Siddartha
Does this have the case discrepancy between table CREATE and INSERT statements? Still downloading it, jut wondering if I have to do a search / replace on it.
No, that error is removed. I thought that I had created the previous dump on the linux server which preserves the case formatting of the table names, but it must have been on my windows machine which doesn't. This time around I made the dump on the linux server and gzip'ed it.
Which brings me to the next problem:
Originally by: Shpion
Thanks mate, latest trial version of WinRar did work for me. Previously I tried extracting with WinAce as well as the Windows Compressed folders function, both of which supposed to work with zip files, but I guess they use different implementation of it.
I just re-checked and there aren't any 'compatibility' options that I can make gzip use. However it should be using the same compression methods as regular ZIP. So my only guess would be that Windows Compressed folders and WInAce are using some old version of the algorithm.
----- http://games.chruker.dk/eve_online -----
Top wishes:
- No daily downtime
- Faster training on sisi
- Updated data export
- Speedup IGB table rendering |
Mianda Atira
Center for Advanced Studies
|
Posted - 2007.04.25 14:07:00 -
[304]
Originally by: Chruker
I just re-checked and there aren't any 'compatibility' options that I can make gzip use. However it should be using the same compression methods as regular ZIP. So my only guess would be that Windows Compressed folders and WInAce are using some old version of the algorithm.
I tried my own WinRar as well as the gzip for KUbuntu 7.04, I managed to extract the dbo_20070420 with neither. The only thing that managed to extract it .. awkwardly .. was the newest WinRar beta version.
|
Vessper
Black Thorne Corporation
|
Posted - 2007.04.26 14:11:00 -
[305]
Chruker,
Once again, thanks for the update SQL. Just managed to play around it with and I found one error 
The SQL statement of:
INSERT INTO mapDenormalize VALUES ('51000009','16','10','30002786','20000408','10000033',NULL,'-2.65590+012','-2.73530e+012','593032028998.0','3836','Stargate (Uedama)','0.602213',NULL,NULL);
is missing an "e" in the x-coord (should be -2.65590e+012). Not a big issue but just thought I'd mention it if you wanted to correct it for anyone else.
Cheers.
--------------------
|
Chruker
|
Posted - 2007.04.28 01:55:00 -
[306]
Originally by: Vessper
is missing an "e" in the x-coord (should be -2.65590e+012). Not a big issue but just thought I'd mention it if you wanted to correct it for anyone else.
Thanks for letting me know. I've fixed that in the newest dump. I've also created a new thread for my dumps.
http://oldforums.eveonline.com/?a=topic&threadID=512512
----- http://games.chruker.dk/eve_online -----
Top wishes:
- No daily downtime
- Faster training on sisi
- Updated data export
- Speedup IGB table rendering |
Vessper
Black Thorne Corporation
|
Posted - 2007.05.01 23:12:00 -
[307]
Hi Chruker - me again 
The line containing the text
"UPDATE invTypes SET description='Replaces some of the heavier..." has some quotation marks in the wrong place. It contains
'1242','2603','2605,''5591','5597'
when it should read
'1242','2603','2605','5591','5597'
The same applies to the DELETE command in the line after that also. Again, not a big issue but it screws up any imports to MS SQL  
--------------------
|
Chruker
|
Posted - 2007.05.06 17:38:00 -
[308]
Chruker kicks MySQL for not speewing errors with stuff like this
Thanks, I've fixed that bug.
On my MySQL it just caused one of the ID (5591) to not be updated. I've updated all the SQL dumps on my page, and also added archieves with most images/icons.
----- http://games.chruker.dk/eve_online -----
Top wishes:
- No daily downtime
- Faster training on sisi
- Updated data export
- Speedup IGB table rendering |
Bowlance
|
Posted - 2007.05.07 05:49:00 -
[309]
Originally by: Chruker
Chruker kicks MySQL for not speewing errors with stuff like this
Thanks, I've fixed that bug.
On my MySQL it just caused one of the ID (5591) to not be updated. I've updated all the SQL dumps on my page, and also added archieves with most images/icons.
I just wanted to say your site it awesome, and thanks for giving a mysql-friendly dump that guys like me can use :)
I might suggest you look into extended inserts though, both to decrease the size, and speed the import process :)
|
Elocin Onyc
|
Posted - 2007.05.10 12:56:00 -
[310]
Well I've been through all tables and can't seem to find the corp name for agents. I've even looked through the database table map and can't see anywhere that identifies the agents corp name.
I'm sure someone out there knows which table the info is in.....help please
|
|
|
Vessper
Black Thorne Corporation
|
Posted - 2007.05.10 14:45:00 -
[311]
If you look at the agtAgents table, you will see each row has a corporationID. If you then look in the eveNames table, just match up the corporationID from the agtAgents table to the itemID in the eveNames table and you will find all the corporation names.
--------------------
|
Sinlok
Southern Cross Incorporated
Pure.
|
Posted - 2007.05.15 07:45:00 -
[312]
Is there a way to filter invtypes to show only real items?
I'm looking to get just T1/T2 modules(faction, named, ect). I'm thinking I can get it with published and marketgroupid but it leaves tons of items for me to check still. Has any one already done this?
|
Dyeadmheet
Caldari
Khanid Aerospace Group
Khanid Provincial Authority
|
Posted - 2007.05.15 18:52:00 -
[313]
Someone was asking how to extract mineral requirements as columns. Here's a query that worked in MS SQL with the RMR edition (I haven't actually imported the new data into MS SQL yet):
(Not using code tags because this is too wide for the fixed-width font.)
use EVE;
select * from (
selectit.typeName "Blueprint Name", it_prod.typeName Produces,
max(it.basePrice) basePrice,
max(ibt.productionTime) productionTime,
max(ibt.techLevel) techLevel,
max(ibt.researchProductivityTime) productivityTime,
max(ibt.researchMaterialTime) materialTime,
max(ibt.researchCopyTime) copyTime,
SUM(case when it_mat.typeName = 'Tritanium' then t2.quantity else 0 end) as 'Tritanium',
SUM(case when it_mat.typeName = 'Pyerite' then t2.quantity else 0 end) as 'Pyerite',
SUM(case when it_mat.typeName = 'Mexallon' then t2.quantity else 0 end) as 'Mexallon',
SUM(case when it_mat.typeName = 'Isogen' then t2.quantity else 0 end) as 'Isogen',
SUM(case when it_mat.typeName = 'Nocxium' then t2.quantity else 0 end) as 'Nocxium',
SUM(case when it_mat.typeName = 'Zydrine' then t2.quantity else 0 end) as 'Zydrine',
SUM(case when it_mat.typeName = 'Megacyte' then t2.quantity else 0 end) as 'Megacyte',
SUM(case when t2.requiredTypeID < 34 or t2.requiredTypeID > 40 then 1 else 0 end) as 'numNonBasicMaterials'
frominvTypes as it join invBlueprintTypes as ibt
on it.typeID = ibt.blueprintTypeID
join invTypes as it_prod
on ibt.productTypeID = it_prod.typeID,
TL2MaterialsForTypeWithActivity as t2 join invTypes as it_mat
on t2.requiredTypeID = it_mat.typeID
whereit.marketGroupID is not null
and t2.typeID = it.typeID
and t2.quantity > 0
group by it.typeName, it_prod.typeName ) as data
where numNonBasicMaterials = 0
Yes, trying to convert attribute/values to columns in SQL is ugly, but if you somehow manage to get the data into MS SQL then you can set up a data import query in excel to insert this data into cells. And this doesn't work so well for T2 prints where the list of possible materials is pretty huge.
|
Dyeadmheet
Caldari
Khanid Aerospace Group
Khanid Provincial Authority
|
Posted - 2007.05.16 15:18:00 -
[314]
For those looking for the database in SQLite and MS SQL Server formats, I've made files of these available. Details in http://oldforums.eveonline.com/?a=topic&threadID=512512&page=1#12
|
Sinlok
Southern Cross Incorporated
Pure.
|
Posted - 2007.05.17 03:38:00 -
[315]
Thanks Dyeadmheet. You weren't answering my question but that query gives more than the answer I had been looking for. The "where numNonBasicMaterials = 0" doesn't work well with the Revalations database though. I think it's picking up on invention materials. At a quick glance it appears nothing with T2 variants shows up with that on the end of the query. Only 255 items with and 956 with out. You can use techlevel=1 and the only other bump you'll run into I know is rigs and items that use stront. Mostly probes.
|
Angmar Da'Kirith
|
Posted - 2007.05.24 21:00:00 -
[316]
Hi! Is it possible to have an update database in ms access format? I just need the dbo_staStation and the table with itemsid-name-volume, thanks!
|
Shar Tegral
|
Posted - 2007.05.25 01:18:00 -
[317]
Originally by: Angmar Da'Kirith
Hi! Is it possible to have an update database in ms access format? I just need the dbo_staStation and the table with itemsid-name-volume, thanks!
I included what I thought relevant without swamping the mdb. If you need it, I suspect you might, eve mail me and I'll make dbo_evenames available too.
MS Access File
The Eve-Online forums may not have invented whining, but they sure have perfected it.
ElweSingollo> Eve is P v P not P v GM. |
Angmar Da'Kirith
|
Posted - 2007.05.25 05:20:00 -
[318]
Originally by: Shar Tegral
If you need it, I suspect you might, eve mail me and I'll make dbo_evenames available too.
You are fantastic ! I need them to decode the market export file and build a program of mine for cargo runs (I know, there are lots of them, but every programmer likes to do things by himself :) ) and the most important info are in those tables. Shar, you are my top eve player bynow ^_^
|
Tubesock
GoonFleet
GoonSwarm
|
Posted - 2007.05.25 21:44:00 -
[319]
Edited by: Tubesock on 25/05/2007 21:45:32
http://goonfleet.com/open_letter_to_CCP.html
|
Dusky Shark
Twilight Rangers
|
Posted - 2007.06.03 05:11:00 -
[320]
Any chance of getting up-to-date database dump ?
|
|
|
Chruker
|
Posted - 2007.06.03 11:35:00 -
[321]
Edited by: Chruker on 03/06/2007 11:33:44
Originally by: Dusky Shark
Any chance of getting up-to-date database dump ?
You mean like this one? http://oldforums.eveonline.com/?a=topic&threadID=512512
----- http://games.chruker.dk/eve_online -----
Top wishes:
- No daily downtime
- Faster training on sisi
- Updated data export
- Speedup IGB table rendering |
Raquel Smith
Caldari
Freedom-Technologies
|
Posted - 2007.06.03 17:49:00 -
[322]
Originally by: Chruker
Edited by: Chruker on 03/06/2007 11:33:44
Originally by: Dusky Shark
Any chance of getting up-to-date database dump ?
You mean like this one? http://oldforums.eveonline.com/?a=topic&threadID=512512
Is that official?
|
Chruker
|
Posted - 2007.06.03 18:38:00 -
[323]
Originally by: Raquel Smith
Originally by: Chruker
Edited by: Chruker on 03/06/2007 11:33:44
Originally by: Dusky Shark
Any chance of getting up-to-date database dump ?
You mean like this one? http://oldforums.eveonline.com/?a=topic&threadID=512512
Is that official?
not from CCP
----- http://games.chruker.dk/eve_online -----
Top wishes:
- No daily downtime
- Faster training on sisi
- Updated data export
- Speedup IGB table rendering |
Dusky Shark
Twilight Rangers
|
Posted - 2007.06.04 03:28:00 -
[324]
Originally by: Chruker
Edited by: Chruker on 03/06/2007 11:33:44
Originally by: Dusky Shark
Any chance of getting up-to-date database dump ?
You mean like this one? http://oldforums.eveonline.com/?a=topic&threadID=512512
nice )
thanks.
|
Liliane Woodhead
Intergalactic Charwomen
|
Posted - 2007.06.15 11:09:00 -
[325]
Hey hampst0rz. I counted exactly 592862 people who beg for an official database update in this thread. More than subscribers 
Please give us one
P.S.: count me as number 592863 ... aeh i mean 661339
|
Liliane Woodhead
Intergalactic Charwomen
|
Posted - 2007.06.15 11:42:00 -
[326]
Originally by: Sinlok
Is there a way to filter invtypes to show only real items?
I'm looking to get just T1/T2 modules(faction, named, ect). I'm thinking I can get it with published and marketgroupid but it leaves tons of items for me to check still. Has any one already done this?
t1-t2 relation :
use invMetaTypes where metaGroupID = 2
or come from the
invBlueprintTypes table. link with invMetaTypes
or link with dgmTypeAttributes and filter for attributeID 633 ( metalevel )
or use dgmEffects
filter for effect-ID 11,12,13 etc.
Another thing you can do on such hairy things where you dont want to spend all your time is: build a tree with the marketgroups. Filter for textual content ... like "module".
Export the ID's in a new table.... Use this table for your program/website/weekend. This is sometimes a faster solution ( for the application query and for your brain )
Excuse me for brain-touching 
|
Ilvari
GoonFleet
|
Posted - 2007.06.20 18:59:00 -
[327]
*bump*
Any new Rev2 Data Export?
|
PotatoHead
Fusion Enterprises Ltd
Mostly Harmless
|
Posted - 2007.06.25 13:36:00 -
[328]
I would also like a new export of data if it's available....It's been about 6 months a a couple patches or so, some of this data has to have gotton stale.
|
Chruker
|
Posted - 2007.06.26 11:45:00 -
[329]
According to Garthagk on IRC, the new datadump has high priority, and he is hoping to have it out this week.
----- http://games.chruker.dk/eve_online -----
Top wishes:
- No daily downtime
- Faster training on sisi
- Updated data export
- Speedup IGB table rendering |
PotatoHead
Fusion Enterprises Ltd
Mostly Harmless
|
Posted - 2007.06.26 13:54:00 -
[330]
Originally by: Chruker
According to Garthagk on IRC, the new datadump has high priority, and he is hoping to have it out this week.
Cool. I imported the current tables for now just to mess with them. I'll most likely just create a new DB when this comes out. Unfortunately since I'm not importing this on my database server and on a hosted site instead I can only import 2 MB at a time.
Anyone know any way around this? I'm using phpMyAdmin with a MySQL database, hosted on GoDaddy's servers. 2 MB is the max size I can upload at once...if I could just stick them all on the server and import the whole thing at once that would make my life alot easier...but I don't see any way I can do that.
Yes, a very vague question, but if anyone has experience with their hosting and knows a way around splitting files into 2 MB increments I'd appreciate it.
|
|
|
|
|
| |
|
| 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 |