Pages: 1 2 [3] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 16 post(s) |
Steve Ronuken
Fuzzwork Enterprises
858
|
Posted - 2012.12.18 18:04:00 -
[61] - Quote
dgmEffects and dgmTypeEffects appear to be truncated from what they had on the first export for retribution. FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities.As well as mysql and CSV/XLS conversions of the Static Data Extract. |
Desmont McCallock
230
|
Posted - 2012.12.18 20:28:00 -
[62] - Quote
Supplemental to Steve's post. dgmEffects -> Inferno SDE: 2934 lines, Retribution SDE: 101 lines dgmTypeEffects -> Inferno SDE: 34184 lines, Retribution SDE: 7332 lines
Edit: This issue doesn't affect us much in EVEMon data files generation, as we use the dgmTypeEffects table only to determine the slot usage, I can say that a new EVEMon version with updated data files is on its way. |
Quantix BlackStar
The Praxis Initiative Gentlemen's Agreement
3
|
Posted - 2012.12.18 23:06:00 -
[63] - Quote
Desmont McCallock wrote:Supplemental to Steve's post. dgmEffects -> Inferno SDE: 2934 lines, Retribution SDE: 101 lines dgmTypeEffects -> Inferno SDE: 34184 lines, Retribution SDE: 7332 lines
Edit: This issue doesn't affect us much in EVEMon data files generation, as we use the dgmTypeEffects table only to determine the slot usage, I can say that a new EVEMon version with updated data files is on its way.
EveHQ uses these tables in its Item Browser and Fitting modules. In my ad-hoc testing that I've been doing with fits today, I have not run into a noticeable issue, but it would be nice to have some explanations of the removals if only for clarification. EveHQ is a multi-faceted character application for EVE Online. Includes pilot monitoring, skill queue planning, ship fitting, industry and more. Get the latest version at http://evehq.net
|
Cielle Tische
Who Armed the Carebears
0
|
Posted - 2012.12.18 23:24:00 -
[64] - Quote
EVEIDB uses these tables for item display.
Tables used in Inferno: [AGT] agtagents agtagenttypes agtresearchagents [CHR] chrancestries chrattributes chrbloodlines chrfactions chrraces [CRP] crpactivities crpnpccorporationdivisions crpnpccorporationresearchfields crpnpccorporations crpnpccorporationtrades crpnpcdivisions [CRT] crtcategories crtcertificates crtclasses crtrecommendations crtrelationships [DMG] dgmattributecategories dgmattributetypes dgmeffects dgmtypeattributes dgmtypeeffects [INV] invblueprinttypes invcategories invcontrabandtypes invcontroltowerresourcepurposes invcontroltowerresources invflags invgroups invitems invmarketgroups invmetagroups invmetatypes invnames invpositions invtypematerials invtypereactions invtypes invuniquenames [MAP] mapcelestialstatistics mapconstellationjumps mapconstellations mapdenormalize mapjumps maplandmarks maplocationscenes maplocationwormholeclasses mapregionjumps mapregions mapsolarsystemjumps mapsolarsystems mapuniverse [PLN] planetinteraction planetschematics planetschematicspinmap planetschematicstypemap [RAM] ramactivities ramassemblylines ramassemblylinestations ramassemblylinetypedetailpercategory ramassemblylinetypedetailpergroup ramassemblylinetypes raminstallationtypecontents ramtyperequirements [OTHER] eveunits eveicons
Those are the SDE tables we use to generate pages. Also, we use MySQL, instead of MSSQL, and we avoid YAML like it's cursed with instant death. Guess I get to figure out how to convert the YAML Icon tables into MySQL from here on out instead of them just being left where they were >.> Developer of www.eveidb.com - Relational EVE database! [Still under construction -- and stupidly imported the Ret1.0.2 SDE, please disregard missing data!] |
Steve Ronuken
Fuzzwork Enterprises
858
|
Posted - 2012.12.18 23:30:00 -
[65] - Quote
Cielle Tische wrote:EVEIDB uses these tables for item display.
Tables used in Inferno: [AGT] agtagents agtagenttypes agtresearchagents [CHR] chrancestries chrattributes chrbloodlines chrfactions chrraces [CRP] crpactivities crpnpccorporationdivisions crpnpccorporationresearchfields crpnpccorporations crpnpccorporationtrades crpnpcdivisions [CRT] crtcategories crtcertificates crtclasses crtrecommendations crtrelationships [DMG] dgmattributecategories dgmattributetypes dgmeffects dgmtypeattributes dgmtypeeffects [INV] invblueprinttypes invcategories invcontrabandtypes invcontroltowerresourcepurposes invcontroltowerresources invflags invgroups invitems invmarketgroups invmetagroups invmetatypes invnames invpositions invtypematerials invtypereactions invtypes invuniquenames [MAP] mapcelestialstatistics mapconstellationjumps mapconstellations mapdenormalize mapjumps maplandmarks maplocationscenes maplocationwormholeclasses mapregionjumps mapregions mapsolarsystemjumps mapsolarsystems mapuniverse [PLN] planetinteraction planetschematics planetschematicspinmap planetschematicstypemap [RAM] ramactivities ramassemblylines ramassemblylinestations ramassemblylinetypedetailpercategory ramassemblylinetypedetailpergroup ramassemblylinetypes raminstallationtypecontents ramtyperequirements [OTHER] eveunits eveicons
Those are the SDE tables we use to generate pages. Also, we use MySQL, instead of MSSQL, and we avoid YAML like it's cursed with instant death. Guess I get to figure out how to convert the YAML Icon tables into MySQL from here on out instead of them just being left where they were >.>
http://sumanrs.wordpress.com/2012/02/23/yaml-to-mysql-yaml2sql-script-in-php/ may be of interest to you.
(mysql version available from another post of mine)
FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities.As well as mysql and CSV/XLS conversions of the Static Data Extract. |
Dei
Mamaleek
3
|
Posted - 2012.12.18 23:54:00 -
[66] - Quote
It's not too bad that it's in YAML. It is strange that the official way of converting the MSSQL backup is to do one table per expansion...
There are a crap load of YAML to XXX converters available on their main website, so it shouldn't be too hard to integrate it into your program/app. I do wish CCP would either convert the entire lot to YAML or continue with a DB backup until it's all done though. |
|
CCP Prism X
C C P C C P Alliance
1017
|
Posted - 2012.12.19 09:40:00 -
[67] - Quote
Fixing stools!
I'm going on vacation after tomorrow, Thursday the 20th of December. That means if there are more issues after tomorrow they will not get fixed until 2013. I'm going carefully over all the joins I added to ensure that no further data is lost from the first update to remove the nameless records. Hopefully there will be no further issues with that specific change.
But if there's anything other broken, the window to report it is getting slimmer by the minute. @CCP_PrismX EVE Database Developer and Expert Ranter Member of Team Pony Express |
|
|
CCP Prism X
C C P C C P Alliance
1019
|
Posted - 2012.12.19 11:26:00 -
[68] - Quote
Yet another SDE Deployment: http://content.eveonline.com/data/Retribution_1.0.7_463858_db.zip @CCP_PrismX EVE Database Developer and Expert Ranter Member of Team Pony Express |
|
Dei
Mamaleek
3
|
Posted - 2012.12.19 11:35:00 -
[69] - Quote
Did anyone tell you how awesome you are? |
Steve Ronuken
Fuzzwork Enterprises
859
|
Posted - 2012.12.19 13:46:00 -
[70] - Quote
https://forums.eveonline.com/default.aspx?g=posts&t=184575
In case anyone wants converted versions FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities.As well as mysql and CSV/XLS conversions of the Static Data Extract. |
|
Desmont McCallock
230
|
Posted - 2012.12.19 14:34:00 -
[71] - Quote
SDE looks OK now. Concurring, CCP Prism X all time favorite CCP.
@CCP PrismX Still your #2 fan. (For those who don't know, Karbowiak is #1). |
Lors Dornick
Kallisti Industries Solar Assault Fleet
357
|
Posted - 2012.12.19 15:59:00 -
[72] - Quote
Dei wrote:Did anyone tell you how awesome you are? Shush, don't tell him!
Keep it a secret and hope that he'll work even harder ;)
CCP Eterne: Silly player, ALL devs are evil.
|
Jercy Fravowitz
School of Applied Knowledge Caldari State
4
|
Posted - 2012.12.19 17:34:00 -
[73] - Quote
Desmont McCallock wrote:SDE looks OK now. Concurring, CCP Prism X all time favorite CCP.
- you call that OK? pah. it is totally missing the entry for 500021 in chrFactions. dont you people have real databases with proper FKs?!
- i kinda agree. he is definetly among the top 5 devs. though he was cuter when he was even younger.
- time to hide somewhere.
- oh, yeah.
- my favorite part of this thread is the part with the feedback about the lack of evemon updates, and the suggested workaround/fix. that would sure work. *chuckles*
|
Desmont McCallock
230
|
Posted - 2012.12.19 18:35:00 -
[74] - Quote
Jercy Fravowitz wrote:Desmont McCallock wrote:SDE looks OK now. Concurring, CCP Prism X all time favorite CCP.
- you call that OK? pah. it is totally missing the entry for 500021 in chrFactions. dont you people have real databases with proper FKs?!
- i kinda agree. he is definetly among the top 5 devs. though he was cuter when he was even younger.
- time to hide somewhere.
- oh, yeah.
- my favorite part of this thread is the part with the feedback about the lack of evemon updates, and the suggested workaround/fix. that would sure work. *chuckles*
If only I didn't knew your sense of humor.... |
Snus Mumriken
EVE University Ivy League
16
|
Posted - 2012.12.19 23:19:00 -
[75] - Quote
PrismX, can you please keep the old naming scheme with the tranquility branch change ID instead of this other number? (463858, the build number or something, don't know exactly.)
Thanks! I'm on Twitter. |
Cielle Tische
Who Armed the Carebears
0
|
Posted - 2012.12.20 05:17:00 -
[76] - Quote
Thank god for all the fixes. However, either it didn't import correctly in my DB or something, but the new ships (velator, corax, etc) don't have blueprint information. Everything else seems to be working. Developer of www.eveidb.com - Relational EVE database! [Still under construction -- and stupidly imported the Ret1.0.2 SDE, please disregard missing data!] |
Desmont McCallock
230
|
Posted - 2012.12.20 05:55:00 -
[77] - Quote
Cielle Tische wrote:Thank god for all the fixes. However, either it didn't import correctly in my DB or something, but the new ships (velator, corax, etc) don't have blueprint information. Everything else seems to be working. I can see those blueprints in SDE. |
Cielle Tische
Who Armed the Carebears
0
|
Posted - 2012.12.20 07:04:00 -
[78] - Quote
Desmont McCallock wrote:Cielle Tische wrote:Thank god for all the fixes. However, either it didn't import correctly in my DB or something, but the new ships (velator, corax, etc) don't have blueprint information. Everything else seems to be working. I can see those blueprints in SDE. I'll try reimporting then. And I meant the Venture, not Velator.... My friend just started playing and he was in a velator. Must have been looking at his ship when I typed that xD
This is my example: http://www.eveidb.com/item?i=32881 (Venture) It finds the blueprint, but the material data is missing. Developer of www.eveidb.com - Relational EVE database! [Still under construction -- and stupidly imported the Ret1.0.2 SDE, please disregard missing data!] |
Desmont McCallock
230
|
Posted - 2012.12.20 07:55:00 -
[79] - Quote
According to EVEMon everything is there. Scan the forum on how to get the materials for a BP as it involves more than one table. |
Cielle Tische
Who Armed the Carebears
0
|
Posted - 2012.12.20 08:29:00 -
[80] - Quote
Desmont McCallock wrote:According to EVEMon everything is there. Scan the forum on how to get the materials for a BP as it involves more than one table.
It's just the new ones. All the others work perfectly, for example: http://www.eveidb.com/item?i=24691 (Hyperion)
I reimported the data and still nothing. Also imported into a blank database to see if it was being tainted by old data, and still nada.
---Ahhhahaha. Got it. Forgot to convert the table into the saferead tab. /derp Should be able to fix this fairly quickly. Developer of www.eveidb.com - Relational EVE database! [Still under construction -- and stupidly imported the Ret1.0.2 SDE, please disregard missing data!] |
|
|
|
|
Pages: 1 2 [3] :: one page |
First page | Previous page | Next page | Last page |