Pages: 1 [2] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 8 post(s) |
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 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.
|
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 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]
hello, can you help me to find id number of skill training animation picture smothing like that
|
|
|
|
Pages: 1 [2] :: one page |
First page | Previous page | Next page | Last page |