Pages: [1] 2 3 4 |
1. Ship skills from Data dump. - in EVE Technology Lab [original thread]
Correct... the only skills that are needed for the ship are the one the query returns. The "missing" skills are all the prerequisite skills and levels needed for the required skills. There's no easy way to get those out of the database withou...
- by Ruziel - at 2012.01.17 07:30:00
|
2. Get Base Invention Chance - in EVE Technology Lab [original thread]
Here's the script I use on MySQL, that adds a column to the blueprints table: ALTER TABLE invBlueprintTypes ADD chanceOfInvention FLOAT NULL; UPDATE invBlueprintTypes bt, invTypes t SET bt.chanceOfInvention = CASE WHEN t.groupID IN (419,27) O...
- by Ruziel - at 2012.01.12 07:00:00
|
3. Get Base Invention Chance - in EVE Technology Lab [original thread]
It's not in the dump.
- by Ruziel - at 2012.01.11 23:20:00
|
4. Crucible database dump - in EVE Technology Lab [original thread]
See here for MySQL conversion.
- by Ruziel - at 2011.12.07 02:45:00
|
5. Sticky:SDE and IEC for Crucible - in EVE Technology Lab [original thread]
Hot off the conversion pipe: http://dl.eve-files.com/media/corp/Ruziel/cru100-mysql5-v2.zip
- by Ruziel - at 2011.12.07 02:42:00
|
6. Crucible database dump - in EVE Technology Lab [original thread]
One more mysql conversion for the pile: cru100-mysql5-v1.zip Used the same scripts that Jercy used for all his previous conversions.
- by Ruziel - at 2011.12.01 02:50:00
|
7. Yapeal PHP API library (revision 1207 branches/keys/) - in EVE Technology Lab [original thread]
Trying out the new keys version. Found one issue so far: The schema for the size of the errorText field in the the eveErrorList table needs to be updated. The current size is VARCHAR(255), there's a new error being returned by the API with a text...
- by Ruziel - at 2011.09.08 22:32:00
|
8. Static Data Export & Image Export for Incarna 1.1 - in EVE Technology Lab [original thread]
Originally by: Cyerus Very nice to have this released before/while patching the game. Now I'll just have to wait for those fancy MySQL dumps.. :D http://dl.eve-files.com/media/corp/Ruziel/ica110-mysql5-v1.zip MySQL version, minus t...
- by Ruziel - at 2011.09.01 22:39:00
|
9. Can't find base invention chance in static data dump - in EVE Technology Lab [original thread]
It's not in the public dump, so it's either hard coded, or just not in the database subset they release to us. As per the damagePerJob modifications for Data Interfaces mentioned in the other thread, this is something that's in an alteration scri...
- by Ruziel - at 2011.07.24 03:40:00
|
10. Static Data Export and Image export for Incarna 1.0 - in EVE Technology Lab [original thread]
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 ico...
- by Ruziel - at 2011.07.22 20:26:00
|
11. Static Data Export and Image export for Incarna 1.0 - in EVE Technology Lab [original thread]
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 auto...
- by Ruziel - at 2011.07.22 20:23:00
|
12. Invention Source <-> Result information missing from Eve Database Dump - in EVE Technology Lab [original thread]
Correct, the T1 -> T2 is in the invMetaTypes table. SELECT parentTypeID AS T1, typeID AS T2 FROM invMetaTypes WHERE metaGroupID = 2 Note, these are for the actual items, if you want to deal with blueprints, then you have to map the items in ...
- by Ruziel - at 2011.07.22 16:23:00
|
13. Regarding Image Server and MetaLevel icon not there in ships images - in EVE Technology Lab [original thread]
If you were following the action in the Static Data Export and Image export for Incarna 1.0 thread, I reported this, and they got on it. It appears to be fixed as far as I can tell. I suggest you force a reload or clear you cache on whatever p...
- by Ruziel - at 2011.07.17 15:13:00
|
14. List of BPO's with NPC Prices - in EVE Technology Lab [original thread]
Because NPC orders adjust over time based on how active they are. If people keep buying from an NPC order, the price gradually adjusts to 110% of the base price, conversely, they adjust to 90% of the base price if nobody is buying from them. Becau...
- by Ruziel - at 2011.07.17 01:58:00
|
15. List of BPO's with NPC Prices - in EVE Technology Lab [original thread]
Edited by: Ruziel on 17/07/2011 00:41:19 invTypes.basePrice The NPC price fluctuates ¦10% from the basePrice based on market activity, so most blueprints end up being 90% of the basePrice.
- by Ruziel - at 2011.07.17 00:38:00
|
16. Static Data Export and Image export for Incarna 1.0 - in EVE Technology Lab [original thread]
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.
- by Ruziel - at 2011.07.15 20:06:00
|
17. Static Data Export and Image export for Incarna 1.0 - in EVE Technology Lab [original thread]
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 th...
- by Ruziel - at 2011.07.15 17:09:00
|
18. Static Data Export and Image export for Incarna 1.0 - in EVE Technology Lab [original thread]
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.
- by Ruziel - at 2011.07.14 22:31:00
|
19. Static Data Export and Image export for Incarna 1.0 - in EVE Technology Lab [original thread]
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 1...
- by Ruziel - at 2011.07.13 19:55:00
|
20. Static Data Export and Image export for Incarna 1.0 - in EVE Technology Lab [original thread]
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 S...
- by Ruziel - at 2011.07.11 16:04:00
|
Pages: [1] 2 3 4 |
First page | Previous page | Next page | Last page |