|
Author |
Thread Statistics | Show CCP posts - 8 post(s) |
Ruziel
Minmatar Twilight Military Industrial Complex
|
Posted - 2011.07.11 05:10:00 -
[1]
Yeah, something is seriously off with the Types dump. Looks like the missing types for starbase structure blueprints that I report got added, but even after that there are about 11k less images than the previous dump.
|
Ruziel
Minmatar Twilight Military Industrial Complex
|
Posted - 2011.07.11 16:04:00 -
[2]
Since he hasn't posted them yet, here's links to Jercy's normal batch of conversions:
inca10-mysql5-v1.sql.bz2 MySQL 5 single file inca10-mysql5-sql-v1 MySQL one file per table inca10-pgsql-v1.sql.bz2 PostgreSQL inca10-sqlite3-v1.db.bz2 SQLite3
|
Ruziel
Minmatar Twilight Military Industrial Complex
|
Posted - 2011.07.13 19:55:00 -
[3]
Someone needs to talk to the folks running the eve image server too, the three new Connections skills are missing the images:
3893 Mining Connections 3894 Distribution Connections 3895 Security Connections
All the Structure blueprints (groupID 1048), and pretty much all the blueprints for non-faction Starbase Structure blueprints.
Here is the list I previously bug reported. https://bugs.eveonline.com/files/79767204440.TXT
|
Ruziel
Minmatar Twilight Military Industrial Complex
|
Posted - 2011.07.14 22:31:00 -
[4]
Great, now all the missing blueprint images are on the server.
But now all the T2/T3 items and blueprints are missing the T2 and T3 corner flags.
|
Ruziel
Minmatar Twilight Military Industrial Complex
|
Posted - 2011.07.15 17:09:00 -
[5]
Originally by: CCP Explorer Can you be more specific and provide us with a few examples? We think we know what might be wrong and are working on fixing that but they are certainly not all missing.
Well, all the tags are missing from the Ships category (categoryID 6), none of them have the T2, T3 or Faction tags on them.
The following blueprint groups have the tabs missing: 384 Armor Hardener Blueprint 349 Armor Reinforcer Blueprint 162 Automated Targeting System Blueprint 127 Cargo Scanner Blueprint 401 Cloaking Device Blueprint 346 Co-Processor Blueprint 176 Combat Drone Blueprint 106 Cruiser Blueprint 140 Damage Control Blueprint 917 Data Miner Blueprint 487 Destroyer Blueprint 131 ECCM Blueprint 130 ECM Blueprint 503 Elite Industrial Blueprint 151 Energy Destabilizer Blueprint 147 Energy Transfer Array Blueprint 148 Energy Vampire Blueprint 133 Energy Weapon Blueprint 139 Fast Loader Blueprint 525 Freighter Blueprint 218 Heat Sink Blueprint 158 Hull Mods Blueprint 143 Hull Repair Unit Blueprint 154 Hybrid Weapon Blueprint 727 Mining Crystal Blueprint 177 Mining Drone Blueprint 134 Mining Laser Blueprint 166 Missile Blueprint 136 Missile Launcher Blueprint 371 Mobile Warp Disruptor Blueprint 161 Passive Targeting System Blueprint 137 Power Manager Blueprint 135 Projectile Weapon Blueprint 787 Rig Blueprint 120 Shield Booster Blueprint 118 Shield Extender Blueprint 157 Shield Hardener Blueprint 119 Shield Recharger Blueprint * 121 Shield Transporter Blueprint * 128 Ship Scanner Blueprint
Those are all the blueprint groups that have T2 or faction prints that are missing the tabs. The two groups marked with an asterisk have bad renders for the 32px icons, the tab is there, but has been resized so that it's 8x8px and not 16x16px as it should be.
|
Ruziel
Minmatar Twilight Military Industrial Complex
|
Posted - 2011.07.15 20:06:00 -
[6]
Looks good now. Kudos for the responsiveness and quick reaction on this issue. I know the tabs are a relatively new addition to the images, but they look so spiffy that they're missed when absent now.
|
Ruziel
Minmatar Twilight Military Industrial Complex
|
Posted - 2011.07.22 20:23:00 -
[7]
Originally by: Almir Kadric I may have found a bug in the database.
When you lookup RAM requirements for invention, the Data interface comes up as consumable (damagePerJob > 0)
Which get's me thinking, is the server hard coded to automatically spit this out when installing an invention?
For some context into what I'm doing: I'm building a website which compares the production costs of different BPO's among other things (production time, income per hour etc) based on the market of a region or system.
Here's an SQL Query example which I used to get the data I mentioned above.
<BEGIN SQL> SELECT InventionRequirements.*, RequiredItem.groupID, RequiredItem.typeName FROM ramtyperequirements AS InventionRequirements
LEFT JOIN invblueprinttypes AS ItemBlueprint ON ItemBlueprint.blueprintTypeID = InventionRequirements.typeID LEFT JOIN ramtyperequirements AS RamRequirements ON RamRequirements.requiredTypeID = ItemBlueprint.productTypeID LEFT JOIN invblueprinttypes AS InventionOutcome ON InventionOutcome.blueprintTypeID = RamRequirements.typeID LEFT JOIN invtypes AS RequiredItem ON RequiredItem.typeID = InventionRequirements.requiredTypeID
WHERE RamRequirements.typeID = 11401 AND InventionRequirements.activityID = 8 AND InventionRequirements.damagePerJob > 0; <END SQL>
If I am supposed to just hard code the ignoring of the consumption of data interfaces by invtypes.groupID I guess I will (even though its a little ugly in code) however it does raise some alarms on what CCP is doing in game O_O
But odd's are I missed something in the database ;p
Almir Kadric
It has been that way for a while. What I do, and so does a corp mate who writes an app that uses the db, is just change our copies of the DB for this issue.
the the MySQL version: UPDATE ramTypeRequirements r INNER JOIN invTypes i ON i.typeID = r.requiredTypeID SET damagePerJob = 0 WHERE r.activityID = 8 AND i.groupID = 716;
|
Ruziel
Minmatar Twilight Military Industrial Complex
|
Posted - 2011.07.22 20:26:00 -
[8]
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?
If I had to guess, it's probably an error with how the filenames are generated for the latest dump. It makes absolutely no sense to have the size in the middle, someone probably swapped two variables in whatever script/program they are using to generate the image dump.
P.S. Explorer, the Tempest (typeID 693) type icon has a bugged render: http://image.eveonline.com/Type/639_64.png http://image.eveonline.com/Type/639_32.png
|
|
|
|