These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Crucible database dump

First post
Author
Previous Topic Next Topic
CCP Prism X
C C P
C C P Alliance
#41 - 2011-12-06 15:18:57 UTC
Stillman just posted the fixed version up in a sticky.
Sorry about the delay, I blame the plague. Blink

CCP Prism X

Programmer on Team Gridlock & Expert Ranter
CCP Stillman
C C P
C C P Alliance
#42 - 2011-12-06 15:19:10 UTC
Desmont McCallock wrote:
Any ETA for fixed SDE?

Yep

Just a random dude in Team Security.
Desmont McCallock
#43 - 2011-12-06 15:27:28 UTC
This is the definition of "Sync".
Xander Hunt
#44 - 2011-12-06 15:45:51 UTC
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
#45 - 2011-12-06 15:52:29 UTC
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

Programmer on Team Gridlock & Expert Ranter
Desmont McCallock
#46 - 2011-12-06 16:02:14 UTC  |  Edited by: Desmont McCallock
@ 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
#47 - 2011-12-06 17:15:50 UTC
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
#48 - 2011-12-06 17:20:58 UTC
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
#49 - 2011-12-06 23:31:22 UTC
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.

typeID attributeID valueInt valueFloat
2333 422 2 (null)
2334 422 2 (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:
4262 Armored Warfare Link - Damage Control II
*4263 Armored Warfare Link - Damage Control II Blueprint
4264 Armored Warfare Link - Passive Defense II
*4265 Armored Warfare Link - Passive Defense II Blueprint
4266 Armored Warfare Link - Rapid Repair II
*4267 Armored Warfare Link - Rapid Repair II Blueprint
4268 Information Warfare Link - Electronic Superiority II
*4269 Information Warfare Link - Electronic Superiority II Blueprint
4270 Information Warfare Link - Recon Operation II
*4271 Information Warfare Link - Recon Operation II Blueprint
4272 Information Warfare Link - Sensor Integrity II
*4273 Information Warfare Link - Sensor Integrity II Blueprint
4274 Mining Foreman Link - Harvester Capacitor Efficiency II
*4275 Mining Foreman Link - Harvester Capacitor Efficiency II Blueprint
4276 Mining Foreman Link - Laser Optimization II
*4277 Mining Foreman Link - Laser Optimization II Blueprint
4278 Mining Foreman Link - Mining Laser Field Enhancement II
*4279 Mining Foreman Link - Mining Laser Field Enhancement II Blueprint
4280 Siege Warfare Link - Active Shielding II
*4281 Siege Warfare Link - Active Shielding II Blueprint
4282 Siege Warfare Link - Shield Efficiency II
*4283 Siege Warfare Link - Shield Efficiency II Blueprint
4284 Siege Warfare Link - Shield Harmonizing II
*4285 Siege Warfare Link - Shield Harmonizing II Blueprint
4286 Skirmish Warfare Link - Evasive Maneuvers II
*4287 Skirmish Warfare Link - Evasive Maneuvers II Blueprint
4288 Skirmish Warfare Link - Interdiction Maneuvers II
*4289 Skirmish Warfare Link - Interdiction Maneuvers II Blueprint

http://eveproductionmixer.appspot.com
Ruziel
Twilight Military Industrial Complex
#50 - 2011-12-07 02:45:42 UTC
See here for MySQL conversion.
Pizzutz
Aliastra
Gallente Federation
#51 - 2011-12-07 12:21:07 UTC
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
#52 - 2011-12-10 08:02:00 UTC
In case you didn't noticed.
SDE conversions.
Mesar Thorrn
Imperial Academy
Amarr Empire
#53 - 2011-12-10 15:46:43 UTC
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
#54 - 2011-12-10 16:07:15 UTC  |  Edited by: Chribba
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

★★★ Secure 3rd party service ★★★

Visit my in-game channel 'Holy Veldspar'

Twitter @ChribbaVeldspar
Desmont McCallock
#55 - 2011-12-10 16:17:12 UTC
Oh, what an honor ! Posting right after your highness. Big smile
M Kernel
Cayman Applied Kinetics
#56 - 2012-01-05 12:25:22 UTC
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
#57 - 2012-01-05 13:17:56 UTC
"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 – or not at all – 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

Programmer on Team Gridlock & Expert Ranter
Desmont McCallock
#58 - 2012-01-05 13:42:22 UTC
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
#59 - 2012-01-07 14:39:24 UTC
Is there by chance some MySQL dump with individual tables ?
(my upload sucks, making the singlefile ones a pain to use ^^)
DerStrick
Combined Interstellar Starflight And Shipment
#60 - 2012-01-21 00:10:04 UTC
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