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.
 

Eve database dump - incorrect/incomplete?
Author
Previous Topic Next Topic
Laura Agathon
Nothing on Dscan
#1 - 2012-12-23 15:04:16 UTC  |  Edited by: Laura Agathon
I've been doing some work using the EVE database dump, and have noticed that (at least to my eyes) the database is incorrect and/or incomplete.

As seen in this (img) image, there is missing data for some of the blueprints.

A more refined query (img) shows the requirements for the Condor Blueprint, however that doesn't match the ingame blueprint (img - Note I have Production Efficiency V, so no extra waste is caused)

If anyone can shed some light on this, it'd be much appreciated.

Laura


Edit: Image link fixed.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2012-12-23 15:26:14 UTC  |  Edited by: Steve Ronuken
That'd be because you're not accessing the data correctly.


Go read:
http://www.fuzzwork.co.uk/blog/2012/10/24/eve-sde-sql-blueprint-details/


You won't be able to use the sql directly, due to a lack of a greatest function in sql server. But it should explain everything you need.

(oh, your second and third image are the same image btw)



http://www.fuzzwork.co.uk/blueprints/583/0/5/0/5 might be of interest

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Desmont McCallock
#3 - 2012-12-23 15:40:14 UTC
Yo, Steve, ain't you tired answering the same question over and over again? I admire your patients.
Laura Agathon
Nothing on Dscan
#4 - 2012-12-23 16:06:04 UTC  |  Edited by: Laura Agathon
Thankyou for that.

Am I correct in replacing "greatest(0,SUM(quantity))" with "(case when SUM(quantity) > 0 then SUM(quantity) else 0)"?

Edit: Ok, no, thats not working...
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2012-12-23 16:59:25 UTC  |  Edited by: Steve Ronuken
Laura Agathon wrote:
Thankyou for that.

Am I correct in replacing "greatest(0,SUM(quantity))" with "(case when SUM(quantity) > 0 then SUM(quantity) else 0)"?

Edit: Ok, no, thats not working...



try:

Quote:
case when SUM(quantity) > 0 then SUM(quantity) else 0 end quantity


That should do it.

Doesn't need to be wrapped in parenthesis (doesn't hurt though). It's the lack of an end that was screwing it up. The quantity on the end is to just name the column

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2012-12-23 17:02:19 UTC
Desmont McCallock wrote:
Yo, Steve, ain't you tired answering the same question over and over again? I admire your patients.



People answered these questions for me Smile I'm just paying it forwards.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Laura Agathon
Nothing on Dscan
#7 - 2012-12-23 17:56:35 UTC
Steve Ronuken wrote:
Laura Agathon wrote:
Thankyou for that.

Am I correct in replacing "greatest(0,SUM(quantity))" with "(case when SUM(quantity) > 0 then SUM(quantity) else 0)"?

Edit: Ok, no, thats not working...



try:

Quote:
case when SUM(quantity) > 0 then SUM(quantity) else 0 end quantity


That should do it.

Doesn't need to be wrapped in parenthesis (doesn't hurt though). It's the lack of an end that was screwing it up. The quantity on the end is to just name the column




EVE Needs more people like you. You're a legend, cheers for all the help!

Laura