| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 4 post(s) |
|
CCP Stillman
C C P
C C P Alliance
120
   |
Posted - 2011.12.06 15:03:00 -
[1] - Quote
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
Associate QA Tester for Team EVESec. |
|
David Magnus
89
|
Posted - 2011.12.06 16:03:00 -
[2] - Quote
Awesome!
Thank you very much!
http://soundcloud.com/davidkmagnus/winterupdate
http://soundcloud.com/davidkmagnus/supercaps
http://soundcloud.com/davidkmagnus/pandemiclegion |
Irijah Onzo
EVE University
Ivy League
0
|
Posted - 2011.12.06 22:02:00 -
[3] - Quote
Sweet! Thanks again! |
Ruziel
Twilight Military Industrial Complex
1
|
Posted - 2011.12.07 02:42:00 -
[4] - Quote
Hot off the conversion pipe:
http://dl.eve-files.com/media/corp/Ruziel/cru100-mysql5-v2.zip |
|
CCP Prism X
C C P
C C P Alliance
228
|
Posted - 2011.12.07 08:40:00 -
[5] - Quote
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
~ CCP Prism X
EVE Database Developer
"Prism X is my first world problem." ~ CCP FLX
If anything in this post was informative or could be considered as 'good news' to you - chances are you've misread it. |
|
Desmont McCallock
54
|
Posted - 2011.12.07 11:50:00 -
[6] - Quote
Your action for the above post is the reason why I like you Prism X a bit more.
However,
CCP Prism X wrote:
-- Translation Changes:
-- LanguageID 'EN' changed to 'EN-US'
-- Added table dbo.translationLaguages for all languages that can be found in dbo.trnTranslations
you realize that there is a spelling error on the table name and further more why is it empty? |
Pizzutz
Capital Industries Research And Development
Fidelas Constans
0
|
Posted - 2011.12.07 14:57:00 -
[7] - Quote
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? |
TorTorden
NorCorp Enterprise
No Holes Barred
15
|
Posted - 2011.12.07 15:55:00 -
[8] - Quote
Since they will only use the one type of fuel, it could possibly just be in invtypes using raceid to figure what fuel type?
Personaly I would just prefer a table for it. |
Pizzutz
Capital Industries Research And Development
Fidelas Constans
0
|
Posted - 2011.12.07 16:22:00 -
[9] - Quote
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. :) |
Desmont McCallock
54
|
Posted - 2011.12.07 19:52:00 -
[10] - Quote
Pizzutz wrote: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. :)
No chance on that. Those guys, they brake first and then they fix (calling [once again] CCP Prism X to the rescue). |
Luminocity
Filthy Thirteen
2
|
Posted - 2011.12.08 18:19:00 -
[11] - Quote
Enjoy!
MySQL singlefile conversion:
crucible1.0.58224-mysql5-v1.zip |
|
CCP Prism X
C C P
C C P Alliance
235
|
Posted - 2011.12.09 08:38:00 -
[12] - Quote
Pizzutz wrote: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, it seems we'll need to generate a new one for you once more. 
I'm going to hunt down the people that did the Fuel Block stuff and pump them for information as to how exactly we're deploying this. I somehow assumed that it would not be done through controlled static data deployments but as far as I can gather that seems to be the case.
I'll also ensure that the API is up to the task although I'm expecting it will not require any changes.
~ CCP Prism X
EVE Database Developer
"Prism X is my first world problem." ~ CCP FLX
If anything in this post was informative or could be considered as 'good news' to you - chances are you've misread it. |
|
Jarnis McPieksu
Aliastra
Gallente Federation
80
|
Posted - 2011.12.09 09:45:00 -
[13] - Quote
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... |
|
CCP Prism X
C C P
C C P Alliance
240
|
Posted - 2011.12.09 13:55:00 -
[14] - Quote
I hear that Soundwave will be making an announcement regarding the fuel issue today.
If not, feel free to talk smack about Anime to him.
~ CCP Prism X
EVE Database Developer
"Prism X is my first world problem." ~ CCP FLX
If anything in this post was informative or could be considered as 'good news' to you - chances are you've misread it. |
|
Desmont McCallock
59
|
Posted - 2011.12.09 17:57:00 -
[15] - Quote
Better late than never. Here are the SDE conversions.
MySQL 5.5 : cruc101-mysql5-innoDB-v1.7z
PostgreSQL 9: cruc101-pgsql9-v1.7z
SQLite 3: cruc101-sqlite3-v1.db.7z
Notice: Not compatible with EAM.
SQLite3 for EAM: cruc101-sqlite3-eam-v1.db.7z |
Chibisuke
Children of Avalon
Avateas Blessed
0
|
Posted - 2011.12.10 12:40:00 -
[16] - Quote
The ores that are part of the asteroid belts are missing in this one.
Quote:
SELECT count(0)
FROM invItems ii
INNER JOIN mapSolarSystems mss
ON mss.solarSystemID = ii.locationID
INNER JOIN invTypes it
ON it.typeID = ii.typeID
WHERE solarSystemName = 'Malkalen' and typeName = 'Pyroxeres'
incarna dump:
result: 71
crucible dump:
result: 0
Is this intentional? and if it is, is there another way to get the ores that are located in a belt? |
Zifrian
Deep Space Innovations
80
|
Posted - 2011.12.11 22:23:00 -
[17] - Quote
Chibisuke wrote:The ores that are part of the asteroid belts are missing in this one. Quote:
SELECT count(0)
FROM invItems ii
INNER JOIN mapSolarSystems mss
ON mss.solarSystemID = ii.locationID
INNER JOIN invTypes it
ON it.typeID = ii.typeID
WHERE solarSystemName = 'Malkalen' and typeName = 'Pyroxeres'
incarna dump: result: 71 crucible dump: result: 0 Is this intentional? and if it is, is there another way to get the ores that are located in a belt?
I posted about this in the earlier thread and he said that they removed asteroids from invNames. I just made a generic table manually 
Maximze your Industry Potential! - Get EVE Isk per Hour!
|
Zalmun
Deep Core Mining Inc.
Caldari State
0
|
Posted - 2011.12.21 11:13:00 -
[18] - Quote
I'm attempting to use the Postgres conversion on a Postgres 9.0 install on Windows, using the command line interface to try to import:
psql EveOnline eve < cruc101-pgsql9-v1.sql
The import succeeds, but there appear to be no primary keys defined, or any other constraints. Is that normal? I don't remember having this problem with previous conversions (I think the last one I used was Incursion).
Anyone able to help me out? |
Ikaef Giasep
Los Primitivos
United Pod Service
0
|
Posted - 2011.12.30 13:32:00 -
[19] - Quote
Luminocity wrote:MySQL singlefile conversion:crucible1.0.58224-mysql5-v2.zipEnjoy! EDIT: Re-published as v2: Changed from InnoDB to MyISAM. Removed one key for translation tables which was of invalid length
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! |
Desmont McCallock
98
|
Posted - 2012.01.05 14:10:00 -
[20] - Quote
Zalmun wrote:I'm attempting to use the Postgres conversion on a Postgres 9.0 install on Windows, using the command line interface to try to import:
psql EveOnline eve < cruc101-pgsql9-v1.sql
The import succeeds, but there appear to be no primary keys defined, or any other constraints. Is that normal? I don't remember having this problem with previous conversions (I think the last one I used was Incursion).
Anyone able to help me out?
As I'm currently learning to do DB conversions, some issues will arise.
Updated Postgres conversion with PK's. |
Ra Demen
The Right Hand of Zod
11
|
Posted - 2012.01.24 08:10:00 -
[21] - Quote
CCP Prism X wrote:Pizzutz wrote: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, it seems we'll need to generate a new one for you once more. I'm going to hunt down the people that did the Fuel Block stuff and pump them for information as to how exactly we're deploying this. I somehow assumed that it would not be done through controlled static data deployments but as far as I can gather that seems to be the case. I'll also ensure that the API is up to the task although I'm expecting it will not require any changes.
Any word on this table?
|
Desmont McCallock
99
|
Posted - 2012.01.24 08:22:00 -
[22] - Quote
Either you are new in there section of the forums or you have high expectations from those guys.
And on this one, we can't rely on "The Rastaman".
Pre-expansion/patch SDE gets available ONLY after bribing, CCP staff involved, with large amounts of "Polar Beer". |
Zagdul
Clan Shadow Wolf
Fatal Ascension
355
|
Posted - 2012.01.24 14:12:00 -
[23] - Quote
/patiently waits for cruci 1.1
It's not Rocket Surgery |
Ramov Tinoga
Tinoga Enterprises
0
|
Posted - 2012.01.27 07:48:00 -
[24] - Quote
This one is sticky, but outdated.
Go this way:  SDE and IEC for Crucible 1.1 (now with DB conversions) |
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |