|
|
| Author |
Thread Statistics | Show CCP posts - 12 post(s) |
Zoon
   |
Posted - 2006.01.24 18:37:00 -
[1]
Edited by: Zoon on 24/01/2006 18:46:35
t20, not wishing to alienate the other devs, but I think you're my fave 
You gimme all this really useful information for me to swish up my website! Thankyou 
The only problem I now have is that I use MySql 
*gets to work*
__________________________________
Are you a mission runner?
Have you tried Zoon's Agent Tool? You should! |
Zoon
|
Posted - 2006.01.24 19:37:00 -
[2]
 Originally by: Gigi Barbagrigia
*drolls*
Thanks so much for csv
Originally by: Zoon
The only problem I now have is that I use MySql
This+This=your friend
Not when the files are in TSQL
__________________________________
Are you a mission runner?
Have you tried Zoon's Agent Tool? You should! |
Zoon
|
Posted - 2006.01.25 21:11:00 -
[3]
Originally by: Bedrox
Originally by: DaRuLe
perhaps this is an incredibly stupid question, but where are the names of the agents in the exports? I can't find them 
hehe that and the corporations name, I can't find those two either.
Heh ... I noticed that too ... good job I got my previous agent data to work from!!
__________________________________
Are you a mission runner?
Have you tried Zoon's Agent Tool? You should! |
Zoon
|
Posted - 2006.01.26 19:32:00 -
[4]
Originally by: Pouah
I know I'll look like a total newb but, what are we suppose to do with those files?
If ya hafta ask, then you have no need for it
__________________________________
Are you a mission runner?
Have you tried Zoon's Agent Tool? You should! |
Zoon
|
Posted - 2006.01.29 22:48:00 -
[5]
Now that I've imported all the original zip and the two newly added tables, I am quite gobsmacked at just what can be done with the data.
If I can find the time, I'm going to do everything!! Expand my agent tool, ice belt searches, NPC database, ship fittings maybe?
It's making me dizzy just thinking
__________________________________
Are you a mission runner?
Have you tried our Agent Tool and Mission Guides? You should! |
Zoon
|
Posted - 2006.02.05 11:20:00 -
[6]
Originally by: Bedrock
just out of curiousity, besides the ones already mentioned, what other programs/databases are you people using for all this data? Thanks.
At the moment I'm using MySql (hey I can't afford MSSQL and I wouldn't dare run a Windows webserver, I've done that before, and its a nightmare) and ASP.Net ... although I am using ASP.Net via Mono and Apache 2 which is proving a little troublesome.
I've got a PHP book somewhere so I'll be going PHP/MySql as soon as I get some practice with it.
__________________________________
Are you a mission runner?
Have you tried our Agent Tool and Mission Guides? You should! |
Zoon
|
Posted - 2006.04.16 00:06:00 -
[7]
Originally by: KaReL Lightyear
Watch out... The new layout uses '.' to seperate thousands (within the cvs). It confused my program here ;).
Also... In the Denormalized csv, the "security" is not filled in for solarsystems (and also the REAL security is not filled in anymore I see).
Is it possible to export the security as the real security? Not the one we see ingame?
Thanks!
Check mapsolarsystems. I haven't downloaded the new data yet, but the data you seek was in there on the last export.
I used a double JOIN SQL query to generate the data for my True Security tool, so you should be able to also.
-----
Are you a mission runner? Try our Agent Tool and Mission Guides!
True System Security |
Zoon
|
Posted - 2006.04.16 09:55:00 -
[8]
Originally by: KaReL Lightyear
Not anymore I am afraid (csv speaking). It is still in the SQL-files, I just discovered that ;).
MySql is free and can import all the files almost directly - just hafta change the UNKNOWN type declaration to INT and CHAR(5000) to TEXT within the SQL files. You can do SQL queries at the command line and just copy and paste into Excel, assuming you don't know a bit of PHP / ASP 
-----
Are you a mission runner? Try our Agent Tool and Mission Guides!
True System Security |
|
|
| |
|