Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Tuborg Uitoh
10
|
Posted - 2014.06.10 12:47:00 -
[1] - Quote
Hey
so IGÇÖm working a bit with the sql version off the static data dump IGÇÖm downloading the dump from fuzzwork but i'm not realy good at using SQL commands ...
So what IGÇÖm looking for is a SQL command That can list the following things
only t1 ships with type id ,name,some kinde off image identifier and if plosibel sortet bay market gruop larges ship first
|
Hel O'Ween
Men On A Mission
81
|
Posted - 2014.06.10 16:37:00 -
[2] - Quote
The "sort by largest ship" is too hard for me. Not sure if this is even possible without some hefty subqueries ..
Quote: SELECT t.typeID, t.groupID, t.typeName, t.raceID, t.marketGroupID, t.graphicID, g.groupName, r.raceName, m.marketGroupName marketGroupName, mp.marketGroupName marketParentGroupName FROM chrRaces AS r INNER JOIN invTypes AS t ON r.raceID = t.raceID INNER JOIN invGroups AS g ON t.groupID = g.groupID LEFT OUTER JOIN invMarketGroups AS m ON t.marketGroupID = m.marketGroupID LEFT JOIN invMarketGroups AS mp ON m.parentGroupID = mp.marketGroupID WHERE g.categoryID = 6 AND t.published = 1 ORDER BY mp.marketGroupName, m.marketGroupName, r.raceName, t.typeName
[Added]
Quote: i been traying to edit this sql command but can't get it working
For programmers, it's good practice to post what you've tried and possible error messages you've received. This spares those who are willing to help to go through all the failed tries you've already did. It's not that we know everything by heart ... EVEWalletAware - an offline wallet manager. |
Tuborg Uitoh
10
|
Posted - 2014.06.10 16:55:00 -
[3] - Quote
Thanks for the replay the sql command you send dosent work :( the colum t.graphicID dos not exist :( so I trayed removing that from the command witch gives me a list off ships that includes t2 witch is what i need to remove to the list so it only containes t1 ships
|
Rob Crowley
State War Academy
301
|
Posted - 2014.06.10 22:12:00 -
[4] - Quote
Adding to Hel's query:
Quote:SELECT t.typeID, t.groupID, t.typeName, t.raceID, t.marketGroupID, g.groupName, r.raceName, m.marketGroupName marketGroupName, mp.marketGroupName marketParentGroupName FROM chrRaces AS r INNER JOIN invTypes AS t ON r.raceID = t.raceID INNER JOIN invGroups AS g ON t.groupID = g.groupID LEFT OUTER JOIN invMarketGroups AS m ON t.marketGroupID = m.marketGroupID LEFT JOIN invMarketGroups AS mp ON m.parentGroupID = mp.marketGroupID JOIN dgmTypeAttributes AS ta ON t.typeID=ta.typeID WHERE g.categoryID = 6 AND t.published = 1 AND ta.attributeID=422 AND COALESCE(ta.valueInt,ta.valueFloat)=1 ORDER BY mp.marketGroupName, m.marketGroupName, r.raceName, t.typeName graphicID has been moved out of the SQL part of the SDE into the YAML part, so it's not supposed to be in there unless you add it back. |
Hel O'Ween
Men On A Mission
81
|
Posted - 2014.06.11 15:57:00 -
[5] - Quote
Adding to Rob's answer: use Desmond's import tool to import those missing columns/tables back into your database. EVEWalletAware - an offline wallet manager. |
Tuborg Uitoh
10
|
Posted - 2014.06.11 16:58:00 -
[6] - Quote
thanks :P
im traying to use the sql commands but i still se faction and priate ships in the thing is that i need only standart t1 ships to be listet |
Rob Crowley
State War Academy
301
|
Posted - 2014.06.12 14:31:00 -
[7] - Quote
Well, that's because faction ships (and modules) are technically T1. If you don't want those you have to filter by meta level:
Quote:SELECT t.typeID, t.groupID, t.typeName, t.raceID, t.marketGroupID, g.groupName, r.raceName, m.marketGroupName marketGroupName, mp.marketGroupName marketParentGroupName FROM chrRaces AS r INNER JOIN invTypes AS t ON r.raceID = t.raceID INNER JOIN invGroups AS g ON t.groupID = g.groupID LEFT OUTER JOIN invMarketGroups AS m ON t.marketGroupID = m.marketGroupID LEFT JOIN invMarketGroups AS mp ON m.parentGroupID = mp.marketGroupID JOIN dgmTypeAttributes AS ta ON t.typeID=ta.typeID WHERE g.categoryID = 6 AND t.published = 1 AND ta.attributeID=633 AND COALESCE(ta.valueInt,ta.valueFloat)=0 ORDER BY mp.marketGroupName, m.marketGroupName, r.raceName, t.typeName As a bonus you also get capital ships now, which for some silly reason don't have a tech level. |
Tuborg Uitoh
10
|
Posted - 2014.06.13 14:35:00 -
[8] - Quote
thanks alot goth it working :P
but will traying to get it working i ran into a few othere sql related questions ;)
is there any way i can get the bp typeid from the item typeid?? |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
3416
|
Posted - 2014.06.13 16:54:00 -
[9] - Quote
Tuborg Uitoh wrote:thanks alot goth it working :P
but will traying to get it working i ran into a few othere sql related questions ;)
is there any way i can get the bp typeid from the item typeid??
It's the producttypeid in invBlueprintTypes (for now, at least) Woo! CSM 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
Tuborg Uitoh
10
|
Posted - 2014.06.16 19:30:00 -
[10] - Quote
thanks alot for the replayed worked perfekt :P
any one that can tell me how i can determin if it's plosibel to see if an item is manufactureable |
|
Tuborg Uitoh
10
|
Posted - 2014.06.19 10:50:00 -
[11] - Quote
bump
still looking for a way to get grapichs detail into the sqllite db and a way to determin if an item is manufacture able |
Hel O'Ween
Men On A Mission
81
|
Posted - 2014.06.19 11:34:00 -
[12] - Quote
Tuborg Uitoh wrote:thanks alot for the replayed worked perfekt :P
any one that can tell me how i can determin if it's plosibel to see if an item is manufactureable
and i been looking at the tool to adding the ymal into db agien witch i can't get working :( any where i can download a sql version off the static data dump with every thing in it??
What didn't work? It's actually pretty straight forward. Off the top of my head (haven't installed it on this machine): edit the *,config with the credentials for your SQL server, copy the YAML and sqlite files to the appropriate folders (there are predefined folders, each holding a "put yaml/sqlite files here" kinde a file). EVEWalletAware - an offline wallet manager. |
Tuborg Uitoh
10
|
Posted - 2014.06.19 13:42:00 -
[13] - Quote
well i can't get the sql server installed that ccp recoment :( second i need the end result to be sqllite like i can download form fuzzworks and second i been traying to change the EVEMonSDEExternalsToSql.exe.config witch makes no sens but i been told that its this part i need to change
link to pastbin
just that i have no idear what to change and to what |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |