Pages: 1 [2] 3 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 7 post(s) |
Xander Hunt
2
|
Posted - 2011.12.06 01:48:00 -
[31] - Quote
Desmont McCallock wrote:@CCP Prism X Is there any particular reason why the invNames table key is bigint? Same goes for invPositions.
64-bit. |
Xander Hunt
2
|
Posted - 2011.12.06 02:08:00 -
[32] - Quote
CCP Prism X wrote:Desmont McCallock wrote:Would be nice if it included the SQL script file. Not very hot on releasing anything about our own internal structure of things. Not that obscurity is security but transparency isn't either.
I can understand the idea of not wanting to release internal structure details, and I don't THINK MS-SQL will export true SQL statements in any form, a simple VB script that connects, reads the table data you define, then exports sanitized SQL code isn't that hard to do. Many bonuses to doing it this way.
A> I don't have to have MS SQL installed anywhere. B> Script kiddies writers can take the SQL code and modify it to whatever their DB preferences are C> When you upgrade to the next version of MS SQL, we won't have to either D> You can limit what tables are exported E> If so inclined, any table that hasn't been changed doesn't need to be included in a new dump.
Downsides: A> Table locking while data is exported - This'll hurt on larger tables, but this could be done on and mirrored server. However, if option E above is done and assuming the bigger tables may not be touched that often, may be a moot point. B> Large export of data that has to live somewhere until its compressed
|
Desmont McCallock
52
|
Posted - 2011.12.06 06:56:00 -
[33] - Quote
Xander Hunt wrote:Desmont McCallock wrote:@CCP Prism X Is there any particular reason why the invNames table key is bigint? Same goes for invPositions. 64-bit.
Well, that's the point. It doesn't need to be 64bit. The id numbering still fits in 32bit (int). |
Mnengli Noiliffe
Imperial Academy Amarr Empire
10
|
Posted - 2011.12.06 07:06:00 -
[34] - Quote
Desmont McCallock wrote:Because T2 modules requirements are combination of invTypeMaterials and ramTypeRequirements. Search the forums, there are at least a dozen topics on the subject.
ok here is the example.
the new t2 gang links, according to the game, have the following common requirements:
106 tritanium 8 transmitter 0.5 RAM Electronics 6 nocxium -- except for skirmish 4 morphite 1 megacyte 13 isogen 1 hypersynaptic fibers 1 link I 3 nanotransistors 8 X microprocessor
now let's see what we get form the export. I am using sqlite version so it might be outdated or wrong...
select (select typeName from invTypes where typeID=materialTypeID),quantity from invTypeMaterials where typeID==(select typeID from invTypes where typeName="Armored Warfare Link - Damage Control II" and published) => [(u'Tritanium', 939), (u'Isogen', 110), (u'Nocxium', 55), (u'Megacyte', 11), (u'Morphite', 3), (u'Nanotransistors', 22), (u'Hypersynaptic Fibers', 11)] |
Desmont McCallock
52
|
Posted - 2011.12.06 07:13:00 -
[35] - Quote
Yet again. Your query returns what you get when you reprocess the item, not what it requires to produce. |
Mnengli Noiliffe
Imperial Academy Amarr Empire
10
|
Posted - 2011.12.06 07:39:00 -
[36] - Quote
so the correct way is to subtract any matching t1 materials from t2 materials, in case there is a t1 consumed item in RAM list?
ok, thanks for the hint and sorry if it's an off topic. |
Lutz Major
Austriae Est Imperare Orbi Universo
51
|
Posted - 2011.12.06 07:55:00 -
[37] - Quote
Mnengli Noiliffe wrote:so the correct way is to subtract any matching t1 materials from t2 materials, in case there is a t1 consumed item in RAM list?
ok, thanks for the hint and sorry if it's an off topic. No. You must only subtract the recycled materials of any recycle-flagged item in the ramTypeRequirements table
For example: Expanded Cargohold II:
SELECT * FROM ramTypeRequirements WHERE typeID = 1320
You see, that the Expanded Cargohold I (requiredTypeID = 1317) is marked as recycle. Now you must subtract the materials from the Expanded Cargohold I from the other materials in the ramTypeRequirements table
See also http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1220024&page=1#30
|
Desmont McCallock
52
|
Posted - 2011.12.06 12:11:00 -
[38] - Quote
Listen to Lutz. He has a PhD on the subject. |
Lutz Major
Austriae Est Imperare Orbi Universo
52
|
Posted - 2011.12.06 12:14:00 -
[39] - Quote
Desmont McCallock wrote:Listen to Lutz. He has a PhD on the subject. Unfortunately I have only a Minmatar Graduation Certificate ... and it isn't even signed |
Desmont McCallock
53
|
Posted - 2011.12.06 15:16:00 -
[40] - Quote
Any ETA for fixed SDE? |
|
|
CCP Prism X
C C P C C P Alliance
226
|
Posted - 2011.12.06 15:18:00 -
[41] - Quote
Stillman just posted the fixed version up in a sticky. Sorry about the delay, I blame the plague. ~ 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. |
|
|
CCP Stillman
C C P C C P Alliance
120
|
Posted - 2011.12.06 15:19:00 -
[42] - Quote
Desmont McCallock wrote:Any ETA for fixed SDE? Yep Associate QA Tester for Team EVESec. |
|
Desmont McCallock
53
|
Posted - 2011.12.06 15:27:00 -
[43] - Quote
This is the definition of "Sync". |
Xander Hunt
2
|
Posted - 2011.12.06 15:45:00 -
[44] - Quote
Desmont McCallock wrote:Xander Hunt wrote:Desmont McCallock wrote:@CCP Prism X Is there any particular reason why the invNames table key is bigint? Same goes for invPositions. 64-bit. Well, that's the point. It doesn't need to be 64bit. The id numbering still fits in 32bit (int).
The point is that the database has been expanded to SUPPORT 64-bit. Whether or not the ID still fits within the 32-bit range isn't the point.
However, that said, I haven't looked at this particular table to see a record count, but I probably will later tonight as I'm writing my own MS SQL Export utility.
http://www.eveonline.com/devblog.asp?a=blog&bid=798
http://www.eveonline.com/devblog.asp?a=blog&bid=813
http://www.eveonline.com/devblog.asp?a=blog&bid=870
|
|
CCP Prism X
C C P C C P Alliance
226
|
Posted - 2011.12.06 15:52:00 -
[45] - Quote
The itemID is 64bit because the API can return 64bit itemIDs and the prudent developer might want to commit data he does not expect to change much to his local DB for a spell. ~ 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
53
|
Posted - 2011.12.06 16:02:00 -
[46] - Quote
@ Xander Hunt I'm fully aware of the subject you linked. Still the PKs for those tables don't necessarily need to be 64bit. But again they may be part of another section of EVE DB that needs them to be 64bit. Never the less, I'll find a workaround on the issue the use of 64bit PKs are causing to EVEMon's data file generation.
Edit: Wrote before seeing Prism X post. |
Zeta Zhul
Preemptive Paranoia
14
|
Posted - 2011.12.06 17:15:00 -
[47] - Quote
Do the previously posted MySQL data conversions included the updated data?
Is there a MySQL data conversion that includes the updated data?
Bueller? :)
Any help would be greatly appreciated thanks! |
Desmont McCallock
53
|
Posted - 2011.12.06 17:20:00 -
[48] - Quote
Patients. I'm sure people are working on it (at least I am). Probably they will post the links on the sticky thread. |
Wind Jammer
Molden Heath Software Company
10
|
Posted - 2011.12.06 23:31:00 -
[49] - Quote
Small point here. The blueprints of the new T2 mods do not have a techLevel attribute on dgmtypeattributes.
For example. these rows from dgmtypeattributes have a techLevel attribute for both the module and the module's blueprint.
typeIDattributeIDvalueIntvalueFloat 23334222(null) 23344222(null)
(where 2333,2334 = Survey Scanner II, Survey Scanner II Blueprint).
With the new T2 modules, the techLevel is set for the module, and not the blueprint. Here are a few of the new T2 modules' blueprints:
select * from dgmtypeattributes where typeid in (4263,4265,4267,4269,4271,4273,4275,4277,4279,4281,4283,4285,4287,4289) and attributeID = 422
-- no rows found
IDs are: 4262Armored Warfare Link - Damage Control II *4263Armored Warfare Link - Damage Control II Blueprint 4264Armored Warfare Link - Passive Defense II *4265Armored Warfare Link - Passive Defense II Blueprint 4266Armored Warfare Link - Rapid Repair II *4267Armored Warfare Link - Rapid Repair II Blueprint 4268Information Warfare Link - Electronic Superiority II *4269Information Warfare Link - Electronic Superiority II Blueprint 4270Information Warfare Link - Recon Operation II *4271Information Warfare Link - Recon Operation II Blueprint 4272Information Warfare Link - Sensor Integrity II *4273Information Warfare Link - Sensor Integrity II Blueprint 4274Mining Foreman Link - Harvester Capacitor Efficiency II *4275Mining Foreman Link - Harvester Capacitor Efficiency II Blueprint 4276Mining Foreman Link - Laser Optimization II *4277Mining Foreman Link - Laser Optimization II Blueprint 4278Mining Foreman Link - Mining Laser Field Enhancement II *4279Mining Foreman Link - Mining Laser Field Enhancement II Blueprint 4280Siege Warfare Link - Active Shielding II *4281Siege Warfare Link - Active Shielding II Blueprint 4282Siege Warfare Link - Shield Efficiency II *4283Siege Warfare Link - Shield Efficiency II Blueprint 4284Siege Warfare Link - Shield Harmonizing II *4285Siege Warfare Link - Shield Harmonizing II Blueprint 4286Skirmish Warfare Link - Evasive Maneuvers II *4287Skirmish Warfare Link - Evasive Maneuvers II Blueprint 4288Skirmish Warfare Link - Interdiction Maneuvers II *4289Skirmish Warfare Link - Interdiction Maneuvers II Blueprint
[url]http://eveproductionmixer.appspot.com[/url]
|
Ruziel
Twilight Military Industrial Complex
1
|
Posted - 2011.12.07 02:45:00 -
[50] - Quote
See here for MySQL conversion. |
|
Pizzutz
Capital Industries Research And Development Fidelas Constans
0
|
Posted - 2011.12.07 12:21:00 -
[51] - Quote
Pizzutz wrote:Will we be getting an updated invControlTowerResources table when the fuel block switchover happens, or will the fuel resources be managed a different way?
|
Desmont McCallock
64
|
Posted - 2011.12.10 08:02:00 -
[52] - Quote
In case you didn't noticed. SDE conversions. |
Mesar Thorrn
Imperial Academy Amarr Empire
0
|
Posted - 2011.12.10 15:46:00 -
[53] - Quote
Hello!
I-¦m looking for a TypeID to ItemName conversion .txt file
Does anyone know a file, up to date with the Crucible expansion or is able to generate one out of the database-dump? The only list I-¦ve found http://eve-files.com/chribba/typeid.txt isnt up to date.
Thanks in advance.
|
|
Chribba
Otherworld Enterprises Otherworld Empire
1138
|
Posted - 2011.12.10 16:07:00 -
[54] - Quote
Mesar Thorrn wrote:Hello! I-¦m looking for a TypeID to ItemName conversion .txt file Does anyone know a file, up to date with the Crucible expansion or is able to generate one out of the database-dump? The only list I-¦ve found http://eve-files.com/chribba/typeid.txt isnt up to date. Thanks in advance. I'm gonna update that one asap. I'm just a bit delayed.
edit/updated. sorry for the delay.
/c
|
|
Desmont McCallock
64
|
Posted - 2011.12.10 16:17:00 -
[55] - Quote
Oh, what an honor ! Posting right after your highness. |
M Kernel
Karma Tec
2
|
Posted - 2012.01.05 12:25:00 -
[56] - Quote
So I've now tried all 3 MySQL conversions from the official SDE Thread.
However, on 2 of them (Luminocity and Desmont's) I have charset issues. When i do
Quote:SELECT `description` FROM `invtypes` WHERE `typeID` =2869
i get this.
Ruziel's conversions seems to work thogh.
Can anyone confirm/deny this? (or, tell me what I did wrong?) |
|
CCP Prism X
C C P C C P Alliance
480
|
Posted - 2012.01.05 13:17:00 -
[57] - Quote
"Only the highly advanced Ukomi superconductor can be rendered small enough for use in nano-factories, microscopic devices programmed to absorb and recycle ambient material into useful matter. Each factory is built from reactive metals, ensuring that they interact properly GÇô or not at all GÇô with their environment, while a mote of industrial explosive automatically destroys them when they have completed their task."
From the DB we generate the backup from. ~ CCP Prism X EVE Database Developer If anything in this post was informative or could be considered as 'good news' to you - chances are you've misread it. |
|
Desmont McCallock
98
|
Posted - 2012.01.05 13:42:00 -
[58] - Quote
M Kernel wrote:So I've now tried all 3 MySQL conversions from the official SDE Thread. However, on 2 of them (Luminocity and Desmont's) I have charset issues. When i do Quote:SELECT `description` FROM `invtypes` WHERE `typeID` =2869
i get this. Ruziel's conversions seems to work thogh. Can anyone confirm/deny this? (or, tell me what I did wrong?)
"CHARSET=utf8" is what I use. Jercy also used this CHARSET. In my MySQL DB, description shows up fine. |
Phoenix Pryde
3-I Area 42
0
|
Posted - 2012.01.07 14:39:00 -
[59] - Quote
Is there by chance some MySQL dump with individual tables ? (my upload sucks, making the singlefile ones a pain to use ^^) |
DerStrick
ZERO T0LERANCE RAZOR Alliance
0
|
Posted - 2012.01.21 00:10:00 -
[60] - Quote
Hi theres,
is there a known dump for spaceships only? I am currently working at a table for this but sorting out all the ships is a mess.
tyvm
regards |
|
|
|
|
Pages: 1 [2] 3 :: one page |
First page | Previous page | Next page | Last page |