Pages: 1 [2] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 8 post(s) |
Aquila Sagitta
Blue-Fire
322
|
Posted - 2014.06.15 18:36:00 -
[31] - Quote
I don't think I have access to a command line for sql thru Wamp.
Could I just make a php script that builds the database with the files and put the dump files in my Wamp www directory?
What are the .yaml files for? Blue-Fire Best Fire |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
3418
|
Posted - 2014.06.15 20:08:00 -
[32] - Quote
Aquila Sagitta wrote:I don't think I have access to a command line for sql thru Wamp.
Could I just make a php script that builds the database with the files and put the dump files in my Wamp www directory?
What are the .yaml files for?
Some of the data isn't in the original export (or in the version I provide. I've loaded some of it)
As for the command line, I'm surprised. you'd be looking for an exe called mysql Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
Aquila Sagitta
Blue-Fire
322
|
Posted - 2014.06.15 21:18:00 -
[33] - Quote
Oh wow I'm dumb... totally passed over MySql Console the first time thinking thats not it derp. Thanks for the help! Blue-Fire Best Fire |
Aquila Sagitta
Blue-Fire
323
|
Posted - 2014.06.15 23:52:00 -
[34] - Quote
Ok got kronos.sql file to build the tables. What do I do with the .yaml files? Blue-Fire Best Fire |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
3418
|
Posted - 2014.06.16 00:20:00 -
[35] - Quote
Aquila Sagitta wrote:Ok got kronos.sql file to build the tables. What do I do with the .yaml files?
In general, ignore them. unless you need the data in them Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
Doctor Goldsmith
Center for Advanced Studies Gallente Federation
0
|
Posted - 2014.06.19 01:19:00 -
[36] - Quote
What is an SDE? |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
3432
|
Posted - 2014.06.19 03:44:00 -
[37] - Quote
Doctor Goldsmith wrote:What is an SDE?
Static Data Extract.
It's the data which doesn't change day to day, about EVE. Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
Desmont McCallock
384
|
Posted - 2014.06.22 18:11:00 -
[38] - Quote
Steve Ronuken wrote:Doctor Goldsmith wrote:What is an SDE? Static Data Extract. It's the data which doesn't change day to day, about EVE. I thought SDE stand for Static Data Export but.... what the heck, at the end it's all static data after all. :p |
Zifrian
Licentia Ex Vereor Black Core Alliance
1513
|
Posted - 2014.07.06 00:16:00 -
[39] - Quote
Found another data error.
In the invTypeReactions table, the output (input = 0) for all Metamaterials Reactions is 1 but the reaction in game provides 300 units.
reactionTypeIDs are 33363,33364,33365,33366 GÇ£Any fool can criticize, condemn, and complain - and most fools do. GÇ¥ - Dale Carnegie
Maximze your Industry Potential! - Download EVE Isk per Hour! |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
3504
|
Posted - 2014.07.07 01:21:00 -
[40] - Quote
Zifrian wrote:Found another data error.
In the invTypeReactions table, the output (input = 0) for all Metamaterials Reactions is 1 but the reaction in game provides 300 units.
reactionTypeIDs are 33363,33364,33365,33366
Reactions have always been a bit funky.
https://github.com/fuzzysteve/reactions/blob/master/reactionmodifier.sql
There's a reason I put together a table to handle the input/output multipliers. Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
|
|
CCP FoxFour
C C P C C P Alliance
3334
|
Posted - 2014.07.07 06:44:00 -
[41] - Quote
Steve Ronuken wrote:Zifrian wrote:Found another data error.
In the invTypeReactions table, the output (input = 0) for all Metamaterials Reactions is 1 but the reaction in game provides 300 units.
reactionTypeIDs are 33363,33364,33365,33366 Reactions have always been a bit funky. https://github.com/fuzzysteve/reactions/blob/master/reactionmodifier.sqlThere's a reason I put together a table to handle the input/output multipliers.
Steve, remind me about this in August if you think it's worth me poking someone to get fixed. CCP FoxFour // Game Designer // @regnerba
|
|
Dimitrie
Free-Space-Ranger Nulli Secunda
6
|
Posted - 2014.07.07 07:01:00 -
[42] - Quote
look at this post https://forums.eveonline.com/default.aspx?g=posts&m=4732096#post4732096 |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
3504
|
Posted - 2014.07.07 11:55:00 -
[43] - Quote
Ahh.
I guess that makes sense Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
Dimitrie
Free-Space-Ranger Nulli Secunda
6
|
Posted - 2014.07.07 14:14:00 -
[44] - Quote
i meant my mysql query. you see that you don't need an extra table for that. |
Nasai Duranis
Gallente Landscaping Corporation
0
|
Posted - 2014.07.08 04:00:00 -
[45] - Quote
Steve,
Many of the .csv files you have posted on https://www.fuzzwork.co.uk/dump/kronos-1.0-98534/ have a great deal of name fields surrounded in quotes. For example, this affects 16 counts of the SOLARSYSTEMNAME field in mapSolarSystems.csv.
These will not appear in Excel by default, but they will also not be trimmed by default when being imported to an SQL database.
I checked the Rubicon SDE, which still included the mapSolarSystems table, and does not surround any solar system names in quotes.
It looks like it affects all csv files with name fields, but only a subset of rows in each. Though admittedly I have not looked through all of them yet.
Regards, Nasai |
|
|
|
Pages: 1 [2] :: one page |
First page | Previous page | Next page | Last page |