| Pages: [1] 2 3 4 :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 3 post(s) |
|
CCP Garthagk
   |
Posted - 2007.12.04 17:05:00 -
[1]
Here's the SQL so far. Thanks again to our anonymous friend for converting this to MySQL.
trinity_1.0_sql.zip [MS SQL, 39MB]
trinity_1.0_sql_mysql5.tar.bz2 [MySQL, 30MB]
Icons are still in progress, actually updating the code to render it out to work with the Trinity client is taking some time.
--------------
Garthagk - EVE Software Group - EVE API Guy
Proud to fly Amarr. Long live the Emperor...well, the Empire at least. |
|
|
Chribba
Otherworld Enterprises
Otherworld Empire
|
Posted - 2007.12.04 17:11:00 -
[2]
Nice then I got something to do while DT tomorrow 
Secure 3rd party service ■ the Love project |
|
Vessper
The Graduates
Brutally Clever Empire
|
Posted - 2007.12.04 17:30:00 -
[3]
Excellent - thank your sir 
--------------
EveHQ Character App | Item Database |
Jameroz
Art of War
|
Posted - 2007.12.04 17:32:00 -
[4]
Thanks especially for the MySQL version! 
|
Mercahnt
|
Posted - 2007.12.04 17:43:00 -
[5]
how can i view that ?
|
cinderbrood
Caldari
Dark Prophecy Inc.
Knights Of the Southerncross
|
Posted - 2007.12.04 17:45:00 -
[6]
where do we send love and bree?
Thanks Gives me something to do now \o/
|
cinderbrood
Caldari
Dark Prophecy Inc.
Knights Of the Southerncross
|
Posted - 2007.12.04 17:48:00 -
[7]
 Originally by: Mercahnt
how can i view that ?
Its just a database file so upload it into a database and code some scripts to view it or look through it in the database manually.
Im working with my own scripts to dump it into something readable for my own use, If there clean enough for anyone to setup and use i may post a link to the downloads. But they not finished yet so doing so now would be pointless.
If the veldgod ( mr chribba of course ) wouldn't mind and i get em done in time, Ill try and contact him to get them hosted viewable on eve files if he hasn't done his own such yet.
|
|
CCP Garthagk
|
Posted - 2007.12.04 17:51:00 -
[8]
Just a note, apparently with this expansion we've decided to modernize some of our items: you'll find Microsoft style "Smart Quotes" and similar evil things in some item names and descriptions.
I leave dealing with this an exercise for the reader...
--------------
Garthagk - EVE Software Group - EVE API Guy
Proud to fly Amarr. Long live the Emperor...well, the Empire at least. |
|
dimensionZ
Reikoku
Band of Brothers
|
Posted - 2007.12.04 18:13:00 -
[9]
Wewt, first time that the data export is available BEFORE the expansion \o/
Now if we can get the icons tomorrow :P that would be grand
----------------------------------------
|
Clogs'R'us
Caldari
The Crimson Death
|
Posted - 2007.12.04 22:27:00 -
[10]
Awsome!
Thank you very much!
|
|
|
Amida Ta
|
Posted - 2007.12.04 23:38:00 -
[11]
Do we also get the CSVs?
|
|
CCP Garthagk
|
Posted - 2007.12.06 11:56:00 -
[12]
Originally by: Amida Ta
Do we also get the CSVs?
Sorry, the CSVs are not being exported at this time. I'm sure someone would be willing to get you a CSV of the data you want, though, or you could use the SQL files here to generate your own.
--------------
Garthagk - EVE Software Group - EVE API Guy
Proud to fly Amarr. Long live the Emperor...well, the Empire at least. |
|
dimensionZ
Reikoku
Band of Brothers
|
Posted - 2007.12.06 12:07:00 -
[13]
Noticed that the icon pack came in black/grey/white. But we used to have the transparent PNGs, anychance of getting that again ?
----------------------------------------
|
dimensionZ
Reikoku
Band of Brothers
|
Posted - 2007.12.06 12:18:00 -
[14]
Originally by: dimensionZ
Noticed that the icon pack came in black/grey/white. But we used to have the transparent PNGs, anychance of getting that again ?
Seems that they already are transparents. My mistake!
----------------------------------------
|
Schwigg
Station Huggers Inc.
|
Posted - 2007.12.07 03:58:00 -
[15]
I have the MySQL version of the data dump and I'm trying to import it into a hosted database, but I'm running into a couple of issues... I'm hoping someone here can help.
1. My interface to the database is PHPMyAdmin, which has a 2MB limit on imported SQL files. I'm assuming that breaking up the SQL files will do the trick, but this will be pretty tedious when I get to some of the larger files.
2. Even for files < 2MB in size, I'm still getting errors on the lines with the /* */ text.
Is there anyone here that has been able to import these files into MySQL using PHPMyAdmin? Any tips & tricks to make the process a little easier? Unfortunately, my hosting provider does not allow for shell access, so I'm not sure I can use MySQL directly.
-Schwigg
Founder, CEO
Station Huggers, Inc. |
Rhispa
Merch Industrial
GoonSwarm
|
Posted - 2007.12.07 13:53:00 -
[16]
Edited by: Rhispa on 07/12/2007 13:52:56
I tried importing with phpMyAdmin once and gave up on the first big file, it's just too tedious.
Your best bet is trying the Mysql Query Browser which is part of the mysql gui tools. With this I've never had any problems even with the largest files.
|
Clogs'R'us
Caldari
The Crimson Death
|
Posted - 2007.12.07 14:39:00 -
[17]
If your mysql server is on linux or unix the command line workes the best.
you can just unzip the files to a folder and create a batch script something like:
Quote:
#!/bin/bash
for file in /pathtofiles/*.sql
do
echo ===========================
echo Updating file $file
mysql -u username --password=yourpassword -D yourdatabase < $file
done
to get full details on the import you can add "-v" in the mysql command. The -v can be added more than once for more details. Remember that you will need to make the file executable with a 'chmod 700 srcipt", and the script as I have it has your password in it, and you need to be keep in mind who might see that script. I would remove it as soon as I am done using it.
|
Marak Bon
|
Posted - 2007.12.08 22:25:00 -
[18]
Thankyou very much.
******s knuckles*
Time to have some fun 
|
DaOpa
Amarr
Static Corp
|
Posted - 2007.12.09 23:02:00 -
[19]
Question for a couple of the provided tables ..
I see there is one for Agt Offer Details..
This shows all the different types of LP offers..
My question is .. would I be missing a table that shows what LP Offers go with the corps?
Or is that information just not provided .. !
K thnx
----------
Static Corp Website |
Merrowinger
|
Posted - 2007.12.10 09:34:00 -
[20]
Hi there.
I found out that in this db dump there are many "test-items" in the invTypes table. Like skills that should not appear in game.
I use this table for a Tool in which the normal (gettable) items should be available but not things like test-scripts or Stargates.
In the last db dumps i could sort these things out. I dont exactly remember how i did this, but im pretty sure i have done it with help of the "published" column.
But in this dump there are things like cargo container or the velator marked with "published=false".
In the Backup of the last db dump i see the velator as "published=true".
So is this maybe an error in the db release? Or is it a misunderstanding of the "published" column by myself?
If its a misunderstanding, please tell me how i can get rid of testobjects in the invtypes table.
|
|
|
Clogs'R'us
Caldari
The Crimson Death
|
Posted - 2007.12.10 17:23:00 -
[21]
Quote:
Rendered blueprint icons are not yet available. We're working on them.
Anyword on the blueprint icons yet..
|
Amida Ta
|
Posted - 2007.12.10 23:54:00 -
[22]
Edited by: Amida Ta on 10/12/2007 23:54:23
Originally by: Merrowinger
Hi there.
I found out that in this db dump there are many "test-items" in the invTypes table. Like skills that should not appear in game.
I use this table for a Tool in which the normal (gettable) items should be available but not things like test-scripts or Stargates.
In the last db dumps i could sort these things out. I dont exactly remember how i did this, but im pretty sure i have done it with help of the "published" column.
But in this dump there are things like cargo container or the velator marked with "published=false".
In the Backup of the last db dump i see the velator as "published=true".
So is this maybe an error in the db release? Or is it a misunderstanding of the "published" column by myself?
If its a misunderstanding, please tell me how i can get rid of testobjects in the invtypes table.
Usually you can identify testobjects because they have special ID numbers which are higher or somehow else different from the rest.
|
Monsieur
|
Posted - 2007.12.11 00:12:00 -
[23]
Thanks a lot for this info...
It really *is* awesome of you to make this stuff available to us players!
|
Raquel Smith
Caldari
Freedom-Technologies
|
Posted - 2007.12.11 22:18:00 -
[24]
Edited by: Raquel Smith on 11/12/2007 22:18:44
Postgres 8.1 dump available here: http://dl.eve-files.com/media/corp/crudvis/trinity-postgres-8.1.zip
edit: linky
--
Creator of The Ruby API Library |
Bellatroix
Gallente
Eve University
Ivy League
|
Posted - 2007.12.11 22:33:00 -
[25]
Just another quick note that you may already know about - it looks like some of the DX9 icons, especially the smaller ones, are still using the DX8 shots of the ships. The Dominix (ID 645) is one of the ones I noticed - the 256 and 128 sizes are the new model, the smaller icons are the old icon/model.
Otherwise, this is awesome. Nice and easy to update :)
|
Azia Burgi
Caldari
Science and Trade Institute
|
Posted - 2007.12.13 14:55:00 -
[26]
I've been waiting for a devblog announcing this! sneaky forum posts 4TL!
has anyone got an MS Access version yet?
Azia Burgi
http://azia.geekandproud.co.uk
BP Profit Calculator
EVE Cemetery |
Jack Toad
Federal Space Academy
Red Army Alliance
|
Posted - 2007.12.14 05:29:00 -
[27]
Made an sqlite3 version of the dump. Where I can put it to share? 
|
Holy Cheater
Red Alliance
|
Posted - 2007.12.14 10:04:00 -
[28]
ship images are not fully rendered: there are some old ship images.
|
Flaming Candle
|
Posted - 2007.12.14 12:27:00 -
[29]
Originally by: Jack Toad
Made an sqlite3 version of the dump. Where I can put it to share?
You could try eve-files.
|
Jack Toad
Federal Space Academy
Red Army Alliance
|
Posted - 2007.12.17 10:33:00 -
[30]
Edited by: Jack Toad on 17/12/2007 10:35:55
Edited by: Jack Toad on 17/12/2007 10:34:03
Originally by: Flaming Candle
Originally by: Jack Toad
Made an sqlite3 version of the dump. Where I can put it to share?
You could try eve-files.
Thank you.
Here it is: http://dl.eve-files.com/media/0712/trinity_1.0_sqlite3.db.zip [~60Mb]
PS: It's conversion of the Mysql5 version of the dump with the same keys and indexes.
|
|
|
|
|
| |
|
| Pages: [1] 2 3 4 :: one page |
| First page | Previous page | Next page | Last page |