Pages: 1 [2] 3 4 5 6 7 8 9 10 11 12 13 14 .. 14 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 3 post(s) |
Anders Chydenius
Phoenix Industries
|
Posted - 2006.12.07 14:10:00 -
[31]
\o/ Wubbins! ------ {o,o} (__(| -"-"- EVEMon - The open source Jamaican wiseman. |
Eewec Ourbyni
Caldari
|
Posted - 2006.12.07 15:06:00 -
[32]
Originally by: t20 I can't help it if you don't read the blog complaining about things like creating the tables etc, as it's all available in the previous blog. No worries though, I'll add the missing tables and add it for you to download later on today.
I'm assuming you mean the blog where you released the old data dumps.... the one with the old table definitions that haven't got things like shortdescriptions and stuff in them.... but <3 for this, it's not actually too hard so far to build the table creation statements with what we have here.... least it hasn't been so far.
Now if I could only get these pesky customers to leave me alone for a few hours so I could really get to grips with it all.... only done the first 13 tables so far.
This is a sig...
-- You think this guys post is nuts.... you should see his bio --
... good, ain't it! |
Moriiko
Nakama Gemini Federation
|
Posted - 2006.12.07 15:09:00 -
[33]
If someone can possibly provide some SQL to create the tables that would be great. Other than that nice work.
|
Eewec Ourbyni
Caldari
|
Posted - 2006.12.07 15:36:00 -
[34]
Edited by: Eewec Ourbyni on 07/12/2006 15:37:28 Quick Q: In dbo.chrRaceSkills do folks think that 'levels' is an INTEGER or a BOOLEAN?
Also, same question for supplierType in dbo.crpNPCCorporationResearchFields.
This is a sig...
-- You think this guys post is nuts.... you should see his bio --
... good, ain't it! |
Ryan Coolness
Esophorics Anonymous
|
Posted - 2006.12.07 15:36:00 -
[35]
Originally by: t20 I can't help it if you don't read the blog complaining about things like creating the tables etc, as it's all available in the previous blog. No worries though, I'll add the missing tables and add it for you to download later on today.
t20, you are a god among men. Griefwatch and women everywhere thank you for merely existing.
|
Dalekplunger Slick
Caldari DPS Holding Corporation
|
Posted - 2006.12.07 16:29:00 -
[36]
Hey what happened to the eveNames table? Where did it go?
|
Beatle Bones
|
Posted - 2006.12.07 17:32:00 -
[37]
Anyone interested in CSV rather than SQL try here
The secret to creativity is knowing how to hide your sources. |
StarLite
Amarr Evolution Band of Brothers
|
Posted - 2006.12.07 17:46:00 -
[38]
Originally by: Dalekplunger Slick
Originally by: t20 I can't help it if you don't read the blog complaining about things like creating the tables etc, as it's all available in the previous blog. No worries though, I'll add the missing tables and add it for you to download later on today.
I don't see anything about how to create the tables in http://myeve.eve-online.com/devblog.asp?a=blog&bid=246 or http://myeve.eve-online.com/devblog.asp?a=blog&bid=406
Is there some other blog that you're talking about?
I haven't been able to find it as well. _______________________________________________________________________
This sig is guarded by SigGuard(c) |
Cade Nemec
|
Posted - 2006.12.07 18:18:00 -
[39]
wow, this info looks awesome. what a cool service. thank you very much, t20 [and kieron].
would someone be able to point me toward the ship info or is that even part of this export? [and by ship info i mean stats, fittings, etc].
|
Eewec Ourbyni
Caldari
|
Posted - 2006.12.07 18:18:00 -
[40]
Edited by: Eewec Ourbyni on 07/12/2006 18:19:03 Also, I notice now that the titans entry in dbo.invGroups has been cut off at 500 characters, that's just something I've noticed due to just having looked at that table to create it.... I'm kinda posting as I go, that way I'm less likely to forget stuff.
This is a sig...
-- You think this guys post is nuts.... you should see his bio --
... good, ain't it! |
|
Keikko Aranata
Amarr Imperial Academy
|
Posted - 2006.12.07 18:21:00 -
[41]
Edited by: Keikko Aranata on 07/12/2006 18:21:21 Keiron, just to close the loop on the original/old thread, could you please edit your last/lock post and add in the URL to *this* topic thread in that post?
I mean your post here: http://oldforums.eveonline.com/?a=topic&threadID=274124&page=13#363
- K. Aranata
|
Altaree
Gallente Red Frog Investments Daikoku Trade Syndicate
|
Posted - 2006.12.07 18:48:00 -
[42]
Be nice to T20, I want to stop being a '!'
Fix The Web Servers
|
Iain Cormac
|
Posted - 2006.12.07 18:54:00 -
[43]
Edited by: Iain Cormac on 07/12/2006 19:12:24 Edit: Never mind, my mistake.
|
Gilgamoth
Imperium Technologies Firmus Ixion
|
Posted - 2006.12.07 19:51:00 -
[44]
WOOHOOO
/me does the happy dance...
All we need now is a working char sheet :-D
Thanks t20, you're the best.
Regards,
Gil
Future Falcon EVE Tools - Project Leader.
|
|
t20
|
Posted - 2006.12.07 20:20:00 -
[45]
Archive file updateded with missing tables + added table structure.
|
|
Eewec Ourbyni
Caldari
|
Posted - 2006.12.07 21:19:00 -
[46]
Oh, btw, t20 (cute and cuddly and extremely cool)
hmmm, and did I mention, thankyouthankyouthankyouthankyouthankyou
Think that covers it.
This is a sig...
-- You think this guys post is nuts.... you should see his bio --
... good, ain't it! |
Silvatico
Far Ranger
|
Posted - 2006.12.07 22:31:00 -
[47]
Originally by: Futurama Which of the following would you most most prefer?
(a) A puppy; (b) A pretty flower from your sweetie; (c) A large, properly-formatted data file.
Choose!
(c)... thank you!
|
Quutar
Caldari Auraxian Irregulars
|
Posted - 2006.12.07 22:48:00 -
[48]
(I am not complaining in the LEAST)
the following table definitions are missing chrFactions chrSchoolAgents eveUnits invFlags invMetaGroups invTypeReactions TL2MaterialsForTypeWithActivity
and we have the definition for these, but no data mapSecurityRatings ramActivities ramassemlylinecostlog raminstallationtypedefaultcontents
Not finding research slots in Empire Space? Try Quutar Research Services. |
Quutar
Caldari Auraxian Irregulars
|
Posted - 2006.12.07 22:48:00 -
[49]
Originally by: Quutar (I am not complaining in the LEAST)
the following table definitions are missing chrFactions chrSchoolAgents eveUnits invFlags invMetaGroups invTypeReactions TL2MaterialsForTypeWithActivity
and we have the definition for these, but no data mapSecurityRatings ramActivities ramassemlylinecostlog raminstallationtypedefaultcontents
I am going to see if I can piece together some definitions for the 7 tables with out definitions (might be able to get them from the rmr version... or just inspect the data and guess)
Not finding research slots in Empire Space? Try Quutar Research Services. |
Altaree
Gallente Red Frog Investments Daikoku Trade Syndicate
|
Posted - 2006.12.07 22:49:00 -
[50]
t20, can you get the website updated with the new data please?
Fix The Web Servers
|
|
Eewec Ourbyni
Caldari
|
Posted - 2006.12.07 22:59:00 -
[51]
Originally by: t20 Archive file updateded with missing tables + added table structure.
Hit a tiny incy wincy snag with your table creators, it locked my mssql so completely, I've had to almost reinstall the thing to get it to work again....
other than that, things are looking good.
This is a sig...
-- You think this guys post is nuts.... you should see his bio --
... good, ain't it! |
Quutar
Caldari Auraxian Irregulars
|
Posted - 2006.12.07 23:23:00 -
[52]
also... in the dbo_eveNames.sql file... the table name is "dbo.dbo_eveNames" instead of "dbo.eveNames"
(more as I import... i have already had to massage the table definitions to get them to work in MySQL... but that was a given)
Not finding research slots in Empire Space? Try Quutar Research Services. |
Quutar
Caldari Auraxian Irregulars
|
Posted - 2006.12.07 23:33:00 -
[53]
also missing the invmetatypes table definition
Not finding research slots in Empire Space? Try Quutar Research Services. |
Internet Knight
Caldari The Knighthawks Ratel Alliance
|
Posted - 2006.12.08 00:30:00 -
[54]
Forgive me for being an SQL newbie, I generally only use INSERT/UPDATE/DELETE... what is this IDENTITY(x, 1) definition in several of the table declarations?
|
Derrys
Caldari Caldari Independent Navy Reserve
|
Posted - 2006.12.08 01:12:00 -
[55]
Edited by: Derrys on 08/12/2006 01:13:40
Originally by: Internet Knight Forgive me for being an SQL newbie, I generally only use INSERT/UPDATE/DELETE... what is this IDENTITY(x, 1) definition in several of the table declarations?
An identity is a field which is automatically incremented for each new row added to the table -- so the first row would automatically be assigned a value of 1, the next row would be assigned a value of 2, and so on. Depending on what other database tools you use, you may know it as an Autonumber or Autoincrement.
Frankly I wonder why the identity fields are there, since the values of those fields are being set explicitly by the INSERT statements, and I don't think people are going to be adding more rows to these tables anyway. I think it would be pretty safe to remove the IDENTITY statements if they're messing things up for you.
|
Cade Nemec
|
Posted - 2006.12.08 01:19:00 -
[56]
does anyone know where i can find the ship information like number of slots, cargo capacity, drone bay, etc?
|
ToxicFire
Warlords Corp The Core Collective
|
Posted - 2006.12.08 02:21:00 -
[57]
is that MS SQL statements I see in those definitions, FOR SHAME on you t20, but good job getting it out.
Join the save Stargate SG1 Campaign Today! http://savestargatesg1.com/
|
Ray McCormack
BIG
|
Posted - 2006.12.08 02:44:00 -
[58]
Thank you very much t20, I appreciate it extremely.
And to those of you moaning about specific formats, stop being lazy bums.
| How To Afford A Tech II BPO | the all mighty BIG industrial corp from hell with a slong the size of a walrus. |
BlueFieldsInMay
|
Posted - 2006.12.08 03:54:00 -
[59]
Originally by: Dalekplunger Slick
Originally by: t20 I can't help it if you don't read the blog complaining about things like creating the tables etc, as it's all available in the previous blog. No worries though, I'll add the missing tables and add it for you to download later on today.
I don't see anything about how to create the tables in http://myeve.eve-online.com/devblog.asp?a=blog&bid=246 or http://myeve.eve-online.com/devblog.asp?a=blog&bid=406
Is there some other blog that you're talking about?
Well I'm not sure how much help you need. But I can point out that the statments to create the tables are in the file dbo___TABLES.sql. In the last export these statments where each in the file that contains that tables inserts.
T20 you might want to point that out in the new dev blog :)
|
Andargor theWise
Disbelievers of Fate The SUdden Death Squad
|
Posted - 2006.12.08 05:16:00 -
[60]
This is a cross-post, sorry... Original in this thread. I thought I should post it in the official thread...
FWIW this is my MySQL conversion:
Linkage (~32 MB)
- Create the "dbo" database, if not already done - It will drop any existing tables, so backup your stuff first...
CCP again forgot some CREATEs... So I guesstimated.
I had to fiddle with data types, there were truncations on some of the IDs which were tinyint(4). I changed them to smallint(6).
Also, I nixed the autoincrements, since I intend to use the data as read-only.
- Got grief?
|
|
|
|
|
Pages: 1 [2] 3 4 5 6 7 8 9 10 11 12 13 14 .. 14 :: one page |
First page | Previous page | Next page | Last page |