Pages: [1] 2 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 8 post(s) |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
3352
|
Posted - 2014.05.30 13:55:00 -
[1] - Quote
Official http://cdn1.eveonline.com/data/Kronos_1.0_98431_db.zip
Mysql https://www.fuzzwork.co.uk/dump/mysql55-kronos-1.0-98431.tbz2
Others: https://www.fuzzwork.co.uk/dump/kronos-1.0-98431/
Postgres: https://www.fuzzwork.co.uk/dump/kronos-1.0-98431/postgres-kronos-1.0-98431.sql.bz2
Sqlite: https://www.fuzzwork.co.uk/dump/kronos-1.0-98431/eve.db.bz2 Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
Qoi
Exert Force
9
|
Posted - 2014.05.30 14:18:00 -
[2] - Quote
Yay |
Kid Delicious
Blue Republic RvB - BLUE Republic
19
|
Posted - 2014.05.30 15:00:00 -
[3] - Quote
Thanks again and a huge thanks to CCP for consistently getting the SDE out early.
PLEX market group is still missing so here is Desmont McCallock's fix from the last thread.
Quote: insert invMarketGroups values (1923,Null,'Pilot''s License Extensions (PLEX)', 'Special ISK-priced capsuleering licenses offered as an alternative to regular piloting contracts.', Null, 1)
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
3354
|
Posted - 2014.05.30 15:23:00 -
[4] - Quote
Kid Delicious wrote:Thanks again and a huge thanks to CCP for consistently getting the SDE out early. PLEX market group is still missing so here is Desmont McCallock's fix from the last thread. Quote: insert invMarketGroups values (1923,Null,'Pilot''s License Extensions (PLEX)', 'Special ISK-priced capsuleering licenses offered as an alternative to regular piloting contracts.', Null, 1)
oops. knew I'd forgotten to add something. Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
Salpun
Global Telstar Federation Offices Masters of Flying Objects
745
|
Posted - 2014.05.30 15:53:00 -
[5] - Quote
Did any new SDE's get put out? CCP Foxfour was talking about the Dogma/weapons interaction one in another thread. If i dont know something about EVE. I check https://wiki.eveonline.com/en/wiki/ISK_The_Guide
See you around the universe. |
Gordon Newman
Deep Core Mining Inc. Caldari State
8
|
Posted - 2014.05.31 07:39:00 -
[6] - Quote
There still are some additional missing rows in the official SDE:
- PLEX market group missing as said before
- Arkombine faction missing, but referenced
- Static bloodline missing, but referenced
- Modifier bloodline missing, but referenced
Fix (with some dummy descriptions): https://gist.github.com/zweizeichen/680c812e51920b77837c Co-Founder of element43 - Join our team! |
|
CCP FoxFour
C C P C C P Alliance
3277
|
Posted - 2014.05.31 09:02:00 -
[7] - Quote
Gordon Newman wrote:There still are some additional missing rows in the official SDE:
- PLEX market group missing as said before
- Arkombine faction missing, but referenced
- Static bloodline missing, but referenced
- Modifier bloodline missing, but referenced
Fix (with some dummy descriptions): https://gist.github.com/zweizeichen/680c812e51920b77837c
Those are missing from the official SDE???? CCP FoxFour // Game Designer // @regnerba
|
|
Risingson
81
|
Posted - 2014.05.31 11:50:00 -
[8] - Quote
complete ms SQL Server (incl yaml/sqlite/plex group fix): https://www.dropbox.com/s/wzxdwiyd10xvvej/Kronos_1.0_98431_MsSQLserver2012.zip https://www.dropbox.com/s/gc83zrfie113qnh/Kronos_1.0_98431_MsSQLserver2008.zip
done with help of SDEExternalsToSql Tool by Desmont
Steve maybe you can put them at your place? Eveeye Prototype YD-114 Onboard Computer Systems |
Desmont McCallock
381
|
Posted - 2014.05.31 17:46:00 -
[9] - Quote
CCP FoxFour wrote:Gordon Newman wrote:There still are some additional missing rows in the official SDE:
- PLEX market group missing as said before
- Arkombine faction missing, but referenced
- Static bloodline missing, but referenced
- Modifier bloodline missing, but referenced
Fix (with some dummy descriptions): https://gist.github.com/zweizeichen/680c812e51920b77837c Those are missing from the official SDE???? I'm not sure if adding the "Arkombine" faction and the "Static" and "Modifier" bloodlines are so important, the PLEX marketGroupID certainly is and it's missing for the third time in the official SDE release.
If this makes you wonder, it makes us pissed.
P.S. Pardon my harshness. |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
3359
|
Posted - 2014.05.31 21:36:00 -
[10] - Quote
https://www.fuzzwork.co.uk/dump/kronos-1.0-98431/risingson/ Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
|
|
CCP FoxFour
C C P C C P Alliance
3278
|
Posted - 2014.06.01 08:17:00 -
[11] - Quote
Desmont McCallock wrote:CCP FoxFour wrote:Gordon Newman wrote:There still are some additional missing rows in the official SDE:
- PLEX market group missing as said before
- Arkombine faction missing, but referenced
- Static bloodline missing, but referenced
- Modifier bloodline missing, but referenced
Fix (with some dummy descriptions): https://gist.github.com/zweizeichen/680c812e51920b77837c Those are missing from the official SDE???? I'm not sure if adding the "Arkombine" faction and the "Static" and "Modifier" bloodlines are so important, the PLEX marketGroupID certainly is and it's missing for the third time in the official SDE release. If this makes you wonder, it makes us pissed. P.S. Pardon my harshness.
To be fair this is the first time I am hearing of this and I am not that hard to get ahold of.
I will look into this on Monday. Not a clue how those things could be missing but will track it down. CCP FoxFour // Game Designer // @regnerba
|
|
Desmont McCallock
382
|
Posted - 2014.06.01 16:11:00 -
[12] - Quote
CCP FoxFour wrote:Desmont McCallock wrote:CCP FoxFour wrote:Gordon Newman wrote:There still are some additional missing rows in the official SDE:
- PLEX market group missing as said before
- Arkombine faction missing, but referenced
- Static bloodline missing, but referenced
- Modifier bloodline missing, but referenced
Fix (with some dummy descriptions): https://gist.github.com/zweizeichen/680c812e51920b77837c Those are missing from the official SDE???? I'm not sure if adding the "Arkombine" faction and the "Static" and "Modifier" bloodlines are so important, the PLEX marketGroupID certainly is and it's missing for the third time in the official SDE release. If this makes you wonder, it makes us pissed. P.S. Pardon my harshness. To be fair this is the first time I am hearing of this and I am not that hard to get ahold of. I will look into this on Monday. Not a clue how those things could be missing but will track it down. It was not meant to be a personal attack post. I don't know who does or is responsible about releasing the SDE. Mostly this went out as a frustration post as CCP tents to 'fire and forget' (releases and doesn't follow) when it comes to the SDE and the API. Trust is hard to be gained back when it has been lost.
|
|
CCP FoxFour
C C P C C P Alliance
3278
|
Posted - 2014.06.01 20:24:00 -
[13] - Quote
Desmont McCallock wrote:CCP FoxFour wrote:Desmont McCallock wrote:CCP FoxFour wrote:Gordon Newman wrote:There still are some additional missing rows in the official SDE:
- PLEX market group missing as said before
- Arkombine faction missing, but referenced
- Static bloodline missing, but referenced
- Modifier bloodline missing, but referenced
Fix (with some dummy descriptions): https://gist.github.com/zweizeichen/680c812e51920b77837c Those are missing from the official SDE???? I'm not sure if adding the "Arkombine" faction and the "Static" and "Modifier" bloodlines are so important, the PLEX marketGroupID certainly is and it's missing for the third time in the official SDE release. If this makes you wonder, it makes us pissed. P.S. Pardon my harshness. To be fair this is the first time I am hearing of this and I am not that hard to get ahold of. I will look into this on Monday. Not a clue how those things could be missing but will track it down. It was not meant to be a personal attack post. I don't know who does or is responsible about releasing the SDE. Mostly this went out as a frustration post as CCP tents to 'fire and forget' (releases and doesn't follow) when it comes to the SDE and the API. Trust is hard to be gained back when it has been lost.
Going forward Steve is on CSM 9 and can contact us directly via several methods for the CSM. You can get me on twitter @regnerba along with a few other devs. There are a few channels on IRC.
The bottom line is just try and hit one of us up directly. We do try and follow the forums but there are a lot of posts and it's easy to miss a post there.
CCP FoxFour // Game Designer // @regnerba
|
|
|
CCP FoxFour
C C P C C P Alliance
3279
|
Posted - 2014.06.02 11:52:00 -
[14] - Quote
Gordon Newman wrote:There still are some additional missing rows in the official SDE:
- PLEX market group missing as said before
- Arkombine faction missing, but referenced
- Static bloodline missing, but referenced
- Modifier bloodline missing, but referenced
Fix (with some dummy descriptions): https://gist.github.com/zweizeichen/680c812e51920b77837c
I have made a fix for the PLEX market group. It wont go out with Kronos but should go out with the July release.
Arkomine, where are you seeing them referenced? They are a corporation, not faction. Your "fix" inserts them as a faction with ID 500021 which is reserved for the "Unkown" faction, used by Sleepers. That seems like a bad.
Still looking into the bloodline thing. CCP FoxFour // Game Designer // @regnerba
|
|
|
CCP FoxFour
C C P C C P Alliance
3279
|
Posted - 2014.06.02 12:05:00 -
[15] - Quote
Tracked the bloodline issue down as well. Should be fixed when the PLEX market group is fixed as well. CCP FoxFour // Game Designer // @regnerba
|
|
Cielle Tische
Who Armed the Carebears CAStabouts
6
|
Posted - 2014.06.02 14:25:00 -
[16] - Quote
There's actually quite a bit of data missing or outdated in this newest SDE, and I even downloaded Fuzzworks' version to verify it wasn't just a bad conversion. Here's what I've caught myself so far, I have some other people compiling lists of what they find off and will update as they feed me information;
The Pirate Faction ships (aside from the new three, of course) still have their OLD Traits. Their attributes seem to have been changed, just not their bonuses.
-- BATTLESHIPS Rattlesnake - : http://www.eveidb.com/item?i=17918 Machariel - : http://www.eveidb.com/item?i=17738 Nightmare - : http://www.eveidb.com/item?i=17736 Vindicator - : http://www.eveidb.com/item?i=17740 Bhaalgorn - : http://www.eveidb.com/item?i=17920 -- CRUISERS Gila - : http://www.eveidb.com/item?i=17715 Cynabal - : http://www.eveidb.com/item?i=17720 Phantasm - : http://www.eveidb.com/item?i=17718 Vigilant - : http://www.eveidb.com/item?i=17722 Ashimmu - : http://www.eveidb.com/item?i=17922 -- FRIGATES Worm - : http://www.eveidb.com/item?i=17930 Dramiel - : http://www.eveidb.com/item?i=17932 Succubus - : http://www.eveidb.com/item?i=17924 Daredevil - : http://www.eveidb.com/item?i=17928 Cruor - : http://www.eveidb.com/item?i=17926 Developer of www.eveidb.com - Relational EVE database! [Still under construction] |
|
CCP FoxFour
C C P C C P Alliance
3279
|
Posted - 2014.06.02 15:37:00 -
[17] - Quote
Thanks for the heads up, I have forwarded this to the SDE guy. CCP FoxFour // Game Designer // @regnerba
|
|
|
CCP FoxFour
C C P C C P Alliance
3279
|
Posted - 2014.06.02 18:06:00 -
[18] - Quote
New version of the SDE is up: http://content.eveonline.com/data/Kronos_1.0_98534_db.zip
This just contains the fix for incorrect traits. CCP FoxFour // Game Designer // @regnerba
|
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
3364
|
Posted - 2014.06.02 18:09:00 -
[19] - Quote
Yes, I have an updated version coming. I'll replace the one I have up with it (with an updated name) Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
3365
|
Posted - 2014.06.02 19:03:00 -
[20] - Quote
Updated. (posting to trigger notifications.) Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
|
Manhim
Radical Astronauts Plundering Eve WormHole Occupation and Resource Exploitation
4
|
Posted - 2014.06.02 19:33:00 -
[21] - Quote
Mirror updated: http://cyanventures.org/dumps/ |
Zifrian
Licentia Ex Vereor Black Core Alliance
1502
|
Posted - 2014.06.03 01:11:00 -
[22] - Quote
Found two records missing in invMetaTypes for Large and Capital T2 Transverse Bulkhead Rigs:
INSERT INTO invMetaTypes VALUES (33900,33898,2); - Large INSERT INTO invMetaTypes VALUES (33904,33902,2); - Capital
I use these to figure out what BPs you need to invent T2 items. Those errored out in IPH after using the last DB update.
GÇ£Any fool can criticize, condemn, and complain - and most fools do. GÇ¥ - Dale Carnegie
Maximze your Industry Potential! - Download EVE Isk per Hour! |
Cryten Jones
Chill Cabal The Serenity Initiative
115
|
Posted - 2014.06.05 15:50:00 -
[23] - Quote
Not sure if this has been mentioned before but the parent blueprint types are missing from the inv_blueprints table.
I am having to do some major SQL-Fu to workout what T1 BPO is needed for a specific T2 type..
Or I could be totally missing how this is done and have wasted my time :-)
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
3383
|
Posted - 2014.06.05 16:00:00 -
[24] - Quote
They've been missing for a long time.
I assume you mean to go from T2 to T1 for invention?
To do that, you join via invMetaTypes on the producttypeid
I've written the core query below, then wrapped it up in some display code so you can see names. It doesn't have the entries where there is no parent, but that could be introduced by using outer joins instead of inner. (If I needed it, I'd probably just update the base table.)
select it1.typename,it2.typename from (
select parent.blueprintTypeID parent,child.blueprintTypeID child from invBlueprintTypes child join invMetaTypes on (child.productTypeID=invMetaTypes.typeID) join invBlueprintTypes parent on (invMetaTypes.parentTypeID=parent.productTypeID)
) parentchild join invTypes it1 on (it1.typeid=parent) join invTypes it2 on (it2.typeid=child) Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
Cryten Jones
Chill Cabal The Serenity Initiative
115
|
Posted - 2014.06.05 16:04:00 -
[25] - Quote
I did something similar, think I looked at what t1 was using the the build, found the T1 bpo from that.
Mine screws up when you have more than one T1 item used in production of a T2 (Modulated Deep core mining lasers for example) so I will have another look with yours |
Zifrian
Licentia Ex Vereor Black Core Alliance
1504
|
Posted - 2014.06.06 01:16:00 -
[26] - Quote
Zifrian wrote:Found two records missing in invMetaTypes for Large and Capital T2 Transverse Bulkhead Rigs:
INSERT INTO invMetaTypes VALUES (33900,33898,2); - Large INSERT INTO invMetaTypes VALUES (33904,33902,2); - Capital
I use these to figure out what BPs you need to invent T2 items. Those errored out in IPH after using the last DB update.
This is still a problem in Kronos_1.0_98534.
I saw someone said they had issues trying to invent these. Is this related? I remember in the past the datadump issues seemed to mimic invention issues like this in game. GÇ£Any fool can criticize, condemn, and complain - and most fools do. GÇ¥ - Dale Carnegie
Maximze your Industry Potential! - Download EVE Isk per Hour! |
Desmont McCallock
384
|
Posted - 2014.06.07 10:51:00 -
[27] - Quote
Zifrian wrote:Found two records missing in invMetaTypes for Large and Capital T2 Transverse Bulkhead Rigs:
INSERT INTO invMetaTypes VALUES (33900,33898,2); - Large INSERT INTO invMetaTypes VALUES (33904,33902,2); - Capital
I use these to figure out what BPs you need to invent T2 items. Those errored out in IPH after using the last DB update.
I confirm this.
|
Aquila Sagitta
Blue-Fire
322
|
Posted - 2014.06.15 06:30:00 -
[28] - Quote
Anyone wanna help a newbro (to building eve tools) out?
I can't figure out how to import this into my db. I'm using Wamp for my testing environment before I put my project up on an actual server. So this is just running on my local machine. I tried just importing the file through phpmyadmin but the file size is too large. I then increased the max limit from 128mb to 999mb via php.ini(changing the 3 relevent values) but that didn't seem to work either. Did some google searches and looks like SSH is the next possibility...
I understand basic sql, I understand php, I don't understand how to import this :3 pls help! Blue-Fire Best Fire |
Desmont McCallock
384
|
Posted - 2014.06.15 07:42:00 -
[29] - Quote
Aquila Sagitta wrote:Anyone wanna help a newbro (to building eve tools) out?
I can't figure out how to import this into my db. I'm using Wamp for my testing environment before I put my project up on an actual server. So this is just running on my local machine. I tried just importing the file through phpmyadmin but the file size is too large. I then increased the max limit from 128mb to 999mb via php.ini(changing the 3 relevent values) but that didn't seem to work either. Did some google searches and looks like SSH is the next possibility...
I understand basic sql, I understand php, I don't understand how to import this :3 pls help! On my adventures learning WAMP I too encounter this nerve breaking behavior of phpmyadmin. I ended up using an alternative way of importing the MySql version of the SDE. HeidiSQL (which handles MySQL) was my first sw but I ended up using Navicat (which can handle all DBs). So I strongly recommend you to find something else than phpmyadmin to do what you are after. |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
3418
|
Posted - 2014.06.15 15:42:00 -
[30] - Quote
Aquila Sagitta wrote:Anyone wanna help a newbro (to building eve tools) out?
I can't figure out how to import this into my db. I'm using Wamp for my testing environment before I put my project up on an actual server. So this is just running on my local machine. I tried just importing the file through phpmyadmin but the file size is too large. I then increased the max limit from 128mb to 999mb via php.ini(changing the 3 relevent values) but that didn't seem to work either. Did some google searches and looks like SSH is the next possibility...
I understand basic sql, I understand php, I don't understand how to import this :3 pls help!
The other option is just to use the actual mysql tools.
log into the command line tool.
use databasename; \. filename.sql Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
|
|
|
|
Pages: [1] 2 :: one page |
First page | Previous page | Next page | Last page |