EVE Technology Lab

Greetings,

Sorry about getting to you this late. The first SDE had a few issues, which should now be fixed.

Here's the SDE and IEC for Crucible:

Static Data Export

IEC Types
IEC Renders
IEC Icons


-Stillman

Sweet! Thanks again!

The source and change log was missing in this original upload. This has been amended, but for the sake of people who do not feel like DLing the entire SDE again just for the change log here it is:

---

-- CHANGED IN CRUCIBLE

---

--
-- Removed table dbo.eveOwners
-- Removed table dbo.eveNames
-- Removed table dbo.eveLocations
-- Added table dbo.invNames
-- Added table dbo.invUniqueNames
-- Added table dbo.invPositions
-- The added tables are not fully compatible with the removed ones as EVE has decided to move away
-- from the item/owner/location paradigm.
-- dbo.invNames contains names of all static items with names.
-- dbo.invUniqueNames contains the names of all entities who have a unique name.
---- It is also seekable on the itemName itself and has a unique constraint on that key.
-- dbo.invPositions contains the (x, y, z) coordinate of static items.
--
--
-- Translation Changes:
-- LanguageID 'EN' changed to 'EN-US'
-- Added table dbo.translationLaguages for all languages that can be found in dbo.trnTranslations
--
--
-- Removed table agtConfig. All info it used to contain is now reflected in agtAgents.
---- Added bit column isLocator to agtAgents to signify wether the agent can locate characters or not.
--
-- Added Tables for Factional Warfare.
---- dbo.warCombatZones
---- dbo.warCombatZoneSystems

Thanks so much for getting this to us.

Will we be getting an updated invControlTowerResources table when the fuel block switchover happens, or will the fuel resources be managed a different way?

Yes, but I still need to map each tower type to both a fuel block type and consumption amount, as well as a stront consumption amount. If needed, I can do it manually, but I'd rather not. Still, if I need to do it manually, I'd like to get started. I've asked in a few different threads, but no dev response yet. Hopefully I can get an answer soon before they break my pos tracker. :)

MySQL singlefile conversion:
crucible1.0.58224-mysql5-v2.zip

Enjoy!

EDIT: Re-published as v2: Changed from InnoDB to MyISAM. Removed one key for translation tables which was of invalid length

Could you also poke whoever is doing this Fuel Block malarky to COMMUNICATE.

We have holidays coming. POS runners would like to prepare but we have no info. Most POS runners assumed that the transition would come very soon after patch and prepared with 2-3 weeks of old fuel and started manufacturing blocks. Those stocks are being chomped up right now and still no word when blocks start to work.

If we can't get a date when blocks start to work, could we at least get a "Don't know yet the date, but absolutely not before X" guarantee if you already know this is not going to happen before the holidays? Would allow us to plan old style fuel supplies that last through December.

Edit: Personally I have already bought additional POS fuels - I can always make more blocks from them if they end up not being needed - but the uncertainty is due to logistics. My logistics are even fairly simple, I can't imagine how sucky the situation is for someone running POSes at the furthest deep end of 0.0...

Better late than never. Here are the SDE conversions.

MySQL 5.5 : cruc101-mysql5-innoDB-v1.7z

PostgreSQL 9: cruc101-pgsql9-v2.7z

SQLite 3: cruc101-sqlite3-v1.db.7z
Notice: Not compatible with EAM.

SQLite3 for EAM: cruc101-sqlite3-eam-v1.db.7z

I posted about this in the earlier thread and he said that they removed asteroids from invNames. I just made a generic table manually

I received the following error while importing it

ERROR 1298 (HY000) at line 3583694: Unknown or incorrect time zone: 'NULL'

Any idea, what this could be?

Thanks!