open All Channels
seplocked EVE Technology Lab
blankseplocked Static Data Export and Image export for Incarna 1.0
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: 1 [2]

Author Topic

Jercy Fravowitz
School of Applied Knowledge
Posted - 2011.07.25 09:52:00 - [31]
 

Originally by: Murnock Loran
so we have a type clash here int vs. bigint

this seems to be an issue of your database engine.
i can recommend not assuming other database engines have the same problem, or expect other database engines to care for the implementation issues of yours.


Originally by: Murnock Loran
the static dump were changed from 16 bit to 32 bit IDs with TYRANNIS 1.2 (as noted in the changelog), while the live game db already used 64 bit IDs.
on this i can recommend researching the difference between typeID and itemID.


Originally by: Murnock Loran
I find it striking that there are such things to be found in a dump from a live database.

what is a "live database"? as opposed to a dead one?
no, the data dumps are not taken anywhere near the TQ database. there are actualy rows in the static data dumps that are in direct conflict with the data on TQ.
thats a feature.


Almir Kadric
Posted - 2011.07.25 23:08:00 - [32]
 

Edited by: Almir Kadric on 25/07/2011 23:18:47
Originally by: Jercy Fravowitz
Originally by: Almir Kadric
Is it just me or are all the T2 ore invtypematerials entries wrong?

just you.

see post 30++ here.


Thanks for this. Ended up creating quite a nice piece of SQL to work around this.


Originally by: Eugen Auberle
Edited by: Eugen Auberle on 20/07/2011 19:07:10
Will the icon imgs be as they are?
for items with id in name is rl nice thx.
my problem is for market tree. why u have the img size in the middle of the icon name Rolling Eyes would be much much easier and less coding when size is pre or post set in name like 14_11_32 and not 14_32_11 as it is now. (i know its easy to code, but in my eyes not needed steps)
EDIT: what i found atm is more stress ^^. f.e. ORE Icon for market is in db icon id 1277 and iconFile 23_05. The new img has the name 23_64_5 in icons\items folder. so 0 to cut out to. must that be? ^^
or im in some confusing stupid mistake with the db?


The code you're after would be something like this:

$imageFile = explode('_', $icon['iconFile']);
$imageFile[0] = preg_replace('/^0/', '', $imageFile[0]);
$imageFile[1] = preg_replace('/^0/', '', $imageFile[1]);
$imageFileName = $imageFile[0].'_'.$size.'_'.$imageFile[1].'.png';
return $this->image('EVE/Icons/'.$subfolder.'/'.$imageFileName);

Where $icon['iconFile'] is the database return from the eveicons table.

Almir Kadric
Posted - 2011.07.26 00:01:00 - [33]
 

Was there supposed to be a size 64 icon counterpart to all size 128 icons?

Just wondering since when constructing the marketgroups tree, there's an inconsistency when looking at Apparel group.

Murnock Loran
Posted - 2011.07.26 07:33:00 - [34]
 

Originally by: Jercy Fravowitz
Originally by: Murnock Loran
so we have a type clash here int vs. bigint

this seems to be an issue of your database engine.
i can recommend not assuming other database engines have the same problem, or expect other database engines to care for the implementation issues of yours.


It's MS SQL Server Express, which should be fine, as the dump is released for this db engine.


Originally by: Jercy Fravowitz
Originally by: Murnock Loran
the static dump were changed from 16 bit to 32 bit IDs with TYRANNIS 1.2 (as noted in the changelog), while the live game db already used 64 bit IDs.
on this i can recommend researching the difference between typeID and itemID.



Nevertheless, it is the first time a 64bit wide ID appears in a static dump, isn't it?

Originally by: Jercy Fravowitz
Originally by: Murnock Loran
I find it striking that there are such things to be found in a dump from a live database.

what is a "live database"? as opposed to a dead one?


One that is actually up and running, beeing used, instead of just a few flat files a in a zip archive?

Originally by: Jercy Fravowitz
no, the data dumps are not taken anywhere near the TQ database. there are actualy rows in the static data dumps that are in direct conflict with the data on TQ. thats a feature.


Twisted Evil

Eugen Auberle
Posted - 2011.07.27 15:49:00 - [35]
 

Originally by: Eugen Auberle
Edited by: Eugen Auberle on 20/07/2011 19:07:10
Will the icon imgs be as they are?
for items with id in name is rl nice thx.
my problem is for market tree. why u have the img size in the middle of the icon name Rolling Eyes would be much much easier and less coding when size is pre or post set in name like 14_11_32 and not 14_32_11 as it is now. (i know its easy to code, but in my eyes not needed steps)
EDIT: what i found atm is more stress ^^. f.e. ORE Icon for market is in db icon id 1277 and iconFile 23_05. The new img has the name 23_64_5 in icons\items folder. so 0 to cut out to. must that be? ^^
or im in some confusing stupid mistake with the db?


The code you're after would be something like this:

$imageFile = explode('_', $icon['iconFile']);
$imageFile[0] = preg_replace('/^0/', '', $imageFile[0]);
$imageFile[1] = preg_replace('/^0/', '', $imageFile[1]);
$imageFileName = $imageFile[0].'_'.$size.'_'.$imageFile[1].'.png';
return $this->image('EVE/Icons/'.$subfolder.'/'.$imageFileName);

Where $icon['iconFile'] is the database return from the eveicons table.


Thank u. As i wrote in my post the code isnt the problem. in my eyes, with simple better nameing, this lines not needed. that what i wanted to say with the post =)

Almir Kadric
Posted - 2011.07.30 11:06:00 - [36]
 

Edited by: Almir Kadric on 30/07/2011 11:06:35
Edited by: Almir Kadric on 30/07/2011 11:06:16
I haven't been able to find the skills requirements for invention in the ramrequirements table. If you look at that table for activity=1 (Manufacturing) it has the skills listed. But for invention ... is this a bug or am I to look elsewhere for them?

Desmont McCallock
Posted - 2011.07.30 14:18:00 - [37]
 

Originally by: Almir Kadric
Edited by: Almir Kadric on 30/07/2011 11:06:35
Edited by: Almir Kadric on 30/07/2011 11:06:16
I haven't been able to find the skills requirements for invention in the ramrequirements table. If you look at that table for activity=1 (Manufacturing) it has the skills listed. But for invention ... is this a bug or am I to look elsewhere for them?


Aha! Yet another one you is trying to solve this mystery and put the pieces of the puzzle together.

Let me give a hint.
You are looking at the right table. But each item used for an invention has a skill prerequisite, right?

Almir Kadric
Posted - 2011.07.31 09:18:00 - [38]
 

Well I looked for the ramtyperequirements for where typeid = 25857 which is the cryptic data interface. However nothing comes up. So im assuming im meant to hard code the skill for each of those requirements? OR is the pre-requisite skill stored elsewhere?

Lutz Major
Posted - 2011.08.01 12:32:00 - [39]
 

Originally by: Almir Kadric
Well I looked for the ramtyperequirements for where typeid = 25857 which is the cryptic data interface. However nothing comes up. So im assuming im meant to hard code the skill for each of those requirements? OR is the pre-requisite skill stored elsewhere?
The skills and levels to use an item are in the dgmTypeAttributes table:
SELECT dta.*, dat.attributeName, dat.description
FROM dgmTypeAttributes dta, dgmAttributeTypes dat
WHERE dta.attributeID = dat.attributeID AND dta.typeID = 25857
The ramTypeRequirements table holds only values for manufacturing and researching.

Almir Kadric
Posted - 2011.08.11 14:19:00 - [40]
 

Originally by: Lutz Major
The skills and levels to use an item are in the dgmTypeAttributes table:
SELECT dta.*, dat.attributeName, dat.description
FROM dgmTypeAttributes dta, dgmAttributeTypes dat
WHERE dta.attributeID = dat.attributeID AND dta.typeID = 25857
The ramTypeRequirements table holds only values for manufacturing and researching.


Thanks for this, sorry for the late reply. I actually looked up what you mentioned and you're right it is there. Funny thing too because i was playing with those tables today while working on a new EFT for my site.

Almir Kadric
Posted - 2011.08.11 14:23:00 - [41]
 

Now @ CCP dev team, are the missing icons or types images going to be fixed at any point?

For example the icon for the market group "Scan Probe Launchers" or "Apparel" or even all the "Artillery Cannons" children.

Is this going to be left as is? or is it eventually going to be fixed?

Almir Kadric
Posted - 2011.08.11 15:05:00 - [42]
 

Also wanted to add:

Tempest Types image is broken "639_64.png" all white, there are a few other items like this.

Also Icons for most dgmattributes are missing ie 2_32_9.png "Structure Hitpoints"

Almir Kadric
Posted - 2011.08.17 15:47:00 - [43]
 

Another thing I have noticed there are a whole heap of blueprints which have not been put in a market group even though they are published. One good example is all marauder blueprints.

when i ran the following:

select count(*)
from `evecq_datadump`.`invtypes` as itemtypes
left join `evecq_datadump`.`invgroups` as itemgroups on itemgroups.groupID = itemtypes.groupID
where itemtypes.marketGroupID is null and itemgroups.categoryID = 9 and itemtypes.published = 1


I found that there are more than a 1000 items which are like this!

basik zero
Stone Circle
Posted - 2011.09.04 20:58:00 - [44]
 

Edited by: basik zero on 04/09/2011 21:10:52
hello, can you help me to find id number of skill training animation picture something like that


Pages: 1 [2]

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only